topic Re: Putting tSalesforceInput out put data row by row into multiple excelfiles in Talend Studio

Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Sat, 16 Nov 2024 07:38:11 GMT

Hi,

I want to put each row which i got from tsalesforceInput after querying .. into a separate excel sheet..

Please suggest how to achieve this...PFA..

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

manodwhb — Tue, 18 Sep 2018 09:26:23 GMT

@uganesh,i suggest you to use tMap between tsaleforceinput and tFileOutputExcle and generate the filenames in tMap using as a filed and then in the tFileOutputExcel using output stream option from the basic settings and specify the filed name based on that filed files will be generated.

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

TRF — Tue, 18 Sep 2018 09:32:38 GMT

As the whole data flow arriving into the tFileOutputExcel component will go to the same sheet, you need to use both tFlowToIterate and tIterateToFlow components between tSalesforceInput and tFileOutputExcel.

This suppose that the sheetname can be directly derived from the schema fields.

Else you will need a tMap or tJavaXxxx component to construct the desired sheetname.

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 10:20:46 GMT

Hi,

I have tried that way..but getting below error.

Error :

Error in the component's properties:Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to Date
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String

tal8.JPG
tal9.JPG
tal10.JPG

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 10:25:12 GMT

I have tried that way but getting below error....PFA

tal8.JPG
tal9.JPG
tal10.JPG

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 10:36:56 GMT

Can you explain ..how to do that...since i am new to talend..

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 10:54:52 GMT

Can you expain how to do this

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

TRF — Tue, 18 Sep 2018 11:12:05 GMT

Here is how ot should look like:

1rst tFixedFlowInput replace tSalesforceInput component for the example. The associated schema is composed of 2 fields (name and sheetname).

tFlowToIterate generates a global variable for every incoming field and mark the beginning of an iteration for every row. The configuration of this component is the default one.

2nd tFixedFlowInput generates a flow based on the global variable "row113.name" genrated by the tFlowToIterate component.

Here is how it is configured:

The field "name" is populated by the global variable "row113.name".

tFileOutputExcel generates the desired Excel file using the global variable "row113.sheetname" as the target sheetname:

Be carefull with the ticked options.

That's all.

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

TRF — Tue, 18 Sep 2018 15:34:22 GMT

@uganesh, did this help?

If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 15:45:51 GMT

i have tried as u said..but still getting below error....PFA

Error in the component's propertiesrg.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties cannot be resolved to a type
org.talend.components.salesforce.SalesforceConnectionProperties cannot be resolved to a variable
org.talend.components.salesforce.SalesforceConnectionProperties cannot be resolved to a variable
org.apache.avro cannot be resolved to a type
org.talend.components.api.properties cannot be resolved to a variable
org.talend.daikon cannot be resolved to a type
org.talend.daikon cannot be resolved to a type
org.talend.components.api.properties cannot be resolved to a variable
org.talend.daikon cannot be resolved to a type
org.talend.daikon cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components.api.component.ConnectorTopology cannot be resolved to a type
org.talend.daikon cannot be resolved to a type

tal11.JPG
tal12.JPG
tal13.JPG
tal14.JPG
tal15.JPG

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 16:01:04 GMT

i have tried that way but getting error. PFA.

tal11.JPG
tal12.JPG
tal13.JPG
tal14.JPG
tal15.JPG

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

TRF — Tue, 18 Sep 2018 16:07:16 GMT

There is a lot of screen captures but not the most interesting one.

Share the tSalesforceInput settings and advanced settings.

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Tue, 18 Sep 2018 16:11:06 GMT

PFA...

tal16.JPG
tal17.JPG

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

TRF — Tue, 18 Sep 2018 16:18:08 GMT

As your captures are not complete, double-check that the fields in your query correspond exactly with the fields of the schema

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

Anonymous — Wed, 19 Sep 2018 07:26:10 GMT

Hi,

As you said i have tried using iterator and fixedflow...

Exception in component tFixedFlowInput_1 (ExtractApexClasses)
java.lang.NullPointerException
at local_project.extractapexclasses_0_1.ExtractApexClasses.tSalesforceInput_1Process(ExtractApexClasses.java:3326)
at local_project.extractapexclasses_0_1.ExtractApexClasses.runJobInTOS(ExtractApexClasses.java:4147)
at local_project.extractapexclasses_0_1.ExtractApexClasses.main(ExtractApexClasses.java:3996)
[statistics] disconnected

Job ExtractApexClasses ended at 11:49 19/09/2018. [exit code=1]

tal18.JPG

Re: Putting tSalesforceInput out put data row by row into multiple excelfiles

TRF — Wed, 19 Sep 2018 07:40:51 GMT

As soon as an input field is you cannot use the corresponding globalMap.get.
Try with globalMap.getOrDefault instead.