Talend community forum / passing parameters of tfileinputexcel dinamically

abbes · 2011-03-31 11:37:36

Tags: [CSV file, deployment, development, dinamically, executable java, file paramaters, java, loading paramaters, oracle, tFileInputExcel]

hello, I have created a simple integration job which integrate data from an excel file to database table. the component used to read data is
tfileinputexcel.I have exported this job as an executable java but this executable still depends on the file defined in the paramaters settings
of the tfileinputexcel component (this means if I change my excel file or move it to other location the job doesn't work).I am looking for a way to passe the paramaters of the excel file (path+name of excel file) to the job when I lunch it from the execuable java.
best regards

lijolawrance · 2011-03-31 12:00:41

Hi

I can be acheived dynamicalliy by declaring a context variable.In the place of file name you can give
context.<declaredVariable>

In the created batch file/sh file you can pass as --context_param <declaredVariable>="File Location"

you can also check the implicit tContext Load option for dynamic file read

abbes · 2011-03-31 12:38:19

how I can pass as --contxt_param
can you give me a simple example of the batch file which passing parameters.
regards.

Announcement

Unanswered posts

#1 2011-03-31 11:37:36

passing parameters of tfileinputexcel dinamically

#2 2011-03-31 12:00:41

Re: passing parameters of tfileinputexcel dinamically

#3 2011-03-31 12:38:19

Re: passing parameters of tfileinputexcel dinamically

Board footer