-limegreen)

## v5.10 (1.5.1) - June 12th, 2024
Angular CLI version 9.1.15.
## Steps
1. Make sure all users saved their work and log out from Elicon FeMS.
2. Execute all scripts in folder `Scripts`
3. **Elicon_Sync.exe, init and create triggers for new tables.**
- Run C:\Elicon\Elicon_Tool.exe
- Click the word Init after exe is opened.
5. Execute below scripts, make sure you get **`6146`** records returned

USE [Elicon_Voyage]
GO
SELECT COUNT(1)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('SYNC_CODE','FlowGroupId')
AND TABLE_NAME NOT IN ('sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet')

5. Execute below scripts, make sure you get **`1012`** records returned

USE [Elicon_Voyage]
GO
SELECT COUNT(1) FROM ExcelFormMapping WHERE template NOT LIKE 'ntu%'

6. Execute below scripts:
- For sites which are using Sync, for example TVL, NTU and TORI, make sure you get **`0`** records returned

    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.triggers WHERE is_disabled = 1

- For sites which are using Sync, for example TVL, NTU and TORI, make sure you get **`375`** records returned

    USE [Elicon_Sync]
    GO
    SELECT COUNT(1) FROM Definition

- For sites which are **NOT** using Sync, for example CLSICO and HM, make sure you get **`0`** records returned

    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.triggers WHERE is_disabled = 0

7. Execute below scripts:
- For sites which are using Sync, for example TVL, NTU and TORI, make sure you get **`0`** records returned

    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.tables
    WHERE object_id NOT IN (SELECT parent_id FROM sys.triggers WHERE  is_disabled = 0)
    AND name NOT IN ('sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet','TableDefinition','SystemConfig','Sheet1','IMPA_IMPORT','LoginLog','SystemKeyGenerator')

- If you do not get **`0`** records returned, do the following
- Run C:\Elicon\Elicon_Tool.exe
- Click the word Init after exe is opened.
- Run the script again to check if you have **`0`** records returned

8. Updating files in `ExcelTemplate`
- `C:\EliconUpload\1\ExcelTemplate`
9. Updating webpage files:
- `C:\inetpub\wwwroot`
- if encountered error, for example: when updating the folder `pms`:
- In IIS, select the site `pms` and Stop,
- Do file replacement (paste) again.
- Start IIS service.
4. Open Browser and test Elicon FeMS.