dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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.

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
>
>