dhis2-devs team mailing list archive

[Orvalho Augusto <orvaquim@xxxxxxxxx>]

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.

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.

Thanks for your patience guys
Caveman





2010/7/12 Jason Pickering <jason.p.pickering@xxxxxxxxx>

> 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 <larshelge@xxxxxxxxx>:
> > Generating any of the resource tables don't affect the aggregation /
> > report tables...
> >
> >
> >
> > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaquim@xxxxxxxxx>
> wrote:
> >> Thanks!!!
> >>
> >> Caveman
> >>
> >>
> >> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering
> >> <jason.p.pickering@xxxxxxxxx> 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 <orvaquim@xxxxxxxxx>
> >>> 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<https://launchpad.net/%7Edhis2-devs>
> >>> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >>> > Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >>> > More help   : https://help.launchpad.net/ListHelp
> >>> >
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> --
> >>> Jason P. Pickering
> >>> email: jason.p.pickering@xxxxxxxxx
> >>> tel:+260968395190
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
>
>
>
> --
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>