topic Re: Handle Excel file folder path accessing local machine when deployed in Talend Studio

Handle Excel file folder path accessing local machine when deployed

Anonymous — Tue, 21 Aug 2018 14:58:15 GMT

Hi,

How can I run .bat file in other machine when dumping data from excel file to sql server table?

When I developed Job I used my local machine folder path to fetch file, so how can I handle this when running .bat file in other machine(not having TOS tool in that machine).

Thanks,

Dhara

Re: Handle Excel file folder path accessing local machine when deployed

fdenis — Tue, 21 Aug 2018 15:12:40 GMT

it depend of the os. for unix you can use tssh and tsystem for windows.
use context to solve your path problème...
regards,

Re: Handle Excel file folder path accessing local machine when deployed

Anonymous — Wed, 22 Aug 2018 07:27:03 GMT

Hi,

I am using Windows 10 OS. I have used Excel file from path D:/Folder/ExcelFile.xlsx on my local machine and I run the Talend Job by .bat file generated on my machine. Now, the same .bat file of my Talend Job, I need to run from other machine, so how that other machine will take Excel file from path D:/Folder/ExcelFile.xlsx on my machine. How to handle this particular problem?

Thanks,

Dhara

Re: Handle Excel file folder path accessing local machine when deployed

fdenis — Wed, 22 Aug 2018 08:25:03 GMT

did you use context?

Re: Handle Excel file folder path accessing local machine when deployed

Anonymous — Tue, 28 Aug 2018 11:32:45 GMT

Yes I used Context and when running on other machine created folder path in that machine.

Re: Handle Excel file folder path accessing local machine when deployed

Anonymous — Tue, 28 Aug 2018 11:40:11 GMT

Hi,

I created a Job, Buildjob and running Job by .bat file on local machine. Now I need to keep this job on server machine and run the job through .bat file on server machine. I am using Talend Open Studio. How can I publish my Job?

Thanks,

Dhara

Re: Handle Excel file folder path accessing local machine when deployed

fdenis — Tue, 28 Aug 2018 12:45:09 GMT

You have to transfer all the output folder then you can run your job on an other machine (java have to be installed on the machine).

to modify excel File name and path modify the contexts/default.properties file
or create a second context before building.