|
By ermesiti - Saturday, October 13, 2012
|
|
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?
|
|
By jcmorin - Sunday, October 14, 2012
|
You can select what columns you want to use for each display:
|
|
By appleshaw - Sunday, October 14, 2012
|
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.
|
|
By ermesiti - Sunday, October 14, 2012
|
|
If you export the table of individuals and the table of families, you can not connect them.
|
|
By appleshaw - Sunday, October 14, 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
|
|
By rfiorille - Sunday, October 14, 2012
|
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 tableI 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 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?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.
|
|
By ermesiti - Monday, October 15, 2012
|
|
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.
|
|
By genome - Monday, October 15, 2012
|
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.
|
|
By ermesiti - Monday, October 15, 2012
|
|
Is true. Are precisely the columns that should be in layout tables. And the export would be easier.
|