topic Re: Retrieve modification date of a file in Talend Studio

Retrieve modification date of a file

Anonymous — Sat, 16 Nov 2024 07:39:47 GMT

Hi,

I'm trying to retrieve modification date of a file inside an archived file.

So first I put a tFileUnarchive component

Then I've tried to get the using native variable but I' ve not found the correct variable name :

((String)globalMap.get("tFileUnarchive_1_CURRENT_FILEDATE"))

((String)globalMap.get("tFileUnarchive_1_CURRENT_FILETIME"))

Both don't work.

I've also tried a tFileProperties component to retrieve the mtime column (and also the mtime_string column)

But I dont' know how to put these values in a tMap component in order to write it in tFileOutputDelimited component (the goal is to create a csv file in output with the inside archive file modification time in it)

Any idea ?

Thx

Re: Retrieve modification date of a file

TRF — Thu, 13 Sep 2018 13:38:12 GMT

Look at tFileProperties component for that

Re: Retrieve modification date of a file

Anonymous — Thu, 13 Sep 2018 15:02:02 GMT

"I've also tried a tFileProperties component to retrieve the mtime column (and also the mtime_string column)

But I dont' know how to put these values in a tMap component in order to write it in tFileOutputDelimited component (the goal is to create a csv file in output with the inside archive file modification time in it)"

Re: Retrieve modification date of a file

TRF — Thu, 13 Sep 2018 15:27:14 GMT

Just connect the tFileProperties component to the tMap then map the fields you want to the output and finally, connect the tMap to the tFileOutputDelimited

Re: Retrieve modification date of a file

TRF — Fri, 14 Sep 2018 08:46:15 GMT

Did this help?

If so, thank's to mark this case as solved (Kudos also accepted).

Re: Retrieve modification date of a file

Anonymous — Fri, 14 Sep 2018 10:07:02 GMT

Hi,

Unfortunately it does not work

So here is my job :

- tFileProperties component with provided working input filepath

- tMap component with links between input columns (abs_path, dirname, basename, mode_string, size, mtime and mtime_string) and output columns (same names)

- tFileOutputDelimited component with provided working output filepath (all other properties are set with default values)

When I run the job, and output file is generated but it only contains semicolons (

Re: Retrieve modification date of a file

Anonymous — Fri, 14 Sep 2018 10:16:44 GMT

Ok it was a bug. I close the job. Then I add a tLogRow to see values and then relink with tFileOutputDelimited and now it works !

Thx !

Re: Retrieve modification date of a file

TRF — Fri, 14 Sep 2018 10:24:11 GMT

Great!

Thank's to mark your case as solved (as it is now).

Re: Retrieve modification date of a file

TRF — Fri, 14 Sep 2018 11:25:26 GMT

~~@nhalicka, not very fairplay to accept your solution when it has been given by someone else!!!~~

@nhalicka thank's for the change

Re: Retrieve modification date of a file

Anonymous — Fri, 14 Sep 2018 15:05:53 GMT

Sorry, I thought I had selected your solution.

Is it ok now ?

Re: Retrieve modification date of a file

TRF — Fri, 14 Sep 2018 15:06:57 GMT

Yes, thank you