topic Re: Archive FileName with Sysdate in Talend Studio

Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 09:03:09 GMT

Hi All,

I have a directory where n number of File is present. Now I want to to archive all of them in a Single Archive Zip File in format like this Sysdate_SomethingName.zip. I am trying with below in Archive FileName Path but getting compilation Error:

context.ROOT_SRCFILEDIR+"J3/DIGITAL/SPEND"+"/"+J3_DIGITAL_ACTUAL_SPEND_routines.TalendDate.getDate("yyyyMMddHHmmss").zip. Can anyone please help

@rhall, @TRF, @vboppudi, @manodwhb

Re: Archive FileName with Sysdate

TRF — Wed, 18 Apr 2018 09:11:00 GMT

Try this one (take care of ".zip"):

context.ROOT_SRCFILEDIR+
  "J3/DIGITAL/SPEND"+"/"+
  J3_DIGITAL_ACTUAL_SPEND_routines.TalendDate.getDate("yyyyMMddHHmmss")+
  ".zip"

context.ROOT_SRCFILEDIR+
  "J3/DIGITAL/SPEND"+"/"+
  TalendDate.formatDate("yyyyMMdd_HHmmss",TalendDate.getCurrentDate())+
  ".zip"

Hope this helps.

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 09:59:22 GMT

Hi @TRF,

Thanks for your reply. That is working in tfilearchive. Now when I am putting the context.ROOT_SRCFILEDIR+"J3/DIGITAL/SPEND"+"/"+TalendDate.formatDate("yyyyMMdd_HHmmss",TalendDate.getCurrentDate())+"_J3_DIGITAL_SPEND.zip" in ts3put FilePath some compilation error is coming

Re: Archive FileName with Sysdate

TRF — Wed, 18 Apr 2018 10:13:12 GMT

Which one?

You may click on the "Code" tab then click on red rectangle in the right margine to locate the compilation error into source code. And finally, click the cross in the left margin to get the error description.

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 10:15:37 GMT

Hi @TRF, @rhall,

FileArchive is working. But When I am putting that in ts3Put It is not working

Re: Archive FileName with Sysdate

TRF — Wed, 18 Apr 2018 10:27:36 GMT

So what, compilation error or runtime error?

Which error, do we have to guess it?

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 12:56:52 GMT

Compilation error it is.I have attached it

ts3Put.JPG

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 12:57:36 GMT

@TRF, @rhall

Re: Archive FileName with Sysdate

TRF — Wed, 18 Apr 2018 13:02:47 GMT

Where are you using this?

Share the component settings with le line of code as it appear in it.

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 13:12:50 GMT

In ts3Put. Using the same FileName as in tfilearchive.Attached it. @TRF

ts3Put_BasicSettings.JPG

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 13:13:37 GMT

FileName is

context.ROOT_SRCFILEDIR+"+"J3/DIGITAL/SPEND"+"/"+TalendDate.formatDate("yyyyMMdd_HHmmss",TalendDate.getCurrentDate())+"_J3_DIGITAL_SPEND.zip" @TRF

Re: Archive FileName with Sysdate

abhi90 — Wed, 18 Apr 2018 13:23:20 GMT

Sorry this One

context.ROOT_SRCFILEDIR+"J3/DIGITAL/SPEND"+"/"+TalendDate.formatDate("yyyyMMdd_HHmmss",TalendDate.getCurrentDate())+"_J3_DIGITAL_SPEND.zip" @TRF

Re: Archive FileName with Sysdate

TRF — Wed, 18 Apr 2018 13:32:02 GMT

Should work as soon as context.ROOT_SRCFILEDIR is known.

Re: Archive FileName with Sysdate

TRF — Sun, 22 Apr 2018 08:03:12 GMT

Which compilation error?