Configure tFileOutputExcel component to load a file inside the built zip

[EnriqueLDE]

Hi,

My job looks like this schema:

tFileInputExcel -> tMap -> tFileOutputExcel

The tFileOutputExcel uses an excel template that needs to be attached to the job when I build it. If someone imports the job he should be able to run it because the template is already inside the zip. But I don't know how to configure the "file name" option in the tFileOutputExcel component to load the template in a dynamic way. This is because the context variable i set is using my local path C:\... , a path that won't be the same in other computers. Has anyone tried this before?

Thanks in advance,

Enrique

[ppatel]

Hello Enrique,

Thank you for posting your question.

If possible can you send us the screenshot of how you've configured the tFileOutputExcel component?

On how to configure the tFileOutputExcel component you can go through the Talend help doc: https://help.talend.com/r/en-US/7.3/excel/tfileoutputexcel.

Hope this helps.

[EnriqueLDE]

Hi,

Here's the image:

 

In "File Name" I need to write the "Template.xlsx" path. It can't be my local path because when I export this job the other user won't be able to run it.

I will build this job and inside the .zip I will place the Template. So the path in "Field Name" should be the "Template.xlsx" path inside the zip. Do you know what do I have to write in the red rectangle area? Thanks!

[SMR040]

If you leave out the Drive letter and use for example "/ExcelFiles" instead of "C:/ExcelFiles" then it should work on any computer. As long as the folder structure is the same.

Note that the path will be read from the location the job is being triggered from, so if you for example have the job.BAT (or job.SH for Linux) file on the C drive and the "ExcelFiles" folder is on D this will not work. So make sure both are deployed on the same drive.

[Anonymous]

Hello,

You are able to append current date into filename in FileOutput component.

The format looks like: //File1/Output_File_" + TalendDate.getDate("CCYYMMDD") + ".xlsx"

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina