...
In this sprint release document, the features below and defects are below have been resolved and deployed to the production FDW/FDE server.
Improved performance for refreshing the Data Point Facts materialized view
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-46 Searching for Exchange Rates by Country Name
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-94 Separate Border Point from Market
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-96 Support GeoJSON format extracts in DataPoint APIs
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-130 Implement an OpenAPI Schema to make it easier to use the REST API
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-134 Improve speed of FDE tables, maps and charts by only extracting required fields
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-136 Associate the document type based permissions to the FEWS NET Staff and FDE Only roles
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-145 Update Mayan to 3.3
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-149 Upgrade Pandas to 0.23.4
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-155 Price Saved Data Sets screen doesn't show FEWS NET Only "tab"
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-170 Ag datasets marked "FEWS NET Only" should be "Public". 4 still need to be changed
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-180 Fix Admin Unit Generation Issues
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-80 Correct Mayan database credentials
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-146 Cached Geography Filter for Crop Production tab in FDE is not working
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-156 In the crop data domain, Admin units of the country Brazil are shown under the drop down list of International
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-166 Incomplete form in offline Data Upload admin screen
Jira Legacy server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 465680f2-b1d7-3a12-9839-d422a302553f key DATA-173
...
This feature is about making change on a `warehouse_datapointfacts_view` so that is it excludes Data Points that are Crop Production Indicator Values (using the
specialization_type
) and check checks on the difference in time to refresh the view before and after the change, which as a result improves performance for refreshing the Data Point Facts materialized view.
Searching for Exchange Rates by Country Name
Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
This feature is about allowing users to search the exchange rate by country name and in addition to this , the calculated name of the exchange rate data series has also been changed to include `from_currency_iso_en_name` and the `to_currency_iso_en_name` as shown below:
...
Separate Border Point from Market
Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
This feature is about separating the border point Border Point value from the Market, i.e the Border point Point becomes a separate list under the subclass sub-class of the Geographic unit like shown below:
...
This feature is about implementing GeoJSON format extracts in DataPoint APIs which APIs, which as a result, will be used in GIS tools for generating Maps ,,, etc.
Implement an OpenAPI Schema to make it easier to use the REST API
Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
This enhancement is about implementing an OpenAPI Schema to make it easier for users who wish to make API requests to use the REST API.
Improve speed of FDE tables, maps and charts by only extracting required fields
Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
This enhancement is about associating the document types to the Groups of
FDE Only
&FEWS NET Staff
i.e so that the users which are assigned to the groupFDE Only
can access only the documents which they are allowed to access and can can only view theData Explorer
, whereas the users which are assigned to the groupFEWS NET Staff
may access all the total documents and can also access/view theData Explorer & Data Management
.
...
This task is about upgrading Mayan to 3.3 and this upgrade introduced key major changes in the user interface of the Mayan system by introducing the features listed below:
Increasing the role label field size from 64 to 128 characters
Darkening content area when opening the mobile menu
Hiding the multi-item selection help text on mobile screens
Removing body spacer HTML and JavaScript. Not needed with the new UI
Adding support for icon shadows
Back porting the vertical main menu update
Adding support for menu inheritance
Convertingdocument Converting document image cache to use file cache manager app. Add Added setting DOCUMENTS_CACHE_MAXIMUM_SIZE defaults to 500 MB
Using timezone aware date for document statistics
Updating mayan_statistics migration 0002 to rename duplicate slugs
Removing index create permission as an ACL permission for indexes
...
o Username color on mobile screens not being user friendly
o The Mayan statistics app that fails to render correct value when the current month is December
...
Since FDW depends on the Pandas library to perform statistical calculations and data re-sampling and we were using version 0.22 which is very old. So this task is upgrading upgraded Pandas to 0.23.4, which is a much more modern version.
Price Saved Data Sets screen doesn't show FEWS NET Only "tab"
Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
There were crop datasets which were sourced from the Public, but these datasets had the visibility type of a FEWS ‘FEWS NET Only Only’ so this task is was to change these datasets to Public type of visibility and it is donethe ‘Public’ visibility type.
Resolved Defects
...
For about 41 countries the FNID codes of the Admin 0 units were missing the year component and it is now resolved for all of these countries.
...
On Crop data domain, the Geographic filter took far longer minutes to popup its values than it should have, and now the performance has been improved to be more consistent with the other values' performance.
...
In the crop data domain, Admin units of the country Brazil are shown under the drop down list of International
Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
Admin 3 units of some countries were shown as list of countries under both M49 or FN Regions, which was incorrect, and this has been resolved.
...
There was an issue on the data upload page, i.e when one clicks on , the
Add data upload
button it results in the screenshot below i.e , . Users were unable to select theFile
,Import format
,subtype
, andsubtype
fields or theFile
field only will be were hidden like you see in the screenshot below, and this was resolved so that the fields are now selectable.
...