ImpEx Module: Xenforo
 

This is a Xenforo module for ImpEx, the vBulletin Import System,
it does allow you to import a Xenforo Database into a vBulletin 4 installation.

Currently, the following data will be imported:

• Usergroups
• Users including Avatars
• Forums
• Threads including Polls
• Posts
• Smilies
• Attachments
• Conversations
  As vBulletin does not have an equivalent to the Conversations feature in Xenforo, conversations will be converted to Private Messages in vBulletin.
  Please note that any attachments used in conversations will get lost as vBulletin does not (yet) support attachments in PMs.

This module has been developed for Xenforo 1.0.4, but it should also work with Xenforo 1.1.X.
Please not that Xenforo 1.1.X features (Profile Fields, Thread Prefixes, etc.) are not yet supported.

If there is enough interest I might add those features in a later release.

Warning
This module is BETA and has not been tested extensively - use it at your own risk.
If you find bugs, please report them!

Important - See Post #87 about an important potential security issue and fix if you use this.

Good job Andreas. Thanks for the help.

Scott

As always great work Andreas!

Nooooooo .... spent hours and hours converting mine through IPB to get it back!!!!

Excellent work as always though m8. Im sure there are a fair few people who will greatly appreciate this effort

Thanks Andreas, looking forward giving this a test run.

great release!!

I don't need it now but it's very nice to have the option if needed

Thanks for sharing :)

thanks for sharing this, great work,
thought to porting my xf to vb, because xf now dead --;

LMFAO!!! I had thought about doing that at one point but changed my mind.

I'm just glad this is free.

I can't get attachments to import, source file not found.

What is the path you did enter for attachments?

I entered the path to the /data/attachments folder, attachments worked fine though.

However when I ran attachments it looked for filenames like "blah.jpg" but xenforo stores all its attachments as 466545646546545664 and other random numbers while the actual file names are in the database under the xf_attachment_data table.

Is there anything that could be done for attachments?

If you require any other information please do let me know!

Awesome indeed Andreas :D

Thats's the wrong path, this directory only contains thumbnails.
You must enter the part to internal_data/attachments.

The filename is just for human readability, it does look for the real file (well, at least it should :)).

the path to internal_data/attachments does not work, it still tells me source file not found for every single attachment.

If you need any other info do let me know! I would very much like to be able to do the full import as soon as possible, thank you for the support and time you have put into this :)

Look forward to your next response.

Seems like you are SOL with this problem then as it works just fine for me.

Sorry, but I can't help you without access to your server.

You might want to check that the path is indeed correct and that the webserver has read access to read the files:
Put
in line 94 of 010.php to see which files are actually being accessed.

I'd have just stopped at IPB...

Maybe one day vBulletin will come up with a 3.6.12 to 4.2 upgrade script for vBulletin.org ;)

I managed to get the attachments imported but on the very last step after importing attachments which worked perfectly I get this error on the last button. Process Inline attachments

ImpEx Database error

mysql error: Invalid SQL:
SELECT attachmentid
FROM attachment
WHERE importattachmentid != 0
ORDER BY attachmentid ASC
LIMIT , 10


mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10' at line 5

mysql error number: 1064

Date: Tuesday 22nd 2012f May 2012 05:52:31 AM
Database: mydatabase
MySQL error:+
Anyway to fix that?

Thanks for your support!

Quick update: I can't even click on the Import button in the ACP, I also get the error above.

Hi i get this Error after importing the forums:



First i thought this is a problem with my target DB, but the connection seems to be fine. So I have no idea what is going wrong here.

Maybe someone has an idea?

Thanks for your help!

Benny

@TFGoRP
Sorry, but as said before - I can't help you without access to your server.

Line 510 of 000.php should be
instead of

Thanks for your help! I will try it as soon as I get home from work :)

Benny

please any one guide me how to use this please ...

ImpEx must bring in tons of customers for vBulletin ... Great work guys :)

IMO all the {$tableprefix} are unnecessary, because xf doesn't have a table prefix:)

i have just convert XenForo 1.1.2 TO vBulletin 4.1.12 all works fine but passwords issue...:(

Hmm ... at least my sample database does have one (xf_).

It is not possible to just import XenForo passwords into vBulletin as XenForo password hashes are incompatible with vBulletin, you would have to create an Addon to handle authentication differently than vBulletin does by default.

Although this would be possible, it requires quite a bit of work.

That's the standard prefix which is hardcoded in the entire code and used for all standard xf tables

http://xenforo.com/community/threads...-prefix.19408/
http://xenforo.com/community/threads...xenforo.31837/

Hardoced or User-Defined doesn't really matter, after all it is a prefix :)

Thank you so much Andreas...this was one of the biggest things stopping me from bringing my main site back to vb...when I am finished setting up my new vb version of the site I will give this a try.

Thanks again

please guide me how to create addon please.
Regards

So I can import all my users but the can't login is that what I am hearing?

Not without resetting their password, yes.

Take a look at how login.php, functions_login.php do work, extend the database to store XenForo Login credentials and program the required Plug-ins.

You know if IPB converts to their passwords and Impex will convert IPB passwords?

AFAIK current IPB versions don't use a hashing scheme that is compatible with vBulletin, eg. if you import IPB accounts you would most likely have ot reset passwords as well.

Anyway to make it accept current xf password and force them to change the password?

hehe it's like ping pong, everyone wants to convert now as things been quiet on the xF front and vB 4.2 just came out.. Next when xF 1.2 comes out, everyone will want convert again til vB 5.x.. etc

I actually converted to code in both worlds, but when my vBulletin database crashed (probably XenForo doing...) I was resorted to keeping the converted XenForo. I've never liked it, but have found myself making more of a profit on XF than vB, but loosing my SEO has dropped my members and guests by half, so the money I have earned making mods on XF, I have lost by advertising revenue decrease. So... Money wise it's about equal, but from day one about 6 months ago, I wanted to switch back. Note to self... Never install and convert a database table... On the same database.

Ohhh, and no, it won't be ping pong, I will be selling my XenForo license after this mess is cleared up. Coding on their platform is more complicated, auto template editing is not even possible yet, which really aggravates me and other customers.

Hello there ...

I am very new here ..

my old board is xenforo and I like to transfer in VB4.20 but my problem is how to get the data from my old one ..

anyone can help me ..

Regards,