SQL: Migrate Kunena Info into ES
By Fred on Thursday, 05 June 2014
Posted in General Issues
Replies 3
Likes 0
Views 595
Votes 0
So I will be launching my ES Section over the weekend and I'm trying to do my community a favor by transferring some of their Kunena information over to ES such as an Avatar. I don't think I see an easy way to do this, would it be possible to do it with a Script? I tested a script out but the base url setting for avatars are linked to their user folder on the site, I've tried putting the full path from the Kunena Avatar into ES but no luck :-\

UPDATE uxyn1_social_avatars AS sqr INNER JOIN xyn1_kunena_users as kun

ON kun.userid = sqr.uid

SET sqr.square = kun.avatar
Hello Fred,

I am really sorry but unfortunately right now we do not have a migrator for this I don't think it's possible to actually just run SQL queries to import them. You also need to relocate the physical files.
Mark
·
Friday, 06 June 2014 02:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Yea I figured as much once I saw the individual User Folders. Thats fine, it wont kill them to reupload them. I will just let them know in advance to Backup their Avatar
Fred
·
Friday, 06 June 2014 03:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating Fred
Mark
·
Friday, 06 June 2014 11:11
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post