[mso] Re: Clarification
- From: "Andrew" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 27 Dec 2003 00:14:57 -0000
Robert Carneal wrote:
<snip>
What I am attempting to do is take a bona fide Excel CVS file, and convert
it to a Gedcom. Then use my genealogy program to open that Gedcom.
Seems like this route is a dead end. Thank you anyway everyone.
</snip>
A GEDCOM file is a text file in a specific format - each line is a field and
records are defined, as far as I can see, by recurring fields. It wouldn't
be hard (but beyond my rusty programming skills) to create a VB script to
read the Excel file cell by cell and store each field sequentially in GEDCOM
format (i.e. output as a text file in the appropriate format with the
extension .ged). You'd need to know the format of a GEDCOM 'record' but
that doesn't look too tricky. Here's a few lines from one of mine as an
example. The 'file header' appears to be the first 25 lines, then follows a
repeated sequence of 15 lines per record (at least in my case). I don't
know what the numbers 0 to 4 signify at the start of each line but the rest
is fairly clear - field name followed by data:
0 HEAD
1 SOUR PAF
2 NAME Personal Ancestral File
2 VERS 5.1.12.0
2 CORP The Church of Jesus Christ of Latter-day Saints
3 ADDR 50 East North Temple Street
4 CONT Salt Lake City, UT 84150
4 CONT USA
1 DEST Other
1 DATE 9 Mar 2003
2 TIME 09:40:03
1 FILE kendon.ged
1 GEDC
2 VERS 5.5
2 FORM LINEAGE-LINKED
1 CHAR UTF-8
1 LANG English
1 SUBM @SUB1@
0 @SUB1@ SUBM
1 NAME Andrew Kendon
1 ADDR
2 CONT
2 CONT
1 CTRY
1 EMAIL
0 @I1@ INDI
1 NAME Andrew Francis /Kendon/
2 SURN Kendon
2 GIVN Andrew Francis
1 SEX M
1 BIRT
2 DATE 8 Dec 1940
2 PLAC Cambridge, England
1 REFN P1
1 _UID CA732F1D460E774C9EB98C6B790C5460270A
1 FAMS @F1@
1 FAMC @F2@
1 CHAN
2 DATE 30 Oct 2001
3 TIME 16:37:13
...
Hope this helps
Andrew
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
