[wemmons53]

Is there a function to set a default relation if none is specified?
I add Self to the relation list and would like it to be the default.
Thanks for all you help.
Bill

[wemmons53]

Could you explain how I could sponsor a modification?

[wemmons53]

This is example of the relationship export, simple 3 fields needed.

Attachments:

You must be logged in to view attached files.

[wemmons53]

This is example of family and individual records.
Note the ID fields.

Attachments:

You must be logged in to view attached files.

[wemmons53]

Here are some clips explaining how the linking would look/work.

The spreadsheet sample data clip shows and explains my added entry-link field.

The addr table clip show a link example from your address table linking address records to another connection record.

The connections clip show the layout of your connections table and where a entry_link field might be inserted.

Let me know if you have questions.
Thanks
Bill

Attachments:

You must be logged in to view attached files.

[wemmons53]

Did you want sample of the spreadsheet I modified manually, the table update I suggested or something else.

Where is the code that creates the CSV file? I would like to check it out.
Also what routine parses out the information stored in the “Options” field of the connections table?

[wemmons53]

Since I only had 140 records, I manually added the entry_link field to the CSV file I downloaded, then was able to do Excel queries to break apart the data to a usuable format.

[wemmons53]

Steven,
I think the simplest way would be to add a “entry_link” field to the wp_connections table. Since all record types are in the table, ie both family and individual, it would be easy to implement.

Use the entry_link field to store the parent id to connect the child to.
In a family (parent) record, the entry_link value would be the same the id of that record.

In a individual (child) record, the entry_link value would be the value of the id of the parent record if one is associated with it. If not, it would use its own id value.

Then the CVS export would have enough info for a query to separate the records into 2 tables and then have a query to extract what is needed.

What do you think?

Bill

[wemmons53]

Steven,
Once you export the CVS, how can you link the family and the individual records within a family? I also looked at the databases. There is no table to cross connect family with individual records.
I was looking at the family records and see that in the “Options” fields there is has reference the “family” entries. Is the a JSON format or something.
Would be nice if a CVS could also be generated with the cross link records, ie decoding the Options field and generating link records for each entry.

I am trying to create a records update sheet for each family and need the information to prefill an update form sheet. Have there old data on sheet and they verify/update as needed.
Thanks
Bill

[wemmons53]

Works thanks. Now just need to get the lines formatted they way we need them.

[Author]

Posts