Member Interaction Activity File

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
Member Account Id	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