PM67314: EXCEL FILES DO NOT ALWAYS OPEN CORRECTLY IN SURVEY REPORTER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • If an Excel file or worksheet name contains an ampersand
    character, the data will not load into Survey Reporter at all.
    In some cases, characters that are invalid in variable names
    will cause problems after opening the worksheet in Survey
    Reporter.  Spaces and non-alphanumeric characters may need to be
    removed manually.
    

Local fix

  • Edit the Excel worksheet to normalize the variable names before
    loading into Survey Reporter, and remove any ampersands from
    worksheet names or file names.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IBM SPSS Data Collection                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If an Excel file or worksheet name contains an ampersand     *
    * character, the data will not load into Survey Reporter at    *
    * all.                                                         *
    * In some cases, characters that are invalid in variable names *
    * will cause problems after opening the worksheet in Survey    *
    * Reporter.  Spaces and non-alphanumeric characters may need   *
    * to be                                                        *
    * removed manually.                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Install IBM SPSS Data Collection 7.0                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM67314

  • Reported component name

    SPSS SURVEY RPT

  • Reported component ID

    5725A78RD

  • Reported release

    601

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-20

  • Closed date

    2013-09-09

  • Last modified date

    2013-09-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R700 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Data Collection
Survey Reporter Desktop

Software version:

6.0.1

Reference #:

PM67314

Modified date:

2013-09-09

Translate my page

Machine Translation

Content navigation