GrahamMYC Posted February 2, 2021 Share Posted February 2, 2021 This is possibly naive, and may have a simple solution. It seems that when I process a raw file in APh and save that as an affinity photo file, the file date is the date that I first saved that APh file, not the date shot I would like to batch change this date to the "date shot", which still exists within the exif data Is there any way to do this? Could a macro be created to do this? Quote Link to comment Share on other sites More sharing options...
kirkt Posted February 2, 2021 Share Posted February 2, 2021 Maybe EXIFTool can help, but it really depends on the tags in the file and what your OS supports in this regard. See: https://exiftool.org/filename.html Kirk Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted February 2, 2021 Share Posted February 2, 2021 16 minutes ago, kirkt said: Maybe EXIFTool can help, It can't help. It would need to understand the Affinity file format, but that is proprietary and undocumented. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. iPad: iPad Pro M1, 12.9": iPadOS 17.4.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.4.1 Link to comment Share on other sites More sharing options...
David in Яuislip Posted February 2, 2021 Share Posted February 2, 2021 exiftool "-FileCreateDate<CreateDate" -r *.jpg The -r switch applies recursion so it will work on lower directories. If you're using a Mac I think that single quotes are required The example below was run from the Metadata level and altered file dates there and in the subs Quote Microsoft Windows 11 Home, Intel i7-1360P 2.20 GHz, 32 GB RAM, 1TB SSD, Intel Iris Xe Affinity Photo - 24/05/20, Affinity Publisher - 06/12/20, KTM Superduke - 27/09/10 Link to comment Share on other sites More sharing options...
Pšenda Posted February 2, 2021 Share Posted February 2, 2021 6 hours ago, David in Яuislip said: exiftool "-FileCreateDate<CreateDate" -r *.jpg 7 hours ago, GrahamMYC said: and save that as an affinity photo file David in Яuislip 1 Quote Affinity Store (MSI/EXE): Affinity Suite (ADe, APh, APu) 2.4.0.2301 Dell OptiPlex 7060, i5-8500 3.00 GHz, 16 GB, Intel UHD Graphics 630, Dell P2417H 1920 x 1080, Windows 11 Pro, Version 23H2, Build 22631.3155. Dell Latitude E5570, i5-6440HQ 2.60 GHz, 8 GB, Intel HD Graphics 530, 1920 x 1080, Windows 11 Pro, Version 23H2, Build 22631.3155. Intel NUC5PGYH, Pentium N3700 2.40 GHz, 8 GB, Intel HD Graphics, EIZO EV2456 1920 x 1200, Windows 10 Pro, Version 21H1, Build 19043.2130. Link to comment Share on other sites More sharing options...
v_kyr Posted February 3, 2021 Share Posted February 3, 2021 8 hours ago, GrahamMYC said: This is possibly naive, and may have a simple solution. It seems that when I process a raw file in APh and save that as an affinity photo file, the file date is the date that I first saved that APh file, not the date shot I would like to batch change this date to the "date shot", which still exists within the exif data Is there any way to do this? Could a macro be created to do this? No it's not simple, since you can't change and influence an APh-file's system level date-time stamp from inside of APh, just from outside from the OS file system level. Also I don't know if this is generally a good idea to do in terms of some possible hidden Affinity file format internals then, meaning due to possible backup and incremental internal Affinity file format parts. 1. However, the easiest would be if you save your Affinity files instead with an own added date stamp filename here, so something like ... MyShot-location-2021-02-03.afphoto ... or the like. So you can treat and handle it yourself differently from the system level file date-time stamp. 2. Otherwise one possible procedure might be (one would have to test/try out), to save always two files from a developed RAW file, namely the Affinity Photo file and a corresponding JPG file of the same filename part with included meta data. Aka ... Myfile_xyz.afphoto & Myfile_xyz.jpg ... then via external system level scripting and a tool like exiftool extract the date of the .JPG file and "touch" the .AFPHOTO file with that date stamp then. Afterwards the JPG-file can be removed. Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2 Link to comment Share on other sites More sharing options...
GrahamMYC Posted February 3, 2021 Author Share Posted February 3, 2021 7 hours ago, v_kyr said: No it's not simple, since you can't change and influence an APh-file's system level date-time stamp from inside of APh, just from outside from the OS file system level. Also I don't know if this is generally a good idea to do in terms of some possible hidden Affinity file format internals then, meaning due to possible backup and incremental internal Affinity file format parts. 1. However, the easiest would be if you save your Affinity files instead with an own added date stamp filename here, so something like ... MyShot-location-2021-02-03.afphoto ... or the like. So you can treat and handle it yourself differently from the system level file date-time stamp. 2. Otherwise one possible procedure might be (one would have to test/try out), to save always two files from a developed RAW file, namely the Affinity Photo file and a corresponding JPG file of the same filename part with included meta data. Aka ... Myfile_xyz.afphoto & Myfile_xyz.jpg ... then via external system level scripting and a tool like exiftool extract the date of the .JPG file and "touch" the .AFPHOTO file with that date stamp then. Afterwards the JPG-file can be removed. I am having difficulty with this. IFor method 1 it is too late to deal with the many files I already ahve. For method 2, I am not sure what goes into the xyz element. Then, how do I use the external exiftool? I shall do a search for some advice, but if you can point me to a source that is understandable to a non expert, then I would be grateful. Reflecting further on your initial comments, I may not need to alter the file date itself. What I am doing is organising my photos (and other material) in the Daminion data asset manager. need only chnage the creation date withi daminion to achieve the sort on my photos that I want, That still requires that I extract the date shot from the metadata. I have put this problem to Daminion (who are incredibly helpful) so that it can be writtrn to the Daminion date created field. I will point them at exiftool to see if it helps their processes. Thanks for the thoughts. SAny further advice would be welcome. Quote Link to comment Share on other sites More sharing options...
v_kyr Posted February 3, 2021 Share Posted February 3, 2021 2 hours ago, GrahamMYC said: I am having difficulty with this. IFor method 1 it is too late to deal with the many files I already ahve. For method 2, I am not sure what goes into the xyz element. "Myfile_xyz" is just an imaginary example name, it was just meant as a placeholder like "DSC_0956.jpg", you can instead choose whatever you name your files. For the external exiftool see exiftool and how to use it. For example from a command shell ... This will output the name of the file, a tab, and the date&time the image was taken at: exiftool -T -FileName -DateTimeOriginal <FILES or DIR> To print out the creation date & time of an image to the console ... exiftool -T -createdate <filename> To write out the previous instead into a temp text file ...exiftool -T -createdate yourfile.jpg > tmp.txt ... and so on ... 3 hours ago, GrahamMYC said: Reflecting further on your initial comments, I may not need to alter the file date itself. What I am doing is organising my photos (and other material) in the Daminion data asset manager. need only chnage the creation date withi daminion to achieve the sort on my photos that I want, That still requires that I extract the date shot from the metadata. ... IMO that would be an overall better way, to let it be handled instead by that "Daminion data asset manager" then, as far as that one offers some options to do so for files and the handling/assigning of date-time stamps. Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2 Link to comment Share on other sites More sharing options...
David in Яuislip Posted February 3, 2021 Share Posted February 3, 2021 12 hours ago, Pšenda said: 19 hours ago, David in Яuislip said: exiftool "-FileCreateDate<CreateDate" -r *.jpg 20 hours ago, GrahamMYC said: and save that as an affinity photo file Haha, that'll teach me. Ok, Round 2, the Windows version for ORFs Exiftool can process the following dates: [File:System] FileModifyDate [File:System] FileAccessDate [File:System] FileCreateDate [EXIF:IFD0] ModifyDate [EXIF:ExifIFD] DateTimeOriginal [EXIF:ExifIFD] CreateDate So open a Powershell window in the folder with the raw files and do exiftool -csv -CreateDate *.ORF > dates.csv Open dates.csv in a text editor and you'll see this SourceFile,CreateDate P1070001.ORF,2020:01:07 18:26:16 P1070003.ORF,2020:01:07 18:26:51 etc - change CreateDate to FileCreateDate in the first row - Replace all .ORF to .afphoto SourceFile,FileCreateDate P1070001.afphoto,2020:01:07 18:26:16 P1070003.afphoto,2020:01:07 18:26:51 etc - Save as UTF-8 & close - Move the file to the folder with the afphoto files Open a Powershell window in the folder with the afphoto files and do exiftool -csv=dates.csv *.afphoto Quote Microsoft Windows 11 Home, Intel i7-1360P 2.20 GHz, 32 GB RAM, 1TB SSD, Intel Iris Xe Affinity Photo - 24/05/20, Affinity Publisher - 06/12/20, KTM Superduke - 27/09/10 Link to comment Share on other sites More sharing options...
GrahamMYC Posted February 3, 2021 Author Share Posted February 3, 2021 22 minutes ago, David in Яuislip said: Haha, that'll teach me. Ok, Round 2, the Windows version for ORFs Exiftool can process the following dates: [File:System] FileModifyDate [File:System] FileAccessDate [File:System] FileCreateDate [EXIF:IFD0] ModifyDate [EXIF:ExifIFD] DateTimeOriginal [EXIF:ExifIFD] CreateDate So open a Powershell window in the folder with the raw files and do exiftool -csv -CreateDate *.ORF > dates.csv Open dates.csv in a text editor and you'll see this SourceFile,CreateDate P1070001.ORF,2020:01:07 18:26:16 P1070003.ORF,2020:01:07 18:26:51 etc - change CreateDate to FileCreateDate in the first row - Replace all .ORF to .afphoto SourceFile,FileCreateDate P1070001.afphoto,2020:01:07 18:26:16 P1070003.afphoto,2020:01:07 18:26:51 etc - Save as UTF-8 & close - Move the file to the folder with the afphoto files Open a Powershell window in the folder with the afphoto files and do exiftool -csv=dates.csv *.afphoto More questions, I am afraid. 1: Presumably I can substitute NEF or DRG (Nikon Raw) for ORF 2: Sometimes I only have the .afphoto file, not the raw. Presumably I would have to make a temporary jpg file which exiftool could access to extract the date. 3: The date I want to capture is DateShot (see screen shot attached), which does not appear in your list of examples. What EXIF name would that have? Quote Link to comment Share on other sites More sharing options...
David in Яuislip Posted February 3, 2021 Share Posted February 3, 2021 1 minute ago, GrahamMYC said: 1: Presumably I can substitute NEF or DRG (Nikon Raw) for ORF 2: Sometimes I only have the .afphoto file, not the raw. Presumably I would have to make a temporary jpg file which exiftool could access to extract the date. 3: The date I want to capture is DateShot (see screen shot attached), which does not appear in your list of examples. What EXIF name would that have? 1. Yes 2. Yes. File Name : P1070001.jpg shows Date/Time Original : 2020:01:07 18:26:16 Create Date : 2020:01:07 18:26:16 3. exiftool -DateTimeOriginal -CreateDate P1070001.ORF displays the same values for both which was the date/time of shooting Quote Microsoft Windows 11 Home, Intel i7-1360P 2.20 GHz, 32 GB RAM, 1TB SSD, Intel Iris Xe Affinity Photo - 24/05/20, Affinity Publisher - 06/12/20, KTM Superduke - 27/09/10 Link to comment Share on other sites More sharing options...
v_kyr Posted February 3, 2021 Share Posted February 3, 2021 13 minutes ago, GrahamMYC said: More questions, I am afraid. 1: Presumably I can substitute NEF or DRG (Nikon Raw) for ORF 2: Sometimes I only have the .afphoto file, not the raw. Presumably I would have to make a temporary jpg file which exiftool could access to extract the date. 3: The date I want to capture is DateShot (see screen shot attached), which does not appear in your list of examples. What EXIF name would that have? yes yes see "createdate" or take a closer look at the manual/documentation here! Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2 Link to comment Share on other sites More sharing options...
GrahamMYC Posted February 3, 2021 Author Share Posted February 3, 2021 v_kyr In the example which I attached. The date shot was 18-07-2018; but the date created was 22-12-2019. Presumably that is because I did not process the file until end of 2019. I will study the documentation, which I have now downloaded and try to disentangle the problem I really appreciate your help. Quote Link to comment Share on other sites More sharing options...
Move Along People Posted February 3, 2021 Share Posted February 3, 2021 - Quote Move Along people,nothing to see here Link to comment Share on other sites More sharing options...
Pšenda Posted February 4, 2021 Share Posted February 4, 2021 On 2. 2. 2021 at 6:15 PM, walt.farrell said: It would need to understand the Affinity file format, but that is proprietary and undocumented. It is possible to join the request to add *.afphoto format support (at least at the metadata level) to ExifTool. https://exiftool.org/forum/index.php?topic=8151.0 Quote Affinity Store (MSI/EXE): Affinity Suite (ADe, APh, APu) 2.4.0.2301 Dell OptiPlex 7060, i5-8500 3.00 GHz, 16 GB, Intel UHD Graphics 630, Dell P2417H 1920 x 1080, Windows 11 Pro, Version 23H2, Build 22631.3155. Dell Latitude E5570, i5-6440HQ 2.60 GHz, 8 GB, Intel HD Graphics 530, 1920 x 1080, Windows 11 Pro, Version 23H2, Build 22631.3155. Intel NUC5PGYH, Pentium N3700 2.40 GHz, 8 GB, Intel HD Graphics, EIZO EV2456 1920 x 1200, Windows 10 Pro, Version 21H1, Build 19043.2130. Link to comment Share on other sites More sharing options...
GrahamMYC Posted February 4, 2021 Author Share Posted February 4, 2021 Psenda I tried to register, but it asked me to check if username was available, but did not tell me where to do that. Quote Link to comment Share on other sites More sharing options...
Pšenda Posted February 4, 2021 Share Posted February 4, 2021 Quote Affinity Store (MSI/EXE): Affinity Suite (ADe, APh, APu) 2.4.0.2301 Dell OptiPlex 7060, i5-8500 3.00 GHz, 16 GB, Intel UHD Graphics 630, Dell P2417H 1920 x 1080, Windows 11 Pro, Version 23H2, Build 22631.3155. Dell Latitude E5570, i5-6440HQ 2.60 GHz, 8 GB, Intel HD Graphics 530, 1920 x 1080, Windows 11 Pro, Version 23H2, Build 22631.3155. Intel NUC5PGYH, Pentium N3700 2.40 GHz, 8 GB, Intel HD Graphics, EIZO EV2456 1920 x 1200, Windows 10 Pro, Version 21H1, Build 19043.2130. Link to comment Share on other sites More sharing options...
GrahamMYC Posted February 5, 2021 Author Share Posted February 5, 2021 On 2/4/2021 at 11:21 AM, Pšenda said: I have not yet tried again to log into the exiftool forum to log my interest. In the mantime, I would like to report that I have been in discussion with Daminion, a data asset manager program. After looking at the problem they said that they would not be able to extract the "date shot" from the affinity photo is it is not one of their supported formats. I went back to them, and pointed out that Affinity is growing rapidly with three applications (APh,AD, and Pub) operating in 3 environments (Mac, iPad, Windows) interchangeably; and that some months ago Affinity reported more than a million users worldwide. I also gave the person I was communicating with access to my website to illustrate the scope of the apps, and the range of formats that I am trying to include in the Daminion catalogues. I set out below the response I received quote unquote. This shows that your suggestion that Affinity user register their interest with exiftool is important, and I would also suggest the users explore the benefits of Daminion as a DAM (data asset manager). I have now integrated about 20k photos,, the most recent ones porcessed on APh; more than a dozen Logs (early ons processed in Pageplus, and the more recent ones in APub). I also make use of some video. Since the abandonment od MoveiPlus, I have used a varietty of editors including Pwer Director, Da Vinci Resolve, and Luma Fusion. Although the Affitiy suite is not formally supported by Daminion, it is possible to specify the file extensions to be accepted, and thereafter it accepts the Affinity family (although the file type displayed can default to "unknown". Otherwise it works well.Indeed, it seems to me that Serif's DAM project has slipped so much that they might do better to "do a deal" with Daminion and concentrate their resources on developing the Affinity triumvarate. Although loading files into Daminion can be a slow process (if there are many), the speed of ersponse ,once loaded, is amazing. So, I have reached the File Date Proposal.pdfthat instead of tryim to develop a workaround on my problem, I shall seek to get Serif to look at the issues I have raised, and encourage them to engage with the Daminion team whO I have found to be very helpful . I attach a short note in which I try to explain what I am trying to achieve and wy. In the near future (but not immediately) I will try to produce a video demonstrating the use and performance of Daminion. File Date Proposal.pdf Pšenda 1 Quote Link to comment Share on other sites More sharing options...
GrahamMYC Posted February 10, 2021 Author Share Posted February 10, 2021 I have had further discussions with Daminion and have recently received the following quote Hi Graham, Thank you for the detailed description! The problem might, indeed, be related to the fact that affinity files are not natively supported by Daminion. We have registered the request to add the native support, but we need to get more user requests before adding it to our roadmap. Adding new format support is a pretty complex task and we need to get more requests to do it. Kind regards, Daria Un quote Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.