We are trying to change the Approval status on many part revisions through DMT. One of the required fields is AltMethod. None of our revisions have any AltMethods. Every time I try to run the file through I get an “AltMethod Input String was not in the correct format error”. I have tried leaving the field blank, putting a space in the field, double quotes, single quotes, double quotes with a space in them, and single quotes with a space. Does anyone have any idea what format this field may be looking for?
What if you try the current revision letter (the only method)?
edit : this isn’t the right answer in case someone else see this!
Try 0
I tried it with an empty string and in the CSV (just left if blank in excel and saved as CSV) and it worked fine.
This is what the CSV looked like.
Company,PartNum,RevisionNum,Approved,AltMethod
RAPAT,000-1-0094,A,TRUE,
edit : I also set the checkboxes to update and removed the add new. Maybe it makes a difference?
That is very odd. What fields are you using? I’m only using the required ones:Company, PartNum, RevisionNum, Approved, ApprovedDate, AltMethod, RevShortDesc.
Approved date isn’t required, and actually says isn’t maintainable by the user. Try moving the AltMethod to the end.
Can you look at your CSV with something like notepad++? Maybe paste the first couple lines in here.
It worked when the Add New checkbox was unchecked. Strange. Thanks for the help.
1 Like