How to use the Database Analyzer and Database Fixer Utilities

How to use the Database Analyzer and Database Fixer Utilities

QUESTIONS THAT APPLY TO THIS TOPIC

  • How do I use the database analyzer?
  • How do I use the database fixer?

 

ANSWER

            Database Analyzer 
  1. Make sure that everyone has closed Gorilla.
  2. Make a backup of your database.
  3. Click on the start menu, select Programs, BGM – Gorilla CRM® System for Financial Services, and choose Database Analyzer.

  4. The Default and Playground buttons to the right of the directory lines toggle between which directories you want to run the analyzer on.  If you are running the analyzer on your regular database, that is selected by default.  To run the analyzer on your Playground, simply click the Playground button.  Click Next to continue.
  5. The database analyzer will then proceed through its process, and display the results.  You have the option to save and to print from this screen, as well.  Click finish, and the Database Analyzer will close.

Database Fixer

  1. Make sure that everyone has closed out of Gorilla.
  2. If you haven’t done so already, make a backup of your database.
  3. Click on the start menu, select Programs, BGM – Gorilla CRM System for Financial Services, and choose Database Fixer.

  4. The Fix Gorilla Database and Fix Playground Database below the directory lines toggle between which directories you want to fix.  If you are running the analyzer on your regular database, that is selected by default.  To run the analyzer on your Playground, simply click the Fix Playground Database button.  The Add Sample Contact Groups checkbox will add several contact groups to the database.  They are good for testing purposes.  Click Next to continue.
  5. Click Finish and the database fixer will then proceed through its process, and display the results.  You have the option to save and to print from this screen, as well.  Click close, and the Database Fixer will close.

    • Related Articles

    • You and Another User are Trying to Edit the Same Action

      PROBLEM You and another user are trying to edit the same action CAUSE This error is most likely begins with a network issue of some kind that resulted in a corrupted record being stored in the database. At that point, the Microsoft database engine ...

    • An Unexpected Unrecognized Database Format

      PROBLEM When opening a contact group within Gorilla, the following error comes up: “program error intercepted 'an unexpected unrecognized database format' \\gorilla server\c\database\b40.mdb. Error occurred in Gorilla CRM.” CAUSE This is caused by a ...

    • How to Use Gorilla in Multiple Locations

      QUESTIONS THAT APPLY TO THIS TOPIC What is a VPN?  What is a WAN?  Why should I not use VPN or WAN?  How can I use Gorilla in another office?    ANSWER What is a VPN?  VPN stands for “Virtual Private Network.”  It is a type of network design that is ...

    • Database Path Uninitialized

      PROBLEM When sending a message to a selection rule, you get the error “database path uninitialized” followed by the visual basic debugger, and nothing will print. SOLUTION Reinstalling Gorilla should fix this problem. Uninstall Gorilla Right click on ...

    • How to Use Merge Fields in Gorilla® Letters

      QUESTIONS THAT APPLY TO THIS TOPIC How do I insert a Merge Field? How do I delete a Merge Field? Where do I input the data for Custom Merge fields? ANSWER Important: If you make any changes to Merge Fields in a letter, be sure to “Save and Exit to ...