I want to upload a csv file to retool and then display the csv in a table in the front end tool. If the user is satisfied, they will click on a button called 'upload' which will insert this data into a backend table. do I need to write a JS Transformer? ChatGPT is not providing any help. I am using PostgreSQL and VS Code for my backend management.
Example:
My backend table is called test_data, and the columns are column1, column2 and column3. my csv file have the same exact columns.
You'll want to use one of the File Components to select a CSV file and upload it as well as get the base64 string for the file before and after uploading. Then you'll use the PapaParse
library that comes pre-installed for you which can take can take CSV (as a file or string) and turn it into a JSON object that the Retool Table Component is able to understand. I'd then suggest taking whatever PapaParse spits out and assigning it to a variable.... then you can set the table data source to this variable. This sets you up for uploading and displaying a CSV file. You can trigger a DB Query based on if the variable's value changes, letting you do an upsert to your DB which will link the Retool Table to your DB Table
Let me know if you need more direction/help and I'll see what I can come up with (or I'm sure someone will)
I have been trying that and I am unable to get the data from the csv file to match the columns in the backend table
hmmmm, well I normally like to start at the beginning of a process to figure out what's going on so I guess that would be the CSV file.
does your CSV file have a header line with all the column names on the 1st line? or do you need to handle the situation where the CSV file may or may not have the header line?
The csv file will always have a header line