Load data into OpenSpending

It is possible to load Fiscal Data Packages into OpenSpending via a web app (the Packager) and via a CLI.

Using the Packager

The Packager provides a simple user interface to load data into OpenSpending. The app is a wizard that guides the user through the uploading of a data source, the modeling of a Fiscal Data Package, the provision of metadata, and publication to the OpenSpending Datastore.

Using the CLI

The CLI provides a simple command line interface to interact with an OpenSpending instance. Using the CLI, you can authenticate with an OpenSpending instance and then push data directly to the datastore.

Walkthroughs

Load data via the Packager

  1. After assigning a DataType to each column in your file and packaging the data, you can proceed to step 3 of the data upload process. Image1

  2. At step 3 “Provide metadata,” name your dataset and provide metadata for better indexing. Include at least a Data Package name and a unique identifier. Image2

  3. As soon as you provide the details about your data, you will get a message saying “Congratulations! Now you can verify your Data Package and download it”: Image3

  4. Click “Continue” to proceed to Step 4 to either “Download” the JSON file or “Publish this Data Package.” Image4

  5. If you are logged in, you will be able to download or publish the data package. If not, you will be reminded to “Login to publish” before being able to move forward. Image5

  6. Two bars will show the progress of publishing your data. Image6

  7. Once your file was published, you can continue to exploring and visualizing your data in OS Viewer, by clicking “Explore and visualize your data now!” Image7

  8. If you want your data to be available to the larger audience, publish it from OS Admin. To access OS Admin, click on your name in the upper-right corner, and then click “Profile,” which will take you to OS Admin.

Image8

Image9

  1. In the menu on the left of the screen, click “My datasets.” Image10

  2. You will be able to see the number of uploaded, published and hidden datasets. Image11

  3. In OS Admin you have the ability to search your datasets, publish or unpublish a dataset. To finalize publishing, click “Publish” next to the dataset you want to make available. Image12

Load data via the CLI

{ pre. start with two data sources, one good one bad, both already have an FDP. 1. check, validate, etc etc. 2. authenticate with the service. 3. Push files up. 4. Ping for API load status }