The following are suggested steps to improve the sync process between WIMS and Rio.
1. Remove Location names from variable names. See Default Variable Display. Example, in WIMS if you have a location Raw Water and a parameter named Raw Water pH in Rio it will appear as Raw Water Raw Water pH. Use the Var Admin Tool.
2. Use Rio Guid Util to set Rio Parameter Types (Guids) on your WIMS variables. NOTE: this does not need to be done for all parameters but will improve your experience in Rio, it is suggested to do for the common parameters (pH, Temp, Turb, DO, BOD, TSS...)
3. Update Units to match Rio Units
4. Set Rio Location Types using Location Setup
5. Move unassigned variables to a location
6. Verify no duplicate MDE Forms (SELECT FORMNAME,COUNT(*) FROM MDE GROUP BY FORMNAME HAVING COUNT(*) > 1)
7. Rename duplicate variables in a location. SELECT LOCID, NAME, COUNT(*) FROM VARDESC GROUP BY LOCID,NAME HAVING COUNT(*) > 1