Easier than I thought. Thanks, Bruce. -----Original Message----- From: rootsmagic-users-bounces@rootsweb.com [mailto:rootsmagic-users-bounces@rootsweb.com] On Behalf Of RootsMagic Sent: Monday, January 07, 2013 10:58 AM To: rootsmagic-users@rootsweb.com Subject: Re: [RMagic] Questions about RM Essentials You wouldn't use RM To-Go. Just give him the .rmgc file. - Bruce http://www.rootsmagic.com On Mon, Jan 7, 2013 at 10:44 AM, Jim Bullock <j.b.bullock@comcast.net> wrote: > Can data be transferred using RM To-Go from RM6 to RM Essentials? > > What are the limitations of Essentials, i.e., what is missing that is in the > full version of RM6? > > I've done some research for a friend who is not a genealogist and would like > to put the data with about 200 names on his computer. What I have in mind > is installing Essentials on his computer and transferring the data from my > RM6 file using RM To-Go on a USB drive to his computer. There are no > multimedia files involved. > > Jim Bullock > Littleton, CO > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message =================================== RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ ------------------------------- To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

I think I figured out most of my problems with the bold and underlining in "Create HTML" webpages. In my notes I had some sections privatized, starting at a heading formated for bold and underline. The { before the heading was also bold and underlined. Once I corrected that, the facts and notes looked correct. So it was a user error, and not the fault of RM 6. I still have the problem with the marriage section. It is still in bold (no underlining). This is true for the marriage section of every person in my website. As I said earlier, this problem goes back to websites I created with RM4 and 5, and I've just lived with it. Thanks to Tom and Mike for your suggestions. This list has the most helpful folks! Yvonne Scott ----- Original Message ----- From: "Tom Holden" <ve3meo@gmail.com> To: <rootsmagic-users@rootsweb.com> Sent: Sunday, January 06, 2013 9:07 PM Subject: Re: [RMagic] What's wrong with my webpage? > There is a bug with the report generator that results in unwanted font > changes that we have seen in RTF. Possibly it's the same bug affecting the > reports generated by the Create HTML process. > > Tom > > On 2013-01-06, at 7:27 PM, "Yvonne Scott" <scottlass@triad.rr.com> wrote: > >> Thanks, Mike. .... I expect the "Create HTML" option to create webpages >> with the >> same formating I used in my notes, and with no underlining of facts and >> fact >> notes. I don't want to have to go through all the pages in my website and >> change the code to correct the affected sections. I wonder if others are >> having this same problem? >> >> Yvonne Scott

You wouldn't use RM To-Go. Just give him the .rmgc file. - Bruce http://www.rootsmagic.com On Mon, Jan 7, 2013 at 10:44 AM, Jim Bullock <j.b.bullock@comcast.net> wrote: > Can data be transferred using RM To-Go from RM6 to RM Essentials? > > What are the limitations of Essentials, i.e., what is missing that is in the > full version of RM6? > > I've done some research for a friend who is not a genealogist and would like > to put the data with about 200 names on his computer. What I have in mind > is installing Essentials on his computer and transferring the data from my > RM6 file using RM To-Go on a USB drive to his computer. There are no > multimedia files involved. > > Jim Bullock > Littleton, CO > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Can data be transferred using RM To-Go from RM6 to RM Essentials? What are the limitations of Essentials, i.e., what is missing that is in the full version of RM6? I've done some research for a friend who is not a genealogist and would like to put the data with about 200 names on his computer. What I have in mind is installing Essentials on his computer and transferring the data from my RM6 file using RM To-Go on a USB drive to his computer. There are no multimedia files involved. Jim Bullock Littleton, CO

There is a bug with the report generator that results in unwanted font changes that we have seen in RTF. Possibly it's the same bug affecting the reports generated by the Create HTML process. Tom On 2013-01-06, at 7:27 PM, "Yvonne Scott" <scottlass@triad.rr.com> wrote: > Thanks, Mike. I apppreciate the directions to change the HTML code. However, > I wonder why this is necessary when RootsMagic6 created the website. I did > not altered the code in any way, and wouldn't know how without your > directions. I expect the "Create HTML" option to create webpages with the > same formating I used in my notes, and with no underlining of facts and fact > notes. I don't want to have to go through all the pages in my website and > change the code to correct the affected sections. I wonder if others are > having this same problem? > > Yvonne Scott > > ----- Original Message ----- > From: "Mike Sweeney" <sweeney2@wolfenet.com> > To: <rootsmagic-users@rootsweb.com> > Sent: Sunday, January 06, 2013 1:10 AM > Subject: Re: [RMagic] What's wrong with my webpage? > > >> It can be fixed manually by opening the htm file with Notepad or some >> other text editor. >> find the below bit of code. Remove the first instance of bold <b> as there >> is only one end of bold </b>. >> Add an end of underline </u> after Life. >> >> <p><u><b><p><br><b>A Chronological Record of Britton's Life<p></b> >> >> It really should look more like this: >> <u><b>A Chronological Record of Britton's Life</u></b> >> >> I see now there are several more sections in the file that are missing >> end of bold </b> and one more end of underline </u> missing in the file. >> -Mike >> >> >> On 1/5/2013 6:21 PM, Yvonne Scott wrote: >>> I created a trial website with RootsMagic 6, using the Create HTML >>> option, >>> and it does not look right. >>> >>> Would someone please take a look at this page and notice all the >>> underlined >>> and bold text? http://dl.dropbox.com/u/20843627/b4952.htm >>> >>> There are two headings that are supposed to be in bold & underlined - >>> "Britton Scott's Birth and Parentage" and "A Chronological Record of >>> Britton's Life." But the facts and notes are not in bold and underlined >>> in >>> my database. >>> >>> Notice the formating ends when the children start, but continues again >>> farther down at the facts about a second wife. >>> >>> I have had a website online for several years, created with RM4 and then >>> RM5 >>> and have always had the problem with the marriage section appearing in >>> bold, >>> but I lived with it. I don't think I want to live with all this. >>> >>> Hope someone has a fix for this! >>> >>> Thanks, >>> Yvonne Scott > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Thanks, Mike. I apppreciate the directions to change the HTML code. However, I wonder why this is necessary when RootsMagic6 created the website. I did not altered the code in any way, and wouldn't know how without your directions. I expect the "Create HTML" option to create webpages with the same formating I used in my notes, and with no underlining of facts and fact notes. I don't want to have to go through all the pages in my website and change the code to correct the affected sections. I wonder if others are having this same problem? Yvonne Scott ----- Original Message ----- From: "Mike Sweeney" <sweeney2@wolfenet.com> To: <rootsmagic-users@rootsweb.com> Sent: Sunday, January 06, 2013 1:10 AM Subject: Re: [RMagic] What's wrong with my webpage? > It can be fixed manually by opening the htm file with Notepad or some > other text editor. > find the below bit of code. Remove the first instance of bold <b> as there > is only one end of bold </b>. > Add an end of underline </u> after Life. > > <p><u><b><p><br><b>A Chronological Record of Britton's Life<p></b> > > It really should look more like this: > <u><b>A Chronological Record of Britton's Life</u></b> > > I see now there are several more sections in the file that are missing > end of bold </b> and one more end of underline </u> missing in the file. > -Mike > > > On 1/5/2013 6:21 PM, Yvonne Scott wrote: >> I created a trial website with RootsMagic 6, using the Create HTML >> option, >> and it does not look right. >> >> Would someone please take a look at this page and notice all the >> underlined >> and bold text? http://dl.dropbox.com/u/20843627/b4952.htm >> >> There are two headings that are supposed to be in bold & underlined - >> "Britton Scott's Birth and Parentage" and "A Chronological Record of >> Britton's Life." But the facts and notes are not in bold and underlined >> in >> my database. >> >> Notice the formating ends when the children start, but continues again >> farther down at the facts about a second wife. >> >> I have had a website online for several years, created with RM4 and then >> RM5 >> and have always had the problem with the marriage section appearing in >> bold, >> but I lived with it. I don't think I want to live with all this. >> >> Hope someone has a fix for this! >> >> Thanks, >> Yvonne Scott

Can't be done completely from within RM. Can readily be done using a SQLite query. Best you can do with RM is a Custom Report, comprising: Name, RIN, Death date, Burial Date. Run it on everyone and save to a text file using the .csv extension. Open with Excel and add a column that tests for equal non-empty dates and outputs a flag (say an asterisk). Turn on filtering and filter the result set to show only those rows with the asterisk. Tom -----Original Message----- From: David E. Cann Sent: Saturday, January 05, 2013 7:34 PM To: RootsMagic Users List Posting Subject: [RMagic] Burial/death search within by date I have tried just about everything I can think of to print a specific report of death and burial dates, but cannot seem to find the right combination of criteria to make it work. What I want to do is to print out a list of individuals who have death and burial dates that ARE THE SAME DATE. I have a fair number of them based on a very large cemetery record I managed to obtain, and when I started to notice what seemed to be more than a few folks shown as buried on the same date they died, I questioned it. I was assured they were correct, so I went ahead and entered them as shown. Now, I have more reason to question them and want to go back and change the date of burial to "aft 5 Feb 1891" (or the like) rather than "5 Feb 1891" that it current states. I am very surprised, but I cannot find any means of setting either Search & Replace or any other search tool to result in telling me who is shown with death and burial dates that are the same. Am I missing something, or is there no way of doing this. I prefer a printed list, that way I can do them one at a time and change them that way for accuracy, but if Search and Replace will do it then I can sure live with it. If anyone out there (are you out there Bruce?) reading this can straighten me out, I would appreciate it. Note that now with burials now being in cemeteries that no longer list in place names but in place details, it is now kind of different than it used to be and I cannot find the right combination to make it work. I appreciate any advice available out there, and thank you in advance. David E. Cann decann@infionline.net =================================== RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ ------------------------------- To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Myrna, Please forgive me for jumping in on your post, but I would likewise be interested in printing such a list of people shown with a date of death and date of burial on the same date. I posted myself on the subject yesterday, but no reply yet so I hope it doesn't mean that it cannot be done. As for your query about the living toggle, I think I have done that some time ago when I changed the toggle for a number of people who needed it. It took me a long time to figure out how to do it (it's done in RM Explorer) if my memory serves me correctly (which it sometimes does not), but let me take a look and see what I can find and I will come back if I find anything of any value to you. Sorry to be so vague, but my aging (70) gray matter just is not what it used to be. David E. Cann decann@infionline.net -----Original Message----- From: rootsmagic-users-bounces@rootsweb.com [mailto:rootsmagic-users-bounces@rootsweb.com] On Behalf Of Myrna Sent: Sunday, January 06, 2013 12:00 PM To: rootsmagic-users@rootsweb.com Subject: [RMagic] Custom list of people who are listed as living I have been trying to create a list of everyone in my database that will show everyone I have marked as living. There are some that have died that haven't been changed. Is there a way to do that. Myrna

1. Reports > Print a Report... 2. Lists > Individual List 3. Create Report 4. People to include (change dropdown from "Everyone" to "Select from list" 3. Mark group > Select people by data fields 4. Living flag - is True 5. OK, OK, Generate Report Drew Smith On Sun, Jan 6, 2013 at 11:59 AM, Myrna <m5y13@ida.net> wrote: > I have been trying to create a list of everyone in my database that will > show everyone I have marked as living. There are some that have died that > haven't been changed. > > Is there a way to do that.

I have been trying to create a list of everyone in my database that will show everyone I have marked as living. There are some that have died that haven't been changed. Is there a way to do that. Myrna

It can be fixed manually by opening the htm file with Notepad or some other text editor. find the below bit of code. Remove the first instance of bold <b> as there is only one end of bold </b>. Add an end of underline </u> after Life. <p><u><b><p><br><b>A Chronological Record of Britton's Life<p></b> It really should look more like this: <u><b>A Chronological Record of Britton's Life</u></b> I see now there are several more sections in the file that are missing end of bold </b> and one more end of underline </u> missing in the file. -Mike On 1/5/2013 6:21 PM, Yvonne Scott wrote: > I created a trial website with RootsMagic 6, using the Create HTML option, > and it does not look right. > > Would someone please take a look at this page and notice all the underlined > and bold text? http://dl.dropbox.com/u/20843627/b4952.htm > > There are two headings that are supposed to be in bold & underlined - > "Britton Scott's Birth and Parentage" and "A Chronological Record of > Britton's Life." But the facts and notes are not in bold and underlined in > my database. > > Notice the formating ends when the children start, but continues again > farther down at the facts about a second wife. > > I have had a website online for several years, created with RM4 and then RM5 > and have always had the problem with the marriage section appearing in bold, > but I lived with it. I don't think I want to live with all this. > > Hope someone has a fix for this! > > Thanks, > Yvonne Scott > > > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > -- Mike Sweeney / Cottonwood, Arizona State Coordinator - WAGenWeb http://www.wagenweb.org/ FM WAGenWeb Archives http://www.usgwarchives.net/wa/wafiles.htm CC Wabash Co, IN http://www.ingenweb.org/inwabash/ CC Yakima Co, WA http://www.wagenweb.org/yakima/ CC Grays Harbor Co, WA http://www.wagenweb.org/graysharbor/ CC Stevens Co, KS http://skyways.lib.ks.us/genweb/stevens/

I created a trial website with RootsMagic 6, using the Create HTML option, and it does not look right. Would someone please take a look at this page and notice all the underlined and bold text? http://dl.dropbox.com/u/20843627/b4952.htm There are two headings that are supposed to be in bold & underlined - "Britton Scott's Birth and Parentage" and "A Chronological Record of Britton's Life." But the facts and notes are not in bold and underlined in my database. Notice the formating ends when the children start, but continues again farther down at the facts about a second wife. I have had a website online for several years, created with RM4 and then RM5 and have always had the problem with the marriage section appearing in bold, but I lived with it. I don't think I want to live with all this. Hope someone has a fix for this! Thanks, Yvonne Scott

I have tried just about everything I can think of to print a specific report of death and burial dates, but cannot seem to find the right combination of criteria to make it work. What I want to do is to print out a list of individuals who have death and burial dates that ARE THE SAME DATE. I have a fair number of them based on a very large cemetery record I managed to obtain, and when I started to notice what seemed to be more than a few folks shown as buried on the same date they died, I questioned it. I was assured they were correct, so I went ahead and entered them as shown. Now, I have more reason to question them and want to go back and change the date of burial to "aft 5 Feb 1891" (or the like) rather than "5 Feb 1891" that it current states. I am very surprised, but I cannot find any means of setting either Search & Replace or any other search tool to result in telling me who is shown with death and burial dates that are the same. Am I missing something, or is there no way of doing this. I prefer a printed list, that way I can do them one at a time and change them that way for accuracy, but if Search and Replace will do it then I can sure live with it. If anyone out there (are you out there Bruce?) reading this can straighten me out, I would appreciate it. Note that now with burials now being in cemeteries that no longer list in place names but in place details, it is now kind of different than it used to be and I cannot find the right combination to make it work. I appreciate any advice available out there, and thank you in advance. David E. Cann decann@infionline.net

Hi Tom Thanks for you answer:I had to read it a few times,not being a very technically gifted one. There are >1410000 individuals in my file. As I explained in the Facebook group Technology for Genealogy my own family is but a very small part of my main file,which contains the combined ancestry of most of Europe's crowned heads, American presidents,movie stars (and so on),descendants of king James I/VI of England/Scotland and the genealogists who study all of that.Is it all proven? I spend my days adding,correcting &reviewing data. Well,there is allso a 'fun part' in my file (Irish kinds,Biblical lineages and other hallucinations) -I don't believe anything of it.... I'm co-author of 4 books on the ancestors of tne king of the Belgians,the crown prince,and their wives.That's how I got into it. They arent' related to me,but,why should a genealogist limit himself to this own family? Tou can view a sample of my work here: http://users.telenet.be/JoseVerheecke/index.html I started my computerized files 20 years ago - a dozen others joined in -it did get a bit out of hand,I presume.. José jose.verheecke@telenet.be Errare humanum est, perseverare, diabolicum ----- Original Message ----- From: Tom Holden To: rootsmagic-users@rootsweb.com Sent: Saturday, January 05, 2013 6:09 PM Subject: Re: [RMagic] Maximum Size for a RootsMagic -database There is no definitive answer, Jose, except some hard limits somewhere out there in a 64bit number limiting the size of a table and/or the operating system itself limiting the size of the file. RootsMagic4+ uses the SQLite3 database engine. Here's what its limits are: http://www.sqlite.org/limits.html and reading down to the last paragraph: "The theoretical maximum number of rows in a table is 2^64 (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 140 terabytes will be reached first. A 140 terabytes database can hold no more than approximately 1e+13 rows, and then only if there are no indices and if each row contains very little data." That's 10,000,000,000,000 or 10 trillion rows. That said, there is the question of how long does it take the application, operating system and computer hardware to execute some procedure - all three of these are highly variable: the application on how much is done in SQL versus how much is done in the higher level application development language and with what granularity (i.e., how many calls to the database); the OS on which version and how it is configured; the hardware on disk speed (solid state disks offering a big advantage) and on caching in RAM... and then there is the question of how long a delay we are willing to tolerate. Some RM operations slow down seemingly exponentially with the number of persons in the database, e.g., Duplicate Search Merge. I'm curious to know how many persons are in your 930MB database and why??? Tom =================================== RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ ------------------------------- To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Hi Having recently transferred my data from Legacy(a 2 Gb file,that's the upper limit,according to the their helpdesk) to RootsMagic v6 (a file of 930Mb) -I wonder: what's the maximum size for a RootsMagic-file -before it will become unstable? Yours José Verheecke jose.verheecke@telenet.be Errare humanum est, perseverare, diabolicum

I have a database with 500,000 names and a size of 250 MB. The problem I have with a file this size is that it takes over two minutes for the database to be useable once it is is opened. Once opened, it is plenty fast. Jacques -- Jacques L'Heureux, Saint Louis, Missouri Personal website: http://Jacques.happyOnes.com/ Family website: http://www.happyOnes.com/ Genealogy website: http://Genealogy.happyOnes.com/ Franco-American website: http://www.FrancoAmericanConnection.com/ Sent from my Gateway desktop computer On 1/5/2013 1:00 PM, rootsmagic-users-request@rootsweb.com wrote: > > Message: 2 > Date: Sat, 5 Jan 2013 09:52:31 -0700 > From: RootsMagic <rootsmagic@gmail.com> > Subject: Re: [RMagic] Maximum Size for a RootsMagic -database > To: rootsmagic-users@rootsweb.com > Message-ID: > <CA++G+pbWTfRdezpa3NNcVU=Ewf_-4FEyii99+4U2wi_im--mHw@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > 2TB is the max database size. As for when it might become unstable, I > don't know because nobody has ever come close to the 2TB limit. > > - Bruce > http://www.rootsmagic.com > > > -- > Jacques L'Heureux, Saint Louis, Missouri > > Personal website: http://Jacques.happyOnes.com/ > Family website: http://www.happyOnes.com/ > Genealogy website: http://Genealogy.happyOnes.com/ > Franco-American website: http://www.FrancoAmericanConnection.com/ > > Facebook: http://www.facebook.com/jlheureux > Google +: http://plus.google.com/113368717911839052301/posts > LinkedIn: http://www.linkedin.com/in/jacqueslheureux > --

I would export my own family into a separate RM database by either gedcom or a drag and drop into a new database. Then I would have 2 databases, one for my own family and one for everyone else. I would find it very difficult to work on my family research with that many unrelated people in the database even if I had my family members color coded all the same color. Just selecting people for reports to be restricted to family every time would waste of a lot of time. Laura --------- *From:* José Verheecke <jose.verheecke@telenet.be> *Subject:* Re: [RMagic] Maximum Size for a RootsMagic -database *Date:* Sat, 5 Jan 2013 19:08:59 +0100 *References:* <3A92F72AC10A4099B9A300214CC0695E@JosePC ><9A79E87112604F7F8748BE7742DA198B@toshiba> *In-Reply-To:* <9A79E87112604F7F8748BE7742DA198B@toshiba> ......my own family is but a very small part of my main file,which contains the combined ancestry of most of Europe's crowned heads, American presidents,movie stars (and so on),descendants of king James I/VI of England/Scotland and the genealogists who study all of that.Is it all proven? I spend my days adding,correcting &reviewing data. Well,there is allso a 'fun part' in my file (Irish kinds,Biblical lineages and other hallucinations) -I don't believe anything of it...... José

Apparently there is a definitive limit, José. That's the 2TB that Bruce stated. As he is the chief architect and author of the software, he should know better than I. That has to do with the application development system Delphi and the compilation of SQLite3 he uses with it, DISQLite3, which has a published limit of 2TB, per http://www.yunqa.de/delphi/doku.php/products/sqlite3/feature_chart . If you can't have a bit of fun with genealogy, it would be a little dry ;-) Tom On 2013-01-05, at 1:08 PM, José Verheecke <jose.verheecke@telenet.be> wrote: > Hi Tom > Thanks for you answer:I had to read it a few times,not > being a very technically gifted one. > > There are >1410000 individuals in my file. > As I explained in the Facebook group Technology for Genealogy > my own family is but a very small part of my main file,which contains the > combined ancestry of most of Europe's crowned heads, American > presidents,movie stars (and so on),descendants of king James I/VI of > England/Scotland and the genealogists who study all of that.Is it all > proven? I spend my days adding,correcting &reviewing data. Well,there is > allso a 'fun part' in my file (Irish kinds,Biblical lineages and other > hallucinations) -I don't believe anything of it.... > I'm co-author of 4 books on the ancestors of tne king of the Belgians,the > crown prince,and their wives.That's how I got into it. They arent' related > to me,but,why should a genealogist limit himself to this own family? Tou can > view a sample of my work here: > http://users.telenet.be/JoseVerheecke/index.html > I started my computerized files 20 years ago - > a dozen others joined in -it did get a bit out of hand,I presume.. > José > jose.verheecke@telenet.be > Errare humanum est, > perseverare, diabolicum > > > > ----- Original Message ----- > From: Tom Holden > To: rootsmagic-users@rootsweb.com > Sent: Saturday, January 05, 2013 6:09 PM > Subject: Re: [RMagic] Maximum Size for a RootsMagic -database > > > There is no definitive answer, Jose, except some hard limits somewhere out > there in a 64bit number limiting the size of a table and/or the operating > system itself limiting the size of the file. RootsMagic4+ uses the SQLite3 > database engine. Here's what its limits are: > http://www.sqlite.org/limits.html and reading down to the last paragraph: > "The theoretical maximum number of rows in a table is 2^64 > (18446744073709551616 or about 1.8e+19). This limit is unreachable since the > maximum database size of 140 terabytes will be reached first. A 140 > terabytes database can hold no more than approximately 1e+13 rows, and then > only if there are no indices and if each row contains very little data." > That's 10,000,000,000,000 or 10 trillion rows. > > That said, there is the question of how long does it take the application, > operating system and computer hardware to execute some procedure - all three > of these are highly variable: the application on how much is done in SQL > versus how much is done in the higher level application development language > and with what granularity (i.e., how many calls to the database); the OS on > which version and how it is configured; the hardware on disk speed (solid > state disks offering a big advantage) and on caching in RAM... and then > there is the question of how long a delay we are willing to tolerate. Some > RM operations slow down seemingly exponentially with the number of persons > in the database, e.g., Duplicate Search Merge. > > I'm curious to know how many persons are in your 930MB database and why??? > > Tom > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to > ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without > the quotes in the subject and the body of the message > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

There is no definitive answer, Jose, except some hard limits somewhere out there in a 64bit number limiting the size of a table and/or the operating system itself limiting the size of the file. RootsMagic4+ uses the SQLite3 database engine. Here's what its limits are: http://www.sqlite.org/limits.html and reading down to the last paragraph: "The theoretical maximum number of rows in a table is 2^64 (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 140 terabytes will be reached first. A 140 terabytes database can hold no more than approximately 1e+13 rows, and then only if there are no indices and if each row contains very little data." That's 10,000,000,000,000 or 10 trillion rows. That said, there is the question of how long does it take the application, operating system and computer hardware to execute some procedure - all three of these are highly variable: the application on how much is done in SQL versus how much is done in the higher level application development language and with what granularity (i.e., how many calls to the database); the OS on which version and how it is configured; the hardware on disk speed (solid state disks offering a big advantage) and on caching in RAM... and then there is the question of how long a delay we are willing to tolerate. Some RM operations slow down seemingly exponentially with the number of persons in the database, e.g., Duplicate Search Merge. I'm curious to know how many persons are in your 930MB database and why??? Tom

I have downloaded the Rootsmagic ap to my iphone5. I am having a problem with free-form sources, which is the only kind of source that I use. When I  tap "sources" for a birth, marriage or death, I cannot pull up the research notes portion. This is where I type in all the details including word-for-word obituaries.   Is there any way to view these research notes that are attached to the source citations, in the iphone ap?   Thanx   Nancy From: "rootsmagic-users-request@rootsweb.com" <rootsmagic-users-request@rootsweb.com> >To: rootsmagic-users@rootsweb.com >Sent: Wednesday, January 2, 2013 3:00 AM >Subject: ROOTSMAGIC-USERS Digest, Vol 8, Issue 1 > > > >SEND REQUESTS FOR CHANGES TO YOUR MAILINGS TO: >RootsMagic-Users-Admin@RootsWeb.com > >NOT TO THE MAIL LIST. > >------------------------------- >To unsubscribe from the list, please send an email to >ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without >the quotes in the subject and the body of the message > >Today's Topics: > >  1. Can I make a source private? (Arthur & Pauline Kennedy) >  2. Re: Can I make a source private? (Alfred) >  3. Re: Can I make a source private? (Alfred) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Tue, 01 Jan 2013 20:55:14 +0000 >From: Arthur & Pauline Kennedy <kengen@paxnet.co.uk> >Subject: [RMagic] Can I make a source private? >To: ROOTSMAGIC-USERS@rootsweb.com >Message-ID: <50E34D32.40207@paxnet.co.uk> >Content-Type: text/plain; charset=ISO-8859-1; format=flowed > >When people share information with me I include them in my RM file as >master sources, and put brief details of our correspondence in the >citations. This means that the names at least get listed in the >footnotes to reports, but it has occurred to me that there might be >times when I want to suppress the names but indicate that I could supply >them if appropriate. > >In the Help file I've found reference to a privacy switch for sources: >it seemed to say I could have two versions of the source name (eg "John >Smith" and "Private correspondent - contact me for details") and in the >report options set which one I wished to use. > >However, I can't get it to work (using RM6), so I'm not sure if I've >misunderstood this or am doing it wrong, or if it's not working >properly. In case it's relevant, all my sources are free form (and I >don't intend to change that), and the reports I produce are almost >always Family Group Sheets or Individual Summaries. Is there anyone who >uses this feature who could give me a bit of help, please? > >Thank you, > >Arthur > > > > > >------------------------------ > >Message: 2 >Date: Tue, 01 Jan 2013 18:28:46 -0600 >From: Alfred <adeller@santel.net> >Subject: Re: [RMagic] Can I make a source private? >To: kengen@paxnet.co.uk, rootsmagic-users@rootsweb.com >Message-ID: <50E37F3E.2080805@santel.net> >Content-Type: text/plain; charset=ISO-8859-1; format=flowed > >You almost have to use a template for the template language structures >to work. > >Go to the Lists - Source templates and find a template similar to what >you want and copy it, I think that starting with "Personal Knowledge" >should work. >You can only edit copies of the built in source templates. >I would call it something like PRIVATE CONTRIBUTOR or something to >indicate what it is. > >Limit the fields to" >Source name, >Contributor  (or Name as it is there) >Details (Check the little box for This is a source detail field) > >that's all you need > >In the footnote template add something like: >[Source name], <![Contributor]|Contributor wishes to remain anonymous>, >[Details]. > >Short footnote would be something like: >[Source name], [Details] > >and the bibliography just: >[Source name], <![Contributor]|Contributor wishes to remain anonymous> > >This seems to keep the contributor's name out of the footnote for me. >You would have to enter a different source name for each contributor so >the short footnotes would be for the correct source. > > >Alfred >============ > >Arthur & Pauline Kennedy wrote: >> When people share information with me I include them in my RM file as >> master sources, and put brief details of our correspondence in the >> citations. This means that the names at least get listed in the >> footnotes to reports, but it has occurred to me that there might be >> times when I want to suppress the names but indicate that I could supply >> them if appropriate. >> >> In the Help file I've found reference to a privacy switch for sources: >> it seemed to say I could have two versions of the source name (eg "John >> Smith" and "Private correspondent - contact me for details") and in the >> report options set which one I wished to use. >> >> However, I can't get it to work (using RM6), so I'm not sure if I've >> misunderstood this or am doing it wrong, or if it's not working >> properly. In case it's relevant, all my sources are free form (and I >> don't intend to change that), and the reports I produce are almost >> always Family Group Sheets or Individual Summaries. Is there anyone who >> uses this feature who could give me a bit of help, please? >> >> Thank you, >> >> Arthur >> >>  > > >------------------------------ > >Message: 3 >Date: Tue, 01 Jan 2013 19:33:32 -0600 >From: Alfred <adeller@santel.net> >Subject: Re: [RMagic] Can I make a source private? >To: kengen@paxnet.co.uk, rootsmagic-users@rootsweb.com >Message-ID: <50E38E6C.4010203@santel.net> >Content-Type: text/plain; charset=ISO-8859-1; format=flowed > >I forgot to put my first thought into my first response. > >Add fact, make it Private and attach the source you want to keep private >ONLY to those facts you have marked as private. > >Alfred >=========. > >Arthur & Pauline Kennedy wrote: >> When people share information with me I include them in my RM file as >> master sources, and put brief details of our correspondence in the >> citations. This means that the names at least get listed in the >> footnotes to reports, but it has occurred to me that there might be >> times when I want to suppress the names but indicate that I could supply >> them if appropriate. >> >> In the Help file I've found reference to a privacy switch for sources: >> it seemed to say I could have two versions of the source name (eg "John >> Smith" and "Private correspondent - contact me for details") and in the >> report options set which one I wished to use. >> >> However, I can't get it to work (using RM6), so I'm not sure if I've >> misunderstood this or am doing it wrong, or if it's not working >> properly. In case it's relevant, all my sources are free form (and I >> don't intend to change that), and the reports I produce are almost >> always Family Group Sheets or Individual Summaries. Is there anyone who >> uses this feature who could give me a bit of help, please? >> >> Thank you, >> >> Arthur >> >>  > > >------------------------------ > >To contact the ROOTSMAGIC-USERS list administrator, send an email to >ROOTSMAGIC-USERS-admin@rootsweb.com. > >To post a message to the ROOTSMAGIC-USERS mailing list, send an email to ROOTSMAGIC-USERS@rootsweb.com. > >__________________________________________________________ >To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com >with the word "unsubscribe" without the quotes in the subject and the body of the >email with no additional text. > > >End of ROOTSMAGIC-USERS Digest, Vol 8, Issue 1 >********************************************** > > >