dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>wrote:

> On 13 July 2010 07:17, Orvalho Augusto <orvaquim@xxxxxxxxx> 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.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
> >> >>> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >>> > Unsubscribe : https://launchpad.net/~dhis2-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
> >> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >> Unsubscribe : https://launchpad.net/~dhis2-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
> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
> >
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>