cuahsi / azure-hydroservertools Goto Github PK

User: Hydroservertest1
Browser: All
Data Table: DataValues

Need to do a quick once over of the error messages. The one I found said "The value 536 is not in SampleID Table. Please validate you input." (should be your)

Please capitalize letters so the end reads "Need help? Contact the WDC staff."

Username: hydroservertest1
Browser: all
Data Table: Categories

Uploaded a file with incorrect values. Upload completed normally, but the two rejections did not have a detailed error message ("No additional information available")

I'm trying to search/filter while viewing the Variables table and I don't think it's filtering properly all the time. Here is the full list:

I'm trying to filter on a variable code (DIN) and no records are listed once I filter:

You can reproduce this using the database associated with [email protected] ...I won't remove the data from there before we talk about this.

Is there a case where someone would have multiple WOFS, and subsequently, multiple Hydroservers? Right now, it is a 1:1 relationship between the google account to the hydroserver, and the google authentication only allows one username (if the user is logged into the browser or gmail, it takes that as the default). Typically there would by a log out or some way to navigate to the other hydroserver with the same log in credentials, but right now you need to remove the good account and clear your browsing data.and log in with a different set of google credentials

Remove link for ISOmetadata template since we have decided to include in Sources template.

Create a new landing page with summary. Something like:
"HydroServer is an application for sharing time series water data. It has three components:

1. An instance of the Observations Data Model (ODM) SQL Database in the Azure Cloud
2. An application for uploading data to the ODM Database using CSV templates
3. A WaterOneFlow Web Service for exposing the database

To begin, download the ODM Templates and populate them with your data and metadata. Next, upload your data and metadata using this portal. Finally, register your web service and database with CUAHSI’s central catalog, HIS Central [link to: hiscentral.cuahsi.org].

Need help? Contact the WDC staff [link to: wdc.cuahsi.org/WDC/Contact.html]."

Currently this is the error message for a return character (because it is invalid for XML):

The reason for this invalid character may not be apparent to users. Can we improve the precision of this message?

Illegal character in NoDataValue returned a DataTypeCV error:

I entered "x" for a NoDataValue. VariableUnitsName was invalid because of capitalization.

If one of these fields are included, then so should the rest: LocalX, LocalY, LocalSRSName

"Nitrogen, dissolved inorganic" was rejected despite being include in VariableNameCV (with matching capitalization). I am wondering if this is somehow related to the VariableUnitsName being rejected (because of mismatch capitalization):

Since it takes a few moments to clear tables, a progression bar should be added so that the user knows that application is working to complete task.

Upon clicking Commit changes, I received a message that "An error occured. Please resubmit...or contact user support." Then, a new message appeared that the records were added successfully:

It appears that the records were successfully added despite the first error message.

Add count to tab headers. For example, "New (7), Rejected (5)"

QualityControlLevels, GroupDescriptions failed download. Same error for both (404).

I believe we decided to remove the Previous/Next buttons. They are gone from the Sites tab, but still appear in others:

In the Association Form, both fields are currently displayed as Email. I think one of them should be user name?

Username: hydroservertest1
Browser: All

Issue: Exception raised saying "an error occurred while executing the inner command definition. See the inner exception for details" and it did not progress to upload summary page

Steps to reproduce: 1. Navigate to DerivedFrom import dialogue, 2. Select "Add file", 3. Choose the correct file, 4. Select "Start Upload"

Add the ability to update controlled vocabulary (by individual CV table) on the Manage Page.

1. Added becomes New
2. Rejected stays Rejected
3. Edited becomes Updated
4. Duplicate stays Duplicate

Can we re-order them as numbered above as well?

I inputted an invalid value for NoDataValue and the message identifies it as a CV. The message should identify the value as invalid, but the field is not a CV:

I cleared all tables, but the number of values in the Methods and Lab Methods show 1:

Is ODM pre-populated with these rows? They are describing Unknown/Unspecified methods.

I left my browser open in the validation step (prior to committing) and it was cleared after 10-15 minutes. Is it possible to add a countdown and/or warning message so that the user doesn't have their session "disappear"?

Table seems to be missing the LocalSRSName field:

Should be placed in the column to the right of Local Y.

I uploaded a sites file and before committing changes I clicked Cancel. This message was returned:

When a user clicks cancel, the user should confirm, then data should be cleared from the cache, and the user should be returned to the Import Data landing page (Home).

Create new page where users can download templates. Also to include instructions on how to use templates, information about ODM, etc.

I uploaded a spreadsheet and it went through the validation. Then, I clicked the Next button and my validated data disappears. If a user clicks Next before committing changes they should be prompted with a warning.

I have uploaded a file with 4 rows for the Sources table, but when I view the Sources data there are 10 records. 1 record appears 4 times, 1 record appears 3 times, 1 record appears twice, and 1 record appears once.

Also, when the table is cleared, should SourceID begin auto-numbering at 1? As it is now, it continues to count up (i.e. if you wipe the table and it has 5 records, then when it is populated again the first record will have a SourceID of 6).

The column for Title is not wide enough; words are forced to be carried down to the next line. Is there anything we can do so that words are not cut off as often?

For example, so a user can click and verify that the link is correct in the validation step:

It looks like the search is case sensitive - does that make it too specific? Should it not be case sensitive?

Add iFrame for request form on landing page. I think we should move the current text to a left column and add the form to the right. I also think we should move the log in button to the upper right of the page to match HIS Central.

Some of the exported .csv files don't seem to be formatted correctly. DataValues and Sites have an issue about what column is being populated with errors while Variables does not. It may have something to do with the DataValues and Sites both had unpopulated columns (i.e. fields with null values) preceding the errors column while the Variables did not...but that is only a guess.

DataValues:

Sites:

I think we should add a vertical scroll bar for panning inside of the panel as shown here:

I also think we should shorten the height of the table so that the user doesn't need to scroll so far down the page.

In the Sites template/table, if the field Elevation_m is provided then VerticalDatum should be required. Currently, the uploader allows you to have an elevation without a corresponding datum.

Some rows of rejected DataValues are not expanding properly to view the error message. I had 91 rejected, and used the dropdown to select showing 100 entries at once. Only a handful of rows had this issue:

There is a typo on the templates page. Please remove the "(" from "DerivedFrom Template".

As it is, you can list up to 100 entries on one page. This is probably good for all of the other tables, but with DataValues users are likely to be handling thousands of records at once.

When you are sorting, the processing dialogue that pops up has text overlap issues (all browsers). Please make this box larger to accommodate the text

For the statistics on the home page, the title should read "Number of Values by Table"

I tried to upload the Variables Template on the Sites page and received this message:

We should probably have an improved message identifying that the user has attempted to upload an incorrect template.

username: hydroservertest1
data: sample_1000_char.csv

Steps to reproduce: Upload all of the previous tables in order, then upload sample_1000_char.csv through the samples import. An error message pops up staying that there is a missing required value, and that value is the LabMethodID.

According to the ODM template, LabMethodID is not required for the samples table, and is not in the template at all. As a result, this message is confusing. Is the error populated from an issue further up the ODM model?

It appears as though SpeciationCV and VariableCV are being confused in the validation step:

Samples template needs to include LabMethodID, which the user will have to look up after uploading LabMethods template.

User: hydroservertest1
Browser: Chrome

Issue: After a successful import of the corrected rejections, the corrected values are still shown as "rejected". The associated error messages reference the previously rejected values

We should build out the Manage page to include more functionality, but let's start with summary information. This can include: Number of Sites, Number of Variables, Number of Time Series, and the URL for the web service.

User: hydroservertest1
dataset: variables_characters.csv

Steps to reproduce: Upload file and view rejections. Rejected value has ID of 3 and a units value of "cubic meter per second" which matches the value in the Units controlled vocabulary table. I checked it for illegal characters or extra spaces in notepad++ and there were none to be found, so in theory it should be good.

Uploaded

We need to allow users to upload values for controlled vocabularies that do not match the casing exactly.
As we discussed, the validation should be non-case sensitive matching, but the database will be populated with whatever case is in the CV database.

Unless we are supporting multiple files on upload, Add Files button should be singular (Add File). Also, we should gray it out if a user has added a file.

Username: [email protected]
Browser: All

Test Steps: 1. Go to hydroservertools.cloudapp.net, 2. Click the button to log in with your google account, 3. Log in with a registered username that does not have an attached Hydroserver DB (e.g. a personal email account) via Google Authentication.

Result: Unsuccesful log in, redirects to home page but clicking on the Google button to change the log in has no resulting action

Do we need an error message for this type of behavior? Initially it was dropping you on the landing page with no hydroserver information attached. Was changed to bringing you to log in page, but there is no message.