Legacy to Rootsmagic Woe

I was stumbling around digging up lost files and came across this list. It was made during the time I was converting the data from Legacy Family Tree to RootsMagic.

It probably goes without saying, but the process took weeks to do. It is not at all smooth, because the two programs operate on totally different foundations and output. Legacy is stuck in the clunky world of Microsoft Access and has built their whole isolated world in their little bubble.

RootsMagic is based on a common and quick and easy database system, but they also have grown up in a Mormon bubble. Their approach is very different and in places very ambiguous, in order to be Mormon approved and run. The truth is that real family tree work is and should be Mormon agnostic, or built on a base that handles family tree data, events and relationships well, and then secondarily has a plug in for Mormons to use. Family tree information predates the Mormon incursions into it, and will far outlast the Mormons (just don’t try to tell them that!).

At any rate, here is a sampling of issues that had to be worked out.

  • Rebuilt website image location program in mysqli
  • Rebuilt headshot image location program in mysqli
  • Fixed ls.jpg reference with replaced graphic in Barney McCoy Douthit fact
  • Fixed lw.jpg reference by deleting from William Bates and Jenssen Witt-Claes
  • Fixed Sanctuary Stings flyer links to Cheryl, Gideon, Deborah, Mark & Naomi Macomber
  • Fixed link to David Kostman appeal document
  • Fixed links to three recital documents in Nelda Griffith
  • Fixed link to Ephraim Leach will
  • Added marriage source for Stephen & Lizzie Macomber
  • Replaced lost document for Stephen & George Macomber in 1880 census
  • Replaced lost document for Rhoda Dore Macomber and family in 1880
  • Fixed link to Elizabeth Whitmore property document in 1897
  • Replaced lost document for Stephen Macomber family in 1850
  • Replaced lost document for Stephen Macomber family in 1860
  • Replaced lost document for Stephen Macomber family in 1870
  • Replaced lost document for Thomas Golden family in 1850
  • Replaced lost document for Thomas Golden family in 1860
  • Replaced lost document for Thomas Golden family in 1870
  • Replaced lost document for Thomas Golden family in 1880
  • Replaced lost documents for Thomas Dore family in 1850

Bitely updates

Hamilton Bitely sent a gravestone photo of Cyrus Bitely, and this inspired the following additions:

  1. Expanded the Bitely family back to 1720
  2. John Bitely residence in 1779
  3. Jacob Bitely family in 1850
  4. Jacob Bitely family in 1850
  5. Stephen Bitely family in 1850
  6. Jacob Bitely grave 1820
  7. Jacob Bitely memorial

June 12 updates

We are still rebuilding from the wreckage that came to our whole computer system the first half of this year. There is going to be a huge amount of things we will not be able to replace, but we had one victory today! We were able to salvage the emails sent in May! We still are trying to get emails sent from December of last year through April, but have not gotten that done yet, and may not be able to do so.

I’m also faced with another dilemma! My website is so popular, I need to somehow come up with $150 to keep it going! We have maxed out the limits of our current business plan host account and have to upgrade to the next level. I sure wish I could count on help, but we may just need to shut this all down. I may have a couple months to think about it, but things do not look good right now. I certainly don’t have this money, and there is no chance I will find it. We are on public welfare, and cannot afford even the basics of life, even the medicines required to stay alive.

  1. Thomas Martellone sent a photo of McGuire Cemetery as well as how to find it.
  2. Byron Bitely gravestone sent by Hamilton Bitely.
  3. Daniel Sylvester Allen data updated and memorial added, along with several folks from Alice Monschke.

Cleve Erhardt updates

Linda Sebastian has helped the family again! Wish we had more diligent folks like her! She sent scans of information gleaned from a visit with Linda Johnson. We are so glad to add these important things:

  • Cleve Erhardt obituary image, text, and facts processed to all mentioned
  • Cleve & Eshter Erhardt wedding photo: better quality scan
  • Brainard Store photo
  • Jamie Koenigs family photo
  • Esther Erhardt obituary image, text and facts processed to all mentioned
  • Lillian Miller husband
  • Shirley Bauman

     

From other sources:

  • Lillian Miller death
  • Walter Bauman full name
  • Gordon Bauman
  • Walter Bauman parents
  • John Brackin Family added
  • Merged and expanded Christian Freiberghaus family
  • Elisabeth Jacob memorial
  • Benedict Jacob memorial

Orchard Mesa Municipal Cemeteries:

  • Caroline Bauman memorial
  • Caroline Baumann record
  • John Bauman memorial
  • John Bauman record
  • Walter Bauman memorial
  • Walter Bauman grave
  • Hulda Bauman grave
  • Hulda Bauman memorial

HUGE Update

We have been struggling for months now with new desktop software, getting data converted, multiple computer crashes and rebuilds, and lots of lost data. It is still not over, but we have just gotten a huge upload done from the new software.

Because there was a desktop software program change, there will be a lot of changes in the website data presentations and tagging. Hopefully we have minimized this as much as possible ahead of time, but still, it will be there.

Second, this data is the presentation of months of work and changes: meaning there are hundreds of new people and thousands of new facts that have been added.

Due to the multiple computer crashes, we do not have a listing of all the new stuff that was added. These lists got destroyed in the computer problems.

There is another sad note. We have lost many emails that were sent from December to the present. We are slowly trying to mine out these emails and hopefully will eventually uncover them, but they may be lost forever. We truly regret this!

Software Updates

It is already time for a subversion update of The Next Generation Software. The update seems to have gone pretty smoothly with most of the work being done behind the scenes. After completing the main software update we had to redo our many modification scripts. The process was a bit awkward not having my website developer software fully installed and going, having lost the websites on my data hard drive in the recent computer troubles.

  • Cleaned up and reinstalled 22 mods that had no new changes
  • Mouse wheel zoom was updated
  • Submit Photo/Document was updated and attachments were increased to 10 items and rtf style added to file types
  • Footer Copyright notice updated and edited
  • Display social buttons mod updated

Where’s the Updates?

“Man is born to trouble as sparks fly upwards!” so say the prophets. Men are born to face trouble and get incinerated facing it. A worthless man avoids the trouble and quietly rots away in the darkness, never to be heard, never to do anything and never to be remembered. Such is the chattel of society. Quietly live, quietly rot, quietly disappear, leave no mark, leave no name.

I certainly have my trials for trying to do something, and it is always a challenge to keep trying. My computer recently lost its coolant and then when my helper was refilling it, it got water damage and fried. The process of trying to salvage the old warhorse was long and grim, and at last it was given up. Then the process of getting the most bang for the buck ensued and Gideon tried to get the best he could on a limited spending allocation. Some say loudly: “you get what you pay for!” and it was said quite a bit the last few weeks. We also said, we will somehow make do. We kept trying to push past all the gluts of challenges and am getting closer to having a working machine.

It may be a couple weeks before we can be back to business as usual, because we still have to get a large data drive recovered. It is dead, and we are looking into seeing if we can replace a part or two to get the data off of it. My backups appear to have not been working for some time, so we have really lost a lot during the last few weeks. Of the greatest losses is the email and email archives. We have yet to find a way to salvage them. I have over four months of emails that were waiting to be handled.

Pray with us! Somehow we will overcome or get burned up trying!

Software Update

The TNG website software underwent a lot of changes, so it was time to upgrade it to the next subversion level. We did that and the following mods were reinstalled.

  1. Life Dates on Separate Lines updated
  2. Add person Row reinstalled
  3. Ancestor Map updated
  4. Burial Website Media Import updated
  5. Cemetery Disclaimer (my mod) upgraded & updated and webpage updated
  6. Create Sitemap updated
  7. Social Buttons reinstalled
  8. Children event map updated
  9. Email sender’s IP to help stop spam comments added
  10. Family Indicators updated
  11. Family Preview updated
  12. Family Group Worksheet extension updated
  13. FGW tabs updated
  14. ID Prefix format updated
  15. Tooltip media updated
  16. Mouse Wheel Zoom updated
  17. New Account Request Form mod updated and heavily customized
  18. Removed password generator
  19. Personal Table Maintenance updated
  20. Person not found updated
  21. Places subject to deletion updated
  22. Redundant Persons tab updated
  23. Search from help reinstalled
  24. Submit headstone photo updated
  25. Submit photo mod reinstalled
  26. Submit photo/document updated
  27. Surname Cloud tooltip updated
  28. User footer copyright mod updated
  29. American Dates reinstalled
  30. Hebrew Dates on hold

WAMP server setup on my desktop computer. IIS server had to be shut down and the various services using it had to be stopped. Once I found all the SQL types and shut them off, things began to work! Surprise!

TNG installed on WAMP server. This worked out pretty well. Next was the data move and it was a real problem. Several data dumps from the website later, we managed to find a way for BigDump to do the job, and it did it!

Next we created a Gedcom from RootsMagic and it took a long time. We ran the import on TNG desktop and it worked well! Surprise. The combing of the results has yielded some problems to overcome:

  1. _Color tag is worthless in TNG, turned off of desktop verson
  2. Family Search tag of event needed to be labeled, done on desktop
  3. Place details is actually just an address holder, so cemeteries and addresses that were setup in RootsMagic must be corrected so TNG’s cemetery feature can work.
  4. County had to be deleted from RootsMagic places and so before merge should be deleted from TNG data, or there will be several hundred more unused Places.
  5. Cemeteries in TNG had to have “of America” dropped from United States even for old data to work
  6. Cemetery Disclaimer had removed the name from the page, code repaired, zipped uploaded, wiki fixed
  7. Memorial Footnotes fixed for FindAGrave of recent entries
  8. Place names address fields reworked to show address and not place name, while preserving old address details. Done with temp tables, perl, regex, and sqlite ide

Hundreds of small address fixes and additions where missing.

Change of Douthit Family Cemetery of Piedmont SC from address to place again

Many streets added to address field and those that were present had the following fixes made:

  1. Rd. to Road
  2. Rd to Road
  3. St. to Street
  4. St to Street
  5. Ave. to Avenue
  6. Ave to Avenue
  7. S. to South
  8. N. to North
  9. W. to West
  10. E. to East
  11. Blvd. to Boulevard
  12. Blvd to Boulevard
  13. Dr. to Drive
  14. Dr to Drive

Finally succeeded in getting the address field information corrected and merged! Wow, that alone took all week!

Known duplicate addresses were removed.

Test export of data to desktop TNG successful.

 

Howard Young Douthit family

Objectives

  1. Glean information from Find A Grave on Howard Douthit and family
  2. Add Census data and other pertinent information on his family
  3. Add amazing photo, map, and other information from Louise Thetford

Implementation

  1. Ira Bessie Douthit memorial
  2. Gatlin Cemetery, Limestone County, Alabama (cemetery 2016)
  3. George William Evans memorial
  4. Rosa Eaves memorial
  5. Zane Douthit memorial
  6. Infant Douthit memorial
  7. Leslie Douthit memorial
  8. Mount Pleasant Cemetery, Limestone County, Alabama (cemetery 2017)
  9. Rebecca Thornton Eaves memorial
  10. Joel Calvin Eaves memorial
  11. Nannie Eaves memorial
  12. Huntsville Memory Gardens Cemetery, Madison County, Alabama (cemetery 2018)
  13. Marcella Douthit Bolton memorial
  14. Thomas Bolton memorial
  15. Howard Douthit memorial
  16. Addie Bea Douthit memorial
  17. George Skinny Douthit memorial
  18. Mabel Douthit memorial
  19. Mary Ella Ferguson memorial
  20. William Green Ferguson memorial
  21. William Edward Douthit memorial
  22. Evangeline Douthit memorial
  23. Gail George memorial
  24. Maggie Douthit memorial
  25. Mary E. Douthit memorial
  26. Ernest Douthit memorial
  27. Athens City Cemetery, Limestone County, Alabama (cemetery 2019)
  28. Elizabeth Douthit memorial
  29. Rev. Samuel Hunter memorial
  30. Ella Hunter memorial
  31. Limestone Memorial Gardens Cemetery, Limestone County, Alabama (cemetery 2020)
  32. Ruth Douthit Lindsay memorial
  33. Mike Lindsay memorial
  34. Ruby Douthit Stripling memorial
  35. Robert Stripling memorial
  36. Hatchett Cemetery, Limestone County, Alabama (cemetery 2021)
  37. Verna Douthit memorial
  38. Marcell Douthit memorial
  39. Reba Douthit memorial
  40. Computer restarted and RootsMagic had not kept items 31-39, so data relocated and reentered. Reason unknown. Data readded. Program Database tools run, but compact still cannot run. Restarted program, data still present.
  41. Oakwood Cemetery, Colbert County, Alabama (cemetery 2022)
  42. Addie Henderson memorial
  43. Douglas Henderson memorial
  44. Page by page search for Douthits in Lincoln County, Tennessee, District 16: negative
  45. Page by page search for Douthits in Lincoln County, Tennessee, District 13: positive, pg 24
  46. Calvin Douthit in 1850
  47. Enoch Douthit family in 1850
  48. Calvin Douthit family in 1860
  49. Elizabeth Brasier family in 1860
  50. Enoch Brasier family in 1860
  51. Wiley Brazier in 1860
  52. Wiley Brasier family in 1850
  53. Calvin Douthit family in 1870
  54. Calvin Young Douthit family in 1880
  55. Monroe Douthit family in 1880
  56. Marcell Douthit family in 1900
  57. Gatlin Cemetery Burials reformatted
  58. Mount Pleasant Cemetery Burials reformatted
  59. Huntsville cemetery burials reformatted
  60. Athens City Cemetery burials reformatted
  61. Limestone Cemeterey burials reformatted
  62. Hatchett Cemetery burial reformed
  63. Oakwood burials reformed
  64. Marcell Douthit family in 1920
  65. Marcell Douthit family in 1930
  66. Fixed Puffer Place spelling errors in Albert Douthit family
  67. Howard Y. Douthit family in 1920
  68. Howard Y. Douthit family in 1940
  69. Howard Y. Douthit family in 1930
  70. Williard Douthit memorial
  71. Howard Y. Douthit in WWI
  72. Photo by Louise Thetford of H. Y. Douthit Cotton Gin Building and staff
  73. Moody Family added from Louise Thetford tree and email

Website Data Update delay

We are having to revise our processes that we use to update the website data. We were forced to leave Legacy Family Tree desktop software, because we have outgrown it by 200% capacity. We were not aware there was only a theoretical limit of a billion records, and not a practical limit of less than 100,000. We are frankly impressed at our tenancity to reach twice the actual limits and still kinda kept things going. We just wish the technitians would have told us of the limits so we would not have wastes so much time trying to make their software work when we were so far past its limits.

With the change in desktop software comes a huge amount of change in data. We chose RootsMagic for several reasons, but it has become apparent they also have cemented their way into a corner also. Legacy idolizes the corrupt and evil Microsoft System and their expesive ways of doing things. They have forced themselves into a really tight corner trying to make things work in this very difficult to diagnose system, and should be commended for what they did do, but they cannot correct their huge deficiancies until they chuck out the door the program core and rebuild their system using one of several superior ways of handling data.

Rootsmagic has locked themselves out of doing the things they need to do and what Legacy did, because they have adopted some bad forms for data entry and storage. Now with their customer base they are stuck with some really bad forms, and cannot dig their way out with their current way of doing things. The areas they need to fix require revamping their data tables and changing their forms, but they cannot do this and not bring about a huge problem to their current users. Anything they do now has to be done in little steps and conversions of existing forms of data have to be made.

Legacy has a problem with rolling out great features but never finishing them into a polished end that flows well with their system. They like to add this and before working out bugs and making it truly useful, they jump to another good idea and totally abandon the last project half baked. Now it takes a ton of clicking to do the littlest things, and nothing ever really works well, so the program crashes constantly.

Rootsmagic can most certainly handle the huge loads of data and had done well in making the data accessible by sqlite. But they monkey wrenched things but creating some strange character compilation that they do not release, so users cannot do that much to the data on their own.

At any rate, we got bogged down setting things up in RootsMagic and then learning their way of doing things. It also took quite a bit of time getting the data changed to fit their way of doing things. There is another article on that process which is ongoing.

The problems currently have involved the update of the data on the Website. During the time of changing desktop software, there was a big upgrade of the website TNG software, and it required the mods to be redone and took a bit of work and several days. We have that completed but now have to get our RootsMagic gedcom to merge well with the current data.

In order to do that we needed to get a good desktop web server going. We have one, but it was not working well with TNG. We turned all the things off on it and installed a standard WAMP server and things went pretty well once we had the conflicting server services all cancelled.

But the first merging of the new type of Gedcom demonstrated a bunch of issues that need to be resolved and we are working through them in hopes we can do a website update in a week or two, and get back to our data updating.

At this point things look promising. The gedcom did work well with the Legacy data already online, and the bugs are being worked out so I believe it will work with less problems online once some more changes are made.

Please bear with us in the interim!

We had one person call us that they could not get emails to be accepted by our webserver host. My emails have fallen dramatically and I am thinking she may be right. My test emails get through, but I may post an alternate email for a while to see if things work better on it. Just another thing to pursue!

Have fun, Clinton.