Score:0

How to assign incremental exif creation date(s) in JPEG images on a series on images exported from Power Point with filenames as Folie1, Folie2,

in flag

Motivation

I wanted to create a fotobook of a power point presentation with 84 pages but the import of https://www.fotoparadies.de/ would create a random order of pages then as it did not follow the image names nor the creation date of the image.

This is the files after the export in PP:

Folie1.jpeg
Folie2.jpeg
...
FolieN.jpeg

However, I noticed that this platform uses the EXIF creation date field to order pictures.

My solution

My hack to this was to add an exif header and assign a increasing creation date basically.

Downloaded https://exiftool.org/ and stored it as exif.exe in the same folder as the images.

On this platform https://www.online-python.com/ I've created this script:

for x in range(1,60):
  print(".\exif.exe -datetimeoriginal=\"2012:07:01 07:02:" + format(x, '02d')  + "\" .\Folie" + str(x) + ".JPG")

for x in range(1,60):
  print(".\exif.exe -datetimeoriginal=\"2012:07:01 07:03:" + format(x, '02d')  + "\" .\Folie" + str(x+59) + ".JPG")

Which then prints:

.\exif.exe -datetimeoriginal="2012:07:01 07:02:01" .\Folie1.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:02" .\Folie2.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:03" .\Folie3.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:04" .\Folie4.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:05" .\Folie5.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:06" .\Folie6.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:07" .\Folie7.JPG
.\exif.exe -datetimeoriginal="2012:07:01 07:02:08" .\Folie8.JPG
...

Then I pasted this commands into a powershell and it updated all the files with an increasing timestam in the exif field. You might have to add a exif tag first.

For creating the field I originally used https://www.sentex.ca/~mwandel/jhead/:

jhead -mkexif *.JPG

So once the images had a exif creation date relative to the file number I was able to import the images into a photobook.

I share here my solution as it took me 2 hours to figure this out. I hope this helps you guys!

If you have a better solution, please feel free to answer.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.