Dapresy Pro supports the data import format Triple-S. Triple-S is a market research standard for transferring data and meta-data between different types of software and applications.
The same features and logic are applied to the imported Triple-S data as are currently applied to SPSS (.sav) imports. This means that both the Meta-data Transformation Module and the automated/scheduled data imports also support the Triple-S format.
- The Triple-S import requires two files, a XML file with meta data and a ASC file with case data, the files need to be compressed to one zip file (.rar is not supported).
- The data file must be of “Fixed width”, Triple-s files in CSV format is not supported
- Multiple choice questions can either be binary or categorical in the imported file, Dapresy Pro can handle both formats
- If the imported Triple-S file contains multiple languages the first language in the file will be used in Dapresy Pro
- In the Triple-S standard a third file showing hierarchical structure between groups exist, this file is not supported, instead the hierarchical structure is defined within Dapresy Pro itself
- In the Triple-S standard the values (answer alternative codes) can be alphanumeric, Dapresy Pro only supports numeric values
- All case data in categorical variables that have no corresponding value labels in the meta data will automatically be deleted during import and not considered in any calculations
- Value labels must be unique within each variable. In the Triple-S standard duplicates are allowed but it is not supported by Dapresy Pro
- If the imported file contains duplicates the text can be corrected by using the existing Meta-data Transformation Tool
- All variable texts, value label texts and variable type (Single choice, Multiple choice, Numeric and String) are picked from the imported XML file
-Text can be updated within Dapresy Pro
-Question type cannot be updated within Dapresy Pro
- All values/value labels in the XML files will be imported to Dapresy Pro, even the standard codes like 99999998 and 99999999 which are used as Missing values in Triple-S standard.
-On the import screen the user can select to exclude those variables in the import to get correct base sizes in the calculations if those values should not be considered.
In addition to the above requirements the imported file must contain three standards variables Respondent ID, Response date and Weight.
- A unique respondent ID (a Numeric variable with the Name “RespondentID”)
- A response date (a Date/Time variable with the Name “Responsedate”)
- A respondent weight (a Numeric variable with the Name “Weight”)
If the file does not contain one or several of the three variables above the Meta-data Transformation Tool can be used for creating those variables. If the date/time variable is a string variable in the imported XML files a feature in the Meta-data Transformation Tool can convert string to date.