Inserts an Alternate Name of type “Married” for female “Wife” spouses in a “Family” where no Alternate Surname matches the male “Husband’s” and a (family) Marriage fact exists.Īdds a Marriage event to any couple (family) in a database that does not have this fact already.ĭiscussion of techniques used to copy Description from one type of event to another and the beginning of a more complex merging of near duplicate eventsįinds SSN facts that have not been set to Private. Sharable Events – Find and Convert to Shared
Especially useful on imports from Legacy Family Tree in which events were copied to multiple persons. List and convert events having key properties in common to shared events. Variant of CopyFact2Group that copies a REFN fact to a group, substituting the target persons’ PersonID’s or RIN for that of the source person. SortDateSameDayOrder | SortDateSameDayOrderCustomĬopies a fact/event for a person to a Named Group of persons, along with the Sources but not the Media for the Fact. Re-orders all same day events of limited types to a natural order, e.g., Birth before Death Lists Individuals whose Death Year from NameTable does not match that of the date for their Death fact.Ī discussion of queries that can modify the Living flag. Lists Individuals whose Birth Year from NameTable does not match that of the date for their Birth fact. People View Error – at most 64 tables in a Join Lists count of rows in each table - If not 22 tables listed, database has corruptionĪn outline of procedures that have been used with some success to recover a corrupted RootsMagic database.Īn outline of procedures that have been used when People View throws error message “SQLite Error 1 – at most 64 tables in a join”. Reports in a list most of the values found in RM4’s File > Properties report results can be exported to a file.Īs ‘Database Properties’ but with more detail and pointing out possible problem areas rmgb file that RootsMagic can restore, media and database. Uses the command versions of SQLite3 (free), WinRAR ($fee) and 7-Zip (free). Possible route to a control of Fact settings for GEDCOM exportīacks up the database file along with all the media files referenced by it to one file. Procedures involving Excel, text editor and SQLite queries to bring Ancestry hyperlinks, citations and images into RootsMagic that are otherwise lost on a straight GEDCOM import. Follow by RM Rebuild Indexes and Compact. RM4 & 5 are differentĭeletes citations of non-existent Sources from database that manifest themselves in the Edit Persons screen as a citation (counted and checkmarked) but return nothing when opened.Ĭleans out unused records from most tables, including phantom citations.
May need checkbox options to select what tables are cleaned.
WEBTREES FIND UNLINKED UPDATE
Rebuild Indexes and Update Birth and Death Yearsĭeletes unused rows from tables as reported by RMGC_Properties. NOT for use on RM4 requires RM5+ Rebuild Indexes after completion. Sets Birth and Death years as seen in the sidebar index and various other reports and displays to match the corresponding facts. N.B., for as long as a fake RMNOCASE collation is used, this REINDEX is needed for external operations on the database and must be followed by RM’s Rebuild Indexes on returning to work the database with RM. RM#_CREATE_as_DB3_NOCASE | RM#_Copy_Data_to_DB3_NOCASEĮxplains why an integrity check is needed and how, using PRAGMA quick_check. Even works with RM but it might trip up on non-English alphabets.
WEBTREES FIND UNLINKED FREE
Makes an empty Master from current database, preserving custom fact types and source templates, Places, Master Sources and associated Repositories and Addresses, and Place/Source Mediaĭepopulate but keep Customs, Places, SourcesĬlones a RM4/5 database without the RMNOCASE collation so that we’re free to do what we want to the data. Lists all addresses in AddressTable and reports how they are used.
List Persons with Blank Names in the Address List - (a fault that may occur in a GEDCOM import). To view the most recent tools, have a look at RM SQLite Queries which is sorted by Date Added. Another way of finding any pages, not just query pages, is by the tag cloud at Find Pages by Tag. This page lists the tools sorted by category.
(Tom Holden )Īddresses | Correspondence | Database | Edit | Facts | Fact Types | File | Functions | Groups | Media | People | Places | Reports | Repositories | Research | Search | Sources | To-Do | Tools This was an attempt, not updated since 2012, to provide a categorised list of pages and scripts and was the basis for the menu structure in RMtrix and the Categories used on this WordPress site. Wikispaces lacked the Category feature of WordPress.
0 kommentar(er)
