Exploit your RootsMagic family tree database with SQLite Tools
Operations on Media, esp the MultimediaTable and MediaLInkTable
TestExternalFiles by Richard J. Otter is a new Windows utility that helps identify these issues: A file on disk may get renamed, or moved, breaking the linkfrom the database. A file may be added to the media folder on disk but then not attached to thedesired database element. A file may be added to RM,…
Problem TreeShare update operations that add images from Ancestry to the RootsMagic database can result in successive downloads of the same image file saved to a revised name, each added to the Media Gallery and independently tagged to their respective subjects. I don’t think this is either necessary or desirable (maybe there is a good…
TreeShare downloads Ancestry media for citations with cryptic file names that mean nothing to humans. This set of scripts and batch or command-line operations prepends to the media filenames the name of one of the persons to whom the citation applies, their BirthYear-DeathYear and the name of the source cited, separated from the cryptic name…
I attached the 1920 Census to the people displayed in the window below: I want to remove the media from Sophia only.and leave the media attached to the remaining people. Actual Results: I have Sophia’s record open, selected the media column for the fact, highlighted Sophia and pressed the Remove media button. It removes the…
I don’t usually post a page here requesting help, but I’ll make an exception in this case. I have created a query that adds rows to the MediaLinkTable. The purpose of the added rows has to do with the fact that I’m an extreme source splitter and therefore I link media files to RM’s Master…
This page is in response to a question posed in the RootsMagic Forums by member DeliChef in the topic Bulk File Name Change For Hundreds of Family Letters?. He had named the files using the format MM_DD_YYYYPersonName, i.e., the date of the letter followed by name of the sender. To improve the utility of Windows…
Update As of RootsMagic 8 Preview 7.9.180, the traceability of where an image is used has changed little from what was described below for RM4. The need for an outboard query such as this is as high in early 2021 as it was in 2010. With some changes in tables from RM7, the Media-UsersList4.sql query…
This query responds to a problem with an import from Family Historian via FTM-flavoured GEDCOM reported by Stewartrb in the RootsMagic Forums thread GEDCOM import with media. The images linked to the person in Family Historian were ultimately tagged as such in RootsMagic but none was marked as the Primary photo. Consequently, none showed on…
Users can mistakenly add image files to the Media Gallery with the wrong MediaType which prevents the images from being used in reports. MediaType is normally set by user selection in the Add Media Item dialog and cannot be changed from within RootsMagic 6.0.0.2 and earlier. Within RM the only option is to add the…
Deletes records from MultiMediaTable untagged by any Person, Family, Fact, Place, Source or Citation. Was formerly included in Delete Phantoms. MediaDeleteUnused.sql — MediaDeleteUnused.sql /* 2013-01-21 Tom Holden ve3meo Deletes records from MultiMediaTable untagged by any Person, Family, Fact, Place, Source or Citation. Extracted from DeletePhantoms.sql */ DELETE FROM MultimediaTable WHERE MediaID NOT IN…