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.
...
- 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 Archivist
- The content is not valid
- The names are not the correct case
- The variable in is not in the dataset
- Typos or spaces in the names
...
Note: All manual mappings will be replaced by the imported qv.txt mapping file. If you do not want this to happen, then export the qv.txt from Archivist first, then update this before importing.
...
Questions and variables which are mapped together must have the same topic. Questions which are mapped to a variable which has been linked to a topic, will automatically inherit that topic from the variable. After the question to variables mappings have been imported successfully, it makes sense to add the variable topic mappings in which the questions will inherit those topics. These are loaded by navigating to Admin > Datasets> search for the dataset prefix > IMPORT MAPPINGS. Choose files and select the tv.txt file you want to import. See format specifications below for details of the tv.txt file. You can also select to import derived variable mappings dv.txt at the same time. From the dropdown select whether the file is T-V Mapping or D-V Mapping. Note: the Heroku in-out-worker server must be turned on for the files to be imported. The state will change from pending, to running, then to success or failure once imported. If the state is failure, VIEW LOGS under Actions. The state will be failure if the whole file fails or if there is only one invalid record (row) in the file.
...
- Topics conflict - questions and variables which are mapped together must have the same topic. If a different topic has already been assigned to a question which has been mapped to that variable this will be invalid
- If a variable has been mapped to 0 .(no topic)
Depending on the number of invalid records, if there are only a couple of issues, then you can fix these by using the Archivist interface see Map Questions, Variables and Topics, If there are many, systematic or file related issues, then update the tv.txt file and re-import.
Note: When re-importing, the previous previously imported topic mappings will not be replaced unless they have been updated in the file.
Note: All manual mappings will be replaced by the imported tv.txt mapping file. If you do not want this to happen, then export the tv.txt from Archivist first, then update this before importing.
...
Question to Topic mappings
After the question to variables variable mappings have been imported successfully, you can import the tv.txt mappings files as above, alternatively if you only have question to topic mappings, or you have both tv.txt and tq.txt you can import those next or at the same time.
...
Note: If you map to 0 (i.e. no topic), this will give an invalid error, but it will map the question to 0, this way you can reset the mapping back to no mappings. This is not the same as None topic.
Note. : When re-importing, the current question to topic mappings will be replaced, so you must include all the question to topic mappings you want to import in the file, not only the records (rows) you want to update.
Note. : All manual mappings will be replaced by the imported tq.txt mapping file. If you do not want this to happen, then export the tv.txt from Archivist first, then update this before importing.
...