Skip to main content
Question

Does anyone know of a good conversion tool to convert transportation related EDI formatted files to CSV format?

  • November 1, 2016
  • 0 replies
  • 70 views

 I'm talking about what they call 210's and 310 and 315's.  I'm looking to receive these from transportation carriers (like ocean container forwarders), convert them to CSV format and then coax them into  Dropbox to Sync into QuickBase?

  • Registered
  • November 1, 2016
I think you are going to find that your EDI data is hierarchical and cannot be converted to a flat CSV file unless you are interested in one small subset of data. Since your client is undoubtedly already using EDI data in their workflow they may have a requirement or expectation of what data they want to manipulate in QuickBase. Perhaps this understanding of the desired QuickBase schema will help you understand the mapping between the EDI files and QuickBase table/fields.

This website has information on conversion tools involving EDI data:

http://www.xtranslator.com/index.html

Thx Dan,

Interestingly I found that same hit when I googled.  I'm on the search for a tool (maybe that is the one) which can accept a file which maybe the carrier places in a dropbox, translates it to CSV and push it into a dropbox for QuickBase to pick up..

  • Registered
  • March 29, 2018
Have you had any luck with EDI files? I need to put quickbase data fields into 5010 files.

  • Registered
  • March 29, 2018
@Jeff - I think the original question wanted to get data in EDI format converted to CSV and then imported into QuickBase. Your question seems to want to take data in QuickBase and generate the 5010 EFI file. Am I correct?

If you have all the data in QuickBase (you may not have every drop of data required) you could use a custom script or a perhaps an existing library to generate the required format:

5010 File Format
http://support.mdsco.com/md-solutions-support/tutorials/ansi-5010-claim-format

There are some existing Node libraries that can manipulate EDI files which can be used in the browser using Browserfy

Node EDI Modules
https://www.npmjs.com/search?q=keywords:edi

Browserify
http://browserify.org/

This would take a detailed evaluation but the bottom line is that if you have all the constituent data in QuickBase tables script can be used to generate appropriate 5010 file. But as I said you must have all the data in QuickBase and understand precisely where this data goes in the 5010 file. Also, there might be variants of data or transactions that goes into the the file that you have to completely understand. 

  • Registered
  • March 29, 2018
Thank you for the information, that would be my first step, although I believe the original question would be helpful for me to bring EDI responses back to quickbase as well.