Versions Compared

Old Version 1

changes.mady.by.user Hayley Mills

Saved on

compared with

New Version Current

changes.mady.by.user Becky Oldroyd

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Populate database

There are two steps to populate Archivist.

  1. Insert questionnaire information tables into database.
  2. Use above tables to build the correct relationships.

Temporary tables

We will need to extract the following information from the digital questionnaireThe following information needs to be extracted from the questionnaire.

Please find the explanation for Archivist Questionnaire Elements

  1. Sequence
  2. Statement
  3. Question item
  4. Question grid
  5. Code list
  6. Response
  7. Condition
  8. Loop

The table structure and example are given below, but please see https://gitlab.com/jli755/archivist_insert_workaround/-/tree/master/template for the latest version.

The checklist will also help with finding any potential problems. 

Info
titleNaming
LabelStarts WithExampleLabel Note
Statements_qs_qQual
Question item qi_qi_Smoker

Question grid 

qg_qg_Qual
Code list cs_cs_Yes_No
Conditionc_qc_qSmoker

Labelled after the question in the condition logic.

If there isn't logic then it should be labelled after the first question inside the condition.

In case of duplicated labels: c_qSmoker_i, c_qSmoker_ii etc.

Loopl_ql_qSmokerLabelled after the first question inside the loop.


  • Branch in conditions 0 is true 1 is else.  i.e. if the parent_type is condition, and it if a true branch, then branch = 0 for that question/statement ..



Format of each table

This is a sample questionnaire:

...