CB Moodle and full name sync

We have a Joomla installation with Community Builder configured to use 3-part fullname (firstname,middlename,lastname).
When this information goes to moodle db, name splt in two pieces, one piece goes to moodle's firstname, other - in moodle's lastname (there is no middlename field in moodle DB (?)). When user name is being shown in moodle these parts are joined together.

The problem is that splitting logic is wrong and at the end, after moodle joins its first and last names we got weird mixture.

- Name in joomla DB loks like: John Fitzgerald Kennedy
CB correctly splits it into:
firstname:John
middlename: Fitzgerald
lastname: Kennedy

- After sync to moodle profile fields looks like
firstname: John
lastname: Fitzgerald Kennedy

And full name in rendered as Fitzgerald Kennedy John

It is probably better to split 3-part names as:

firstname: John Fitzgerald
lastname: Kennedy

This post was supposed to go to R09 support, please move it

Hi.

As you say, there is no moodle middlename field.

Are you mapping first and lastname from CB to moodle? That should make you have moodle info wihou the middlename.

Antonio Durán wrote: As you say, there is no moodle middlename field.

That is true. As a workaround people put middlename in 'firstname' field, I even sow moodle patch extending the length of that field in DB to fit longer strings

Antonio Durán wrote: Hi.
Are you mapping first and lastname from CB to moodle? That should make you have moodle info wihou the middlename.

In some countries/cultures middlename is important and not ommitable.

I personally found a workaround, i have an extra CB field where " firstname middlename" string (with the help of CB Auto Actions plugin) automatically copied to, and then this field is mapped to the firstname field of Moodle.

Great to know hat you found a workaround.


As for splitting the name 2 + 1: in Spain, for example, it would make more sense to have it 1+2 (as we have 2 surnames), so it is a difficult problem to solve.

I see.
You might consider to make it configurable, which way to split full name into pieces.

Ok, I will move this to feature requests, in case it can be included.

Hi,

I see there is a column middlename in Moodle user table.I also have middlename in comprofiler table of CB.I wanted to map these two column but it does not seem possible because in Mapping I cannot see middlename in moodle fields dropdown.Is it possible to map these two fields?if yes,could you please help me how?


Thanks,

As I just learned, Moodle has middlename starting from version 2.6
But we still use older version with no middlename field. To deal with it we used the trick I described above:

1. Have extra CB field for "firstname+middlename" combined, lets call ut cb_firstmiddlename. This field is hidden for users and updated automatically every time one of firstname and middlename fields are updated (you need CB Auto Actions plugin to forse this update).

2. Map this combined field cb_firstmiddlename to moodle name field

Can you guide me where to find the PHP file where the split happens? I'd like to edit it, to match only the last word in the name as the lastname, and let the rest of it in the firstname. I will submit the code change here when I find it. Thanks for your help!