topic Re: [resolved] Convert to String in csv tconvert problem in Talend Studio

[resolved] Convert to String in csv tconvert problem

Anonymous — Mon, 16 Nov 2015 11:54:35 GMT

Hello everybody,
I tried to connect an csv with out Salesforce System
But i have a problem with the conversion from String to Double
Here is my test environment:

I tried the tconvert method which has Sabrina described with the treplace component from this thread.
I tried several scenarios to set the treplace behind or in front of tmap .. but nothing will fit properly.
It comes the following errror:
Error in the component's properties:Type mismatch: cannot convert from String to Double
But I'm not sure if this working in any way with these approach.

Here is my csv File:

Best regards john

Re: [resolved] Convert to String in csv tconvert problem

Anonymous — Mon, 16 Nov 2015 13:43:11 GMT

Did you try in the tMap Double.parseDouble(rowXX.yourString) (without any tReplace or tConvert)

Re: [resolved] Convert to String in csv tconvert problem

a_vlad — Mon, 16 Nov 2015 13:45:09 GMT

Hello!

The answer already in the error description
Just go from left to right on You Job and check all schemas for data type, possible to start from tMap
when You found change type String to double - use in tMap conversion function Double.valueOf(row1.some_name)

Re: [resolved] Convert to String in csv tconvert problem

Anonymous — Tue, 17 Nov 2015 09:11:12 GMT

Hello Everybody
I have solved the conversion Problem .. there is no more error if i start the job.
I have still tconvert in action cause my java skills are so bad
...thanks for the hints
but i think that treplace doesn't work properly.
Here are my treplace settings:

I thought i need sth. like simple expression like r/n but this doesn't seems to work

Here is an outline from the csv export from toad ( i've made 2 examples what is important for the transformation):

And this is the outline from the same File what i get from Talend back:

I hope that is understandable what the problem is ....

Edit:

Here are my Excel Sheet Settings:

regards john

Re: [resolved] Convert to String in csv tconvert problem

Anonymous — Wed, 18 Nov 2015 07:59:54 GMT

Hello Everbody,
I've made some Tests with and without some Components and it's seems to that the TConvert Component is repsonsible for the cold cut of important data even if i deactivate all options for the Component.
So i think with the tconvert component is getting more worse than better ...
So as https://community.talend.com/t5/Design-and-Development/Covert-integer-DateKey-to-Date-MM-dd-yyyy/td-p/179488[size=2][font=Verdana, Helvetica, Arial, sans-serif] [/font][/size]said before maybe it's a better idea to use tmap only.
I'm totally new so how i have to integrate this. But i think i need treplace to trim my csv.
Do i have to do itin this way as mentioned here on the picture?:

best regards john

Re: [resolved] Convert to String in csv tconvert problem

Anonymous — Thu, 19 Nov 2015 14:38:26 GMT

Update
I'm sick with the csv conversitions...
I got the Permission to Access Directly to database and everything is fine
Thanks all for helping in other threads
regards john