topic Re: File name with a timestamp in Talend Studio

File name with a timestamp

Anonymous — Sat, 16 Nov 2024 12:45:54 GMT

Hi,
I have one question.
I want to give my file's name with a time stamp
It will be like "filename_yyyyMMdd_HHmm.dat"
But I have to find this file again in the job so, I want to store the "yyyyMMdd_HHmm" value in a context or variable.
and assign that context or variable to the file name.
Can you direct me how it can be done???
I've tried making a context of type string whose value is TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())
But when i run it i got a file not found exception (I'm to create a file not find for the first time).
and I think the context returns as a string of "TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())" not the actural date time value.
Thank You.

Re: File name with a timestamp

Anonymous — Tue, 02 Aug 2011 13:56:01 GMT

Hi Kyaw,
you have to set the content of the context variable in the running job by using the "Context Load" component.
At the start of the job insert a tFixedFlowInput Component and a "Context Load" Component.
Establish a "main" link from fixedFlowInput to the ContextLoad and set the schema of the fixedFlowInput equal to the ContextLoad.
In the fixedflowInput enter one row. In the "key" Field enter a String with the name of your context variable. In the value field enter the Expression TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate()).
When you run the job, the context will be set dynamically with the actual time in the given format.

Re: File name with a timestamp

Anonymous — Tue, 02 Aug 2011 14:17:38 GMT

Hi
Or you could make a context variable - I called it filename (String).
and before you save the file add a tjava component. In this component paste the following Code

context.filename = "filename_"+TalendDate.getDate("yyyyMMdd_HHmm")+".dat";

and whenever you need to use the name simply just use it as you would a normal context by typing context.filename

Re: File name with a timestamp

Anonymous — Tue, 02 Aug 2011 14:24:32 GMT

Hi Kyaw Lwin Phyo,
so first of all I created tLoop, context variable named timeStamp, then somewhere in process I asigned it the value of current time using tJava component and connected it to the first iteration

context.timeStamp = TalendDate.formatDate("yyyyMMdd_HHmmssSSS",TalendDate.getCurrentDate());

then I just used tRowGenerator to generate random ascii values for the tFileOutputDelimited and that's it.
Ladislav

Re: File name with a timestamp

_AnonymousUser — Thu, 29 Jan 2015 07:07:23 GMT

Instead, No need of Context Variable or Context load component.
Directly provide the expression in the filename property - it works
"D:/filedirectory/fileout_"+TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())+".csv"

Re: File name with a timestamp

_AnonymousUser — Tue, 14 Apr 2015 15:40:54 GMT

Instead, No need of Context Variable or Context load component.
Directly provide the expression in the filename property - it works
"D:/filedirectory/fileout_"+TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())+".csv"

A W E S O M E !

Re: File name with a timestamp

Anonymous — Tue, 14 Apr 2015 17:38:46 GMT

if u want ur output file with time stamp try this one:

Re: File name with a timestamp

Anonymous — Wed, 30 Mar 2016 19:21:37 GMT

Instead, No need of Context Variable or Context load component.
Directly provide the expression in the filename property - it works
"D:/filedirectory/fileout_"+TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())+".csv"

It worked perfectly. Thank You

Re: File name with a timestamp

Anonymous — Wed, 20 Apr 2016 12:41:09 GMT

Do we have any option for giving regular expression in file path

Re: File name with a timestamp

Anonymous — Thu, 21 Feb 2019 10:32:30 GMT

Hi,

Could you please let me know how can we append the date to the file name in cst format?

Re: File name with a timestamp

Anonymous — Thu, 21 Feb 2019 11:12:06 GMT

@Puspanjali12

Could you please let us know the exact format you are looking?

Then we can suggest the corresponding format to you.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: File name with a timestamp

Anonymous — Thu, 21 Feb 2019 11:15:50 GMT

@nthampi

I want to append the current date in a filename and the date should be in CST timezone.
for ex: data02212019051444

Regards,

Puspanjali

Re: File name with a timestamp

Anonymous — Thu, 21 Feb 2019 12:11:51 GMT

@Puspanjali12

Please refer the below diagram.

I have used the java libraray joda-time and the screen shots for tlibraryload are as below.

 import org.joda.time.DateTime;
 import org.joda.time.DateTimeZone;
 import org.joda.time.format.DateTimeFormatter;
 import org.joda.time.format.DateTimeFormat;

tMap screenshot is as below.

row1.input+DateTime.now(DateTimeZone.forID( "America/Chicago" ) ).toString(DateTimeFormat.forPattern("MMddyyyyHHmmss"))

And you got the answer 🙂

Please spare a second to mark the topic as resolved. Kudos are also welcome 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: File name with a timestamp

Anonymous — Thu, 21 Feb 2019 13:23:25 GMT

@nthampi

Thanks. It's working!!

Re: File name with a timestamp

Anonymous — Sat, 23 Mar 2019 13:47:46 GMT

The best for me

Re: File name with a timestamp

Anonymous — Wed, 12 Jun 2019 00:44:23 GMT

excelent...!

filename with datestamp.png

Re: File name with a timestamp

SJeshwani1618330394 — Fri, 01 Oct 2021 15:44:38 GMT

Hey hi @pariyarath Kiran ,

Your solution is working perfectly when we give it in a file path, but I want to use context variable and while I am giving this path in a context variable, it's not working.

do you have any idea about this?

Thank you

Regards,

Sheetal

Re: File name with a timestamp

1636848613 — Sat, 27 Nov 2021 09:12:28 GMT

"D:/filedirectory/fileout_"+TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())+".csv"

Seems to work when writing a file, but not on tFileCopy??

Re: File name with a timestamp

1636848613 — Sat, 27 Nov 2021 09:15:29 GMT

Diregard... needed spaces around + 😂