Skip to end of banner
Go to start of banner

Preparing Data and Using Templates

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Preparing Data for Upload

To ensure a successful upload of data:

  • Data values must be accurately matched to their column headings.

  • Column headings must be recognized by FDW. When uploading ad hoc data, column names may need to be adjusted.

  • Metadata values must be recognized by FDW. New metadata must be added through the data series or metadata importing screen.

Use of Templates

IPC Classification Data

  • The IPC classification data template provides data for four source documents which can be FSO, FSO Internal, FSOU, FSA and KMU select.

  • You can simultaneously upload Food Security Area Classification, Humanitarian Food Assistance (HFA) and Internally Displaced People (IDP) data. Separate data collections will be automatically created for Food Security Area Classification and HFA data.

  • The source document must align with the date range included in the template or data will not be uploaded. Data collection should be uploaded one month at a time. The collection date should always be the first day of the month. 

  • The first month in the data collection period includes the CS (current situation), ML (near term projection three months), ML2 (medium term projection six months). The outlook collection date is the first date from the current state through four months. A new collection date begins after four months.

Food Assistance Outlook Brief (FAOB) Data

  • The FAOB template allows multiple data collections to be created from one upload (public and internal population estimates, and public and internal highest household).

  • Preparing internal and public FAOB data in the template will fall under one of the following three scenarios:

    • Public and internal data values are the same:

      • Provide values in the columns for public data and leave the columns for internal data blank. FDW will ascribe the values to both the public and internal source documents. 

    • Public and internal data values differ:

      • Provide values in the columns for public and internal data. FDW will separate out the data into the public and internal source documents. 

    • Internal data only:

      • Provide values in the columns for internal data, and either:

        • Specify NA values in the columns for public data to include the country as not analyzed in extracts of that month’s public data, or

        • Leave the columns for public data blank if you plan to add public data at a later time. If the values are blank, the country will not be reflected in extracts of that month’s public data.

  • No labels