Skip to content

On Duplicates

edited November 2012 in Questions
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.

Comments

  • BenBen
    edited November 2012
    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.
  • 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
  • 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.