The List Import function can be used to import Lists from your HD, which could have originated from another Application or ESP.
The “Import” function automatically scrubbs the List removing any records where the Email Address is either of an invalid format, is blacklisted on our global blacklist (amongst other things could be it hard bounces) or is a Role Account as explained in http://setup.sendreach.com/lists-2/role-accounts-isp-terminology/
A new blank List has to be created first in your SendReach Account and the following Custom Fields are created by default:-
Date Added – (Not Editable) (System Field)
IP Address Used – (Not Editable) (System Field)
Status – (Unconfirmed – Confirmed – Unsubscribed – Blacklisted) (System Field)
You therefore need to open the List to be imported in Excel (or any Spreadsheet that can save in .csv format) and firstly delete any columns that are blank or contain data you do not require. Then ensure that the column titles on line one of the remaining columns match those above. You do not need to create blank columns to match those above if they do not already exist as the column already exists in the new blank List you created.
If your existing List includes columns not shown above where you do want to import taht data, then provided the column titles are acceptable (just text – no non-textual characters) the import function will add them to the List.
The function is accessible in Lists > Your List > Overview > Tools > View as below (the tiles on the Dashboard are no longer colored as below). As the Tools section as below is within List Overview you have to create the blank List first as above, then import the existing List into it.
Import a List – “Import” > “View” > “CSV” > “Browse” – then select csv file from your Hard Drive.
NOTE: Whilst there is a function to import from a .txt file, using a .csv format is far more reliable, whilst sql is only for those familiar with its use.
Use “Queue Import” for Lists with over 100k subscribers – which queues the import ready for actioning as it’s turn comes – might be a few hours depending on demand at the time.