Hi all,

I’ve seen a few topics here discussing the conversion of flat files into hierarchical IATI data. I’m attempting to do the reverse, and I’m interested in hearing your feedback.

The original idea was to create a flat file from IATI transactions and budgets that could fill-in for the gaps in the CRS (i.e. 2017 and beyond).

Here’s my work so far: https://github.com/akmiller01/iati_flat_testing

I’m not sure if this could be worked into a multi-purpose tool, given that whoever wants to flatten IATI data probably has different use-cases in mind, but maybe we could strip down some of the logic of splitting values by sectoral/recipient percentages.

Cheers,
-Alex Miller

Comments (11)

Mark Brough
Mark Brough

Thanks Andy Lulham – I also meant to reply on here so you beat me to it!

Alex Miller maybe we should also write down together, maybe in a GDoc, the assumptions we’ve made for how to handle data

Bill Anderson
Bill Anderson

A few questions for UNDP, UNICEF, FAO, WFP that may help us avoid double counting through multilaterals.

You all report Incoming Commitment and/or Incoming Fund transactions

  1. Do you have activities that are funded by a mix of core and earmarked funds. or are the two exclusive of each other?
  2. Is it possible to say that activities that include Incoming Commitment and/or Incoming Funds transactions are 100% earmarked funding?
  3. Do you add incoming commitment/funds to all activities with earmarked funding?

Abdul Riza Otto Reichner Sangita Dubey Steven Flower Alex Miller

Otto Reichner
Otto Reichner

Hi Bill,
WFP is a 100% voluntarily funded organization and has no core funding.
Therefore all incoming funds reported by WFP are according your definition ‘earmarked’.
Rgds
Otto

Abdul Riza
Abdul Riza

We do have projects at UNDP that are funded by a mix of core and earmarked funds and we publish incoming commitment and incoming funds for all projects. When we publish the core contribution of a project, UNDP becomes the funding organization, and incoming commitment and incoming funds transactions are added with reference to UNDP as the provider organization.

  1. Yes
  2. No. UNDP publish it for all activities
  3. Yes
Bill Anderson
Bill Anderson
Image removed. markbrough:

maybe we should also write down together, maybe in a GDoc, the assumptions we’ve made for how to handle data

Great idea
+1 to that

Steven Flower
Steven Flower

Hi Bill Anderson

I can’t speak directly for FAO , but know that in their IATI publication the Incoming Fund transactions represent funding that is directed to that activity/project. In all cases (I think) there is a named donor for each project. This is also cited in the IF transactions.

Example: http://d-portal.org/q.html?aid=XM-DAC-41301-640544

One next step for FAO would be to connect together with the donor project, where applicable: https://devtracker.dfid.gov.uk/projects/GB-1-204019/


Please log in or sign up to comment.