Is there a recommended way to sort facts on an Edit Person page when the facts are undated?
Undated facts can still be given sort dates.
That’s been my approach to-date (see what I did there?) but wanted to see if there was a better option. Thx!
Enhancement requests have been made in the past for a feature that would apply a ‘natural’ sort order for undated events. Some attempts have been made using outboard tools to apply computed Sort Dates to them.
My SQL maintenance script looks at certain classes of events that generally don’t have dates and assigns sort dates so the undated events sort the same in each person’s edit window.
Is that a script you’re willing to share? Sounds quite useful.
My reply was done from my phone. If you have any questions about the script, email me at
RichardJOtter at the mail system of google. You know what I mean, gmail.
Is there a place or a You Tube video that can further explain how to use the SQL Lite in order to modify the RM database? I have watched several of the post here and hve the elementary impression that this is something to learn and thus will make the RM database much better.
I don’t know of any videos
Check out my writeup at:
https://richardotter.github.io/#run-sql
I agree there are no videos.
The use of SQLite is not supported by RM. You are on your own, with possible assistance from a few other RM users. The best place to learn how to use SQLite with RM is probably at https://sqlitetoolsforrootsmagic.com/ However, it typically requires a background in computer programming and previous knowledge of SQL (or the ability to learn SQL fairly quickly).
Well, in some cases you can get by with being able to install an SQLite manager and being able to run an SQLite script written by someone else.
@thejerrybryan is right on track on this and it does have it’s nuances , but at the same time it is very useful. I have used SQL extensively for many years. (I wrote my master’s thesis’s research in SQL and I used to do database conversions before I retired last year. ) I have been out of it for a couple of years, but I may be able to help in some feeble way. However, I’m very new to this RM community (this is my second week).
As I re-read some of the earlier posts to this topic I can clearly see that those who posted earlier are wizards that are much more experienced using SQLlite with RM. @tomh and @RichardOtter have done some amazing things and I’ll defer to them. (BTW the link that Jerry referred to is wonderful and it is Tom’s). They are Jedi masters and maybe I can be their Padawan.