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.