Exporting My Raw Data

You can export the raw data from your project as SPSS files (snytax and ASCII data file, or SAV file) or you can schedule recurring Excel/CSV exports. Use the steps below to configure and send your data exports.

1: SPSS Export

To export your data as an SPSS file, open the ADMINISTRATE area. Select Data Sources from the left side menu, then select SPSS Export from the tabs at top.

Select from the following options to prepare your export:

1. Select your Export Type:

   • Syntax (SPSS syntax)

   • Spss file (SPSS data)

2. Select what content to Include (only when Spss file is selected):

   • Looped data: Adds and creates an additional file, per loop existing in your project, to the SPSS export.

   • Open ended variables: Adds all the open-ended questions in your project to the SPSS export. Including open-ended variables will cause a substantial increase in the file size, resulting in longer export times.

   • Computed and Merged variables: Adds all the Computes and Merged variables in your project to the SPSS export.

   • Input variables: Adds all the Input variables in your project to the SPSS export.

   • DCM data: Adds and creates an additional file, per DCM test existing in your project, to the SPSS export.

   Note: Stacked and standard data cannot be combined in a single file due to different data structures.

3. Select your Decimal separator for open numeric questions:

   • Dot (.)

   • Comma (,)

4. Identify your Multiple choice question separator. You may use any separator that makes sense, such as #, r, ., etc.

   Note: Multiples are dichotomized in the SPSS exports. Each variable is marked code 1 if selected by the respondent:

   

5. Add the Email address where you want the link to the export to be sent.

6. Update the Subject line as desired. Use the following variables in the Subject to auto-populate the information when the e-mail is sent:

   • [domain]: the URL from which the export was requested

   • [project]: the name of the project

   • [link]: the link for the data export file

   • [password]: the password for the zip file

7. Update the Text (body) of the e-mail as desired. Use the following variables in the Text to auto-populate the information when the e-mail is sent.

   • [domain]: the URL from which the export was requested

   • [project]: the name of the project

   • [link]: the link for the data export file

   • [password]: the password for the zip file

2: Excel Export

To export your data as an Excel or CSV file, open the ADMINISTRATE area. Select Data Sources from the left side menu, then select Excel Export from the tabs at top.

Excel Exports can be a one-time export or a recuring export with saved schedules and settings.

Select from the following options to prepare your export:

To create a new Export Schedule, first provide the following information:

1. Name: Give a name to your export to identify this schedule separate from others.

2. Active: Toggle this switch on to run your export by the scheduled time.

3. Schedule type: Choose from the following options. The selected time is based on the server's timezone, not your local timezone.

   • Single: Select the Date, Hour and Minute to run the report.

   • Weekly: Select the Day(s) of the week and the Time to run the report.

   • Monthly: Select the Day of the month and the Time to run the report.

   Once you save your active export, the Next scheduled export date will display.

In the next section, set up the Data Structure for your export:

1. Format:

   • Excel

   • CSV

2. Separator (CSV only): Select between Tab, , (comma), or ; (semi-colon).

3. Column labels: Use the drop-down to select how you want the columns to be labeled:

   • Variable text: Use the text of each question (variable) as the column label.

   • Variable code: Use the code for each question (variable) as the column label.

4. Export categorize variables with:

   • Values: The numeric codes assigned to each categorical response. For example, a coffee question with answers 1=Forsta Fika, 2=Espresso Express, and 3=The Busy Bean uses the values 1, 2 and 3 in the export.

     

   • Value labels: The text descriptions assigned to each categorical response. For example, a coffee question with answers 1=Forsta Fika, 2=Espresso Express, and 3=The Busy Bean uses the labels Forsta Fika, Espresso Express and The Busy Bean in the export.

     

5. Variables: Select the questions (variables) to include in the export. The number of variables selected will display.

   • Toggle on to select All variables

   • Toggle off All variables and click Select variables.... A new module displays at the bottom of the screen. Scroll through the list to select specific variables.

6. Add filters: Apply filters to limit the data included in the export. The number of filters selected will display. Click Select filters.... A new module displays at the bottom of the screen. Scroll to select the desired filter categories. See Defining Filters to learn how to add filters to your project.

7. Select time period:

   • Static date range...: Use the calendar to select when the time period Starts and Ends. The export includes the start and end dates.

   • Year-to-Date: Exports any data from the beginning of the year through the date of the export.

   • Full Period: Includes data from all dates.

   • Select last X periods...: Select the Amount of periods and the length of each Period (Day, Week, Month, Quarter, Half year, Year, Full period).

Then, add the File Transfer Settings. Your file is exported to the server you add here:

1. Protocol: Select between FTP, FTPS, or SFTP.

   • When exporting using FTP, the maximum length of the path is 50 characters. Whitespaces are not allowed.

2. Server address: Add the server address.

3. Server port: Add the server port. The default is 21.

4. Username: Add the username.

5. Password: Add the password.

6. Data file name: Provide the name of the file you want to use. You can use the following terms in your data file name to automatically name the file based on the day and time of the export.

   • {day}

   • {month}

   • {year}

   • {hour}

   • {minute}

   For example, using the Data file name DataExport_{year}{month}{day}_{hour}{minute}.xlsx will export an Excel or CSV file named DataExport_20270915_1600.xlsx

Email notifications

1. Contact email: Add the email address where notifications should be sent. Notifications are only sent if one or more of the following toggles are switched on.

2. Send email after job completion: Toggle on to send an email when the file is exported.

3. Send email on job failure: Toggle on to send an email if the file fails to export.