For example, I have an imported GED and several people have a ‘Residence’ event that corresponds with a Census and there are no details, sources, notes, etc.
What I’ve been doing is deleting each of these Facts, and then entering a Census Fact with the details, etc.
It would be really nice to be able to delete all of these unwanted (for whatever reason) Facts in one operation.
Example, click a button (or link) that makes checkboxes appear for each fact that could be individually checked and deleted (with a warning your deleting x number of facts, are you sure?). Or, perhaps each Fact could then be multi-selected/highlighted and then deleted?
you can bulk delete ALL Facts by a particular type (Such as Residence) – it would delete all residence for all people for example. Not sure if you want to go that route. Are there exceptions? Residence facts like that often come from Ancestry etc. They do not use CENSUS facts. If you can better articulate exactly the desired outcome – someone should be able to advise best course of action.
there is no check box selection to delete multiple items from a person’s edit screen. The would be a feature enhancement (which might have been previously suggested not sure).
If you want to identify people who might have duplicate facts for residence such as above – there are a few options do that but most of them would be outside of the main program – such as custom report etc.
You can save the delete step and just select each Residence fact in the left pane of the Edit Person screen, followed by clicking the Fact type at the top of the right pane to CHANGE that Residence fact to a Census fact (type).
Yes, that’s a potential work-around in some cases.
Actually, in most of these cases I simply want to delete the fact altogether (for a variety of reasons) and in some cases (like the one I posted), only ‘Census’ is available to change to whereas I’m wanting to add ‘Census (family)’ for some of the entries, but the option isn’t available to switch to.
Being able to multi-select data (i.e. a Fact line in this case) for deletion would be great.
Yeah, that’s what I was thinking. Or going into a SQLite interface. Too bad there isn’t an easier way to accomplish this. Perhaps someday there will be.
I do not believe there is with in RM for what you are looking to do.
RM discourages use of SQL to manipulate DB. That said – if you do – make sure you have backups, make sure you fully understand ant script your run to update or remove records etc. Very easy to make a mistake (Big Mistake)
Definitely! I used to be a programmer for several state Medi-Caid accounts, working with SQL Server (& Oracle and MySQL in some instances), so yeah…write the query or SP once, check twice+ (even with peer review) before running even in a test environment. Not fun having to explain to the DBA (or the boss, or worse yet…in a client meeting (been in one before with someone else)) why the data needs to be reloaded
With this, I’m thinking in terms of an Excel spreadsheet and being able to select more than one row of data for deletion. Seems like a basic idea, but alas, no such luck in this case. Yet, anyway.
If you are familiar with Power BI - you can use a Data Connector – that is where I view lots of things. If you want to do within RM – you can do a customer report them export to Excel.
(Then you have data refreshed, incremental refresh and so on where things can break if someone else changes something)
