browser issueshttps://gitlab.inf.unibz.it/lter/browser/-/issues2023-10-25T14:26:31+02:00https://gitlab.inf.unibz.it/lter/browser/-/issues/137SWC parameters - wrong filtering2023-10-25T14:26:31+02:00Zandonai AlessandroSWC parameters - wrong filteringSome parameters: swc_cst_avg and swc_lst_avg, etc. are filtered as Soil temperature, whereas they are Soil Water Content and their substrings "cst" and "lst" indicate the measurement plot.
I corrected a rule in [WebApp Internal - Parame...Some parameters: swc_cst_avg and swc_lst_avg, etc. are filtered as Soil temperature, whereas they are Soil Water Content and their substrings "cst" and "lst" indicate the measurement plot.
I corrected a rule in [WebApp Internal - Parameters Grouping Rules.xlsx](https://scientificnet.sharepoint.com/:x:/r/sites/LTERDB/Shared%20Documents/WebApp/Labelling/WebApp%20Internal%20-%20Parameters%20Grouping%20Rules.xlsx?d=w6261df149a5a42199b45dc5ab949e0bd&csf=1&web=1&e=8wbkKW) and now it should work
old rule:
st_ --> Soil Temperature
new rule:
st_ & ~(cst or lst or tst) --> Soil Temperature
please, could you update your script?
@Luca.CattaniMartin PalmaMartin Palmahttps://gitlab.inf.unibz.it/lter/browser/-/issues/136Add to maintenance menù - missing & new stations parameters2024-02-16T08:58:43+01:00Zandonai AlessandroAdd to maintenance menù - missing & new stations parametersIn the data browser maintenance menu are missing some stations parameters.
Thus, I'd like to add the parameters written in red, in the sheet "Parameters & Flags" of the following file [WebApp Internal - Parameters Grouping Rules.xlsx](ht...In the data browser maintenance menu are missing some stations parameters.
Thus, I'd like to add the parameters written in red, in the sheet "Parameters & Flags" of the following file [WebApp Internal - Parameters Grouping Rules.xlsx](https://scientificnet.sharepoint.com/:x:/r/sites/LTERDB/Shared%20Documents/WebApp/Labelling/WebApp%20Internal%20-%20Parameters%20Grouping%20Rules.xlsx?d=w6261df149a5a42199b45dc5ab949e0bd&csf=1&web=1&e=KuK357)
Probably I missed to include some parameters, because the addition in the table isn't performed in automatic.
Shouldn't be easier, more reliable, without delays due to the manual update, a different approach to keep up to date data browser maintenance menù, if instead to update it manually, we apply an "exclusion rule", that in this menù must be present all the parameters not present in the main menù? I could manage the necessary information, flagging in the table all the parameters present in the main menù.
@Luca.CattaniMartin PalmaMartin Palmahttps://gitlab.inf.unibz.it/lter/browser/-/issues/121Empty result of query2022-09-06T12:54:27+02:00Zandonai AlessandroEmpty result of queryIf for some reason (eg "wrong" time range selction) the query result is empty, instead of the download form appear just a blank page; in these cases would useful generate a pop-up message like "the query result is empty, please, try agai...If for some reason (eg "wrong" time range selction) the query result is empty, instead of the download form appear just a blank page; in these cases would useful generate a pop-up message like "the query result is empty, please, try again making a different selection" or something like thatMartin PalmaMartin Palmahttps://gitlab.inf.unibz.it/lter/browser/-/issues/116Query results CSV file - columns ordering by parameters NAME, DEPTH and AGGRE...2022-05-18T08:27:37+02:00Zandonai AlessandroQuery results CSV file - columns ordering by parameters NAME, DEPTH and AGGREGATION (Avg, Smp, Min, Max & StdDev)* [ ] About the query results in the CSV file, I have a request if it is possible to implement it: In the file, the parameters columns are ordered by Stations and this is ok, but inside the same station all the parameters are not in orde...* [ ] About the query results in the CSV file, I have a request if it is possible to implement it: In the file, the parameters columns are ordered by Stations and this is ok, but inside the same station all the parameters are not in order. After the stations ordering it could be possible automatically order the columns by parameters name (string without depth "xx" and aggregation "yyy" chars), then order by depth (if present) and finally by aggregation, if possible in the following order (Avg, Smp, Min, Max & StdDev)? This could be in general much useful to avoid confusion, especially downloading Soil water content, soil water potential and soil temperature where we can have many similar parameters, where change just the depth, or the plot; to manage this, in excel is almost mandatory manually order the columns.
Example (here miss only the aggregation ordering)
RIGHT NOW:
| b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 |
|----|----|----|----|----|----|----|----|----|----|----|----|
| st_b | st_b | st_b | st_b_00 | swc_st_a | swc_st_a | swc_st_a | swc_st_a | swc_st_b | swc_st_b | swc_st_b | st_b |
| 50 | 20 | 10 | | 50 | 2 | 5 | 20 | 2 | 5 | 20 | 5 |
ORDERED:
| b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 |
|----|----|----|----|----|----|----|----|----|----|----|----|
| st_b_00 | st_b | st_b | st_b | st_b | swc_st_a | swc_st_a | swc_st_a | swc_st_a | swc_st_b | swc_st_b | swc_st_b |
| | 5 | 10 | 20 | 50 | 2 | 5 | 20 | 50 | 2 | 5 | 20 |
* [x] still miss the "00" depth indication in the downloaded file ("st_b_00" parameter)Martin PalmaMartin Palmahttps://gitlab.inf.unibz.it/lter/browser/-/issues/113Fields of "no data" collection2022-03-15T09:17:36+01:00Zandonai AlessandroFields of "no data" collectionAt the moment, when I set a range of dates which partially includes a period prior to the data is present in the DB, this period is in any case exported to the csv file, even if it has no information content (all the timeseries in the cs...At the moment, when I set a range of dates which partially includes a period prior to the data is present in the DB, this period is in any case exported to the csv file, even if it has no information content (all the timeseries in the csv start with a series of "NaN").
Is it possible to insert a control that, if none of the selected stations, for not even one of the selected parameters, contains a value different than "NaN", then that record is not reported?
In other words, start with the first date containes at least one parameter has a value different than "NaN".
| station | b1 | b2 | b3 | i1 | i3 | m4 | m5 |
|------------------|-------------|------------|-------------|-------------|-------------|-------------|-------------|
| landuse | me | me | me | me | me | pa | pa |
| latitude | 46.66121887 | 46.6862577 | 46.69173286 | 46.68700896 | 46.6840937 | 46.74048467 | 46.70135815 |
| longitude | 10.59024912 | 10.5798452 | 10.59188535 | 10.57969321 | 10.58166556 | 10.69699228 | 10.61585587 |
| elevation | 990 | 1490 | 1930 | 1490 | 1430 | 1986 | 1823 |
| parameter | batt_v | batt_v | batt_v | batt_v | batt_v | batt_v | batt_v |
| depth | | | | | | | |
| aggregation | std | std | std | std | std | std | std |
| unit | volts | volts | volts | volts | volts | volts | volts |
| 2018-12-25 00:00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2018-12-25 00:15 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2018-12-25 00:30 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2018-12-25 00:45 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |Martin PalmaMartin Palma