[OpenSpending-discuss] Help with the mapping file - views

Mon Nov 28 21:19:10 UTC 2011

Hi David,

interesting issue, thanks for reporting it. This seems to be some
munging going wrong with the classifier taxnonmies, but thankfully
we've now abolished them altogether. FWIW, in the latest version you
should be able to express this as:

    {
      "entity": "dimension",
      "label": "Breakdown by programme",
      "name": "default",
      "dimension": "programme_group",
      "drilldown": "programme"
    }

Best,

- Friedrich

On Mon, Nov 28, 2011 at 10:11 PM, David Cabo <david at calibea.com> wrote:
>  Hi,
>  I was just picking up the import of Spanish budget data [1] into
> OpenSpending (after many months away), and I ran into a problem with the
> views definition, maybe it's related to Michal's issue:
>  I had a classifier and a taxonomy both named 'programme_group' (with an
> underscore), and a view associated to them like this:
>     {
>       "entity": "classifier",
>       "label": "Breakdown by programme",
>       "name": "default",
>       "dimension": "programme_group",
>       "breakdown": "programme",
>       "filters": {"taxonomy": "programme_group"}
>     }
>  Other views worked fine, but this one wasn't: I was just getting the list
> of entries, but not the tree view. I then noticed that the url was
> displaying a hyphen, not an underscore, for
> example http://sandbox.openspending.org/classifier/programme-group/453 I've
> just changed the model definition to use a hyphen in the dimension name, and
> now it all seems to be working.
>  Regards,
> /david
> [1]: http://thedatahub.org/dataset/spain-national-budget-2008-2011
> On 28 November 2011 19:29, Friedrich Lindenberg
> <friedrich.lindenberg at okfn.org> wrote:
>>
>> Hi,
>>
>> I've looked at the model file a bit but couldn't immediately find the
>> error. Maybe you could try the latest version of OpenSpending, where
>> we can edit this together. This requires some editing of the model,
>> but there's a utility to help you with it:
>> https://github.com/okfn/osvalidate. After doing that, you can sign up
>> on openspending.org and then using the "Create a dataset..." option in
>> the "Datasets" dropdown. There, you can link in data references and
>> copy & paste the mapping and views sections of the model file. This
>> should give you much better error messages and you can edit the views
>> without reloading the data.
>>
>> - Friedrich
>>
>> On Mon, Nov 28, 2011 at 5:40 PM, M.Skop KohoVolit.eu
>> <michal.skop at kohovolit.eu> wrote:
>> > I would like to ask you for help with the mapping file - views. I
>> > probably
>> > still cannot get the idea of drilldowns/taxonomies/cuts/filters right. I
>> > have tried many settings, reading the wiki and some mapping files, but
>> > no
>> > success with following:
>> >
>> > I have a datafile
>> > http://sandbox.openspending.org/dataset/cz_2006-2010_os_2
>> > which has 7 different categories (levels)
>> > 1:budget - 2:chapter(=group of organizations) - 3:organization - 4:group
>> > of
>> > entries (e.g. 'salaries') - 5:subgroup of entries - 6:subsubgroup of
>> > entries
>> > - 7:entry(account number) -> amount
>> > e.g.
>> > 1:budget - 2:Chapter 311 - 3:Organization X - 4:group 4_1 - 5:subgroup
>> > 5_1 -
>> > 6:subsubgroup 6_1 - 7:entry 5111
>> > or
>> > 1:budget - 2:Chapter 311 - 3:Organization Y - 4:group 4_1 - 5:subgroup
>> > 5_1 -
>> > 6:subsubgroup 6_1 - 7:entry 5111
>> >
>> > (mind that spending groups at level 4 till 7 are the same for all the
>> > organizations)
>> >
>> > I want to be able to drilldown (with appropriate filters) _using the
>> > tree-chart_ (and api)
>> > A) 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 (and get the final amount in given
>> > year
>> > and organization and entry=account)
>> > and/or
>> > B) 1 -> 4 -> 5 -> 6 -> 7 -> 2 -> 3 (or similarly 1 -> 4 -> 2 -> 3 ... )
>> >
>> > How shall I specify the mapping file?
>> >
>> > Thanks a lot for your help,
>> > Michal
>> > p.s.: It works in desirable manner down to level 3/4 at the
>> > http://sandbox.openspending.org/dataset/cz_2006-2010_os_2, but I cannot
>> > get
>> > it work well further down to level 6/7
>> >
>> > --
>> > Mgr. Michal Škop, Ph.D.
>> > KohoVolit.eu
>> > michal.skop at kohovolit.eu
>> > +420 775 187 021 / +420 721 484 915
>> >
>> >
>> > _______________________________________________
>> > openspending mailing list
>> > openspending at lists.okfn.org
>> > http://lists.okfn.org/mailman/listinfo/openspending
>> >
>>
>> _______________________________________________
>> openspending mailing list
>> openspending at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/openspending
>
>