Uploaded image for project: 'Hydstra Testing'
  1. Hydstra Testing
  2. HT-317

Groundwater Group download and selection not providing right data

    XMLWordPrintable

    Details

      Description

      Hi Denby,
      There are some problems with the output from the group selection and download. I uploaded a list (attached) and didn't receive all the data in the spreadsheet (also attached).

      This was missing or wrong:
      1. Water level tab.Measurement point (mAHD) and Natural surface (mAHD) values not the latest values from the HYDRLMP table. See 58112 for eg. This has 194.04 and 193.4 respectively as values and the latest ones are 194.13 and 193.51.

      2. Field chemistry tab. Vol Water purged (890) and EC (820) values not coming across.
      a)Vol water purged - why is this variable empty now? Where is this now stored?
      b)Does EC (820) it have something to do with not picking up on variables with .##'s? I've added a list of variables with . in them which I did a count of in SQL Server
      SELECT distinct([VARIABLE]), COUNT([VARIABLE]) as "count of variable"
      FROM [hydstra].[dbo].[HYDMEAS]
      where VARIABLE like '%.%'
      group by VARIABLE
      order by VARIABLE

      3. Lab Chem Tab. "Paramater names" and "units of measure" values - not all coming through, just blank spaces.

      Thanks,
      Emma

      Thanks,
      Emma

        Attachments

        1. Copy of download.20131022142743.xls
          94 kB
        2. double_up_23Oct.xls
          42 kB
        3. download.202301140049.xls
          95 kB
        4. list.txt
          0.0 kB
        5. NEWdownload.20131113150214.xls
          91 kB
        6. sub var check_ht317.JPG
          sub var check_ht317.JPG
          31 kB
        7. sub var check_ht317.xls
          91 kB
        8. variables with . in them.xlsx
          10 kB

          Activity

            People

            Assignee:
            ed01 Emma Davidson (Inactive)
            Reporter:
            ed01 Emma Davidson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated: