Jump to content


Member Since 12 May 2011
Offline Last Active Dec 11 2011 08:19 PM

Posts I've Made

In Topic: Shareable CD/DVD Problem

11 December 2011 - 08:18 PM

Did we ever get this figured out? I'm having the same exact problem with shareable cds I created for my husband's line. I've started a different post for the problem I'm having with my line, where the cd won't burn at all. My husband's line cds burn just fine, but as already mentioned, the only photo that shows in the thumbnail is the main person's photo. The rest of the images are icons unless you click on them to view. I've tried everything I've read about online to try to fix thumbnail problems in terms of Windows XP, as well as everything I've read on here. I'm trying to get the shareable cds ready for Christmas presents & I'm frustrated that this is happening at the very last step of the process. Please help!!

In Topic: Quick Fix to Saving Media the Wrong Way?

14 May 2011 - 12:10 PM

I don't understand how all that works - but THANK YOU SO VERY MUCH!!!! It didn't work on the media links that were broken due to me changing the file path, but I'm assuming that after I go in & get the links fixed & run that SQ thing again that it will fix those as well? Absolutely amazing - you saved me days of monotonous fixing - thanks again!!

Open the .rmgc file, not the .rmgb backup file.

In Topic: Quick Fix to Saving Media the Wrong Way?

13 May 2011 - 08:44 PM

I followed your directions, but when I try to open my backup, it says that it isn't a database or that it's encrypted & needs a password?!?!

It is pretty easy even though it seems daunting when you have no idea what you are doing! Go to the SQLiteToolsForRootsMagic4 wiki if you have not already and browse How to Query RootsMagic 4. Then download and install the free SQLiteSpy program for Windows. Using RootsMagic, make a backup of your database before any SQLite operation that is intended to modify your database. Run SQLiteSpy and use its File > Open database to open your database .rmgc file. The cursor will be blinking in the upper right empty pane of the SQLiteSpy window - that is where you will enter your SQL query. Copy the SQL command line (query) from my prior message (c/w semi-colon) into this space. With SQLiteSpy as the active window, press the F9 key to execute the query. You can close SQLiteSpy and proceed to open the Media Gallery in RootsMagic. Done!

In Topic: Quick Fix to Saving Media the Wrong Way?

13 May 2011 - 12:00 PM

I have absolutely no idea what any of this means!! I'm basically an intermediate computer user - I can do the basics without any trouble, but if it gets too technical, I'm lost...If you can dumb this down for me, maybe I can try it :)

An SQLite query outside RootsMagic on your .rmgc database appears to be a quick fix:

UPDATE MultimediaTable SET MediaType=1 WHERE MediaFile LIKE '%.jpg';

assuming your image files have the .jpg extension.

Then open the Media Gallery and I think it will automatically refresh thumbnails.

See the link in my signature for guidance on SQLite with RootsMagic.

In Topic: Quick Fix to Saving Media the Wrong Way?

13 May 2011 - 11:57 AM

Yes, I've had to do some of that erasing, too, unfortunately. My media gallery is so junked up & hard to find things in, I don't ever use it. I'm learning the hard way how to use this program...

A related problem to keep in mind: When I added media, I always chose "Add new media" even if I had already added that particular media item to another person or fact. I didn't realize it at the time, but I should have chosen "Add from gallery." Now when I choose "List | Media Gallery" I see several duplicate copies of the same item. It apparently causes no harm, but it does make it more difficult to manage my collection. It's too bad there isn't a confirmation message displayed when you try to add a new media item and that item is already in the media gallery.