Bacteria data download

[SierraStreamsInstitute-Lab]

When we download data table 2, we get everything except bacteria data.

[thosmos]

I'm not sure I understand. When I run data table 2, I see TotalColiform and EColi columns

[SierraStreamsInstitute-Lab]

Yes, I see that too, it's when I download CSV for all years that it's missing.

[thosmos]

Can you try it again? I recently changed the csv download to use the same algo as data table 2. T

…

On Wed, Feb 15, 2023 at 10:34 AM SierraStreamsInstitute-Lab < ***@***.***> wrote: Yes, I see that too, it's when I download CSV for all years that it's missing. — Reply to this email directly, view it on GitHub <#42 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEXVZXUFLHEKDZKMNC63NTWXUOTJANCNFSM6AAAAAAUPU5AWU> . You are receiving this because you commented.Message ID: ***@***.***>

[SierraStreamsInstitute-Lab]

Oh, it got weirder!

[thosmos]

That doesn’t look very good

…

On Wed, Feb 15, 2023 at 10:40 AM SierraStreamsInstitute-Lab < ***@***.***> wrote: Oh, it got weirder! [image: CSV download] <https://user-images.githubusercontent.com/114112659/219122261-22082115-9488-4d6a-98f6-2a53725c7016.png> — Reply to this email directly, view it on GitHub <#42 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEXVZVEMJVT5RFZEIVGHM3WXUPJBANCNFSM6AAAAAAUPU5AWU> . You are receiving this because you commented.Message ID: ***@***.***>

[SierraStreamsInstitute-Lab]

Just checking on this here, I'm still getting the same blank csv file.
I also wanted to check the format of bulk uploads; what I have from when Alex was working on this is this:
RiverDB data upload template.xlsx
But it doesn't have some necessary info like device name. The download template used to though:
RiverDB data download format.xlsx

[thosmos]

The All Years button has been fixed. As for the device column, normally you would have a device column per parameter with the device ID for those values, and that ID should match with an existing device ID in your devices table. It looks like the report download only shows the default device type for each parameter, but device IDs are missing entirely. These were never imported manually before. Did you ever enter these when adding data manually?

[SierraStreamsInstitute-Lab]

I believe we did enter them when adding data manually, and most data that you pulled from RiverDB has a device associated with it.