Who is this article for?

Users responsible for managing the export of Questionnaire data

Model Administrator permissions and Ideagen Healthcare Guardian v24+ access are required.

This article shows you how to configure a bespoke questionnaire data export. A questionnaire will export all instances from that have been updated for your chosen questionnaire(s) and date range.

1. Open Healthcare Guardian Administrator > Export > Export Questionnaire Data

2. In the Questionnaire dropdown, select the questionnaire(s) to export 
3. Click Add to Export

4. Select the data range you are interested in 

   This Year = This Financial Year

   This Year to Date = This Year to Current Date

   Range from current date (e.g. n before current date and n after current date)

   Specific Range

5. Choose the specific options you want to include / not include in your export.  
   (as a minimum, we recommend Export Repeating)

6. Click Export

7. The export will download into your locally configured Downloads folder

The export format is designed for data warehouse reporting and therefore uses a consistent structure, with one row per questionnaire question. This ensures that the exported columns remain the same regardless of which questionnaire is being exported.
 
In contrast, a column-pair or single-row export format can become unreliable when questionnaires contain multiple repeating sections. Because questionnaires can have varying numbers of sections and questions, the warehouse export represents each question as a separate row, resulting in multiple rows for a single questionnaire instance if something closer to the example provided is important.
 
While a single-row or column-pair approach may be suitable for simpler reporting and incident trend analysis, questionnaires with multiple repeating sections introduce one-to-many relationships. These can lead to cross-join issues, making it difficult to produce a clean and reliable export. 
 
The warehouse export approach is specifically designed to avoid these issues and provide a consistent dataset for reporting and analysis.