1. Click Subscribers.
2. Click Data Extensions and then click the desired data extension. Select only one data extension for import.
3. Click Import.
4. Complete the fields in the Upload File section:File Location and File - If the file you want to import is on your hard drive, click Browse and locate the import file. If file size exceeds 20MB, you must use the FTP option. The file name must be 99 characters or less. To use a file that you've uploaded to the enhanced FTP site, type the filename in the File name field. File names are case-sensitive.File is compressed checkbox - Determines whether the system uncompresses the file when the activity runs. If you select this checkbox, the value you enter in the File Naming field must have a .ZIP extension.File is encrypted checkbox - Determines whether the system unencrypts the file when the activity runs. If you select this checkbox and do not select the File is compressed checkbox, then the value that you enter in the File Naming field must have a .PGP or .GPG extension.Delimiter:Comma - If you choose Comma, the value that you enter in the File Naming field must havea .CSV extension.Tab - If you choose Tab, the value that you enter in the File Naming field must have a.TXT extension.Other - If you choose Other, you must enter a 1-character delimiter in the OtherDelimiter field.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.Import Type:Add and update - If the import file contains records with a primary key or email addressthat do not exist in the data extension, the import creates a new record for thatinformation. If the import file contains records with a primary key (or email address) thatalready exists in the data extension, the import updates the record to match what is in theimport file.Add only - The import creates new records for primary keys that do not already exist inthe data extension and ignores records whose primary keys already exist.Overwrite - The import overwrites all records.Import Options - If you select Respect double quotes as a text qualifier, the system treats data contained within double quotes as text and does not process any delimiter contained within those quotes. If you do not select this checkbox, the system ignores double quotes in your import file.
5. File Location and File - If the file you want to import is on your hard drive, click Browse and locate the import file. If file size exceeds 20MB, you must use the FTP option. The file name must be 99 characters or less. To use a file that you've uploaded to the enhanced FTP site, type the filename in the File name field. File names are case-sensitive.
6. File is compressed checkbox - Determines whether the system uncompresses the file when the activity runs. If you select this checkbox, the value you enter in the File Naming field must have a .ZIP extension.
7. File is encrypted checkbox - Determines whether the system unencrypts the file when the activity runs. If you select this checkbox and do not select the File is compressed checkbox, then the value that you enter in the File Naming field must have a .PGP or .GPG extension.
8. Delimiter:Comma - If you choose Comma, the value that you enter in the File Naming field must havea .CSV extension.Tab - If you choose Tab, the value that you enter in the File Naming field must have a.TXT extension.Other - If you choose Other, you must enter a 1-character delimiter in the OtherDelimiter field.
9. Comma - If you choose Comma, the value that you enter in the File Naming field must havea .CSV extension.
10. Tab - If you choose Tab, the value that you enter in the File Naming field must have a.TXT extension.
11. Other - If you choose Other, you must enter a 1-character delimiter in the OtherDelimiter field.
12. 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.
13. Import Type:Add and update - If the import file contains records with a primary key or email addressthat do not exist in the data extension, the import creates a new record for thatinformation. If the import file contains records with a primary key (or email address) thatalready exists in the data extension, the import updates the record to match what is in theimport file.Add only - The import creates new records for primary keys that do not already exist inthe data extension and ignores records whose primary keys already exist.Overwrite - The import overwrites all records.
14. Add and update - If the import file contains records with a primary key or email addressthat do not exist in the data extension, the import creates a new record for thatinformation. If the import file contains records with a primary key (or email address) thatalready exists in the data extension, the import updates the record to match what is in theimport file.
15. Add only - The import creates new records for primary keys that do not already exist inthe data extension and ignores records whose primary keys already exist.
16. Overwrite - The import overwrites all records.
17. Import Options - If you select Respect double quotes as a text qualifier, the system treats data contained within double quotes as text and does not process any delimiter contained within those quotes. If you do not select this checkbox, the system ignores double quotes in your import file.
18. Click Next. The application checks for malware and prevent uploading of infected files.
19. Complete the fields in the Configure Mapping section:Map by Header Row - The import updates the columns in the data extension with the information in the import file by matching the column headings.Map by Ordinal - The import updates the first column in the data extension with the first column in the import file, the second column with the second column, and so on. When Import File has column headers is checked, the header value in the import file is displayed in italics.Map Manually - The import file column that directly matches a data extension column maps automatically. To manually map an import file column, select the column name in the drop-down next to the data extension column. An import file column can only be mapped to a single data extension column.
20. Map by Header Row - The import updates the columns in the data extension with the information in the import file by matching the column headings.
21. Map by Ordinal - The import updates the first column in the data extension with the first column in the import file, the second column with the second column, and so on. When Import File has column headers is checked, the header value in the import file is displayed in italics.
22. Map Manually - The import file column that directly matches a data extension column maps automatically. To manually map an import file column, select the column name in the drop-down next to the data extension column. An import file column can only be mapped to a single data extension column.
23. Click Next.
24. Review the Review & Import section that appears.
25. Enter an email address to receive an email when the import completes. You receive a list of errors if applicable. By default your Notification Email Address set in the account is populated.
26. Click Import.