Handle Excel file folder path accessing local machine when deployed

[Anonymous]

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

[fdenis]

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

[Anonymous]

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

[fdenis]

did you use context?

[Anonymous]

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

[Anonymous]

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

[fdenis · Accepted solution]

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.