Tuesday, April 14, 2009

New Feature: FTP your List import files

You can now FTP files to client.jangomail.com/GroupImportsAutoFTP/ and those files will automatically be processed and imported into a JangoMail List.

You may use any standard FTP client, such as FileZilla, CuteFTP, or even the FTP built into Internet Explorer.

The above screenshot uses the Windows Explorer built-in FTP utility to transfer the file Data.csv to JangoMail. In this example, if an Email List named "Data" already exists, then the email addresses will be imported into this List. Otherwise an Email List named "Data" will be created automatically.

FTP to client.jangomail.com using your JangoMail username and password, switch to the GroupImportsAutoFTP folder, and place any data file there. The file can be of any extension (.csv, .dat, .txt, or anything else), and you can set the row delimiter, column delimiter, text qualifier and other options under Settings --> List Management --> FTP List Import Handling.

Some technical notes about how the FTP List Import feature works:
  1. JangoMail will examine your file name, and if a corresponding List exists, then the data in that file will be imported into that List. If a corresponding List does NOT exist, then a new List will be created. The name of the list will be based on the name of the file, but non-alphanumeric characters will be removed.
  2. If your file has column names in the first row, those column names will be translated into appropriate List Fields. If your file does NOT have column names in its first row, then field names will be created following this scheme: Field1, Field2, Field3, etc. After the import is complete, you can change these field names to more meaningul names.
  3. If your file has column names in the first row, JangoMail will look for a column called "Email" or "Email Address", or similar derivations, such as "E-mail" or "E-mail Address". It will be assumed that this column contains the actual email addresses. If your file does NOT have column names in the first row, JangoMail will look for the first occurence of an email address in your data file, and will assume this is the column containing email addresses.
  4. Your file should not have the following field names: confirmed, modified, memberID, uniqueident, submission_date, and email_id. These are JangoMail-reserved words, and files containing these field names may have the fields automatically re-named to something else in the actual JangoMail List that is created, or the file may not process correctly at all, in which case an error email notification will be sent.
  5. This feature is foreign language compliant, so you may FTP Unicode files.
  6. You may also use a secure FTP client to transfer files.
  7. You will receive one email notification when the file is actually detected by JangoMail, and you will receive another email notification when the file is done importing and the data is in your List
  8. If you FTP a file, and that file name corresponds to an existing List, and the file does NOT have column names, the file will NOT be imported, and you will receive an email notifying you of the error.