Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Mass User Upload Tool
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Mass User Upload Tool
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
Joanie4u View Drop Down
Newbie
Newbie


Joined: 12 March 2005
Location: United States
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Joanie4u Quote  Post ReplyReply Direct Link To This Post 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!
 
 
Back to Top
HawkMultimedia View Drop Down
Newbie
Newbie


Joined: 29 May 2003
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote HawkMultimedia Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Rudster View Drop Down
Newbie
Newbie
Avatar

Joined: 15 September 2004
Location: United Kingdom
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Rudster Quote  Post ReplyReply Direct Link To This Post 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:
 
 
Ta...
 
JR
 
 
Back to Top
HawkMultimedia View Drop Down
Newbie
Newbie


Joined: 29 May 2003
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote HawkMultimedia Quote  Post ReplyReply Direct Link To This Post 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. Cry  Thanks anyway, though.
Back to Top
elfcross View Drop Down
Newbie
Newbie


Joined: 07 October 2005
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote elfcross Quote  Post ReplyReply Direct Link To This Post 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. Tongue
 
Cheers!
 
EC
Back to Top
Rudster View Drop Down
Newbie
Newbie
Avatar

Joined: 15 September 2004
Location: United Kingdom
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Rudster Quote  Post ReplyReply Direct Link To This Post Posted: 12 October 2005 at 4:12am
Hi EC
 
I have amended the code an XLS, try now.
 
 
Ta... JR
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.