Has anyone come up with a neat way to update all document types at once on this?
Unfortunately in days gone by someone thought it would be great to put apostrophes in the file system naming which of cause the DMT process does not like so i am have to change those apostrophes with something else and then change the path to the correct path in File Attachment Path maintenance. I just seems labourious that you have to do it for every file type when ultimately it is only 10 to 20 paths that need to be amended in total.
Not quite following there.
Your upgrading from 9.05 to kinetic correct?
Your trying fix the apostrophes in the path of the file system attachments setup for current records?
The File attachment maintenance in kinetic allows you to select the option for all document types In classic, but it appears not in the kinetic UI by the looks.
Looks like another oversight for Classic compatibility issue, or perhaps usability. There was an idea for this, but it is expired Log In - Epicor Identity
Because it is a once off, and there is not functionality. I’d suggest an Epicor function to iterate through the tables to fix the problem…
ice.xfileref and ice.xfileattach are the ones you need to look at.
You could possibly do it with an updatable BAQ using the uplift from excel option also
Which file format did you try to use with DMT? Xlsx or csv. Apparently xlsx is a bit more forgiving, but your mileage may vary.
2 Likes
Hi Simon,
It allows you to select all the Document Types, however you can only amend the file path for one document type at a time.
When you click on the next file type you lose the Current and Targe Path Details
I tried it with both csv and xlsx
Cheers.
1 Like
Looks like your left with the function option.
1 Like