search

helendallas / FRC_FBIS

Freshwater research Centre FBIS Data Consolidation Management
0 stars 0 forks source link

Check SASS data per province - Western Cape #152

Closed helendallas closed 3 years ago

helendallas commented 3 years ago

Several issues exist with the SASS data in FBIS which need to be systematically checked.

I have created a folder on FRC_FBIS Data for Consolidation/SASS Data checking FBIS

Two files: invert sass ihas v3.1Jul17.xlsx (This is the original Rivers database SASS data) - highlighted columns include

RHP Site Code Sampling Date Site Visit Owner

File to check is: WC Multiple SASS Summary.xlsx (Extracted from FBIS) - highlighted columns include Original Site Code Sampling Date Owner

  1. Owners are blank - filter on Owner column for blanks - check owner in invert sass ihas v3.1Jul17.xlsx, copy to WC Multiple SASS Summary.xlsx , and then update on FBIS.
helendallas commented 3 years ago

@Janette-Lumley Dimas said he had run an update to fix this so let me check first so that we dont waste your time. I have working today on FBIS stuff so should have some more tickets lined up for you soon :)

helendallas commented 3 years ago

To rerun and check after Dimas has reattached owners

helendallas commented 3 years ago

Closing ticket as superseded with #179 which is for the whole country