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 with examples.
Note: Only one topic can be applied to a grid as a whole- this means that all variables mapped to a grid question must have the same topic.
It is recommended that you create only one topic mapping file first (preferably tv) 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
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
Viewing and downloading mappings
Note: you must be logged into Archivist to view the below pages.
Most .txt files can be viewed from one Instrument Export page. Navigate to Admin > Instrument exports > search for the prefix then select VIEW e.g. https://closer-archivist.herokuapp.com/admin/instruments/ncds_65_eq/exports
Question to variable mappings can be saved as a .txt by clicking e.g. Download qv.txt
Question to topic mappings can be saved as a .txt by clicking e.g. Download tq.txt
Derived variable mappings can be saved as a .txt by clicking e.g.e.g. dv.txt
Variable to topic mappings can be saved as a .txt by clicking e.g. e.g. tv.txt
Quesiton to variable mappings with topics included can be viewed and saved by navigating to the instrument map page. On the instrument page search for the prefix then select MAP, then click e.g. Download File, this will list; Question name, Question text, Question Topic ID, Variable name, Variable Topic ID, and Variable Label. Note it doesn't include derived variables mappings.
.txt files to download to create mappings
A question list can be saved as a .txt by clicking e.g Download cc_questions.txt
A question list with sequences can be saved as a .txt by clicking e.g. Download mapper.txt
A variable list can be saved as a .txt by clicking e.g. variables.txt Note - there is a bug which means this is not currently loading.
Dataset and instrument views
Datasets > search and select the Name of the dataset. Any mapping conflicts will appear in red.
The question-variable mappings can also be checked through Instruments > search and select the Prefix (or view) of the instrument. This will gives the questionnaire view with the variable names listed against them