Requirements For Passing Data To ForeSee: Data File Requirements
The file must have column headers.
Delimited files (CSV, TSV, Pipe, or any other delimited format) with associated header record.
Any dates supplied in MM/DD/YYYY or M/D/YYYY H:MM format.
One row per respondent.
ForeSee respondent ID required as a data point in each row.
In most cases, Adobe (Omniture) or Google (UA) integrations are accommodated through an API those companies provide. When using this API, data file transfers are not necessary to deliver our data to Adobe or Google. However, if a client wants to pass Adobe or Google data back to us, a data file transfer is necessary.
Passing Data To ForeSee: SFTP Information
ForeSee establishes an ID, Password, and directories to the SFTP host. A client-supplied SFTP can be used as well.
ForeSee also has the capability to provide Public Key Authentication.
Encryption with Open PGP and GnuPG (GPG) is supported provided the ForeSee encryption key is used.
Passing Data To ForeSee: EXDL Information
External Data Load (EXDL) is a process used to load data into the ForeSee database:
A custom EXDL is generated for each data feed.
The process monitors the SFTP folder and automatically imports new files.
Imported data appears in the Portal the following day.
Passing Data To ForeSee: Hidden Custom Questions Information
Hidden custom questions are simply the containers for the imported data. Respondents do not see these questions on their surveys.
Every incoming column of data is mapped to a corresponding hidden custom question.
Passing Data From ForeSee
Data is in tab delimited files of Text (.txt), Comma Separated Values (.csv), or Excel (.xlsx) format.
One zip file per measure. The zip file contains three files:
Data file - Respondent data from the survey.
Question Mapping File - Question details including mapping.
Answer Mapping File - Answer details including mapping.
Delivery options include:
Email: Zip file attachment sent to email recipient.
Posted for Pickup: Posted to ForeSee® Portal workspace area for client retrieval.
FTP (ForeSee): File available for retrieval on ForeSee® SFTP site.
