Skip to main content

Email Validate (Bulk)

Overview

Before using this product, you have to activate your SFTP account using the Self Service Portal.

Activate Your SFTP Account

  1. Log in to the Self Service Portal.
  2. Go to Products and click Activate SFTP account.
  3. Enter your SFTP username and password.
    The maximum length for the username is 20 characters. The following special characters are not allowed " [ ] : ; | = + * ? < > / \ , @

You can now log into the Windows FTP client or use UNIX command line.

Email Validate bulk mode 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 addresses for authenticity and return one of the 6 result types and suggesting corrections where appropriate.

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

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

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.

Windows FTP client

  1. Ensure your account has been activated.

    Activate Your SFTP Account

    1. Log in to the Self Service Portal.
    2. Go to Products and click Activate SFTP account.
    3. Enter your SFTP username and password.
      The maximum length for the username is 20 characters. The following special characters are not allowed " [ ] : ; | = + * ? < > / \ , @
  2. Open your preferred SFTP client. We recommend Filezilla or PSFTP.
  3. Enter your connection information. Below is the required information to connect to our server:

    Host: files.experianmarketingservices.com
    Port: 22
    Protocol: SFTP
    Username and Password:

  4. Once logged in, you will see two folders 'Incoming' and 'Outgoing'.
    1. '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.
    2. '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. Ensure your account has been activated.

    Activate Your SFTP Account

    1. Log in to the Self Service Portal.
    2. Go to Products and click Activate SFTP account.
    3. Enter your SFTP username and password.
      The maximum length for the username is 20 characters. The following special characters are not allowed " [ ] : ; | = + * ? < > / \ , @
  2. Navigate to the directory of the file you would like to upload:
    cd /path/to/folder
  3. Connect to our SFTP server using the following command:
    open files.experianmarketingservices.com
  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:
    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.

Result types

CertaintyDescription
verified Mailbox exists, is reachable, and not known to be illegitimate or disposable.

undeliverable

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

unreachable

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

illegitimate

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

unknown

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

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 our support team.

Troubleshooting

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 our 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 our support team.

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 our 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 for more information.

Copyright ©, 2014-2017. All rights reserved.