Importing the member only data from SNITZ ( Access ) to VBulletin ( MySQL )

Blog Category: cfzr.com — Blogged by: jane on March 12, 2010 at 7:02 am
  • I have a forum at http://www.xBhp.com. I have decided to s hift to vBulletin. I dont want to import the posts and topics into the vBulleting board. Instead i would onli lik eto import the member data, even if its only the user name and the email addresses, so that i can request the members to get a new password for the board.

    I have chalked out a very simple logical plan to import this data.

    I make a ASP page which connects to the Access DB and loops the forum members table. It gets the member name in each loop and calls a PHP page which in turn connects to the Vbulleting My SQL database. It inserts the member ID value from the ASP page to the correct table field in the VBulleting MYSQL DB.

    I can customize this script by just changing the source and destination field names. What do you think? WIll it work? I am not a pro-programmer ( its not meant to be a stutterm pardon me :D ).

    Would really like to get hands on this slick forum fast, so please answer my
    queries!


  • Lastly, can you please lend me a list of reliable hosts which provide PHP hosting and have plans which support around 50GB trabsfer every month? My budget is around a maximum of 50$s a month.


  • Welcome to vBulletin

    With this Snitz (3.4.x MySQL and MSSQL) (http://www.vbulletin.com/forum/showpost.php?p=678080&postcount=14) Impex importer, you can import selective data which you want to import.

    So you probably won't need to make that ASP script :)

    Edit: Plus your script will won't fully work. While it will import all data, vBulletin has a much different encryption method on passwords. While most boards use a standard MD5 hash, vBulletin does a double MD5 hash while encrypting it with a SALT key.


  • try www.ev1servers.net (http://www.ev1servers.net) and www.steadfastnetworks.com (http://www.steadfastnetworks.com)


  • vBulletin.org is the official site for codehacks. Jelsoft doesn't support hacks written by any third party author, but from my past history with Jelsoft, they do support boards with hacks and is still considered legal and valid for tech support.

    However anytime there's a problem with the hack, Jelsoft will tell you to go run to the author, and not them :)


  • Thanks for the prompt reply. Now that one of the things have been clarified i will go to my next query. ( I will rather ask here than start a new topic. )

    My next query :

    I have come across the website at vbulletin.org, they offer hacks for vBulletin. After applying the mods will my vBulletin copy still be legal and valid for tech support. I am aksing this because there are some great mods over there and would really rellay like to install them after i procure my copy. I hope vBulletin officially supports them.

    So will there be any problem, legal / customer support wise after i install those hacks?

    Regards


  • www.hostgator.com :)


  • www.asmallorange.com is very good.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Importing the member only data from SNITZ ( Access ) to VBulletin ( MySQL ) , Please add it free.