Tutorial: Creating a Members Only Website using V1 apps
Creating a "Members Only" Website Using DMXReady Secure Login Manager, Mailing List Manager, and Registration Manager
(*Note: This tutorial pre-dates DMXReady Members Area Manager, which creates essentially the same environment. You may find it easier to purchase this app instead. Find out more about Member Area Manager here.)
DMXReady apps are strongest when used together. This is especially true when combining three of our most powerful apps: Secure Login Manager, Mailing List Manager, and Registration Manager. If you purchased all three applications together, or if you are integrating all three into a new website for the first time, you can easily integrate the member information by simply changing the pointers from the Secure Login Manager and Mailing List Manager databases to the Registration Manager database. In that case, skip directly to the integration section.
If you have one or more apps already running on your website, both with member information, then you must manually integrate the databases using one of two methods: using Microsoft Access 2000 and Excel to transfer data (preferred), or if you do not have Access or Excel you can take the member information from the Secure Login Manager and Mailing List Manager admin pages and add them to the Registration Manager through its admin page. If you choose this method, you can skip the next section and go directly to Integrating Secure Login Manager and Mailing List Manager with Registration Manager.
Using Microsoft Access 2000 and Excel to Transfer Member Data
By far, the most intricate member database is in Registration Manager, so this is the best one to use. However its complexity and extra fields means that it is not as easy as simply copying the members tables together. But by using Microsoft Access 2000 and Microsoft Excel, you can take the data from your Secure Login Manager and Mailing List Manager members tables and add them into the Registration Manager database.
This method is fairly easy, although there are a number of steps needed in order to complete the setup properly.
- First, save backup copies of the Secure Login Manager, Mailing List Manager, and the Registration Manager to somewhere else on your hard drive to keep your original data safe.
- Highlight the file tblMM_Members and click File-> Export
- Rename as RMembers, click on the "Save Formatted" checkbox, and save as an Excel file (your current version).
- Repeat steps 2-4 with the Secure Login Manager and Mailing List Manager databases, renaming the files SLMembers and MLMembers.
- Open RMembers, SLMembers, and MLMembers in Excel.
- Cut and paste all active columns from SLMembers and MLMembers to the corresponding columns in RMembers. You may do this one column at a time, switching between workbooks with each cut and paste, or you can cut and paste all columns and rows to RMembers and rearrange from the one workbook. There is no right or wrong way, as long as names, usernames, passwords etc. are all together in their respective columns.
- In the "CategoryID" column (probably column C), make sure that all entries have the number "19", as the RMembers data already has. (This is easier if you type it once at the top entry, then drag down to the bottom of the entries).
- You may also want to enter new numbers for your MemberID to avoid duplication between applications. Simply delete info from all cells in this column, enter a number in the top three rows of the column (e.g. 1,2,3), and drag it down to the bottom row.
- Save the file as NewTable in Excel format within your local website folder called "databases" (i.e. C:\MyDocuments\YourWebsite\Public\databases).
- In Microsoft Access, open the Registration Manager database and go to File-> Get External Data -> Import
- Change the File Type to Excel, and select the NewTable file.
- This will bring up the Import Spreadsheet Wizard. On the first page, click the "First Row Contains Column Headings" check box and click the Next button.
- Select "In a New Table" and click the Next button.
- Do not edit any of the fields on this page, simply click the Next button.
- Select "No Primary Key" and click on the Next button.
- In the "Import to Table" text box, type "NewTable" and click on the Finish button.
- In Microsoft Access, double-click "NewTable". Ensure that all the information transferred and is listed correctly.
- Once you are satisfied that everything is in order, delete the current "tblMM_Members" file and rename "NewTable" to "tblMM_Members". Double check spelling.
- Open another instance of Access, and open the MailingListManager database.
- Click and Drag the following tables to the Registration Manager database: tblMailingListActivity, tblMailingListManagerPreferences, and tblMemberDetails.
- Change the table pointers in the Mailing List Manager files from "tblMemberList" to "tblMM_Members". In Dreamweaver, the easiest method is to use Edit -> Find and Replace while in Code View. The following files must be changed:
- In Admin Folder
- In Applications Folder
- In Admin Folder
- Open the Registration Manager admin page (i.e. www.yoursite.com/admin/RegistrationManager/admin.asp). All the members from your Secure Login Manager database should appear on the Registration Manager admin page.
- You may now take advantage of Registration Manager's extra fields by editing and adding new information to the members.
If you have any problems or questions with this procedure, contact DMXReady Tech Support .
In order to fully integrate DMXReady's Secure Login Manager and Mailing List Manager with Registration Manager, the file name pointer has to be changed from the Secure Login Manager and Mailing List Manager databases to that of the Registration Manager. Note: These steps should be done after all three applications have been extracted to your local website location and put to the server.
- Open the local file of ".../Connections/secureloginmanager.asp" with Dreamweaver.
- Change the line: "MM_secureloginmanager_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/databases/SecureLoginManager.mdb") & ";" %>" to read: "MM_secureloginmanager_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/databases/RegistrationManager.mdb") & ";" %>"
- Save and put to server.
- Repeat steps 1-3 with ".../Connections/mailinglistmanager.asp"
Do not use the Secure Login admin page or the Mailing List Manager admin page to manually add new members. Although it will update to the same database, Registration Manager allows a wider range of fields, so all new members should now be added through the Registration Manager admin page. As well, all information pertaining to members, including security levels, should be edited through the Registration Manager. For more information, please refer to the Registration Manager User Guide documentation.
Continue to use Mailing List Manager for mailing campaigns.