By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
I am trying to build an import scenario where the import file is a .txt file that is pipe-delimited with no header row.
I have build a data provider using a .CSV provider type with a filename with a .txt extension and a default delimiter of |. Note that I used a .CSV file first to populate the schema fields - I have used this method successfully to create a .txt export scenario / file so I expect it should work for import.
I have created an import scenario but when I upload a file and try to prepare the import, I get no data found and an error saying Sequence Contains no Elements.
Has anybody managed to build an import scenario like this? I am constrained by the ability of the source system in terms of the file format.
Once I have got past this hurdle, I still have to figure out how to update a Shipment with both lot and package data - but that may be for another post.
Thanks in Advance... John
I think lack of header record is your issue - it's required AFAIK.
You can add a header record with a command script and possibly replace the pipes with commas if needed. Do this before running the import.
Online Members
