Hi Guys, I am reading in JPG's and writing to a TAB file with attributes.
I want to convert the EXIFF date format to DD/MM/YYYY with time if possible.
The format EXIFF provides is YYYY:MM:DD HH:MM:SS eg 2020:06:03 08:55:21
Can this be done in the feature writer? eg changing the value with a @Value(jpeg_exif_datetime,%d/%m/%Y) command is this the right approach?
Dave
Best answer by ebygomm
If you want to write the date into a field of type date in your mapinfo TAB file, you will want to convert it to FME format YYYYMMDD, display as DD/MM/YYYY should be handled wherever the data is viewed.
I would use a DateTimeConverter prior to the FeatureWriter, the EXIF format is available to select as an Input Format
%Y:%m:%d %H:%M:%S$
+63There is a @DateTimeFormat function that you can use but it expects the input to be in FME DateTime format, which the EXIF isn't. A DateTimeFormatter transformer should do the trick, you'll probably have to specify the input format to be on the safe side.
+54If you want to write the date into a field of type date in your mapinfo TAB file, you will want to convert it to FME format YYYYMMDD, display as DD/MM/YYYY should be handled wherever the data is viewed.
I would use a DateTimeConverter prior to the FeatureWriter, the EXIF format is available to select as an Input Format
%Y:%m:%d %H:%M:%S$