Data Load Record Handling and Requirements
Use the Load from File option to import data records from a delimited text file directly into an existing List. There is a limit of 5,000 records for uploading. If you need to upload more records, we strongly suggest that you use a Connect job. These are the requirements for uploaded files:
- Character to Quote field values as Double Quotes (") and None only.
- Character Separator - Comma Only
- File must have header
Notes
- Blank and/or null characters are stripped from the beginning and end of fields (columns) in imported data. If necessary, it also truncates data fields to fit into the field lengths you specify.
- Timestamp fields must have the format
yyyy-mm-dd hh:mi:ss
(anything after thess
segment is truncated). - For text fields – Any blank lines are removed from those text fields.
- For mobile number fields - See Mobile number data import handling in Responsys.
Import Speed
Importing can be slowed for various reasons, including:
- Data fields of type MEMO (Long Text)
- Source data that is both tab-delimited and double-quoted
- Ignored columns
- Understanding Data and List Management
- System-Defined List Fields
- Viewing and Editing List Data
- Finding List Data Records
- Loading Lists from Files
- Changing Channel Status Fields
- Downloading List Data
- Understanding Filters
- Creating Data Sources from SQL Statements
- Creating Test Group Lists
- Creating Segment Group Lists
- Changing List Schemas
- Moving or Renaming Lists
- Viewing List Load History
- Mobile number data import handling in Responsys