Page Comparison

...

The process can be less manual by using the .txt files described below. The format specifications are given at the end of the page, along with examples.

• mapper.txt Question and sequence list produced by Archivist
   
• qvmapping.txt Mapping file which links questions and variables (listing all variables and derived variables)
• dv.txt Mapping file which links derived variables to variables
• tqlinking.txt Mapping file which links topics and questions
• tvlinking.txt Mapping file which links topics and variables

...

The Q-V mappings can also be checked through Admin > Instruments > search and select the Prefix of the instrument. This will gives the questionnaire view with the variable names listed against them

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.

...

• Tab delimited
• Must include all variables including derived variables
• 2 columns
  • qc
    • question Question name
    • ‘0’ if mapped to nothing
    • ‘0’ if derived variable
    • [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.
  • variable Variable name

tvlinking.txt

• Configuration file
• Tab delimited
• Used for applying level 1 & 2 topics to variables
• Uses Colecitca topics IDs
• 2 columns
  • variable Variable name
  • topic 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

...