Exploit your RootsMagic family tree database with SQLite Tools
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…
Here are some tricks using a shortcut and a Windows command file (.bat file for old DOS programmers) in conjunction with the command line version of SQLite3. The shortcut, which you can place in your Start menu, on your desktop or wherever it is convenient, calls the batch file and passes the path and name…
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…
(See Backup Media with Database – 7Zip for a similar procedure using 7-zip.) Here is a one-click backup procedure that stores the database file and all the media files it references in one solid, compressed backup file, preserving the path to each. Many have lamented the fact that RootsMagic 4 neither stores images in its…
RootsMagic 4 supported a unique set of metadata (Caption, Description, Date, SortDate, RefNumber) for each use of a media file, i.e., if the same image file was used for a citation, a fact and a person, there were three sets of metadata. RootsMagic 5 does not permit that, allowing only one set of metadata per…
The following was written in 2011 and RM Inc did rise to the challenge and produced a Backup option that includes media. However, it does two things that some people do not like if they are forced to restore from that backup: Their carefully developed folder structure for media is collapsed into one media folder…