topic Re: Import CSV file to Postgres with Talend in Talend Studio

Import CSV file to Postgres with Talend

Anonymous — Sat, 16 Nov 2024 11:37:26 GMT

I tried to import a CSV file in my table on PostgreSQL. I used Tmap to match the fields but when I launched the process I got this error:
Exception in thread "main" java.lang.Error: Compilation problem not solved: Invalid character constant
The error I get is too generic to understand. How can I do to investigate the problem?

Re: Import CSV file to Postgres with Talend

Anonymous — Tue, 03 Jun 2014 15:56:34 GMT

https://community.talend.com/t5/Design-and-Development/resolved-Need-help-with-quot-Invalid-character-constant-quot/td-p/102870

Re: Import CSV file to Postgres with Talend

Anonymous — Wed, 04 Jun 2014 05:44:11 GMT

Can you post your statement expression used in tMap?
Vaibhav

Re: Import CSV file to Postgres with Talend

Anonymous — Wed, 04 Jun 2014 07:39:57 GMT

Hi romidipa,
You'll get a Image upload box that allows to upload screen captures and images up to 200KB, when you click on "post reply" (not through the quick post").
Best regards
Sabrina

Re: Import CSV file to Postgres with Talend

Anonymous — Wed, 04 Jun 2014 09:37:34 GMT

I put the pictures which I hope will help to understand the problem

Re: Import CSV file to Postgres with Talend

Anonymous — Wed, 04 Jun 2014 09:39:24 GMT

I put the pictures which I hope will help to understand the problem..
this is my csv
alleg_id;alleg_categoria;alleg_allegato;alleg_descr_breve;alleg_progetto;alleg_sostituito;alleg_categ_sostituita;alleg_aria;alleg_acqua;alleg_territorio;alleg_ordina
60;B1.10;B1;Progetti di infrastrutture - linee ferroviarie a carattere regionale o locale;linee ferroviarie a carattere regionale o locale;1;B1.10;1;1;1;65
61;B1.11;B1;Progetti di infrastrutture - funicolari o linee simili di tipo particolare;funicolari o linee simili di tipo particolare, esclusivamente o principalmente adibite al trasporto di passeggeri (vedi cat. B3, n. 6);1;B1.11;1;1;1;66

Re: Import CSV file to Postgres with Talend

Anonymous — Wed, 04 Jun 2014 09:50:22 GMT

I think there is a trouble in metadata creation,
your input columns are 9 - as per csv data
and data shows - 11
tMap shows - 10
Please fix this, however, you don't need tMap, as there is no processing involved... You can remove that...
Vaibhav

Re: Import CSV file to Postgres with Talend

Anonymous — Fri, 06 Jun 2014 09:43:02 GMT

Now there are 11 field in csv, in pg table e in tmap process. I removed the id serial in postgresql table nevertheless i get this error
Exception in component tMap_1
java.lang.NullPointerException
at demos.csv_table_0_1.csv_table.tFileInputDelimited_1Process(csv_table.java:1447)
at demos.csv_table_0_1.csv_table.runJobInTOS(csv_table.java:2070)
at demos.csv_table_0_1.csv_table.main(csv_table.java:1929)

Re: Import CSV file to Postgres with Talend

Anonymous — Fri, 06 Jun 2014 11:06:19 GMT

There could be multiple reasons for Null pointer exception
- may be that tMap is not receiving expected input from the input component
Can you show the tMap configuration?
Vaibhav