Implementation Tasks

Infrastructure Components

1. Switch the system into maintenance mode.
2. Add 3 new columns to LM_LabGroup Table in DataBase EUCSLabMonitor on Server sql-db-at2.is.ed.ac.uk
   • Column: lat varchar(30) default NULL
   • Column: lng varchar(30) default NULL
   • Column: geo_locked int default NULL

Application Components

Application Setup

1. Check out code from git (releases/release_2.0.0) and copy to LIVE server (ucs-sequel.ucs.ed.ac.uk)

Integration Components

Data Population

Data Migration

1. Update LIVE with geolocation data from TEST.
2. labmon_geo_loc_updates.txt

Implementation Validation

1. Check that there are no labs in groups that have lat/lng of 0/0. The following querey should be run on the LIVE DB server.

   SQL checking for Labs with no geo location data

   SELECT TOP (1000) [Lab_Group_Name],

   [Lab_id],

   [Lab_Friendly_Name],

   [Lab_Display_Order],

   [lat],

   [lng],

   [geo_locked]

   FROM [labmontest].[dbo].[LM_LabGroup]

   WHERE len(lat)<8 OR len(lng)<17;

    

2. If that returns any results then there are labs without geo_location data. Add in the geo_location data for the labs listed by the above result

3. Once all labs have geo location data remove from maintenance mode.