Google map visualization on Community Builder data?

[chris.paschen]

Has anyone created a Google Map visualization on Community Builder data?

I know I need to add the proper google map element; however, I don't want to make changes directly to the CB core comprofiler table.

I've thought about adding a linked table that just contains the location data; however, the question then becomes how to keep that data updated when a user updates their CB profile.
I know I could create auto-actions within CB, but if there is some other way I'd prefer to avoid auto-action for this integration.
Also, any ideas how to 'automatically' populate the location data for a large CB dataset?

I'm just hoping someone else has already done this and can share their experience/tips.

 

[cheesegrits]

Nope, not heard of anyone doing that.

And offhand I can't recall how CB's data is structured, and I don't currently have it installed anywhere. I vaguely recall how their custom fields data is structured, which really isn't copacetic with how Fabrik works.

When you talk about keep the data updated, do you mean geocoding a Fabrik map element from address data in their CB profile?

-- hugh

 

[chris.paschen]

Thanks.

All the CB data is just in table fields (in com_comprofiler). So I COULD just add it to that table and then access it from Fabrik, but not sure how that would work.

And yes, the address data is in CB and need to have the geocoding in a fabrik element.

I'll do some work on this and post back here when I come up with a workable solution.
(If anyone else has any thoughts/ideas please share and I'll pursue them).

 

[cheesegrits]

Iirc, the way you are supposed to add additional profile fields in CB is with their custom field handling, which stores them in a separate table, with some kind of mapping table for figuring out what the field types are. Not a mechanism that plays well with Fabrik.

But yes, assuming the address data is in the main CB data table, and CB doesn't have a conniption fit if you add additional fields to their table, you could add a simple VARCHAR column to it for 'map', and introduce the table to Fabrik as a list (just make sure you set "Alter field types" to No so we don't mess with the structure), and set the 'map' element to a googlemap.

Then you could add a 'geocode' Scheduled task in Fabrik for that list, to do the geocoding from the address data to the map field, and you could put a map viz on that list.

-- hugh