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

Import list/add subscribers
  • Vote Up0Vote Down alessioalessio
    Posts: 4Sendy user
    Import allows you to import email incorrect and duplicate. It 'easy to fix
    I would also ask if the campaign will be sent to two identical email or the program notice me has already been sent and send only one email.
  • 3 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support
    Hi, importing does check for duplicates though.

    When sending, Sendy checks if email appears in multiple lists and only sends to one if so.
  • Vote Up0Vote Down alessioalessio
    Posts: 4Sendy user
    line-update.php don't check duplicate and don't check valid email
    edit: sorry line-update.php check duplicate but don't work

    import-update.php don't check valid email
    :-)

    Suggestion:
    1) add LIMIT 1 to select query
    2) add index to email (and other field you use in select) in subscribers table
    3) check 2 query in import-update
    $q = 'SELECT email from subscribers WHERE (email = "'.$linearray[0].'" || email = " '.$linearray[1].'" || email = "'.$linearray[1].'") AND bounced = 1';
    --- || email = "'.$linearray[1].'" is duplicate and slow query
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support
    "edit: sorry line-update.php check duplicate but don't work"
    Sorry but when I import emails per line, it does check for duplicates. I just tested. I purposely imported an email that exists in the list and it was not imported.

    Thanks for your suggestions.
    If we use LIMIT 1, the script will only import 1 subscriber no matter how many exists in the CSV.
    Lastly, thanks for spotting the 'duplicate condition'! :) Will remove it.
This discussion has been closed.
All Discussions