Internet Software Sciences | (www.inet-sciences.com) | Toll Free (888) 949-0942 | Sales@inet-sciences.com | Los Altos, CA USA

Welcome to the June 2009 ISS Newsletter. We hope you have been enjoying the benefits of   Web+Center, the Help Desk and Sales CRM Solution that are quick and easy to implement, and that you have previously downloaded.

If you haven't had a chance to use the Web+Center suite of web-based applications, please download version 6.0 for Windows OR Linux.

Recently we have received some support calls on restoring Web+Center systems on computers that have encountered disk failures. This newsletter will describe some preventative backup and recovery approaches that we recommend for your Web+Center application.

It is important to note that Internet Software Sciences DOES NOT backup your database or application and it is up to you to properly cause this to happen. It is especially important to backup the database on a frequent interval and then store the backup materials at a safe and off site location. This newsletter will help to define what Web+Center application pieces should be backed up and then how to restore them in the event of a disk failure or server migration.

Sincerely,
Scott Vanderlip - President - Internet Software Sciences


    Web+Center application backup and restore methods


Backup your Web+Center data and application BEFORE a possible disk failure

Overview
The Web+Center Help Desk Application is a web-based, database-driven application. Certainly the most VALUABLE part of your Help Desk application is the data and information you have put into the Web+Center and is in the database itself. This value grows as you enter more and more solved support cases and customer information into the database that can be used as a resource for knowledge based searches, asset inventory notes or customer sales leads or even critical business invoice information. You can always download a fresh version of the software if a re-installation is required but the data you put into the application can not be restored unless you have properly backed up the database and application folder.

Proper regularly scheduled backing up of the Web+Center database is critical to restoring your data and application in the event of a disk or machine failure.

Recommended Application backup procedures
The Web+Center application consists of two primary components. The first component is the application code. It consists of ASP- active server page modules, "include" files, graphics and some configuration files. All of these files can be found in the folder and sub folders typically installed under

    c:\Program Files\Internet Software Sciences\Web+Center 6.0\...

This file structure should be backed up fairly regularly, especially if you are making customizations to the Web+Center ASP code. If you are storing related attached files in a directory outside of the Web+Center folder, it should also be backed up. Attached files to cases are NOT stored in the database but stored in the file structure.

The Second component is the Web+Center database. For Microsoft Access database users, the database will be the webcenter60.mdb file located in the database subdirectory and will be backed up as part of your folder backup if you are properly backing up the entire Web+Center folder. If you are running SQL*Server as your backend server database, you must separately backup the webcenter60 database using SQL*Server database backup tools at regularly scheduled intervals.

Important: If you have performed a Web+Center version database migrations, be sure that the database you are backing up is the database that you are using for your Web+Center application via the specified database DSN. It may be possible that the SQL or Access database that you are using is an upgraded webcenter40, or webcenter50 version so verify that you are backing up the correct database.

We recommend you backup your database daily and you should backup your application file directory tree probably weekly or every few weeks. We get calls all the time from Web+Center users who experienced hard-disk crashes on their web server or had they files wiped out through errant software or procedures. They then inquire as what utilities we have for database recovery and we have to sadly inform them that users are responsible for their own application and database backups.


Web+Center application Migration to a new server
The Web+Center application is an easy application to migrate or duplicate on a test server.

The basic steps to migrating your Web+Center from one machine to another are outlined below. For more complete details on some of the installation steps listed below, please refer to the Web+Center installation guide.

  • Copy all of the Web+Center files to another machine. To be consistent, the files are typically installed under:
    c:\Program Files\Internet Software Sciences\Web+Center 6.0\...
  • Re-create the Web+Center web virtual directories consisting of tech60, customer60, pocket60, business60, language60 and docs60 using IIS (Internet Information Server).
  • If you are using SQL*Server as the backend database, it must be backed-up and restored on the new server if you want to migrate it to a new server. An Access databases is just one file (webcenter60.mdb) located in the database sub directory of the Web+center 6.0 folder and it will be copied with all of the other files automatically when you copy the webcenter files.
  • Re-create the Web+Center ODBC DSN (webcenter60_db) on the new machine. For complete ODBC DSN configuration steps, please refer to the installation guide.
  • It will probably be necessary to re-register the ASP mailer dll called AOSMTP.dll located in the ASPMailer directory. To register this DLL, run the command "REGSVR32 aosmpt.dll" inside of the ASPMailer directory within a DOS command prompt window. You must first navigate to the directory or specify the path of the dll for it to be successfully registered.
  • The file security permissions for the Web+Center 6.0 folder and all sub folders must be set for Everyone (Full Control) and no other users. You must break inheritance from any directories above the Web+Center folder, especially if you are in the Program Files folder where inherited permissions are often set for child folders. A complete system reboot is required once file permissions have been applied to completely set all of the "Access control lists" required for proper operation.
  • Always verify the operation of the new Web+Center before switching users or deleting any code or databases.
  • When you ran the original webcenter60.exe installation executable, it did place some minimal information into the registry which is used when doing un-installs but these registry settings are not required for the web+center operation and re-installing from original webcenter60.exe executable is not necessary.
  • If you have questions, please contact the Internet Software Sciences support center by using their web-based support site or call their support center at Toll Free (888) 949-0942 or (650) 949-0942.


   Evaluate Web+Center Help Desk Today! Click for details

The Web+Center Suite of applications provides an optimal solution for your IT Help desk, asset tracking, or customer support operations and reservation processes. By providing a practical balance of feature-richness and usability with low total cost of ownership, it will be one of the best investments you make for your organization.

If you need more information, please visit our web site at www.inet-sciences.com or call Toll Free (888) 949-0942. We look forward to hearing from you about your variety of uses of the Web+Center products.