...
The process can be less manual by using the .txt files described below with an example attached to demonstrate the format. The format specifications are given at the end of the page, along with examples.
- qvmapping.txt Mapping file that links questions and variables (listing all variables and derived variables).
- dv.txt Mapping file that links derived variables to variables.
- tqlinking.txt Mapping file that links topics and questions
- tvlinking.txt Mapping file that links topics and variables
A question list can be saved as a .txt from Archivist by navigating to the instrument view and then adding /mapper.txt to the web address e.g.https://archivist.closer.ac.uk/instruments/alspac_01_rat/mapper.txt
The following steps can be used to upload mappings via the .txt files.
...
Note: Variables can be mapped to grid references in the qvmapping.txt file, but currently these will only be displayed as mapped to the gird as a whole.
Format specifications:
mapper.txt
- ID (qc or URN)
- Type (“Question” or “Sequence”)
- Grid limits or “-“ for null ([Y,X])
- Parent (URN)
- Text (Literal or Sequence name)
qvmapping.txt
- Tab delimited
- Must include all variables including derived variables
- 2 columns
- qc
- question name
- ‘0’ if mapped to nothing
- ‘0’ if derived variable
- [OPTIONAL] suffix grid cell coordinates in the format $X;Y
- variable name
- qc
tvlinking.txt
- Configuration file
- Tab delimited
- Used for applying level 1 & 2 topics to variables
- Uses Colecitca topics IDs
- 2 columns
- variable name
- topic ID
tqlinking.txt
- Tab delimited
- Uses Colecitca topics IDs
- 2 columns
- qc (question identifier)
- Topic ID
dv.txt
- Tab delimited
- Only includes derived variables
- 2 columns
- Derived variable name
- Source variable name