Re: [Dhis2-users] Fwd: Pivot Table does not display correct data

2014-06-16 Thread Lars Helge Øverland
Hi Jose, you likely have an SQL view in your database which depends on the _orgunitstructure resource table which DHIS 2 needs to drop during re-generation. Please remove that SQL view and rather create it through DHIS 2 under data administration > SQL views - the system will then take care of dro

Re: [Dhis2-users] [Dhis2-devs] Resource table Erro after Manual Aggregation

2014-06-16 Thread Lars Helge Øverland
Thanks Sumudo, glad it works. Mind you this might still be a bug with the aggregation queries, we are working it. Lars On Mon, Jun 16, 2014 at 8:23 PM, sumudu weerasinghe wrote: > Thanks Lars and Adebusoye! > > Yes, your guess is correct i have done the thing wrong way > >- during manual a

Re: [Dhis2-users] [Dhis2-devs] Resource table Erro after Manual Aggregation

2014-06-16 Thread sumudu weerasinghe
Thanks Lars and Adebusoye! Yes, your guess is correct i have done the thing wrong way - during manual aggregation i have selected start date 1/5/2014 and end date as *16/6/2014* - then my database period table shows two monthly period for June - now i have remove the extra one from p

[Dhis2-users] Problems with category combination

2014-06-16 Thread Chris Onoja
Hello All, I am having an issue with some of my data element category combinations. A couple of my data elements do not pick up the category combinations assigned to them and as a result the data elements are not rendered properly in the section form. For example i have a data element that has a

Re: [Dhis2-users] [Dhis2-devs] Resource table Erro after Manual Aggregation

2014-06-16 Thread Lars Helge Øverland
Hi Adebusoye, that sounds quite likely. Tran can you please check that the aggregation queries produce valid periods (start / end dates are in sync with the period type) ? On Mon, Jun 16, 2014 at 5:00 PM, Adebusoye Anifalaje wrote: > Hi Sumudu, > > To get past this quickly, you need to check

Re: [Dhis2-users] [Dhis2-devs] Resource table Erro after Manual Aggregation

2014-06-16 Thread Adebusoye Anifalaje
Hi Sumudu, To get past this quickly, you need to check your period table and filter by Periodtypeid 3. Have a look at all any start date that does not begin on the 1st. Delete this from the table. Clear system cache and run analytics again. This should work. The Devs have to think of a more l

Re: [Dhis2-users] [Dhis2-devs] Resource table Erro after Manual Aggregation

2014-06-16 Thread Adebusoye Anifalaje
Hi Lars, I also reported this problem on the Bug list here: https://bugs.launchpad.net/dhis2/+bug/1313954. It happens either when you import from another system so you have period type id = 3 both end dates in year . Another scenario is when you run the manual aggregate query and choose a

Re: [Dhis2-users] Discrepancy in Reporting Rates

2014-06-16 Thread Lars Helge Øverland
Hi, yes they actually have different implementations, although the logic should be the same. On the demo database they are equal (except for some rounding errors). We are planning to replace the reporting rate summary by extending pivot table to support the same output. cheers Lars On Mon,

Re: [Dhis2-users] [Dhis2-devs] Resource table Erro after Manual Aggregation

2014-06-16 Thread Lars Helge Øverland
Hi Sumudu, my guess is that someone has done manual inserts of periods in the period table, and that you have a mismatch between the period (start / end date) and the period type. E.g. you have periods which are days but has the monthly period type. Please investigate this. This SQL will give you

Re: [Dhis2-users] absence de rapport de formulaire après saisie

2014-06-16 Thread ANGE ASSOHOU
merci à tous bien compris   Dr Ange ASSOHOU DRSLS du Gboklé, Nawa, San Pedro Ministère de la Santé et de la Lutte contre le SIDA Le Lundi 16 juin 2014 7h38, Aymar Narodar SOME a écrit : Cher Ange, A mon avis si c'est juste pour la gestion d'un seul centre de santé, je vous conseiller

[Dhis2-users] I cannot see my data

2014-06-16 Thread Bismarck Owusu
Dear Users, I cannot see my data when i do pivot table and at the data visualizer despite the fact that i have updated my data mart.  When i go back to the data entry form am able to see all the data but when i try to do data pivot table and other reports the data does not show up. So please i n

Re: [Dhis2-users] How to use CSV OrgUnit import?

2014-06-16 Thread Adebusoye Anifalaje
That’s great. Thanks. Busoye On 16 Jun 2014, at 14:37, Lars Helge Øverland wrote: > Hi, > > I have added support for parent org unit in 2.15. See docs here in 5 min: > http://www.dhis2.org/doc/snapshot/en/user/html/ch21.html#d5e3351 > > Lars > > > On Tue, Jun 10, 2014 at 10:35 AM, Knut St

Re: [Dhis2-users] Link to App store?

2014-06-16 Thread Lars Helge Øverland
OK fixed. On Tue, Jun 10, 2014 at 3:43 AM, Knut Staring wrote: > Ok, but then we need to update the link in several places, for example > here: > http://apps.dhis2.org/demo/dhis-web-maintenance-appmanager/appList.action > > > On Sun, Jun 8, 2014 at 10:20 AM, Lars Helge Øverland > wrote: > >>

Re: [Dhis2-users] How to use CSV OrgUnit import?

2014-06-16 Thread Lars Helge Øverland
Hi, I have added support for parent org unit in 2.15. See docs here in 5 min: http://www.dhis2.org/doc/snapshot/en/user/html/ch21.html#d5e3351 Lars On Tue, Jun 10, 2014 at 10:35 AM, Knut Staring wrote: > Hello all, > > I cannot see how to indicate the *parent* OU in the CSV metadata import? >

Re: [Dhis2-users] I need help On setting up SMS on dhis

2014-06-16 Thread Peder Andreas Nergaard
Hi Anthony, What are your current issues? What is working and what is not working? Br, _Andreas_ On 16. juni 2014 12:08, Anthony Danso wrote: Please am still having issues with the Setting up of proxy for SMS in DHIS2.can someone help me out? On Apr 7, 2014, at 12:55 PM, Peder Andreas Nergaar

Re: [Dhis2-users] absence de rapport de formulaire après saisie

2014-06-16 Thread Aymar Narodar SOME
Cher Ange, A mon avis si c'est juste pour la gestion d'un seul centre de santé, je vous conseillerai d'utiliser la version DHIS1.4 conçue sous Microsoft Access et VBA. Cette version a les mêmes fonctionnalités que la version web DHIS 2. La version DHIS1.4 est téléchargeable sur hisp.org . Par la s