...
It is recommended that you create only one topic mapping file first (preferably tv.txt) as the other will be inherited once the question and variable have been mapped. Any gaps in topics can then be filled afterwards. This should prevent topic conflicts.
A spreadsheet usually created by CLOSER using this template which contains all the questions, variables and topic list, is sent to the studies to help with creating the mappings. When the completed mappings have been returned by the study, these are checked for:
- Gaps in mappings
- questions which have not been mapped to variables
- questions which have not been mapped to topics
- variables which have not been mapped to topics
- Any obviously incorrect topic mappings
- Variables which have not been mapped to questions are in the DVs tab
...
Format specifications for Archivist
qv.txt
Mapping file which links questions and variables.
- Tab delimited
- 4 columns:
1. Questionnaire prefix with _ccs01 suffix
2. Question label (with optional suffix grid cell coordinates in the format $X;Y. Please refer to the Grid coordinates table on the condition page for how to reference grid cells.)
3. Dataset prefix (which usually matched the questionnaire prefix but without the suffix)
4. Variable name
tv.txt
Mapping file which links topics and all variables.
- Tab delimited
- 3 columns:
1. Dataset prefix
2. Variable name
3. Topic ID (Uses Colectica topic IDs)
tq.txt
Mapping file which links topics and questions (this can be inherited using the qv and tv mappings).
- Tab delimited
- 3 columns:
1. Questionnaire prefix with _ccs01 suffix
2. Question label
3. Topic ID (Uses Colectica topic IDs)
dv.txt
Mapping file which links derived variables to source variables.
- Tab delimited
- 4 columns:
1. Dataset prefix
2. Derived variable name
3. Dataset prefix
3. Source variable name
Question to Variable mappings
...
- The incorrect file has been selected
- The incorrect mapping type has been selected
- The file format is not correct
- The instrument and dataset is not linked in ArchvistArchivist
- The content is not valid
- The names are not the correct case
- The variable in not in the dataset
- Typos or spaces in the names
...
Note: Derived variables and their source variables do not have to have the same topic, although a suggested topic is inherited from the source variable.
Format specifications for Archivist
qv.txt
Mapping file which links questions and variables.
- Tab delimited
- 4 columns:
1. Questionnaire prefix with _ccs01 suffix
2. Question label (with optional suffix grid cell coordinates in the format $X;Y. Please refer to the Grid coordinates table on the condition page for how to reference grid cells.)
3. Dataset prefix (which usually matched the questionnaire prefix but without the suffix)
4. Variable name
tv.txt
Mapping file which links topics and all variables.
- Tab delimited
- 3 columns:
1. Dataset prefix
2. Variable name
3. Topic ID (Uses Colectica topic IDs)
tq.txt
Mapping file which links topics and questions (this can be inherited using the qv and tv mappings).
- Tab delimited
- 3 columns:
1. Questionnaire prefix with _ccs01 suffix
2. Question label
3. Topic ID (Uses Colectica topic IDs)
dv.txt
Mapping file which links derived variables to source variables.
- Tab delimited
- 4 columns:
1. Dataset prefix
2. Derived variable name
3. Dataset prefix
...
Reviewing the mappings
Dataset and instrument views can be used to check for gaps and conflicts.
...