importing members from diff database !
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3084
Printed Date: 01 April 2026 at 1:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: importing members from diff database !
Posted By: sundaytricky
Subject: importing members from diff database !
Date 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  ! !
|
Replies:
Posted By: michael
Date 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. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: sundaytricky
Date 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 !
|
Posted By: xeerex
Date Posted: 28 May 2003 at 12:28pm
Dunno about str8dog anymore but I bet Maddog's site may can help. Try posting in http://www.maddogs-asp.com - 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. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: sundaytricky
Date 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 . . . . . . . |
Posted By: xeerex
Date Posted: 28 May 2003 at 2:49pm
|
What type of database is it? Send me an mailto:rex@rexpage.com?subject=DatabaseHelp - email with the type of database and exactly what you want. I'll see if I can help ya out within your budget. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: SilverDragon
Date 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....
|
Posted By: xeerex
Date Posted: 01 June 2003 at 9:20am
|
Cool script. I just did the following: Exported the 2000+ members database to Excel
Of course, I'm a software freak anyway, but a script would have made it faster. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: sundaytricky
Date Posted: 02 June 2003 at 4:07pm
| all done and dusted folks, thanks to Rex from http://www.rexpage.com - www.rexpage.com cheers ! |
Posted By: SilverDragon
Date Posted: 02 June 2003 at 4:28pm
|
Ok, well here is the small .ASP script I had wipped up and used to import users from a different database.
http://danny.tamuk.edu/wwf_files/wwf_user_import.zip |
Posted By: xeerex
Date Posted: 02 June 2003 at 8:30pm
|
Script looks nice Silver. Haven't tried it yet but looks good. Thanks for posting it. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: acerbbs
Date Posted: 18 June 2003 at 4:10am
|
Does this need SQL support? ------------- http://acer.hothome.net - http://acer.hothome.net |
Posted By: SilverDragon
Date Posted: 18 June 2003 at 5:01pm
|
Common reasons for that error are: Make sure that you have specified the import database path in the variable impDBPath. Make sure that you have atleast READ permissions to the import database file and READ/WRITE permission on the directory where the file sits. Make sure that your database table fields are not using any reserved words. |
Posted By: acerbbs
Date Posted: 18 June 2003 at 7:08pm
|
Thank you SilverDragon, ------------- http://acer.hothome.net - http://acer.hothome.net |
Posted By: acerbbs
Date Posted: 19 June 2003 at 4:53am
|
SilverDragon, ------------- http://acer.hothome.net - http://acer.hothome.net |
Posted By: SilverDragon
Date Posted: 19 June 2003 at 6:44am
|
The following is information I have found for that error: http://www.adopenstatic.com/faq/80040e14.asp#scenario1 - http://www.adopenstatic.com/faq/80040e14.asp#scenario1 PLEASE EDIT THESE FIELDS TO MATCH YOUR IMPORT DATABASE ' import Database Path impDBPath = "mydirectory/importdatabase.mdb" ' import Database Table Name impDBTable = "user" <-- THE NAME OF YOUR TABLE ' import Database Username Field impDBUNField = "userid" <--- YOUR USERNAME FIELD ' import Database Password Field impDBPWField = "password" <---- YOUR PASSWORD FIELD Hope this helps... |
Posted By: acerbbs
Date Posted: 20 June 2003 at 12:29am
|
Thank you, SilverDragon: ------------- http://acer.hothome.net - http://acer.hothome.net |
Posted By: SilverDragon
Date Posted: 20 June 2003 at 6:35am
|
What is the name of the table in the database you are importing from that contains your user information? What is the name of the field that has the usernames? And what is the name of the field that has the passwords you want to use? BTW, these should all be in the same table..... |