You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-03 20:28:40

BremmeyrISS
Member
7 posts

BremmeyrISS said:

[resolved] Decimal tSalesforceWaveBulkExec and tFileOutputDelimited

How does a job need to be configured to send decimal values to SalesForce Wave? Currently I have a job that reads data from my database and sends data to Wave. Near the end of the job the component tFileOutputDelimited is used to create a file that in turn is sent to Wave with component tSalesforceWaveBulkExec. 
To make this a simple test I created a job that is tSalesforceWaveBulkExec to upload a 3 column file with 1 record header and 1 record of data. In tSalesforceWaveBulkExec schema I set the columns to string, bigdecimal, and integer. bigdecimal has length 7 precision 3. Integer has length 7 precision 3. 

My data file is FieldTest.csv and contains 
A_String,B_BigDec,C_Int
"TestString",123.456,123 

tSalesforceWaveBulkExec also creates a json file with the following content; 
{"fileFormat":{"charsetName":"UTF-8","fieldsDelimitedBy":",","fieldsEnclosedBy":"\"","linesTerminatedBy":"\n","numberOfLinesToIgnore":0},"objects":[{"name":"SalesData","fullyQualifiedName":"Sales Data","connector":"Talend_tSalesforceWaveBulkExec","description":"","label":"CRM.SalesData","fields":[{"name":"A_String","fullyQualifiedName":"SalesData.A_String","label":"A_String","isUniqueId":false,"type":"Text"},{"name":"B_BigDec","fullyQualifiedName":"SalesData.B_BigDec","label":"B_BigDec","isUniqueId":false,"type":"Numeric","precision":7,"scale":3,"defaultValue":0,"format":"#.##"},{"name":"C_Int","fullyQualifiedName":"SalesData.C_Int","label":"C_Int","isUniqueId":false,"type":"Numeric","precision":7,"scale":3,"defaultValue":0,"format":"#.##"}]}]}

The upload to Wave sends the file with a response of; 
The upload status is 'CompletedWithWarnings'.
In Wave the result is that column B is truncated or rounded to a integer value. 
Error message:
(column: B_BigDec) strconv.ParseFloat: parsing "B_BigDec": invalid syntax § (column: C_Int) strconv.ParseFloat: parsing "C_Int": invalid syntax
In wave the result can be viewed and shows 
A_STRING    B_BIGDEC    C_INT
TestString              123       123

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy