Sample File Fields Overview

When a person first agrees to make themselves available as a potential panelist, a lot of details about that person are registered into a database. The database is constructed as a table of rows and columns where each row contains the details of one person and each column contains the answers provided for one particular question.

The end product of the panel selection process is a text file containing a sample of the database table rows (panelists’ details) as defined by the exclusion and selection criteria.

Some information, such as the panelist’s ID number is always included by default. However you can use the Sample File Fields tab to specify which other columns of information about the selected panelists are to be included in the text file. The columns included here will define the contents of the results tables that will be available after the survey is completed. Click on the various tabs and buttons in the figure for further details. To add columns:

1. In the Available Fields list, select the columns you wish to add by clicking in the boxes beside the name.
2. Click Add.

The selected columns are moved to the Selected Fields area - .

Click Add All to add all of the columns without having to select them individually. In the Selected Fields area, select a column and click Remove to return it to the Available Fields list.

Figure 1 - The Sample File Fields window

Navigation

The toolbar for the Sample File Fields tab is as shown below - .

Figure 2 - The Sample File Fields toolbar

• Search – starts the search function.
• Add – moves selected fields from the Available Fields list to the Selected Fields list.
• Add All – moves all the available fields from the Available Fields list to the Selected Fields list.
• Field Type – select the field type you wish to use. The options are:
• Panel fields – the fields pre-defined by the panel.
• External fields – additional fields made available by uploading a matchfile.txt file (go to Uploading a File for more information).
• Check box – click in a check box to select the associated field. The uppermost check box selects all the fields.
• Field name – the header for the list of fields in the column.
• Remove – removes selected fields from the Selected Fields list.
• Remove All – removes all fields from the Selected Fields list.
• View - select from the drop-down list the field type you wish to view.