Managing surplus media #media
Tom
I broke down and copied my entire GedcomMedia folder from Onedrive to my computer, and it finally worked.
However, I don't see where it's determined which files are referenced in my DB in the excel output. Just for giggles, I ran the attach and sql select queries you suggested above, in SQLite Expert. What I get is two columns, Used and File. Everything in Used is (null). I'm certain I deleted one entire family with 10 children who had a census attached. Shouldn't it flag items that are in the GedcomMedia folder and not referenced in the database? Or does it flag items the other way around?
I've tried it both ways, with the batch file and in SQLite Expert and you are quite right - it's a large DB and takes about 8 minutes to run.
There should be a 1 in the Used column when a fully expanded filename in the file listing matches a concatenated MediaPath||MediaFile string in MultimediaTable. That they are all nulls indicates that you must be comparing a media folder that is different from where RM has the media recorded. Is it because your database has them in the OneDrive folder and your BAT file is generating a file list from a different folder? If so, then rename the OneDrive folder to break the links and use RM's Fix Broken Media Links tool with it focussed on the other folder so the MultimediaTable is updated (alternatively, you could use RM's global search & replace to change their paths).
I don't understand the issue of not working with the OneDrive folder. It should, as long as the file listing and the MultimediaTable paths are the same.
If you can share your RMGC and DB3 files with me on OneDrive, I could have a look for myself.
I just did a test with a small tree downloaded by TreeShare to a RM7 db on a OneDrive folder and RM created a sub-folder for media. I copied an unconnected image file to the same local media folder and I created a TXT file via OneDrive in the Cloud. I then used the option "Free up space" on the local media folder to remove the files' data from the local drive except for the directory listing. The RM database was also on OneDrive in the folder above and was not syncing because OneDrive detects that RM has it open (clever OneDrive; last time I looked, neither Google Drive nor DropBox is that clever). Finally, after editing the shortcut and BAT file accordingly, I opened the shortcut. Within seconds, Excel opened showing all 4 files and flagging the 2 used by the RM database with "1".
Uploaded files:
I got it working!
Part of the problem with OneDrive is that the Media folder contained over 32,000 files. Adobe Lightroom had created backup copies out there, and a couple of other genealogy programs I've tested created folders for "profile preview" thumbnail images. What I ended up copying over locally to my laptop was only about 7000 images and a couple hundred Pdf files. Once I culled all the unnecessary files and ran the Fix Broken media, it worked. I probably didn't need to copy it locally but, it was easier to delete the junk locally and keep the OneDrive as a backup. So right now I only have about 1000 unattached media files, of which are a lot of duplicates.
Now that I have it cleaned up I'm going to test it out using onedrive.
Thank you so much for taking the time to troubleshoot this with me!
Nicole