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.
FamilySearch.org in Africa
-
- Member
- Posts: 51
- Joined: Wed Jul 11, 2007 3:48 pm
Re: FamilySearch.org in Africa
- Attachments
-
- HCF Project v0.00.zip
- (409.41 KiB) Downloaded 1220 times
-
- Member
- Posts: 51
- Joined: Wed Jul 11, 2007 3:48 pm
Re: FamilySearch.org in Africa
New version of project.
- Attachments
-
- HCF Project v0.01.zip
- (239.42 KiB) Downloaded 1121 times
-
- Member
- Posts: 51
- Joined: Wed Jul 11, 2007 3:48 pm
Re: FamilySearch.org in Africa
HCF Project v01.01
Change log:
Added a menu
Fixed "Assign a child to a family"
Changed field name in "Individuals" table
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 1105 times
-
- Member
- Posts: 51
- Joined: Wed Jul 11, 2007 3:48 pm
Stand alone genealogy software/database
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 917 times
-
- Member
- Posts: 51
- Joined: Wed Jul 11, 2007 3:48 pm
Re: FamilySearch.org in Africa
I could really use help with making a tree.
-
- Member
- Posts: 51
- Joined: Wed Jul 11, 2007 3:48 pm
Re: FamilySearch.org in Africa
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)
)
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)
)