Forum Discussion
_anomDiebolt_
8 years agoQrew 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.
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.