FTP Instruction Guide

From $1

    Overview

    ExactTarget offers the following advanced options for using FTP to import your large subscriber data files into a subscriber list:

    • The basic FTP option allows you to upload files to our FTP site and import them through the ExactTarget application's Import Subscriber wizard.
    • The encrypted FTP option allows you to use encrypted import files for greater security.
    • The enhanced FTP option provides the greatest level of security, as it gives your organization its own FTP directory.

    Please contact your ExactTarget account manager if would like to enable any of these FTP options for your account.

    If your organization uses the ExactTarget API, see also the ExactTarget API documentation for information about using the FTP site with certain API calls.

    About FTP Security and Site Clean-Up

    All users who log in to the ExactTarget FTP site have limited write permissions only. An existing file on the site cannot be overwritten, and the list of files on the site cannot be viewed by anyone who logs in.

    The ExactTarget FTP site uses FTP with SSL (explicit encryption) on port 21. Using your browser to access FTP sites will not provide a secure connection. ExactTarget recommends that you use a third-party FTP utility to access the FTP.

    Your import file is removed from the FTP site immediately after it is imported. A periodic clean-up is scheduled to remove files that have not been used over a period of time. Please contact ExactTarget Support if you have questions.

    File Requirements

    The following sections detail the requirements for filenames, file formats, and encryption.

    See the help topic entitled "Importing Subscribers into a List."

    Filename Requirements

    The name of each file that you upload to the ExactTarget FTP site must contain either your ExactTarget member ID or your company name to ensure its uniqueness.

    Additionally, the filename must not contain any characters that are restricted by Microsoft Windows. The following characters must not appear in your filenames: 
    \ / : * < > | ? "

    Format Requirements

    Your import file must meet the following requirements:

    • Format: When you create the file of subscriber data to be imported into the application, you must save it as a tab-delimited TXT file or a comma-delimited CSV file. (Many applications offer these formats as "save as" options.)
    • Header row: A header row (a row at the top of the file labeling the columns in the file) is recommended for mapping purposes. If the labels in the header row exactly match the names of the attributes in your account, the application will be able to map the data for you by default.
    • Attribute data type: If you're importing subscriber attributes, the data in the import file must be of the same data type (text, date, or numeric) as the attribute field in the application.
    • Attributes with restricted values: If you're importing subscriber data into attribute fields that restrict the possible values, the import data must exactly match one of the values defined as allowable for that attribute.
    • Preferences: If you're importing subscriber preference data, your import file should use only the values Yes and No.

    Encryption Support

    If the advanced feature for encrypted imports is enabled in your account, you can encrypt your import file. ExactTarget supports files encrypted with the GNU Privacy Guard (GnuPG). You can find out more about the GnuPG format and download the software at http://www.gnupg.org/.

    The ExactTarget public GnuPG key is located at the following address: http://members.exacttarget.com/Content/Subscribers/SubsLists/publickey.txt
    This link to the public key is included in the Identify Source File dialog box of the Import Subscriber wizard (in the ExactTarget application) for your convenience.

    Accessing the ExactTarget FTP Site

    The ExactTarget FTP site is located at the following address:

    ftp://ftp.exacttarget.com

    When prompted to log in, use the following username and password:

    • Username: import
    • Password: import

    Once logged in, you simply drag your import file into the browser window to upload the file.

    Note: If the enhanced FTP option is enabled for your account, please contact your ExactTarget account manager for your organization's account-specific login information.

    Importing a Subscriber File from the FTP Site

    When you have FTP options enabled, the Identify Source File dialog box in the Import Subscriber wizard contains additional options:

    FTP_import.jpg

    • If the basic FTP option is enabled in your account, you'll see the FTP upload source field. In the Upload Source section, select the FTP radio button and enter your filename in the FTP field.
    • If you have the FTP encryption option enabled in your account as well, you'll also see the File is encrypted radio button. Select this radio button if you're importing a GnuPG-encrypted file.

    All other aspects of importing your subscribers is the same as it is for standard (non-FTP) imports. Please refer to the online help within the ExactTarget application for full details on the import process.

    Troubleshooting

    Here are helpful hints to troubleshoot issues you might encounter.

    Permission Error

    Issue: You receive a permission error while trying to copy your file to the FTP site.

    Possible resolution: Another file with the same filename already exists on the FTP site. Rename your file and try again to copy the file to the FTP site.

    Windows Folder Access Error

    Issue: You receive the following error when you try to log in to the FTP site:

    Windows cannot access this folder. Make sure you typed the file name correctly and that you have permission to access the folder.

    Possible resolution: According to Microsoft, this issue can occur when you are attempting to access the FTP site from behind a firewall and you have folder view for FTP sites enabled in Internet Explorer.

    Go to the Advanced tab in the Internet Options dialog box and clear (deselect) the Enable folder view for FTP sites check box. Then try accessing the FTP site again.

    For more information, see the following Microsoft knowledge base article:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;814473.

    Unable to Log In

    Issue: You are unable to log in to the FTP site.

    Possible resolution: Your organization might be set up to deny users access to all external FTP sites. Ask your organization's system administrator whether you can access FTP sites.
     


    This page was last updated by Josh Cloud on Tue, 31 May 2011 14:10:51 GMT.

    If you're having an application issue, please contact Global Support. To send Josh direct feedback, fill out the form below:


    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 18095 backwards:
       
    Tags: (Edit tags)
    • No tags
    FileSizeDateAttached by 
    FTP_import.jpg
    No description
    40.68 kB10:10, 31 May 2011AdminActions
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin