By MicheleF on
hallo to everybody.
after migrating from 4.4 to 4.5 I got stuck into profile customization problems. In details, I’d like to re-integrate into user profiles fields already inherited from 4.4 settings (especially avatars, now pictures).
Do someone can provide to me some instructions please?
Comments
Please help us on profile migration
I got the same problem. I assume the data of my previous profiles are there somewhere!
Is there any way to update the customisation of the profile module??
I had a similar problem with profiles..
Hi Gufo,
I had similar problems with profiles a few months ago when changing a test site from 4.4 to 4.5.
It's been a while, so I don't know if this is a hindrance or a help..but, I spent ages trying to work out how to port the user profiles across . If I remember correctly the main problem was because the table structure with 4.4 was different to 4.5 and profile data was stored in a different way.
Anyway..I found a workaround which worked a treat and in simplicity it was as follows:
a) export the complete users table from your 4.4 installation into excel. I'm not an sql/php expert so I used navicat which allows you to reorder columns when importing/exporting to an sql table which made it a breeze.
b) manipulate the old 4.4 user info. into columns for import into 4.5 (I used excel for this and did it by creating a dummy, complete user profile in 4.5 with all the extra data fields with a value...exporting that user table to excel and comparing the two worksheets.)
c) import the re-jigged XLS file into the new 4.5 SQL users table.
d) after importing the new data into 4.5 you need to update the SEQUENCES table (you need to tell drupal the number or UID of the last user in the user table for it to work properly).
Apologies if that sounds very complicated...it was a while ago and I'm not an expert in sql..so there is probably an easier way to do this..I just don't know how. Just thought I'd mention how I got around the problem. Worked for me with almost 2,000 users with photos/avatars.
Hope thats of use..
Dublin Drupaller..
Currently in Switzerland working as an Application Developer with UBS Investment Bank...using Drupal 7 and lots of swiss chocolate
I'll try
Dublin,
Thanks, I will try this. I still can't believe the profile module has changed so drastically and there is no update script for this.
I have tried creating forms with previous names and I noticed that the profile module tends to "import" that data.
Another of my biggest headaches is that I applied a specific form that I use say form_myform and it worked on the previous version when myform was in the array. Unfortunately, this new module seems to be less flexible.
as far as I can remember
Hi Gufo.
Hope it works for you.
It's a while back since I did it...but I remember in 4.4 the extended profile fields were stored in the DATA field in the user table.
In 4.5 they are stored in a seperate table.
As far as I can remember, that's what caused me the most grief. But after getting to grips with using excel and importing the databases in..it all worked.
Don't forget the sequences table..
Good luck! in the documentation it's noted that there is a significant jump in the way drupal is structured between 4.4 and 4.5.
If it's any consolation...it is well worth the effort. 4.5 is extremely well put together.
Dub
Currently in Switzerland working as an Application Developer with UBS Investment Bank...using Drupal 7 and lots of swiss chocolate
Problem on updates.inc
Hey Dublin,
After some painful days and nights, I found the solution.
I noticed that only some of my profiles fields were lost and some were kept when I re-created a new profile with the same name (i.e. profile_age).
The source of the problem is the updates.inc which for some reason it will delete your profiles.
My solution was to delete the fields in where any of my profiles were mentioned in the file (i.e. taking out realname if I used profile_realname):
// Migrate the old profile data to the new scheme:
$fields = array(
array("Name", "realname", "textfield", NULL, 0),
);
This way our profile data is kept and you do not need to do any -even more painful- manual data migration.
Regards,