Is there a way that someone can transfer what is written in the title(nobility) field into the prefix field all at once, without having to do one person at a time? Have a very large database and would like to change the titles to the prefixs
thank you in advance
kat
Which title field?
Edit person does not have “title”
however, either way from what I under you are describing might only be possible via Sqlite script (outside of RM ) which is not recommended by RM (although may users still use scripts to make such modifications)
No. When you are in edit mode of a person you can click on the + to give a drop down menu like when you want to enter marriage info. But if you scroll all the way down you will find title(nobility). I want to take whatever I have in the title field and put it into the prefix field all at once, not doing it one at a time. My database is extremely large.
I believe you have a fact you are referring to - I get you do not want to do manually.
If the title is under “FACTS” and not on the right person info then it probably is a fact. A screenshot would him with ambiguity. So answer would be YES its possible to do NOT MANUALLY but not possible to do with RM UI. An outside script should be possible.
Kevin
Ok that’s what I thought. Beyond my computer skill.
Title (Nobility) is a standard, built-in fact in RM and it has the Description field enabled. The person’s title is therefore stored in the Description field. Repeating what has already been said, your request cannot be handled all at once from inside of RM. It could be handled all at once with an SQLite script. The script would copy the Description field from the Title (Nobility) fact to the Prefix field.
Writing such a script requires programming skills and running such a script against your RM database is not supported or recommended by the RM folks. Nonetheless, it would be a very easy script. I suggest you investigate further at SQLite Tools for RootsMagic The site is not an official RM site. Rather, it is maintained by RM users.
before running you can ask other users for help there and even AI can help (although you need to be careful to ask “right” question(s) and provide correct context) - The script would likely not be very long and it was take less than a minute to execute if written correctly. As Jerry note RM not support using scripts and of course you make sure you have backups before running
…and the only people that should be dabbling with SQLite and their RM database are already able to figure out that certain things can be done. If one is unsure of what SQLite and scripts and stuff like that are, then one should completely disregard any posts in which apparently well-meaning people are even discussing such things. These suggestions are akin to giving a toddler a hammer and telling him the world is a nail.
