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

[howarde]

Well.. I put something in for 5138 and it works... Thanks.

 

[rdn]

This query should do it:

DELETE xft.*
FROM `xfdb`.xf_thread xft
WHERE xft.thread_id IN (
    SELECT vbt.threadid
    FROM `vbdb`.thread vbt
    WHERE vbt.open = 10
);

Backup first of course.

To run this, I must have both VB4 and XF database present on the current server, and just replace xfdb and vbdb with the real database name right?
Thanks!

 

[Slavik]

Yup

 

[rdn]

Yup

and I will run this inside XF Database right?

Cause if I run it outside any database, I got an error:

Static analysis:

3 errors were found during analysis.

1. Unexpected token. (near "xft" at position 7)
2. Unexpected token. (near "." at position 10)
3. Unexpected token. (near "*" at position 11)

MySQL said:

#1046 - No database selected

 

[Slavik]

Yes

 

[rdn]

42951 rows affected. (Query took 4.4829 seconds.)

That was a lot of vb4 thread redirects .

Any cache needs to rebuild?
Threads...and...?

 

[Slavik]

Just threads.

 

[Vincent Gabriel]

Suggestion:

add
--local-infile=1

to the mysql commands when importing, otherwise in some cases it'll throw the following:

ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version

Edit:

It does not import user groups, moderators, permissions etc. is that by design?

 

[Jake Bunce]

Edit:

It does not import user groups, moderators, permissions etc. is that by design?

Yes. You need to manually setup groups, perms, and mods in the XF Admin CP. But since this importer is designed to be run multiple times against the same XF install, this setup will persist for multiple runs.

 

[Vincent Gabriel]

Will it be a good idea to use the default xenforo import data through the admin cp to first import user groups, custom user fields and moderators?

 

[Jake Bunce]

Will it be a good idea to use the default xenforo import data through the admin cp to first import user groups, custom user fields and moderators?

That's not a bad idea. I don't see why that wouldn't work but I have never tried it.

Make sure you select the option during the import to preserve the source ids.

 

[Vincent Gabriel]

Thanks. I've been modifying the script to support certain things like the usergroups, custom fields, moderators and permissions. as well as minor changes to the output of the times, interactive console and ability to specify multiple banned user groups. I've also updated to read the configuration set for source db, destination db and paths from within a config file rather than modifying the class directly.

Overall the script is well written, very fast for a large board we are trying to migrate from VB3 to Xenforo.

375K users took us with the regular XenForo importer about an hour with this tool it took 102 seconds (1.7 minutes), over 1 million threads in right under a 1.5 minutes.

Great job. Thank You.

 

[rdn]

FYI, this script doesn't work with PHP 7.0 .

 

[zylstra]

Will it be a good idea to use the default xenforo import data through the admin cp to first import user groups, custom user fields and moderators?

My Big Board Importer guide has all this info (and much more) in it. Have you seen it? If so, did you find it useful?

 

[zylstra]

Is this exporter hyperthreaded? At first I thought not but the xf_user.txt file kept growing after the CLI had moved on to displaying the export of threads and more after I chose 9 (Everything) at the initial prompt.

 

[Slavik]

Is this exporter hyperthreaded? At first I thought not but the xf_user.txt file kept growing after the CLI had moved on to displaying the export of threads and more after I chose 9 (Everything) at the initial prompt.

http://php.net/manual/en/intro.pcntl.php

 

[digitalpoint]

Is this exporter hyperthreaded? At first I thought not but the xf_user.txt file kept growing after the CLI had moved on to displaying the export of threads and more after I chose 9 (Everything) at the initial prompt.

Technically not hyper-threaded (that is an Intel thing that creates two virtual CPUs per single actual CPU). But it is multi-threaded, yes.

https://en.wikipedia.org/wiki/Multithreading_(computer_architecture)

 

[zylstra]

Ah, yes, I meant multi-threaded. I see the pcntl statements now.

 

[zylstra]

I believe Import.php has line 108:

//importTable('xf_ip');

commented out. Why is this?

Can I can uncomment that line to convert IP post history to Xenforo?

 

[Slavik]

I believe Import.php has line 108:

//importTable('xf_ip');

commented out. Why is this?

Can I can uncomment that line to convert IP post history to Xenforo?

Yes,

It's commented as for the most part IP history is worthless unless you have a specific reason for it.