/
Framework Logistics Tablet Upgrade v7.2

Framework Logistics Tablet Upgrade v7.2

Owned by Jillian (Unlicensed)
Last updated: Oct 21, 2021 by Sam Pitts
The Tablet PC Copy in the title refers to the Tablet PC copy of the Framework Logistics Tablet database and software.

The following guide is designed to upgrade the Framework Logistics Tablet database and software.

Framework Logistics Tablet must be upgraded on ALL systems that are currently running the application.

Pre-Requisite Checklist

  • Complete the Pre-Requisite Checklist Overview.
  • Complete the Environment Setup Checklist Overview.
  • The Framework ECM Upgrade must be complete.

Step 1 - Implement Framework Logistics Tablet Files

The following environment setup procedures must be performed before upgrading Framework Logistics Tablet.

Implement Upgrade Folder On Tablet PC

On every Tablet PC:

  1. Open Windows Explorer.
  2. Browse to the server: \[fw folder]\Upgrade\
  3. Copy the Upgrade 7_2_0_26 folder 
  4. Browse to the C:\Framework\Upgrade\ of the Tablet PC.
  5. Paste the folders. The folder should be: 
    C:\Framework\Upgrade\Upgrade7_2_[X_xx]\
  6. Close Windows Explorer.


Step 2 - Backup Framework Logistics Tablet Database

A backup of the Framework Logistics Tablet databases MUST be performed prior to upgrading the database using one of the following two methods: 

  • Manual: Using Microsoft SQL Server Management Studio.
  • Automatic: Using the backup.bat file.

Backup (Manual) - Framework Logistics Tablet Database

  1. Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 (or above) > SQL Server Management Studio).
  2. Connect to the required server.
  3. In the Object Explorer pane, expand: [server name] > Databases
  4. Right-click on the Framework Logistics Tablet database (e.g., FworkSQLCstLTablet) and select Tasks > Back Up. The Back Up Database (General Page) dialog will be displayed.

  5. Specify a Name and Destination for the backup file, if different from the default name and destination details.

    Write down the name and destination details.
  6. Select the Options page.
  7. Tick: Overwrite all existing backup sets
  8. Tick: Verify backup when finished
  9. Click the OK button. The backup will be performed to the selected destination.
  10. Click the OK button to close the message prompt.
  11. Close SQL Server Management Studio.
  12. Browse to the backup location (as detailed in Point 5 above).
  13. Copy the backup file to a secure location.

Example

A typical example is to backup the database file (.bak file) to the following folder location: \[fw folder]\Service\fwCstLTabletBackup_[machineName]

Backup (Automatic) - Framework Logistics Tablet Database

CRITICAL

Edit the backup.bat file located in the C:\Framework\Synchronise\ folder to ensure the correct organisation details are included. If this folder is not available, please use the manual backup method.

  1. Open Windows Explorer.
  2. Browse to: C:\Framework\Synchronise\
  3. Double-click the file: backup.bat
  4. A backup of the Framework Logistics Tablet database will be created and copied to the location entered in the backup.bat file.

Step 3 - Upgrade Framework Logistics Tablet Database

The following procedure upgrades the Framework Logistics Tablet database.

CRITICAL

The Framework Logistics Tablet database must have previously been upgraded to v7.0.0. Contact your Framework administrator if you are not running the Framework Logistics Tablet v7.0.0 database.

The Framework Logistics Tablet database upgrade can be performed either manually or silently. The manual upgrade option requires user intervention and selections whilst the silent upgrade option, which uses a command line switch, requires no user intervention and is therefore useful for group policy rollouts across multiple Tablet PCs. Both manual and silent installation options are included.

If during the upgrade process 'Not Responding' appears in the title bar of the Framework Logistics Tablet Upgrade software, this is due to the system performing very long and CPU-intensive calculations. This message will disappear once the upgrade has been completed.

You must have completed the Microsoft SQL Server backup (outlined in step 2) before proceeding further.

Framework Logistics Tablet 7.2. Database Upgrade

Framework Logistics Tablet 7.2.0.26 Upgrade

On the system that is running Framework Logistics Tablet: 

  1. Open Windows Explorer.
  2. Browse to: \[fw folder]\Upgrade\Upgrade_v7_2_0_26\ECM\
  3. Double-click the FworkCstLTabletUpgrade.exe file. A Database Backup confirmation prompt will be displayed.
  4. Click Yes to confirm that a manual backup of the Framework Logistics Tablet database has been performed. The Start Upgrade confirmation prompt will be displayed.
  5. Click Yes to perform the upgrade.
  6. If the upgrade was successful, a successfully completed message prompt will be displayed.
  7. Click OK.
  8. Click Close.

Backup Framework Logistics Tablet Database

Following the relevant instructions in Step 2, create a separate backup of the database at this point.

Silent Framework Logistics Tablet 7.2.X.xx Database Upgrade

This is a two-step process:

Framework Logistics Tablet 7.2.0.26 Upgrade

On the system that is running Framework Logistics Tablet: 

  1. Open Windows Explorer.
  2. Browse to: \[fw folder]\Upgrade\Upgrade_v7_2_0_26\ECM\
  3. Right-click on FworkCstLTabletUpgrade.exe and select Create Shortcut. A shortcut to the executable will be created.
  4. Right-click on the new shortcut and select Properties. The Properties dialog will be displayed.
  5. On the Shortcut tab, edit the Target field and include the command line switch -s at the end of the line. The target should look similar to the following:
     "\[fw folder]\Upgrade\Upgrade7_2_[X_xx]\ECM\FworkCstLTabletUpgrade.exe" -s
  6. Click OK. The Properties dialog will close.

After creating a new shortcut with the command line switch, run the database upgrade using the new shortcut.

  1. Open Windows Explorer.
  2. Browse to: \[fw folder]\Upgrade\Upgrade7_2_0_26\ECM\
  3. Double-click the newly created shortcut file.
  4. The silent database upgrade will be performed.

Unsuccessful Database Upgrade

If the database was unsuccessful, restore the backup database file. Refer to your Microsoft SQL Server documentation for more information.


Step 4 - Update Core Components

Installs a set of common software tools used by Framework Logistics Tablet.

This step can be skipped if Core Components v16.0.02 or greater is already installed.

For this process, see Install Insula Core Components.

Step 5 - Update Framework Logistics Tablet

On all systems running Framework Logistics Tablet:

Uninstall The Existing Version Of Framework Logistics Tablet

In Microsoft Windows XP Tablet PC Edition

  1. Open Add or Remove Programs (Start > Control Panel > Add or Remove Programs). The Add or Remove Programs dialog will be displayed.
  2. From the Currently Installed Programs list, select the previous version of Framework Logistics Tablet.
  3. Click the Remove button. The application will be removed.

In Microsoft Windows Vista Tablet PC Edition

  1. Open Uninstall a Program (Start > Control Panel > Uninstall a Program). The Uninstall or Change a Program list will be displayed.
  2. Select the previous version of Framework Logistics Tablet.
  3. Click the Uninstall button. The application will be removed.

Install The Latest Version Of Framework Logistics Tablet

  1. Open Windows Explorer.
  2. Browse to: \[fw folder]\Setup\Framework Logistics Tablet\v7.2\Setup\
  3. Double-click Framework Logistics Tablet.msi and follow the on-screen prompts.


Step 6 - Test Framework Logistics Tablet

On all systems running Framework Logistics Tablet:

Start Framework Logistics Tablet

  1. Start Framework Logistics Tablet (Start > All Programs > Insula Software > Framework Logistics Tablet).

    Double-click the Framework Logistics Tablet desktop icon.

  2. Log on to the system.


Step 7 - Backup Framework Logistics Tablet Database

CRITICAL

This MUST be performed on the system(s) that host a Framework Logistics Tablet database. 

A backup of the upgraded Framework Logistics Tablet databases MUST be performed using one of the following two methods: 

  • Manual: Using Microsoft SQL Server Management Studio.
  • Automatic: Using the backup.bat file.

Backup (Manual) - Framework Logistics Tablet Database

  1. Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 (or above) > SQL Server Management Studio).
  2. Login to Microsoft SQL Server.
  3. In the Object Explorer pane, expand: [server name] > Databases
  4. Right-click on the Framework Logistics Tablet database (e.g., FworkSQLCstLTablet) and select Tasks > Back Up. The Back Up Database (General Page) dialog will be displayed.
  5. Specify a Name and Destination for the backup file, if different from the default name and destination details.

This must be a different destination location than the one used in Step 2 - Backup Framework Logistics Tablet Database.

Write down the name and destination details.
  1. Select the Options page.
  2. Tick: Overwrite all existing backup sets
  3. Tick: Verify backup when finished
  4. Click the OK button. The backup will be performed to the selected destination.
  5. Click the OK button to close the message prompt.
  6. Close SQL Server Management Studio.
  7. Browse to the backup location (as detailed in Point 5 above).
  8. Copy the backup file to a secure location.

Example

A typical example is to backup the database file (.bak file) to the following folder location: \[fw folder]\Service\fwCstLTabletBackup_[TabletPCName]

Backup (Automatic) - Framework Logistics Tablet Database

CRITICAL

Edit the backup.bat file located in the C:\Framework\Synchronise\ folder to ensure the correct organisation details are included.

  1. Open Windows Explorer.
  2. Browse to: C:\Framework\Synchronise\
  3. Double-click the file: backup.bat
  4. A backup of the Framework Logistics Tablet database will be created and copied to location entered in the backup.bat file.


Step 8 - User Acceptance Tests

The following is a list of view only tests that must be performed after upgrading the application.

These tests must be performed on all Tablet PCs.

Screen / View

Menu Path

Completed

Start Framework Logistics Tablet



Log in as a user other than a super-user



Access all screens via the Home page.




Step 9 - Perform Synchronise

Perform the following synchronise on ALL Tablet PCs after upgrading the Framework Logistics Tablet database.

  1. Open Framework Logistics Tablet.
  2. Login to the system.
  3. On the Home page, select Synchronise. The Framework Logistics Synchronise (Standard tab) dialog will be displayed.
  4. Select the Advanced tab.
  5. From the Select a Profile list, select Daily (full sync) - Construction Data.
  6. From the Synchronise list, tap 1 - 9:

    1. Construction Progress

    2. Notifications, Estimates, WOs

    3. Jobs, POs, Tenders, VOs, Colours

    4. Tablet, Static Data, Entity, Prefs

    5. Keys, Templates, Standard Notes

    6. Company, Product, Land, Diary

    7. Calendar, RMS, Security

    8. Synchronise Job Files

    9. Synchronise Master Files


     

  7. Tap the Start Synchronise button. The synchronise will be performed. Once successfully completed, the Framework Logistics Synchronise dialog will close.
  8. From the Home page, select Synchronise. The Framework Logistics Synchronise (Standard tab) dialog will be displayed.



  9. Tap the New Jobs Synchronise. The synchronise will be performed. Once successfully completed, the Framework Logistics Synchronise dialog will close.
  10. Close Framework Logistics Tablet.

See Also Upgrading A Blank Logistics Tablet Database.