| Author |
 Topic Search  Topic Options
|
sundaytricky 
Newbie
Joined: 26 May 2003
Status: Offline
Points: 14
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: importing members from diff database !
Posted: 28 May 2003 at 6:09am |
my community site has over 2000 members and passwords i need to move across to the new forum (so i can scrap the old log-ins and use new forum) all i plan to move is usernames and passwords, so the members can edit their own new profiles etc. its access and i dont want to spend a night typing the sods in one by one ! (great support here folks) thanks in advance . . . again  ! !
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2003 at 7:42am |
|
You can run a basic import in access from all your datasources to import the username as well as the clear text password. You will need to create some random value for the User Code as well. Once your done , take the hashing script and create batches to convert the clear text password into encrypted ones. I am not sure but I think str8dog has such a script you might be able to use.
|
|
|
|
sundaytricky
Newbie
Joined: 26 May 2003
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2003 at 8:57am |
sorry michael, thats right over my head, im not good with databases!, my techie mate set it up for me. Do you think st8dog might be able to gently take me through the transition ?  when the site gets its new launch soon, i will then be able to change the paths to the new forum registration and relax !
|
|
xeerex
Senior Member
Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2003 at 12:28pm |
Dunno about str8dog anymore but I bet Maddog's site may can help. Try posting in www.maddogs-asp.com in the WWG mods forum. Remember that his site is not for WWG support but mods mainly, but those who check it may be able to help if the post is worded nicely. 
|
|
|
|
sundaytricky
Newbie
Joined: 26 May 2003
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2003 at 2:37pm |
somebody asked for $80 to do the conversion spot on for me, but i cant afford that as yet, i could probably manage around $30 - answers on a postcard . . . . . . . 
|
|
xeerex
Senior Member
Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2003 at 2:49pm |
What type of database is it? Send me an email with the type of database and exactly what you want. I'll see if I can help ya out within your budget.
|
|
|
|
SilverDragon
Newbie
Joined: 31 May 2003
Location: United States
Status: Offline
Points: 10
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 June 2003 at 8:30am |
I wrote up a small .ASP script that will get usernames and passwords from one Access Database and import them into the Web Wiz Forum complete with the password, user code, and a few defualt attributes. I used it to migrate 3100+ users into the forum when I first set it up. I will post a link on this site Monday where you can grab the code. If you cannot use it directly, maybe it will atleast give you an idea and direction to create your own....
|
|
xeerex
Senior Member
Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 June 2003 at 9:20am |
Cool script. I just did the following:
Exported the 2000+ members database to Excel
- Setup a formula to put a random string at the end of the users names
- Imported to a v6.34 database
- Used the migration tool to convert to v7.01
- Good to go
Of course, I'm a software freak anyway, but a script would have made it faster.
|
|
|
|
