[Dhis2-users] (no subject)

[harsha siriwardana]

Hi, I solved the issue in GHIS Android dashboard mentioned in the
Github. But i am finding difficult to add it as pull request ! Anyone
to help me with this

Thanks

___
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] Data Set problem

[Carlos Nyembwe]

>
> Hello Team
>

I have a problem about Data Set.
We are fixing something in our DHIS2 but, we need to assign to some users a
dataset for entering data and some data set just for view data.
Could you help me if is it possible in usual DHIS2

Regards

-- 
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
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] ETL process with DHIS2

[henri claude moungui]

Thank you Uwe for sharing your experience. Better late than never  I agree with 
you. It is effectively the graphical data-flow on ETL that is missing on 
DHIS2...
Regards.
Henri
  

Le Jeudi 24 mars 2016 9h18, Uwe Wahser  a écrit :
 

 HI Henri,

sorry for for chipping in late, I am on vaccation. We are using kettle for
extracting data into DHIS2 as a prototype for a datawarehouse in a corporate
setting. A few of Aarons points on Talend apply for kettle as well. Things can
get tricky, but that is partly because of the nature of data import into DHIS2.
Support, community etc are not as vivid as the DHIS2 community, but you still
find some material on the net.

It runs and does the job. Currently we are batteling with memory issues as I am
trying to find some suitable method of packaging data partitions. Again, that is
not only kettles fault.

I just found out that the MoH is also using kettle in their HMIS setting, so I
am quite confident to have a few ressource persons in the country for
sustainable hand-over.

Compared to R etc I like the graphical data-flow, which helps when discussing
transformations with users. You can actually see what is going into and is
coming out of a process with a mouse-click.

Our current transformations are quite generique for extracting from a custom
data-source, hoping to put them on the net after some clean ups.

Generally speaking I'd prefere to have more extensive ETL capabilites within
DHIS2, though, e.g. to better synchronise and monitor load-jobs, not having to
allocate memory to two java engines, consistent management of data-elements
etc... 

Regards,

Uwe
> henri claude moungui  hat am 23. März 2016 um 11:01
> geschrieben:
> 
> 
> Hi.Thank you Ant, Knut, Jason and Aaron for the tips. I'm sure the discussions
> we are having will make us continue to improve the DHIS2 platform,
> particularly for datawarehouse implementations.I was also looking for Kettle
> and Talend for this purpose. Finally, I found DHIS2 very comfortable for
> Export and Import as it is possible to do this step by step (you choose which
> metadata you want to export/import). Now I see the way is how to TRANSFORM the
> Excel databases to fit with the exported file. For now, I intend to do this
> manually...
> Thank you.
>  
>   
> 
>    Le Mardi 22 mars 2016 7h58, Aaron Gladders  a écrit
> :
>  
> 
>  Hi - we did some work using Talend based on client desires.  We found it to
> be an incredible pain in the butt.  Although our group are typically senior
> software developers or technical architects we had to pull in vendor
> consultants to get training on how to use it and ultimately dumped it.  Beware
> the marketing - they all promote self-service but I suspect you'll either be
> bringing in their trainers, hiring their consultants or finding your own
> software developers to actually get the job done.
> Aaron
> 
> On Tue, Mar 22, 2016 at 12:04 AM, Knut Staring  wrote:
> 
> Good point, Ant.
> Here is a link to that conversation, with many interesting
> points:https://lists.launchpad.net/dhis2-users/msg09234.html
> 
> Knut
> On Tue, Mar 22, 2016 at 6:23 AM, Ant Snyman  wrote:
> 
> Hi Henri,I read on this forum that someone was attempting to use Kettle
> (Pentaho Data Integration). I don't know whether they succeeded.RegardsAnt
> Snyman
> On 21 March 2016 at 18:21, henri claude moungui  wrote:
> 
> Thank you Knut.
> Henri 
>   
> 
>    Le Lundi 21 mars 2016 15h25, Knut Staring  a écrit :
>  
> 
>  Hi Henri,
> There is no specific 3rd party software that you have to use, people use many
> different tools. Perhaps most commonly, people use scripts in Python or R or
> similar to load data. You can import both metadata and data in CSV format, for
> example.
> http://dhis2.github.io/dhis2-docs/2.21/en/developer/html/ch01s10.html
> http://dhis2.github.io/dhis2-docs/2.21/en/user/html/ch21.html
> 
> Knut
> On Mon, Mar 21, 2016 at 3:15 PM, henri claude moungui 
> wrote:
> 
> Hi to all.I want to test the ETL process with DHIS2. Is there an automated way
> to do this? is there a recommended tiers soft to use for this? my operational
> DB to use are excel files.Thank you in advance.
> Henri Moungui 
>  
> ___
> 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 StaringDept. of Informatics, University of OsloNorway: +4791880522
> Skype: knutstarhttp://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] New DHIS2 Installation white/blank screen

[Adam Dawoodjee]

I'll consider changing the port once the .war is fully extracted.

PS: to be fully specific I'm running a smaller server with:
- Ubuntu server 14.04
- 2 GB RAM
- Celeron D with >= 2.5GHz

On Thu, Mar 24, 2016 at 5:32 PM, Knut Staring  wrote:

> Also, if you are running just plain Tomcat (without nginx reverse proxy),
> you probably want to look at port 8080 instead.
>
> On Thu, Mar 24, 2016 at 4:30 PM, Knut Staring  wrote:
>
>> Hi Adam, there is bound to be more interesting info before the tail end
>> of the log that you shared.
>>
>> On Thu, Mar 24, 2016 at 4:12 PM, Adam Dawoodjee 
>> wrote:
>>
>>> Hello Communty,
>>>
>>>
>>> I just finished installing DHIS2. When I run 192.x.x.2 (port 80). I get
>>> a blank screen. The only clue I've got is the abnormal catalina.out log:
>>>
>>> 
>>>
>>> dhis@webserver:~$ tail -f tomcat-dhis/logs/catalina.out
>>> at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>> at java.lang.Thread.run(Thread.java:745)
>>>
>>> Mar 24, 2016 5:04:31 PM org.apache.coyote.AbstractProtocol start
>>> INFO: Starting ProtocolHandler ["http-bio-80"]
>>> Mar 24, 2016 5:04:31 PM org.apache.catalina.startup.Catalina start
>>> INFO: Server startup in 966 ms
>>>
>>>
>>> -
>>>
>>> Seeing *concurrent  *I thought perhaps I have two tomcat/java instances
>>> running. But stopping tomcat and starting one instance leaves nothing
>>> running (I get
>>> *This site can’t be reached* in the browser).
>>>
>>> Kindly help.
>>>
>>> Thanks
>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> 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] New DHIS2 Installation white/blank screen

[Adam Dawoodjee]

You're right Knut!


I found the problem. In my case, I had cancelled the first dhis.war
download and started a second. *mv dhis.war tomcat-dhis/webapps/ROOT.war*
was copying the broken* dhis.war* file (colored peach). This can be seen
from the log excerpt below:

...
INFO: Deploying web application archive
/home/dhis/tomcat-dhis/webapps/ROOT.war
Mar 24, 2016 1:28:27 PM org.apache.catalina.startup.ContextConfig
beforeStart
SEVERE: Exception fixing docBase for context []
java.util.zip.*ZipException: error in opening zip file*
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(ZipFile.java:219)
at java.util.zip.ZipFile.(ZipFile.java:149)
at java.util.jar.JarFile.(JarFile.java:166)
at java.util.jar.JarFile.(JarFile.java:103)
at sun.net.www.protocol.jar.URLJarFile.(URLJarFile.java:93)
at
sun.net.www.protocol.jar.URLJarFile.getJarFile(URLJarFile.java:69)
at
sun.net.www.protocol.jar.JarFileFactory.get(JarFileFactory.java:99)
at sun.net.www.protocol.jar.JarURLConnection.connect
...


Only problem is I'm installing on a smaller server which is taking forever
to extract the ROOT.war file. Over 30 minutes now.

--
Adam

On Thu, Mar 24, 2016 at 5:12 PM, Adam Dawoodjee 
wrote:

> Hello Communty,
>
>
> I just finished installing DHIS2. When I run 192.x.x.2 (port 80). I get a
> blank screen. The only clue I've got is the abnormal catalina.out log:
>
> 
>
> dhis@webserver:~$ tail -f tomcat-dhis/logs/catalina.out
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
>
> Mar 24, 2016 5:04:31 PM org.apache.coyote.AbstractProtocol start
> INFO: Starting ProtocolHandler ["http-bio-80"]
> Mar 24, 2016 5:04:31 PM org.apache.catalina.startup.Catalina start
> INFO: Server startup in 966 ms
>
>
> -
>
> Seeing *concurrent  *I thought perhaps I have two tomcat/java instances
> running. But stopping tomcat and starting one instance leaves nothing
> running (I get
> *This site can’t be reached* in the browser).
>
> Kindly help.
>
> Thanks
> 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

Re: [Dhis2-users] New DHIS2 Installation white/blank screen

[Knut Staring]

And do you not have a name for your .war file? meaning /dhis or something

On Thu, Mar 24, 2016 at 4:32 PM, Knut Staring  wrote:

> Also, if you are running just plain Tomcat (without nginx reverse proxy),
> you probably want to look at port 8080 instead.
>
> On Thu, Mar 24, 2016 at 4:30 PM, Knut Staring  wrote:
>
>> Hi Adam, there is bound to be more interesting info before the tail end
>> of the log that you shared.
>>
>> On Thu, Mar 24, 2016 at 4:12 PM, Adam Dawoodjee 
>> wrote:
>>
>>> Hello Communty,
>>>
>>>
>>> I just finished installing DHIS2. When I run 192.x.x.2 (port 80). I get
>>> a blank screen. The only clue I've got is the abnormal catalina.out log:
>>>
>>> 
>>>
>>> dhis@webserver:~$ tail -f tomcat-dhis/logs/catalina.out
>>> at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>> at java.lang.Thread.run(Thread.java:745)
>>>
>>> Mar 24, 2016 5:04:31 PM org.apache.coyote.AbstractProtocol start
>>> INFO: Starting ProtocolHandler ["http-bio-80"]
>>> Mar 24, 2016 5:04:31 PM org.apache.catalina.startup.Catalina start
>>> INFO: Server startup in 966 ms
>>>
>>>
>>> -
>>>
>>> Seeing *concurrent  *I thought perhaps I have two tomcat/java instances
>>> running. But stopping tomcat and starting one instance leaves nothing
>>> running (I get
>>> *This site can’t be reached* in the browser).
>>>
>>> Kindly help.
>>>
>>> Thanks
>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>



-- 
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] New DHIS2 Installation white/blank screen

[Knut Staring]

Also, if you are running just plain Tomcat (without nginx reverse proxy),
you probably want to look at port 8080 instead.

On Thu, Mar 24, 2016 at 4:30 PM, Knut Staring  wrote:

> Hi Adam, there is bound to be more interesting info before the tail end of
> the log that you shared.
>
> On Thu, Mar 24, 2016 at 4:12 PM, Adam Dawoodjee 
> wrote:
>
>> Hello Communty,
>>
>>
>> I just finished installing DHIS2. When I run 192.x.x.2 (port 80). I get a
>> blank screen. The only clue I've got is the abnormal catalina.out log:
>>
>> 
>>
>> dhis@webserver:~$ tail -f tomcat-dhis/logs/catalina.out
>> at
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>> at java.lang.Thread.run(Thread.java:745)
>>
>> Mar 24, 2016 5:04:31 PM org.apache.coyote.AbstractProtocol start
>> INFO: Starting ProtocolHandler ["http-bio-80"]
>> Mar 24, 2016 5:04:31 PM org.apache.catalina.startup.Catalina start
>> INFO: Server startup in 966 ms
>>
>>
>> -
>>
>> Seeing *concurrent  *I thought perhaps I have two tomcat/java instances
>> running. But stopping tomcat and starting one instance leaves nothing
>> running (I get
>> *This site can’t be reached* in the browser).
>>
>> Kindly help.
>>
>> Thanks
>> 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
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>



-- 
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] New DHIS2 Installation white/blank screen

[Knut Staring]

Hi Adam, there is bound to be more interesting info before the tail end of
the log that you shared.

On Thu, Mar 24, 2016 at 4:12 PM, Adam Dawoodjee 
wrote:

> Hello Communty,
>
>
> I just finished installing DHIS2. When I run 192.x.x.2 (port 80). I get a
> blank screen. The only clue I've got is the abnormal catalina.out log:
>
> 
>
> dhis@webserver:~$ tail -f tomcat-dhis/logs/catalina.out
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
>
> Mar 24, 2016 5:04:31 PM org.apache.coyote.AbstractProtocol start
> INFO: Starting ProtocolHandler ["http-bio-80"]
> Mar 24, 2016 5:04:31 PM org.apache.catalina.startup.Catalina start
> INFO: Server startup in 966 ms
>
>
> -
>
> Seeing *concurrent  *I thought perhaps I have two tomcat/java instances
> running. But stopping tomcat and starting one instance leaves nothing
> running (I get
> *This site can’t be reached* in the browser).
>
> Kindly help.
>
> Thanks
> 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
>
>


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

[Dhis2-users] New DHIS2 Installation white/blank screen

[Adam Dawoodjee]

Hello Communty,


I just finished installing DHIS2. When I run 192.x.x.2 (port 80). I get a
blank screen. The only clue I've got is the abnormal catalina.out log:



dhis@webserver:~$ tail -f tomcat-dhis/logs/catalina.out
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Mar 24, 2016 5:04:31 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-80"]
Mar 24, 2016 5:04:31 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 966 ms


-

Seeing *concurrent  *I thought perhaps I have two tomcat/java instances
running. But stopping tomcat and starting one instance leaves nothing
running (I get
*This site can’t be reached* in the browser).

Kindly help.

Thanks
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

Re: [Dhis2-users] Orgunits tree

[Jason Pickering]

Hi David,

This is usually caused by selecting too many "Data capture and maintenance
organisation units" and has been discussed recently on the list.

You should only select the parent of the orgunits which this user should
have access to. So, if this user should only record data for a specific
district, you should select that district (and only that district). The
user will then be able to see this district, and all facilities in that
district.

Please see  this section in the user manual:

http://dhis2.github.io/dhis2-docs/master/en/user/html/ch07.html#user_by_org_unit



and specifically section 7.1.3. User management, which explains how to
properly use this feature.


Best regards,
Jason

On Thu, Mar 24, 2016 at 7:29 AM, mugume david  wrote:

> Hello team,
>
> Has anyone faced the issue where orgunit trees are not well structured. I
> just see the final nodes and not the full tree, which is annoying
> especially when you have too many final nodes. (You can't know what belongs
> to what).
>
> Any way around this. Clearing cache isnt helping.
>
> Thanks,
>
> [image: Inline image 1]
>
>
> *David Mugume*
> +256 704 008815
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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] ETL process with DHIS2

[Uwe Wahser]

HI Henri,

sorry for for chipping in late, I am on vaccation. We are using kettle for
extracting data into DHIS2 as a prototype for a datawarehouse in a corporate
setting. A few of Aarons points on Talend apply for kettle as well. Things can
get tricky, but that is partly because of the nature of data import into DHIS2.
Support, community etc are not as vivid as the DHIS2 community, but you still
find some material on the net.

It runs and does the job. Currently we are batteling with memory issues as I am
trying to find some suitable method of packaging data partitions. Again, that is
not only kettles fault.

I just found out that the MoH is also using kettle in their HMIS setting, so I
am quite confident to have a few ressource persons in the country for
sustainable hand-over.

Compared to R etc I like the graphical data-flow, which helps when discussing
transformations with users. You can actually see what is going into and is
coming out of a process with a mouse-click.

Our current transformations are quite generique for extracting from a custom
data-source, hoping to put them on the net after some clean ups.

Generally speaking I'd prefere to have more extensive ETL capabilites within
DHIS2, though, e.g. to better synchronise and monitor load-jobs, not having to
allocate memory to two java engines, consistent management of data-elements
etc... 

Regards,

Uwe
> henri claude moungui  hat am 23. März 2016 um 11:01
> geschrieben:
> 
> 
> Hi.Thank you Ant, Knut, Jason and Aaron for the tips. I'm sure the discussions
> we are having will make us continue to improve the DHIS2 platform,
> particularly for datawarehouse implementations.I was also looking for Kettle
> and Talend for this purpose. Finally, I found DHIS2 very comfortable for
> Export and Import as it is possible to do this step by step (you choose which
> metadata you want to export/import). Now I see the way is how to TRANSFORM the
> Excel databases to fit with the exported file. For now, I intend to do this
> manually...
> Thank you.
>  
>   
> 
> Le Mardi 22 mars 2016 7h58, Aaron Gladders  a écrit
> :
>  
> 
>  Hi - we did some work using Talend based on client desires.  We found it to
> be an incredible pain in the butt.  Although our group are typically senior
> software developers or technical architects we had to pull in vendor
> consultants to get training on how to use it and ultimately dumped it.  Beware
> the marketing - they all promote self-service but I suspect you'll either be
> bringing in their trainers, hiring their consultants or finding your own
> software developers to actually get the job done.
> Aaron
> 
> On Tue, Mar 22, 2016 at 12:04 AM, Knut Staring  wrote:
> 
> Good point, Ant.
> Here is a link to that conversation, with many interesting
> points:https://lists.launchpad.net/dhis2-users/msg09234.html
> 
> Knut
> On Tue, Mar 22, 2016 at 6:23 AM, Ant Snyman  wrote:
> 
> Hi Henri,I read on this forum that someone was attempting to use Kettle
> (Pentaho Data Integration). I don't know whether they succeeded.RegardsAnt
> Snyman
> On 21 March 2016 at 18:21, henri claude moungui  wrote:
> 
> Thank you Knut.
> Henri 
>   
> 
> Le Lundi 21 mars 2016 15h25, Knut Staring  a écrit :
>  
> 
>  Hi Henri,
> There is no specific 3rd party software that you have to use, people use many
> different tools. Perhaps most commonly, people use scripts in Python or R or
> similar to load data. You can import both metadata and data in CSV format, for
> example.
> http://dhis2.github.io/dhis2-docs/2.21/en/developer/html/ch01s10.html
> http://dhis2.github.io/dhis2-docs/2.21/en/user/html/ch21.html
> 
> Knut
> On Mon, Mar 21, 2016 at 3:15 PM, henri claude moungui 
> wrote:
> 
> Hi to all.I want to test the ETL process with DHIS2. Is there an automated way
> to do this? is there a recommended tiers soft to use for this? my operational
> DB to use are excel files.Thank you in advance.
> Henri Moungui 
>  
> ___
> 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 StaringDept. of Informatics, University of OsloNorway: +4791880522
> Skype: knutstarhttp://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
> 
> 
> 
> 
> 
> -- 
> 
> Ant SnymanCell: 0824910449Landline: 028 2713242
> Health Information Systems Program - SA
> This message and any attachments are subject to a disclaimer publishedat
> http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer

Re: [Dhis2-users] DHIS2 crashes during login

[Raminosoa Rabemanantsoa, Tantely]

Thank you Jason.

Regards,

On Wed, Mar 23, 2016 at 5:07 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> This issue has been mentioned many times on the list
>
>  Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
> exception is org.postgresql.util.PSQLException: ERROR: duplicate key
> value violates unique constraint "_dateperiodstructure_pkey"
>
> Basically, you have an invalid period. The fix is detailed here and in
> other messages.
>
>
> https://lists.launchpad.net/dhis2-users/msg08274.html
>
> Regards,
> Jason
>
>
>
> On Wed, Mar 23, 2016 at 3:02 PM, Raminosoa Rabemanantsoa, Tantely
>  wrote:
> > Dear All,
> >
> > As requested, please find here a link to the log file during the DHIS2
> > crash.
> >
> >
> https://drive.google.com/file/d/0BxDzZDbBr_thUjhEUW9URnUwQ1U/view?usp=sharing
> >
> > Thanks
> >
> > On Fri, Mar 18, 2016 at 2:58 PM, Morten Olav Hansen 
> > wrote:
> >>
> >> Hi Tantely
> >>
> >> As Jason say, we need a bit more information. Also I would recommend
> >> upgrading to Java 8 (as Java 7 is end-of-line, and not supported
> anymore),
> >> at the same time upgrading Tomcat to the latest would probably be a good
> >> idea.
> >>
> >> Including the server log at the time of crash is a good start (I would
> >> guess it's memory related if it's tomcat itself that crashes)
> >>
> >> On Fri, Mar 18, 2016 at 6:50 PM, Jason Pickering
> >>  wrote:
> >>>
> >>> Hi Tantely,
> >>>
> >>> Please have a look at our guidelines for reporting a problem.
> >>>
> >>> Please include the logs of the server when it crashes as this will help
> >>> to diagnose what the issue might be.
> >>>
> >>> Regards,
> >>> Jason
> >>>
> >>>
> >>> On Fri, Mar 18, 2016 at 12:43 PM, Raminosoa Rabemanantsoa, Tantely
> >>>  wrote:
> 
>  Hello everyone,
> 
> 
>  I am a new user of DHIS2. I am working with a DHIS2 application that
> has
>  already been installed last year inside an Amazon cloud web server.
> The
>  version that we have is DHIS2 2.19. The Tomcat version is 1.7. All
> the data
>  elements, organization unit and questionnaires have been integrated
> into the
>  system.
> 
> 
>  We are observing odd situation such as Tomcat is crashing each time a
>  couple of users (15+) are accessing DHIS2 simultaneously, especially
> when
>  they are using the DHIS2 Data Capture within tablets. DHIS2 is only
> back
>  after restarting Tomcat.
> 
> 
>  Do you know the Server and JVM memory specifications that are
>  recommended to expect about 300 concurrent DHIS2 users?
> 
> 
>  Here are some Java environment variables and server caracteristics
> that
>  we are using:
> 
> 
>  Java opts:   -Xms1024m -Xmx2048m -XX:PermSize=256m
>  -XX:MaxPermSize=512m
> 
>  Java version: 1.7.0_91
> 
>  OS name:Linux
> 
>  OS architecture:amd64
> 
>  OS version:4.1.10-17.31.amzn1.x86_64
> 
>  Server memory:Mem Total in JVM: 1243 Free in JVM: 547 Max Limit:
>  1820
> 
>  CPU cores:2
> 
>  Server RAM: 3.75 G
> 
> 
>  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-users
>  Post to : dhis2-users@lists.launchpad.net
>  Unsubscribe : https://launchpad.net/~dhis2-users
>  More help   : https://help.launchpad.net/ListHelp
> 
> >>>
> >>>
> >>>
> >>> --
> >>> Jason P. Pickering
> >>> email: jason.p.picker...@gmail.com
> >>> tel:+46764147049
> >>>
> >>> ___
> >>> 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
> >>>
> >>
> >>
> >>
> >> --
> >> Morten
> >
> >
> >
> >
> > --
> > Tantely Raminosoa
> > Data Officer
> > Management Sciences for Health
> > Madagascar-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.
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>



-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Madagascar-Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org

[Dhis2-users] Orgunits tree

[mugume david]

Hello team,

Has anyone faced the issue where orgunit trees are not well structured. I
just see the final nodes and not the full tree, which is annoying
especially when you have too many final nodes. (You can't know what belongs
to what).

Any way around this. Clearing cache isnt helping.

Thanks,

[image: Inline image 1]


*David Mugume*
+256 704 008815
___
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