Preview Mappings

In this step you tell Visit how it should read each of the fields in your spreadsheet.

On the left-hand side you can see System Questions. At the bottom of the left-hand side you can click on Profile questions to see all Questions that have been set up for the Event.

1. Select a field from the left-hand side
2. Drag the field to the matching column.

3. Once the box below the field name is green you can drop the field

   

   Figure B-5 Drop fields

4. Continue until all fields are mapped
5. If you want to remove a field mapping, click to the right of the field name

You must map the field called Reference from the left-hand side.

Where there are any questions that are answered by multiple-choice in the database you have to map the answers in the database to the answers in the spreadsheet. You can easily identify these questions as Map answers will appear in the column. In addition to the multiple choice answers, mapping is also required for Language and Country fields.

If you drop a field in the wrong column, you can simply drag and drop it to the correct column