Video Instruction Guide - Loading Data Into OpenSpending

Written by
  • lucy
Outdated Content Warning: This content refers to an older version of OpenSpending. See here for information about the next version of OpenSpending and ways to contribute.

Recently, the OpenSpending team have been working on a project to visualise financial data in Cameroon. One of the aims of the project is to create a platform which is sustainable for years to come and that means that it needs to be really easy to load and maintain datasets into OpenSpending.

So… we’ve created some screencasts about how to load data into OpenSpending. Please do take a look and try it out for yourself and let us know if anything needs to be clearer!

Once you’ve got your data into the OpenSpending data format you’re ready to load.

Preparing your dataset information

First add information about your dataset to make it easily findable in OpenSpending

OpenSpending Upload from Open Knowledge Foundation on Vimeo.

Upload your data online

Next, you need to get your CSV file online. There are numerous ways to do this, Dropbox, exporting your data directly from a Google Docs (File > Publish to the Web > Publish a CSV). We’ve used the DataHub to publish our data. If you’ve never used it before here’s a quick demo of how to upload a dataset.

DataHub upload from Open Knowledge Foundation on Vimeo.

Create a model to explain the structure of your data to OpenSpending

Next, tell OpenSpending how to understand your data by creating a model.

OpenSpending - Create a Model from Open Knowledge Foundation on Vimeo.

If that’s all gone well, you’ll be able to move on to creating visualisations (video coming soon - watch this space!) and if not and you have some errors watch the video below to see what to do next.

Not quite right? How to fix errors…

It doesn’t always go right the first time you try and load your data - here’s what to do if you have made a mistake either in your model or your data.

OpenSpending Error from Open Knowledge Foundation on Vimeo.

Please let us know if you upload a new dataset and if you have any feedback. You can get in touch any time via the mailing list.