ImpEx - importing users/email

[Pasqualis]

I want to import my old 6.5 ubb.t forum to vb3.08 by using the ImpEx system. I've attached some screenshots and I have some question:

Module 001 - Check and update database: please see attached document for my results. I guess the results are ok, so I continue with the next step.

Module 002 - Associate Users: now what do I have to do here? Please see attachment user_import1.gif. I'm importing from my old ubb database into a new & empty vb database. The only user that excists on on the vb database is me, Pasqual. This username is also the superadmin of my ubb board. What do I have to do with all other usernames?

Module 004 - Import User: which email do I select? Please see attachment user_import3.gif. My old board used 2 emails: a registration email (hidden) and a puplic email. What do I choose here ?

Module 011 - Import Attachments: where will my attachements be copied to after doing the import?

After the import: how do I update all the internal links that point from one post to another post?

This is all very new to me, so excuse me for asking these maybe silly questions :) Thanks in advance!

Pasqual

[Jerry]

I've attached some screenshots and I have some question:

Can't see any, can you try adding them again ?


Module 001 - Check and update database: please see attached document for my results. I guess the results are ok, so I continue with the next step.

As long as there were lots of table names in green.


Module 002 - Associate Users: now what do I have to do here?

For a clean/new import ignore this and DO NOT link up and userid's.


Module 004 - Import User: which email do I select? Please see attachment user_import3.gif. My old board used 2 emails: a registration email (hidden) and a puplic email. What do I choose here ?

I would say the registration as it has to exsist as some times there isn't a public email, I put the option in because there are two.


Module 011 - Import Attachments: where will my attachements be copied to after doing the import?

By default to the database, unless you set up the attachment details to use a path.


After the import: how do I update all the internal links that point from one post to another post?

Answered that here : http://www.vbulletin.com/forum/showthread.php?t=149796

[Pasqualis]

Sorry... forgot the attachments :)
here they are

[Pasqualis]

Ok, I pretty much managed to import my old board :)

Still a few questions:
1. All my old smiley's turned into an URL's like:

Since this URL is similar for each smiley, could I do some search & replace in the database to make this work?

2. All quotes looke like this:

</font><blockquote><font class="small">Citaat:username</font><hr />

QUOTED TEXT HERE

[/ QUOTE ]

How do I deal with that ?

3. Usergroups and Forum permissions have not been imported with ImpEx. Is that normal behaviour?

4. After the import most usernames look ok, but some look like "imported_username”

5. Where do I change the display options as shown in my attachment? (I want to list ALL posts, not just from the pas 30 days).


That's it for now ;)

Thank,

Pasqual

[Pasqualis]

Attachment ;)

[Jerry]

1. All my old smiley's turned into an URL's like: ...... could I do some search & replace in the database to make this work?

2. All quotes looke like this:

</font><blockquote><font class="small">Citaat:username</font><hr />

QUOTED TEXT HERE

[/ QUOTE ]

How do I deal with that ?

Check out impex/tools/cleaner.php



3. Usergroups and Forum permissions have not been imported with ImpEx. Is that normal behaviour?

Yes, you have to set them up again.



4. After the import most usernames look ok, but some look like "imported_username”

Then there were duplicate usernames that impex found so it added the imported_ on the front of the name so you knew which was which.



5. Where do I change the display options as shown in my attachment? (I want to list ALL posts, not just from the pas 30 days).


AdminCP -> Forum Manager -> Default View Age (Default date cut-off for thread display)

[Pasqualis]

Jerry, you're amazingly fast! Thank you so much for helping me out here :D

[Pasqualis]

Then there were duplicate usernames that impex found so it added the imported_ on the front of the name so you knew which was which.

Yes, that's because I run the ImpEx script a few times. I Won't make that mistake again ;)

Some more questions:

1. the imported avatars now all have different dimensions. Is there a place where I can regenerate all avatars so they are 80x80 ?

2.

AdminCP -> Forum Manager -> Default View Age (Default date cut-off for thread display)

Can I set the Default View Age to "Show all threads" for all forums by using some SQL Query ?

3. When I look at my usergroups, I see all Users under "Custom Usergroups" ? How can I change them to Registered Users under "Default Usergroups" ?

4. At my previous board we used icons below the avatars to show that some people are part of a special group. I'm sure It's possible with VB too, but where can I find it? Or is it a modification?

BTW, would it be better asking these random questions through a ticket? ;)

Thanks a lot.

[Steve Machol]

1. There is no funcction to do this.

2. To update them all at once, run this query (assuming no table prefix is being used):

UPDATE forum SET daysprune=-1;

After running that query, update the forum counters:

Admin CP -> Import & Maintenance -> Update Counters -> Rebuild Forum Information

3. Please read the Importing HOWTO thread:

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

Take special note of The End Game section. Following these steps should solve those issues.

4. You can use User Ranks for this:

http://www.vbulletin.com/docs/html/m...er_ranks_intro

[Pasqualis]

Thanks Steve, I didn't notice the HOWTO topic ;)

Well, the import went quite smoothly, but ofcourse I still have some little issues.
Most important one: PM's

When I look at the pmtext table, it's nicely filled with all PM's, but when I look at my inbox, it's entirely empty. Do I have to run some rebuild query or how do I fix this?