Merge Questionnaires in new level using id... (AskiaTools)
Use this feature to create a new loop in a questionnaire, containing data from a (flat) sub-questionnaire. This merge operation will import the secondary *.QES file's data and its data-entry mask into the primary *.QES file, listing it at the end of its pre-merge data-entry mask. Furthermore, interviews possessing an identical ID will be merged into a single and unified interview sheet.
Note: this operation can also be carried out using the
command line.
For example:
- primary *.QES contains 10 interviews. The ID of interview 7 is "ABC".
- secondary *.QES contains 5 interviews. The ID of interview 3 is ABC".
Note: it is possible to specify a name for the loop that will be created by using the command line to invoke this command. For example:
AskiaToolsU.exe "C:MyQesThis qes.qes" /importinnewlevel /idQuestion:"ID" /shortcut:"newloop" /sourcepath:"C:MyQesAnother qes.qes" /sourcetype:2 /sourcesurveyconnection:"a connection to a DB" /sourcesurveyid:3
The keyword
shortcut allows you to specify the loop name (in this case
newloop). For more information on using the command line, see the following Knowledge Base article:
AskiaTools : Automate tasks via Command line.
In this example, AskiaTools will merge the data of both interview sheets, and so the resulting primary *.QES file's interview sheet 7 will contain its own pre-merge data plus the new data which came from the source *.QES file’s interview sheet 3.
To merge questionnaires using IDs:
-
Open the primary *.QES file, which will contain all merged data.
-
In the merge menu, select questionnaires using id.
-
In askia file, click 
to select a secondary *.QES file, or 
to select an AskiaField task. If you select the latter, the AskiaField tasks dialog appears.
-
In interviews, select the type of data source: QES file, SQL server (legacy format), SQL server (new format) or inverted database.
-
In identifiers, select the question containing respondent IDs in your target (primary) QES, and then the question containing respondent IDs in the data source. AskiaTools expects the ID to be unique in the target and to have duplicates in the source.
-
Finally, click OK.
AskiaField tasks dialog
If you choose to merge data from an AskiaField task, you can specify the task details here. The available options are:
| Option |
Description |
|
Connection to AskiaField database
|
Enter the connection string to the call centre database.
|
|
Surveys
|
Select the survey from which you want to import data (once you have entered a connection string into connection to AskiaField database, described above).
|
|
Askia file
|
Specify the QES file associated with this survey. To browse for the file, click ....
|
|
Connection to surveys database
|
Enter a reference to the database's DSN, in the following format:
;DSN=BDDASKIA
|
|
Survey ID
|
Enter a unique identification number for this project.
|
|
Interviews storage
|
Select the location where the interview data is stored. This can be the QES or the SQL server (in either legacy or new formats).
|