dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Caveman, we are definitely not dropping mysql support, its just
that most of the devs are using postgres so a function not being
mysql-compliant might sneak in from time to time. I tested most of the
application on mysql recently without trouble.

A common problem with aggregation earlier was the way the orgunit
hierarchy was represented and stored, this is changed in 2.0.5
snapshot and is way less error-prone now. So please build yourself a
war-file from trunk and test with that.

If that doesn't work please send me a database dump and I will have a
look. (On a sidenote a main reason for choosing postgres is the way
dumps are restored - mysql uses single regular sql insert statements
which might take days for very large databases while postgres uses
more "native" copy statements which never takes more than minutes).

cheers, Lars



2010/7/12 Orvalho Augusto <orvaquim@xxxxxxxxx>:
> I need to have a repo/table that aggregates data as I asked before. I did
> not find it on docs.
>
> Someone told me that can happens if a generate those resource tables. I try
> to generate those tables and I get stuck on that error I reported.
>
> Good for me if I do not need to generate such tables and ask what I should
> do?
>
> Caveman
>
>
> 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
>> >
>> >
>
>
>
>