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. 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. Sets the Media Type value for each media file to one of the four types: Image, File, Sound, Video, according to the file extension. DescriptionĬreates a Citation WebTag for each citation having an URL beginning the Citation Comments field with “ Not restricted to downloads.Ĭreates Person WebTags from Citation WebTags to consolidate all WebTags pertaining to a person under the WebTags button on the Edit Person Screen.ĭeletes perfectly duplicate WebTags as will occur if WebTags-Consolidate is repeated or other possible cause. Queries are categorized in a menu-like structure on the page Query Menu. The following table lists the queries from most recent to oldest. Some SQLite managers allow you to save a query as a view from the user interface, putting a GUI in front of an internal CREATE VIEW. When successfully executed, the query is embedded in the database as a virtual table which remains with the database file until it is ‘dropped’ (deleted). Optionally, a single query can be expanded to begin with the CREATE VIEW command. Each SQL statement must end with a semi-colon to demark it from the others. Depending on the SQLite manager, you can select which statements you want to run by highlighting them or by placing the cursor anywhere in the one statement to be run. Some smaller standalone queries are combined in one file other larger files may be multiple queries that run in seqence. Others may require you to open the file with a text editor and copy/paste the query into the SQLite manager’s query editor. Some SQLite managers can import a query file and some can also export a query file. Therefore a few queries may be erroneous in dealing with Media, and/or ignore the ResearchLinkTable or the URLtable but most would be unaffected because their purpose does not include these tables. RM6 added the URLtable in support of WebTags. RM5 added the ResearchItemTable and changed the storage of some Media Properties from the tag to the media item. The limitations are due to the changes in database definitions. Likewise, many were developed around RM5 and should also work on RM6, with fewer limitations. Many of these were developed around RootsMagic 4 and should also work on RootsMagic 5 and 6 with limitations. The tag cloud on the home page and the search control are two good ways to find pages of interest. This page has not been updated since 2012 but many scripts have been added since.
0 kommentar(er)
