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

XF 1.1 Import only converted 2/3 of my custom user profile fields

Discussion in 'Installation, Upgrade, and Import Support' started by Coop1979, May 31, 2012.

  1. Coop1979

    Coop1979 Well-Known Member

    As the title says, the vB 3.8 --> XF importer only converted 2 out of 3 of my custom user profile fields. I went live with my site before I realized that one of them was missing. Is there a way that I can import the 3rd field into XF?
  2. Sadik B

    Sadik B Well-Known Member

    Don't think that would be possible with the importer. You will have to create the missing custom profile field in XF and then write a query to select from the VB db and insert into the XF DB. A bit technical but easy if you are good with SQL.
  3. Coop1979

    Coop1979 Well-Known Member

    I'm not a genius when it comes to SQL, but I do know that this is the information needed to create the query:
    vB Table: pc_vbulletin.userfield
    Columns needed: userid, field7
    vB Table: pc_vbulletin.profilefield
    Columns needed: profilefieldid, data

    XF Table: pc_xenforo.xf_user_field
    VB field7 is equal to field_id 'package' in XF
    Will have to convert vb's data column to XF's field_choices somehow.
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I can probably do that for you, once I'm done with your other stuff.

Share This Page