Importing CSV Files

Resources & Tutorials
1

We have a completely new resource document for importing CSV files to your database! (Also known as bulk record upload).

4 Likes
2

Love the comprehensive documentation - really, really great.

However, I canā€™t seem to get the demo app/csv file to work at all :frowning: Is there a broader issue with CSV thatā€™s potentially the issue?

3

Not that Iā€™m aware of, but we have had a few reports of some users getting an error when trying to import even 1 column files. Could you try in a different browser and let me know if you see any improvement?

4

Iā€™m trying to import from a CSV, the ā€œSelect a Fileā€ button does not reveal any of the csv files on my computer. If I change ā€œcustomā€ file search to ā€œall filesā€ and select my csv file, nothing happens. The import animation just spins and spins. Any help would be appreciated.

1 Like
5

UPDATE: On a hunch, I changed the file extension of my file to txt and the import worked.

6

Thatā€™s quite interesting - what browser and OS are you on?

7

I am facing same issue last time but no response from anyone an couldnā€™t find the topic troubleshooting in google.

www.myaarpmedicare.com

8

Hello,

Do you know if itā€™s possible to enable users on the app to upload a csv file for a bulk upload of inventory?

9

Unfortunately this is isnā€™t really possible just with Adalo itself, but it could be possible by building out something in Integromat or another automation service. Basically they upload the file with the correct column formats which fires your workflow, then the workflow iterates over the rows in the spreadsheet and adds each one to your collection in Adalo.

10

Iā€™ve given it a shot with both integromat and zapier using easycv but Iā€™ll be honest Iā€™m having a lot of trouble figuring out the correct workflow. Thank you though! Iā€™ll keep working at it.

11

@adalouser500 I found that the issue was if there are duplicate records it doesnā€™t upload

12

Hi Helen,

Would you elaborating a bit more ? Iā€™d love to learn how you got to that conclusion.

13

Ciao,
confirmed. CSV does not work.
I renamed the file to .txt and I replace with search and change the ā€˜;ā€™ to ā€˜,ā€™. At this point the import occurs correctly.