The Survey Sync is used to export batches of survey, trivia and poll answers. The sync can output up to three separate files per execution, one for each question type.
Upon each execution, all new answers since the last execution will be included in the sync file with current information. Files are then FTP’d to the predetermined location.
Note: This information is available as a PDF for portability. Survey Sync.pdf
Survey Sync
Name |
SurveyResultsSync_YYYYMMDDHHMMSS_##.txt (Survey) TriviaResultsSync_YYYYMMDDHHMMSS_##.txt (Trivia) PollResultsSync_YYYYMMDDHHMMSS_##.txt (Poll)
## = File Numbe |
Format |
Pipe delimited Header record is present |
Frequency | Daily |
Source | Kognitiv Loyalty |
Contents | Answer-related data registered in Kognitiv Loyalty since the last sync file processed. |
Field Name | Type | Notes |
---|---|---|
Question Name | String(60) | |
Member Id | Numeric(10) | Kognitiv Loyalty Internal Member Id |
Account Id | String(60) | Member's Primary Account Id |
First Name | String(60) | |
Last Name | String(60) | |
Question Set External Reference | String(20) | |
Answer | String(120) | |
Answer Timestamp | Date/Time | YYYY-MM-DD HH:MM:SS.nnn (24hr UTC) |
Multiple Answer Type | Boolean |
TRUE or FALSE
Can the question have multiple answers selected? |
Example Data
QuestionName|SBInternalMemberId|AccountId|FirstName|LastName|QuestionSetExternalReference|Answer|AnswerTimestamp|MultipleAnswerType
Favorite Pizza Topping|37796|99955515556|JOHN|VILLANO|PQ|Extra Cheese|2012-05-18 15:25:13.520|TRUE