About the Data
Commodity balances show the balance of staple foods. The purpose of this domain is to show the consumption, import, and export of these staple foods for each country.
...
Country
Item (Indicator)
Crop (Commodity)
Data Source Document
Values (periods as one column or multiple periods/columns)
| Note |
|---|
| Tip |
It is best practice to use the same indicator and crop names as used in previous periods if possible. |
Currently, the FDW will recognize the following column headers: datasourcedocument , data_source_organization , data_source_document , schedule , data_usage_policy , country , geographic_group , fewsnet_region , start , end , id , created , modified , specialization_type , name , description , metadata , geographic_unit , indicator , is_calculated , _search , _country , datausagepolicy , original_data_source , product , unit , dataseries_ptr.
| Note |
|---|
Important: If you regularly receive a document from a non-FEWS NET source that contains alternate column headings, do not edit the column headings every time. Instead, submit a help desk ticket so the Hub can add the headings as aliases to the system. |
If the unit type is not specified, the default unit type will be used:
...
Importing Commodity Balance Sheet Data
Commodity balance sheet data must be uploaded twice: under Commodity Balances and Commodity Balance Values.
Go to Dataseries Management > Commodity Balances > Commodity Balances.
Click Import Commodity Balances.
Click Choose File and select your spreadsheet to load the file.
Load Click Submit and the same file from Step 1 into the Commodity Balance Value screen. Select: file will be in draft status.
Go to Dataseries Management > Data Points > Commodity Balance Value. Utilizing the same file in Step 1, click the Values.
Click Import Commodity Balance Values button and upload the file in the appropriate format. .
Click Choose File and select the same spreadsheet to load the file.
Click Submit and the file will be in draft status.
...