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 »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Mapping Members based on Membership
Pages: [1]

Author Topic: Mapping Members based on Membership  (Read 890 times)

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Mapping Members based on Membership
July 19, 2012, 08:19:21 am
Since profiles don't allow for searchable directories based on membership how would one suggest I go about building a map of all the members of a particular membership based on the fact that there multiple membership types within the membership?

I have started to look into OpenLayers but was wondering if anyone had experience using the geocoding (I assume in Google Maps form) information within the CiviCRM db and openlayers.

My Goal:  To have a mapping "view" of current and new members that can be pinpoints on the map and clickable to see other info.  Any suggestions would be great.

Thanks!
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mapping Members based on Membership
July 19, 2012, 09:41:39 am

For more complex searcable directories, i would recommend checking the views integration and see how much further we can get with that

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

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: Mapping Members based on Membership
July 19, 2012, 12:33:27 pm
in case the tiny write up i did of using open layers and civicrm is of any use to you (or others reading this)
http://forum.civicrm.org/index.php/topic,18572.msg91263.html#msg91263
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

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Mapping Members based on Membership
July 26, 2012, 06:50:49 am
Looks like the OpenLayers method is working. Now the issue seems to be that the output from the data layer view is duplicating and all sort of oddities. Not sure where it is coming from.  Any ideas? I am using membership fields in that data layer view and getting duplicates that are slightly different in lat/long values for each. FYI, you can see this output in the preview area of the data layer view for debug purposes, which is very helpful.  I checked the records and they only list one entry for those values so would this be a views issue with CiviCRM values?
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

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: Mapping Members based on Membership
July 26, 2012, 01:10:19 pm
only suggestion i have is have you got a page using a table to show the same data inc Lat Lon so you can narrow the issue down? Have you set your address fields to Primary Only as that would let duplicates in.
May help to strip fields back out till you get down to no duplicates then put them back in till problem appears.
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

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Mapping Members based on Membership
July 26, 2012, 02:45:24 pm
Okay I figured it out and got things moving again, two questions:

One, how do you limit the references to the "primary" member only instead of all members

Two, how do you reference the Website URL in the Rewrite inside Views, for the life of me I cannot find a Token or anything of the sort that rewrites the same exact field value as a link.

Thanks!
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

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: Mapping Members based on Membership
July 26, 2012, 02:51:43 pm
Could be that neither of the above have had Views Handlers constructed yet - would be great if you could progress that. Civi - Views is definitely a community effort
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

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Mapping Members based on Membership
July 27, 2012, 07:13:25 am
If I could code a Views Handler I would sure like to help. I am terrible at coding and trying to understand even the "easy" methods of writing handlers for custom fields is beyond me.

What I did discover in the course of research is the following:

Views 3 and CiviCRM play pretty well with each other except for adding custom fields into the fields section of a particular view but custom data seems to be perfectly okay in the filter or sort sections.

Seems like there is a pretty good plan in place as explained here: http://wiki.civicrm.org/confluence/display/CRMDOC40/Drupal+Views%27+Future

Looks like it is pretty close to working except the custom data which appears that there is a plan to write code that makes the handler based on data type so that it would work with any custom field and create a generic handler for custom fields so individual handlers for each custom field aren't necessary???  Is that correct in my understanding of the current landscape?

If so there is no way I could help with this except to offer high level strategy.  I am happy to try and help any where I can but I am more of an implementer designer and such where code changes are simple like adding database connectors in settings.php  ;D

I also saw the Data module which seems like it could offer a solution to creating generic handlers with custom data but I'm pretty sure you need to know the relationships to be effective with it.  Perhaps we can leverage that module to complete the task of Views integration easier? Should I pose this question to someone that oversees views for CiviCRM currently?

Please point me in the right drection if I can be of any assistance.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mapping Members based on Membership
July 27, 2012, 04:37:28 pm

The civi + views integration is looking for one or more folks to help oversee and push the current views integration to even greater heights.

If there is funding, there are a couple of integrators that can put in the needed hours (fuzion, web access, gingko street et al)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Mapping Members based on Membership

This forum was archived on 2017-11-26.