...
Add a Data Collection is recommended for uploading monthly data.
Import Data Points is recommended for small bulk uploads of historical data or corrections. Each data collection must be created separately.
Offline Data Uploads is recommended for large bulk uploads of historical data or corrections. When using this method, users will not receive immediate feedback on the success of the upload.
Add a
...
New Data Collection
From the system wide menu bar, select Data entryEntry > Add a new New Data collectionCollection.
Begin filling out the form. Note: (*) represents a required field:
*Source document: Specify the Data Source Document as an Excel worksheet attachment, or manual entry.
*Publication name: Enter the publication name.
*Collection date: Specify the collection date of the data series included within the data source document.
File: Upload an Excel worksheet as an attachment. If no attachment is provided, the user will be redirected to a screen allowing for manual data entry.
Complete additional fields as applicable:
Status: An indicator for the current status of the Data Source Document. Default status during the Data entry phase is Draft.
Status changed: A tracking feature that records the date, time, and action taken regarding changes in status of a Data Source Document.
Import log: For tracking notification warnings or errors, a log file is generated after the creation of every data collection. Warning notifications are sent to the FEWS NET Home Office Markets and Trade team to make the relevant corrections. This action ensures the Alias Market name is specified correctly, and that the appropriate data series are identified.
Collection periods: Specify the collection periods of the data source document.
Start date: The start date of a collection period, usually the first day of a month.
Period date: Refers to the last day of a collection period. If set to monthly, it will be the last day of that same month.
Notes: A text field for notes and comments to improve context.
When ready, click on either the Save, Save and add another, or Save and continue editing buttons to save the data into the system and prepare it for processing. The system will display a message confirming the success of the saving operation.
Save: Save and return to the Data entry homepage.
Save and add another: Implies adding another data collection. Once the current one is saved, the system redirects the user to a similar window to repeat the process as many times as desired.
Save and continue editing: The system allows a user to save the current work and continue editing which serves to minimize the loss of entered data in case of a poor internet connection.
Manual
...
Data Entry
In cases where an Excel worksheet is not loaded, a user can enter values and set the status manually.
| Info |
|---|
Note: Previous Price and Percentage Change will only be recognized or appear automatically if values were entered for the previous period (the last day of the previous month). This field is not required. |
Status options
Collected: Most common status. It means there is a value for the Data-Point in the Data Series for this Data Collection Period.
Not Collected: The Enumerator did not collect the price (a value for the Data Series) this month (for this Data Collection Period), and availability of the product is unknown.
Not Available: The Enumerator attempted to collect the data (a value for the Data Series for this Data Collection Period) but the product was not on sale/available in the Market.
Missing Historic Data: Should not be used by the Field Office because this status does not involve any new data. Concerns missing prices from historical data uploaded in bulk by Home Office: The data is not present in FEWS NET’s historic data; Unclear whether it was not available or not collected.
Bulk
...
Uploads
The Import data pointsData Points and Offline data uploadsData Uploads screens should be used to bulk upload historical data or corrections. It is best to use Import data pointsData Points when possible as this allows changes to be reviewed before the import is finalized. However, this option can be time consuming when there is large amounts of data so Offline data uploadsData Uploads should be used for large uploads.
Import
...
Data Points
Data series can be imported in the following formats ( XLS, CSV, TSV, ODS, HTML, JSON, and YAML ). To import data series, follow the steps below:
From the system wide menu bar, select Data entryEntry > Import data pointsData Points, and choose an item from the sub-menu.
Click the Choose File button and choose a file to upload.
Specify the file format that will be imported using the Format drop-down list.
Click Submit to start the import process.
Once the file is uploaded, the system will display the summary including:
New: the data in the file that will be imported.
Updated: the data in the file that are updates to existing data in the system.
Delete: the records in the file that will be deleted from the system.
Skip: the records in the file that will be skipped.
Error: the records in the file that have errors in the data and will not be added to the system.
Total: total number of records in the file.
To continue with the import, select Confirm importImport. The data series will be imported and a confirmation message will appear when complete.
Offline
...
Data Uploads
The Offline data uploadsData Uploads screen displays all the data upload records in the system together with their status, data domain, country information, and the user who initiated the upload process.
...
From the system wide menu bar, select Data entryEntry > Offline data uploadsData Uploads.
Click the Add Data Upload button.
Choose the File.
Select the Import Format.
Select the Country.
Click Save, Save and Add Another or Save and Continue Editing.