-limegreen)

## v5.11 (1.8.0) - December 20th, 2024
Angular CLI version 9.1.15.
## Steps
1. Copy folder `EliconUpload` to
- `C:\`
2. Execute all scripts in folder `Scripts`
- Please execute scripts in **SEQUENCE**
3. **Elicon_Sync.exe, init and create triggers for new tables.**
- Run C:\Elicon\Elicon_Tool.exe
- `Quickly`, click the word Init after exe is opened. You should see the **Success** information box.
4. Execute below scripts, make sure you get **`6786`** 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','__EFMigrationsHistory','__WorkFlowEFMigrationHistory')
AND TABLE_NAME NOT LIKE '%WorkFlow%'

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

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

6. Execute below scripts:
- Make sure you get **`421`** records returned

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

- For sites which are using Sync, for example TVL, Cetus, Tairong, Jinhui, 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 **NOT** using Sync, for example CLSICO, 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, Cetus, Tairong, Jinhui, 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 ('UserRefreshTokens','sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet','TableDefinition','SystemConfig','Sheet1','IMPA_IMPORT','IMPA8_IMPORT','LoginLog','SystemKeyGenerator')

- If you do not get **`0`** records returned, do the following
- Run C:\Elicon\Elicon_Tool.exe
- `Quickly`, click the word Init after exe is opened. You should see the **Success** information box.
8. Updating webpage files in directory`C:\inetpub\wwwroot`:
- C:\inetpub\wwwroot\FeMS-Frontend
- Delete all files, **EXCEPT** the file web.config.
- Copy web folders from Release package to `C:\inetpub\wwwroot`, and REPLACE!!
- 
- if encountered error, for example: when updating the folder `pms`:
- This means someone is using FeMS.
- In IIS, select the site `pms` and Stop,
- Do file replacement (paste) again.
- Start IIS service.
9. Open Browser and test Elicon FeMS.