CiviCRM Community Forums (archive)

I am in the middle of a cumbersome job of entering membership records.
We want to keep detailed records(including custom data) of members along with their family relationships like Parent, Spouse, Sibling.
Our members fill the paper form and submit which we enter and also update relationships manually.
This is a huge manual work so I am looking for a better alternative
-----------
our Use-case:
We want our members to  fill in their details online for themselves.
To do this,
1) We already have our members Name, email and phone numbers in a spreadsheet (csv)
2) We can create Drupal users and send them login credentials (using Feeds module)
3)  When they login they can fill in the webform (integrated with civicrm)

Problem:
1) How does the current user add  relationships like spouse, child, parent ? We want every relationship to be approved by the contact2.
I have read some of the posts online, which suggest that logged in users can search an existing contact and add relationship using webform.
I have tested that it works.
But, we want the contact2 to approve it before the relationships show up in Civicrm Relationships Tab

This is similar to "Approval" requests seen on social networking sites.
The reason we want to do this is to avoid corrupting the relationships part of our civicrm data. There could be errors or some relationships added on purpose. Imagine, a man adding another man's wife as his wife mischievously or by mistake.

Pete,

I wrote a very similar response, then deleted it when I realized I was missing large chunks of the equation!

* I believe there's still no API for sending an e-mail - so while you could send an e-mail via a PHP function, you couldn't use checksums etc. - maybe if someone employed some BAO ugliness that would work.
* I couldn't think of a good way to do the UI for confirming the relationship - I guess I was too caught up in the idea that you should be able to confirm the relationship by clicking a single URL  in the e-mail.

I guess if you created a file similar to extern.php, you COULD have a single-click confirmation - you'd use a stand-alone PHP file, and when you clicked "Approve" or "Deny" ("Divorce"?) it would pass arguments which the file could use to trigger the appropriate action.

Regardless - it seems like a LOT of work!  Though last week I wrote a similar module.  My advantage was that the relationship was confirmed on the back-end, making this a LOT simpler.

Is it an idea to set the relationship to 'inactive'? E.g. you create the relationship in the webform but it is not active. The 2nd user should on approval activate the relationships. I think you can achieve this all with webforms.
e.g.
1 One webform for the user
2. One webform for 2nd user which approves all relationships (or this latter one could be done manually in civicrm)

jaapjansma, your suggestion is interesting.

But, how to populate Webform2 which ContactB would use to activate the inactive relationships.
I mean, the webform2 must be autofilled with all inactive relationships for for ContactB so that he can chose to activate it.