Fixed with a query:
UPDATE ZPICTURE
SET ZORIGINALFILENAME=ZFILENAME
An instant update for almost 2000 entries. I did have backups and started with a single row test update in a WHERE clause.
Dave
Search found 2 matches
- Mon Oct 31, 2022 2:58 pm
- Forum: General Discussion
- Topic: Original File Name - Missing
- Replies: 1
- Views: 10588
- Mon Oct 31, 2022 12:07 pm
- Forum: General Discussion
- Topic: Original File Name - Missing
- Replies: 1
- Views: 10588
Original File Name - Missing
iFamily 2.13.2, Ventura 13.0 on M1 iMac. At some unknown time most of the Original File Name data has been lost i.e. only 5 from 2539 media items display that data. Using SQLiteStudio I can see that the Original File Name entries in the ZPICTURE table are Null and a copy n' paste from ZFILENAME into...