I conducted quick testing for New Action of “Import CSV file” as it seems to be functional right now.
I save the CSV file (made out of Excel) and saved to local. This CSV have first row with exactly same names of column against the target table
This is observation so far.
Add new row
It works. Make sure to add “unique value explicitly” on the csv file otherwise this action wont add new rows (for rows missing the key value)
Even we have initial value set and leaving the value in cells for key field in CSV as null/blank, action will not upload rows. Suggest to Appsheet dev team to review their code to let the action add new row even missing the cell key value while we have initial value set on the column definition on appsheet editor.
Update existing row
If the value in key field in CSV matches the one in existing data key value, then the uploaded rows from CSV will update the existing row. Lovely
- Key value missing
See comment in 1). If we miss the value for key, either existing or new, this new action will not add new rows.
- Data type mis-match
For instance, we have number type on Appsheet editor, but we have text value for that field in CSV, upload csv seems to be failing. Meaning nothing is going to happen is data type mismatch is detected.
- CSV file type sensitive?
Save in the format of CSV UTF-8, and upload to Appsheet, it works. Other CSV file MS DOC does not work.
Those were the results of quick test withe super simple use cases . Hope other community member will add something new findings.