Page 1 of 1

Error importing CSV of duplicates

Posted: Mon Mar 21, 2011 10:30 pm
by kihilind
I exported a list of ~5,000 duplicates, marked the first column as "1" if it's a duplicate, and then tried to import the CSV. Each time I got an error: "Index was outside the bounds of the array". That doesn't make sense because all I did was: 1) export dup list to CSV, 2) change the value in the first column from 0 to 1 if it was a duplicate, and 3) import the CSV. Why the error?

Posted: Thu Mar 24, 2011 7:46 pm
by DV
Make sure you export the fields as having double quotes round them (if using excel, etc), else it might choke on reimporting fields with commas in.