import csv error

Topic: import csv error (Read 2661 times) previous topic - next topic

import csv error

October 17, 2019, 09:58:50 AM

Hi,
i have this problem whe i import data csv, where am I wrong?

Re: import csv error

Reply #1 – October 17, 2019, 10:48:42 AM

@Domenico‍ Make sure the number of columns on the CSV file is equal to the number of columns in the database table, without adding the id column.

you can also go through this thread👉 https://phprad.com/forum/index.php?topic=487.0 to find a video posted for making such operation.

Re: import csv error

Reply #2 – October 17, 2019, 11:18:49 AM

Ok,solved.
and if i want to update existing records?

Re: import csv error

Reply #3 – October 17, 2019, 11:23:51 AM

@Domenico‍ you have to edit the record using the application, you cant update record using import.

Re: import csv error

Reply #4 – October 17, 2019, 12:13:11 PM

ok

and how can I avoid duplicates?

Re: import csv error

Reply #5 – October 17, 2019, 03:39:12 PM

@Domenico‍ Do you mean, when you are importing CSV records?

Re: import csv error

Reply #6 – October 20, 2019, 07:46:09 PM

Let the database handle it. Be sure to include the SAME index key for records which are duplicate, or only export distinct rows to your CSV file.

Quote from: Domenico – October 17, 2019, 12:13:11 PM

ok

and how can I avoid duplicates?