Document toolboxDocument toolbox

Release Notes for Data Sprint 21.10

Owned by Hamelmal Kiros
Last updated: Nov 12, 2021 by Andrew Somers
5 min read

Dated: 12 November, 2021

Introduction

The following list of new features, tasks and resolved bugs are included in the latest Sprint 21.10.2 release to FDW/FDE:

Features

Tasks

Bugs

Features

Price availability validation https://fewsnet.atlassian.net/browse/DATA-972

  • This enhancement is about adding a validation error message, which is stated as: Availability should be set to 0 (Zero) or left empty for unavailable prices, for adding an availability value other than zero for the Not Available data point values.

Replace the Southern Africa Cross-Border Trade on Data Centre with a direct download from FDW https://fewsnet.atlassian.net/browse/DATA-1064  

Operationalize FAOB Ingestion https://fewsnet.atlassian.net/browse/DATA-1110

  • This feature is about introducing a pipeline that imports FAOB data into FDW. While this feature enables the functionality, there will be future work to improve upon the user interface and allow the project to utilize the data more effectively.

Enhancements to Market Price Time Series extracts https://fewsnet.atlassian.net/browse/DATA-1129

  • This feature is about enhancing the time series extract of the market price data across multiple areas (for instance, https://fdw.fews.net/api/marketpricefacts/?format=html&timeseries=true&dataseries=6453165) which includes the following:

    • Showing Country or Geographic Region for the national-level Exchange rates columns.

    • Adding new metadata heading column after the last exchange rate and before the first secondary price index with the same values except using "base value" instead of "unit" and "name" instead of indicator_type.

    • Updating the existing second metadata heading column that appears before the first exchange rate so that it uses "-" instead of "base period"; "rate type" instead of "indicator type".

    • Removing prefix from the base value and base period metadata values.

    • Using “Collected" instead of "Stored" as the "field_source” for the Exchange Rate and Secondary Price Index data series which are retrieved from the system.

    • Using the actual indicator name of the exchange rates , such as e.g. "Domestic Currency per USD" instead of the generic "Exchange Rate".

    • Rounding Exchange Rate Values to 8 decimal places.

    • Populating the Latitude and Longitude metadata for the Market-level exchange rates.

Create specific viewsets for calculated data series https://fewsnet.atlassian.net/browse/DATA-1135

Add "Fare" to market products price_type https://fewsnet.atlassian.net/browse/DATA-1178

Use Direct ExchangeRate api end point when filtering/searching exchange rates other domain by country https://fewsnet.atlassian.net/browse/DATA-1180

  • This feature enhanced the search and filter capabilities of the Exchange Rate data series endpoint (/api/exchangerate) so that it searches all country currency assignments instead of just the country assigned to the Data Series.

Remove Copyright footer and add Rights Disclaimer page https://fewsnet.atlassian.net/browse/DATA-1181  

Allow `NOT_COLLECTED` data points to be reported and imported in a generic way https://fewsnet.atlassian.net/browse/DATA-1201  

  • This feature is about allowing the generic import of data points with a Not Collected status which later can be replaced with the actual status and data values.

Review Other domain end points to ensure they point to their specific end points for specific metadata https://fewsnet.atlassian.net/browse/DATA-1206

Tasks

Commodity Balances historic data upload https://fewsnet.atlassian.net/browse/DATA-820

Change drupal node title from Central America and Caribbean to Guatemala and Haiti https://fewsnet.atlassian.net/browse/DATA-1200

  • This task was about making Drupal node title change from Central America and Caribbean to Guatemala and Haiti on the http://fews.net website.

Bugs

The buttons “Download “ , “Browse” , “Chart” and the “Excel Web Query URL” are missing from the price data set page of the FDW https://fewsnet.atlassian.net/browse/DATA-1189

Upon creating calculated indices (https://fdw.fews.net/en/admin/price/calculatedindex/add/), the Owner dropdown field doesn’t populate the username of the user that logged in https://fewsnet.atlassian.net/browse/DATA-1190

New price data information for Zimbabwe is not recognized by the FDW https://fewsnet.atlassian.net/browse/DATA-1207

  • There was a problem in the system recognizing the price data for the country Zimbabwe and this was resolved and the metadata successfully loaded.