Data mapping custom fields

Hi Antonio, sorry, me again! I currently data map from a community builder custom field over to Moodle without problems. However, I do have lots of problems with community builder being glitchy, giving error messages to users logging in and the forgot password does not always work, resulting in a bad user experience. I only use community builder for the custom field so I am looking for alternatives so I can uninstall the plug in and use Joomla login instead.

The current custom field is pulling the group admin id from the Membership Pro subscription data. Membership Pro guys are quoting me for some custom code so that I can have the data I need in a custom field in Joomla user info. (see attachments).

If they can get the info into a custom field for me, can I then map the Joomla custom field to Moodle?

Hope that makes sense? Tell me if not I will try again. Thanks. Tracey

Hi Tracey. Don't be sorry, we are all learning all the time

Your explanation makes sense... although I don't get why you would want to map group admin id to moodle (is that the ID of the Joomla user?)

Also, before I can answer, I have another question: how is this custom field you are using CB? How is it populated now? Or is it a query field?

Hi, sorry struggling to get my reply to submit - I wondered it if was too long so this is a test message first

Yep, must be too long or maybe doesn't like something I've written. I will break my reply into smaller chunks!

Hi Antonio, the custom field I am using in Community Builder is the SQL query field that you got working for me several weeks back. It automatically populates the group admin id from Membership pro into a custom field, which then maps into Moodle. In Moodle, I have a plugin which uses the data to automatically create cohorts for me. The advantage of this is that the group admins can then view the progress of their group members on Moodle. The current data mapping and creating cohorts in Moodle works brilliantly - unfortunately, my experience with community builder is not so great so I need to find a way of doing the same thing without them!

I sell group plans to driving instructors using Membership Pro. The driving instructor is the group admin for the plan and adds their learner drivers as group members to the plan.

I've called the custom field driving instructor id. The SQL query means that the data in the custom field is the group admin's id for the group the users belong to. So if a driving instructor has 30 group members all 30 have the same driving instructor id which identifies who the group admin is and whose plan they belong to. It doesn't have to be the group admin id, it could be the group admin name or the group admin email - just something to identify which plan they belong to.

I would like to use Joomla's custom field (or Membership Pro also have a custom field option) instead of Community Builder. This would streamline my plugins, reduce conflicts and enable me to use the Joomla login/out and forgot password which always worked without a problem. I do not use any other elements of community builder, I only installed it to get this piece of data into Moodle.

Membership Pro have confirmed they can create the custom field for me.
Once I have the custom field set up and populated will I be able to map it? Happy to pay for custom coding and also for that to be shared if there isn't a way to do it currently.

Thanks. Tracey

Thanks for the info, I understand much better now.

I think what you propose could work...I have been thinking if there is any solution without additional coding, but could not come up with anything.
It needs to be a Joomla field, so you can map it to Moodle, as we don't have a mapping plugin for Membership Pro fields.

> Membership Pro have confirmed they can create the custom field for me.

Wait...what do you mean with custom field? I think what's needed is not a custom field, but a plugin to fill a normal text field.
I mean, are you sure they understood your request, and they are not just talking about something like this:
docs.joomla.org/SQL_form_field_type/en

ie: that you just want to show some values from a table in a select box so you can select them when editing a user.
The important thing here is that the info in the field needs to be filled automatically, and I don't think that it can be done with just a custom field by looking at the API.
in CB, this is done because when you get a field value through the API, it does all the needed modications, like executing the SQL query.

Hi, I have said to them that I need the data to populate automatically and for it not to be a drop-down field or editable by anyone but I will go back and double-check this point with them.

When I said custom field I meant it will be in the area as shown in the attachments. So when you click Users, Fields you can add a new field which then appears in a separate Fields tab when you click on a user to see their details. Is that ok?

Hi, I copied what you said about requirements for the field to membership pro and they have confirmed that is ok and are ready to go.

Can I just check that the field they are putting the data into which I took a screenshot of in the attachments is ok for you?

Once you have confirmed that field is ok Membership Pro will start work. Are you able to give me a quote for the additional coding required for mapping while Membership Pro and working on it, or will you need to wait until its complete before taking a look?

Thanks. Tracey

Hi Tracey.

> that is ok and are ready to go.

Great.

> Can I just check that the field they are putting the data into which I took a screenshot of in the attachments is ok for you?

Yes, you can map com_fields data using this plugin:
www.joomdle.com/download/category/27-plu...-user-fields-profile

> Are you able to give me a quote for the additional coding required

There is no additional coding required. Once they get the info in the field, Joomdle can map the field as any other one from com_fields.

Excellent, thanks very much for your detailed and fast responses
Tracey