The Arcive of Official vBulletin Modifications Site.

jluerken · #1 03-02-2004, 08:20 PM

This Hack is released under an EverythingvB.com FullAttribution-NonCommercial-NoDerivs-NoTranslation License

UBBT 6.2.x to vb3 Importer

Tested with vB-Version:
import UBBT 6.2.3 to RC2: worked
import UBBT 6.2.3 to RC3: worked
import UBBT 6.2.3 to RC4: worked
import UBBT 6.2.3 to vb3 gold: worked
import UBBT 6.3 to RC4: not tested so far
import UBBT 6.4 to RC4: not tested so far

Install-difficulty: nothing to install
File-edits: no edits needed, this script is using a wizard
Template-edits: 0
Price: not decided yet but it will definetly not be for free
Support: If you have another version of UBBT or if you want to have
modifications how or what the script is importing one of my collegues
and main author of this script can assist you. Price for changes is up
to him then and based on how difficult it is to implement the wished changes.

Official UBBT 6.2.3 to vb3 Importer Script page:
www.clanforums.com
(I will update the board you can see there this month to RC4 and then you will also get the Script there!)

Brief Description of the Script:
I tried to import my UBBT 6.2.3 to vb3 which is very difficult and a lot of work if you try to do this manually. I did not want to wait for an official importer and made an own one.
The script imports most data (see below) from UBBT 6.2.3 to vb3.
It does not matter if you have installed both boards in the same database until they're on the same server the script can handle it.

For the test I had to import many many times so I wrote a small cleanup File which kills all data from vb3 so that you can try as often as you want.

I got more then 50000 posts and 1000 users imported without any problems.

Information on the UBBT 6.2.3 to vb3 importer
The script can do many many things for you but not everything. UBBT is very different and has much less functionality than vb3.

Example: A User within UBBT has all settings in one table and there are not so much field in it. vb3 knows much more fields and importing an UBBT user then will mean to have empty fields. To solve this problem I created a new user in vb3, checked which settings he got and put this into the import script so that you get fully working vb3 users :-)

1. WebWizard interface for import: works

2. import all users: works

- including signature and profile field
- excluding Displayname (there is not field or function for this within vb3)
- added function to check if the user has a group cause in UBBT you can also
have users without a group. If this is the case these user will get the
vb3 'Registered Users' Group as primary group

3. import of groups: works

- UBBT Administrators to vb3 Administrators
- UBBT Moderators to vb3 Moderators (not Supermoderators)
- UBBT Users to vb3 Registered Users
- UBBT Guests to Unregistered / Not Logged In

- imports all UBBT additional groups as vb3 Custom Groups

4. import of forums and categories : works

UBBT 6.2 and 6.3 does not know sub forums (don't know if 6.4 has it)
so therefore it was easy to import cats and forums (level1) including
description

5. import of threads and posts: works

Importing all threads to the right categories and all posts to the right
threads in the correct order.

6. set correct userrights: works

UBBT only knows groups rights. If a user is in a special group he has
or he has not the rights.

Within this part I added the imported users to the custom usergroups.

7. set moderators of boards: works

Mods of a board within UBBT are now also Mod of the same board within
vb3.

8. change UBBTCode to vbCode inside of posts: works

Changed all UBBTCode within posts and signatures to vb3 code.
HTML Code is ignored. Tweaked this function and I found no post
where this not worked. If a user made a failure or inserted wrong
code in UBBT it is also imported wrong of course

9. import private messages: works

10. import smilies: works:
All UBBT graemlins will be copied to the vb3 location
and added to the database including a sort order check

Added an option to skip this step cause the smilies are copied physically
to the new board. If safedir restrictions are active or your don't want to
store smilies in the filesystem you can now step this.

11. import smilies: works:
A Custom User Profile field (field5) is created and all UBBT Displaynames are imported into it. Users can change it but its hidden on the profile field.
This field can then be used to change the vb3 Templates in the way that the field5 is shown instead of the loginname beside the posts.
Its up to you if you want to use this or not

12. import attachments: works:
All UBBT files attached to a post will be copied to the vb3 location
and added the info is added to the right posts in the database.

Added an option to skip this step cause the attachments are copied physically to the new board. If safedir restrictions are active or your don't want to store attachments in the filesystem you can now step this.

13. import attachments: works:
UBBT Avatars are imported and saved to the local /customavatars vb3 folder.

14. change UBBPolls within posts to vb3 polls: works
Changed all UBBT polls within the vb3 posts to vb3 posts.
This was a real pain in....(you know :-))

TO DO:
Migrating my own board now from UBBT 6.2.3 to vb3 gold to find out
if there are problems. If not I will release a link to the script.

Status: 99%

Writing this script was really hard cause you have to take a deep look in both forums to find out how the authors handled some things.
Because I want to convert my board until end of the month I think that if nothing special happens also the import script is working :surprised:

I will post the full feature list to the IMPORTER SECTION for vb3 FULL RELEASES when its completly done.

If this is the wrong forum for this post it would be nice if a mod can move it to the right place

jluerken · #2 03-02-2004, 08:23 PM

To see that is working I posted some screens of my new vb3 board within my actual UBBT board for my users.

You can also see there that everything is imported.

btw. the STYLES of UBBT are NOT imported :-)

Here the link to the thread with the screens:
http://www.clanforums.com/ubbthreads...b=5&o=&fpart=1

Lets see if I can win a style contest with them when the new board goes online :nervous:

UDPATE | TO DO:
different small things: to be investigated

Status: 99%

Zachery · #3 03-02-2004, 08:33 PM

Quote:

Originally Posted by jluerken

To see that is working I posted some screens of my new vb3 board within my actual UBBT board for my users.

You can also see there that everything is imported.

btw. the STYLES of UBBT are NOT imported :-)

Here the link to the thread with the screens:
http://www.clanforums.com/ubbthreads...b=5&o=&fpart=1

Lets see if I can win a style contest with them when the new board goes online :nervous:

Might just wanna wait till they finish and release vB3 as gold... just a thought...

jluerken · #4 03-02-2004, 08:42 PM

Quote:

Originally Posted by Zachery

Might just wanna wait till they finish and release vB3 as gold... just a thought...

I don't think that they will change much to the tables where I import data to anymore

I wrote this for RC2 and it works also for 3 and 4 so I think that it will also work for the gold without the need to make changes. We will see :squareeyed:

Zachery · #5 03-02-2004, 08:43 PM

Quote:

Originally Posted by jluerken

I don't think that they will change much to the tables where I import data to anymore

I wrote this for RC2 and it works also for 3 and 4 so I think that it will also work for the gold without the need to make changes. We will see :squareeyed:

I was stating that there will probally be offical importers for more scripts once vB3 goes gold

jluerken · #6 03-02-2004, 08:45 PM

Sure there will but at the moment there are no importers for UBBT 6 available for vb3

Jerry · #7 03-10-2004, 07:26 PM

Quote:

Originally Posted by Zachery

I was stating that there will probally be offical importers for more scripts once vB3 goes gold

There is and it will be.

6.2 -> 6.5 and testing on 6.7 soon, cleaning up the style importer and the module redo and error checking atm.

http://www.vbulletin.com/forum/showthread.php?t=97131

AWS · #8 03-11-2004, 03:04 PM

Quote:

Originally Posted by Jerry

There is and it will be.

6.2 -> 6.5 and testing on 6.7 soon, cleaning up the style importer and the module redo and error checking atm.

http://www.vbulletin.com/forum/showthread.php?t=97131

Jerry, this is a UBB.Threads importer. The one you reference in that thread is for UBB classic.
Wish I would have seen this thread before I imported my UBB.T forum. I could have went directly to vb3.

Jerry · #9 03-11-2004, 03:35 PM

Quote:

Originally Posted by AWS

Jerry, this is a UBB.Threads importer. The one you reference in that thread is for UBB classic.
Wish I would have seen this thread before I imported my UBB.T forum. I could have went directly to vb3.

Doh ! My mistake

Though I'll be doing a Ubb.T's one as well, its just not as high on the list at the moment.

jluerken · #10 03-19-2004, 09:04 AM

I think if Jelsoft releases the Gold version this weekend I can also do the final tests with the import script for it. I am nearly ready.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04239 seconds Memory Usage 2,276KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!