Standard CSV Sample Files
Unlike some other exported batch files, the New and Updated Customer
Export File is sent in comma separated value (CSV) format by default.
The two samples below (standard and pre-7.2 release) each show a few lines of a sample New and Updated Customer Export File in CSV format.
Standard File Format Sample
The next sample shows a few lines of a sample New and Updated Customer Export File in CSV format. This sample is for clients who want to use Custom Attributes. It includes fields for custom attributes. Most of the Custom Attribute fields are not used (empty fields are indicated by a pair of double quotation marks with no content between quotes. In this sample, the client uses only a few of the available fields available for assignment to custom attributes.
2773,2007-03-16 13:42:50.877,2007-03-16 13:42:50.903,"A",1,"Other","58841512",58841562,"Nastia","v","Molchanenko","101 Pine St","","San Francisco","NJ","94005","anastasia@loyaltylab.com",1,"","","",1900-01-01 00:00:00.000,,220.0000,2007-03-21 16:52:52.383,"",,"",2007-02-02 00:00:00.000, "dttnDateLastSale",,"",,"dttnDateLastMtce",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,,"",," StoreID",,"AssignedSalesperson",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",, 2007- 03-21 16:52:52.430,"Marital Status","1","Age Range","3","OpenRewards",,"",,"",,"",,"", ,"",,"",,"",,"", ,"",,"",,"",,"",,"",,"",,"",,"",,"",,,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"", ,"",,"",,"",,"",,"",,"", 2773,2007-04-23 01:00:00.000,2007-03-23 09:51:19.950,"I",1,"Other","05093951", 58841669,"Anastasia","","Molchanenko","100 Pine","","BRISBANE","CA","94111", "anastasia2@loyaltylab.com",0,"6504151212","","",1900-01-01 00:00:00.000,,.0000, 2007-04-23 10:20:40.250,"",,"",2007-02-05 00:00:00.000,"dttnDateLastSale",2006-12-01 00:00:00.000, "",,"dttnDateLastMtce",2006-12-14 00:00:00.000,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"", ,"",,"",,"",,2007-04-23 10:20:40.640,"",,"StoreID",5.0000,"AssignedSalesperson", 1234.0000,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,2007-04-23 10:20:40.377, "Marital Status","1","Age Range",,"OpenRewards","false","",,"",,"",,"",,"",,"",,"",,"",,"", ,"",,"",,"",,"",,"",,"",,"",,"",,,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",,"",
File Format Sample: No Custom Attributes
This first sample, which is for clients who do not want to use custom attributes, includes no custom attribute fields.
12854,2007-01-22 23:41:32.473,2007-01-22 23:41:32.380,"A",1,"Other"," ",53210971,"John","","Smith"," ",""," "," ","94114","jsmith@loyaltylab.com",1,"","","",,,300.0000 12854,2007-01-22 01:58:23.447,2007-01-22 01:58:23.587,"A",1,"Other"," ",53184716,"Joe","","Baker"," ",""," "," ","60478","jbaker@loyaltylab.com",1,"","","",,,500.0000 12854,2007-01-22 02:34:43.424,2007-01-22 02:35:21.127,"A",1,"Other"," ",53316847,"Bob","","Jones"," ",""," "," ","94609","bjones@loyaltylab.com",1,"","","",,,200.0000