On Tue, May 5, 2009 at 4:35 PM, Knut Staring <[email protected]> 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.
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
