Sendy Forum

Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

In this Discussion

Problems importing contacts via CSV
  • Vote Up0Vote Down poliukpoliuk
    Posts: 22Sendy user
    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. :(
  • 8 Comments
  • Vote Up0Vote Down poliukpoliuk
    Posts: 22Sendy user
    i've continued investigating. One of the problems is the final comma after email. But when i upload large csv only half of the contacts are processed by sendy, the others are ignored.
  • Vote Up0Vote Down poliukpoliuk
    Posts: 22Sendy user
    I've found the error.

    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
  • Vote Up0Vote Down BenBen
    Posts: 3,607Sendy support
    To answer your original question. 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.

    image

    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?
  • Vote Up0Vote Down poliukpoliuk
    Posts: 22Sendy user
    I've done some tests and in a list formed by emails with that pattern only the first email is being uploaded (either via CSV or FORM). So is not "the half of the emails".


    I've downgraded my sendy to the previous version and now it works fine. The CSVs has 50kb (around 1000 rows).
  • Vote Up0Vote Down BenBen
    Posts: 3,607Sendy support
    Can you please send me the CSV (to: hello at sendy.co) so that I can test it on my side? Thanks.
  • Vote Up0Vote Down poliukpoliuk
    Posts: 22Sendy user
    Im sorry, it's private data and i cannot share it :(

    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
  • Vote Up0Vote Down BenBen
    Posts: 3,607Sendy support
    I understand. :)

    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:

    image
  • Vote Up0Vote Down poliukpoliuk
    Posts: 22Sendy user
    I've upgraded again to 1.10, tried this and it seems that it works... wierd, but a local problem ;)
This discussion has been closed.
All Discussions