Page 1 of 1

Original File Name - Missing

Posted: Mon Oct 31, 2022 12:07 pm
by dhwalt
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

Re: Original File Name - Missing

Posted: Mon Oct 31, 2022 2:58 pm
by dhwalt
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