Web Wiz Forums - Import Tool Times out/Should I manually Import?

Print Page | Close Window

Import Tool Times out/Should I manually Import?

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=30794
Printed Date: 30 March 2026 at 12:10pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Import Tool Times out/Should I manually Import?

Posted By: Romnus
Subject: Import Tool Times out/Should I manually Import?
Date 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?

Replies:

Posted By: WebWiz-Bruce
Date 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:-

http://www.webwiz.net/web-wiz-forums/kb/existing-members-api.htm" rel="nofollow - http://www.webwiz.net/web-wiz-forums/kb/existing-members-api.htm

http://www.webwiz.net/web-wiz-forums/kb/xml-http-api.htm" rel="nofollow - http://www.webwiz.net/web-wiz-forums/kb/xml-http-api.htm

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Romnus
Date 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.