This feature allows you to import data files which are too large to upload from your browser. The normal import process does not allow an import of a data file size bigger than 150MB, so an FTP upload is used to overcome this limitation.

  1. To find your sFTP login credentials, move your mouse cursor over your account name and click “Connections”.

  2. Click on the SFTP Access tab. You will see the following details required to setup the FTP upload: Host, server address, username, password, and port.Snip20150813_13

  3. Enter the login credentials to any FTP client that you chose to use.  Once you’ve logged in, you’ll noticed that your default root FTP folder is “Uploads”. From this root folder, you can create any sub-folders and place your data files there.
    • Maropost Marketing Cloud supports any text file with .csv or .txt file extension.
    • Your file can use either a comma, tab, colon, or semi-colon as the field delimiter.
    • The first row of the file must be the header row.
  4. From the Contacts screen, click the “Import” link for the list whose contacts data file you wish to import.Import 1
  5. When the Import Contacts modal opens, click the “FTP import” tab.

    import_contacts

    • Select the name of the file that you’ve uploaded to the FTP folder.
    • Select the field delimiter that is used in the file.
    • Click the [Next] button to upload the file to the buffer.
  6. Once the upload is complete, you will be shown the contact mapping page. Map the fields in the import file to the standard and custom fields in your Contacts database.

    Mapping

    • Choose the option to import new contacts (checked by default)
    • Choose the option to update existing contacts (checked by default)
    • Choose the option to not trigger workflow campaigns (checked by default).  This option only applies to workflows using a “New Subscription” trigger widget and this list is selected in the trigger.  If selected, then contacts included in the data file will not enter any of the workflows.
  7. Click the [Import] button to initiate the import.
  8. Check the Notifications center to follow the status of the import.  You’ll be notified when the import has finished.
    notifications

    • The notification will inform you of the total records imported, total contact records subscribed to the list, total contact records unsubscribed from the list, total number of bad email addresses and total duplicated email addresses.
    • A “bad email address” is any address that fails the basic syntax validation for an email address, or one whose domain is that of a known spammer.
    • You will be able to download a file of the bad email addresses that includes the email address and why it was flagged as “bad.”