just created an Ikonboard member convertor

and have tested it with my board (STGN) at www.ugforums.com
its fully working, i've just got to do some obvious stuff (like removing my database username/pass from the file hehe :D) then ill upload it,

[Glen C]

posting to get email notification when released :)

Is there a MESSAGE converter from ikonboard to vB?

[LoB]

Originally posted by Glen C
posting to get email notification when released :)

Is there a MESSAGE converter from ikonboard to vB?

you just made my day, i thought noone was interested so i didnt bother posting it :D

uploading it now as an attatchment, im making a post convertor at the moment, should be done in a few days

[Glen C]

Thanks! i'll have a test vB board up after labor day weekend and will get this tested ASAP :)

[Juan]

What version/s of Ikonboard does it convert from?

Do you need to start with an empty Vbulletin database? If not, does it import the past post count?

[LoB]

Originally posted by Juan
What version/s of Ikonboard does it convert from?

Do you need to start with an empty Vbulletin database? If not, does it import the past post count?

you can start with an existing database, however for test purposes, there is a paragraph commented out which creates it for you if you uncomment it

it imports from all versions of IB that use flat text files (well all of 2.x anyway), it converts most things including postcount, date of birth, homepage, icq number etc. and puts it in the vbulletin database
overwrites existing users with the same name in the database (well its supposed to but i havent had the opportunity to test that bit)

[Dimitri]

I'm not very interested in the user converter since most of my users are well established on my vB now, but would definitely be interested in the post converter so I can remove iB from my server completely. :cool:

[KRIDER]

but it will not work with the new files where the data is in hexcode?

i need such a converter very urgent :( :( :(

[LoB]

Originally posted by KRIDER
but it will not work with the new files where the data is in hexcode?

i need such a converter very urgent :( :( :(

ummmmmmmm to my knowlege no board exists that stores its memberfiles in hex...

[KRIDER]

its the Ikonboard 3

I don't know if its really hexcode, but it looks like
I cannot extract the plain text so I asked here if someone knows...

[justsomedude]

Just wanted to post a note of thanks LoB!!

worked like a charm :) can't wait for an update on the post conversion.

[LoB]

Originally posted by justsomedude
Just wanted to post a note of thanks LoB!!

worked like a charm :) can't wait for an update on the post conversion.

*mr burns voice* exxxcellent....

my old server is now back online so i have access to the IB posts/threads so ill be writing the convertor tonight when i get back from work, should only take a few hours hopefully

[Juan]

Thank you for this. I will be testing both scripts to see if they can merge both the posts and members.

[Juan]

Doesn't work on version 2.19.

After following all the instructions correctly and using 3 different populated vbulletin databases as well as 2 different IB forums, I get the following:

Processing 153 members ..1136: Column count doesn't match value count at row 1

and then these 153 times:

1136: Column count doesn't match value count at row 1
USERFIELD database
.1136: Column count doesn't match value count at row 1

[LoB]

Originally posted by Juan
Doesn't work on version 2.19.

After following all the instructions correctly and using 3 different populated vbulletin databases as well as 2 different IB forums, I get the following:


Processing 153 members ..1136: Column count doesn't match value count at row 1

and then these 153 times:

1136: Column count doesn't match value count at row 1
USERFIELD database
.1136: Column count doesn't match value count at row 1

that means that in your userfield table, you have more columns than has been accounted for (have you added any hacks that changes/adds to the userfield table?) to fix, just go into the script and where it writes to the DB, add the extra column information for your database

[Juan]

Here is the structure, no idea on what to do.

#
# Table structure for table 'userfield'
#

CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`field1` char(250) NOT NULL default '',
`field2` char(250) NOT NULL default '',
`field3` char(250) NOT NULL default '',
`field4` char(250) NOT NULL default '',
`importuserid` int(10) unsigned NOT NULL default '0',
`isnew` int(1) unsigned NOT NULL default '0',
`field5` char(250) NOT NULL default '',
`field6` char(250) NOT NULL default '',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

[Jet]

I tried your converter (IB 2.19b to VB 2.0.3) and found it very useful.
Just a couple of questions or 'bug notification', if any...
:p


First, I realize that you don't import all the fields (i.e. IP address or some other handwrited in the php). Is there a particular reason ?

Second, I noticed that the files in the working directory aren't correctly chosen (*.cgi), but all the files (Apache Un*x server) are listed, even '.' and '..'

O-T: is there any way to reset an auto_increment field in mySql (with phpMyAdmin) for example for a lot of members deleted ?

Thank you very much and excuse my requests.
Bye

[JimG]

I know that this topic is a bit old now but have you completed the posts convertor?
If not, how far have you got?

[vjspeedy]

i also realy need the post converter
right now i use yabb and i already have a member/post converter from YaBB to Ikonboard but i realy need to be able to convert from IB to VB since my board has got 80+ members and over 4000 posts and i do not want to lose em.

http://www.metallica-mechanix.com/metalboard/logo.gif

[Juan]

Which version of Ikonboard you have?

I can convert all your posts and members to a vbulletin database. E-mail me for information, as this involves much more than just a scipt. The method works 100%.

webmaster_listings@yahoo.com

Or you can wait for Jelsoft to release the conversion script they are working on.

[vjspeedy]

i have version 2.1.9 of ikonboard but i need to convert the members and posts to it first (installed IB today)

[LoB]

Originally posted by Juan
Which version of Ikonboard you have?

I can convert all your posts and members to a vbulletin database. E-mail me for information, as this involves much more than just a scipt. The method works 100%.

webmaster_listings@yahoo.com

Or you can wait for Jelsoft to release the conversion script they are working on.

doing something liek that isn't possible without a script, or a lot of manual work

[DarkReaper]

I just used it successfully, but there's one thing that bothers me. Everyone's last posted date is set to 1970. why?

[DarkReaper]

This doesn't work with 2.2.1...... :(

[Jawelin]

The only differences are the encrypted pw (md5 hash) and a field added to the end of the row in table USER.
You should apply later the step3 of upgradeXX.php (XX >
12)

But in the converter there are a lot of other fields not copied from IB to VB.... :(

Bye

[Tech_Koss]

what exactly is the "iKonBoard member cgi files" ??

[Jawelin]

Do you have ikonboard to "upgrade" from ? ;)

Otherwise you wouldn't need this hack/importer !
:stupid:
If you had, you absolutely should know the users are individually stored in .cgi files in members directory.
One file per user... <grin>

[Tech_Koss]

Yes I have (had) ikonboard & im trying to convert my members into my vbulletin forum.

Are you talking about the member folders in the "database" folder? ...because there is no cgi file in those directories; there is 2 *.ibx & a *.cb file in there.

[Jawelin]

I think the converter talks about Ikonboard v2.19, NOT v3.0.
In the first one there's no DB, but only .cgi files...

Thanks

[Tech_Koss]

Originally posted by Jawelin
I think the converter talks about Ikonboard v2.19, NOT v3.0.
In the first one there's no DB, but only .cgi files...

Thanks
ohh man :cry: ....stupid ikonboard!

[merit5]

Do these convertors (this and the post/thread convertor) .. convert to/from MySQL databases? .. i'm subscribing to this because I very much need some help .. for a VERY LARGE msg board that bought the software.. i'm trying to help them.

thanks in advance.

[merit5]

like the subject.. can anyone help me on this please.. bought the license.. but need this to work with MySQL in order for me to take advantage of my purchase...

any info would be great .. or at least if someone can point me in the right direction.

thanks

[merit5]

gotta keep bumping for hope!@

[eGoR]

thats amazing...Iam trying right now :0
great... installed

/me loves u, m8