1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to import?

Discussion in 'XenForo' started by CarpCharacin, Jun 23, 2016.

  1. #1
    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?
    SEMrush
    See also: python mysql db migration script?
     
    Last edited by a moderator: Jun 30, 2016
    CarpCharacin, Jun 23, 2016 IP
    SEMrush
  2. ALN2015

    ALN2015 Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #2
    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.
     
    ALN2015, Jun 29, 2016 IP
  3. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #3
    I will try that or i will create a script. How do i import the data manually myself?
     
    CarpCharacin, Jun 30, 2016 IP
  4. ALN2015

    ALN2015 Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #4
    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.
     
    ALN2015, Jun 30, 2016 IP
  5. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #5
    The import tool was not designed for IPB 2.1.7.
     
    CarpCharacin, Jun 30, 2016 IP
  6. ALN2015

    ALN2015 Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #6
    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.
     
    ALN2015, Jun 30, 2016 IP
  7. ALN2015

    ALN2015 Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #7
    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.
     
    ALN2015, Jun 30, 2016 IP
  8. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #8
    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.
     
    CarpCharacin, Jun 30, 2016 IP
  9. ALN2015

    ALN2015 Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #9
    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.
     
    ALN2015, Jun 30, 2016 IP
  10. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #10
    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.
     
    CarpCharacin, Jun 30, 2016 IP
  11. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #11
    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.
     
    Last edited: Jul 3, 2016
    CarpCharacin, Jul 3, 2016 IP
  12. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #12
    I found this code: http://mattsnider.com/script-for-easy-mysql-migrations/ Would it work?
     
    CarpCharacin, Jul 10, 2016 IP
  13. CarpCharacin

    CarpCharacin Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    65
    #13
    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):
     
    CarpCharacin, Jul 11, 2016 IP