Upgrading LIP

Upgrading From v3.x.y or later

From v3.0.0, the SQL procedures have their own version number. This is to make it easier to upgrade LIP in cloud, where you do not have access to the SQL procedures without downloading the database. The SQL procedure version in your Lime CRM application is noted in the SQL procedure csp_lip_cc_getlipsqlversion.

Whenever you are running lip.Install, LIP will check if you have the latest version of the SQL procedures and if you have the latest version of the VBA modules. If not, LIP will ask you to upgrade. If you already have the latest version of the SQL procedures, you will not have to replace the SQL procedures when updating, which will make updates in Cloud Lime CRM applications a lot easier.

Upgrading From v2.x.y or Earlier

The SQL procedures changed names in v3.0.0 to csp_lip_cc_*, where cc stands for Cloud compatible. You should remove all other old SQL procedures for LIP when updating to this version or later. The old procedures were named as csp_lip_*.

Step-by-step Instructions

  1. Delete the VBA modules lip and LIPPackageBuilder and the VBA form FormProgress.
  2. Delete the folder Actionpads\apps\LIPPackageBuilder.

  3. Follow the steps for an installation of LIP.

    Warning

    If you also need to update the SQL Procedures, the upgrade of LIP must be done a bit differently depending on if the Lime CRM application is in the cloud or on-premise, as that requires access to the database in Management Studio.