PDA

View Full Version : importing users from MAILGATE


pussySniper
Thu 29th Apr '04, 5:41am
my site currently uses MAILGATE which is more like a newsgroup than a Forum. So I just bought vB3 have got it installed and running now i'm trying to figure out how to import the existing user to the new system. :eek:
Any hints/tips will be so much help!
Steve Machol
Thu 29th Apr '04, 2:53pm
This requires writing a custom import script. I suggest asking at vbulletin.org for help with this.
Jerry
Fri 30th Apr '04, 6:57am
Can you export the data in any way ?
pussySniper
Fri 30th Apr '04, 7:35am
the only way to export data is directly from the database.
besides the fact that my SQL is very rusty, there is also the problem that most of the data is in the mailgate forum, but things such as the user_id is in a completely different database which uses Oracle, and the others use mySQL...
Jerry
Fri 30th Apr '04, 7:45am
SQL is still better than spidering web pages.

If the data could be exported some how then loaded into another database where it could be used by the importer, it is possiable.

Getting it there is going to be the trick I'd say :)
pussySniper
Fri 30th Apr '04, 7:48am
the "importer" is that a downloadable script i can find somewhere in here? it would definately be a place to start!

so you think having a temporary middle database

mailgate_DB -> temp_DB -> vBulletin_DB??? somethin like that?
Jerry
Fri 30th Apr '04, 11:18am
the "importer" is that a downloadable script i can find somewhere in here? it would definately be a place to start!

Yes it is a bunch of scripts that make up a system called impex which can be download in the members area :

http://www.vbulletin.com/members/


so you think having a temporary middle database

mailgate_DB -> temp_DB -> vBulletin_DB??? somethin like that?

That is currently the only and advised way of doing it as the importer expects and needs a eve database to connect to, to import from.
pussySniper
Mon 3rd May '04, 6:49am
sorry didn't understand the last bit...

"... importer expects and needs a eve database to connect to, to import from."

needs a "eve" dB, don't know what that is.
Jerry
Tue 4th May '04, 7:07am
Sorry, that last paragraph shouldn't be there. Eve is another system completely.

Though you will need to get the SQL + data from the existing system into a database.

From there we could have a look at the database and see how similar / different to vB3 it is.