topic Re: Need Created Date of File; Not Modified (mtime) in Talend Studio

Need Created Date of File; Not Modified (mtime)

SMurphy1703184287 — Mon, 01 Jul 2024 17:51:09 GMT

I have a current job that grabs images from a folder and uploads them if their Modified date time is AFTER the last upload date. Problem is... I have images with dates like this...

Created Date: June 11, 2024

Modified Date: May 20, 2024

How is the Created Date AFTER the Modified Date? Because of this - these images are not being caught. I think the June 11th date is when the images are being copied into my shared folder; but May 20th is when the graphic was actually created and edited?

I know tFileProperties will give me mtime - is there a "ctime" that tells me the created date/time?

Re: Need Created Date of File; Not Modified (mtime)

Shicong_Hong — Wed, 03 Jul 2024 08:57:57 GMT

@SMurphy1703184287 Created Date: the date when the file is created or moved to a new folder. tFileProperties only returns the modified date, you can use this piece of Java code on tJava to get the created date.

Path file = Paths.get("D:/shong/out.txt");
BasicFileAttributes attr = Files.readAttributes(file, BasicFileAttributes.class);

System.out.println("creationTime: " + attr.creationTime());

tJava's Advanced Settings tab:

import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import java.nio.file.attribute.BasicFileAttributes;

Regards

Shicong

Re: Need Created Date of File; Not Modified (mtime)

SMurphy1703184287 — Sun, 07 Jul 2024 20:01:49 GMT

Thank you! I haven't had time to try this out - but I think this is what I'm looking for!