Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Import Tool Times out/Should I manually Import?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Import Tool Times out/Should I manually Import?

 Post Reply Post Reply
Author
Romnus View Drop Down
Groupie
Groupie


Joined: 16 September 2009
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote Romnus Quote  Post ReplyReply Direct Link To This Post Topic: Import Tool Times out/Should I manually Import?
    Posted: 10 July 2013 at 12:15am
I have a table with 300,000 members and I wish to check to make sure all are in the webwiz forum table, since I did a modification to my website and I accidentally change a specific code to create forum users. 

Anyhow, when the count reaches 1731 it stops. I am thinking this might be due to the large database. How do I go about doing either of the following to resolve this issue:

1. Increase the timeout of the connection
2. Change the sql string
3. Will importing users 'manually' via my code be the best option if the above two does not work?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 10 July 2013 at 12:39pm
The tool was never designed to import this many members and importing manually would not work due to the encryption of passwords.

Have you considered instead using your present membership system inconjucktion with web wiz forums?

Have a look at the following pages on the Existing Member API and the HTTP XML API:-

Back to Top
Romnus View Drop Down
Groupie
Groupie


Joined: 16 September 2009
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote Romnus Quote  Post ReplyReply Direct Link To This Post Posted: 10 July 2013 at 2:27pm
I estimate that about 2,500 members of the 300,000 were not entered. I will just have to either input them by hand (very unlikely) or just not input them, until the individual comes to me complaining they cannot post of the forum. I don't think the Existing Membership API will work since it must be done in ASP.

What I used was the XML HTTP API, during signup. So when a user signed up, their information is inputted into the webwiz forum database. However, I made a mistake in my code and thus 2,500 members was not entered into the forum database over a month and a half time-span.

When I stated manually, I am saying via code, So I will do an SQL query to see what uses are NOT in the webwiz database then loop and input them via the XML HTTP API with all the same default password. I think this will do the trick, but wanted to make sure. Thanks. 
Back to Top
 Post Reply Post Reply

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.