Exporting data to Triple-S (*.sss) (AskiaTools)

Use this feature to export data from a QES file or SQL database to Triple-S (*.sss) format. Both classic Triple-S and XML Triple-S 2.0 are supported.

Note: When askiatools creates a *.sss file, it exports the data-map as an *.asc file. Both are stored in the same location.

To export data in triple-S format:

  1. In the file menu, select export, then triple S....  The triple-S export dialog appears:
  2. Set the options as described below.
  3. Click OK to proceed. If you opted to export a selection of questions (rather than all questions), you are now presented with a list of the questions in your QES:
  4. Copy the questions you want to export to the right-hand list, by using the following buttons:
    move_right Copies the selected question to the right-hand list;
    move_all_right Copies all questions to the right-hand list;
    move_left Removes the selected question from the right-hand list;
    move_all_left Removes all questions from the right-hand list.
  5. Once you are satisfied with the questions you have in the right-hand list, click OK. Your data is exported to triple-S format.

Triple-S export options

Option Description

Triple-S file

Type the path and filename of the output file (where the data will be stored), or click ... and specify the path and filename in the file dialog.

Classic triple-S/XML Triple-S 2.0

Select the triple-S format you wish to export to.

Replace spaces and forbidden characters in shortcuts

In Triple-S, shortcuts may contain only letters (A-Z, a-z) and digits (0-9), underscore (_) or period (.) characters. Select this if you wish to replace any spaces and other forbidden characters in your question shortcuts with underscore characters.
Export questionnaire in Unicode

Select this if you wish to export the metadata (the questionnaire) in Unicode format. The encoding will be displayed in the XML as UTF-16LE or UTF-8 as appropriate.
Use short captions when available

If you select this option, short captions will be exported where they exist on a question; if a short caption is not present on a question, the question's long caption will be exported.

If this option is not selected, long captions will be exported.

Export data in Unicode

Select this if you wish to export a Unicode data file (for non-Latin alphabets).

Export questions: All the questions in the datamap/A Selection of Questions

Select which questions you wish to export: all questions in the datamap, or a selection of specific questions (you will be able to specify these questions later in the export process).

Click view datamap... to inspect or edit the datamap.

Export completes only

Select this option if you want to export completed interviews only.

Interview started after

Allows you to export interviews that were begun after the specified date. You can, therefore, use this feature to export new data that has been collected since a previous export.

Additional filter

Allows you to specify a custom data filter by specifying an AskiaScript condition. Click ... to open a secondary dialog where you can define your condition.
Create your own Knowledge Base