Is there a way in QuickBase to generate EDI files?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Is it possible? It is my undertansing that I need a EDI Network Provider but that is a different story. Any help will be appreciated.

Photo of Chary

Chary

  • 0 Points

Posted 4 years ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,904 Points 20k badge 2x thumb
While there is no explicit support for EDI files in QuickBase using script you can generate files dynamically and have them save to your local computer automatically and with the correct name. Most people think files have to be created elsewhere and uploaded into QuickBase but you can create files dynamically (both text and binary files) using features in HTML5 enabled browsers.

To be specific regarding EDI files here is a cxml file extracted from some documentation my local grocery store (Kroger) provides:

http://pastie.org/10421436


There are possibly hundreds of data elements in this file. If you had all tables that contained all of those data fields you could write a script that on the click of a button used the QuickBase API to gather all the raw data and compose a "string" (through concatenation or using a template library) and save it to a file. Using the script in this pastie you can write an arbitrary string to a text file automatically and save it with the correct name:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=355


It might be a bit of work tracing down each data element and formatting it correctly as you might have to query several QuickBase tables using the API but it is just repetitive task not a complex one.

The big takeaway for other readers who are not interested in EDI files specifically is that any file can be generated dynamically with script from data stored in QuickBase tables. For example, vCard or hCard files can be generated from QuickBase data which contain any properties or features supported by those technologies. Likewise XML, JSON, CSV etc files can be generated dynamically from data within QuickBase.