jforum example source code file (8.txt)

This example jforum source code file (8.txt) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - jforum tags/keywords

admin, if, in, innodb, jforum, jforum, phpbb, phpbb, phpbb2jforum, phpbb2jforum, phpnuke, the, the, you

The jforum 8.txt source code

!!! PHPBB / PHPNuke to JForum migration
Migrating from a PHPBB or PHPNuke forum to JForum is quite straightforward. We provide a command line tool that reads all information from a source database - PHPBB or PHPNuke - and convert it to a JForum database. 

JForum's ''Phpbb2JForum'' is able to import ''most'' of the tables, as shown in the table below. Please note that, while there are items marked as __%%(color: red)no%%__, is doesn't  mean that JForum don't have a relative table - It only means that the table's data will not be imported by the tool. 

||Table Name||Is data Imported?||Description
|phpbb_auth_access|__%%(color: red)no%%__|JForum uses a completely different security model from PHPBB. 
|phpbb_banlist|__%%(color: green)YES%%__|
|phpbb_categories|__%%(color: green)YES%%__| 
|phpbb_config|__%%(color: red)no%%__|Configurations in JForum are completely different from PHPBB
|phpbb_confirm|__%%(color: red)no%%__| 
|phpbb_disallow|__%%(color: red)no%%__| 
|phpbb_forum_prune|__%%(color: red)no%%__|Feature not implemented yet
|phpbb_forums|__%%(color: green)YES%%__| 
|phpbb_groups|__%%(color: green)YES%%__|Groups are migrated, but not group roles ('permissions'')
|phpbb_posts|__%%(color: green)YES%%__| 
|phpbb_posts_text|__%%(color: green)YES%%__| 
|phpbb_privmsgs|__%%(color: green)YES%%__|All private messages are imported
|phpbb_privmsgs_text|__%%(color: green)YES%%__| 
|phpbb_ranks|__%%(color: green)YES%%__| 
|phpbb_search_results|__%%(color: red)no%%__|JForum uses [Lucene|http://lucene.apache.org] for search
|phpbb_search_wordlist|__%%(color: red)no%%__|Same as above
|phpbb_search_wordmatch|__%%(color: red)no%%__|Same as above
|phpbb_sessions|__%%(color: red)no%%__|Session information is irrelevant
|phpbb_smilies|__%%(color: green)YES%%__| 
|phpbb_themes|__%%(color: red)no%%__|JForum uses a different template engine
|phpbb_themes_name|__%%(color: red)no%%__| 
|phpbb_topics|__%%(color: green)YES%%__| 
|phpbb_topics_watch|__%%(color: green)YES%%__| 
|phpbb_user_group|__%%(color: green)YES%%__|
|phpbb_users|__%%(color: green)YES%%__| 
|phpbb_vote_desc|__%%(color: green)YES%%__| 
|phpbb_vote_results|__%%(color: green)YES%%__| 
|phpbb_vote_voters|__%%(color: green)YES%%__| 
|phpbb_words|__%%(color: red)no%%__|JForum currently does not implement this feature 

!! Permissions / Access rights
''Phpbb2JForum'' __does not__ import permissions / roles, so, after the importing process is finished, you'll need to manually setup access rights for each for the imported groups. The migration tool only setup Admin access for those users who also are Administrators in the PHPBB version. 

!! Search - Indexing the database

!! Downloading the import tool
The current version of ''Phpbb2JForum'' has a command line interface only, although a graphical one is planned for next versions. Also, you'll need to have Java 1.4 or newer installed on your computer. 

First, download ''Phpbb2JForum'' [here|https://jforum-tools.dev.java.net/files/documents/2106/9470/phpbb2jforum-1.0.zip], and unpack it in any directory. It is recommended you create that a specific directory for it, like ''c:\jforum_migration'' or ''/home/johndoe/jforum_migration''. 

!! Preparing the environment
Now, you will need to have both JForum and PHPBB's tables under the same database name. In other words, ''Phpbb2JForum'' will search for phpbb's tables in the database's name passed as argument to the program ( as shown later in this doc ). So, if you're going to run JForum on a database named "jforum", all PBPBB tables should be located in this same database before the migration starts. You can achieve this by simple dumping ( using mysqldump, for example ) and restoring into the target database. 

The JForum's tables should be already created as well. The tables' structure are placed at ''WEB-INF/config/database/mysql/mysql_db_struct.sql''. 

!! Running

[{Note title='MySQL table type'

If you are using MySQL, set the table type to ''MyISAM'' instead of ''InnoDB'' before running the migration tool. This will make the SQL statements run much faster. 
After you finish with the data importing, you can set back to ''InnoDB''.
}]

Now, open the Prompt ( or a shell, if running some Unix like machine ) and go to the directory where the files are located. If you are running a Windows box, the program you'll run is named ''phpbb2jforum.bat''. If running Linux or other Unix like OS, the program is ''phpbb2jforum.sh'' ( please confirm if it has execute - "chmod +x" - permissions ). 

You should pass as arguments the database name, username, password and database host, as shown above:

[{Highlight
c:\jforum_migration\phpbb2jforum.bat jforum root rootPassword localhost 
}]

in this example, ''localhost'' is the host where the database server is, ''root'' is the username, ''rootPassword'' is the password for the ''root'' user, and ''jforum'' is the database name. Press <ENTER> to start. Wait until the program finishes, and then you're done. 

!! Permissions
The script __does not__ migrate permissions, so you'll have to do it manually. For the start, please access http://www.jforum.net/posts/list/399.page . In this link is shown how to set the administrator's role, which you can use as start to access the Admin Panel.