Skip to main content

FV Decipher Support

All the topics, resources needed for FV Decipher.

 
FocusVision Knowledge Base

SPSS Data Importer

The SPSS Data Importer can be used to import existing offline data into Crosstabs.

1:  Importing an SPSS File

Tip:  It is best to clean your SPSS file prior to uploading:
 - Remove any notes from labels
       - Be sure to specify the correct data type and value labels
       - Remove any unwanted variables

To upload an SPSS file, log into the Research Hub and select the "New Project" button.

In the "New Project" window, enter a project name and select "Import SPSS File" from the dropdown.

Optionally, click the "Project Info" link and enter a description and add tags, then select "Import SPSS File."

Click "Choose File" or simply drag the SPSS (.sav) file into the window.

Once the file has been selected, click "Load SPSS File."

When the file is loaded successfully the data will appear in the data importer, allowing you to edit and manage your data before saving it as a report.

If your file does not load, please review the Limitations & Assistance.

2:  Data Importer Overview

2.1:  File Name & Information

The top portion of the SPSS Data Importer contains the project name and information about the SPSS file.

  • Project Name:  The name of the project that's used in the Portal.
    • To edit the project name, simply click on the text and enter a new name in the field.
  • File Name:  The name of the imported file.
    • To permanently remove or replace, click on the X and follow the instructions.
  • File Size:  Lists the size of the file.
  • Variables:  The number of variables in the file.
  • Respondents:  The number of respondents in the file.

2.2:  SPSS Data Variables

The main body of the importer contains the data that was imported from your SPSS file.

All respondents are imported as "qualified" for purposes of reporting.

  • Select Variables:  Check to select variables to edit. Check the box at the very top to select all variables.
  • Variable:  Contains the variable name.
    • To edit the variable label, click on the question text and enter the change.
  • Question Text:  Contains the question text.
    • To edit, click on the question text for a variable and make changes to the variable label, question type or question text, and choose if you want it included in the report. If changes are made, click "Save."
  • Question Type:  Contains the type of question. The importer applies a question type to each variable in the SPSS file.
    • To edit the question type, click on the dropdown menu and selecting the desired type.
      • Single-Select:  A question that permits one response.
      • Multi-Select:  A question that permits multiple responses.
      • Text:  An open-ended question that permits an alpha-numeric response.
      • Number:  An open-ended question that permits a numeric response.
      • Float:  An open-ended number question that allows decimal places or negative numbers.
  • Values:  Contains the reporting values. Hover-over the values for a variable to view the corresponding answer options. (Not editable at this time.)

2.3:  Editing Variables

When one or more variables are selected you can add them to new or existing groups, change the question type or include/exclude them from the import.

Select variables to enable these controls.

  • # Selected:  When variables are selected, the total is shown here.
    • Unselect:  Click to uncheck selected variables.
  • New Group:  Select variables of the same type, click "New Group" and enter the group label and question text to create a new group. Then click "Save."
  • Add to Group:  Allows you to add the selected variables to an existing group. The importer will place variables into a group if those variables are similar (e.g., if the variables reference the same question number).
  • Change Question Type:  When multiple variables are selected, this allows you to change the question type of all selected variables.
    • Single-Select:  A question that permits one response.
    • Multi-Select:  A question that permits multiple responses.
    • Text:  An open-ended question that permits an alpha-numeric response.
    • Number:  An open-ended question that permits a numeric response.
    • Float:  An open-ended number question that allows decimal places or negative numbers.
    • Troubleshooting:  You must choose one of the above question types.  If the question type is "unknown," the file will not be accepted.
  • Ungroup:  Select a grouped variable and click "ungroup" to break down the group.
  • Include:  Select an excluded variable and click "Include" to include it in the data that is imported to crosstabs.
  • Exclude:  Allows you to exclude the selected variable(s) when the data is imported to the report.
  • Show/Hide Excluded Variables:  Excluded variables are shown in grey font. Uncheck the box to hide them from view completely.

2.4:  Save & Import

Click "Save" to save your changes as you edit the data. Once the changes are complete, click "Import" to import the data to Crosstabs.

3:  Edit an SPSS Project

To edit the SPSS variables, locate the project in the Research Hub and select the menu icon. Under "Actions," select "Edit SPSS Variables."

The data importer opens with all of the editing options explained in section 2, above.

4:  Limitations & Assistance

SPSS files may not always upload the first time around. SPSS files are wildly different depending on vendor and SPSS version. This is a known issue and not something Decipher can control. Decipher offers services for debugging and troubleshooting these errors. For assistance on SPSS upload, please reach out to your account team for a cost estimate.