On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe <bobjolli...@gmail.com>wrote:
> On 13 July 2010 07:17, Orvalho Augusto <orvaq...@gmail.com> wrote: > > I recompiled DHIS2.05 yesterday with help of a magician Jason yesterday. > And > > the first thing I tried was this aggregation thing. > > > > So I started redoing the orgunitstructure. It gave the same error. > > > > While it was running I used the > > show full processlist > > to find out that it is a verry long insert to be run at once. I have 1664 > > orgunits. So it sounds like indexing trouble. > > > > As there is a faith and "antimysql fight" I am moving my data to > postgres. I > > have to do it manually. > > There is no mysql fight. Just more people using postgres I guess. > > > > > I have to do it manually because DHIS does not keep de ids fixed > > (organisationunid, dataelementid etc). That affects our mapping data for > > data importation from other systems. So if someone could suggest a good > > strategy is welcomed. > Database internal ids should not really be used to map anything between databases... Also postgres is using a sequence meaning auto-generated values are globally unique, while auto-generated values in mysql starts at 1 for each table. > > How are you doing mapping data from other systems? If you tell me a > bit about these systems and the data they have maybe we can make a > plan :-) > > Cheers > Bob > > > > > Thanks for your patience guys > > Caveman > > > > > > > > > > > > 2010/7/12 Jason Pickering <jason.p.picker...@gmail.com> > >> > >> Hi Lars, > >> Well, yes and no. If the resource tables (namely orgunitstructure) is > >> not generated, it would not be possible to assign any orgunits to a > >> given data mart/report table? Likewise, if the orgunit levels have not > >> been defined, it is also not possible to assign any orgunits to a > >> given report table/datamart, or perhaps I am just hallucinating ? I > >> have run into this problem several times actually when creating new > >> databases. Ideally, the orgunitstructure table should be regenerated > >> when there have been changes to the orgunit hierarchy and users should > >> be warned that it is not possible to create a report table/datamart > >> without first defining orgunit level names. > >> > >> Regards, > >> Jason > >> > >> > >> 2010/7/12 Lars Helge Øverland <larshe...@gmail.com>: > >> > Generating any of the resource tables don't affect the aggregation / > >> > report tables... > >> > > >> > > >> > > >> > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaq...@gmail.com> > >> > wrote: > >> >> Thanks!!! > >> >> > >> >> Caveman > >> >> > >> >> > >> >> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering > >> >> <jason.p.picker...@gmail.com> wrote: > >> >>> > >> >>> A very common mistake is not having generated the resource tables, > >> >>> namely "orgunitstructure". Consult the documentation for more > details > >> >>> on how to generate these tables. > >> >>> > >> >>> Regards, > >> >>> Jason > >> >>> > >> >>> > >> >>> On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto < > orvaq...@gmail.com> > >> >>> wrote: > >> >>> > I have a dataelement collected at a Health Centre level (eg: > >> >>> > ats_posfem) > >> >>> > in > >> >>> > one province and only in some particular districts. In > unpredictible > >> >>> > future > >> >>> > at National level we will be collecting on every health centre. > >> >>> > > >> >>> > Now, my ignorance: How can I obtain the provincial total on Report > >> >>> > Table? I > >> >>> > have been battled with DHIS so far and nothing. > >> >>> > > >> >>> > Thanks guys > >> >>> > Caveman > >> >>> > > >> >>> > > >> >>> > _______________________________________________ > >> >>> > Mailing list: https://launchpad.net/~dhis2-devs > >> >>> > Post to : dhis2-devs@lists.launchpad.net > >> >>> > Unsubscribe : https://launchpad.net/~dhis2-devs > >> >>> > More help : https://help.launchpad.net/ListHelp > >> >>> > > >> >>> > > >> >>> > >> >>> > >> >>> > >> >>> -- > >> >>> -- > >> >>> Jason P. Pickering > >> >>> email: jason.p.picker...@gmail.com > >> >>> tel:+260968395190 > >> >> > >> >> > >> >> > >> >> > >> >> _______________________________________________ > >> >> Mailing list: https://launchpad.net/~dhis2-devs > >> >> Post to : dhis2-devs@lists.launchpad.net > >> >> Unsubscribe : https://launchpad.net/~dhis2-devs > >> >> More help : https://help.launchpad.net/ListHelp > >> >> > >> >> > >> > > >> > >> > >> > >> -- > >> -- > >> Jason P. Pickering > >> email: jason.p.picker...@gmail.com > >> tel:+260968395190 > > > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~dhis2-devs > > Post to : dhis2-devs@lists.launchpad.net > > Unsubscribe : https://launchpad.net/~dhis2-devs > > More help : https://help.launchpad.net/ListHelp > > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
