File Format for FTP Import in Brilliant Navigator

File Format

• File type: CSV

• Encoding: UTF-8 (required if the file contains special characters like å, ä, ö)

• Column delimiter: Semicolon (;)

• Row delimiter: Standard line break (LF or CRLF)

Required Columns

The file must contain the following columns. The order of columns can vary, but the headers must exactly match the list below:

• PhoneNumberOrEmail

• AgentRefCode

• SurveyRefCode

• LanguageCode

• MetaKey

• RecruitmentMethod

• RespondentAttributes

Detailed descriptions of each column are provided below.

Column Descriptions

PhoneNumberOrEmail

The phone number or email address of the person to be contacted.
For phone numbers, including the country and area code is recommended.
Example: 0046857933901

AgentRefCode

A unique identifier for the agent who will send the survey and receive the responses.
This reference must be configured in Brilliant Navigator.

SurveyRefCode

The identifier for the survey to be used.
The questions asked depend on the survey selected by the client.

LanguageCode

The language in which the survey will be conducted.
Use one of the following codes:

• SE

• NO

• DK

• FI

MetaKey

An optional metadata key (unique value), such as a customer number or case ID.
Can be left empty.

RespondentAttributes

Respondent attributes in JSON format.
Can be left empty.
Example: { "CallLength": "885" }

RecruitmentMethod

Specifies the recruitment method to be used.
Possible values: