I have many Places like “(katholisch) xxxxxxxxxx”
How can I this translate to standard place?
and in best case set religion to “rk” etc. ?
That is the person’s religion, so you may want to record that first to each individual, I know of no universal way to accomplish that.
The “Search and Replace” feature may be a good first step, using it to search for the word “katholisch” but I don’t believe that you can replace it with nothing (I personally haven’t tried leaving it blank) but if you have to put in something, then I would suggest a space. This will still leave you with an issue with the location names but now they will sort to the top of your Places list and should be an easy fix from there, alternatively you could run Place Check, where they will show as an issue to be corrected.
Another option may be to simply search place for katholisch if there are not too many and delete the word there. Using this method may actually be better because you’ll be able to see who is using the place name and go to their edit person screen to add the religious info.
A couple ways, off the top of my head, hope this helps some.
“Search and Replace” I had allways done in the past ; it works fine with empty .
replace "(katholisch), " to “”
and then
replace “(katholisch),” to “”
how come this change Places in RM10 to FS?
Is there really no way to set the religion fact by rule?
Can you ask this question again with slightly different wording?
Create a Group of people, where ANY FACT PLACE CONTAINS katholisch
Use Tools>Fact Tools>Add a fact to everyone in a group
2 Likes
good idea !!
Is there a posibility, to delete all "alternate Name"s
Tools>Fact Tools>Remove a fact type from everyone
My apologies, I’m wrong. Was going off flawed memory. RootsMagic lists Alternate Name as a fact, both in the Edit Person screen and under Fact Type list. However, they don’t offer it in such operations. Don’t know why.
if I change in RM some (many!) facts;
how will this changes written to FS?
only via FS-Browser manually ?
Back home now and looking at Alternate Name fact reveals the fact has a Name Type element with 8 possible options, which would have to ALL be the same value and would likely not apply to ALL . So, no way to achieve valid group or mass addition to more than an individual at a time.
Changes (made by you inside RM), after already being “matched”, would not propagate up to FSFT unless initiated manually on your end.
@kbens0n If @thburkhart made an Alternate name fact and named it Alternate name 2 --then changed all those with an Alternate name fact to Alternate name 2,–wouldn’t that work so that Thomas could then use the remove a fact from everyone in tools-- think I would make a group 1st to make sure I wasn’t deleting an alternate name I wanted to keep ( just change it back to Alternate).
An “Alternate Name 2” custom fact type would be an event type, not a name type. The two are not interchangeable as they are stored in different tables with different structures. For Name facts, all are stored in one table; for a person with multiple names, all of the name records are Alternate Names except for (normally) the one record marked as Primary.
It is a trivial SQL query to delete all name records other than those marked Primary.
Hi Tom (Holden)?
ich habe nur triviale SQL-Kenntnisse..
first of all..
wie kann ich eine RM-Datei mit phpadmin oder Heidi SQL öffnen, mit welchen credentials?
Visit Learn – SQLite Tools for RootsMagic to get started. Using SQLite on your database is a double-edged sword - powerful and dangerous. Be conscientious about backing up.
2 Likes
@thburkhart There is an alternative to changing place names which may save you some time if you decide not to use the suggestion @TomH gave (which, as he says, is powerful but dangerous, especially for novices). You can go to your list of all place names in the Places tab and look for any places that start with (katholisch). If you have many records with identical place names, changing the place name there will change it for every place that uses that name.
How can I find the records “not marked primary”
ok I think, I have found this..
Sort “is Primary”
Can I simply mark the “0” records as shown and press delete?
I doesn’t work:
hmm .. das verstehe ich nicht..
This error occurs because RootsMagic has a special proprietary collation (RMNOCASE) that it uses for interpreting and ordering similar characters and special characters with features (like other language sets) not in the basic ASCII set, for sorting, etc.
SQL tools (by default) only “work” with SQLite’s default COLLATION. In order to “emulate” that required RMNOCASE COLLATION (for compatibility)… one can load up the unifuzz64.dll (64-bit) or unifuzz.dll (32-bit) from within the SQL tool (being used) to load a SQLite database and accomplish some operations that would normally fail with an error like your screenshot.
1 Like