migration – Transferring media from downloaded Apple Pictures library into Synology Pictures with a minimal metadata loss

Drawback:
I’ve an nearly 2TB Apple Pictures library already downloaded onto an exterior drive. I wished emigrate this library into Synology Pictures with out re-downloading it from the web. Exporting originals from Apple Pictures was too time-consuming and impractical. After some investigation, I found that the .photoslibrary file is actually an everyday folder containing an SQLite database and the unique photographs and movies. So, I moved this file to my Synology NAS.

Anticipated End result:
I wished to maneuver the media recordsdata from the .photoslibrary/originals listing into residence/Pictures on my NAS, organized in a %Y/%m/%d listing hierarchy. Ideally I want to maintain as a lot as attainable metadata from Apple Pictures.

Answer:
I created a program that:

1. Recursively loops by all recordsdata contained in the originals listing.
2. Queries a CSV file (exported from the ZASSET desk within the Apple Pictures SQLite database). The CSV accommodates two columns: ZFILENAME and ZDATECREATED.
3. Converts ZDATECREATED into %Y/%m/%d format and creates/selects the suitable folder inside residence/Pictures.
4. Strikes the file into that listing.

Shortcomings:
A big variety of recordsdata within the originals listing have _2, _3 suffixes earlier than the extension, and the database doesn’t have ZASSET information for these recordsdata. How ought to I deal with these?

Usually, I might like to listen to solutions from anybody who has completed the same migration of their Apple Pictures library to Synology Pictures. What’s the finest technique with the least metadata loss?

Thanks!