GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum




Table layout - families

Click to view RSS...
Author Data export
Posted Saturday, October 13, 2012 - Post #30764
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Customers
GenoPro version: 3.1.0.1

Last Login: 8 hours ago
Posts: 20, Visits: 142
In the tables of families and relationships, we are only the names of husband and wife and not their IDs. It is not possible to correlate these tables with that of the individuals. You have to add the columns with the IDs of husband and wife. It's possible?
Posted Sunday, October 14, 2012 - Post #30767
Forum Master

Forum MasterForum MasterForum MasterForum MasterForum MasterForum MasterForum MasterForum MasterForum Master

Gamma
Moderators
Administrators
FamilyTrees.GenoPro.com
Customers
GenoPro version: 3.1.0.0

Last Login: Wednesday, October 7, 2020
Posts: 952, Visits: 10,075
You can select what columns you want to use for each display:

Posted Sunday, October 14, 2012 - Post #30769
Grand Master

Grand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand Master

Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 6 hours ago
Posts: 1,579, Visits: 31,355
Jean-Claude
You can not show, on the Family table, the ID of a husband or wife, only the Family ID. You can show the Husband/Wife but not their ID.
Why this is neeed is a differnt question. The ID in GenoPro is not a fixed value. You can delete them all and the program will create new (different) values.
Posted Sunday, October 14, 2012 - Post #30770
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Customers
GenoPro version: 3.1.0.1

Last Login: 8 hours ago
Posts: 20, Visits: 142
If you export the table of individuals and the table of families, you can not connect them.

Edited: Sunday, October 14, 2012 by ermesiti
Posted Sunday, October 14, 2012 - Post #30771
Grand Master

Grand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand Master

Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 6 hours ago
Posts: 1,579, Visits: 31,355
Not sure what you are trying to do, but if you use column properties for indviduals and show 'Display Name' this will produce a field that also occurs in the family table
Posted Sunday, October 14, 2012 - Post #30772
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Customers
GenoPro version: 2.5.4.1

Last Login: Sunday, October 30, 2022
Posts: 45, Visits: 1,256
appleshaw (14-Oct-2012)
Not sure what you are trying to do, but if you use column properties for indviduals and show 'Display Name' this will produce a field that also occurs in the family table


I don't know of any column in the "Family" table layout that is equal to the "Display Name" in the "Individual" table layout.  Are you sure about this Appleshaw?

ermesiti (13-Oct-2012)
In the tables of families and relationships, we are only the names of husband and wife and not their IDsIt is not possible to correlate these tables with that of the individualsYou have to add the columns with the IDs of husband and wife. It's possible?


It is possible.  You have to create your own column and then copy the IDs of the fathers and mothers/husbands and wives into the Individual Table.  This is how I do it:

First, create a 'custom tag' in the 'Tag Editor' in the 'Individual' Tab and name it whatever you like (I use fatherID and motherID).  You can learn more about creating custom tags here.

Second, open 'Individuals' in the 'Table Layout' and sort columns in this order:

1. ID
2. Internal Hyperlink
3. Internal Hyperlink?

Third, in the File menu select 'Export', then "Export to Text Format".  In the 'Summary' Tab be sure the bullet item "Export Friendly Names" is selected.  Then select the 'Individuals' Tab and sort the columns in this order:

1. ID
2. Internal Hyperlink
3. Internal Hyperlink?

Then return to the 'Summary' Tab and select the bullet item "Export Permanent IDs".  After you select "Export Permanent IDs", return to the 'Individuals' Tab and you will see the IDs of the individuals instead of the names.  Now scroll down to the first empty cell in the "Internal Hyperlink" column.  Now scroll right or left until you find the "Fathers" colunm.  Select the first cell of the "Fathers" column (it should have data in it), right-click and select "Copy Column".

Fourth, close the "Export to Text" Dialogue and open 'Individuals' in the 'Table Layout'.  (This should still be sorted the way it was in the second step).  Now you need to scroll down until you find the first empty cell in the "Internal Hyperlink" Column.  Now scroll right or left until you find the "Fathers" column.  Right-click and select "Paste".  This should paste all the corresponding Father IDs to their respective Individuals.

Repeat these steps to do this for the Mother.  You can use the same steps above for the husband and wife IDs as well.  The only difference is you will copy the Husband and Wife Columns in the "Export to Text" Dialogue from the "Families" Tab instead.  I've done the same with Mate IDs and Family IDs.  However, Mate IDs require a few additional steps of separating the multiple IDs that exist in one column by completing the export to the text file and importing it into an Excel spreadsheet and separating by comma delimited.  Then you will have the mate IDs in their own columns and you then paste them into any custom tag columns you've created (i.e. mateID01, mateID02, etc...).

I believe I could avoid all these superfluous steps if the "Export to SQL" Skin in the Report Generator was expanded to include all columns.  Then MySQL or another relational database software could help to create a more relational database that didn't rely on GenoPro.  I would do it, but I don't have the knowledge or the time right now to figure it out now.  Maybe later.
Posted Monday, October 15, 2012 - Post #30774
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Customers
GenoPro version: 3.1.0.1

Last Login: 8 hours ago
Posts: 20, Visits: 142
Right. What you have written is all right, but could be avoided by adding the ID column of the table of families. It would be easy for developers of GenoPro.
Posted Monday, October 15, 2012 - Post #30775
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 7 hours ago
Posts: 3,368, Visits: 25,789
Am I missing something?  Why not just use File/ Export/ Export to Text Format to export your data?

It has a built-in facility to include Husband/Wife IDs in Family records and Mother, Father, Mates, siblings etc. in Individual records.  Just ensure you select the Export Permanent IDs radio button under the summary tab and then select the records you want to export and then for each record use the Show/Hide Columns button and then select the fields you want.  


'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
Posted Monday, October 15, 2012 - Post #30776
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Customers
GenoPro version: 3.1.0.1

Last Login: 8 hours ago
Posts: 20, Visits: 142
Is true. Are precisely the columns that should be in layout tables. And the export would be easier.

Edited: Monday, October 15, 2012 by ermesiti


Similar Topics

Click to view RSS...
Expand / Collapse

Reading This Topic

Expand / Collapse