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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

 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?

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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..
Photo of Jeff

Jeff

  • 186 Points 100 badge 2x thumb
Have you had any luck with EDI files? I need to put quickbase data fields into 5010 files.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
@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. 
Photo of Jeff

Jeff

  • 186 Points 100 badge 2x thumb
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.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,964 Points 20k badge 2x thumb
The process of parsing an EFI file can also be done with script. In the past all a browser could do with a text file is send it to the server. Nowadays it is easy to select a file from the users local computer, read the the file and parse it and send the parsed information to the server (QuickBase). 

But again you have to pay attention to every piece of data involved in the process in terms of both input and output.