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

On Duplicates
  • Vote Up0Vote Down shadowshadow
    Posts: 15Sendy user
    Hi Ben, just to check if there are duplicates in a list when importing, will sendy detect that and only import one of the duplicate records?
    If yes, may I know if it's taking the First row of the duplicate records or the Last row of the duplicate records as the final one.

    Also, if sendy does detect duplicate, I believe that there's a problem with importing. When I import the same list twice, the number of subscribers in my list increase.

    If no duplicate detection, it might be good to consider having this =)

    Thank you.
  • 3 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support
    Sendy detects duplicate emails of course.

    When you import a CSV, it imports the first row all the way down to the last. With each iteration, it checks the database to see if the same email exists in the list.

    Sendy also checks for invalid emails or if the email was already marked as bounced in the list and won't import them.

    Finally, it doesn't matter if you have the first 'title' row or not.
  • Vote Up0Vote Down shadowshadow
    Posts: 15Sendy user
    Hi Ben, in that case I am having a weird problem with importing.
    I imported the same csv file twice and the number of subscribers increased on my second import.

    also, my question on the first row and last row actually refers to something like this

    Say my csv contains the following record
    A, user@email.com
    B, user@email.com
    C, user@email.com

    When importing, will sendy do

    A, user@email.com [no duplicate, stored]
    B, user@email.com [duplicate, skipped]
    C, user@email.com [duplicate, skipped]

    or

    A, user@email.com [no duplicate, stored]
    B, user@email.com [duplicate, update name]
    C, user@email.com [duplicate, update name]

    Thank you
  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support
    Sendy will do this:

    A, user@email.com [no duplicate, stored]
    B, user@email.com [duplicate, skipped]
    C, user@email.com [duplicate, skipped]
This discussion has been closed.
All Discussions