Retrieve modification date of a file

[Anonymous]

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

[TRF]

Look at tFileProperties component for that

[Anonymous]

"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)"

[TRF · Accepted solution]

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

[TRF]

Did this help?

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

[Anonymous]

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 (

[Anonymous]

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 !

[TRF]

Great!

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

[TRF]

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

@nhalicka thank's for the change

[Anonymous]

Sorry, I thought I had selected your solution.

Is it ok now ?