Participants

Interviewer - Server > UNICOM Intelligence Interviewer activities in UNICOM Intelligence Interviewer Server - Admin > Participants

Participants

You use the Participants activity to copy participant records from a Participant file format text file into a table in a Sample (participant) database. You can either use an existing database and/or table or you can create new ones. After you have loaded some records, you can use the Participants activity to view and edit those records.

The Participants activity displays a page that contains six tabs. The first three tabs are used to view, edit, delete, and download records that have already been loaded into the sample table: for more information, see Viewing and editing participant records. The next three tabs correspond to the tasks you need to perform before you can upload records. These are:

▪Specify the text file and then choose or define the sample database and table into which the participant records will be loaded. See Naming the database server, sample database, and sample table.

▪Map fields from the participant records to required columns in the sample table, or create the required columns with default values. See Mapping fields to required columns in the sample table.

▪Define new columns that you want to create in the sample table to store other information from the participant records. See Adding other information to the sample table.

When you have completed these tasks, you can then upload records from the text file (see Uploading records from the text file).