Skip to main content

Email Automated Batch

Overview

Email Automated Batch allows you to process multiple email addresses in one go. You simply upload a file (of a specific format) to an SFTP site which is then processed and made available for download.

Email validation will check each email address for authenticity and return one of the 6 result types suggesting corrections where appropriate.

Deployed as a daily or weekly process, Email Automated Batch will validate all new or incoming emails into your customer database.

Depending on the size of your file, the processing may take up to 24 hours to complete.

Uploading files

You can either upload files via a Windows FTP client or via UNIX command line.

I am using Windows

I am using UNIX

Downloading files

Read more about the output file specification and how to interpret the results.

Uploading files

When uploading files, there are file formatting requirements that must be adhered to. If these requirements are not met, the file will be rejected. 

Input requirements 

Ensure that these input requirements are met before proceeding.

 Uploaded files must be RFC 4180-compliant CSVs:

  • Commas are used to separate fields
  • DOS/Windows-style newline (CR+LF) is used to indicate end of a record
  • The last record may or may not be terminated
  • Double quotation marks are used to quote fields
  • Fields containing commas, newlines or double-quotation marks must be quoted
  • Otherwise, quoting is optional.

In addition to the above, a header row named 'email' (case-insensitive) is required.

Additional columns may be included and will be retained in the output, but they cannot be named as 'result' or 'correction'. The maximum file size is 2GB and the maximum record count is 1 million records.

You can either upload files via a Windows FTP client or via UNIX command line:

Windows FTP client

  1. Open your preferred SFTP client. We recommend Filezilla or PSFTP.
  2. Enter your connection information. Below is the required information to connect to our server:

    Host: sftp.qasemail.qas.com
    Port: 22
    Protocol: SFTP
    Username and Password: (password is your API key)

    All non-specified values should be left as the program’s default settings. 

    If you get a message asking whether you trust the host key provided by our servers, simply click OK to proceed. You can also select the checkbox to remember this decision.

  3. Once logged in, you will see two folders 'Incoming' and 'Outgoing':
  • 'Incoming': used to upload new jobs for processing. Simply drop the file into this directory as you would a normal file upload. Our system will begin processing the file.
    Note that if you upload a file that is not properly formatted, your files will be uploaded, but the job status will be ‘Failed’. Additionally, both Filezilla and PSFTP cache the file listings that they display. If you see something out of place, please refresh to get an up-to-date view of the system.
  • 'Outgoing': After a file has been successfully uploaded, processing will begin automatically. While the file is still being processed it will remain in the 'Incoming' folder. Once processing is complete, the file will appear in this folder. Copy this file to your local computer to view results.

UNIX command line

  1. Navigate to the directory of the file you would like to upload:
    cd /path/to/folder
  2. Connect to our SFTP server using the following command (replacing [user] with your username):
    sftp [user]@sftp.qasemail.qas.com
  3. Reply yes if you see the following message: The authenticity of host ‘sftp.qasemail.qas.com (167.107.82.46)’ can’t be established.

  4. Navigate to the incoming directory on the remote file system:
    cd incoming
  5. Upload your file:
    put filename.csv
  6. Once processing has finished you can download the results from the outgoing directory:
  7. cd Outgoing
    get filename.csv 

Downloading files

Once processing is complete, you can download the files and view the results.

Output specification

Output files will adhere to the same format as used for input but will contain additional fields named result and correction.

To simplify parsing (e.g. for direct, MS-SQL bulk import), every field will be quoted.

Corrections

Corrections may be provided if the submitted email address is incorrect. These are suggestions and may not relate to the person in your database.

Please get approval from your legal team/department before using these corrections.

These suggestions are not a guarantee that the email addresses are correct, nor that they can be used in any specific manner. They may, therefore, be emails you are not authorized to send to.

Expected processing time

You can expect your file to be validated within 24 hours (if less than 100,000 records) although the email addresses in the file will also determine performance. When processing has completed, the file will automatically be moved to the outgoing folder.

Managing files

Please take care when deleting files. 

Using the SFTP interface, you may delete files from both the incoming and outgoing folders using the standard SFTP delete functionality. However, please use this functionality with care as backups of your files are not made once the delete functionality has been used. If you delete by mistake, the file will need to be re-uploaded and you will be charged for it as a new file.

Deleting files from the incoming folder will result in the file processing being halted and all contents removed. All input fields and output results will be deleted and the file will not be available for view in the incoming folder or for download in the outgoing folder.

Deleting files from the outgoing folder will result in all data relating to this file being permanently removed from our platform and the file no longer being available for download.

Result types

CertaintyVerboseOutput*Description
verified verified Mailbox exists, is reachable, and not known to be illegitimate or disposable.

undeliverable

mailboxDisabled The user mailbox has been disabled.
mailboxDoesNotExist The user mailbox does not exist at this domain.
mailboxFull The user mailbox is full.
syntaxFailure The syntax of the email address is incorrect.

unreachable

unreachable The domain is not responding to validation requests or does not have any active mail servers.
unresolvable The domain cannot be resolved.

illegitimate

illegitimate Seed, spamtrap, black hole, technical role account or inactive domain.
roleAccount Role accounts such as support@, sales@, info@ .
typoDomain The domain was close to a common domain and although it exists, it is highly unlikely to be correct.
disposable disposable Domain is administered by a disposable email provider (e.g. Mailinator).

unknown

unknown We were unable to conclusively verify or invalidate this address.
timeout The request timed out due to the host domain not responding in time.
acceptAll The domain is accept-all, so the username cannot be validated.

* The VerboseOutput values might not be visible to you due to your configuration.

We recommend that you remove/fix email addresses that are undeliverable, unreachable, illegitimate or disposable.

Additional information on how to manage the result types can be provided by your account manager or the local support team.

 

 

Troubleshooting

SSL certificate errors
Your SSL certificate might have expired. To manually update your deployment:

  1. Get the files:
    Download ZIP
  2. Extract the files.
  3. Install Root.crt in the Trusted Root Certificates Authorities Store.
  4. Install the following files in the Intermediate Certificate Authorities Store:
    • Intermediate1.crt
    • Intermediate2.crt
  5. Install api.experianmarketingservices.com.cer in the Personal Certificate Store.
  6. For further help contact your local support team.


Authentication Failure
This usually happens due to typos in the supplied username/password. However, if you're confident that you are entering the right details, please contact your local support team.

Couldn't connect to server
If you encounter this message, please double-check the settings entered while uploading the file. If the problem still persists, please contact your local support team

Uploaded file is not in the 'Incoming' folder
This could be the result of a malformed file. Check your SFTP client’s message log for further information on why it was rejected. Additionally, if you have email notifications enabled you will receive an email with a description of the error.

Can't delete a file from the 'Incoming' folder
Once the file processing has begun, you will not be allowed to delete the file. If you believe the processing has completed and you still can't delete the file, please contact our support team.

Result file is not in the 'Outgoing' folder
This is likely to be due to a failed job. You should receive an email notification that containing a description of the error you've encountered.

Errors can be caused by files that:

    • are blank
    • have the Email header but no content
    • have a valid header row but it's not separated by a separator
    • have an invalid separator
    • have no Email header
    • have the same name as a file that's still being processed
    • exceeded 2GB file size
    • exceeded 1 million record count

How do I unlock my account?
The account lock was implemented for security purposes and occurs after too many failed login attempts. To unlock, please contact your local support team

How do I change my SFTP password?

  1. Log into the Self Service Portal and go to SFTP account.
  2. Click Change Password, enter a new password and save changes.
  3. Confirm that your new password has been updated in the FTP client/Unix command line.

What's the status of my upload?
An email notification will be sent to you when an upload has failed or when a file has completed processing. Here are the reasons that can cause the processing job to fail:

ReasonDescription
Maximum file size exceeded  Ensure the file does not exceed 2GB.
Exceeds maximum record size  Ensure the number of records does not exceed 1 million.
No valid data row found  Potential issues:
  • Blank file submitted
  • File has a header row but no content
  • Emails are not separated by commas
Email column not found The 'email column header was not found.
There were some error(s) processing the job Can be caused by an internal exception error.
Please try resubmitting the file or contact our support team if the problem still exists.
Insufficient Credit Your account is running out of credits. Please contact your account manager for more information.
License Disabled  Your license has been disabled. Please contact your account manager for more information.

What are the downtime procedures?
The processing platform may occasionally be unavailable due to maintenance. Your account manager will notify you in advance of any scheduled maintenance periods.

How do I manage clicks, credentials, and reporting?
Please contact your account manager or the local support team for more information.