topic Re: SPSS file in Talend Studio

SPSS file

Anonymous — Sat, 16 Nov 2024 02:49:25 GMT

Please can anyone help me i really need it

Load Data into database mysql from file spss

i already do for excel file.

help me please

Re: SPSS file

Anonymous — Wed, 01 Apr 2020 04:40:41 GMT

Hi
Take a look at the SPSS components and learn the scenario.
https://help.talend.com/reader/1lUpv~2pBEhtc6fvQwPFhw/US~IomevrLc7LZecQZ24nQ

Regards
Shong

Re: SPSS file

Anonymous — Wed, 01 Apr 2020 14:47:13 GMT

oh thank your reply
i think i can already do that
1°) How to dysplay an spss file
2°)how to write in an.sav file

so my question is :
i have an spss fil and i want to integrat the data into MySQL table database
Best regards

Re: SPSS file

Anonymous — Thu, 02 Apr 2020 09:01:43 GMT

Hi
Are you able to read data from an .sav file now? If not, follows the scenario using tSPSSInput component in this documentation page and learn it.
https://help.talend.com/reader/1lUpv~2pBEhtc6fvQwPFhw/aqcDs4HDZ~uySbMUYGRcZQ
After you read the data from .sav file, link the tSPSSInput component to a tMySQLOutput for inserting or updating the data to Mysql database. eg:
tSPSS--main--tMysqlOutput

Regards
Shong

Re: SPSS file

Anonymous — Thu, 02 Apr 2020 19:40:33 GMT

hi i am so happy for your help
so definitely i have an error please look at the files attached

My spss file contains named variables from A to H
I want to put each group of variables in a mysql table
for example (file attached =captureBD)

Best regards

erreur.JPG

Re: SPSS file

Anonymous — Tue, 07 Apr 2020 03:39:58 GMT

Hi bayeManel
I have no idea on the NPE error, it is not a job design issue, if you are a Java developer, you can launch the Java debug model and debug the Java code to see if you could find any hits.

Regards
Shong

Re: SPSS file

manodwhb — Tue, 07 Apr 2020 03:45:45 GMT

tsspinput component is giving null pointer exception..
You need to share the configuration of tsspinput, have you not specified something like host or port or username or password or object name.