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

Mon Nov 28 18:29:18 UTC 2011

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
>