Any chance you can look into that? Or is it faster to just add https://github.com/vulekamali/os-source-specs#vulekamali to os-data-importers?
I'm pretty sure the pipelines in that branch don't work properly but if it's cool to add so long I can get the new pipeline I need working in there later today
when trying to upload the file I get this Error: Can't get a report from API. Reason: "Error: Reached maximum attemtps"
in the network log I then see a request to /packager/proxy?url=undefined which has come up before openspending/openspending#1378
I think it's a declarative way of making D3 visualisations, with vega-lite being a very simple high level version of vega, which is much more verbose but also powerful
here's an example pulling directly from OpenSpending https://codepen.io/jbothma/pen/zYOEbWv?editors=1000
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
Has anyone built a Tableau Web Data Connector for OpenSpending yet? https://help.tableau.com/current/pro/desktop/en-us/examples_web_data_connector.htm
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 :)
@jbothma what will that connector feed into?
The connector could make it easy to use data in OpenSpending in Tableau for visualisation https://cdns.tblsft.com/sites/default/files/pages/wdc-socrata.gif
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
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?
Thanks!
@akariv I'm trying to spot the exact point where the failure happens, but I'm not sure which is the correct repo, is it https://github.com/openspending/dataflows-openspending ?