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 ZORIGINALFILENAME fixes the issue. Not practical for +2500 filenames:
1. Can the Original File Name(s) be retrieved on the iFamily interface (preference change, refresh or whatever)?
2. Failing that does anyone have a tested query that could be used, with confidence?
Thanks Dave
Original File Name - Missing
Re: Original File Name - Missing
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
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