I've got a client who also is big into genealogy. He's using Brothers Keeper for his desktop application and TNG for his website. ( http://lythgoes.net/genealogy/software.php )

BK allows for tracking of Census Names, but when it is exported into a Gedcom file for import into TNG, it is a level 2 record that TNG doesn't support. If I "promote" that to a level 1 record, then TNG can import it if that tag is entered as a custom tag record.

We'll know shortly if it works out.

I ended up using a low level write method using FPUTS() and various ALLTRIM() to make it work. I used WinMerge ( http://winmerge.org/ ) to compare the before and after Gedcom files. WinMerge is like BeyondCompare but cheaper. I can post the code later but I don't have that VM fired up right now.



On 09/19/2014 07:08 PM, Ted Roche wrote:
Hey, I've got a gedcom file. I'll have to try this.

Not tried, but how about using varchars instead of fixed-width column
fields.

Padded with spaces is a "feature" of FoxPro's fixed columns.


On Fri, Sep 19, 2014 at 3:57 PM, Kevin Cully <[email protected]>
wrote:

Hello Fox Experts!

I'm writing a quick utility to manipulate a text file.  Here's the
(simplified) program I've got so far:

sGedCom = "Gedcom1.ged"
CREATE CURSOR c_GedCom (cType C(7), sF1 C(200), sF2 C(200) )
APPEND FROM (sGedCom) TYPE SDF
REPLACE ALL cType WITH "1 _CENN" FOR cType = "2 _CENN"
sGedCom = FORCEEXT( sGedCom, "GED1" )
COPY TO (sGedCom) TYPE SDF

The Gedcom1.ged has almost a million records but it only takes about 3
seconds to load the file, do the replace, and export. Nice.

MY PROBLEM: the exported file has the trailing spaces on each line while
doing the SDF export.  I basically want each line to be ALLTRIM'd.  I can't
find the right setting or parameter to make that happen.

I can always do a FWRITE() for each line, but I figure there's a built in
way to do this.

Thanks!

[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to