Logo Home    Page list

RootsMagic 7

RootsMagic 7 was released on 25 Nov 2014. It will take some time to answer the following questions:
  1. Which SQLite scripts on this wiki need to be revised? Identifying changes in the database design will trigger areas to investigate.
  2. Which ones can be retired? Requires comparing the functional capabilities of RootsMagic 7 to those of the relevant scripts.
  3. Are there new exploits needed? Depends on user feedback in various forums.
Your help in this process is needed; the size of this wiki is too much to expect one person to handle in a timely fashion.

SQLiteToolsForRootsMagic Blazes Trails

Some of the new features of RootsMagic 7 were conceived and/or pioneered on this wiki. Only the RootsMagician can say what influence it has had on product development. Some examples:
New Feature
Wiki Page
Wiki Date
Compare Files
Comparing Two RM Databases
2011-12
Import Lists
Depopulate but keep Customs, Places, Sources
Database - Copy Master Lists to Shell
2011-12
2014-10
Backup and Restore with Media
Backup Media with Database - RAR
Backup Media with Database - 7Zip
2011-02
2011-03
Quick Groups
Named Group - Mark or Unmark List refresh
2011-11



Okay, a couple of those might be a bit of a stretch...

Database Structure Unchanged from RM6

There have been no changes to the SQLite database structure between RootsMagic 6 and 7. The database version stored in the ConfigTable remains at "6000". Results (or absence thereof) from the following queries (run individually) support these observations. The main database was an empty one created by RootsMagic 6; the attached one was an empty one created by RootsMagic 7.
SELECT * FROM main.sqlite_master OLD
LEFT JOIN EmptyRM7000.sqlite_master NEW USING(name)
WHERE OLD.SQL NOT LIKE NEW.SQL
ORDER BY name;
 
SELECT * FROM main.sqlite_master OLD
LEFT JOIN main.sqlite_master NEW USING(name)
WHERE OLD.SQL NOT LIKE NEW.SQL
ORDER BY name;
 
SELECT CAST(DataRec AS TEXT) FROM EmptyRM7000.ConfigTable
;
That is not to suggest that one can work on the same database with both versions with impunity. There will have been changes in how fields are used, perhaps the meanings of some values, giving rise to possible problems. However, the RootsMagician says in a private email on 26 Nov: "Yes. You should be able to switch back and forth between 6 and 7."

Discussions

chiptobey

Place update query

chiptobey 27 February 2017 00:12:37

Short question:
I need a query to concatenate the place detail to the place.

Long question: I used the data clean and moved things like cemetery name to the place detail. When I went to combine like places, I found this to be the wrong course as I would have to count the record position that had place detail so I would combine places resulting on people being born in the cemetery. Bruce could fix this by displaying the details on the list of locations to be combined but that hasn't happen yet.

I have 100's of these places and need to get the detail info back into the place so I can see which ones need to be combined.

Can you email chiptobey1@hotmail.com as well as posting? Thanks!!

www.000webhost.com