FamilySearch.org in Africa

richardsontb
Member
Posts: 50
Joined: Wed Jul 11, 2007 3:48 pm

Re: FamilySearch.org in Africa

#11

Post by richardsontb »

At the beginning of this topic I was working on a php/SQLite/web server solution. It failed because I didn't have the time to hammer it out. In the interim, FamilySearch.org has changed. My favorite change is the completely rebuilt source attachment process. Instead of a source being attached just to the person you are working on, it gets attached to everyone that is referenced. This single change has really improved accuracy (my opinion, not based on actual statistics.) My personal genealogical efforts have been focused on standardizing locations as well as attaching sources that FamilySearch.org finds. I have found that that RootsMagic allows me to pinpoint locations where standardization is needed.

What is my point? A multiplicity of tools in my family history toolbox improves the quality of my work and the amount I can contribute to my ancestors. In working on "FamilySearch.org in Africa", I can see where gedcomx/php can be used to merge data into FamilySearch.org. Using Microsoft Access has allows me a smaller development cycle. Additionally, databases are databases. What I mean is, Microsoft Access allows me to work through some of the structural issues. Later, I can transfer it to MySQL, or whatever. FamilySearch.org shows me one way to solve problems. RootsMagic has shown me others. The open source project GRAMPS has shown me yet more. The key is to make Family History tools accessible to our resource poor Brothers and Sisters.
Attachments
HCF Project v0.00.zip
(409.41 KiB) Downloaded 631 times
richardsontb
Member
Posts: 50
Joined: Wed Jul 11, 2007 3:48 pm

Re: FamilySearch.org in Africa

#12

Post by richardsontb »

New version of project.
Attachments
HCF Project v0.01.zip
(239.42 KiB) Downloaded 555 times
richardsontb
Member
Posts: 50
Joined: Wed Jul 11, 2007 3:48 pm

Re: FamilySearch.org in Africa

#13

Post by richardsontb »

HCF Project v01.01

Change log:

Added a menu
Fixed "Assign a child to a family"
Changed field name in "Individuals" table
Attachments
HCF Project v0.01.01.zip
(192.96 KiB) Downloaded 550 times
richardsontb
Member
Posts: 50
Joined: Wed Jul 11, 2007 3:48 pm

Stand alone genealogy software/database

#14

Post by richardsontb »

I pulled this project out of my proverbial drawer. It would be wonderful to get some input.
Attachments
HCF Project 20210202.zip
(97.76 KiB) Downloaded 379 times
richardsontb
Member
Posts: 50
Joined: Wed Jul 11, 2007 3:48 pm

Re: FamilySearch.org in Africa

#15

Post by richardsontb »

I could really use help with making a tree.
richardsontb
Member
Posts: 50
Joined: Wed Jul 11, 2007 3:48 pm

Re: FamilySearch.org in Africa

#16

Post by richardsontb »

I have the following tables. I use PHP as the interface. I would like to get rid of the Full Name field. I feel that is redundant. I am soliciting input as to how make the Given Name and Surname searchable by Surname first.

Second. How can I learn how to link a database with these tables to FamilySearch? Probably view only.

CREATE TABLE "Families" (
"ID" INTEGER NOT NULL UNIQUE,
"Father ID" integer,
"Mother ID" integer,
"Marriage Date" varchar(50),
"Marriage Location" varchar(255),
PRIMARY KEY("ID" AUTOINCREMENT)
)
CREATE TABLE "FamilySearch" (
"ID" INTEGER NOT NULL UNIQUE,
"Individual ID" INTEGER,
"FamilySearch ID" TEXT,
PRIMARY KEY("ID" AUTOINCREMENT)
)
CREATE TABLE "Individuals" (
"ID" INTEGER NOT NULL UNIQUE,
"Full Name" TEXT,
"Given Name" TEXT,
"Surname" TEXT,
"Sex" TEXT,
"Birth" TEXT,
"Birth Location" TEXT,
"Christening" TEXT,
"Christening Location" TEXT,
"Death" TEXT,
"Death Location" TEXT,
"Burial" TEXT,
"Burial Location" TEXT,
"Family ID" TEXT,
PRIMARY KEY("ID" AUTOINCREMENT)
)
CREATE TABLE "Sex" (
"ID" INTEGER NOT NULL UNIQUE,
"Sex ID" INTEGER,
"Sex" TEXT,
PRIMARY KEY("ID" AUTOINCREMENT)
)
Post Reply

Return to “Software Development”