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