topic Re: excel to postgresql string in Talend Studio

excel to postgresql string

veryimportantdude — Sat, 16 Nov 2024 13:41:02 GMT

Hello
I am having problems with excel tables import to tpostgresql.
I set the type of data to Double or Float and he reports error
statistics] connecting to socket on port 4270
connected
For input string: "7410,42"
For input string: "7410,42"
For input string: "14820,83"
disconnected
Than I set type of data to BigDecimal and now he reports this error
statistics] connecting to socket on port 4008
connected
null
null
null
disconnected
Job dohlestvica ended at 16:25 16/11/2009.
What type of data is set in excel (text, number, general) doesn't seem to have any effect
This problem occurs almost every time I am dealing with decimals
Any suggesttions???
thank you for helping me

Re: excel to postgresql string

Anonymous — Tue, 17 Nov 2009 06:47:38 GMT

Hello

For input string: "7410,42"

Read it as string type, then remove the comma ',', convert string to double or float as needed.
Best regards
shong

Re: excel to postgresql string

veryimportantdude — Mon, 23 Nov 2009 13:58:14 GMT

Thank you
The problem is with dot and commas. Because european is 790,12 but when you transfer to postgreSQL it is suppose to be 790.12, so you have to change it in excel. But since Microsoft is ..... sometimes you have big big problems with replacing that. Open office rules