dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

On Tue, May 5, 2009 at 4:35 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Tom,
>
> Copying this to our DHIS 2 development list, as it is something several
> people would like to be aware of.
>
> 1) As we saw today, removing the restriction on dataelement shortname
> length works, but only up to 40 characters if you want to crosstab on them.
>
> 2) Unfortunately, because of the limitiations of the underlying Postgres
> database, the datamart/report table generation cannot handle more than 1233
> data elements. The GUI should probably check this and give you feedback,
> instead of just creating a hanging process as seems to be the case
> currently.
>
> There are two ways to deal with this:
>
> a) We can divide the operation into three parts (since you have 2813 data
> elements). Basically, just select a couple of your datasets at a time. And
> then the CSV files must be joined somehow. This probably means that OrgUnits
> (200 countries) should be on crosstabbed (to get the same columns in all
> three files)
>
> b) We can create a separate "Export all" button, which does not use the
> crosstab functionality, but is basically just a dump of our datavalue table
> with names of orgunits, periods (years), and data elements in CSV format.
>


Yes, we could create a regular datavalue export in CSV format, will have a
look.