Intended Application
For interaction importing in which a single file will contain interactions for one or many Interaction Types.
Records can contain interaction custom field data.
Notes
- Any delimiter, with the exception of [tab] can be used to separate columns. The delimiter used is then specified at the time of file import.
- Header is Required. Header Field Names must match Interaction Custom Field External References
File Structure
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
---|---|---|---|---|
Alphanumeric |
Yes |
|
||
Unique Key | Alphanumeric | No | Unique identifier generated by external system. | |
Interaction Type External Reference | Alphanumeric | Yes | ||
Location External Reference | Alphanumeric | Yes | ||
Timestamp | Date/Time | No |
MM/DD/YYYY HH:MM:SS |
Based on a 24 hour clock |
Interaction Custom Fields | Varies | No |
Sample File
1: 2: 3: |
Account|Unique|InteractionExtRef|LocExtRef|Timestamp|INT_CustFLD1|CUSTFLD2|Number 7000|990332AF|INT1|1|09/08/2010 18:13:14|On|yes|350 7001|990332BF|INT1|1|09/08/2010 18:15:14|On|yes|350 |