topic Re: tSPSSInput throwing blank rows in Talend Studio

tSPSSInput throwing blank rows

Anonymous — Mon, 13 Feb 2017 16:35:53 GMT

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

Re: tSPSSInput throwing blank rows

Anonymous — Tue, 14 Feb 2017 03:00:58 GMT

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

Re: tSPSSInput throwing blank rows

Anonymous — Tue, 14 Feb 2017 17:53:52 GMT

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.

Re: tSPSSInput throwing blank rows

Anonymous — Wed, 15 Feb 2017 10:02:53 GMT

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