Forum Discussion
- _anomDiebolt_Qrew EliteI 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 - QuickBaseCoachDQrew CaptainThx 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.. - JeffKelly1Qrew MemberHave you had any luck with EDI files? I need to put quickbase data fields into 5010 files.
- _anomDiebolt_Qrew Elite@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. - JeffKelly1Qrew MemberThank 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.
- _anomDiebolt_Qrew EliteThe 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.