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