By n00bster on Wednesday, 02 April 2014
Posted in General Issues
Replies 19
Likes 0
Views 1K
Votes 0
i am testing the v1.2.5 version on my dev-site. i need some assistance on profile field migration.

first problem - address fields
my jomsocial user profiles have this following fields:
FIELD_ADDRESS
FIELD_STATE
FIELD_CITY
FIELD_COUNTRY

now in easysocial there is an multifield group called "Adresse" which have included two address lines, city, state, zip code and a country field. how can i migrate my jomsocial fields in this fields?
FIELD_ADDRESS > Address line 1
FIELD_STATE > State
FIELD_CITY > City
FIELD_COUNTRY > Country

second problem - name fields
my problem with profile fields belongs to the default joomla name migration. i use full names in my community. i set up easysocial to work with "First Name" & "Last Name". Now all Names are stored in the First Name field. Is there any way that i could split the names to First & Last Names?
Hi Noobster,

Thanks for the heads up.

About the 5 zeros string, I've fixed internally The fix will be added into next release of EasySocial
Thanks and have a nice day
Sam
·
Thursday, 17 April 2014 13:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

When you migrate from JomSocial over to EasySocial, we can't really know the real "field type" since some users might have a different field codes for their fields. We can however, import the country field accordingly but the rest of the fields would be a normal "textbox" in EasySocial.

If I recall correctly (This was a feature that was added very long ago in JomSocial) where if you use GIVENNAME or FAMILYNAME field code accordingly, we'll be able to fetch it accordingly.

GIVENNAME (JomSocial) ---> First Name (EasySocial)
FAMILYNAME (JomSocial) --> Last Name (EasySocial)

If there are standard or fixed field codes, migration would be much easier but because JomSocial custom fields are pretty generic in the sense where they are all basically "textboxes", it's almost close to impossible to find the correct fields
·
Wednesday, 02 April 2014 23:32
·
0 Likes
·
0 Votes
·
0 Comments
·
ok.

easysocial have this address field. how can i migrate to them?
http://screencast.com/t/au1EsXeJHXmD
in jomsocial i have a city and state field, and i would like to migrate this two fields to your address field block.
·
Thursday, 03 April 2014 02:46
·
0 Likes
·
0 Votes
·
0 Comments
·
You can't currently because there's no way to determine which "textbox" in JomSocial is used as the address. The only way is of course through the "field key" but everyone field key's could be different.
·
Thursday, 03 April 2014 11:18
·
0 Likes
·
0 Votes
·
0 Comments
·
i understand that all jomsocial installations have different fields and types, but it would be a lot better when your migration script could also extend with some more fields. in this case "city" and "state". it can not so difficult to make this happen.
i made a little vid what i mean:
http://www.screencast.com/t/DOVBrPpc

the migration script is nice, but there have to be some more fields which i can choose where i want to have the jomsocial profile data in easysocial. at this time it is cool that i could import all images, messages an so on, but i could only import half of the user profile field information in the right fields from easysocial
as long in the jomsocial profile a normal textbox is used for custom fields it should very easy to point this where i want to easysocial profile fieldboxes, or not?
·
Thursday, 03 April 2014 17:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

Ah, I see. I get what you mean now. I think I get your point and I'll discuss this with the team and see if we can also be able to migrate multiple fields into 1 single field.
·
Thursday, 03 April 2014 18:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

Okay, we'll try to see if there's a way to adjust this because right now we're revamping the way custom fields store it's values.
·
Friday, 04 April 2014 15:28
·
0 Likes
·
0 Votes
·
0 Comments
·
thank you for the info, i hope there is a way.
·
Friday, 04 April 2014 15:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks n00bster, we'll keep you in the loop
·
Friday, 04 April 2014 16:20
·
0 Likes
·
0 Votes
·
0 Comments
·
i see you made some changes on the migrator for profile fields. i tested this on my test site (v1.2.7) where i have already migrated the jomsocial users to easysocial.
but i can not see any imported field information in easysocials address fields (state, city, country). i mean no "state, city or country" was after a re-migrate taken from jomsocial profiles.
are the fields only merged on the first run, do i have to set up a new site to test this? or can i test this on an existing migrated jomsocial installation from easydiscuss?
·
Wednesday, 09 April 2014 02:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

I am sorry for the late reply.

Yes, you are right. The changes only applied to new migration. Meaning to say, if you already migrated, then it will not re-migrate again. Thus you are still seeing the address in different fields. What you can do is to do a clean install of EasySocial and run the migration again on your test site

Hope this help and have a nice day
Sam
·
Wednesday, 09 April 2014 12:48
·
0 Likes
·
0 Votes
·
0 Comments
·
you mean with the clean installation that i have to uninstall ES and drop the database tables also, am i right?
·
Wednesday, 09 April 2014 14:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

Yup, thats correct. Once you done that, then you can migrate JomSocial with the address, city, state, country fields combined into single EasySocial's address field
Hope this help and have a nice day
Sam
·
Wednesday, 09 April 2014 14:15
·
0 Likes
·
0 Votes
·
0 Comments
·
i tested the extended field migrator. it does for the fields suchs as "city", "state" and "address" a good job. but i have also a "country" field in my jomsocial installation and i believe many more user have this too.
i see that you have also in the migrator screen, at your dropdown fields a "country" field, but this have nothing to do with the "country field from your grouped "address" block - am i right?
it would be better when the imported country field from jomsocial are hooked in in the group field instead of the standalone country field.
·
Wednesday, 09 April 2014 23:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

Em the country field should group into 'address' as well. Can you tell me what is your field code for your 'country' field in your JomSocial? Currently EasySocial will group these field with field code of 'field_address', 'field_state', 'field_city', 'field_country' into ES address field. So in your JS migrator the field mapping screen, you should see something similar as here http://screencast.com/t/xG012NyDC

Are you seeing your JS country mapped into ES address field? if not, then you might want to check what is the field code for your JS country field then.
If your JS country field the field code already is 'field_country' ( ignore the upper/lower case ), then can you pass me your Joomla test site the admin access, your ftp account to your Joomla test site and also your phpmyadmin access to your Joomla test site. I will then look into your issue again.

Please advise.
Sam
·
Thursday, 10 April 2014 11:45
·
0 Likes
·
0 Votes
·
0 Comments
·
hi,
my field code in jomsocial for country is "FIELD_COUNTRY".
in the ES migrator screen it is mapped to a dropdown-field. thats wierd, i attache you the login data.
·
Friday, 11 April 2014 15:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

I am sorry for the delay of this reply.

Today i checked on your JomSocial and apparently your country field is a 'select' drop down type thus the mapping to address field failed. I've added a fix on your dev site and I also clear the data but when i attempt to re-run the migration, i hit connection was reset issue. Now i no longer able to access to your dev site. Please advise.

By the way, below are the two files I've modified:

JOOMLA/administrator/components/com_easysocial/includes/migrators/helpers/jomsocial.php
JOOMLA/administrator/components/com_easysocial/themes/default/migrators/jomsocial.php

Once your site is up again, can you try to re-run the JS migrator and see if your JS country field group into EasySocial address field?
Please advise.
Sam
·
Friday, 11 April 2014 18:07
·
0 Likes
·
0 Votes
·
0 Comments
·
hi Sam,
sorry for my late reply.
i have re-run the JS migrator. it looks good.
one thing is a bit curious, after the migration the users with an migrated country field have filled in five zeros in the ZIP Code field. the zip code field should not automatically get field with this zeros.
·
Wednesday, 16 April 2014 16:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

after the migration the users with an migrated country field have filled in five zeros in the ZIP Code field. the zip code field should not automatically get field with this zeros.


Ah fixed internally The fix will be added into next release of EasySocial
Thanks and have a nice day
Sam
·
Thursday, 17 April 2014 18:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post