Use FTP to upload multiple lists at a time or large lists. You can use any standard FTP client, such as FileZilla, CuteFTP, or the FTP client built into Windows Explorer.
Prepare your File:
- The file can be of any extension, including .CSV, .DAT, and .TXT.
- Specify row delimiter, column delimiter, text qualifier and other options under Settings --> List Management --> FTP List Import Handling.
- Your file should not have the following column names: confirmed, modified, memberID, uniqueident, submission_date, and email_id. These are JangoMail-reserved words. Files containing these field names may be re-named in the list that is created or the file may not process at all. If the file does not process, an email notification of the error will be sent.
- 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 occurrence of an email address in your data file, and will assume this is the column containing email addresses.
Connect to FTP:
-
Point your FTP client to ftp://client.jangomail.com/ or connect via secure FTPS by using ftps://client.jangomail.com/ on port 990. For non-secure, use ftp://client.jangomail.com and port 21.
-
Use your primary JangoMail username and password for login credentials.
-
Once logged in, drag your import file to the GroupImportsAutoFTP folder.
-
We will send an email notification when the file is detected by JangoMail, and another email notification when the file is done importing.
Notes:
- 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.
- 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 occurrence of an email address in your data file, and will assume this is the column containing email addresses.
- Column names in your file will be translated into corresponding field names. 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 names.
- This feature is foreign language compliant, so you may FTP Unicode files.
- 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.
Comments
0 comments
Article is closed for comments.