Quantum / SAS

Note: When the target type selected is SAS, the Loop Handling and Position of Loop Variables options will also be available.

Figure 1 - The Target tab when Quantum or SAS is selected

When Target Type is set to Quantum or SAS, the properties and options available on the tab - - are as follows:

• Truncate Open Ends - For Open Ends (Open Text questions with no field width specified), it is recommended to truncate texts to improve performance. If a number of characters is specified for the Open Ends Width, texts longer than this limit, if any, will automatically be truncated. If No Truncation (Full Length) is selected, the whole text will be imported/exported, but the task will take significantly longer to execute.
• Encrypt File - data transfer encryption functionality makes it possible to perform secure data exports from Forsta Plus. The encrypted files can then be either ordered by email or sent to the FTP server for downloading. The users will have to decrypt the files using their private PGP encryption keys.
• Email Address - if the file is to be sent via email, this is the recipient's email address. Default is the current user's (yours).
• Loop Handling - [SAS only] this option is only available if the project included loops. Here you specify how loops are to be handled for the export. The options are:
• Separate files - the default export format for loops creates one export file for each loop, and one export file for the top level. In the files containing the loop data there will be one row per loop iteration per respondent, so there will be several rows for each respondent. Each row will have the responseid (system generated respondent id) of the respondent and the code of the loop id for the iteration as identifiers, and then the answers for the questions inside the loop for that specific iteration for that respondent. This means you can export a hierarchical project without having to generate a flattened template.
• Single file - Instead of exporting loop data as separate files, you can export all data belonging to a project in one single file. Loop data will then be expanded. This means that variables will be created to represent each iteration of each question.
• Position of Loop Variables - [SAS only] only available when Single file is selected in the Loop Handling option. This allows the user to specify in which position the loop variables should be exported. The options are:
• Appended at end - the loop variables are appended at the end of the template.
• As in Questionnaire - the loop variables are positioned as the corresponding loop was placed in the questionnaire.
• Recode Multis - check this box to recode value codes for non-sequential multi variables. For example, a multi variable with the answer codes 1, 2, and 99 will normally use 99 positions in the export, although only three are actually required. Check the box to recode the variables such that they will have the value codes 1, 2 and 3. The variable will then use only three positions. If you have many multi variables with non sequential codes, selecting Recode Multis will greatly reduce the size of the exported file.
• File Transfer - export files can either be sent by email or placed on a Forsta or External FTP server. FTP may be a good option for large volumes of data, since emails with large attachments may be blocked. FTP can allow automation of data flows, since files can then be picked up automatically by another system/process. In the event External FTP is selected, the file name, Folder Name (at the external FTP location), the Host Name, and the FTP User name and Password must be specified. The Verify connection button is provided to allow you to check whether the FTP settings are correct. Note that your company must license the FTP add-on for the FTP options to be available (refer to the Professional Authoring documentation for more information).
• Override Email Options - when selected, allows you to override the standard export email options and customize both the subject and the email that will be sent to the export recipient. Checking this box displays a number of additional options.
• Override Filename - allows you to override the system-generated file name. Tick this check-box to open the file name text-box. Here you can edit the system-generated name. Note that when exporting Survey Data to the FTP server in Survey Data > Exports or Data Processing rules, the Override Filename option accepts relative paths, as for example “..\..\myftpfile_in_another_folder.txt”. In this case the file will not be stored in the default folder (“ProjectsData\p123123” or “RulesData\RuleN”), but rather directly under the (Company) Download folder.

Note: The Filename template must contain the '_^PROJECTID^_' part of the name as this will be replaced by the real project id during rule execution. Default is ^PROJECTID^_^USERID^_^TASKID^.