CSV import

Ask the community
,
1

trying to import csv into database …

select file - approve field mapping - press the import - then i just get a spinning wheel
on the import screen and it never completes - no errors - just spins forever

any ideas? file format is a file i download from a duplicate database
edit and then upload to my backup database so format is consistent
i do it every week but now it doesnt work

website_ https://www.fascias-soffits.co.uk/

2

Hi Mark,

Can you please upload your CSV file ? (the one that you exported from the database and edit) and send the URL so we can inspect .

Best,
Sapir

3

here it is:

4

here it is:
https://www.dropbox.com/s/tqahnkiohhdk7bp/removee%20291118n1.csv?dl=0

5

any news on this please Sapir?

6

Hi Mark,

The CSV file is missing the field names , in order to fix the problem:
First, export the schema from the destination collection.
Second, add the relevant data to the correct fields, and try importing again.

Best,
Sapir

7

that is because I was trying it without field names , it doesnt work with or without field names
here is a file with field names :

please can you tell me why this function was working fine and is now broken

8

even if i export from the https://www.fascias-soffits.co.uk/ database and reimport the same file to the same database it doesnt work

9

Hi Mark,

Your file wasn’t be saved as CSV file.
After opening the file, export it as CSV, and then you should be able to import it to your database.
If you’re working with Mac it should be under the File tab:


Best,
Sapir

10

Please explain how this isnt a csv file? …

https://www.dropbox.com/s/zxso6affj4w0b50/removee%20291118.csv?dl=0

I dont understand it is a .csv file it is the same file format as what i download from wix database

11

Hi Mark,

I have created a “Test” database at your site and import the CSV file that you sent.
As you can see, the import succeed and all the data are presented at the database.
If the problem still continue, pleas upload a video that show your problem.
Here is an article that explain that.

Thanks,
Sapir

12

upload is working now - thank you for your help Sapir

13

Hi Sapir.

the upload is not working again, here is the sample file;
https://www.dropbox.com/s/gn7moncoc7bmjov/remove100119.csv?dl=0
here is the video of the failure - nothing happens when i click ‘next’ as you can see:

https://www.facebook.com/mark.valentine.9615/videos/739699376406087/

14

Hi Mark,

Can you please upload your CSV file ? (the one that you are trying to import in your video) and send the URL so we can inspect .

Best,
Sapir

15

HI Sapir, the url was posted in my last post, here it is again:
ttps://www.dropbox.com/s/gn7moncoc7bmjov/remove100119.csv?dl=0
thanks
Mark

16

Hi Mark,

I download the file and saved it as CSV file then I import it to a database and I didn’t get any problem.
Does it still doesn’t work?

Best,
Sapir

17

I can import into the ‘test2’ database but not the ‘Sales’ database - please advise - the fact that it works on work database and not another must indicate a problem i cannot rectify myself

18

Hi Mark,

Do you try to import an external CSV file to one of your database? or to export one of your collection to a CSV file and then import it again?

Thanks,
Sapir

19

@mark-valentine I just finished having the same issue. The problem is that you most likely have a hook on your Sales database in the data.js file, mine was the beforeUpdate webhook. Even though my hook was properly configured, it was giving me an issue importing for whatever reason, so I had to comment it out until after the import.
\