UltraBoard 2.2.x importer released!

Please do not contact me via ICQ, Email, PM or anything other way than this thread any more!

Okay... this is my UB2k 2.2.x to vBulletin 2.0.x importer. It can import styles (= skins), users, forums, moderators, posts and private messages.

This Importer has been created for vBulletin 2.0.3! The most things work correctly with 2.2.x (it will import the styles, users, forums, moderators, posts and private messages) but some features like setting new passwords for admins doesn't work. I don't want to create a new version as I don't think there are many UB2k users left who could import...

This script does not work with the vB import system as I wanted to have it independent of the vB directory (some servers are not able to read files in directories like ../../ub2k/). You can upload the script to any directory where you can access the UB2k directory and the vBulletin database.

A manual is in the zip file. Please do not email or pm me if you have questions or found bugs. Please simply answer the thread.

Known bugs:
- On some servers you need to chmod the directory "ubimporter" to 777...

[cipap]

does it work with 2.2.0? anyone tried.. because i'm thinking of migrating a whole bunch (around 30, 000 users) off from a flat file ub2k to mysql vbulletin..

any ideas? *** 2.0.x does not have user password encryption unlike 2.2.x

[GameCrash]

It works for vB 2.2.x except this one password problem... but it will not work with any other UltraBoard than 2.2.x because they have changed their backup format...

[flyguy]

Yes, in fact there were 11,000+ posts from the original board

http://www.flyfishingforum.com/cgi-b...eadlines&BID=2

I increased the # of posts per cycle to a high value, I will try them lower at your recommendation. Thanks, I will try it now...

[flyguy]

GameCrash -

I tried the whole thing again and here's what I found:

#1 => the "\" character shows up at the end of every line of text in every post. Is there a trick to clearing that?


#2 => One of the boards, entitled:
Flytalk III > Saltwater Flyfishing > Stripers and Coastal Gamefish

at URL:
http://www.flyfishingforum.com/flyta....php?forumid=3

(Before I update counters and all that) lists 9579 posts and 1646 threads. On the original board, it lists: 11223 posts over 1645 (plus the one I made to test it = 1646). It somehow lost (11223-9579 posts) in the import counter.

#3 => I think the posts were never imported...
Even though the board lists 9579 in the vBulletin, none of them are accessible even when posts are displayed since the beginning of time. It seems only the post count made it over?

The ubimporter.php script never asked me to import these posts for some reason, because I set the import cycles down very low and if I had to click for 11,223/n cycles I would remember ;-)

#4 => When I update counters it goes to zero.

Any suggestions?

Thanks in advance.

[flyguy]

cipap -


RE: going to 2.2.0 -

The password enryption differences between UB2K and 2.2.0 cause a problem using ubimporter.php - but there is an easy fix if you have administrator rights to the mysql database on the vBulletin side.

Feel free to email me for specific information.

juro@flyfishingforum.com

[flyguy]

Gamecrash -

More information on the problems:

Failure to build an .export file:

I went back to my back-up log and found that one of the files terminated in an error... it says:

- - - Exporting the 'B2' database... Error:
- - - Copying the config file of 'B2' database... Done.

B2 is the one failing. The other backup directories have successfully built an B*.export file, B2 does not have one - but it has a .cfg file which is probably where the counter is coming from. The backup probably aborts at ~9k and the .export file never gets built.

The problem appears to be that the UB2k backup can not handle the huge board... and of course there is no one to ask at UB2K!

Removal of "\" characters:

Looking at that .export file, I see that each newline is contained as the characters "\n" on the Unix server. Is there an easy way to modify the importer to create 'native' newlines in vBulletin?

Another alternative would be for me to do a large-scale substitution on the .export file before running ubimporter, but I would need to know from you what you expect to see for newlines.

Loss of members and passwords:

The number of members has been reduced for some reason. This is not a big deal although people who had higher member status will not be happy starting over. This is the least important because it will be easy for people to re-register. I think the passwords are not working because of the encryption difference UB2K vs. 2.2.0.


Thanks for your help so far. I think if I can get rid of the slashes and figure out how to get an export file to build in B2 database, I should be able to make the move to vBulletin.


Juro
http://flyfishingforum.com

[flyguy]

GC -

I am taking the tactical approach of splitting the posts into two boards before trying again. I hope this solves the board error.

Will report later,
Juro

[flyguy]

--- back from the depths...

I manually split the posts into a several new boards and was able to build the files that ubimporter needs for each board to import! >phew<

Now the problem I face the problem of "\" delimiters at the end of each line and before each item of punctuation.

Any suggestions? It appears that the conversion is placing this char, which might have been necessary for pre 2.2.0 versions (?) 2.2.0 apparently does not need punctuation escaped.

Beyond that, a method of converting the UBCodes to vBCodes is needed to activate the links, show images, etc... but that's down the road.

Thanks again, getting VERY close!

[GameCrash]

I'm sorry, I my computer at home is down so I was not able to answer you earlier and I have not much time atm (at school)

Well... the \n is the standard unix newline. It should not be shown in the text... do you use a windows server?

[flyguy]

Hi GC -

No, it's a unix server... the slash appears where there were newlines -and- before quote characters, both ' (single) and " (double).

I looked at the .export file over on UltraBoard and although there are "\n" chars at the end of every line the single quote chars are not escaped so I am assuming the slash is added somewhere along the way(?)

You can look at the results at:

http://flyfishingforum.com/flytalk2