CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • enter all household members at once.
Pages: [1]

Author Topic: enter all household members at once.  (Read 440 times)

civieric

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
  • CiviCRM version: 4.3.5
  • CMS version: WordPress
  • MySQL version: 5.5.32
  • PHP version: 5.4.17
enter all household members at once.
March 29, 2014, 11:00:27 am
I'm testing CiviCRM for a Women's shelter. I'm trying to figure how to streamline entry of a new family coming to the shelter. To enter a family with a mother, two children and a case-related male (father/partner/husband/ex/...) seems to take at least 30 different page opening or closings. This takes about 10 minutes to enter maybe 2-3 minutes worth of typing, depending on connection speed. Something like this:

1 Open Household (HH) create
2 Save HH create
3 Open Indiv create
4 Save Indiv create: Mother
5 Click Relations
6 Click new relations
7 Save Mother-HH rel
8 Open Indiv create child 1
9 Save child 1 create
10 Click Relations
11 Click new relation
12 Save child1-HH rel
13 Click new relation
14 Save child1-mother rel
15 Open indiv create child 2
16 Save child 2 create
17 Click relations
18 Click new relation
19 Save child2-HH relation
20 Click new relation
21 Save child 2-mother rel
22 open indiv create related male: father/husband/boyfriend/partner
23 save related male create
24 open relations
25 click new relation
26 save related male-mother rel
27 click new relation
28 save related male-child 1 rel (if related)
29 click new relation
30 save related male-child 2 relation (if related)

Has anyone created a page form that would let one enter all the info at once and do one save? (Once 'save' was clicked, the page would presumably have to do multiple queries to create the users in order so the relations-creations would have the right clients already existing.)

It would also be good if certain HH info (address, phone, ...) could be pre-loaded as the defaults in the creation of the various individuals, at least for the head of the HH (presumably the mother in these cases).

If not, what might be the best way to create such a form or something that is more efficient? I'm thinking maybe an import process where the info would be entered into Excel/LO Calc and then imported via a script. It looks like this would take multiple imports to get the relationships, so it's probably not the way to go for entering one family.

Or am I missing some way to do this that's already there?

Thanks.

Jeremy Proffitt

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 2
    • Mobius New Media
  • CiviCRM version: 4.4.x
  • CMS version: Joomla 2.5.x/3.x / D7
  • MySQL version: 5.1.x
  • PHP version: 5.3.10+, 5.4.x
Re: enter all household members at once.
March 29, 2014, 11:25:24 am
There's not a single step way to do this with the import function or in the standard UI, but a custom form+script using the API could easily do this. The specific relationship names (partner/boyfriend/etc) can be configured in the UI up front.

The process would look more like this:

- Create household
- Create all contacts
- Relate applicable contacts to the HH (if there were biological parents needing to be recorded that were not part of the household?)
- Relate each parent to applicable child

I have created code that will do something like this, but it's very specific to the application and I'm not free to share it. I would certainly be happy to answer specific questions about doing something like this if you decided to try something on your own.
Jeremy Proffitt
Mobius New Media
IRC: JP_EzoD

civieric

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
  • CiviCRM version: 4.3.5
  • CMS version: WordPress
  • MySQL version: 5.5.32
  • PHP version: 5.4.17
Re: enter all household members at once.
March 29, 2014, 11:55:33 am
Thanks for the suggestions and offer of help. I'll plunge into the api etc and see what I can figure out.  I figured there had to be some kind of step-wise process involved.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: enter all household members at once.
March 30, 2014, 01:17:52 pm
Note for anyone reading this thread with Drupal - most of the above can be done using Webform CiviCRM module
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • enter all household members at once.

This forum was archived on 2017-11-26.