You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Problem with decimal numbers
#1 2009-06-10 11:32:28
- Anlaur
- Member
- Registered: 2009-05-20
- Posts: 17
Problem with decimal numbers
Hi everybody,
I works on a project with Talend.Today, I meet a difficulty with decimal numbers in text file. I want to save "solde" of an account. This 'solde' find with the help of tAggregateRow . However, when I want to use this value, i have this following error :
Starting job LiaisonEntites at 10:55 10/06/2009.
Effacement de l'historique d'insertion.
fin de l'effacement de l'historique d'insertion
Exception in component tSageCRMInput_1
sage.SageCRMException: java.lang.NumberFormatException: For input string: "840,68"
at sage.metadata.type.SageSQLDataType.getSageSQLType(SageSQLDataType.java:63)
at sage.metadata.EntityDescription.appendMapData(EntityDescription.java:442)
at sage.metadata.EntityDescription.selectData(EntityDescription.java:425)
at importcrm.liaisonentites_0_1.LiaisonEntites.tSageCRMInput_1Process(LiaisonEntites.java:4059)
at importcrm.liaisonentites_0_1.LiaisonEntites.tSageCRMConnection_1Process(LiaisonEntites.java:229)
at importcrm.liaisonentites_0_1.LiaisonEntites.runJobInTOS(LiaisonEntites.java:5027)
at importcrm.liaisonentites_0_1.LiaisonEntites.main(LiaisonEntites.java:4939)
Caused by: java.lang.NumberFormatException: For input string: "840,68"
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
at java.lang.Double.valueOf(Unknown Source)
at java.lang.Double.<init>(Unknown Source)
at sage.metadata.type.SageSQLDataType.getSageSQLType(SageSQLDataType.java:57)
I join some screenshot :
Someone knows how I can resolve this error
Offline
#2 2009-06-11 05:45:10
Re: Problem with decimal numbers
Hello
sage.SageCRMException: java.lang.NumberFormatException: For input string: "840,68"
There is comma in your data, you need delete the comma on tJavaRow or tMap first. 840,68==>84068
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2009-06-15 17:35:28
- Anlaur
- Member
- Registered: 2009-05-20
- Posts: 17
Re: Problem with decimal numbers
shong wrote:
There is comma in your data, you need delete the comma on tJavaRow or tMap first. 840,68==>84068
Best regards
shong
I try these solutions but I don't know how to do the tJavaRow. I try also update types of 'solde (double ==> BigDecimal and double ==>Solde).
I think the problem is in format 'Device' which declared for 'Solde_du_compte" on SAGECRM.
If someone has an idea???????????????
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Problem with decimal numbers