search

USGS-R / WQ-Review

Toolbox for discrete water-quality data review and exploration.
11 stars 4 forks source link

First basic data import #141

Closed bmccarthyqw closed 7 years ago

bmccarthyqw commented 7 years ago

I am new to using WQ-Review, and trying to do a basic data import according to the instructions provided in the vignette. I have a connection to the DSN, which my IT admin helped set up. As far as we can tell, it is set up correctly.

https://github.com/USGS-R/WQ-Review/blob/master/vignettes/WQReviewGUI.Rmd#a-basic-data-import

I am trying to pull all of the parameter codes for a site where I know that the data are approved and uploaded. I've tried both doing it by selecting all parameter groups, as well as by using parameter codes that I know we have data for.

I get different error messages when running this, sometimes I get : "Problem with data import, please check import criteria" "No samples exist in your local NWIS database for the date range specified, check data criteria"

Other times I get: "Problem with data import, please check import criteria" "Incorrect database number entered for qa.db"

Attached is a screenshot of my QW-Review GUI.

qwreview

tjmills commented 7 years ago

I am in the field this week but I can help trouble shoot next week when I return. The most likely cause is that your data are not stored in the database numbers you specified. Are you sure they are in 01 and 02?

Sent from my iPhone

On Mar 7, 2017, at 12:15 PM, bmccarthyqw notifications@github.com wrote:

I am new to using WQ-Review, and trying to do a basic data import according to the instructions provided in the vignette. I have a connection to the DSN, which my IT admin helped set up. As far as we can tell, it is set up correctly.

https://github.com/USGS-R/WQ-Review/blob/master/vignettes/WQReviewGUI.Rmd#a-basic-data-import

I am trying to pull all of the parameter codes for a site where I know that the data are approved and uploaded. I've tried both doing it by selecting all parameter groups, as well as by using parameter codes that I know we have data for.

I get different error messages when running this, sometimes I get : "Problem with data import, please check import criteria" "No samples exist in your local NWIS database for the date range specified, check data criteria"

Other times I get: "Problem with data import, please check import criteria" "Incorrect database number entered for qa.db"

Attached is a screenshot of my QW-Review GUI.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

bmccarthyqw commented 7 years ago

Thank you for your response, I'm not entirely sure they are in there. Is there a quick way for me to check? I just went with the defaults.

tjmills commented 7 years ago

So the database numbers vary center to center so you will need to check with your DBA as to where your data are. The majority of centers have 01 and 02 but MANY do not use those. Maybe fire up qwdata and see what it says at the top of the home menu. I think it shows the database number there

Sent from my iPhone

On Mar 8, 2017, at 7:25 AM, bmccarthyqw notifications@github.com wrote:

Thank you for your response, I'm not entirely sure they are in there. Is there a quick way for me to check? I just went with the defaults.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

tjmills commented 7 years ago

Also thanks for using the GitHub issues!

Sent from my iPhone

On Mar 8, 2017, at 7:25 AM, bmccarthyqw notifications@github.com wrote:

Thank you for your response, I'm not entirely sure they are in there. Is there a quick way for me to check? I just went with the defaults.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

bmccarthyqw commented 7 years ago

I just switched it to 01 and 01, and it worked. Thank you for your time!