Server User Guides > Interviewer - Server > Participants > Uploading records from the text file
 
Uploading records from the text file
1 On the Upload tab, click Import Participants.
A progress box reports the number of records uploaded.
2 When all records have been processed, click OK to close the progress box.
Notes
The Participants activity uploads all records in a text file in one go. It is not possible to load only part of a file.
If the text file you are uploading contains a record with the same Id as a record that is already in the sample table, the Participants activity rejects the record and continues with the next record in the text file. At the end of the upload, Participants displays a list of rejected records.
If the upload process fails with the message “CREATE DATABASE permission denied in database ‘master’”, the problem might be that the Anonymous IIS User account does not have permission to create databases. Contact your UNICOM Intelligence Interviewer administrator for assistance.
Only values from newly added fields are added to existing records when uploading samples into an existing database. Existing database values are not updated, even when they differ from values in the newly uploaded file.
When a project is activated, a view that joins the sample table and sample history table is created for reporting purposes. In the view’s SQL statement renames four of the view’s fields (Id is renamed to SampleId, CallOutcome is renamed to CallOutcomeTmp, UserId is renamed to InterviewerId, and a computing field is named to IsLatestEntry). As a result, when a sample table contains a column name that is the same as on of the view’s four alias columns, an error is written to the ACT log when the project is activated. The error message is similar to:
Column names in each view or function must be unique. Column name 'InterviewerId' in view or function 'SAMPLETEST_SampleOverview' is specified more than once
See also
Participants