Normally when I file input element is on a form the user selects a file from their local file system and when the form is submitted the file is sent
unmodified to the server. In your case you want to parse and manipulate the selected file and send the modified contents to multiple tables. This can be done in JavaScript using a feature called a
FileReader. In a nutshell, after a file is selected and the
FileReader objectis created the
CSV contents would be parsed into an array. Next, portions of this array are selected in sent to QuickBase using
API_ImportFromCSV.
When calling
API_ImportFromCSV you would specify the parameter
clist_output to obtain the
[Record ID#] and other fields from the newly created records. Knowing the
[Record ID#] of the newly created records allows you to import secondary and tertiary data to other tables and relate them appropriately.
The key to this whole procedure is using the
FileReader object and the
clist_output parameter.
Unfortunately I can't create a generic demo of this process as it depends on a lot of small details of your tables, fields and the precise format of the CSV file being used. If you want to pursue a solution feel free to contact me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt
