Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tSPSSInput throwing blank rows

Hi, 
I'm trying to convert *.sav SPSS file data to Excel/CSV format. tSPSSInput component can extract .sav file schema but returns blank values for each column to tLogRow. 
These are the SPSS files: 

I'm using Talend Open Studio for Data Integration 6.3.1.20161216 on Windows 7, 64 bit with JVM 32 bit. Talend installation directory TOS_DI-20161216_1026-V6.3.1 is containing Spssio32.dll file. My simple Talend job screenshot is attached for reference. Appreciate any clues on this. Thanks

Regards, 

Farakh
0683p000009MGGQ.png
0683p000009MGGV.png

Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi,
Have you already checked the usage in component reference: TalendHelpCenter:tSPSSInput?
Before being able to benefit from all functional objectives of the SPSS components, make sure to do the following: -If you have already installed SPSS, add the path to the SPSS directory as the following:  SET PATH=%PATH%;<DR>:\program\SPSS , or -If you have not installed SPSS, you must copy the SPSS IO "spssio32.dll" lib from the SPSS installation CD and paste it in  Talend  root directory.
Let us know if it is Ok with you.
Best regards
Sabrina
Anonymous
Not applicable
Author

Thanks Xdshi, 
I reproduced the steps mentioned in the article you are referring to. Let me know if you want me to upload the Talend file. I don't have SPSS installed. I downloaded spssio32.dll from internet. 
Anonymous
Not applicable
Author

Hi,
If you have not installed SPSS, you must copy the SPSS IO "spssio32.dll" lib from the SPSS installation CD and paste it in Talend root directory. Have you tried this step?
Best regards
Sabrina