How to import?

Is it possible to import a site running on IPB 2.1 to xenforo? I would like to avoid doing a double import because there is a media gallery that i would like to import into the XenForo media gallery. If i wanted to write a custom importer script how would i go about doing that?

See also: python mysql db migration script?

 

I have never tried this because I have never used IPB, However my suggestion would be to test the import Choose to import the oldest version Xenforo Allows you to Which I believe is 3.1, See if the import works properly and if so then you should be able to move the site live once you have the site integrated to your current design. Alternativly you can probably find someone to import the data manually or create an import script.

 

I will try that or i will create a script. How do i import the data manually myself?

 

There is an import tool in xenforo. Click the tools tab, then there is an option to import external data. Try using that tool before trying to create a script to do so.

 

The import tool was not designed for IPB 2.1.7.

 

Well I don't know what to say then, I was just suggesting that you try the import tool and see if that will work for you. If not then getting one developed would be the way to go.

 

Sorry for my ubrupt previous reply my phone died and I was unable to edit the post before it went through.

Anyhow you could also try to import the data by exporting the tables from both databases in a csv format and doing a merge in excel to get the tables to work. However that is very dagerous and I would take a backup of your new site before uploading the merged database.

You can also take those two exported databases side by side and copy each users info into the xenforo database manually.

 

The site has 32 thousand users and close to 1 million posts. I don't really know much programming, but i want to develop the importer myself.

 

Contact Xenforo support they may be able to help you with that. I am sorry I didn't guve the best of answers I thought I could help.

 

I do not want to do a double import, because there is a media gallery and i would like to import that into the xenforo media gallery. I want to make my own script, but i am not really sure where to start. How would i make a python script? It is not my site. I am doing it for free for this guy and i could use the experience.

 

He was unable to contact the original owner of the site. At this point it is unlikely that i will have to do the import and that is a good thing.

EDIT: He is still determined to get that site. It looks like i might be doing the import after all.

 

I found this code: http://mattsnider.com/script-for-easy-mysql-migrations/ Would it work?

 

I have not defined any tables, but this is what i have so far.

"""
This is an importer that will import IPB 2.1.X to XenForo 1.X.X.
"""
HOST_NAME = 'mysql_host_name'
USER_NAME = 'mysql_user_name'
USER_PASS = 'mysql_password'
DATABASE  = 'mysql_db_name'
TABLE_NAME = 'db_migrations'

Code (markup):