mO SharemO Share

Users' Guide (Version 1.1) for Data Sync to Live Sync Migration

Owned by Aparajita Basu Roy
Last updated: Apr 12, 2023
3 min read

Previously, Ginesys ERP and Ginesys POS used a three point system to send and receive data to each other. These three points were the HO, the Web DB and the POS. An asynchronous sync cycle was followed in which during HO sync, HO dumped data in Web DB and each POS downloaded the data from Web DB at the time of its own scheduled sync. Then the POS uploaded its own data which was finally downloaded by the HO to complete the sync cycle.

After enabling Live Sync Ginesys users will be able to access real time data of POS at HO and vice versa. The new technique of Data Sync has removed the Web DB between HO and POS, minimizing the time lag between updated data of HO and POS. HO has been provided with an API as a gateway for data transfer to POS. When the POS makes a call on that API it accesses the data of HO and also provides its own data. 

System Prerequisites for Data Sync to Live Sync Migration

HO - 

  1. OS: Windows 2012 R2(x64)* or higher [*64bit OS is mandatory]
  2. RAM: 16GB or higher
  3. IIS: 8.5 or higher with STATIC IP 
  4. Oracle: 12c

  5. Framework: .Net 5.0 Hosting Bundle - Windows Hosting Bundle(If not installed) 

    Alert

    Prerequisite checker will prompt the user if the above bundle is not found but the user needs to download and install it manually.

    Download Link: https://download.visualstudio.microsoft.com/download/pr/05726c49-3a3d-4862-9ff8-0660d9dc3c52/71c295f9287faad89e2d3233a38b44fb/dotnet-hosting-5.0.17-win.exe 


  6. Internet connection speed: 150 Mbps or more

POS -

  1. OS: 64 bit OS* [*64bit OS is mandatory]
  2. RAM: 8GB or higher
  3. SQL Server: 2012 or Higher

  4. Framework: .Net 5.0 Hosting Bundle - Windows Hosting Bundle 

    Alert

    POS Auto updater will automatically download and install the above framework from version 2.12.3

    Download Link: https://download.visualstudio.microsoft.com/download/pr/05726c49-3a3d-4862-9ff8-0660d9dc3c52/71c295f9287faad89e2d3233a38b44fb/dotnet-hosting-5.0.17-win.exe

  5. Internet connection speed: 50 Mbps or more

Software Versions for Data Sync to Live Sync Migration

HO side:

HO AutoUpdater: Greater than or equal to 55.0

Ginesys ERP version: Greater than or equal to 12.14.4

POS side:

POS Auto Updater: Greater than or equal to 14.0

Ginesys POS version: Greater than or equal to 2.14.3


LiveSync Activation Steps at HO:

  1. Open AutoUpdater
  2. Upgrade AutoUpdater to Version 55.0 (Greater than or equal to)
  3. Download and Apply the HO version (Greater than or equal to 12.14.3)

LiveSync Configuration Steps at HO:

  1. Enable the LiveSync function from "Admin" -> "Security" -> "Roles" -> Select the desired role -> Check the "LiveSync" option under "Configure" and "Explore" in the "Utilities" section of the "POS Management" module.
  2. Log out and again Log in to reflect role changes.
  3. Set up a new API endpoint configuration for the Live Sync from the "POS Management" -> "Utilities" -> "Web API" section.
  4. Navigate to "POS Management" -> "Utilities" -> "Configure" -> "Live Sync" menu. Select the site(s) you wish to migrate, then click the "Migrate Site" button.
  5. Wait for the sync process to stabilize(it typically takes one sync process from HO followed by one sync process from POS).
  6. After stabilized, navigate to "POS Management" -> "Utilities" -> "Configure" -> "Live Sync" menu & click the "Generate JSON" button to download the config file. The system will not allow the user to generate JSON if the current cycle of Web Sync is not completed.
  7. Circulate the config JSON file to migrated POS site(s) by user/admin/it. Sample as follows
  8. Navigate to "POS Management" -> "Utilities" -> "Explore" -> "Live Sync" menu to view Live Sync Dashboard. It will display all Live Statistics(Critical, Warning & Info)which helps IT Team to determine Sync's health and take any proactive action if required.

LiveSync Activation Steps at POS:

  1. Open AutoUpdater
  2. Upgrade AutoUpdater to Version 14.0(Greater than or equal to)
  3. Download and Apply the POS (Greater than or equal to 2.14.3)

LiveSync Configuration Steps at POS:

  1. Open POS, and access the "Live Sync Settings" menu.
  2. Import the downloaded JSON config file from HO.
  3. After getting a success prompt from POS, User should take a Backup before doing any POS Operation. It is mandatory. After Migration or POS Restore or POS Recovery, if the POS is Live Sync enabled, then taking Backup before starting any POS operation is NECESSARY.We'll automate this step in our next release but for the time being, taking backup is mandatory after migration or restore or recovery.

Estimated Downtime:

  • HO Update: As same as the previous update
  • POS Update: As same as the previous update
  • No downtime is applicable for Sync Migration. This is a "Live Migration". All steps will take place and execute while the system is up and running.

Key Notes:

  • HO Task Scheduler: A new windows task scheduler is introduced that is responsible for HO side site(s) data gathering parallelly.
  • HO LiveSync API:A new set of API endpoints (PUSH API to consume data from POS, PULL  API to distribute data from HO) that is responsible for HO to POS and POS to HO communication.
  • POS Task Schedulers: Two new windows task schedulers are introduced that are responsible for POS Data sending to HO and receiving from HO.
  • POS Backup & Recovery: Now Live Sync will take Transaction Log Backup every minute. It helps POS to minimize data loss.
  • We strongly suggest all POS, to take full backup per day to get maximum throughput.