let's try os-data-importers - shouldn't rely on goodtables
I've managed to process enough of the columbian datapackage in the simple branch using os-data-importers to be able to see the default bar chart but when I try to filter the API doesn't respond - any ideas why that might be?
I haven't explored its ability to slice and dice data - I don't think it can generate data URLs dynamically, but at the very least I can generate URLs dynamically for it, and perhaps let it do basic filtering of disaggregated OpenSpending queries
I built a quick attempt - it ends up getting errors from the OpenSpending API - probably hitting it a bit hard. It should probably just use the model to provide a schema to Tableau, then load the data by streaming the CSV file https://github.com/vulekamali/tableau-web-data-connector
On another topic, it'd be amazing to have the OpenSpending API URL exposed by OpenSpending viewer - we've been building some interactive visualisations using D3 and still look at the browser network log in OS Viewer to put API URLs together :)
The API being exposed is definitely something to look into
for vulekamali.gov.za that's interesting because there could be an adaptor specific to vulekamali which lists just the vulekamali datasets, and if we update a dataset in openspending, peoples' visualisations could update automatically overnight
obviousy we'd need to make it clear if that might happen. it makes sense for an in-year spending tracker. it might be surprising for a once-off analysis
@tlacoyodefrijol just checking you're aware it looks like we're getting gateway timeouts from the API
Yes, I'm currently handling it.
It's back up now
Woo! thanks Adam
Hi, OpenSpending gurus
We're developing an Open Fiscal Data Package conversion script for public universities, but are facing a technical problem and need some help
I've tried the forums, but they won't allow me to post anything (¿?), so here I am...
This is a date field as defined in the JSON file. As you can see, we specify the format
And here is the error we get when applying the JSON to our CSV in the online OS Packager:
As you can see, it seems to be ignoring the "format" information, and tries to apply a different date mask than the one we specify in the JSON
We are not able to deal with this. Can anybody lend us a hand?
Hey @jjalcolea - if you’d like, we can get on a call sometime next week so you can explain to me what you’re trying to do and I can guide you through the openspending codebase and how to best use it for your needs.
Thanks @akariv , I was just trying to isolate where the bug occurs in the code to better inform the bug report and facilitate the diagnosis; for the moment we don't have the resources to get involved in development; we're just users of the tools at openspending.org