august Posted April 30, 2018 Report Share Posted April 30, 2018 How do I define the Partner Custom Event Type (from gedcom) in order to have it sorted chronologically with spouses? In the following example a partner from 1932 is listed as Family 1 and the wife from 12 Oct 1918 is listed as Family 2: http://vestraat.net/TNG/getperson.php?personID=I147780&tree=IEA Spouses are sorted after the gedcom import. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted April 30, 2018 Report Share Posted April 30, 2018 1 hour ago, august said: How do I define the Partner Custom Event Type (from gedcom) in order to have it sorted chronologically with spouses? In the following example a partner from 1932 is listed as Family 1 and the wife from 12 Oct 1918 is listed as Family 2: If you are importing data, there is no need to Sort Spouse or Children after an import. They should be set to the correct order in your genealogy program. I have never used the Secondary Process > Sort Children or Sort Spouses. If they are not in the correct order, I fix the order in my desktop program. Quote Link to comment Share on other sites More sharing options...
august Posted April 30, 2018 Author Report Share Posted April 30, 2018 I have tried the Sort Spouses but it doesn’t fix the problem. Dragging them manually into order will be overwritten by the next gedcom import. The dates are in perfect order in my desktop program (TMG 9.05). Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted April 30, 2018 Report Share Posted April 30, 2018 TNG normally preserves the order of children and of spouses on import. Maybe TMG does not export them in order. Quote Link to comment Share on other sites More sharing options...
stores Posted April 30, 2018 Report Share Posted April 30, 2018 I have never had to sort spouses either, they are in the correct order in my genealogy program and retain that order in TNG... I do however "Sort Children" after I import a new gedcom because at least one of the mods I have installed requires it. Tables of Descendants is one mod that comes to mind because if a person has children it will not show a "Yes" in that column unless you do a "Sort Children" after importing a new gedcom. I also run "Track Lines" as well because that is needed as well because of a mod. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted April 30, 2018 Report Share Posted April 30, 2018 Jim, That has not been my experience with the Tables of Descendants mod. As far as I know the mod works correctly, but maybe I have not checked closely enough. You do have to run the "Track Lines" after an import Quote Link to comment Share on other sites More sharing options...
august Posted April 30, 2018 Author Report Share Posted April 30, 2018 Even if the sort order was wrong in my desktop program, I do not understand why the sort order is still wrong after I run the Sort Spouses in TNG. Quote Link to comment Share on other sites More sharing options...
august Posted April 30, 2018 Author Report Share Posted April 30, 2018 They had a child in 1932, buy they were not married (TMG uses the event type Partner). Quote Link to comment Share on other sites More sharing options...
stores Posted April 30, 2018 Report Share Posted April 30, 2018 Ken, the mod works fine and I love it but on the right side of the page is the descendants, for the particular generation you click on and you have a childrens column, to show a person has children. That column is blank, instead of having a Yes in it, unless you run the "Sort Children" option when you import a new gedcom. At least that is what I have to do. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted April 30, 2018 Report Share Posted April 30, 2018 Seems to be OK for me without doing any sorts - https://www.royandboucher.com/tng/descendtables.php?personID=I183&tree=T0001&generations=4 Quote Link to comment Share on other sites More sharing options...
stores Posted April 30, 2018 Report Share Posted April 30, 2018 Must be something with my (Offline) site... I have always needed to Sort Children before Yes would appear, after uploading a new gedcom. Quote Link to comment Share on other sites More sharing options...
jayat1familytree Posted May 1, 2018 Report Share Posted May 1, 2018 August If you can look at the data in your database thru your phpmyadmin, then look up the marrdatetr in the tng_families table for your two marriages... F44942 and F 44943 I dont use Year only dates but instead would use Abt. 1832 , you might try changing your desktop program to that and then see if the import sorts it properly. Hope that helps. Jay Quote Link to comment Share on other sites More sharing options...
august Posted May 1, 2018 Author Report Share Posted May 1, 2018 15 hours ago, jayat1familytree said: August I dont use Year only dates but instead would use Abt. 1832 , you might try changing your desktop program to that and then see if the import sorts it properly. Hope that helps. Jay Thank you, I tried this, but it doesn’t help. Quote Link to comment Share on other sites More sharing options...
jayat1familytree Posted May 2, 2018 Report Share Posted May 2, 2018 10 hours ago, august said: Thank you, I tried this, but it doesn’t help. what are the contents of the marrdatetr in the tng_familes table? Quote Link to comment Share on other sites More sharing options...
august Posted May 2, 2018 Author Report Share Posted May 2, 2018 3 hours ago, jayat1familytree said: what are the contents of the marrdatetr in the tng_familes table? Family 1 has the value 0000-00-00. “Partner” is a custom event type defined in my desktop program TMG. Family 2 has the value 1918-10-12. Quote Link to comment Share on other sites More sharing options...
bhemph Posted May 2, 2018 Report Share Posted May 2, 2018 That being all 0 isn't right. What is in the GEDCOM export for the family? Quote Link to comment Share on other sites More sharing options...
august Posted May 2, 2018 Author Report Share Posted May 2, 2018 1 hour ago, bhemph said: That being all 0 isn't right. What is in the GEDCOM export for the family? I updated my TMG database with other info, and after a new export the family numbers are F44943 and F44944: 0 @F44943@ FAM 1 HUSB @I147780@ 1 WIFE @I150122@ 1 CHIL @I147782@ 1 EVEN 2 TYPE Not Marr 2 DATE ABT 1932 0 @F44944@ FAM 1 HUSB @I147780@ 1 WIFE @I147781@ 1 CHIL @I150125@ 1 CHIL @I150126@ 1 MARR 2 DATE 12 OCT 1918 2 PLAC Tromsøysund, Troms 2 SOUR @S178@ 3 PAGE https://media.digitalarkivet.no/kb10811410120288 Quote Link to comment Share on other sites More sharing options...
bhemph Posted May 4, 2018 Report Share Posted May 4, 2018 So it is exported as a custom event, which explains why TNG gives the all 0 date. My desktop program renumbers all the family numbers on each export in the order they are listed in the program, so I don't run into this issue but instead run into media attached to the family jumping to another family at each import. Try editing that marrdatetr to 1932-00-00 that should allow the sort spouses to work as expected. That gives you a couple of options. If there are not too many that you would have to manually adjust and you are not importing too often, you could keep the list of which ones need to have the marrdatetr manually changed before running the sort and fix them that way. Otherwise, you could add a mod to the import code to identify your custom event start date and run an update so that the marrdatetr is populated from the custom event start date if it is all 0. Quote Link to comment Share on other sites More sharing options...
august Posted May 4, 2018 Author Report Share Posted May 4, 2018 I see that TNG released a new version 12.0, maybe it’s a good idea to install this before I decide what to do next. Quote Link to comment Share on other sites More sharing options...
jayat1familytree Posted May 4, 2018 Report Share Posted May 4, 2018 I my Gedcom created in a Legacy Desktop database the "marriages' that are marked as "Partners" are exported in the gedcom as a marriage record with the 'type" partners' and then both a standard marriage and the partner relationships sort properly by the date 0 @F9003@ FAM 1 HUSB @I26411@ 2 _PREF Y 1 WIFE @I26384@ 2 _PREF Y 1 MARR 2 DATE Aft 1960 1 _TAG 1 _TAG9 1 CHAN 2 DATE 1 May 2010 3 TIME 16:41 0 @F9004@ FAM 1 HUSB @I26430@ 1 WIFE @I26384@ 2 _PREF Y 1 _STAT Partners 1 MARR 2 DATE Aft 1960 2 TYPE Partners 1 _TAG 1 _TAG9 1 CHAN 2 DATE 1 May 2010 3 TIME 16:41 0 @F9005@ FAM Hope that helps Jay Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.