BBPress Wemmons53 : Replies Created

Forum Replies Created

Viewing 10 posts - 1 through 10 (of 29 total)
  • Author
    Posts
  • in reply to: Select Relaton #449249
    wemmons53
    Participant

    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

    in reply to: Export Relationships CVS #449169
    wemmons53
    Participant

    Could you explain how I could sponsor a modification?

    in reply to: Export Relationships CVS #448542
    wemmons53
    Participant

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

    Attachments:
    You must be logged in to view attached files.
    in reply to: Export Relationships CVS #448540
    wemmons53
    Participant

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

    Attachments:
    You must be logged in to view attached files.
    in reply to: How to print an entry #409791
    wemmons53
    Participant

    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.
    in reply to: How to print an entry #409769
    wemmons53
    Participant

    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?

    in reply to: How to print an entry #409612
    wemmons53
    Participant

    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.

    in reply to: How to print an entry #409611
    wemmons53
    Participant

    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

    in reply to: How to print an entry #409572
    wemmons53
    Participant

    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

    in reply to: Show Detail Link on Famil Relation Links #385127
    wemmons53
    Participant

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

Viewing 10 posts - 1 through 10 (of 29 total)