XF 1.3 How to import avatars in the file system from Vbulletin 4.2 to Xenforo 1.3.3

[Terry Love]

Moving from Vbulletin to Xenforo, and having problems with the import of the avatars.
It did NOT import avatars from the VB4 filesystem into the xenforo filesystem.
It DID import custom avatars from the old VB4 SQL database into the xenforo filesystem folders.

So custom avatars were imported successfully, but default avatars that I would allow people to choose from (if they did not want to upload their own) were not imported correctly. How do I finish importing the avatars?

I list my users with their location under the avatar, and use a flag for state or province. So many questions being asked are dependent on where the user is doing the work.

How do I keep this feature in Xenforo?

 

[Paul B]

Did you enter the correct path to the avatar directory when you did the import?

 

[Terry Love]

Did you enter the correct path to the avatar directory when you did the import?

I'm not sure I saw this step. Where does it ask for the path to the avatar directory? My son and I have been trying to find where it would be located as it was mentioned in another post, but we have not been able to find it so far. At which stage and window location?

 

[Brent W]

I'm not sure I saw this step. Where does it ask for the path to the avatar directory? At which stage and window location?

On the page where you fill out database information.

 

[Terry Love]

The page on the import tool?

@BamaStangGuy

 

[Terry Love]

I'm still not finding it. I've been searching the forums for where this would be located as well. Either it isn't documented in the forums, or I'm not looking hard enough. For future searches it would be nice to have the solution posted in this thread.

 

[0ptima]

The page on the import tool? @BamaStangGuy

Its on the next page

 

[Terry Love]

After clicking "validate configuration"... It does not show a place for attachment paths.
I'm wondering if maybe it has to do with how xenforo detects if files are being stored in the file system. Maybe the avatar directory from the old VB4 needs to be dropped into the new Xenforo folder?

 

[0ptima]

Where are your attachments/avatars store in VB? Database or file system?

 

[AndyB]

The other option is to put the avatars back into the database in vB4 and then do the import.

 

[Terry Love]

Custom avatars are in SQL, but most of the avatars are in the file system. I can import the database avatars and attachments, but the avatars in the images/avatars/ links don't port over. Instead I get the standard Xenforo images. And there are thousands of them.

How would I put the file based avatars in 4.2 back into the database?

 

[AndyB]

How would I put the file based avatars in 4.2 back into the database?

It's been a couple years, but if memory serves there's an option in the Admin Control Panel to do that.

 

[Mike]

Wait, back up here. We only import custom avatars (and you say that's working). Any "avatar gallery" avatars will not be imported. You would need custom development to support that.

 

[Terry Love]

Writing a solution on how to do this for future Googlers. Kind of cool that this post came up when I was searching for how avatars are stored in the VB4 system.

Use the following query on your VB4 database to get a list of user IDs matched with their respective file paths and avatars.

SELECT`user`.`avatarid`,`avatar`.`avatarpath`,GROUP_CONCAT(`userid`)
FROM(`user` LEFTJOIN `avatar` ON `user`.avatarid =`avatar`.avatarid)
WHERE `user`.`avatarid` != 0 GROUP BY `user`.`avatarid`;

Rest of solution still pending.

 

[Terry Love]

There really isn't a clean cut solution for this. You'll probably need to hire a developer who can write a program to query the old DB and manipulate the data properly. We're just going to write an add-on to grab new location based avatars when a user's avatar is not already custom defined.

 

[Jake Bunce]

Try this addon:

http://xenforo.com/community/resources/avatar-gallery.276/

But then you still need to import the records from vB. This can probably be accomplished with some cross-table inserts after you manually copy over the image files. I can probably do this for you if you need.