Storing genealogy data with MySQL or other databases
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 
GenoPro Support Forum
Home        Members    Who's On
Welcome Guest ( Login | Register )
        


««123»»

Storing genealogy data with MySQL or other databases Expand / Collapse
Author
Message
Post #7857 Posted 8/24/2005 10:26:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/23/2006 11:33:29 AM
GenoPro Version: 1.99
Posts: 4, Visits: 9
I was able to get things to import - though I did have to make a few additional tweaks due to some other CRLF issues. The only problem I have now is that nobody is linked to anybody else. Is this expected behavior? It seems possible that phpGedView purged the drawing data or something...I'm not sure. But although everyone's individual information is intact, no familial relationships are showing.

You're providing amazing customer support, by the way. Thank you! I think a donation will be in order.
Post #7858 Posted 8/24/2005 10:45:42 PM


Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master This user is an important contributor to the translation of GenoPro 

Group: Administrators
Last Login: Today @ 8:36:29 AM
GenoPro Version: 2.4.0.3
Posts: 3,523, Visits: 14,877
Meredith (8/24/2005)
The only problem I have now is that nobody is linked to anybody else. Is this expected behavior?

Not at all.  After importing your Gedcom, I noticed the pedigree links were missing... and I am investigating this too.  Something very strange is going on in the import module.  Wow, you found 3 bugs in one night.  Keep up the good work.


Post #7859 Posted 8/24/2005 11:11:04 PM


Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master This user is an important contributor to the translation of GenoPro 

Group: Administrators
Last Login: Today @ 8:36:29 AM
GenoPro Version: 2.4.0.3
Posts: 3,523, Visits: 14,877
I found the problem.  The .ged file you sent me has only one PEDIGREELINK record.  At the begining of the import routine, GenoPro attempts to locate all PEDIGREELINK records.  If one or more records are found, GenoPro assumes the file contains all the necessary pedigree links to describe all parent-child relationships.  As a result, GenoPro imported a single pedigree link from your file, making the tree appear as if all individuals were disconnected.

I modified the code to handle this case, by never skipping the FAMCchild, FAMSpouse, HUSBand, WIFE and CHILd keywords, even if the file has multiple PEDIGREELINK records.  I am not sure if this modification will cause undesired site effects, so I am crossing my fingers on it.  For the crashing bug, I am still working on it.

What to do:
Delete the PEDIGREELINK record in your Gedcom file using Notepad. After removing the lines below, you will be able to import your family tree as before.

0 PEDIGREELINK
1 PEDIGREE_LINK biological
1 FAMILY @fam00014@
1 INDIVIDUAL @ind00130@



Post #7884 Posted 8/28/2005 1:12:16 AM


Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master This user is an important contributor to the translation of GenoPro 

Group: Administrators
Last Login: Today @ 8:36:29 AM
GenoPro Version: 2.4.0.3
Posts: 3,523, Visits: 14,877
I have fixed the problem in two ways (each way avoids the crash).  First, I improved the parser to detect an illegal sequence of CRLF and normalize it so all keywords are imported.  Another good benefit from this correction is the proper line number is displayed if an error occurs while importing.  The second fix skips any non-root keyword, thus avoid the crash.  The crash you reported was GenoPro attempting to import an unknown (non-root keyword) at the root of the document.

If you ever get a crash importing using Beta14 (or later), please let me know.

I restored the code to import only the PEDIGREELINK.  If a PEDIGREELINK record is found, then the other tags linking objects CHILdren, FAMSpouse, HUSB, WIFE are be ignored.  I cannot do any better at the moment, until the new XML module is being used.

If your file has only one PEDIGREELINK, then your file is structurally corrupted.  You should contact the guys at phpGedView and let them know about this.  Also, make them aware there software is exporting data with an illegal sequence of CRLF, causing the line numbers to be messed up.  The proof is simple: use Notepad and try to open their .ged file.  You will see lines are all messed up.  GenoPro has resolved the problem with the lines, however other genealogy applications may have problems importing files from phpGedView.

Post #7889 Posted 8/28/2005 12:00:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/23/2006 11:33:29 AM
GenoPro Version: 1.99
Posts: 4, Visits: 9
Where can I find Beta14? I didn't see it on the main beta page.

I am definitely going to have to contact the phpGedView folks, because a Gedcom created from scratch with their program did not import successfully into GenoPro beta13h - so I think phpGedView is indeed creating invalid Gedcoms.

I look forward to trying out beta14. You really are amazing with customer support.
Post #7892 Posted 8/28/2005 1:33:43 PM


Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer This user is a contributor to FamilyTrees.GenoPro.com This user is an important contributor to the GenoPro community 

Group: Customers
Last Login: 2 days ago @ 11:23:05 AM
GenoPro Version: 2.0.1.4
Posts: 438, Visits: 3,414
Beta14 isn't out yet, but should be in a few hours (hopefully)

This would explain why you can't find it yet!

Post #7893 Posted 8/28/2005 1:44:09 PM


Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master This user is an important contributor to the translation of GenoPro 

Group: Administrators
Last Login: Today @ 8:36:29 AM
GenoPro Version: 2.4.0.3
Posts: 3,523, Visits: 14,877
iaintait (8/28/2005)
Beta14 isn't out yet, but should be in a few hours (hopefully)

I am currently performing the code review and revising my "todo" list.  I am also generating reports from various .gno files containing names in different languages to make sure there are no problems.

Post #7903 Posted 8/29/2005 4:27:07 AM


Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master This user is an important contributor to the translation of GenoPro 

Group: Administrators
Last Login: Today @ 8:36:29 AM
GenoPro Version: 2.4.0.3
Posts: 3,523, Visits: 14,877
Beta14 is ready at http://www.genopro.com/beta/.  You should not get the crash anymore

Post #10957 Posted 4/13/2006 4:20:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/18/2006 3:49:24 AM
Posts: 1, Visits: 5
Hi - I did a search of the forum and found this post...

I have data about people and their relationships in a database and would like to draw genograms from that data.

Do I understand correctly from this that it would be possible (with some work) for GenoPro to be populated with the information it needs to draw a genogram from the results of a SQL query rather than, for example, someone keying the same infomration (eg: names, dates of birth, relationships etc) by hand into the Family Wizard?

Jon

Post #10964 Posted 4/14/2006 9:04:57 AM


Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master This user is an important contributor to the translation of GenoPro 

Group: Administrators
Last Login: Today @ 8:36:29 AM
GenoPro Version: 2.4.0.3
Posts: 3,523, Visits: 14,877
At the moment, the SQL import is not supported.  What you can do is convert your SQL to XML and import the XML into GenoPro.

Post #13122 Posted 9/14/2006 11:04:13 PM