5 replies to this topic

[R Steven]

I have been doing some maintenance on my sources and templates and wrote a little utility program to help me with a couple of things:

• list all of the sources using a particular template
• find a template containing certain phrases
• list those custom templates I have created
• list the templates I am actually using in my sources
• merge similar templates into a single template in an intelligent way

I wrote a small utility program which currently does all of the above things except the last. The last item takes some care because it modifies the RM database. It also gets a bit complicated deciding how to handle fields which may not be exactly the same in the two templates. If you think the program might be useful for you, I happy to freely share it with others. You can install it from http://rsturley.net/...rce/publish.htm. It installs most cleanly using Internet Explorer as your browser, but should work okay with others as well.

The program has internal help which can also be viewed online at http://rsturley.net/RmSource/help.html.

Once you have installed it, it will automatically check for updates and changes in the program as I improve it or fix reported problems.

These kinds of reports and utilities would might be nice to have internally in RootsMagic some day and would be good to add to the Wish List.

[TomH]

I just ran into the issue once again that RootsMagic has no Merge Source Templates function and it really needs one. When you copy multiple times from one database to another and there are citations involved that use the same custom source template, each time that source template is brought over it is treated as a new source template and the associated source is, too. So now you have multiple identical source templates with no tool to merge them and multiple identical master sources which cannot be merged by AutoMerge because they use different source template records. You can merge them manually but that is painfully tedious given that the identical properties of the source templates should make it possible to automate it.

I'm not even sure that AutoMerge|Merge Source Templates is even on the wish list!

So I went searching the forum and turned up your message, Steve, and checked to see if maybe you had progressed your utility to include the Merge feature. No such luck! I might have a stab at it with SQLite.

BTW, the info displayed about a source template is great! I would like to see a delineation between Master Source fields and Source Detail fields.

[Renee Zamora]

I just ran into the issue once again that RootsMagic has no Merge Source Templates function and it really needs one. When you copy multiple times from one database to another and there are citations involved that use the same custom source template, each time that source template is brought over it is treated as a new source template and the associated source is, too. So now you have multiple identical source templates with no tool to merge them and multiple identical master sources which cannot be merged by AutoMerge because they use different source template records. You can merge them manually but that is painfully tedious given that the identical properties of the source templates should make it possible to automate it.

I'm not even sure that AutoMerge|Merge Source Templates is even on the wish list!

Confirming enhancement request is in our tracking system.

[Nettie]

Ok  This topic was in Nov 2003, has anything new been down about it.  Or is there another extra set of tools to do this type of a search.  When I ran this http://rsturley.net/RmSource/help.html>    I got RM 2005.  Anyone know anything more on this subject. wondered if it would work on the current database.  My guess is no.  But..... 

 

Thanks

[TomH]

I think you meant Nov 2012, not 2003, and RM5, not RM2005.

Nothing has changed wrt analysing and merging source templates from inside RM. It's as weak in its support as it was then. Outside of RM and Steven's utility, there are developed scripts for SQLite and queries for remaining questions could be designed. One that can merge duplicate source templates I did in 2013: http://sqlitetoolsfo...erge Duplicates

[Nettie]

Thanks Tom, guess my sight is not as good as I thought.  Glad you did a Sqlite macro for this.  Will try it.