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!

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,823Sendy support
  • 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,823Sendy support
  • 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,823Sendy support
  • 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