Page Comparison

The mapping 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 
• mapping.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 above .txt files will be available to view in Archivist by adding them to the url of the instrument. Currently only mapper.txt and mapping.txt are availableCurrently the .txt files, mapper.txt and mapping.txt are available to view in Archivist, as detailed below.

Note: you must be logged into Archivist to view the below pages.

...

The question to variable mapping.txt (once applied) can be viewed in Archivist by navigating to the instrument view and then adding /mapping.txt to the web address e.g.https://archivist.closer.ac.uk/instruments/alspac_01_rat/mapping.txtNote: All the .txt mapping files detailed above will be available to view in Archivist v.10 (the current version can be found under Info).

The following steps can be used to upload mappings via the .txt files.

...

Format specifications:

mapper.txt

Question and sequence list produced by Archivist.

• ID (qc or URN)
• Type (“Question” or “Sequence”)
• Grid limits or “-“ for null ([Y,X])
• Parent (URN)
• Text (Literal or Sequence name)

mapping.txt

Mapping file which links questions and variables (listing all variables and derived variables).

• 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. Please refer to the Grid coordinates table on the condition page for how to reference grid cells.
  • Variable name

tvlinking.txt

...

Mapping file which links topics and variables.

• Tab delimited
• Used for applying level 1 & and 2 topics to variables
• Uses Colecitca topics Colectica topic IDs
• 2 columns:
  • Variable name
  • Topic ID

 tqlinking.txt

Mapping file which links topics and questions.

• Tab delimited
• Uses Colecitca topics Used for applying level 1 and 2 topics to variables
• Uses Colectica topic IDs
• 2 columns:
  • qc (question identifier)
  • Topic ID

dv.txt

Mapping file which links derived variables to variables.

• Tab delimited
• Only includes derived variables
• 2 columns:
  • Derived variable name
  • Source variable name

...