Login

mvnForum

mvnForum Homepage Welcome Guest
  Search  
  Index  | Recent Threads  | Unanswered Threads  | List Polls  | Public Albums  | Who's Online  | Help

  mvnForum
  Category: mvnForum Development
  Forum: mvnForum Development
  Thread: phpBB to mvnForum converter available

Quick Go »


No member browsing this thread
Thread Status: Active
Thread Type: Announcement Thread
Total posts in this thread: 24
Posts: 24   Pages: 3   [ 1 2 3 | Next Page ]
Post new Thread
Author
Previous Thread This topic has been viewed 12028 times and has 23 replies Next Thread
Male anandh
Newbie




Joined: May 22, 2005
Post Count: 21
Status: Offline
Reply to this Post  Reply with Quote 
biggrin phpBB to mvnForum converter available
Hi all :
Javareference.com recently completed a migration from phpBB to mvnForum. We created a java utility to facilitate this migration. The utility generates SQL statements from the source phpBB database. You can run these sql statements on your mvnForum database to migrate everything.

The converter supports most functionality except private messaging and statistics.

The utility is available for free download from www.javareference.com

http://www.javareference.com/downloads/viewdownload.jsp?id=00000032

To the developers of mvnForum and the community, please accept a big thank you from us at Javareference.com.

Thanks all,
_anand
[May 22, 2005 11:36:34 PM] Show Printable Version of Post    View Member Profile    Send Private Message    http://www.javareference.com [Link] Report threatening or abusive post: please login first  Go to top 
Male anandh
Newbie




Joined: May 22, 2005
Post Count: 21
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
And when you visit Javareference.com, please do join our forums over there for general java developer discussions.
Thanks much,
_anand
[May 22, 2005 11:38:31 PM] Show Printable Version of Post    View Member Profile    Send Private Message    http://www.javareference.com [Link] Report threatening or abusive post: please login first  Go to top 
Male minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2956
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
Hi,

Thanks a lot for your work on this, it will help a lot of users for the migration.

Btw, would you agree to migrate this tool to mvnForum's CVS so other users could continue to contribute on this great work ?

Thanks rose
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[May 25, 2005 12:33:51 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    http://www.MyVietnam.net    minhnn_mvn [Link] Report threatening or abusive post: please login first  Go to top 
Male anandh
Newbie




Joined: May 22, 2005
Post Count: 21
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
Hi Minhnn :

By all means. Please go ahead and integrate this as a tool in the mvnForum CVS. If you visit www.javareference.com, you should be able to download the jar file, which also contains the sources.

The code is not documented well, since it was developed as a tool for internal use, but it should be sufficiently self-explanatory.

Also, there are some missing parts, like private messages and formatting related stuff. Most everything i know is explained in the README which is available along with the zip.

Again, im happy you appreciate it, because everyone loves your forum.
Thank you again.

_anand
[May 25, 2005 1:15:38 PM] Show Printable Version of Post    View Member Profile    Send Private Message    http://www.javareference.com [Link] Report threatening or abusive post: please login first  Go to top 
Female redzara
Stranger




Joined: Apr 10, 2005
Post Count: 11
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
Thanks a lot for this converter. With some little modifications I've been able to directly convert my phpbb forum to mvnforum running with hsqldb (200 users, 50000 posts).
Just be carefull with quote remplacemnt in hsqldb and if you have forums with 0 posts. In fact, only 2 hours to have a working tool smile

Thanks again
[May 31, 2005 8:26:32 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male anandh
Newbie




Joined: May 22, 2005
Post Count: 21
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
Congratulations redzara. We are happy you were able to convert your existing forums to mvnforum. Would you mind if we quote you on javareference.com ?

Please let us know.
All the best...
[Jun 2, 2005 5:30:31 PM] Show Printable Version of Post    View Member Profile    Send Private Message    http://www.javareference.com [Link] Report threatening or abusive post: please login first  Go to top 
Female redzara
Stranger




Joined: Apr 10, 2005
Post Count: 11
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
Would you mind if we quote you on javareference.com ?


You are free to quote me if you want dancing
[Jun 3, 2005 6:06:27 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2956
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
Thanks a lot for this converter. With some little modifications I've been able to directly convert my phpbb forum to mvnforum running with hsqldb (200 users, 50000 posts).
Just be carefull with quote remplacemnt in hsqldb and if you have forums with 0 posts. In fact, only 2 hours to have a working tool smile

Thanks again

Could you give me more detail? what is your "little modifications" and what should be careful in hsqldb?

Thanks smile
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Jun 5, 2005 6:48:44 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    http://www.MyVietnam.net    minhnn_mvn [Link] Report threatening or abusive post: please login first  Go to top 
Female redzara
Stranger




Joined: Apr 10, 2005
Post Count: 11
Status: Offline
Reply to this Post  Reply with Quote 
Re: phpBB to mvnForum converter available
in PHPBBToMvnForum, you have to add class loading for hsqldb like :

try
{
Class.forName("org.hsqldb.jdbcDriver").newInstance();
}
catch (Exception E)
{
System.err.println("Unable to load hsqldb driver.");
E.printStackTrace();
}


and change

String mvnurl = "jdbc:mysql://" + mvnhost + "/" + mvndb;

with corresponding url format for your base

String mvnurl = "jdbc:hsqldb:file:D:/jetty/webapps/mvnforum/WEB-INF/mvnForumHome/hsqldb/mvnforum";


In Utils.java, public static String wrapit replace :

if(text.charAt(i) == '\'' )
strbuf.append("\\\'");
else

by

if(text.charAt(i) == '\'' )
strbuf.append("\'\'");
else


In Migrator.java, public static void migrateusers, replace :

String MemberLanguage = Utils.wrapit(RS.getString("user_lang"));
...
String MemberLastname = Utils.wrapit("");


by

// defaut code language
// if it's not set in phpbb
String MemberLanguage = Utils.wrapit("en");
...
// because mvnforum doesn't allow empty name
String MemberLastname = MemberName;



In Migrator.java, public static void migrateforums, after :

String last_post_id = RS.getString("forum_last_post_id");

add

// If you have a forum without any post
if(RS.getInt("forum_last_post_id") == 0) {
continue;
}


little more tweaks are needed if you have empty password

minhnn: I format the code
----------------------------------------
[Edit 3 times, last edit by minhnn at Jun 12, 2005 3:42:19 PM]
[Jun 6, 2005 1:24:13 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Female redzara
Stranger




Joined: Apr 10, 2005
Post Count: 11
Status: Offline
Reply to this Post  Reply with Quote 
sad Re: phpBB to mvnForum converter available
Humm, after convertion, I've some problems with 'Rebuild Post Search Index'
Scenary :
- new db
- import from phpdb
- login admin
- rebuild Memer Search Index : OK
- rebuild Post Search Index : OK but ...
Index Post count : 2112
Database Post count : 50103 worried

But in logs :
INFO | jvm 1 | 2005/06/09 14:29:48 | 14:29:48.231 INFO [Timer-0] com.mvnforum.search.post.RebuildPostIndexTask.run(RebuildPostIndexTask.java:108) >03> Rebuilt index finished successfully! 50103 post(s) indexed.
[Jun 9, 2005 12:48:08 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Posts: 24   Pages: 3   [ 1 2 3 | Next Page ]
Show Printable Version of Thread  Post new Thread

RSS feeds Current timezone is GMT
Jan 9, 2009 6:34:28 AM

Powered by mvnForum Portlet 1.2 GA (Build: 27 June 2008)
Copyright © 2002-2008 by MyVietnam.net