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. TIBCO Reward can also provide this file in XML format, as well as other commonly used flat file formats (tab separated, pipe delimited format).

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