Backfeed File Format (csv)

Each row in the csv file should consists of between three and nine fields which map into Q_Panel as follows:

Position Q_Panel field name Date (time) format
1 UniqueRef  
2 Email Resp ID*  
3 Outcome Code  
4 Interview Date yyyy-mm-dd
5 Don’t Contact Before Date yyyy-mm-dd
6 Re-contact Date yyyy-mm-dd hh:mm:ss
7 Reward Points  
8 Start Interview Time yyyy-mm-dd hh:mm:ss
9 End Interview Time yyyy-mm-dd hh:mm:ss

Either positions 1 or 2 must contain data which identify the panellist.

Position 3 must contain the outcome code.

Positions 4-9 can be set as optional or required according to the definition of the outcome code.

For example, a csv backfeed file could contain these rows:

159805,,1 159799,,1,,,, 159875,,4,2015-01-18,,,2 ,19f290c75bbd4c729b6abb21a9337b67,4,2012-5-17,,,2 159885,,1,2015-01-20,,,10,2015-01-20 09:10:11,2015-01-20 09:15:11

Note that date time fields may also use the format yyy-mm-ddThh:mm:ss.