Re: [Dhis2-users] [Dhis2-devs] Linking Power BI and DHIS2

[Michael Mwebaze]

Hi Channara,

you create the token on Powerbi. See link below with some useful hints.

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with-azure-ad

Regards,

Michael

On 22 March 2018 at 06:47, channara rin  wrote:

> Hi Michael,
> Do you have guide for option 2: connect through web API?
> how can i find dhis1 api token key?
>
> On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze <
> michael.mweb...@gmail.com> wrote:
>
>> Hi Stanley,
>>
>> you basically have two options for this.
>>
>>1. download data from dhis2 as csv and upload it to PowerBI (you will
>>have to create a dataset for that on PowerBI)
>>2. make use of DHIS2 web api to pull data and push it to powerbi via
>>its web api as well. To achieve this a number of things need to happen on
>>the PowerBI side. You will need to create an app on the Azure platform,
>>give it the right authentication permissions, then use the token created 
>> in
>>your custom script of application to authenticate and update a particular
>>dataset.
>>
>> If you are interested in code repository, I have a working example based
>> on Symfony 3 a PHP frameweork in my git repository.
>>
>>
>> https://github.com/mmwebaze/powerbi_Symfony
>>
>>
>> I hope this helps.
>>
>> On 14 September 2017 at 11:46, Stanley Kalyati 
>> wrote:
>>
>>> Anyone with experience linking Power BI and DHIS2 for further analysis .
>>>
>>> Anyone
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data elements assignation

[Michael Mwebaze]

Hi Diao,

Are you able to use the web api? The section in the developer's manual
'Metadata create, read, update, delete, validate' should be helpful.

Regards,

Michael

On 27 January 2018 at 15:30, Mamadou Diao Diallo 
wrote:

> Hi dhis2 devs,
> I have to assign many data elements to a data set, so I would like to
> automatically do it.
>
> Is there any possibility to do it, like a csv importation?
>
> Thank you in advance.
>
> Best
>
> Diao
>
> --
> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
> Health Information Software )*
>
>
> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
> *Phone : 623909413 | 662256106*
> *Skype : diawwdiallo*
> www.jsi.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Using DHIS2 API

[Michael Mwebaze]

Hi Diallo,

from the developer's guide it doesn't look like dataelement group is a
supported query parameter for dataValues end point. See link below

https://docs.dhis2.org/2.23/en/developer/html/ch01s15.html

You should however have more success with the analytics end point see link
below

https://docs.dhis2.org/2.23/en/developer/html/ch01s32.html

Michael



On 21 September 2017 at 06:37, Mamadou Diao Diallo 
wrote:

> Hello dhis2 API users,
>
> I have some troubles to have dataValues, dataElements(Name and Id) and
> dataElementGroups(Name and Id) in the same query instead of doing two
> different queries.
>
> Is it possible? if yes thank you for any information.
>
> Thank you in advance
>
> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
> Health Information Software )*
>
>
> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
> *Phone : 623909413 | 662256106*
> *Skype : diawwdiallo*
> www.jsi.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Linking Power BI and DHIS2

[Michael Mwebaze]

Hi Stanley,

you basically have two options for this.

   1. download data from dhis2 as csv and upload it to PowerBI (you will
   have to create a dataset for that on PowerBI)
   2. make use of DHIS2 web api to pull data and push it to powerbi via its
   web api as well. To achieve this a number of things need to happen on the
   PowerBI side. You will need to create an app on the Azure platform, give it
   the right authentication permissions, then use the token created in your
   custom script of application to authenticate and update a particular
   dataset.

If you are interested in code repository, I have a working example based on
Symfony 3 a PHP frameweork in my git repository.


https://github.com/mmwebaze/powerbi_Symfony


I hope this helps.

On 14 September 2017 at 11:46, Stanley Kalyati  wrote:

> Anyone with experience linking Power BI and DHIS2 for further analysis .
>
> Anyone
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

[Michael Mwebaze]

Hi Martin,

do you have access to the Tomcat logs? If an exception is being thrown that
would also be helpful to figure out what is happening.

Regards,

Michael

On 28 August 2017 at 10:04, Martin Van Aken  wrote:

> Hi DHIS2 users & developers,
> We have a relatively large instance of DHIS2 (30 000 org units) where we
> have several groups that can make up to 3 000 org unit each.
>
> When trying to update them through the UX, our server get a timeout
> (looking in the console for the network calls).
>
> The call is like this:
>
> /api/organisationUnitGroups/RZYPaa6gxq8?mergeMode=REPLACE
>
> When using the API, we get no problem but we typically add/remove
> relations one by one (so the call is very different).
>
>  I tested on the last version on play and everything is working there, but
> the version is quite different too.
>
> Is this something someone encountered already? Anything we could do to
> avoid this ?
>
> Thanks,
>
> Martin
>
>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 to DHIS2 integration cases

[Michael Mwebaze]

Hi Martin,

what I have done in the past to achieve this is to build a 3rd party
utility say in Python and sync any number of dhis2 instances through their
web apis. I then went on to create cron jobs which run the utility
periodically. The major assumption I made was that the changes only
happened on the master and never on the slaves. The slaves just got updates
from the master. I hope this helps.

Michael

On 21 August 2017 at 12:13, Martin Van Aken  wrote:

> Hi DHIS2 community!
> We start having a number of cases for "DHIS2 to DHIS2" integration.
> Typically, we have a DHIS2 at the HMIS level and one or more dedicated to
> vertical programs. In this situation:
>
> - the vertical program need the health pyramid from the HMIS
> - the HMIS may be interested to get back a part of the data element &
> values generated by the vertical program
>
> Examples:
>
> - every time an org unit is created or updated in the HMIS we want to
> create/update in the vertical program system
> - every time an data element is created or updated in a given group in the
> vertical program system we want to create/update it in the HMIS
> - every period (week/month/quarter) we want to push back the data from the
> vertical program to the HMIS for a given set of data element
>
> While all the individual elements are there for this to works (can use
> export/import and/or the API), is there any "advised way" to make this run
> on an automated basis? Missing this, any case/experience to share?
>
> Thanks & regards,
>
> Martin
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] mapLegendSet API end-point

[Michael Mwebaze]

Hi,

is there a mapLegendSets end-point? I can't seem to find it as part of
api/resources

I am trying to embed a map and getting

http://localhost:8181/dhis/api/mapLegendSets.jsonp?viewClass=detailed&links=false&paging=false&callback=Ext.data.JsonP.callback3&_dc=1478624326625
Failed to load resource: the server responded with status 404

Thanks,

Michael
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] API: dataSets.dataElements

[Michael Mwebaze]

Thanks Uwe,

I have been trying to figure this out as well.



On 3 November 2016 at 04:04, Uwe Wahser  wrote:

> just found the answer myself: it has to be
> https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?
> paging=false&fields=dataSetElements[dataElement[id,code,name]]
>
> the other question remains: why cant I use the old syntax by adding 24 or
> 23 to
> the url?
>
> Regards,
>
> Uwe
>
> ---
> > Uwe Wahser  hat am 3. November 2016 um 09:52 geschrieben:
> >
> >
> > Dear all,
> >
> > I am a bit confused about the api in 2.25. Before, I was able to list
> > dataElements of a given dataSet via
> > https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?
> paging=false&fields=dataElements[id,code,name]
> >
> > As I understand from the manual, this has changed to
> > https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?
> paging=false&fields=dataSetElements[id,code,name]
> >
> > Two issues in this context:
> > 1 - I would have expected to be able to use the old syntax by adding 24
> or 23
> > into the url - that doesn't work.
> > 2 - the new syntax only works for the id of a dataSetElement and doesn't
> bring
> > up code nor name. fields=dataSetElements[:all] only brings up a few
> attribute,
> > but not neither code nor name.
> >
> > Am I missing something? Haven't tested with other sub-ressources, yet.
> >
> > Thanks,
> >
> > Uwe
> >
> > ___
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to : dhis2-users@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Link to download Dhis 2.22 rev 22060

[Michael Mwebaze]

Hi Matthieu,

Try the link below:

http://ci.dhis2.org/job/dhis2-2.22/

Regards,

Michael

On 19 October 2016 at 11:04, Matthieu Pinard  wrote:

> Hi Guy,
>
> any particular reason fo you to ask for this specific rev rather than the
> latest one of 222?
>
> Cheers,
> Matthieu
>
> Matthieu Pinard
> DHIS2 Core Team | University of Oslo
>
> On 19 October 2016 at 16:12, Guy Ekani  wrote:
>
>> Hello Team,
>>
>> Please could someone can share the link for downloading Dhis 2.22 rev
>> 22060
>>
>> Sincerely,
>>
>> --
>> =
>> EKANI Guy
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] dhis version 2.25 is released

[Michael Mwebaze]

Hi Brajesh,

You can get the code on Github,

https://github.com/dhis2/dhis2-core/

You can also get the latest builds and other information from

http://ci.dhis2.org/job/dhis2-2.25/

Regards,

Michael

On 19 October 2016 at 01:05, Brajesh Murari 
wrote:

> Hello Devs,
>
> I have one question in my mind, that where i can find DHIS2.25 code on
> launchpad.net ?
>
> On Mon, Oct 17, 2016 at 9:02 PM, vunda limbe  wrote:
>
>> Good news! look a way to test and upgrade.
>> Thanks for Dev Team
>>
>> 2016-10-14 9:24 GMT+01:00 riddy ndoma :
>>
>>> Great!
>>>
>>> 2016-10-14 8:52 GMT+01:00 GROUT, Lise :
>>>
 Congratulations to all the team!



 Really looking forward to diving into this version 2.25!



 All the team deserves a nice and long week-end!



 Lise.



 *From:* Dhis2-users [mailto:dhis2-users-bounces+groutl=
 who@lists.launchpad.net] *On Behalf Of *Lars Helge Øverland
 *Sent:* 13 October 2016 12:51
 *To:* DHIS 2 Users list; DHIS 2 Developers list
 *Subject:* [Dhis2-users] dhis version 2.25 is released





 Hi all,



 DHIS version 2.25 is out with a lot of new features, apps and
 improvements.



 *Log in with admin/district on the **demo*
 * system.*





 ANALYTICS FEATURES

 ---



 *External map layers:* The GIS app now supports TMS (Tile Map
 Service), XYZ and WMS (Web Map Service) layers. These are all popular
 protocols for map data and there are numerous map services available,
 allowing you to display maps for rivers, roads, weather, land data and
 everything else. External map layers can be set up from the Maintenance
 app, and then be accessed from the top bar in the GIS app.



 Docs GIS
 
 | Docs setup
 
 | Screenshot 1
 
 | Sc 2
 
 | Sc 3
 
 | Sc Setup
 
 | Demo 1
 
 | Demo 2
 



 *Push analysis*: You can now push data analysis in the form of
 reports, charts and maps to your users over email. This allows for
 improving awareness and visibility of your data, and can encourage people
 to more actively look at analysis. Push analysis is based on dashboards,
 and can be set up, run and scheduled from the Maintenance app. You can also
 run immediately and preview from the the context menu.



 Docs
 
 | Screenshot 1
 
 | Sc 2
 
 | Demo
 



 *Indicator as filter:* A single indicator or data set reporting rate
 can now be used as filter in charts and pivots. This allow you to create
 charts for example with multiple periods and organisation units.



 Docs
 
 | Screenshot
 
 | Demo
 



 *Dashboard translations:* The names of dashboards can now be
 translated, meaning you can have dashboard names appear in user’s local
 language.



 Docs
 
 | Screenshot
 



 *Deep linking of favorites:* When opening favorites in the Pivot Table
 and Visualizer apps, the browser address bar URL will reflect the current
 favorite. This allows for easy sharing of favorites through
 copy-and-pasting the URL.



 Sc

Re: [Dhis2-users] Error in DHIS2

[Michael Mwebaze]

Hi Ravi,

do you have the environment variable DHIS2_HOME pointing to the directory
containing either hibernate.properties or dhis.conf configuration files?
Below is a link to a sample configuration file and you can just limit to
the section 'Database connection for PostgreSQL'

http://dhis2.github.io/dhis2-docs/2.22/en/implementer/html/ch08s07.html

Regards,

Michael

On 23 August 2016 at 01:10, Chandrasekar Ravi  wrote:

> Dear Team,
>
> When i am trying to open the dhis2 software in web browser. It shows the
> following error. How to rectify it?
>
> : org.springframework.transaction.CannotCreateTransactionException: Could
> not open Hibernate Session for transaction; nested exception is
> org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC
> Connection
>
> Thanks & Regards
>
> *Chandrasekar Ravi*
> *Scientist - C, Data Manager*
>
> *GHSA MAHA CDC Project*
>
>
> *National Institute of Epidemiology, ICMR127, Second Main Road,
> TNHBAyapakkam, Ambattur, Chennai – 77*
> *aravindr...@gmail.com ,*
> *9787214185 <9787214185>*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Step by step process of building dependencies and making them available in a local maven repo

[Michael Mwebaze]

Hi Collins,

the maven repository: http://maven.dhis2.org/ isn't available. Is there a
particular reason why you want to build version 2.12 and not a later
version?

Regards,

Michael

On 8 August 2016 at 06:36, Collins McAdoyo  wrote:

> Dear Team,
>
> I get the error below whenever, I try to built my system previously done
> on DHIS2 Version 2.12. I am aware some of these repos are old and are
> nolonger supported so I want to build them locally. I have tried
> downloading some of these compile dependencies but still its not able to
> built.
>
> Any idea of how to go about it step wise would be highly appreciated.
>
>
> [ERROR] Failed to execute goal on project dhis-api: Could not resolve
> dependencies for project org.hisp.dhis:dhis-api:jar:2.12: Failed to
> collect dependencies for [junit:junit:jar:4.11 (compile),
> commons-lang:commons-lang:jar:2.6 (compile),
> commons-io:commons-io:jar:2.4 (compile), 
> commons-collections:commons-collections:jar:3.2.1
> (compile), jfree:jfreechart:jar:1.0.13 (compile), 
> net.sf.jasperreports:jasperreports:jar:4.7.1
> (compile), net.sf.jasperreports:jasperreports-fonts:jar:4.0.0 (compile),
> com.fasterxml.jackson.core:jackson-core:jar:2.0.6 (compile),
> com.fasterxml.jackson.core:jackson-annotations:jar:2.0.6 (compile),
> com.fasterxml.jackson.dataformat:jackson-dataformat-xml:jar:2.0.6
> (compile), org.smslib:smslib:jar:3.5.3 (compile),
> org.springframework:spring-jdbc:jar:3.2.2.RELEASE (compile)]: Failed to
> read artifact descriptor for org.smslib:smslib:jar:3.5.3: Could not
> transfer artifact org.smslib:smslib:pom:3.5.3 from/to amplecode_maven2_repo
> (http://maven.dhis2.org/amplecode-local): maven.dhis2.org: unknown error:
> Unknown host maven.dhis2.org: unknown error -> [Help 1]
>
> Collins
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS2 based App http.post and put (403 error)

[Michael Mwebaze]

Hi Mark,

The app I am developing is running with-in a DHIS2 context. Below is the
error from the console. I have also included the code fragment causing the
error.

[image: Inline images 1]

var data = {
"dashlets" : dashlets
}

$http.put('/api/dataStore/rbcdashboard/HIV', data, {
headers : {
'Content-Type' : 'application/json'
}
})
.success(function (data, status, headers) {
console.debug(data)
});
Thanks,

Michael

On 7 August 2016 at 10:50, Mark Polak  wrote:

> Hey Michael,
>
> Are you developing the app using CORS? If you're doing CORS requests you
> will need to include the header yes. If your app is running from within the
> dhis2 context (as in you installed it) you won't need to do so.
>
> Generally when the Authorization header is not send the API would 302 you
> to the login page, so perhaps something else is the matter. When POSTing to
> the dataStore api you need to POST to /api/dataStore//
> If you could share a piece of the code where you do the request, perhaps i
> can give you some more detailed feedback. :)
>
>
> On Sun, Aug 7, 2016 at 11:18 AM, Michael Mwebaze <
> michael.mweb...@gmail.com> wrote:
>
>> Hi,
>>
>> I am developing a DHIS2 based app using AngularJS. The $http.get is
>> successful but I am getting 403 (Forbidden) with the POST and PUT when I
>> try to add a new item to the dataStore. Am I supposed to include
>> Authorization: Basic base64encode(username:password) in the header as
>> well? Is there an example I can follow for DHIS2 based apps?
>>
>> Thanks,
>>
>> Michael
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Regards,
>
>
> Mark Polak
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>
> m...@dhis2.org
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] DHIS2 based App http.post and put (403 error)

[Michael Mwebaze]

Hi,

I am developing a DHIS2 based app using AngularJS. The $http.get is
successful but I am getting 403 (Forbidden) with the POST and PUT when I
try to add a new item to the dataStore. Am I supposed to include
Authorization: Basic base64encode(username:password) in the header as well?
Is there an example I can follow for DHIS2 based apps?

Thanks,

Michael
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Error when running 'mvn install'

[Michael Mwebaze]

Hi Collins,

I notice you are trying to build version 2.12. I suspect the issue might be
some of the repositories with the needed dependencies aren't available. In
particular from the error log I can see maven is complaining that '
http://maven.dhis2.org/' is a unknown host. Check you are not behind a
firewall which is prevent maven from accessing them.

Regards,

Michael



On 2 August 2016 at 15:18, Collins McAdoyo  wrote:

> Dear Knuts & Team,
>
> I am trying to run maven as :~/2.12/dhis-2$ mvn install'  i get this
> error. Any advice on how to fix this?
>
>
> [INFO]
> 
> [INFO] BUILD FAILURE
> [INFO]
> 
> [INFO] Total time: 59.967s
> [INFO] Finished at: Tue Aug 02 21:59:09 EAT 2016
> [INFO] Final Memory: 13M/157M
> [INFO]
> 
> [ERROR] Failed to execute goal on project dhis-web-commons: Could not
> resolve dependencies for project org.hisp.dhis:dhis-web-commons:jar:2.12:
> Failed to collect dependencies for [org.hisp.dhis:dhis-api:jar:2.12
> (compile), org.hisp.dhis:dhis-dxf2:jar:2.12 (compile),
> org.hisp.dhis:dhis-service-i18n:jar:2.12 (compile),
> org.hisp.dhis:dhis-service-core:jar:2.12 (compile),
> org.hisp.dhis:dhis-service-administration:jar:2.12 (compile),
> org.hisp.dhis:dhis-service-reporting:jar:2.12 (compile),
> org.hisp.dhis:dhis-support-test:jar:2.12 (test),
> org.hisp.dhis:dhis-support-system:jar:2.12 (compile),
> org.apache.struts:struts2-core:jar:2.3.16 (compile),
> org.apache.struts:struts2-spring-plugin:jar:2.3.16 (compile),
> org.apache.velocity:velocity:jar:1.7 (compile),
> org.apache.velocity:velocity-tools:jar:2.0 (compile),
> javax.servlet:servlet-api:jar:2.4 (provided),
> org.springframework.mobile:spring-mobile-device:jar:1.0.0.RELEASE
> (compile),
> org.springframework.security:spring-security-config:jar:3.1.3.RELEASE
> (compile), org.springframework:spring-context-support:jar:3.2.2.RELEASE
> (compile), commons-logging:commons-logging:jar:1.1.1 (compile),
> commons-fileupload:commons-fileupload:jar:1.2.2 (compile),
> com.thoughtworks.xstream:xstream:jar:1.4.3 (compile),
> xpp3:xpp3:jar:1.1.3.4.O (runtime),
> net.sf.jasperreports:jasperreports:jar:4.7.1 (compile),
> net.sf.jasperreports:jasperreports-fonts:jar:4.0.0 (compile),
> jfree:jfreechart:jar:1.0.13 (compile), jfree:jcommon:jar:1.0.16 (compile)]:
> Failed to read artifact descriptor for org.hisp.dhis:dhis-api:jar:2.12:
> Could not transfer artifact org.hisp.dhis:dhis-api:pom:2.12 from/to
> amplecode_maven2_repo (http://maven.dhis2.org/amplecode-local):
> maven.dhis2.org: unknown error: Unknown host maven.dhis2.org: unknown
> error -> [Help 1]
> [ERROR]
> [ERROR] To see the full stack trace of the errors, re-run Maven with the
> -e switch.
> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> [ERROR]
> [ERROR] For more information about the errors and possible solutions,
> please read the following articles:
> [ERROR] [Help 1]
> http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
> [ERROR]
> [ERROR] After correcting the problems, you can resume the build with the
> command
> [ERROR]   mvn  -rf :dhis-web-commons
> cadoyo@pathmis:~/2.12/dhis-2/dhis-web$ cd ..
> cadoyo@pathmis:~/2.12/dhis-2$ mvn install
> [INFO] Scanning for projects...
> [INFO]
> 
> [INFO] Reactor Build Order:
> [INFO]
> [INFO] DHIS 2
> [INFO] DHIS API
> [INFO] DHIS Support Parent Project
> [INFO] DHIS Test Support
> [INFO] DHIS External Support
> [INFO] DHIS Hibernate Support
> [INFO] DHIS XML framework services
> [INFO] DHIS System Support
> [INFO] DHIS JDBC Service
> [INFO] DHIS Services Parent Project
> [INFO] DHIS Core API Implementations
> [INFO] DHIS Administration Service
> [INFO] DHIS SMS Service
> [INFO] DHIS Patient API Implementations
> [INFO] DHIS I18n Static
> [INFO] DHIS Data Exchange
> [INFO] DHIS Integration Service
> [INFO] DHIS DataMart Service - Default
> [INFO] DHIS Analytics
> [INFO] DHIS Reporting Service
> [INFO] DHIS Import-Export Service
> [INFO] DHIS Map Generation Service
> [INFO] DHIS Aggregation Service - Default
> [INFO] DHIS Mobile Service
> [INFO] DHIS JDBC / External Test Project
> [INFO]
>
> [INFO]
> 
> [INFO] Building DHIS 2 2.12
> [INFO]
> 
> [INFO]
> [INFO] --- maven-antrun-plugin:1.7:run (default) @ dhis ---
> [INFO] Executing tasks
>
> main:
> [INFO] Executed tasks
> [INFO]
> [INFO] --- maven-install-plugin:2.3:install (default-install) @ dhis ---
> [INFO] Installing /home/cadoyo/2.12/dhis-2/pom.xml to
> /home/cadoyo/.m2/repository/org/hisp/dhis/dhis/2.12/dhis-2.12.pom
> [INFO]
>
> [INFO]
> -

[Dhis2-users] Embedding chart in portal is blank chart

[Michael Mwebaze]

Hi,

I am trying to include a chart externally onto a web portal but with
partial success. A blank chart appears but not the bars and whovering over
the blank chart, I can see the different values. I am not have any issues
with the pivot. Has anyone come across this problem before? I am using
DHIS2.22 and using the below link as reference point

http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/ch01s27.html

Thanks

Regards,

Michael
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Embedding chart in portal is blank chart

[Michael Mwebaze]

Hi Knut,

No I don't have any errors in the Chrome web console.

Regards,

Michael

On 29 July 2016 at 00:24, Knut Staring  wrote:

> Any errors in your Chrome web console?
>
> Knut
>
> On Fri, Jul 29, 2016 at 10:48 AM, Michael Mwebaze <
> michael.mweb...@gmail.com> wrote:
>
>> Hi,
>>
>> I am trying to include a chart externally onto a web portal but with
>> partial success. A blank chart appears but not the bars and whovering over
>> the blank chart, I can see the different values. I am not have any issues
>> with the pivot. Has anyone come across this problem before? I am using
>> DHIS2.22 and using the below link as reference point
>>
>> http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/ch01s27.html
>>
>> Thanks
>>
>> Regards,
>>
>> Michael
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Problem upgrading from 2.20 to 2.21

[Michael Mwebaze]

Hi Bob,

Can you update the dataelement table on postgres by running an update query
and setting the  aggregationtype to 'SUM' where it is 'sum'?

UPDATE dataelement set aggregationtype = 'SUM' where aggregationtype =
'sum';

Regards,

Michael


On 22 July 2016 at 09:09, Bob Jolliffe  wrote:

> Hi
>
> After upgrading from 2.20 to 2.21 system is failing to start with:
>
> ERROR 2016-07-22 09:01:36,593 java.lang.IllegalArgumentException:
> Unknown name value [avg_sum_org_unit] for enum class
> [org.hisp.dhis.analytics.AggregationType]
>
> This looks like one of those new enum upper case restrictions.  Does
> anyone have a quick recipe to solve?
>
> Bob
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Use DHIS2 in other Sectors

[Michael Mwebaze]

Hi Andrew,

DHIS2 has indeed been used in other sectors. Jhpiego, PSI, IPPF, IRC, WHO
have all implemented DHIS2 in one way or another. The last DHIS2 Symposium
in February this year, various presenters showcased their implementations
of DHIS2 which weren't limited to the health field. I am also implementing
it for a diary farm in Uganda.

Regards,

Michael

On 15 July 2016 at 06:15, Muhire Andrew  wrote:

> Dear Community,
>
> Did anyone managed to use DHIS2 in other sectors? not Health.
>
> I would like to hear from your experience and insights.
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS2 SQL View - practical examples

[Michael Mwebaze]

Hi Tantely,

Standard ANSI SQL can be executed easily with-in Sqlviews sub-module in
DHIS2. The link below should be helpful.

http://dhis2.github.io/dhis2-docs/2.22/en/user/html/ch22s06.html

Regards,

Michael

On 5 July 2016 at 04:45, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Thank you Knut for your suggestion.
>
> Regards,
>
> Tantely.
>
> On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring  wrote:
>
>> Hi Raminosa,
>>
>> I think you should try to install Postgres locally on your laptop, which
>> would allow you to easily query the database using PgAdmin.
>>
>> Regards,
>> Knut
>>
>> On Tue, Jul 5, 2016 at 9:13 AM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Hi All,
>>>
>>>
>>> I am looking for a documentation of the use of the SQL syntax to run in
>>> SQL View  (table names, field names specific to DHIS2 ). I have seen for
>>> example to query organization unit, we have to select from “ou” or to use
>>> “dv” to select the datavalues. I am planning to list all the uid, code and
>>> names of all organization units at all levels (1 to 6) in one single query
>>> result.
>>>
>>>
>>> Thank you for your support.
>>>
>>>
>>> Tantely.
>>>
>>> *This message and its attachments are confidential and solely for the
>>> intended recipients. If received in error, please delete them and notify
>>> the sender via reply e-mail immediately.*
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> *Tantely Raminosoa*
> *Data Officer*
> Management Sciences for Health
> Antananarivo Madagascar
> Mobile: 0321180040
> E-mail: tramino...@mikolo.org
> Skype: traminosoa
> 
> Stronger health systems. Greater health impact.
> 
> 
> 
> www.msh.org
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Android SMS Gateway App - Can use for large scale??

[Michael Mwebaze]

HI Harsh,

for such a large implementation you are better off using an SMS gateway
such as Kannel or Jasmin. The android sms gateway is for test purposes.

On 28 June 2016 at 08:31, Jerome Shaguy  wrote:

> Hi Harsh,
> What is the size of the dataset you plan to deploy? We have successfully
> deployed this gateway for a pilot using a small dataset of approximately 16
> data points (elements) in a monthly aggregation. It is not ideal but can be
> used to pilot ideas or as a STOP gap measure whilst planning for a proper
> gateway (which is obviously more expensive).
> On Jun 28, 2016 13:23, "Zubair Asghar Raja"  wrote:
>
>> Hi Harsh,
>>
>> This app was designed for the purpose of testing and demonstration. So
>> its not recommended to be used for production DHIS 2 installations. Using
>> network-based SMS gateways would be a better way.
>>
>>
>>
>>
>> On 28. juni 2016 13:51, Harsh Atal wrote:
>>
>> Hi
>>
>> We are planning to use the Android SMS Gateway app to get data from sms
>> into DHIS. [
>> https://play.google.com/store/apps/details?id=org.dhis2.androidsms&hl=en]
>>
>> But the scale of the implementation which has been finalized is too
>> big(>30 districts) Therefore, now need to know if any one has used the
>> android app for large scale implementation.
>>
>> Also, if any one has tested the maximum sms which can be forwarded in a
>> certain time period?
>>
>> Any inputs will be very helpful.
>>
>> Thanks
>> harsh
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> --
>> Zubair Asghar
>> Software Developer, DHIS2
>> University of Oslowww.dhis2.org
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data Not Showing Up in Reports and Pivot Tables

[Michael Mwebaze]

Hello Ifeanyi,


   1. Are you able to generate resource tables without any errors?
   2. Do you have any values/names for the various Orgunit levels? If yes
   try to rename them and save them just to be certain they are saved in the
   database.
   3. generate resource and analytic tables again

Hope this helps.


Michael

On 21 June 2016 at 10:13, Ifeanyi Okoye  wrote:

> Hello,
>
>
> Weare currently experiencing an issue with the analytics on our
> DHIS2installation.
>
>
>
> Theinstance went live on Thursday and data entry commenced that same day.
> OnSaturday, I tried to run dataset reports and got no output (just the
> formstructure). Pivot tables also returned no data.
>
>
>
> Iran the analytics generation, which completed successfully each time from
> thefront end but still no data. Tried running maintenance but that went
> onindefinitely.
>
>
>
>
>
> Iasked our IT folks to pull the database and system logs and noticed some
> errors(see attached PostgreSQL and Catalina logs).
>
>
>
> Here'sa subsection:
>
>
>
> INFO 2016-06-18 20:51:25,517 Query failed, likely because the
> requestedanalytics table does not exist
> (JdbcAnalyticsManager.java[SimpleAsyncTaskExecutor-487])
>
> org.springframework.jdbc.BadSqlGrammarException:StatementCallback; bad SQL
> grammar [select"dx","co","monthly","uidlevel1",sum(value) as value from
> analytics_2016 where "dx" in ('txAGdhIyCoP')and "co" in ('L8BiaJcGlDA',
> 'Nii07uRlq9I', 'aajj1DKxqPa','deVhyY1hfDO', 'QLmvl8CxNYs', 'UdufjVycW0s',
> 'Kf0uVFPuA8s', 'hlgJQWw4vlY','RSq3AOSIUh1', 'pErlxyLqK8G', 'ofRCydRthqG',
> 'E0oECMnEhKK', 'Lr49tVveh4n','AmgnnAu4Raw', 'hvMYNwgY0fN', 'wy5xiY6VZNM',
> 'yKSHLcb0fVY', 'M3gaIIkX5Ea','zq5W69j1A5O', 'iBipMNkNvEU', 'mQGIahEkqQr',
> 'rVbaaj8FKdA', 'iOr97drPOoZ','WW0OzurqWny', 'dAZsyxKTru2', 'z4R5rXEPVcN',
> 'GenN3reQduf', 'FWDHae3zoIz','dwPdgJxljWD', 'rfVGtr1syCt', 'FQ0T8oicM1q',
> 'zeOLrHi1DED', 'wZey9PSViRb','x4aIvEhgnCX', 'skAHXkrqvUx', 'L6j7K9kmltt',
> 'LVhjAVcUC8z', 'XhCoL9nItWA','O1uKi3kQsGi', 'Fmy4z8hQFri', 'B6Kdba5mGpB',
> 'Ya8X9slYFDV', 'H8HAVyunZwj','ofCLpSSvqFp', 'IXTMAi8ASDP', 'C0cgd3RxLRF',
> 'e2o6yW76PzJ', 'nddeqMEE0s4','qn32iuP28aI', 'REeTM8YMG5t', 'VfrL2mVMKtW',
> 'qU7giGjkkUw', 'oysF1o76Qxl','HPAxapmoBvr', 's9CyZFKA9n7', 'A8A8JF9lpue',
> 'qTTDZKszW4O', 'ujy6e2O2Y6W','BRmlLoDHsjT', 'e27h0KUYBEK', 'okuojwTFZo3',
> 'dQfpHrCSl0J', 'xBHYXY7Lfip','kru3fGkvxka', 'GJMevtelfZp', 'TrhQf5tFVih',
> 'sbWJ3tN5DuY', 'VGt0aLQgbdc') and"monthly" in ('201604') and "uidlevel1" in
> ('C983g0J6p9m')and ( "sASLYFgAkiG" in ('CW20DvNk041') ) and ("LKC6LlcxjzT"
> in ('jj2GfLHSgGP') ) group by"dx","co","monthly","uidlevel1"];nested
> exception is org.postgresql.util.PSQLException: ERROR: column "sASLYFgAkiG"
> does not exist
>
>  Position: 1213
>
>
>
> atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)
>
>
>
> atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
>
>
>
> atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
>
>at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
>
>at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
>
>at
> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
>
>at
> org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
>
>
>
> atorg.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395)
>
>
>
> atorg.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143)
>
>at sun.reflect.GeneratedMethodAccessor538.invoke(Unknown Source)
>
>
>
> Thetext in red is pretty recurrent across the catalina logs from the 18th
> of June.
>
>
>
> Weare running DHIS2 2.22 build 22057.
>
>
>
> Dokindly take a look and help us resolve this.
>
>
>
> Wouldgladly provide any other information  required.
>
>
>
> Thankyou.
>
>
> Warm Regards,
>
> Ifeanyi
>
> Read DrMaestro's Blog
> www.ifeanyiokoye.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Use of dataStore

[Michael Mwebaze]

Hi Stian,

I wasn't able to find any documentation on specifying a namespace in the
manifest file. The links below were particularly helpful and I looked at
the java doc for AppManager api.

https://blueprints.launchpad.net/dhis2/+spec/general-purpose-data-store

https://code.launchpad.net/~stian-sandvold/dhis2/KeyJsonValue

Regards,

Michael

On 20 June 2016 at 08:33, Stian Sandvold  wrote:

> Hey,
>
> seems like the documentation for specifying a namespace have disappeared,
> I will add it back in when I get a chance!
>
> In the mean time, it should be as simple as:
>
> “activities”: {
> “dhis”: {
> “namespace”: “my_name_space”
> }
> }
>
>
>
> I also see that there are some other discrepancies with the documentation
> regarding the namespaces, which I will fix:
>
>  - The name of the namespace reserved by an app does not need to be
> similar to the app it self.
> This way, different apps can share the same namespace, as long as the user
> has the correct access to the apps.
> - A namespace can only be reserved once
> If you are trying to share a namespace between multiple apps, only one of
> them can reserve it in the manifest, and users of the different apps all
> need to be able to use the app with the reservation.
>
>
> ——
> Stian Sandvold
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
>
>
> On 20 Jun 2016, at 12:25, David Siang Fong Oh 
> wrote:
>
> Hi all,
>
> Is there any documentation about specifying a namespace in the manifest
> file? I've tried searching the DHIS2 developer manual and the W3C manifest
> documentation but can't find anything.
>
> Cheers,
>
> -doh
>
> On Mon, Jun 20, 2016 at 1:46 PM, Michael Mwebaze <
> michael.mweb...@gmail.com> wrote:
>
>> Thanks Stian,
>>
>> I finally figured it out.
>>
>> On 20 June 2016 at 02:01, Stian Sandvold  wrote:
>>
>>> Hi,
>>>
>>> defining namespaces in the manifest file only restricts access to the
>>> namespace, it does not create it.
>>>
>>> The namespace will appear as soon as you add some data to it. The way
>>> the dataStore is designed, a namespace only exists when one or more keys
>>> are present in it.
>>>
>>>
>>> Hope this help, and let me know if you need any more help with the
>>> dataStore.
>>>
>>>
>>>
>>> On 20 June 2016 at 06:47, Michael Mwebaze 
>>>  wrote:
>>>
>>>> Hi All,
>>>>
>>>> I am trying to make use of the dataStore resource for my custom app but
>>>> can't seem to add namespace to it. In the manifest file, I have set
>>>> activities.dhis.namespace property and in the tomcat logs I do see that the
>>>> namespace and its value is being read. However
>>>> http://localhost:8181/dhis/api/dataStore is still empty i.e [ ]. Has
>>>> anyone come across this issue? I am using DHIS 2.22 build 22027.
>>>>
>>>> Regards,
>>>>
>>>> Michael
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>> 3
>>>
>>>
>>>> ——
>>> Stian Sandvold
>>> Software developer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>>
>>>
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Use of dataStore

[Michael Mwebaze]

Thanks Stian,

I finally figured it out.

On 20 June 2016 at 02:01, Stian Sandvold  wrote:

> Hi,
>
> defining namespaces in the manifest file only restricts access to the
> namespace, it does not create it.
>
> The namespace will appear as soon as you add some data to it. The way the
> dataStore is designed, a namespace only exists when one or more keys are
> present in it.
>
>
> Hope this help, and let me know if you need any more help with the
> dataStore.
>
>
>
> On 20 June 2016 at 06:47, Michael Mwebaze 
>  wrote:
>
>> Hi All,
>>
>> I am trying to make use of the dataStore resource for my custom app but
>> can't seem to add namespace to it. In the manifest file, I have set
>> activities.dhis.namespace property and in the tomcat logs I do see that the
>> namespace and its value is being read. However
>> http://localhost:8181/dhis/api/dataStore is still empty i.e [ ]. Has
>> anyone come across this issue? I am using DHIS 2.22 build 22027.
>>
>> Regards,
>>
>> Michael
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>> 3
>
>
>> ——
> Stian Sandvold
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Use of dataStore

[Michael Mwebaze]

Hi All,

I am trying to make use of the dataStore resource for my custom app but
can't seem to add namespace to it. In the manifest file, I have set
activities.dhis.namespace property and in the tomcat logs I do see that the
namespace and its value is being read. However
http://localhost:8181/dhis/api/dataStore is still empty i.e [ ]. Has anyone
come across this issue? I am using DHIS 2.22 build 22027.

Regards,

Michael
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] IT provider in Kampala needed

[Michael Mwebaze]

Hi Marta,

Try SPIDD AFRICA LTD
Contact person: Michael Gensi
email: michael.ge...@spiddafrica.com

He should be able to help

Regards,

Michael

On 1 July 2015 at 11:48, Marta Vila  wrote:

> Dearall, in MSF Spain we are organizing a training in Kampala in October
> and we need to hire all the hardware to set the typical academy setup
> (laptops, server, router, network cables... )
>
> We would like to know if there is someone in this list that can recommend
> (or be) a local IT provider.
>
> Thanks!!
>
> Marta
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Problem reading data values with the web api

[Michael Mwebaze]

Hi Uhuru,

I generally tend to use Postman - REST Client a chrome extension for
testing the web services. You can try it too.

Regards,

Michael

On 15 May 2015 at 04:22, Bob Jolliffe  wrote:

> That xml looks perfectly well formed.  Just that there are no
> datavalues to be retrieved for that dataset - orgunit - period
> combination.
>
> On 15 May 2015 at 09:16, Adam Uhuru  wrote:
> > I'm currently trying with curl, typing the request as described in the
> > developer manual. I get this in catalina.out log:
> >
> > * INFO  2015-05-15 08:00:41,376 Get XML data value set for data set:
> > g7iYkNW2YXJ, period: 201405, org unit: s4ubWiG4w51
> > (DataValueSetController.java [http-bio-8080-exec-76])
> >
> > And within curl window:
> >
> >> Authorization: Basic YWRtaW46TGluS21TSVMyMDE0
> >> User-Agent: curl/7.42.0
> >> Accept:application/xml
> >>
> > < HTTP/1.1 200 OK
> > < Server: Apache-Coyote/1.1
> > < Set-Cookie: JSESSIONID=B2C948AB94C974571F2DFD519DD35CB7; Path=/;
> HttpOnly
> > < Content-Type: application/xml;charset=UTF-8
> > < Transfer-Encoding: chunked
> > < Date: Fri, 15 May 2015 08:00:41 GMT
> > <
> >  > xmlns="http://dhis2.org/schema/dxf/2.0"; dataSet="g7iYkNW2YXJ"
> > period="201405" orgUnit="s4ubWiG4w51"/>
> >
> > I also tried with my ssh connection to type the curl request directly on
> the
> > server shell. Same result.
> >
> > I'm using DHIS2 version 2.15
> >
> >
> > On Fri, May 15, 2015 at 10:48 AM, Knut Staring  wrote:
> >>
> >> Which browsers? Which version of DHIS2? Is the system running well
> >> otherwise?
> >>
> >> Can you check the logfile in the Tomcat logs folder?
> >>
> >> On Fri, May 15, 2015 at 9:45 AM, Adam Uhuru 
> wrote:
> >>>
> >>> Hi,
> >>>
> >>> Thank you for your answers.
> >>> I tried that too, by directly entering the query in the browser
> (Chrome).
> >>> I get in response an xml file that contains no value. I also tried with
> >>> json. With csv, I get on the browser this more explicit message:
> >>>
> >>> HTTP Status 406 -
> >>>
> >>> 
> >>>
> >>> type Status report
> >>>
> >>> message
> >>>
> >>> description The resource identified by this request is only capable of
> >>> generating responses with characteristics not acceptable according to
> the
> >>> request "accept" headers ().
> >>>
> >>> 
> >>>
> >>> Apache Tomcat/7.0.26
> >>>
> >>>
> >>> Is there something to check on the server ?
> >>>
> >>> On Fri, May 15, 2015 at 8:34 AM, Knut Staring 
> wrote:
> 
>  You can also replace .XML with .json for an alternative view.
> 
>  On May 15, 2015 6:19 AM, "Jason Pickering" <
> jason.p.picker...@gmail.com>
>  wrote:
> >
> > Hi Adam,
> > This is not an error really, but just your browser telling you that
> it
> > cannot render the XML which the API returns to it. You can use
> Google Chrome
> > or Firefox and you will be able to see the XML. There are also
> browser
> > plugins available which will render it more human readable form.
> >
> > Regards,
> > Jason
> >
> >
> > On Fri, May 15, 2015 at 3:36 AM Adam Uhuru 
> > wrote:
> >>
> >> Hi
> >>
> >> I am trying to read data values using the web api, and followed the
> >> developer manual. I am getting this error message each time:
> >>
> >> This XML file does not appear to have any style information
> associated
> >> with it. The document tree is shown below.
> >>
> >> This error happens when even typing the request on the browser this
> >> way
> >> http://domain:port
> /api/dataValueSets.xml?dataSet=ID1&orgUnit=ID2&period=201401
> >>
> >> Do you know what could raise this error ?
> >>
> >> Thank you for your help.
> >>
> >> Regards,
> >> Adam
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-users
> >> Post to : dhis2-users@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> More help   : https://help.launchpad.net/ListHelp
> >
> >
> > ___
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to : dhis2-users@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
> >
> >>>
> >>>
> >>>
> >>> --
> >>> Regards,
> >>> Adam
> >>
> >>
> >>
> >>
> >> --
> >> Knut Staring
> >> Dept. of Informatics, University of Oslo
> >> Norway: +4791880522
> >> Skype: knutstar
> >> http://dhis2.org
> >
> >
> >
> >
> > --
> > Regards,
> > Adam
> >
> > ___
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to : dhis2-users@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
> >
>
> ___
> Mailing list: https://la

Re: [Dhis2-users] Chart comparing two time intervals

[Michael Mwebaze]

Hi all,

a work around for this could be to create the graphs separately, save them
as favorites and add and resize them to your dashboard.

Regards,

Michael

On 23 April 2015 at 10:41, Olav Poppe  wrote:

> +1 for this - also useful for data quality-related reports.
>
>
>
> 23. apr. 2015 kl. 16.30 skrev Bram Piot :
>
>
> Same here, +1 for PSI. It's a common request that users (and donors!) have
> so we would love to see it in the next generation chart engine :-)
>
>
> --
> Bram Piot
>
> Leader, Evidence-Based Decision Making | West & Central Africa
> Population Services International | Dakar, Senegal
> C: +221 77 479 40 74 | Skype: bram_piot
>
>
> psi.org  |  Twitter  
> | Facebook
> 
> | YouTube  | psiimpact.com
>
> 93 cents of every dollar raised directly supports PSI programs. Donate at
> psi.org
> 
>
>
> On 23 April 2015 at 10:13, Knut Staring  wrote:
>
>> Not that it helps you much, but this did indeed come up as a requirement
>> with weekly data for Early Warning (quite similar to IDSR) in Cambodia,
>> where I ended up making a custom app to allow comparison of this year with
>> the average of the 3 preceding years. So this is a +1 vote for adding such
>> functionality for all sub-annual data (though the most common use cases are
>> probably weekly, or even daily).
>>
>> On Thu, Apr 23, 2015 at 4:08 PM, Johan Ivar Sæbø 
>> wrote:
>>
>>> Hi,
>>>
>>> a common requirement here at the West African IDSR workshop is to
>>> compare values of one data element/indicator over two time periods,
>>> typically two years as indicated in the attached example. I remember this
>>> being possible in old DHIS->Excel pivot tables when periods were split in
>>> "month" and "year", but with the "Month year" period I don't see how it can
>>> be done in the DHIS. Is there a way to do this, and if not; can it be
>>> considered as a new feature? Not sure how it could be done, but some ad-hoc
>>> creation of time series perhaps. We can always export it or make custom
>>> report, but it seems common enough for IDSR analysis to be useful on-demand
>>> inside DHIS.
>>>
>>> Regards,
>>> Johan
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Please help me for a blank run-able DHIS2 database

[Michael Mwebaze]

Hi Liem,

I am glad I was of help.

Cheers

On 22 April 2015 at 06:01, Liem Le Duy  wrote:

> Hi Michael & Alex,
>
> It's MAGIC!, the DHIS2 support to generate new database from hql schema?
>
> I tried with new database and it run more faster, some actions can be
> tested as first time I see
>
> I also will try the option as Alex suggested by tomorrow and report you. I
> have to leave now
>
> I am very appreciated to your help!
>
> Thank you all a lot!
> Best regards
> Liem
>
>
>
>
> On Wed, Apr 22, 2015 at 4:47 PM, Alex Tumwesigye 
> wrote:
>
>> Hi Liem,
>>
>> Please try this tomcat setting.
>>
>> JAVA_OPTS="-Xmx2000m -XX:MaxPermSize=800m"
>>
>> Alex
>>
>> On Wed, Apr 22, 2015 at 12:45 PM, Liem Le Duy 
>> wrote:
>>
>>> Hi Nieker,
>>>
>>> Could you please create another thread for your issue? :)
>>>
>>> Thank you
>>> Liem
>>>
>>> On Wed, Apr 22, 2015 at 4:41 PM, Alex Tumwesigye 
>>> wrote:
>>>
>>>> Dear Niekerk,
>>>>
>>>> Please visit https://www.dhis2.org/downloads for DHIS2 software.
>>>> For documentation, please visit https://www.dhis2.org/documentation
>>>>
>>>>
>>>> Alex
>>>>
>>>> On Wed, Apr 22, 2015 at 12:36 PM, Niekerk, AK, Mnr 
>>>>  wrote:
>>>>
>>>>>  Good Day All,
>>>>>
>>>>>
>>>>>
>>>>> I am new to the forum and I have identified that DHIS2 is a tool that
>>>>> could be used to monitor patient outcome indicators but I have no idea how
>>>>> to go about requesting access to it. I know where to download the tool and
>>>>> the resource documents but creating or requesting access is what I seem to
>>>>> be having difficulty with.
>>>>>
>>>>>
>>>>>
>>>>> Is anyone able to direct/assist me?
>>>>>
>>>>>
>>>>>
>>>>> Kind Regards,
>>>>>
>>>>>
>>>>>
>>>>> *Ashley Niekerk*
>>>>>
>>>>> Programme Data Manager
>>>>>
>>>>> *South to South Program for Comprehensive Family HIV Care & Treatment *
>>>>>
>>>>> Department of Paediatrics and Child Health, Faculty of Medicine and
>>>>> Health Sciences, Stellenbosch University | 3rd Floor, Teaching Block,
>>>>> Tygerberg Campus , Francie van Zyl Drive, Tygerberg 7505 | Tel +27
>>>>> 021 938 9972 | Fax +27  021 938 9972 |
>>>>>
>>>>> Toll free 0800 050 050 | Email: akniek...@sun.ac.za |
>>>>> www.sun.ac.za/southtosouth
>>>>>
>>>>> [image: cid:image002.jpg@01CE98CD.649BE8E0]
>>>>>
>>>>>
>>>>>
>>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+akniekerk=
>>>>> sun.ac...@lists.launchpad.net] *On Behalf Of *Liem Le Duy
>>>>> *Sent:* 22 April 2015 11:34 AM
>>>>> *To:* Michael Mwebaze
>>>>> *Cc:* dhis2-users
>>>>> *Subject:* Re: [Dhis2-users] Please help me for a blank run-able
>>>>> DHIS2 database
>>>>>
>>>>>
>>>>>
>>>>> Hi Michael,
>>>>>
>>>>> I downloaded version 2.18 from this site
>>>>> https://www.dhis2.org/downloads. I just a newbie in this domain for 2
>>>>> days and don't know where is better resource
>>>>>
>>>>> Best
>>>>>
>>>>> Liem
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Apr 22, 2015 at 4:29 PM, Michael Mwebaze <
>>>>> michael.mweb...@gmail.com> wrote:
>>>>>
>>>>>   Liem,
>>>>>
>>>>> are you using the war downloaded from the dhis portal? I remember
>>>>> having issues with it so I had to checkout the source code and do a fresh
>>>>> maven build and was then able to deploy it. I am hoping you don't have to
>>>>> go that far.
>>>>>
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> Michael
>>>>>
>>>>>
>>>>>
>>>>> On 22 April 2015 at 05:23, Liem Le Duy 
>>>>> wrote:
>>>>>
>>>>

Re: [Dhis2-users] Please help me for a blank run-able DHIS2 database

[Michael Mwebaze]

Liem,

are you using the war downloaded from the dhis portal? I remember having
issues with it so I had to checkout the source code and do a fresh maven
build and was then able to deploy it. I am hoping you don't have to go that
far.


Regards,

Michael

On 22 April 2015 at 05:23, Liem Le Duy  wrote:

> Hi Michael,
>
> Thank for your response
>
> Here below is my pc information
>
> RAM: 8gb
> JAVA_OPTS='-Xmx1024m -Xms1024m -XX:PermSize=512m -XX:MaxPermSize=1024m'
> TOMCAT: 8.0.21
> Java 7
> DHIS 2.18
> Psql 9.4
>
> If you want I will start TeamViewer so you can remote access
> Thank you a lot
> Liem
>
>
> On Wed, Apr 22, 2015 at 4:18 PM, Michael Mwebaze <
> michael.mweb...@gmail.com> wrote:
>
>> Hi Liem,
>>
>> How much RAM does your system have? My laptop has 4GB of RAM and I am
>> able to run the DHIS2 (with Sierra Leone DB) without any problem with the
>> following settings:
>>
>> JAVA_OPTS  -Xmx512m -XX:MaxPermSize=256m
>>
>> Tomcat : 8.0.15
>>
>> Java 7
>>
>> DHIS 2.18
>>
>> Psql 9.3
>>
>> What version of the DHIS2 have you deployed?
>>
>> Regards,
>>
>> Michael
>>
>> On 22 April 2015 at 04:59, Liem Le Duy  wrote:
>>
>>> Hi everyone,
>>>
>>>
>>> 1. Using command-line to start Tomcat to see error, I can not see any
>>> error thrown out on screen. But I see into the log file, there is a message
>>> "No Spring WebApplicationInitializer types detected on classpath"
>>>
>>> 2. To change JAVA_OPTS
>>> I already try some values, you can see some values in the SEV image
>>> below that start by REM. But performance still slow
>>>
>>> 3. In the performance image, I captured the %CPU that Tomcat process
>>> take (at the first line)
>>>
>>> Please correct me if any my mistake of configuration
>>>
>>>
>>> On Wed, Apr 22, 2015 at 3:44 PM, Liem Le Duy 
>>> wrote:
>>>
>>>> It's very slow on my pc now, I will try to follow all your suggest and
>>>> report later
>>>>
>>>> thank you all a lot
>>>> Best
>>>>
>>>> On Wed, Apr 22, 2015 at 3:24 PM, John Lewis 
>>>> wrote:
>>>>
>>>>> Hi Liem,
>>>>> you need to set memory for tomcat.
>>>>>
>>>>> JAVA_OPTS="-Xmx1024m -Xms1024m -XX:PermSize=512m -XX:MaxPermSize=1024m"
>>>>>
>>>>> On Wed, Apr 22, 2015 at 3:19 PM, Liem Le Duy <
>>>>> liem.le...@pkgdvietuc.com> wrote:
>>>>>
>>>>>> Hi Michael,
>>>>>>
>>>>>> Yes, correctly, I have checked the Tomcat process always take more
>>>>>> than 80% CPU
>>>>>>
>>>>>> I will try to start manually to see what happened
>>>>>>
>>>>>> Thank you a lot
>>>>>> Liem
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Apr 22, 2015 at 3:09 PM, Michael Mwebaze <
>>>>>> michael.mweb...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Liem,
>>>>>>>
>>>>>>> if you deployed the war into tomcat, you might also want to increase
>>>>>>> the memory allocation to your tomcat. This will help significantly. 
>>>>>>> Also if
>>>>>>> possible, start Tomcat from the command line so you are able to see if 
>>>>>>> any
>>>>>>> exceptions are being thrown so you can troubleshoot. I hope this helps.
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Michael
>>>>>>>
>>>>>>> On 22 April 2015 at 04:03, John Lewis 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi Liem,
>>>>>>>> How have you installed dhis2 using dhis2 live or individual
>>>>>>>> component.
>>>>>>>> you can create a database (empty) and use that database name in
>>>>>>>> hibernate.properties file.
>>>>>>>> is it h2 database or postgres.
>>>>>>>> John
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 3:00 PM, Liem Le Duy <
>>>>>>>> liem.le...@pkgdvietuc.com> wrote:
>>&

Re: [Dhis2-users] Please help me for a blank run-able DHIS2 database

[Michael Mwebaze]

Hi Liem,

How much RAM does your system have? My laptop has 4GB of RAM and I am able
to run the DHIS2 (with Sierra Leone DB) without any problem with the
following settings:

JAVA_OPTS  -Xmx512m -XX:MaxPermSize=256m

Tomcat : 8.0.15

Java 7

DHIS 2.18

Psql 9.3

What version of the DHIS2 have you deployed?

Regards,

Michael

On 22 April 2015 at 04:59, Liem Le Duy  wrote:

> Hi everyone,
>
>
> 1. Using command-line to start Tomcat to see error, I can not see any
> error thrown out on screen. But I see into the log file, there is a message
> "No Spring WebApplicationInitializer types detected on classpath"
>
> 2. To change JAVA_OPTS
> I already try some values, you can see some values in the SEV image below
> that start by REM. But performance still slow
>
> 3. In the performance image, I captured the %CPU that Tomcat process take
> (at the first line)
>
> Please correct me if any my mistake of configuration
>
>
> On Wed, Apr 22, 2015 at 3:44 PM, Liem Le Duy 
> wrote:
>
>> It's very slow on my pc now, I will try to follow all your suggest and
>> report later
>>
>> thank you all a lot
>> Best
>>
>> On Wed, Apr 22, 2015 at 3:24 PM, John Lewis 
>> wrote:
>>
>>> Hi Liem,
>>> you need to set memory for tomcat.
>>>
>>> JAVA_OPTS="-Xmx1024m -Xms1024m -XX:PermSize=512m -XX:MaxPermSize=1024m"
>>>
>>> On Wed, Apr 22, 2015 at 3:19 PM, Liem Le Duy 
>>> wrote:
>>>
>>>> Hi Michael,
>>>>
>>>> Yes, correctly, I have checked the Tomcat process always take more than
>>>> 80% CPU
>>>>
>>>> I will try to start manually to see what happened
>>>>
>>>> Thank you a lot
>>>> Liem
>>>>
>>>>
>>>>
>>>> On Wed, Apr 22, 2015 at 3:09 PM, Michael Mwebaze <
>>>> michael.mweb...@gmail.com> wrote:
>>>>
>>>>> Hi Liem,
>>>>>
>>>>> if you deployed the war into tomcat, you might also want to increase
>>>>> the memory allocation to your tomcat. This will help significantly. Also 
>>>>> if
>>>>> possible, start Tomcat from the command line so you are able to see if any
>>>>> exceptions are being thrown so you can troubleshoot. I hope this helps.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Michael
>>>>>
>>>>> On 22 April 2015 at 04:03, John Lewis 
>>>>> wrote:
>>>>>
>>>>>> Hi Liem,
>>>>>> How have you installed dhis2 using dhis2 live or individual
>>>>>> component.
>>>>>> you can create a database (empty) and use that database name in
>>>>>> hibernate.properties file.
>>>>>> is it h2 database or postgres.
>>>>>> John
>>>>>>
>>>>>> On Wed, Apr 22, 2015 at 3:00 PM, Liem Le Duy <
>>>>>> liem.le...@pkgdvietuc.com> wrote:
>>>>>>
>>>>>>> Dear,
>>>>>>>
>>>>>>> My name is Liem, I am from Viet Nam. I am newbie in DHIS2
>>>>>>>
>>>>>>> I already installed DHIS2 on my pc with Serra Leon data example, the
>>>>>>> web site work but the performance is trouble. I can only log-in, any 
>>>>>>> action
>>>>>>> after log-in successful take long time, I did some actions such as "kick
>>>>>>> profile button".. then waited but the browser always in progress of
>>>>>>> connecting and return nothing for us
>>>>>>>
>>>>>>> I worry about of Serra Leon example data is huge, so that it cause
>>>>>>> performance
>>>>>>>
>>>>>>> Actually I hope to have a blank database version that come up with a
>>>>>>> lit bit data such as user, role,..but can be run-able however with more
>>>>>>> than 320 tables I still not clarified on so I dont know what first 
>>>>>>> point to
>>>>>>> start to have it
>>>>>>>
>>>>>>> So I think to you!, I will be very appreciated if you can send me a
>>>>>>> blank run-able data or suggest me some clues so I can easy to create it
>>>>>>>
>>>>>>> Thank you so much, for reading & understand my condition
>>>>>>>
>>>>>>> I am looking forward to your response
>>>>>>> Best regards
>>>>>>>
>>>>>>> ___
>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> ___
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Please help me for a blank run-able DHIS2 database

[Michael Mwebaze]

Hi Liem,

if you deployed the war into tomcat, you might also want to increase the
memory allocation to your tomcat. This will help significantly. Also if
possible, start Tomcat from the command line so you are able to see if any
exceptions are being thrown so you can troubleshoot. I hope this helps.

Regards,

Michael

On 22 April 2015 at 04:03, John Lewis  wrote:

> Hi Liem,
> How have you installed dhis2 using dhis2 live or individual component.
> you can create a database (empty) and use that database name in
> hibernate.properties file.
> is it h2 database or postgres.
> John
>
> On Wed, Apr 22, 2015 at 3:00 PM, Liem Le Duy 
> wrote:
>
>> Dear,
>>
>> My name is Liem, I am from Viet Nam. I am newbie in DHIS2
>>
>> I already installed DHIS2 on my pc with Serra Leon data example, the web
>> site work but the performance is trouble. I can only log-in, any action
>> after log-in successful take long time, I did some actions such as "kick
>> profile button".. then waited but the browser always in progress of
>> connecting and return nothing for us
>>
>> I worry about of Serra Leon example data is huge, so that it cause
>> performance
>>
>> Actually I hope to have a blank database version that come up with a lit
>> bit data such as user, role,..but can be run-able however with more than
>> 320 tables I still not clarified on so I dont know what first point to
>> start to have it
>>
>> So I think to you!, I will be very appreciated if you can send me a blank
>> run-able data or suggest me some clues so I can easy to create it
>>
>> Thank you so much, for reading & understand my condition
>>
>> I am looking forward to your response
>> Best regards
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Turn off data aggregation

[Michael Mwebaze]

Hi Laura,

in my case I was able to find a solution by configuration the aggregations
levels before I imported the data from the legacy system. Once the
aggregation levels were defined, then the system stopped aggregating the
data which is what I wanted since I was dealing with survey data from a
legacy system. You might also want to change your table layout as well.

Regards,

Michael

On 14 April 2015 at 15:52, Laura E. Lincks 
wrote:

> Michael,
>
> I was wondering if you had any luck with this. I'm working with an
> instance where some data elements are set up to have Aggregation Levels
> (set at site/facility all the way up to Nation, the highest level of the
> OrgUnit hierarchy.) (However, we're using version 2.14 in this particular
> country). We're having difficulty when summing the data in a pivot table at
> any level above site/facility. If I remove the Aggregation Levels from the
> data elements I have better luck (but still have some strange problem.) I'd
> love to hear what success you've had.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>
>
>
> On Wed, Apr 1, 2015 at 5:20 AM, Michael Mwebaze  > wrote:
>
>> Hi,
>>
>> I have been trying to configure DHIS2.18 to use aggregation levels but
>> they seem not to work. I don't want the system to aggregate the data
>> element values at each org unit. Setting the selected aggregation level
>> with-in the data element doesn't seem to work.
>>
>> Anyone done this before?
>>
>> Michael
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Turn off data aggregation

[Michael Mwebaze]

Hi,

I have been trying to configure DHIS2.18 to use aggregation levels but they
seem not to work. I don't want the system to aggregate the data element
values at each org unit. Setting the selected aggregation level with-in the
data element doesn't seem to work.

Anyone done this before?

Michael
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp