Type Mismatch Error during Import

Type Mismatch Error during Import

PROBLEM

  • When importing a list or a Campaign, you get a “Type Mismatch” error.

CAUSE

This is usually caused by importing the wrong file type or trying to import a zipped file.

SOLUTION

  • Campaigns
    1. If the Campaign downloaded came in a compressed (zipped) folder, be sure to extract the .mdb from the .zip.
    2. Click on Windows Logo/Orb->All Apps/Programs->BGM - Gorilla System for Financial Services->Import Utility.
    3. Click on the ellipses (three dot box), and choose the .mdb file you wish to import.
    4. Click Next.
    5. On the duplicate checking screen, you will need to select if you want to use the already existing files, or replace the existing files with ones contained in the Campaign Database.
      Note : Everyone must be out of Gorilla to import any .mdb file (campaigns, speedbuttons, office procedures, etc...)
  • Lists
    • List files must be in either .txt or .csv file formats.
    • If the file you are trying to import is a .xls or .xlsx, you must open the file in Excel and then click on File>Save As and choose CSV (comma delimited) (*.csv) from the Save as type drop down.
    • If you are dealing with a .doc or .docx file, then you will need to re-save it as Plain Text (*.txt)
    • Once you have the correct file type, you may proceed with importing the file.



    • Related Articles

    • Type Mismatch Error on Login

      PROBLEM After clicking “OK” on Gorilla login screen, you get a “Program error intercepted: ‘type mismatch’” error. SOLUTIONYou will need to send your database in for repair. Call Software Support at 801-553-9888 for assistance with sending in your ...

    • Type Mismatch Error in the History Tab of the Info Sheet

      PROBLEM When going into the Info Sheet, you get a “Type Mismatch” error. CAUSE This is caused by the History containing too many items and Gorilla not being able to sort them all. SOLUTION To get past this, you just need to filter out some of the ...

    • Type Mismatch when Adding a New Opportunity

      PROBLEM When adding a new Opportunity to a Contact Group in Gorilla®, you receive the message "Type Mismatch" and the Due Date for the Opportunity only shows as being 12:00 AM. CAUSE This is caused by the Region and Language settings being set to a ...

    • System.InvalidCastException Unable to case object of type ‘System.DBNull’ to type ‘System.string’

      PROBLEM When trying to print a message to a Selection Rule, on the Contact Groups screen of the Send Message window when you click on the "Next" button you get the Error Message: System.InvalidCastException: Unable to cast object of type ...

    • You Don’t Have Any Import/Export Functions Installed

      PROBLEM I am trying to import a list, but I am getting the error “You don’t have any Import/Export functions installed. Please install them before using this function.” CAUSE This issue is a result of Gorilla having been installed as a Non-Master. ...