Importing Data into vBulletin

an article added by: Linda Gould at 05312007


In: Categories » Internet and online » Forums » Importing Data into vBulletin

If you are moving to vBulletin from another type of discussion board, then there is a good chance that you won't want to lose all the posts that you already have and start again with nothing. And it's not just the posts that are important what about all your member information usernames, passwords, profile data? You don't want to lose all that and start with aIn the right-hand pane you get information about the version notice how we are being told that there is a newer version of vBulletin available. That's a really handy feature, and later on we'll show you how to upgrade the forum software quickly and easily.
We suggest that you spend some going through the menus and familiarizing yourself with the options and settings available especially if this is your first installation of vBulletin. We will pick up the tour of the vBulletin Control Panel in Article 3. Now we need to go and look at importing data from another discussion board into vBulletin.

Importing Data into vBulletin
If you are moving to vBulletin from another type of discussion board, then there is a good chance that you won't want to lose all the posts that you already have and start again with nothing. And it's not just the posts that are important what about all your member information usernames, passwords, profile data? You don't want to lose all that and start with a blank forum!
To make migration easier, the vBulletin development team has created a Import/Export script (called the ImpEx script).
Downloading the ImpEx Script
The ImpEx script is available from the Member Area on the vBulletin site. This means that you need a valid license to be able to download it.
After downloading the script, you will need to extract the files into a convenient location (just as you did with the vBulletin installation files).
Compatibility
The following boards are supported in the ImpEx script:

• IPB (version 2)

• phpBB (version 2.0.4 - 2.0.11 MySQL and MSSQL))

• Infopop eve (EVE: version 1.2.6, UBB.x forum module: version 4.0.3)

• IPB (version 1.1 - 1.3)

• wBB (version 2)

• Ubb_classic (version 6.3 - 6.7)

• Open Topic & Ubb.x

• DCFm (DCForum+ MySQL backend)

• YaBB SE (version 1.5.5)

• Ubb_threads (version 6.4)

 blank forum!
To make migration easier, the vBulletin development team has created a Import/Export script (called the ImpEx script).
• vBulletin 3 (version 3.0.x -> vB 3.0.x)

• Snitz (version 3.4.x MySQL and MSSQL)

• Ikonboard MySQL (version 3.x)

• XMB (version 1.9)

  • • CuteCast (version 2.0)
  • • vBulletin (version 2)
  • • ThwBoard (version 3)
  • • SMF (version 1.0)
  • • DiscusWare (version 4.00.x)
  • • vB (version 1.0 RC 1)
  • • YaBB - Gold (version 1.3.1)
  • • openBB (version 1.0.7)
  • • deluxeportal (version 2.0)
  • • Digiposts (version 2.0)
  • • Phorum (version 3)
  • • Fusetalk
  • • WebWiz (version 7.9)
  • • Maxportalweb
  • • Jiveforums
  • • Xoops Newbb
  • • Siteframe
  • • PNphpBB2
  • • TruBB
  • • bbBoard2
  • • MyBB
  • • tritaniumbb2
  • • ASPPlayground (MSSQL)
  • • Geeklog
  • • PunBB
  • • e107.org
  • • phpBB1
  • • Oyxgen
  • • megaBBS (version 1.69-2.1 MySQL & MSSQL)

• yahoogroups_text

  • • wowBB
  • • vB lite (version 1.0)
  • • Encore II
  • • Infopop eve (EVE: version 1.2.6, UBB.x forum module: version 4.0.3)
  • • IPB (version 1.1 - 1.3)
  • • wBB (version 2)
  • • Ubb_classic (version 6.3 - 6.7)
  • • Open Topic & Ubb.x
  • • DCFm (DCForum+ MySQL backend)
  • • YaBB SE (version 1.5.5)
  • • Ubb_threads (version 6.4)

• Freethreads

  • • W-agora
  • • ttCMS
  • • Simpleboard mambo server
  • • Allaire
  • • dotnetBB
  • • Beta support for vBzoom

Preparing for Upload
When the unzipping progress is complete, you will find that the process has created a new folder called xxxxxxxx.impex (where xxxxxxxx is the license number of your vBulletin license).
Within this folder you will find another folder called upload. This folder contains the ImpEx files that need to be uploaded to your web server.
Editing the Configuration File
However, you're not ready to upload just yet. First you must make some changes to the ImpEx configuration file. This file is located in the impex subfolder of the upload folder and is called ImpExConfig.php.new.
As before, the first thing you must do is rename this file from ImpExConfig.php.new to ImpExConfig.php (removing the .new extension). This step is in place to make sure that you remember to edit the file!
To edit the ImpExConfig.php file, you will need to open the file in a text editor such as Windows WordPad. (Again, the use of Windows Notepad is not recommended, as Notepad has problems displaying line breaks.)
The settings in this file need to be edited in order to get the script working.
The settings that require editing are divided into two groups.

  • • Target database
  • • Source database

Target Database Settings
The target database is the database that will be having data imported into it by the script.

  • • targetdatabasetype Enter the type of database here. This is usually mysql.
  • • targetserver This sets the address of your database server. On most installations the database server is located on the same computer as the web server, in which case the address should be set to localhost, otherwise use the address of the database server as supplied by your web host.
  • • targetuser This contains the username to connect to your target database.

• targetpassword This is the password to connect to the target database.

  • • targetdatabase This is the name of the database that contains your vBulletin.
  • • targettableprefix If your vBulletin installation uses a prefix on the tables, then set this value here.

Source Database Settings
The source database is the database that the script will be extracting the data from.

  • • sourceexists If the system that is being imported from uses a database, enter the details for it here and set sourceexists to TRUE. If the source data is not contained in a database, set sourceexists to FALSE.
  • • sourcedatabasetype Enter the type of database here. This is usually mysql.
  • • sourceserver This sets the address of your database server. On most installations the database server is located on the same computer as the web server, in which case the address should be set to localhost. Otherwise use the address of the database server as supplied by your web host.
  • • sourceuser This contains the username to connect to your source database.
  • • sourcepassword This is the password to connect to the source database.
  • • sourcedatabase Change this value to state the name of the database that contains your other forum software data on the database server.
  • • sourcetableprefix If the source database uses a prefix for the tables, set that here.

Upload the ImpEx Script
When you have finished editing the ImpExConfig.php file, you should save it and you are then ready to upload the ImpEx script to your web server.
Remember only to upload the contents of the upload folder.
Connect your web server with your FTP program and upload the files and folders.
As we saw earlier in this article, FTP client applications usually handle the file transfers automatically, but if this does not happen, then all text files (.html, .php, .js, .xml, and .css) will need to be transferred in ASCII mode, and all non-text files (.gif, .png, .jpg, and .ico) will need to be transferred in Binary mode.
Once all the files are uploaded, you are ready for the next stage of the installation.

Running the ImpEx Script
From your Admin Control Panel select Import & Maintenance, then Import / Export, and select the system you wish to import from the list.
Version issues
Note that the ImpEx script has been written for version 3.0.1 and higher of vBulletin.

The script will then run automatically, and all you need to do is run each module by clicking on the appropriate button. Make sure that you work through each module in turn and don't be tempted to skip steps or rush things the ImpEx script can take a lot of time.
If you receive an error message, make a note of it and carry out a search for it on the vBulletin forum. If you cannot find a resolution, contact support importing data is a complex procedure, but the vBulletin support team is likely to be able to help you with any problems that you might have.
Check usergroups
After each import, check all options for every usergroup that was imported into vBulletin using the ImpEx script, and make sure that all the usergroup permissions are set correctly.
We will be covering usergroup management in Article 5.
Default Usergroups
Every member on a vBulletin discussion board must belong to at least one usergroup. These usergroups allow you to control who has access to what and later on (Article 5) we will be taking a closer look at the usergroups. However, vBulletin comes pre-installed with default usergroups, which can be used to get the forum up and running quickly.

• Administrators These are the users with the most power, and membership should usually be restricted to forum owners. Administrators have control over almost all features of the discussion board.

  • • Moderators These are members with more powers than regular members but less than administrators. These are normally the people who look after the forum moving posts that are in the wrong place, deleting inappropriate posts. Choose trusted people for this role.
  • • Registered Users Almost everyone else! These are the people who sign up to participate on the forum.

Banned users!
Handling banned users is something that we will come to in Article 5.
These are the main vBulletin usergroups, and most members will belong to these (unless you have made some significant changes to the way your forum works).
Securing vBulletin
vBulletin is a very robust and secure application, but it still needs you to take care of some things for it to remain totally secure.

  • • It is passwords that secure vBulletin make sure that all your passwords are good passwords (eight characters or greater, containing upper- and lowercase characters and numbers). Change your passwords every so often (at least 4 times a year).
  • • Remember too that it's not just forum access that you need to be mindful of anyone who has access to the web server or MySQL also has access to the data the forum contains. Make sure that the passwords protecting these are robust, and if you need to give someone access (such as support personnel), change them afterwards.
  • • Make regular backups of your forum data (files and database), and keep these safe just in case of a future problem.
  • • Carry out software upgrades regularly.

Help & Support
The installation and initial setup of vBulletin is quite simple and straightforward, thanks mainly to the thought put into the software and also the easy–to-follow wizard-style setup interface.
If, however, you run into serious problems, then your first port of call should be the vBulletin community forum here you will find years of vBulletin information in one place. Chances are that a few searches will turn up a solution to your problems.

If that's not enough, then you can fall back on vBulletin support for help you will need to fill in a trouble ticket and then wait for a response. This is usually fast and you should get an initial response in a few hours.
In order that you receive the best support, make sure you pass on the following information:

  • • vBulletin version
  • • PHP and MySQL version (Ask your host if unsure.)
  • • Exact error message
  • • Description of what causes the error
  • • Is the error repeatable?

The more information you provide, the easier it is for the vBulletin support team to be able to quickly and accurately deal with your problems.
Summary
We've looked at a lot in this article and covered everything you need to know to install and carry out the initial configuration of the vBulletin software.
If you are installing the vBulletin software for the first time, then take your time, especially when editing the configuration files. (Keep a backup in case you make a mistake!) It can be annoying to get to the installation wizard stage only to find that you made some simple mistakes early on.
If you are upgrading from another discussion board, then be extra careful and take extra precautions you want to make sure that everything goes back properly and that members can't do or see more than they should!
Also, once you have vBulletin up and running, take time to familiarize yourself with the software. A article like this is very useful, but it can only go so far. Work your way through the menus and options. Don't feel that you need to make changes just seeing what's available and getting to grips with the defaults can be educational.
Finally, if things do go wrong, then remember that along with purchasing software you also bought support that you can always fall back on if you get stuck or if the worst happens.

legal notice

Our website is not responsible for the information contained by this article. Web-articles is a free articles resource.
Suggestion: If you need fresh, daily updated content for your website, feel free to use our service. Click here for more information.

Useful tools and features

Link to this article from your page    Send this article to you or to a friend
If you like this article (tutorial), please link to it from your web page using the information above.

related articles

1. Introduction to the vBulletin Board
Before we see how to install vBulletin, and how to customize and hack the board, let's take a little time to look at the board, the company behind it, and a little of its history. We will also show you what other people have accomplished with this most versatile and powerful board. What is vBulletin? This is a good place to start! vBulletin is software that is loaded onto a web server to allow you to create and manage online forums or discussion boards. It is des...

2. The vBulletin Advantage
The vBulletin Advantage What are the key benefits from choosing and running vBulletin? Here are the top reasons to base your community on vBulletin. Versatile vBulletin is designed to be versatile and can be run on a variety of platforms. • vBulletin is written in PHP, making it fast, efficient, and capable of running on a broad range of hosting platforms. Shared hosting provides the cheapest option, while semi-dedicated hosting solutions offer more power...

3. vBulletin Licensing Options
vBulletin Licensing Options vBulletin is a commercial product, and you must therefore buy a license before you can use it. To offer site owners the greatest possible flexibility there are two licensing options to choose from: • Leased license • Owned license Leased License Purchasing a leased license will allow you to run vBulletin on your server for one year. During this period you will be entitled to technical support and softwa...

4. The requirements of vBulletin
In the next article we're going to be shifting our focus to the installation and configuration of vBulletin. In this article we begin at the point where most people begin with vBulletin with a copy of the software and somewhere to upload it to. If you have both of those, then you are probably eager to get going with the installation! We will look at: • The requirements of vBulletin • How to install the files • How to create the database • How ...

5. The vBulletin Control Panel
The vBulletin Control Panel Now that you have come this far, you are probably eager to access the Control Panel and get started. Click on the link on the Step 13 page to access the Control Panel. (You will need to have deleted the install/install.php file before being able to continue.) After clicking on the link you will then need to enter the username and password you assigned to the administrator during the installation of vBulletin. Once you log into the Control P...

6. The vBulletin User Experience
A Tour of vBulletin In the previous article we looked at the vBulletin installation process. This process involved downloading the installation files, making edits to the configuration files, creating or preparing a database for vBulletin, uploading the installation files, and finally going through the vBulletin installation wizard. We also looked at how to import posts and settings from another discussion board into vBulletin. Now that you have a working vBulletin board, the next thing that you need to do is famili...

7. Customizing Your vBulletin Board
  Customizing Your vBulletin Board Most of the best discussion boards on the Web have been customized in one way or another. Some have only basic customizations to give the place a specific look and feel, while others have been heavily modified and customized to look, feel, and work exactly how the owners want them to. At this stage you probably want something in the middle you want a certain level of customization but don't want to take on too much too soon, right? That's fine the g...

8. vBulletin templates
Template Modifications So far we've looked at how to modify CSS stylesheet information, which controls how vBulletin looks, and the phrases, which control the text. Both of these modifications allow you to radically change how your vBulletin board looks and feels. Template modifications allow you to do a lot more and to make much more radical changes to your vBulletin installation. In fact, templates control nearly every aspect of a vBulletin board. Each page that the end user sees is the result of one or mo...

9. Hacking a vBulletin Board
Hacks So far we've talked about making modifications to a vBulletin installation, and we've looked at four different ways to modify the installation. So far we've called the changes 'modifications', but the term that you are more likely to see used on the web is 'hacks'. Whenever a board is modified, it is said to be hacked (not to be confused with 'hacked' as in the security being compromised by a hacker), and modifications are known as hacks as in "hacks to a board"...

10. Administering Your Forum
Administering Your Forum There's a lot to do as a forum administrator. It's not just about participating in the discussions, facilitating new discussion, and making the tough decisions as to who should be moderated or banned. There's a lot to do behind the scenes the day-to-day care of the forum as well as routine maintenance. You will also run into problems from time to time, and then you will need to carry out emergency repairs to get your forum going again. This article is about the most common tasks an adminis...