Problems importing contacts via CSV
Hi there,
I'm having problems importing a new list of users using the CSV feature.
I think that i've problems with the format of the CSV file. Can you help me with this?
The file im using is built like this (i've copied the format from a CSV downloaded through your export button):
Name,email,\n
And the error im getting is:
Number of columns in CSV does not match CSV format example (as shown below).
I've also tried to upload directly a CSV downloaded from sending and i get the same error.
I'm having problems importing a new list of users using the CSV feature.
I think that i've problems with the format of the CSV file. Can you help me with this?
The file im using is built like this (i've copied the format from a CSV downloaded through your export button):
Name,email,\n
And the error im getting is:
Number of columns in CSV does not match CSV format example (as shown below).
I've also tried to upload directly a CSV downloaded from sending and i get the same error.
This discussion has been closed.
Comments
Sendy is deleting email with this pattern:
a.xxxx@emailA.com a.yyyy@emailB.com Sendy thinks that all the emails started with "a." are the same. Downgrading to 1.08 :S
Name,email,\n
is 3 columns because there are 2 commas. The format example you saw shows 2 columns, Name and Email. If you try to import the 3 column CSV, you'll get an error.With regards to your second question:
"when i upload large csv only half of the contacts are processed by sendy, the others are ignored."
and
"a.xxxx@emailA.com a.yyyy@emailB.com Sendy thinks that all the emails started with "a." are the same."
I tried uploading a CSV with a.xxxx@emailA.com and a.yyyy@emailB.com, they both appeared in my list (see screenshot below). Sendy does not think that any emails starting with the same alphabet are the same.
I'm not sure how large your CSV is, if only half your subscribers are uploaded, that may mean the server stopped executing the script because the CSV is too large. You may want to split your CSV into multiple chunks and upload them. How big is your CSV in terms of megabytes?
I've downgraded my sendy to the previous version and now it works fine. The CSVs has 50kb (around 1000 rows).
But i can show you the emails with a little change so you see the pattern of the emails:
Name,a.agXXXar@daiYYYYYysler.com
Name,a.araXXXru@roYYYYco.com
Name,a.buXXXs@peteYYYYYYning.com
Name,a.gXXXn@baYYYYYYYlo.com
Name,a.jimXXXz@hotYYYYYton.com
These emails are 3 columns (notice the comma on the right of each line)? Could it be some lines in your CSV have an extra comma on the right resulting in 3 columns and some does not? As a result these emails aren't imported.
I imported these emails after removing the comma on the right of each line and everything was imported: