Original File Name - Missing

General discussion of iFamily for Leopard and Genealogy
Post Reply
dhwalt
Posts: 3
Joined: Sat Dec 06, 2008 10:43 am
Location: Newcastle under Lyme, U.K.

Original File Name - Missing

Post by dhwalt » Mon Oct 31, 2022 12:07 pm

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

dhwalt
Posts: 3
Joined: Sat Dec 06, 2008 10:43 am
Location: Newcastle under Lyme, U.K.

Re: Original File Name - Missing

Post by dhwalt » Mon Oct 31, 2022 2:58 pm

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

Post Reply