Comparing different IATI data publishing and validation tools
From January 2021, Aidstream, a popular International Aid Transparency Initiative (IATI) publishing tool, will charge for publishing more than 20 (project) activities. What are your alternatives for publishing tools and options to keep all of the fantastic financials and project results visible in the public domain against the international IATI standard?
IATI have compiled a list with some of your options, but we have also collected a list of suggestions for you, to see if one (or many) of the options below suits your budget, time available and organisational size.
Options for publishing your data to IATI
-
Publishing natively: you can upload your XML data set to the IATI registry directly if you have enough knowledge of XML and of the data standard to produce a valid dataset (you will need to validate your data against the standard using a validation tool). There is a handy IATI publishing checklist and the option to submit support requests to the IATI helpdesk. However, there will be a learning curve if this is the first time you are publishing to the standard.
-
Aidstream is a widely used publishing tool that now charges you to publish over 20 projects (known as activities) at a cost starting at $1,500 per year. It is a good option for smaller organisations without too many projects to publish, since you can then use it for free. You can upload data in bulk using CSV or add it manually, and it also has multi-user team options where you can log into the same website interface from various locations. There are also discounts for organisations based in the ‘global south’.
-
Spreadsheet2IATI Service by Data4Development will charge you (a bit more than Aidstream) to support your IATI publishing. The service uses spreadsheet templates where you input your data to then convert your spreadsheets to XML. In addition, the service includes helpful feedback on the data quality and adherence to donor guidelines (such as the UK Foreign Commonwealth and Development Office). There are different tiers of services provided depending on the complexity of your data, as well as a helpdesk and training service offered. You will retain ownership of the data. There are also discounts for organisations based in the ‘global south’.
Another option is to procure a wider Project Management application or Monitoring, Evaluation, Accountability and Learning (MEAL) tool for your project, programme or organisation that integrates publishing to IATI as one of its many functions. If you have the budget, dedicated personnel, and you have the time to build some of the foundations using existing project parameters, this could a good option for you to streamline systems.
You will likely have procurement checklists to follow, but some questions to consider when choosing a tool like this might include: can I trial a demo version? is it GDPR compliant? will it work on lower bandwidth? is it multi-user? is the software open source? is the cloud system based on a green server? is there a support team? is the service provider a business or non-profit? and do I retain ownership of the data?
Some options for you include:
-
Project Connect with an optional module on IATI, pricing available on request
-
TolaData is a user friendly and relatively cheap tool (pricing starts at 99 Euro a month) with a built in validated IATI switch, IATI pricing available on request
-
NGO Online can be aligned with the IATI standard, pricing is available on request
-
Akvo RSR (really simple reporting) is free to use if you have the coding skills (as the code is available on Github), or the platform starts at 25,000 Euro
-
DevResults has tiered pricing starting at $2,400 with a $28,800 set up fee
-
AmpImpact has a new IATI integration, pricing is available on request
Building something bespoke to publish to IATI using your own internal systems is probably the biggest initial outlay of expenditure, but could be cost-effective in the long run to line up internal reporting systems at large organisations with the IATI standard. There are open-source models you can replicate from Github (for example from DFID) but you will likely need to rely on web developers or in-house technical support to build an application. There could be future costs too, such as upgrades to the system/API if the standard changes over time and the current version depreciates.
Options for checking and validating your IATI data
Depending on the tool or method you choose to publish your data (and what this already involves in terms of checking data quality), you might want to validate your data against the standard before you hit the publish button. There are various options for doing this and the IATI data validator is the most useful tool for checking your data ahead of time. You will need to know how to correct any errors or complete missing data as result of identifying any problems though. The IATI Canary is another useful tool if you want to check your datasets are still complete over time, it might also be helpful if you are carrying out due diligence on a potential partner, or want to see how transparent a government donor really is!
Here are a few validation options:
-
IATI’s free data validator (built by Data4Development) checks data against the standard in an ad hoc manner using a URL, or it can check data in advance of publishing by uploading files. It comes with a useful Q&A document and the IATI team can offer technical support via the helpdesk service.
-
DataWorkbench IATI data Validator will validate data ad hoc or in advance of publishing, checking it against donor requirements.
-
D-portal’s free file checker by Development Initiatives will check your XML files for compliance with the standard before you publish to ensure it is a valid XML file.
-
IATI Canary by Publish What you Fund is an open-source validator that checks existing datasets for compliance, and can email you if datasets you want to follow break in the future.
-
Convert, Validate & Explore by Open Data Services Co-operative will help you convert file types between XML, spreadsheet or CSV, and will check whether the data is valid (you can either upload a file, add a URL or paste XML). It also provides some sample data formats for activities and organisations. It is free but there is no helpdesk service provided, and data is retained for 7-days.
Some wider questions to consider when you are choosing a publishing process:
-
How much time do you really have to either upload data or learn to use new tools?
-
How many people will collect and check the data to publish to IATI within your team?
-
Do you need the system and tools in multiple languages or with translations?
-
Do you prefer using an online web service or would you like personal help and advice?
-
Do you have the time to check the data against the standard or would you prefer this was done externally?
-
Do you want to tie yourself into a contract? Do you have allocated project or institutional funds that will pay for a chosen tool over the lifecycle of a project for which you are committed by a donor to publish data for?
How do you publish your IATI data? If you want to get in touch with our members who publish to IATI you can join the Alliance Community discussion thread, or if you would like to chat to a member of the Alliance team to discuss the tools you use and chat more about transparency, contact the effectiveness & learning team by email at admin@intdevalliance.scot
With grateful thanks to article reviewers for their comments and feedback. If you would like to provide further information or add a tool to the list, please email Laura@intdevalliance.scot
Join Scotland's International Development Alliance and be part of Scotland's international development community.
Resources
Scotland's International Development Alliance Strategic Plan 2017-2020
This strategic plan sets out the new direction of The Alliance and what it hopes to achieve by 2020.
Monitoring, Evaluation & Learning Guide
A guide to improve knowledge, increase confidence and success in Monitoring, Evaluation and Learning.
A basic introduction to logframes
Writing a logframe well is a necessary skill for anyone in the international development sector. Some donors request them as part of their funding application process.
Monitoring, Evaluation & Learning for Beginners
This paper is for those new to Monitoring, Evaluation and Learning (MEL) and want to increase their knowledge.
A Quick Guide to Theory of Change
Theories of Change are essentially about how we think that change happens. It is nearly always a mix of evidence and assumptions.
Partnership Guide
Partnerships are essential to our work but what makes a good partnership? This guide looks at best practice in developing, sustaining and disbanding partnerships.
Innovation Guide
There is a need for organisations working in the fields of development and humanitarian action to continually see if there are better solutions to the problems they are working with local communities to address.
Introduction to Fundraising
Fundraising is important for every organisation. This guide is an introduction to fundraising as well as a good practice guide.
Climate Change Bill Consultation Joint Submission
A joint submission to the Climate Change Bill Consultation from Oxfam Scotland, Christian Aid Scotland, SCIAF & Tearfund Scotland.
LGBT+ Inclusion in International Development Programming
A checklist for UK Aid Connect proposals that can help ensure LGBT+ communities do not continue to be left behind.
ODI Report - The politics of the results agenda in DFID: 1997-2017
In this report the ODI analyse how and why the results agenda emerged. Their primary focus is on the politics of the story, how it has intersected with DFID's management, and the response to these changes. They ask whether DFID's results management is fit for purpose; that is, does it reflect the UK's development ambitions?
DFID budget template for overhead costs
The Department for International Development (DFID) has developed a new standard budget template available for use from June 2019. It takes a standard format for capturing direct costs and overheads.
Members Guide to Accessing Funds Online
Funds Online is an extensive online database compiling over 8,000 sources of funding for organisations and individuals, from grant-making charities, companies and statutory providers. This guide explains how Alliance members can access this database.
Thematic Discussion: Disability
Presentations from the thematic discussions about disability with DFID and the Big Lottery Fund.
Lobbying Register Guidance
From Monday 12 March 2018 all regulated lobbying in Scotland, as defined in the Lobbying (Scotland) Act, will have to be registered on Scotland’s new Lobbying Register. You can find all related guidance and documentation here.
EU-AFRICA RELATIONS: STRATEGIES FOR A RENEWED PARTNERSHIP
Friends of Europe launches a major new report examining the strategies for a renewed partnership that tackles the changing geopolitical, development, social and economic challenges facing Africa and Europe.
Value for Money Paper
This paper tries to explain the very first principles associated with this term using both “formal” and “informal” resources hopefully helping you to start engaging with the concept and start answering simple value for money questions.
Scottish Government Main Grants Rwanda Zambia Feedback Session Notes
Scottish Government Main Grants Rwanda Zambia Feedback Session Notes
Welcome Letter to Secretary of State for International Development
This letter offers congratulations to the new Secretary of State for International Development.
Handy Hints - Fundraising
A four part series of guides developed by Helen Harvey about realising the potential of crowdfunding, corporate support, in-kind/pro-bono support and individual donors.
Safeguarding & Whistleblowing Example Policies
A range of example safeguarding and whistleblowing policies for organisations to read, review and adapt to individual contexts.
Effectiveness Toolkit and MOT
The Effectiveness Toolkit enables an organisation to review its work both against a set of principles of good practice in international development and benchmarks of good operational practice.
Scottish Government Small Grants Information for Applicants 2018
Information for Scottish Government Small Grants Programme applicants for the 2018 funding round.
The International Fair Trade Charter
How the Global Fair Trade Movement works to transform trade in order to achieve justice, equity and sustainability for people and planet.
Safeguarding Research Summary
This report provides the analysis of a small research project conducted by the Scottish Government and Scotland’s International Development Alliance with stakeholders in the international development sector.
Developing a Safeguarding Policy
This is a tool to help organisations develop their own safeguarding policies.
Top tips for better blogging
Top tips for better blogging from Susan Smith, Editor, Third Force News (TFN).
Leaving no-one behind in emergencies
CBM gave a presentation about practical ways to ensure humanitarian responses are inclusive.
Transparency & IATI resources
Transparency helps to improve effectiveness, accountability and trust in the international development and aid sector. This resource page signposts different places across the internet to gain support on organisational transparency and publishing your data to IATI.
Climate Justice Innovation Fund Information Session 2019
A Climate Justice Innovation (CJI) Fund information session was held by the fund managers Corra Foundation in Edinburgh on 26 June 2019.