[Closed] CB <==> Moodle field mappings

Joomdle provide an interface to map some Community Builder fields to Moodle fields.

In our CB database we have fields of type "MySQL", it is virtual fields with value being result of some MySQL query, such field are implemented by CB plugin, they do not have corresponding columns in comprofiler table.

Example: you have real "birthday" field and virtual "age" field wich is dynamicaly evaluated every time its being requested.

Unfortunatelly, these fields are not listed by Joomdle for mapping with Moodle. Are there any plans to support those "virtual" CB fields?

I jus learned those kind of fields existed, so we had no plans to support them.
I will move this thread to Feaure Request in case we may add it in a future release.

Some of those MySQL fields are dynamic and the values are changing each time you view that page and thus not, as you say, stored in the comprofiler table. This presents a problem of data integrity. Eg. Some of these fields are for display only purposes like displaying the persons age. You could "not" map this to moodle as the value would change everyday and you would require a continuously running cron job to keep that field up to date.

Thus from a practical point of view, you will need to consider how appropriate it is to store the display on "fields".

So how do "normal" fields stay in sync?
If I map "real" Joomla firstname field to Moodle firstname field, what triggers Moodle field update once Joomla field got updated?

When the fields are edited. But display only fields are never edited. I suppose you could trigger an event each time a page is visited but that is a lot of overhead ?

There is CB Auto Actions plugin which lets you perform different actions when different event happens, for example request some URL when some field was updated.
Looks like it is easier to use this plugin to update "real" CB fields which in turn mapped to Moodle fields.

But thanks for explanaton.