Choose to not import empty rows

Ask the community
1

I have columns where there are 50 rows with data and when importing is will import all rows available in the csv file, no matter which column I choose. Can it be some checkbox not to import empty cells?

726×558 13.3 KB

#import #datacollection

3 Likes
2

Hi Andreas,

have you found a solution for that problem so far?

At this time, import and export is totally unuseful for me. For some reasons (mainly images) i can’t export and import the whole database. I only need partial import, so that import will insert colums that ‘‘fulfill’’ the database, and not in addition; number of total row has to stay the same

3

I would also love to get an answer about this.
I have a file with content of 170 rows but the import brings in 998 rows.
If I don’t delete these empty rows from the DB the dynamic pages present all this empty content.
Please help

803×597 17.4 KB

4

I had the same problem with my CSV file, but I have solved it. I think the problem came from the file I have uploaded after some edits (from someone else maybe) and there is something wrong with it.
So You can try this:

  • Create a brand new worksheet (excel file), then copy the content from CSV file to this excel file.
  • Save the excel file as CSV file
  • From Wix, add a new collection database and import the new CSV file

Let me know if it works for you