• 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

Coop1979

Well-known member
#1
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?
 

Sadik B

Well-known member
#2
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.
 

Coop1979

Well-known member
#3
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.