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

[Coop1979]

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]

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]

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.

 

[Jake Bunce]

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