codeforIATI / iati-data-bugtracker

🐛 A public log of issues with IATI data and metadata
https://bugtracker.codeforiati.org
3 stars 0 forks source link

AfDB Disb transactions now missing aid/finance type w/28 Sept update #43

Open sarahshamiso opened 2 years ago

sarahshamiso commented 2 years ago

Explanation of the issue

I'm preparing data for the government of Tanzania and downloaded the TZ transactions file from CDFD on 29 Sept. This data contained aid and finance type for all AfDB transactions. Then on 10 Oct I downloaded the files again and aid and finance type are still there for outgoing commitments but missing for disbursements.

URLs / screenshots

Discussed with @markbrough and he shared the following screenshots of the XML showing that this data is reported for commitments but not for disbursements. No default aid/finance type is reported either.

image_2021_10_11T12_45_08_068Z

image_2021_10_11T12_45_36_453Z

Does the publisher know?

Have alerted the tech team.

IATI registry identifier for the publisher

afdb

Additional context

When orgs don't report this data it makes it very difficult for a government to use it, particularly finance type which categorizes the resources between grants and loans. In the case of Tanzania, there is interest in analyzing the allocation of grants vs loans over time and this is very difficult to do when $186 million in resources (for 2020 only) are not allocated to one of these categories. Also, for data users, this kind of unpredictable removal of needed data is what creates lack of trust in the data.

TZ 29 Sept 2021.xlsx TZ 11 Oct 2021.xlsx

PetyaKangalova commented 2 years ago

@sarahshamiso and @markbrough I talked to AfDB and they have updated their data on 14 October and can see that aid and finance types are reported at the transaction level for disbursements: https://www.afdb.org/sites/default/files/iati/iatitanzaniadata.xml See an example: image

As I understand, there were changes to their systems which might have caused the issue. Let me know if data is still missing for specific activities and I will double check and get back to AfDB.

markbrough commented 2 years ago

Amazing - thanks @PetyaKangalova. Indeed this seems to have updated nicely in Datastore Classic already: https://datastore.codeforiati.org/api/1/access/activity.xml?reporting-org=XM-DAC-46002&recipient-country=TZ&limit=1

However,

(1) there are still some transactions (appears to be Government of Tanzania counterpart funding) that are missing aid types / finance types: image

See for example this activity: https://datastore.codeforiati.org/api/1/access/activity.xml?unwrap=True&iati-identifier=46002-P-TZ-A00-002

(2) the AfDB reporting organisation code has changed from 46002 to XM-DAC-46002, but the IATI Registry publisher account has not yet been updated to reflect this change. Please can this be done, as various tools rely on this data?

Many thanks!!

andylolz commented 2 years ago

(2) the AfDB reporting organisation code has changed from 46002 to XM-DAC-46002, but the IATI Registry publisher account has not yet been updated to reflect this change. Please can this be done, as various tools rely on this data?

39 raises that same issue. It looks like it has now been addressed, see: https://iatiregistry.org/publisher/afdb

PetyaKangalova commented 2 years ago

Thanks @markbrough and @andylolz . Yes, the organisation identifier is now correct on the IATI Registry. I'll follow-up with AfDB about the example you shared above. I cross-checked and indeed the finance and aid type are missing.

image

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

markbrough commented 2 years ago

The missing aid-type and finance-type is still an issue.

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

sarahshamiso commented 2 years ago

Definitely still an issue. I combined the outputs from CDFD to get a full picture of AfDB data to try and assess if there was some kind of trend to the omission of aid and finance types. Didn't immediately see one but attaching if anyone else wants to take a look. AfDB_finance aid type issues.xlsx

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 years ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 year ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 11 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 10 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 9 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 8 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 7 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 6 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 5 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 4 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 3 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 months ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 1 month ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!

codeforIATIbot commented 2 weeks ago

Hello! There has been no activity on this issue in the last 30 days. I wonder if it has now been resolved?

If you’re reading this, would you mind checking to see if the issue is still applicable?

Thank you!