Hi SPSSX list...I also have an XML into SPSS question. My XML is of the
following format:
<DATA_EXPORT>
<HEADER>
<RECDATE>
<START>2012-01-01</START>
<END>2012-01-01</END>
</RECDATE>
<SURVEY_COUNT>999</SURVEY_COUNT>
<QUESTION_MAP>
<QUESTION>
<SERVICE>SERVICE</SERVICE>
<VARNAME>AGE</VARNAME>
<QUESTION_TEXT>Age</QUESTION_TEXT>
</QUESTION>
<QUESTION>
<SERVICE>SERVICE</SERVICE>
<VARNAME>B2</VARNAME>
<QUESTION_TEXT>Daily cleaning of your room</QUESTION_TEXT>
</QUESTION>
<QUESTION>
<SERVICE>RH</SERVICE>
<VARNAME>SECTREDR</VARNAME>
<QUESTION_TEXT>Rehabilitation Doctor Section Comments</QUESTION_TEXT>
</QUESTION>
</QUESTION_MAP>
</HEADER>
<PATIENTLEVELDATA>
<SURVEY_ID>69999999999</SURVEY_ID>
<CLIENT_ID>999</CLIENT_ID>
<SERVICE>SERVICE</SERVICE>
<RECDATE>2012-01-01</RECDATE>
<DISDATE>2012-01-01</DISDATE>
<ANALYSIS>
<RESPONSE>
<VARNAME>B2</VARNAME>
<VALUE>5</VALUE>
</RESPONSE>
</ANALYSIS>
<DEMOGRAPHICS>
<RESPONSE>
<VARNAME>AGE</VARNAME>
<VALUE>99</VALUE>
</RESPONSE>
</DEMOGRAPHICS>
<COMMENTS>
<RESPONSE>
<VARNAME>SECTREDR</VARNAME>
<SENTIMENT>Negative</SENTIMENT>
<VALUE>I wish someone would have given us a general overview of what to
expect at the beginning so we knew what I was coming.</VALUE>
</RESPONSE>
</COMMENTS>
<HCAHPS>
</HCAHPS>
</PATIENTLEVELDATA>
</DATA_EXPORT>
I'd like to turn the above into an spss readable file, e.g., something like...
SURVEY_ID,AGE,B2,SECTREDR,SENTIMENT
69999999999,99,5,I wish someone would have given us a general overview of
what to expect at the beginning so we knew what I was coming.,Negative
I've tried using the SPSS Data Pack XML driver, but it seems to be broken in
some fashion (when I try to add the XML driver through ODBC, I click on the
Add button to add a location name and nothing happens - I assume another
popup with a browse-to file type dialogue should appear,and therefore can't
add the driver).
Thanks for any help,
dbrewingto
SPSS 21
Release 21.0.0.0
32-bit edition
Win 7
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
