The mapping process can be less manual by using .txt files. Please send the files to Hayley Mills to load into Archivist. Once loaded you can then check the mappings. The format specifications are given at below along with examples. A list of the Archivist pages which can be used to check the mappings (and view a list of questions) can be found at the end of the page , along with examples.
Grid mappings and derived variable mappings currently must be completed using .txt files.
...
It is suggested that you create only one topic mapping file first , (preferably variable to topic) 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.
Format specifications
cc_questions.txt
Question list produced by Archivist.
- ID
- Text (Literal)
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
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.
- 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
Archivist pages to view mappings
Note: you must be logged into Archivist to view the below pages.
...
Note: Variables can be mapped to grid references in the mapping.txt file, but currently these will only be displayed as mapped to the gird as a whole. See table for how to map to grid cells.
Format specifications
cc_questions.txt
Question list produced by Archivist.
- ID
- Text (Literal)
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
4. Variable name
tv.txt
Mapping file which links topics and all variables.
- Tab delimited
- 3 columns:
1. Dataset prefix
2. Variable name
...
.
...
tq.txt
Mapping file which links topics and questions.
- 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
...