A while back, we started having to deal with EDI files in Ecometry for Fright Catalog. We started charging for our catalog and wanted a third party to ship them for us. Unfortunately, the third party couldn’t handle EDI files, they needed a CSV file and annoyingly, Ecometry’s software couldn’t do it for us. Not wanting to create a CSV file for this by hand, I created a C# console application (requires the Microsoft .NET 2.0 Framework) to parse these EDI files for me into a CSV file. It will output the following:
- Customer Number
- Company Name
- Title
- First Name
- Middle Initial
- Last Name
- Address 1, Address 2, Address 3
- City
- State
- Postal Code
- Country
This was great, until it came time to processes these orders. Now I needed to generate a ship confirm batch file as specified in the Ecometry 7.x documentation. Not wanting to do this by hand either (especially since I’d need to do this on a regular basis) and being a fan of the DRY (Dont’ Repeat Yourself) principal, I extended my little utility to create Ship Confirm Batch files for Format 256. Other formats might be supported later, contact me if you need them, maybe I can help.
So now I have a cool application that will parse these EDI files for me in the formats I need. If you’re interested in getting your hands on it for your own use, I have a download available with the executable. Let me know if you have any issues with it or want to see some new features.