Resource icon

vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0

No permission to buy ($150.00)
Overview Updates (9) Reviews (3) History Discussion
Ridemonkey said:
I tried that... it seems to get rid of the association of the like to a post itself (i.e. there are no posts that show they've been liked) but it doesn't remove likes from the users (e.g. my user has 920 likes post-migration).
Click to expand...

That is a cached value. The user export/import brings over that total count.

If there are no likes after your import then it's just as easy to run this script to rebuild those user values:

http://xenforo.com/community/thread...t-profile-post-like-caches.42384/#post-457352
 
Hi all - I have special characters like Δ in my vB 3.8 that are importing to "Δ" - Is there a way for them to be converted or displayed properly?
 
Ridemonkey said:
If the asking price is "absurd" then I suspect the forum downtime to import using the web importer is not that big a deal and you're better off going that route.
Click to expand...
I have 4.5m posts 650k threads and 200k members. How long would that take the web importer?
 
I'm looking to run this with a DB running on port 3307, what issues am I likely to expect? Is there built in config for setting the DB port?

Also, am I correct in thinking that:

I need to manually create my usergroups from VB to XF before import?
That thread prefixes are not exported/imported?
I need to manually create VB Paid subscriptions as XF User Upgrades before import?

Thanks
 
Last edited:
SimonV said:
I'm looking to run this with a DB running on port 3307, what issues am I likely to expect? Is there built in config for setting the DB port?

Also, am I correct in thinking that:

I need to manually create my usergroups from VB to XF before import?
That thread prefixes are not exported/imported?
I need to manually create VB Paid subscriptions as XF User Upgrades before import?

Thanks
Click to expand...

It should work on another port fine.

Yes, youll need to make and map the usergroups..

Prefixes should be imported as part of the threads section

Yes, you need to make the paid subs.
 
That is a real show stopper as the forum uses thread prefixes extensively, do you have any advice on how to move forward with importing the thread fixes?
 
SimonV said:
That is a real show stopper as the forum uses thread prefixes extensively, do you have any advice on how to move forward with importing the thread fixes?
Click to expand...

Once you create the thread prefixes in XenForo, the prefix itself for each thread is just controlled by a single field in the xf_thread table. It would be fairly simple to populate if you wanted to learn a few minutes of SQL. It would look pretty simple... if your prefix ID numbers were all the same between vBulletin and XF, which they could be if you create them all in exactly the same order (or if you go in and manually change the prefix IDs afterwards), you would have something like this:

Code: 
update xf_database.xf_thread, vb_database.thread
set xf_database.xf_thread.prefix_id = vb_database.thread.prefix_id
where xf_database.xf_thread.thread_id = vb_database.thread.threadid

Where "xf_database" and "vb_database" were the actual names of your databases. Please don't take me for a SQL expert, I know barely enough to be a danger to myself and others, I'm just getting you pointed in the right direction. :)

Or I'm sure you could pay Slavik to do it - he helped me out with importing thread tags into a new plugin.
 
Thanks for the pointers.

Ive gone about it in another way as the thread prefixid's in VB are text values, I created the prefix's in XF and then created a new field in the VB thread table, then SET that new field with a CASE query matching the VB text values from prefixid to the numeric values of XF for the new field. Then just altered the Export.php file to pickup the new field with the numeric values rather than setting them all to 0 as it does now. If that makes sense?

Ive not tested the import yet as ran out of time today but looking at the xf_thread.txt file everything seems to be fine.
 
So I'm running some tests now with the export/import and I have a couple of questions / issues

For avatars export I get the following output, its seems to be all avatars in the following folders, no errors for any other folders and there seems to be avatar images in those folders: data/avatars/s/0/, data/avatars/m/0/ anddata/avatars/l/0/ (only folders ending 0)

performing avatar diff...
6,065 users with new avatars
<pre>
data/avatars/s/0/1.jpg => No move
data/avatars/s/0/100.jpg => No move
data/avatars/s/0/102.jpg => No move
data/avatars/s/0/108.jpg => No move
data/avatars/s/0/11.jpg => No move
data/avatars/s/0/111.jpg => No move
data/avatars/s/0/114.jpg => No move
data/avatars/s/0/119.jpg => No move
........
.......
.......
....... (list snipped)
Click to expand...

On the Import I had some errors at xf_conversation_message:

xf_conversation_master0
(401.43s)...
xf_conversation_message1261969
Warning 1261 Row 1 doesn't contain data for all columns
Warning 1261 Row 2 doesn't contain data for all columns
Warning 1261 Row 3 doesn't contain data for all columns
Warning 1261 Row 4 doesn't contain data for all columns
Warning 1261 Row 5 doesn't contain data for all columns
Warning 1261 Row 6 doesn't contain data for all columns
Warning 1261 Row 7 doesn't contain data for all columns
Warning 1261 Row 8 doesn't contain data for all columns
Warning 1261 Row 9 doesn't contain data for all columns
Warning 1261 Row 10 doesn't contain data for all columns
Warning 1261 Row 11 doesn't contain data for all columns
Warning 1261 Row 12 doesn't contain data for all columns
Warning 1261 Row 13 doesn't contain data for all columns
Warning 1261 Row 14 doesn't contain data for all columns
Warning 1261 Row 15 doesn't contain data for all columns
Warning 1261 Row 16 doesn't contain data for all columns
Warning 1261 Row 17 doesn't contain data for all columns
Warning 1261 Row 18 doesn't contain data for all columns
Warning 1261 Row 19 doesn't contain data for all columns
Warning 1261 Row 20 doesn't contain data for all columns
Warning 1261 Row 21 doesn't contain data for all columns
Warning 1261 Row 22 doesn't contain data for all columns
Warning 1261 Row 23 doesn't contain data for all columns
Warning 1261 Row 24 doesn't contain data for all columns
Warning 1261 Row 25 doesn't contain data for all columns
Warning 1261 Row 26 doesn't contain data for all columns
Warning 1261 Row 27 doesn't contain data for all columns
Warning 1261 Row 28 doesn't contain data for all columns
Warning 1261 Row 29 doesn't contain data for all columns
Warning 1261 Row 30 doesn't contain data for all columns
Warning 1261 Row 31 doesn't contain data for all columns
Warning 1261 Row 32 doesn't contain data for all columns
Warning 1261 Row 33 doesn't contain data for all columns
Warning 1261 Row 34 doesn't contain data for all columns
Warning 1261 Row 35 doesn't contain data for all columns
Warning 1261 Row 36 doesn't contain data for all columns
Warning 1261 Row 37 doesn't contain data for all columns
Warning 1261 Row 38 doesn't contain data for all columns
Warning 1261 Row 39 doesn't contain data for all columns
Warning 1261 Row 40 doesn't contain data for all columns
Warning 1261 Row 41 doesn't contain data for all columns
Warning 1261 Row 42 doesn't contain data for all columns
Warning 1261 Row 43 doesn't contain data for all columns
Warning 1261 Row 44 doesn't contain data for all columns
Warning 1261 Row 45 doesn't contain data for all columns
Warning 1261 Row 46 doesn't contain data for all columns
Warning 1261 Row 47 doesn't contain data for all columns
Warning 1261 Row 48 doesn't contain data for all columns
Warning 1261 Row 49 doesn't contain data for all columns
Warning 1261 Row 50 doesn't contain data for all columns
Warning 1261 Row 51 doesn't contain data for all columns
Warning 1261 Row 52 doesn't contain data for all columns
Warning 1261 Row 53 doesn't contain data for all columns
Warning 1261 Row 54 doesn't contain data for all columns
Warning 1261 Row 55 doesn't contain data for all columns
Warning 1261 Row 56 doesn't contain data for all columns
Warning 1261 Row 57 doesn't contain data for all columns
Warning 1261 Row 58 doesn't contain data for all columns
Warning 1261 Row 59 doesn't contain data for all columns
Warning 1261 Row 60 doesn't contain data for all columns
Warning 1261 Row 61 doesn't contain data for all columns
Warning 1261 Row 62 doesn't contain data for all columns
Warning 1261 Row 63 doesn't contain data for all columns
Warning 1261 Row 64 doesn't contain data for all columns
(669.01s)...
Click to expand...

and xf_conversation_recipient

xf_conversation_recipient2109
Warning 1062 Duplicate entry '12624-1836' for key 'PRIMARY'
Warning 1062 Duplicate entry '19648-1387' for key 'PRIMARY'
Warning 1062 Duplicate entry '20707-2260' for key 'PRIMARY'
Warning 1062 Duplicate entry '32645-2021' for key 'PRIMARY'
Warning 1062 Duplicate entry '33230-2684' for key 'PRIMARY'
Warning 1062 Duplicate entry '51893-3031' for key 'PRIMARY'
Warning 1062 Duplicate entry '52571-1291' for key 'PRIMARY'
Warning 1062 Duplicate entry '56767-3194' for key 'PRIMARY'
Warning 1062 Duplicate entry '58275-355' for key 'PRIMARY'
Warning 1062 Duplicate entry '81723-43' for key 'PRIMARY'
Warning 1062 Duplicate entry '88404-3497' for key 'PRIMARY'
Warning 1062 Duplicate entry '101924-3883' for key 'PRIMARY'
Warning 1062 Duplicate entry '105198-3903' for key 'PRIMARY'
Warning 1062 Duplicate entry '106469-3750' for key 'PRIMARY'
Warning 1062 Duplicate entry '116424-1410' for key 'PRIMARY'
Warning 1062 Duplicate entry '122155-4209' for key 'PRIMARY'
Warning 1062 Duplicate entry '124848-1623' for key 'PRIMARY'
Warning 1062 Duplicate entry '132032-2687' for key 'PRIMARY'
Warning 1062 Duplicate entry '134363-2827' for key 'PRIMARY'
Warning 1062 Duplicate entry '135684-2001' for key 'PRIMARY'
Warning 1062 Duplicate entry '139108-3886' for key 'PRIMARY'
Warning 1062 Duplicate entry '143831-4566' for key 'PRIMARY'
Warning 1062 Duplicate entry '172266-4258' for key 'PRIMARY'
Warning 1062 Duplicate entry '174726-783' for key 'PRIMARY'
Warning 1062 Duplicate entry '175373-4381' for key 'PRIMARY'
Warning 1062 Duplicate entry '176291-2965' for key 'PRIMARY'
Warning 1062 Duplicate entry '176504-4258' for key 'PRIMARY'
Warning 1062 Duplicate entry '193643-3027' for key 'PRIMARY'
Warning 1062 Duplicate entry '200567-5161' for key 'PRIMARY'
Warning 1062 Duplicate entry '209822-2965' for key 'PRIMARY'
Warning 1062 Duplicate entry '236103-123' for key 'PRIMARY'
Warning 1062 Duplicate entry '246226-5786' for key 'PRIMARY'
Warning 1062 Duplicate entry '246441-5786' for key 'PRIMARY'
Warning 1062 Duplicate entry '246529-5786' for key 'PRIMARY'
Warning 1062 Duplicate entry '249866-5407' for key 'PRIMARY'
Warning 1062 Duplicate entry '251054-1132' for key 'PRIMARY'
Warning 1062 Duplicate entry '253861-1250' for key 'PRIMARY'
Warning 1062 Duplicate entry '260539-1113' for key 'PRIMARY'
Warning 1062 Duplicate entry '271301-1097' for key 'PRIMARY'
Warning 1062 Duplicate entry '278957-2289' for key 'PRIMARY'
Warning 1062 Duplicate entry '287395-5367' for key 'PRIMARY'
Warning 1062 Duplicate entry '288503-895' for key 'PRIMARY'
Warning 1062 Duplicate entry '297911-6114' for key 'PRIMARY'
Warning 1062 Duplicate entry '297923-336' for key 'PRIMARY'
Warning 1062 Duplicate entry '314576-6501' for key 'PRIMARY'
Warning 1062 Duplicate entry '320147-5019' for key 'PRIMARY'
Warning 1062 Duplicate entry '345996-4380' for key 'PRIMARY'
Warning 1062 Duplicate entry '347272-6786' for key 'PRIMARY'
Warning 1062 Duplicate entry '357979-160' for key 'PRIMARY'
Warning 1062 Duplicate entry '360476-6793' for key 'PRIMARY'
Warning 1062 Duplicate entry '377385-7061' for key 'PRIMARY'
Warning 1062 Duplicate entry '379630-4448' for key 'PRIMARY'
Warning 1062 Duplicate entry '385020-3522' for key 'PRIMARY'
Warning 1062 Duplicate entry '388284-6330' for key 'PRIMARY'
Warning 1062 Duplicate entry '392920-6919' for key 'PRIMARY'
Warning 1062 Duplicate entry '396622-7249' for key 'PRIMARY'
Warning 1062 Duplicate entry '401564-7347' for key 'PRIMARY'
Warning 1062 Duplicate entry '406663-3278' for key 'PRIMARY'
Warning 1062 Duplicate entry '407842-2951' for key 'PRIMARY'
Warning 1062 Duplicate entry '415482-7414' for key 'PRIMARY'
Warning 1062 Duplicate entry '422056-4380' for key 'PRIMARY'
Warning 1062 Duplicate entry '426184-3793' for key 'PRIMARY'
Warning 1062 Duplicate entry '444512-6330' for key 'PRIMARY'
Warning 1062 Duplicate entry '444524-6330' for key 'PRIMARY'
(3,631.13s)...
Click to expand...

Also is there any fine tuning that could be done to the server to speed the import process as its taking quite a long time.
 
Last edited:
SimonV said:
For avatars export I get the following output
Click to expand...

SimonV said:
On the Import I had some errors at xf_conversation_message:
Click to expand...

SimonV said:
and xf_conversation_recipient
Click to expand...

Everything here is normal and can be ignored.

SimonV said:
Also is there any fine tuning that could be done to the server to speed the import process as its taking quite a long time.
Click to expand...

Thats simply due to the import effectively being a MySQL restore.
 
Hi,

I'm getting the 'Sed' related error while exporting posts. "sed: couldn't write 225 items to stdout: Broken pipe".
Does any one know what does it mean?


Here is the output
  1. ################################################
  2. ### XenForo Big Board vB3/vB4 -> XF Importer ###
  3. ### Original version created by Shawn Hogan ###
  4. ### Modified by Slavik and Jake Bunce ###
  5. ### Version Number: 1.2.0 ###
  6. ################################################

  8. 1 - Posts
  9. 2 - Users
  10. 3 - Threads
  11. 4 - Private Messages
  12. 5 - Avatars
  13. 6 - Attachments
  14. 7 - Forums
  15. 8 - Miscellaneous
  16. 9 - Everything

  18. Make Selection [1-9]: 1

  20. exporting posts...
  21. postsWarning: Using a password on the command line interface can be insecure.
  22. sed: couldn't write 225 items to stdout: Broken pipe
 
You must log in or register to reply here.

Similar threads

M
  • Question Question
XF 2.2 XF2 CLI import vs vBulletin Big Board Importer
Replies
1
Views
520
Slavik
Slavik
Slavik
vBulletin Big Board Importer for XenForo 2 [vBulletin 3 & vBulletin 4] [Deleted]
Replies
1
Views
807
Slavik
Slavik
Steffen
vBulletin 3/4 Moderator Log Import Command
Replies
0
Views
960
Steffen
Steffen
Kier
  • Question Question
XF 2.0 vBulletin 4 with Blog importer - known issue
Replies
8
Views
17K
Universal4
U
Mr Lucky
  • Question Question
XF 1.5 Redirect from vBulletin 3 and vBulletin 4
Replies
1
Views
488
Mr Lucky
Mr Lucky
Top Bottom