1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Installation, Upgrade, and Import Support' started by Terry Love, Jun 21, 2014.

  1. Terry Love

    Terry Love Member

    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?
     
    Last edited: Jun 22, 2014
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Did you enter the correct path to the avatar directory when you did the import?
     
  3. Terry Love

    Terry Love Member

    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?
     
  4. BamaStangGuy

    BamaStangGuy Well-Known Member

    On the page where you fill out database information.
     
  5. Terry Love

    Terry Love Member

    Last edited: Jun 22, 2014
  6. Terry Love

    Terry Love Member

    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.
     
  7. 0ptima

    0ptima Well-Known Member


    Its on the next page
    upload_2014-6-21_21-13-24.png
     
    AndyB likes this.
  8. Terry Love

    Terry Love Member

    import3.png
    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?
     
  9. 0ptima

    0ptima Well-Known Member

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

    AndyB Well-Known Member

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

    Terry Love Member

    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?
     
  12. AndyB

    AndyB Well-Known Member

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

    Mike XenForo Developer Staff Member

    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 and 0ptima like this.
  14. Terry Love

    Terry Love Member

    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.
     
  15. Terry Love

    Terry Love Member

    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.
     
  16. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

Share This Page