Web Wiz Forums - Mass User Upload Tool

Print Page | Close Window

Mass User Upload Tool

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=11848
Printed Date: 12 April 2026 at 6:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Mass User Upload Tool

Posted By: Rudster
Subject: Mass User Upload Tool
Date Posted: 17 September 2004 at 11:51am

Hi All,

I have created a couple of quick and dirty pages for upload users into WWF using Excel.

http://www.sportsregister.co.uk/misc/Rudster_Members_Uploader.zip - http://www.sportsregister.co.uk/misc/Rudster_Members_Uploade r.zip

Enjoy!!

Replies:

Posted By: steve
Date Posted: 17 September 2004 at 2:52pm

how exactly does it work? Isn't excel 'single user only?' Meaning that it won't handle more than 1 simultaneous user.

Posted By: michael
Date Posted: 17 September 2004 at 5:33pm

His readme is fairly detailed, it's not supposed a hit me app, it's a one time process to import users.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: steve
Date Posted: 17 September 2004 at 5:43pm

So, the function of this is to allow you to use a spreadsheet to mass add users to your database?

Posted By: Rudster
Date Posted: 19 September 2004 at 3:44pm

Yeah, one-off upload tool nothing fancy!

Posted By: confused2xover
Date Posted: 28 November 2004 at 12:42am

I tried this import and got an error..............

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: ""]'

/Supplier/Forum/admin/upload_members.asp, line 188

Any ideas?

Posted By: FuNkDoBiE
Date Posted: 07 December 2004 at 10:03am

error '80020009'

Exception occurred.

/members/forum/admin/upload_members.asp, line 157

Posted By: Rudster
Date Posted: 03 February 2005 at 9:32am

maybe different version or using them from within a portal?!

-------------
http://www.sportsregister.co.uk">

Posted By: Joanie4u
Date Posted: 12 March 2005 at 9:54pm

Rudster,

Looks like I arrived a little to late your link no longer works... Cry

I am looking for a way to import 1800 users. If you get this post please send another link to the Excel spreadsheet you created...

Thanks In Advance!

Posted By: HawkMultimedia
Date Posted: 14 September 2005 at 1:12pm

Does anyone have an archived copy of this tool? I need to import some users, and the getSalt, Hashencode, etc. is way over my head. I'd appreciate any help.

Thanks

Posted By: Rudster
Date Posted: 17 September 2005 at 12:28pm

Hi Hawk

This is all I have left of the uploader now, not sure of the version etc etc.

From what I remember it was designed to work with the webWiz from inside the EZA portal, so the paths may need to be amended.

However, it's pretty straight forward:

http://www.sportsregister.co.uk/Rudster_Members_Uploader.zip - http://www.sportsregister.co.uk/Rudster_Members_Uploader.zip

Ta...

-------------
http://www.sportsregister.co.uk">

Posted By: HawkMultimedia
Date Posted: 19 September 2005 at 1:06pm

Thanks, Rudster. Unfortunately, I'm not having much luck. It keeps giving me subscript errors on various lines.

Thanks anyway, though.

Posted By: elfcross
Date Posted: 11 October 2005 at 8:40pm

Hi Rudster!

Nice job on the uploading script, except I only get this small error:

********************

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Attach_signature', table 'forum.dbo.tblAuthor'; column does not allow nulls. INSERT fails.

/forum/admin/upload_members.asp, line 372

********************

And I believe it's because you don't have the "Attach_signature" field in the excel to be filled with a boolean variable. Consequently you also don't allow for this value to be considered in your script... see what I mean?

Please help me overcome this for I would very much like to upload 4000 members to the forum.

Cheers!

Posted By: Rudster
Date Posted: 12 October 2005 at 4:12am

Hi EC

I have amended the code an XLS, try now.

http://www.sportsregister.co.uk/Rudster_Members_Uploader.zip - http://www.sportsregister.co.uk/Rudster_Members_Uploader.zip

Ta... JR

-------------
http://www.sportsregister.co.uk">