Hello,
I am new to Tropy. I downloaded images from several google photos folders. In those folders, the images are ordered according to the time and date I took them (the metadata on the original photos creates this order). My hand-written notes on each of these photos follows that order, moving chronologically. But when I import these photos (the entire folder of them) into Tropy, the order gets completely screwed up somehow, and this makes it unbelievably time consuming for me because I can no longer quickly follow my notes and enter new metadata and notes for the images.
I read on a previous post that they are listed in the order that they are imported. However, I am importing the entire downloaded folder of images at once. I thought that Tropy would logically follow the metadata of the original JPGs and import the earliest photos first (with the earliest time stamp) but this isn’t happening.
I would love to hear how I can correct this problem.
Thanks!
Jessica
I’m afraid there’s no easy solution currently. Tropy imports the photo’s metadata at the photo level (including the date, if you use the default template); but we can sort items only by item properties not photo properties, because there’s no general 1:1 mapping between items and photos.
Currently, you’d have to copy the date of the photo-level to the item-level in the metadata panel; then you can sort the items based on this date.
We should make this process easier (or import the date also at the item level).
Hello,
I was wondering if there had been progress made on this issue. I recently installed Tropy and imported over 500 pictures, but can’t sort them out properly because the date field I care about is located at the photo-level.
In the content of “my_project.tropy”, the folder “assets” contains the pictures, but there is no similar folder with the items, so I guess it’s not feasible to write a simple Python script that would set the item-level date to the value of that field in its first picture.
At any rate, thanks for this wonderful software.
The metadata is stored in the project.tpy
file which is a SQLite database, so you could probably do this directly in SQLite or using Python and the SQLite adapter. If you do try to do this, please make a backup copy of the database file first!
In the database, both items and photos are ‘subjects’ – each metadata field is a property / value pair that’s linked to a subject. So if you have metadata at the photo level which you’d like to move up to the item level you’d either have to add a new corresponding field at the item level or change the current subject id from photo to item. I can help you coming up with suitable SQL queries if that’s something you want to explore.
Alternatively, what exactly is the date field at the photo level? On import, Tropy tries to set a date based on the photo at the item level too (if it fails it will fallback to the creation time of the file). Depending on how the date is stored it could be possible to make Tropy attach it to the item during import.