The WIMS-Rio Sync Service is a Windows Service that syncs data and audit information to/from WIMS to/from Rio.
The service runs on a scheduled basis every x number of minutes (see Configuring WIMS-Rio Sync Service). With each run the service:
1. Retrieves all data for the last x days (Service, Days to Fetch setting), scans that data for changes (whether the data is entered, imported via an interface or calculated) in Rio since the last sync run and it's parameter is connected to WIMS (i.e. the Rio Parameter's description is set to Varid=xxx). It will import that data with audit trail information to WIMS).
2. Finds data in WIMS that has changed (whether the data is entered, imported via an interface or calculated in WIMS) since the last Sync run and it's parameter is connected to WIMS (i.e. the Rio Parameter's description is set to Varid=xxx). It will import that data with audit trail information to Rio.
3. Retrieves all Rio logbook notes for the last x days (Service, Days to Fetch setting), checks if they exist or need updating in WIMS and creates/updates in WIMS.
NOTE: The Rio logbook notes are moved to WIMS as plain text. Example:
4. Finds logbook entries in WIMS that have been added, updated, or deleted since the last Sync run and updates the Rio records accordingly.
5. Finds any updates to Variables since the last sync in WIMS and updates the following:
- WIMS name to Rio Parameter Name.
- WIMS Units to Parameter Unit. WIMS unit must be a valid Rio Unit for the update to occur.
- WIMS Rio Parm Guid to the Rio Parameter Type.
- WIMS Entry Limits get created/updated as Warning Limits in Rio.
- WIMS Regulatory Limits get created/updated as Regulatory Limits in Rio.
6. Logs the number of data points synced to the Data Studio's Rio-WIMS Sync log.
WARNING: Care should be taken when syncing calculated data. Sync WILL NOT sync data if the variable/parameter is calculated in both systems. Therefore, a WIMS calculated variable should be synced to a Rio Parameter and a Rio Calculated Parameter should be synced to a WIMS parameter variable.
1. MLSS entered in Rio and Synced to WIMS.
2. Total MLSS Mass calculated in WIMS and then synced to Rio.
3. MLVSS calculated in Rio and synced to WIMS.