<% @ Language=VBScript %> <% Option Explicit %> <% '**************************************************************************************** '** Copyright Notice '** '** Web Wiz Forums(TM) '** http://www.webwizforums.com '** '** Copyright (C)2001-2014 Web Wiz Ltd. All Rights Reserved. '** '** THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS UNDER LICENSE FROM WEB WIZ LTD. '** '** IF YOU DO NOT AGREE TO THE LICENSE AGREEMENT THEN WEB WIZ LTD. IS UNWILLING TO LICENSE '** THE SOFTWARE TO YOU, AND YOU SHOULD DESTROY ALL COPIES YOU HOLD OF 'WEB WIZ' SOFTWARE '** AND DERIVATIVE WORKS IMMEDIATELY. '** '** If you have not received a copy of the license with this work then a copy of the latest '** license contract can be found at:- '** '** http://www.webwiz.co.uk/license '** '** For more information about this software and for licensing information please contact '** 'Web Wiz' at the address and website below:- '** '** Web Wiz Ltd, Unit B10, 9 Nimrod Way, East Dorset Trade Park, Ferndown, Dorset, BH21 7UH, England '** http://www.webwiz.co.uk '** '** Removal or modification of this copyright notice will violate the license contract. '** '**************************************************************************************** '*************************** SOFTWARE AND CODE MODIFICATIONS **************************** '** '** MODIFICATION OF THE FREE EDITIONS OF THIS SOFTWARE IS A VIOLATION OF THE LICENSE '** AGREEMENT AND IS STRICTLY PROHIBITED '** '** If you wish to modify any part of this software a license must be purchased '** '**************************************************************************************** 'Set the response buffer to true as we maybe redirecting Response.Buffer = True %> Import Subscribers from External Database <% '***** START WARNING - REMOVAL OR MODIFICATION OF THIS CODE WILL VIOLATE THE LICENSE AGREEMENT ****** Response.Write("") '***** END WARNING - REMOVAL OR MODIFICATION OF THIS CODE WILL VIOLATE THE LICENSE AGREEMENT ****** %>

Import Members from External Database

Return to the the Admin Control Panel Menu

<% 'If member API enabled then display a message to the user If blnMemberAPI Then Response.Write(" This option is not available if the Member API is enabled.

After logging in through your own login system, members will be added to the forum using the Member API when they enter the forum.") Else Response.Write(" This tool allows you to import members into Web Wiz Forums from an external database.") End If %>


<% 'If member API enabled do not show the form If blnMemberAPI = False Then %>
Database Details
Database Type:  
Name of Database:
This is the Name of your database or database file name if connecting to an Access database.
/>
Database Path (Access Only):
This is the path to your database. Must be located on the same server or network mapped drive. 
/>
/> Physical Server Path to Database (not URL)
/> Path from this application to database
Database Server Name or IP (SQL Server, mySQL only):
This is the name or IP address to your MS SQL Server
/>

Database Username:
This is the Username you use to login to your database.

/>
Database Password:
This is the Password you use to login to your database.
/>
Database Table and Field Details
Name of Table (required):  
This is the name of the table in your database where the details of the members you wish to import into your Forum are stored.
/>
Username Source Field (required):
This is the name of the field in your database that stores the Usernames of the members you wish to import.
/>
Password Source Field:
This is the name of the field in your database that stores the Passwords of your members you are importing. If you don't specify a field for Passwords, a password will be created for your member.
/>
Email Address Source Field:
This is the name of the field in your database that stores the Email Addresses you wish to import.
/>
Real Name
This is an optional Real Name import and is the name of the field in your database holding the persons real name.
/>
Real Name (Last Name)
If you are using the Real Name import above this is used if the Real Name of the person is stored in two fields, for example when you have a First Name and Last Name fields.
/>
Location />
Signature />
No of Posts />
Forum Group
<% 'Initalise the strSQL variable with an SQL statement to query the database strSQL = "SELECT " & strDbTable & "Group.* FROM " & strDbTable & "Group ORDER BY " & strDbTable & "Group.Group_ID ASC;" 'Query the database rsCommon.Open strSQL, adoCon 'Loop through cats Do While NOT rsCommon.EOF Response.Write(vbCrLf & " " & _ vbCrLf & " " & _ vbCrLf & " " & _ vbCrLf & " ") 'Move to next record in rs rsCommon.MoveNext Loop 'Close RS rsCommon.close %>
Please select which Web Wiz Forums Memebr Group you would like the Imported Members placed in.
" & rsCommon("Name") & "

<% End If 'Close DB Call closeDatabase() %>