By Frank ter Braak on Friday, 19 September 2014
Posted in General Issues
Replies 3
Likes 0
Views 897
Votes 0
At this moment I ask new registering users for First / Middle / Last name

I think I have older users (from my Community Builder time!?) that once have entered only one (or two?) name field.

Now I seem to have users in the backend that have empty First / Middle / Last name fields but DO have there name shown in the Userslist in the backend and also have there names in the Acymailing lists and are listed by there name in the frontend users list.

Could I somehow cleanup or correct this? I would like to have a consistent database.

Does anyone know how to do this and where are these single name fields stored? I can't access them through Easysocial.

I like to use the right nametags in Acymailing and this component seem to be smart enough get the first name in the mailing.
Hi,

Technically, there are 2 copies of a user's name stored. 1 in Joomla's core table (#__users), and EasySocial stores it as well.

What the field does is, it stores the "segment" data as it is in EasySocial's database in order to retain the structure of the name (first, middle and last), but Joomla's core table only requires 1 single name, hence the field will group the name together as 1 single name and store it in Joomla's core table.

If the "segmented data" is not found in EasySocial's database, the field will always fallback and uses data from Joomla's core table, which results in 1 single name used as "First Name".

Since you've mentioned that those are old users prior to EasySocial, hence EasySocial does not have the necessary segmented data of their names.

Unfortunately, there is no easy way around this as it is hard to determine which part of the name falls in to middle/last name.

In terms of searching, if you are searching for particularly "last name", then this will be affected, but if you are searching in general, then it won't get affected.
·
Friday, 19 September 2014 17:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

If users registered through EasySocial, then the names are stored as pieces internally within EasySocial's database, but the fullname is constructed and stored in Joomla's users table as well @ #__users.
·
Friday, 19 September 2014 10:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you for fixing this as a super user.

For my info:
Did you complete the record with the empty Easysocial firstname fields with the fullname data from the Joomla or @#_users table?

To get the fullname data from the firstname field split to the according middlename and lastname fields is a manual job or a complicated scripting task?
Or do you think it is not needed for proper functioning. (Like in using email name tags, seaching easysocial users from the front end, registering events etc!?)
·
Friday, 19 September 2014 17:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post