About UsSite MapContact Us
Help Desk Software Australia LogoHelp Desk Software Australia
ProductsTestimonialsFAQ'sPurchaseSupport
Menu

Products

VERSION HISTORY - Database changes v2.2 to v3.1.1

ACANOTION help desk software is a Microsoft windows desktop software package that allows you to log support calls and jobs for anything ranging from help desks to problem tracking with products and services.

The following changes should be made to your existing database to enable you to successfully upgrade to Version 3.1.1. These instructions are provided to upgrade from Version 2.2.0 to Version 3.1.1. If you have any other version, you should contact our support team for further assistance.

Before making any changes, we recommend that you make a backup of your current database first. You will also require a new registration code for the new version - please contact our sales team for this information before the upgrade to your database commences.

DB Table Changes or Additions How to make the change
tblEscalationActions Additional table
  • Copy and paste this table from v3.1.1 demo database to your v2.2 database
tblEscalationAdmin Additional table
  • Copy and paste this table from v3.1.1 demo database to your v2.2 database
tblJob Add new field called "LastEscalationTime"
  • Data Type = Date/Time
  • Default value = Now()
tblJob Add new field called "WaitingToSend"
  • Data Type = Yes/No
tblReminder New Field in this table called "ReminderDateTime"
  • Under "ReminderTime" add a row and place this new field in, called "ReminderDateTime".
  • Data Type = Date/Time
tblReminder Change to "ReminderInterval" field
  • Change Data Type from text to Number.
  • Set no default value. IE- remove the zero from default value.
tblReminder Change to "ReminderPeriod" field
  • Change Data Type from text to Number.
  • Set no default value. IE- remove the zero from default value.
tblReminder New Field in this table called "ReminderOption"
  • Data Type = Number
  • Set no default value. IE- remove the zero from default value.
Queries tab    
You should also copy the queries from the v3.1.1 DB and paste them into your v2.2 DB. This will replace the current ones you have.

The queries you will be copying and replacing are:

  • ACANOTION_GetClientJobHistory
  • ACANOTION_JobList
  • ACANOTION_ReportGeneratorAssets
  • ACANOTION_ReportGeneratorJobs

If you need any further assistance, please contact our support team via email.

ACANOTION help desk software - its easy to use, easy to log calls and has an great help desk user interface that anyone can understand.

 

 

2015 Help Desk Software Australia
Copyright | Privacy | Disclaimer
Site last updated: 02 January, 2015