Import into a List

Import enhanced subscriber data into a list in Email Studio.

1. Hover over Subscribers.
2. Click Lists.
3. Under Actions click Import for the list to import into.
4. Click Next in the wizard's introductory dialog box.
5. Read the content of the Opt-in Certification dialog box that appears next. If you have verified that every subscriber in your import file has agreed to receive emails from you, select the I agree checkbox, and click Next.
6. Complete the Identify Source File dialog box.

   Field	Description
   Upload Source	The import wizard shows you two upload options: Your Computer and FTP. To use a file that you've uploaded to the FTP site, type the filename in the FTP field. If the file you want to import is on your hard drive, click the Browse button and locate the import file on your computer. Only files on a locally mapped drive are supported ( C:\, D:\, etc.). You cannot upload a file from a UNC path (such as \\ abcfiles\).
   Data Format	Select one of the following: The CSV radio button The Tab Delimited radio button The Other Delimited radio button. If you select this value, you must enter a 1-character delimiter in the field.
   File is encrypted	If the advanced feature for encrypted imports is enabled in your account, you'll see this check box. Select the check box if the import file you're using has been encrypted.
   Updated Options	Add new subscribers and update subscribers that exist Add new subscribers but do not update subscribers that exist Update existing subscribers but do not add subscribers that do not exist
   Date Format	You can select a date format from the drop-down menu in this section to use as part of the import. Choose the date format that most closely matches the region from which you are conducting the import.
   File Encoding	Select the type of file encoding you want to use. If no type is selected, the system defaults to UTF-8.

7. Click the Next button in the Import Subscriber Wizard dialog box. The application reads the import file, which may take several moments depending on the size of the file. The application will then perform a check for malware and prevent uploading of infected files.
   

   Note The data in the import file is not yet brought into your account.
8. The Map Attributes dialog box appears next. This dialog box consists of two sections:

   Source

   The Source section lists the data found in the first row of your import file. Labels that are grayed out have been mapped to attribute fields by default; labels shown in black font have not been mapped. If the first row of your import file is a header row, you'll see the column labels from your import file shown in the Source section. In this case, make sure that the First row is header check box is selected so that the application does not attempt to import that row as subscriber data. You can view all the data in your import file by the buttons below the Source section. Click the Next button below the Source section to view the next row of data in your file. Click Previous to go back to the row that was displayed.

   Destination

   The Destination section lists the profile and preference attributes currently defined in your account, separated into those that have been set up as required and those that have not. If the header row in your import file contains labels that exactly match attribute names, the application has mapped those labels to the attributes for you. The Mapped From column in the Destination section shows the label from your import file that's been mapped to the attribute shown in the Attribute column. As you scroll through the rows of data in your import file by using the Previous and Next buttons, the Destination section updates to show how the data is mapped to the attribute fields.

9. If a field from your import file has not been mapped for you to an attribute, map it as follows:
   • Click the field in the Source section. (Whether you're viewing the header row labels or a row of actual subscriber data in the Source section when you click the source field is unimportant. In either case, you're mapping all data from that row of your import file to the attribute.)
   • Click the corresponding attribute in the Destination section.
   • Click the Map button.
     

     Note The column of data is now mapped to the attribute, as indicated by the grayed-out value in the Source section and the Mapped From value in the Destination section.

     You also have these additional options:

     • Remove a single mapping: To unmap an attribute from the import file field to which it's currently mapped, click the attribute row in the Destination section and then click the Unmap button.
     • Remove all current mappings: If you want to remove all the current mappings (that is, delete all values from the Mapped From column in the Destination section), click the Clear Map button.
     • Return to the original mappings: If you want to undo all changes you've made to the default mappings (the mappings that were in place when you first opened this dialog box), click the Default Map button.

   Any fields still displayed in black font rather than gray in the Source section represent data that isn't imported.

10. When satisfied with your mappings, click the Next button at the bottom of the dialog box.
    

    Note Any attributes that have been defined as required must be mapped to fields in your import file. You can't continue with the wizard until these fields are mapped.
11. The Confirm Mappings dialog box appears next, summarizing your selected mappings and the number of columns (fields) and records (subscribers) in your file that the application attempts to import. If you want to be notified when the import is complete, select the Email me upon import completion check box and enter your email address in the Email address field. Your email notification also includes a log of any subscriber records that could not be imported.
12. Click the Begin button. The application begins the process of importing your data. How long the import takes depends on the size of your import file.
13. The final dialog box of the wizard appears.

• If you chose to be emailed upon completion, this dialog box appears immediately and confirms that the import has begun. Click Finish to exit the wizard. After the import is completed, you'll receive an email with the results of the import (if the file does not exceed 5MB in size. If the export file is over 5 MB in size, the system delivers it to your enhanced FTP account regardless of what you select here. If you do not have an enhanced FTP account, the system returns a message saying that you should call global support.)
• If you did not request an email upon completion, the dialog box appears after the import process has been completed. The text of the dialog box shows you the results of the import and includes a Download report button for you to view the details behind the records that could not be imported. Click Download report to open the log file showing the results. You also have the option of opening the list into which you imported the new subscribers. Select the Take me to my list check box, and the list opens when you click Finish.

Note If you imported using an Enterprise account, the email address appears on the global unsubscribe list or on your account-level unsubscribe list.