Hi there,

I'm currently using a message board system on my Web site
(http://smilezone.com/cc) powered by "Discus" (Discus 4.0beta, with
mySQL, at http://www.discusware.com/) and due to a number of factors,
I'd like to switch over to "InvisionBoard"
(http://www.invisionboard.com/).

I have thousands of messages and thousands of members on my current
board, and I'm very unhappy about the prospect of having to start over
from scratch.

From my research, I've sadly found no programs that convert members
and/or messages from Discus to InvisionBoard, so I am looking for a
"bridge"... something to convert from Discus ---> "X" --->
InvisionBoard.

Your mission, should you choose to accept it, is to find OR CREATE a working
bridge for me.

Thanks in advance for your help :-)

Regards,
Adam

I can't help you with the conversion but I can say that Invisionboard
is an excellent choice - I use it myself -very good user support at
http://invisionboard.com as well as from the source itself - check out
the forums if you haven't already

There was one post mentioning Discus -made today (that may have been
you???)

You might need a custom conversion job, but if you go thru that
trouble - you might consider posting it there for future users!

Bob, yes, from my searching, I'm the only one who has posted about
Discus in the IBF forums.  I do appreciate you thinking of me and
posting here, though, and also appreciate your reassuring me that IBF
is really a good way to go.

It's a difficult decision, however.  I'll be losing out on many cool
functions and benefits that Discus has over IBF... and that's why I
can't imagine dealing with the changes AND starting over from scratch.

And you're right, I may have to suck it up and pay someone
specifically to do a custom conversion.  If you have any
recommendations on that (specific people, groups, or things to look
for in a conversion specialist), that'd be much appreciated.  You're
welcome to write me at thatadamguy@smilezone.com, though you're also
certainly welcome to post any further responses here, since I'm
guessing that others might benefit from this Conversion discussion.

Thanks much for your reply!

Regards,
Adam

I don't know much about invision, but there is a script to convert
Discus to phpBB (I love phpBB 2.0 very much), and there is maybe a
script to import phpBB messages to invisionboard.

Discus to phpBB: http://abledesign.com/programs/

There is a way to import ikonboard to Invision, that's all I've found
to import messages:
IkonBoard to Invision:
http://www.invisionboard.com/documentation.cgi?subc=viewart&art=118

I haven't found any converter from phpBB to IkonBoard, but there is a
tool to convert from ikonboard to phpBB, so you should be able to
rever it easily:
http://www.phpbb.com/downloads.php

Hope this help

Hey, thank you very kindly for the links!  I think they may come in
handy for one fella who is still using Discus 3.1, and I will point
him here!

Unfortunately for me, however, I am using Discus 4.0, which uses a
completely different data structure :|

Thanks again for your thoughtful note, though :)

Hi,

I am a PHP programmer.
I can create the translation in PHP and then POST the source code
inside this message.  I will then donate the source code to
invisionboard :-)

My problem is that the MySQL functionality of discuss appears only for
the pay version of Discuss.  Should you be able to provide an SQL
schema dump, I can start work!

(2 ways of doing this I can think of)

(Easiest Way)
% mysqldump -u mysqlUserName -p databasename | grep -v "INSERT" >
sqlLayout.sql

(replacing mysqlusername & databasename for whatever is relevant).

(Not as nice way)
DESC tableName;
DESC anotherTable;

If you have phpMyadmin etc there is also an option within it.

I'm very pleased that you're willing to take a look at this and have a
go with it.  You'd definitely be the hero of many InvisionBoard people
:)

I'm including below the output you requested.  Feel free to follow up
with me via e-mail (harmonyguy at smilezone.com).

I'd be curious to know, after you check out the stuff below, exactly
how much you think'd be convertable... names, passwords, posts (with
formatting?), etc.

Thanks again!

- Adam

--------
# MySQL dump 8.16
#
# Host: localhost    Database: messageboard
#--------------------------------------------------------
# Server version	3.23.44

#
# Table structure for table '_counters'
#

CREATE TABLE _counters (
  ID int(11) NOT NULL default '0',
  value int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table '_counters'
#


#
# Table structure for table '_locks'
#

CREATE TABLE _locks (
  filename varchar(100) NOT NULL default '',
  processid varchar(20) default NULL,
  timecreate int(11) default NULL,
  PRIMARY KEY  (filename)
) TYPE=MyISAM;

#
# Dumping data for table '_locks'
#


#
# Table structure for table '_log'
#

CREATE TABLE _log (
  postnum int(11) NOT NULL default '0',
  postby text,
  posttime int(11) default NULL,
  posttopic int(11) default NULL,
  postpage int(11) default NULL,
  postip varchar(20) default NULL,
  posthost varchar(100) default NULL,
  firstfew text,
  author text,
  PRIMARY KEY  (postnum)
) TYPE=MyISAM;

#
# Dumping data for table '_log'
#


#
# Table structure for table '_passwd'
#

CREATE TABLE _passwd (
  user varchar(100) NOT NULL default '',
  pass text,
  email text,
  fullname text,
  edit int(11) default NULL,
  notify text,
  ctime int(11) default NULL,
  stime varchar(40) default NULL,
  atime varchar(40) default NULL,
  groups text,
  picture text,
  prefs text,
  favorites text,
  signature text,
  status int(11) default NULL,
  posts int(11) default NULL,
  idnum int(11) default NULL,
  personal1 text,
  personal2 text,
  personal3 text,
  personal4 text,
  personal5 text,
  personal6 text,
  personal7 text,
  personal8 text,
  personal9 text,
  personal10 text,
  personal11 text,
  personal12 text,
  personal13 text,
  personal14 text,
  personal15 text,
  personal16 text,
  personal17 text,
  personal18 text,
  personal19 text,
  personal20 text,
  custom1 text,
  customdesc1 text,
  custom2 text,
  customdesc2 text,
  custom3 text,
  customdesc3 text,
  custom4 text,
  customdesc4 text,
  custom5 text,
  customdesc5 text,
  custom6 text,
  customdesc6 text,
  custom7 text,
  customdesc7 text,
  custom8 text,
  customdesc8 text,
  custom9 text,
  customdesc9 text,
  custom10 text,
  customdesc10 text,
  PRIMARY KEY  (user)
) TYPE=MyISAM;

#
# Dumping data for table '_passwd'
#


#
# Table structure for table '_search'
#

CREATE TABLE _search (
  postnum int(11) NOT NULL default '0',
  posttopic int(11) default NULL,
  postpage int(11) default NULL,
  posttime int(11) default NULL,
  text text,
  PRIMARY KEY  (postnum)
) TYPE=MyISAM;

#
# Dumping data for table '_search'
#


#
# Table structure for table '_tree10088_1033795298'
#

CREATE TABLE _tree10088_1033795298 (
  level int(11) default NULL,
  topic int(11) default NULL,
  page int(11) default NULL,
  parent int(11) default NULL,
  name text,
  param varchar(50) default NULL,
  url text,
  posts int(11) default NULL,
  properties varchar(200) default NULL,
  lastmod int(11) default NULL,
  originator varchar(200) default NULL,
  post_list text,
  subs int(11) default NULL,
  last_poster varchar(200) default NULL,
  ID int(11) NOT NULL auto_increment,
  flagged int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table '_tree10088_1033795298'
#


#
# Table structure for table '_tree10197_1033795298'
#

CREATE TABLE _tree10197_1033795298 (
  level int(11) default NULL,
  topic int(11) default NULL,
  page int(11) default NULL,
  parent int(11) default NULL,
  name text,
  param varchar(50) default NULL,
  url text,
  posts int(11) default NULL,
  properties varchar(200) default NULL,
  lastmod int(11) default NULL,
  originator varchar(200) default NULL,
  post_list text,
  subs int(11) default NULL,
  last_poster varchar(200) default NULL,
  ID int(11) NOT NULL auto_increment,
  flagged int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table '_tree10197_1033795298'
#


#
# Table structure for table '_tree10201_1033795298'
#

CREATE TABLE _tree10201_1033795298 (
  level int(11) default NULL,
  topic int(11) default NULL,
  page int(11) default NULL,
  parent int(11) default NULL,
  name text,
  param varchar(50) default NULL,
  url text,
  posts int(11) default NULL,
  properties varchar(200) default NULL,
  lastmod int(11) default NULL,
  originator varchar(200) default NULL,
  post_list text,
  subs int(11) default NULL,
  last_poster varchar(200) default NULL,
  ID int(11) NOT NULL auto_increment,
  flagged int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table '_tree10201_1033795298'
#


#
# Table structure for table '_tree33_1033795298'
#

CREATE TABLE _tree33_1033795298 (
  level int(11) default NULL,
  topic int(11) default NULL,
  page int(11) default NULL,
  parent int(11) default NULL,
  name text,
  param varchar(50) default NULL,
  url text,
  posts int(11) default NULL,
  properties varchar(200) default NULL,
  lastmod int(11) default NULL,
  originator varchar(200) default NULL,
  post_list text,
  subs int(11) default NULL,
  last_poster varchar(200) default NULL,
  ID int(11) NOT NULL auto_increment,
  flagged int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table '_tree33_1033795298'
#


#
# Table structure for table '_tree3_1033795298'
#

CREATE TABLE _tree3_1033795298 (
  level int(11) default NULL,
  topic int(11) default NULL,
  page int(11) default NULL,
  parent int(11) default NULL,
  name text,
  param varchar(50) default NULL,
  url text,
  posts int(11) default NULL,
  properties varchar(200) default NULL,
  lastmod int(11) default NULL,
  originator varchar(200) default NULL,
  post_list text,
  subs int(11) default NULL,
  last_poster varchar(200) default NULL,
  ID int(11) NOT NULL auto_increment,
  flagged int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table '_tree3_1033795298'
#


#
# Table structure for table '_users'
#

CREATE TABLE _users (
  user varchar(100) NOT NULL default '',
  pass text,
  email text,
  fullname text,
  edit int(11) default NULL,
  notify text,
  ctime int(11) default NULL,
  stime varchar(40) default NULL,
  atime varchar(40) default NULL,
  groups text,
  picture text,
  prefs text,
  favorites text,
  signature text,
  status int(11) default NULL,
  posts int(11) default NULL,
  idnum int(11) default NULL,
  personal1 text,
  personal2 text,
  personal3 text,
  personal4 text,
  personal5 text,
  personal6 text,
  personal7 text,
  personal8 text,
  personal9 text,
  personal10 text,
  personal11 text,
  personal12 text,
  personal13 text,
  personal14 text,
  personal15 text,
  personal16 text,
  personal17 text,
  personal18 text,
  personal19 text,
  personal20 text,
  custom1 text,
  customdesc1 text,
  custom2 text,
  customdesc2 text,
  custom3 text,
  customdesc3 text,
  custom4 text,
  customdesc4 text,
  custom5 text,
  customdesc5 text,
  custom6 text,
  customdesc6 text,
  custom7 text,
  customdesc7 text,
  custom8 text,
  customdesc8 text,
  custom9 text,
  customdesc9 text,
  custom10 text,
  customdesc10 text,
  PRIMARY KEY  (user)
) TYPE=MyISAM;

#
# Dumping data for table '_users'
#