Append CSV template format
The CSV file template for a dataset uses a number of conventions to ensure that the imported CSV data can be successfully appended to the dataset.
Identifier fields
These fields are used to associate each record with a member (ownerId) and to provide a unique identifier for each submission for multiple response surveys (recordExternalId).
| Name | Description |
|---|---|
| ownerId | Optional. The Member ID the record is associated with. Although this field is optional, it is the field that ties each appended row to the appropriate member and should be specified whenever possible. If the data is not specific to a particular member, leave this field blank. |
| recordExternalId | Optional for single response surveys. Required for multiple response surveys to ensure that a unique record is created in the dataset for each individual response. You can specify any string or numeric value, but you must provide unique values for each individual row for an ownerId. |
Activity fields
These fields include an entry for each field you selected in the dataset with the field name and the activity it belongs with, and a set of system fields for each activity that must be present in the CSV file. You can populate the system fields if the application you are exporting data from includes this information, but it is not required.
| Syntax | Description |
|---|---|
| <field_name>|<activity_name>
Example: Role|Employee Satisfaction |
An entry is included for each activity field you added to the dataset. |
| DisplayType|<activity_name> | Optional. Indicates whether the participant used a desktop or mobile device to respond to the survey |
| UserAgent|<activity_name> | Optional. Provides information about the browser the participant used to respond to the survey. |
| RespondentLocale|<activity_name> | Optional. Indicates the language the participant used to respond to the survey. |
| ResponseStatus|<activity_name> | Optional. The status of the survey response. Specify "Completed" unless you are working with incomplete or invalid responses. |
| CompletedDate|<activity_name> | Optional. The timestamp recording when the
response was completed. Not required, but recommended for multi-response
surveys. Must be specified in UTC time which has the following format:
yyyy-MM-ddTHH:mm:ss.SSSZ For example,
2021-07-01T17:35:52.123Z
|
Profile variable fields
These fields include an entry for each profile variable you added to the dataset, and the memberstatus field, a system variable that indicates whether the associated member is active in the system or not.
| Syntax | Description |
|---|---|
| <profile_variable_name>|profilevariables | An entry is included for each profile variable you added to the dataset. |
| memberstatus|profilevariables | The current status of the associated member in the system. |