IATI Switcheroo

Hello,

Hope all is well where you are. We made this over last weekend and thought we’d share it with you.

https://notshi.github.io/IATIswitcheroo/

It’s a website that exposes some of d-portal’s internal data conversions; you could use it to convert an xml file to csv, make changes to that csv and upload it again to convert back to xml so this could be useful for small publishers.

Optionally, you can use this to convert to html and have a quick preview of the data in print-friendly SAVi.

Feedback and comments are much appreciated.

3 Likes

Oooh, very cool - the most readable csv format I have seen so far :slight_smile: and super easy to just do a pivot table on to get real data out.

Would it be hard (and make sense?) to make it spit out xlsx files, with one tab for the activity level stuff, and another for the transactions? Maybe with a column that listed the activity-ID for each row on the transaction tab?

3 Likes

Nice, but the XML export seems to fail schema validation?! :grimacing:

Has this app been tested with validator reports @ https://test-validator.iatistandard.org ? I got (input raw XML valid data) that became schema-invalid once it got Switcherood from XML to XML…

Thanks, Matt!

We made this so it’s a flat format and not made of multiple files so that it can go back and forth between formats.

I think you can probably do this sort of processing using scripts inside a spreadsheet once you have the csv but we haven’t explored this yet!

Huh, interesting. Thanks, Siem!

Just ran an example via the validator and it looks like the export failed due to the wrong order of elements. Is this what you meant?

We didn’t think the order of data mattered so didn’t put that into account. Currently it’s ordered alphabetically so it’s easy to find things (human legible).

Suppose it’s called Switcheroo for a reason :} Will go change that then.

XML export for IATI Switcheroo should now pass schema validation. Do let us know otherwise!

5 Likes