UBBT 6.x to vb3 import script beta

[jluerken]

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