Jump to content


Media - BULK Linking Utility for Rootsmagic

  • Please log in to reply
2 replies to this topic

#1 Vyger


    Advanced Member

  • Members
  • PipPipPip
  • 3385 posts

Posted 03 May 2012 - 05:55 PM

I have written up an Excel workbook to enable bulk linking of unattached Media items into a Gedcom file for further processing in Rootsmagic. I wrote it to serve my own needs which it is doing very well so if any other user wants a free copy please contact me with your email address. Quick summary of what it does is below, a few users have tried it without problems.

  • User prints MultiMedia report from RM
  • User selects Media folder they wish to reconcile.
  • User selects Multimedia report.
  • Excel compares both and reports anomalies (unlinked)
  • User further edits list to remove any unwanted ADDS
  • Click "Create Gedcom" and workbook creates new gedcom file, one individual and all unlinked media tagged to that indi.

You will, of course need Excel to run this, itís in 2007 but should run on earlier versions.

“Your most unhappy customers are your greatest source of learning.” -Bill Gates

It's now time for discretion, trust, patience and support


User of Rootsmagic 7.5.9, Family Historian 6.2.7, Family Tree Maker 2014 & Legacy 7.5


Excel to Gedcom conversion - simple getting started tutorials here



#2 MVS


    Advanced Member

  • Members
  • PipPipPip
  • 326 posts

Posted 04 July 2012 - 03:56 AM

I have used this utility and it fills a big shortcoming in RM. It is well worth it when you are trying to do a bulk update.

If only this facility were a single "click" away in RM itself - but I guess we have to wait for them to catch up on this.

Meanwhile - this solution is a great tool.


#3 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 6174 posts

Posted 19 January 2013 - 09:22 AM

A number of forum members recently received vyger's Excel workbook by email. In the interest of making it readily available with his permission and given that he has had to withdraw from his genealogy pursuits for a time, I have posted the file and instructions on a page of the SQLIteToolsForRootsMagic wiki at Media Comparison & Attach Utility.

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.