Tech Forum

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.

New version of project.

HCF Project v01.01

Change log:

Added a menu
Fixed "Assign a child to a family"
Changed field name in "Individuals" table

I pulled this project out of my proverbial drawer. It would be wonderful to get some input.

I could really use help with making a tree.

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)
)