Re: [Dhis2-users] It's possible to drilldown on DHIS2 visualizer?

2018-10-11 Thread Isaiah Nyabuto
Hi Nguyen,

Welcome to DHIS2. I am assuming you would like to drill down/up an orgUnit.
Go to the organizationUnit tab in the left side data dimension menu.
Click on the settings symbol and choose the appropriate selection mode; the
default one is select organisationUnits which allow you to select the
orgUnits you want to visualize manually.
You can also drill down/up orgUnits by orgUnit levels; change the selection
mode to levels and select the appropriate level from the drop-down menu
bar.

If you have some time, I recommend you enroll for the DHIS2 fundamentals
course at https://academy.dhis2.org/courses/HISP/DHIS2_Level1/2015_Q1/about
to better understand DHIS2.

Hope that helps
Isaiah Nyabuto.


On Tue, Oct 9, 2018 at 7:36 AM ha nguyen  wrote:

> I'm a beginner on DHIS2, I'm trying to create a chart (column chart, pie
> chart...) with drill down on org unit, period, or data dimension but I have
> not done. So, please help me if you have any idea for this.
>
> Thanks,
> Nguyen Ha.
> ___
> 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
>


-- 
Isaiah Nyabuto
email: isaiahnyab...@gmail.com
Tel: +254 729 572 616
___
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] Can't add items to a dashboard, dhis2 version 2.27

2018-09-24 Thread Isaiah Nyabuto
Hi everyone,

Am wondering why I am not able to add items on the dashboard. I can find
the visualizations I want to add, but I can't see the add button. I am also
on a very stable network.

Thoughts?
-- 
Isaiah Nyabuto
email: isaiahnyab...@gmail.com
Tel: +254 729 572 616
___
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] Extract a complete set of orgUnits (with all children and sub children) of a specific orgUnit

2018-06-25 Thread Isaiah Nyabuto
Thanks Lars!

On Mon, Jun 25, 2018 at 1:02 PM, Lars Helge Øverland  wrote:

> Hi Isaiah,
>
> for special operations for org units I would use the /organisationUnits
> endpoint directly. Docs here:
>
> https://docs.dhis2.org/master/en/developer/html/webapi_
> organisation_units.html
>
> regards,
>
> Lars
>
>
>
> On Mon, 25 Jun 2018 at 08:18, Isaiah Nyabuto 
> wrote:
>
>> Hi!
>>
>> I want to extract a complete set ( all children and sub children) of a
>> specific organisation units like this.
>>
>>
>> */api/25/metadata.json?assumeTRUE=TRUE=TRUE=name:eq:Tanzania=id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name]]]*
>>
>> is there a shorter way of doing that?
>>
>> Thanks
>> --
>> Isaiah Nyabuto
>> email: isaiahnyab...@gmail.com
>> Tel: +254 729 572 616
>>
>> ___
>> 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
>>
>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@dhis2.org
> https://www.dhis2.org
>
>


-- 
Isaiah Nyabuto
email: isaiahnyab...@gmail.com
Tel: +254 729 572 616
___
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] Extract a complete set of orgUnits (with all children and sub children) of a specific orgUnit

2018-06-25 Thread Isaiah Nyabuto
Hi!

I want to extract a complete set ( all children and sub children) of a
specific organisation units like this.

*/api/25/metadata.json?assumeTRUE=TRUE=TRUE=name:eq:Tanzania=id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name,children[id,name]]]*

is there a shorter way of doing that?

Thanks
-- 
Isaiah Nyabuto
email: isaiahnyab...@gmail.com
Tel: +254 729 572 616
___
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] Not able to assign organisation units to an event program (v2.29)

2018-06-19 Thread Isaiah Nyabuto
Thanks Prosper!

That was the problem.

Best.

On Mon, Jun 18, 2018 at 3:15 PM, Prosper BT  wrote:

> Dear Isaiah,
>
> Can you check on your user orgunit assignment,
>
> Its probably deselected
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation Adviser| HISP Uganda
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> On Mon, Jun 18, 2018 at 1:07 PM, Isaiah Nyabuto 
> wrote:
>
>> Hi Community,
>>
>> I am creating an event program in dhis2 2.29.
>>
>> There is no option to select and assign the organisation units. Its only
>> says *determining your root organisation units*.
>>
>>  I realise that no organisation unit was successfully fetched.
>>
>>
>> Any helps on this will be appreciated.
>>
>> Thanks!
>>
>> --
>> Isaiah Nyabuto
>> email: isaiahnyab...@gmail.com
>> Tel: +254 729 572 616
>>
>>
>> ___
>> 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
>>
>>
>


-- 
Isaiah Nyabuto
email: isaiahnyab...@gmail.com
Tel: +254 729 572 616
___
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] Not able to assign organisation units to an event program (v2.29)

2018-06-18 Thread Isaiah Nyabuto
Hi Community,

I am creating an event program in dhis2 2.29.

There is no option to select and assign the organisation units. Its only
says *determining your root organisation units*.

 I realise that no organisation unit was successfully fetched.


Any helps on this will be appreciated.

Thanks!

-- 
Isaiah Nyabuto
email: isaiahnyab...@gmail.com
Tel: +254 729 572 616
___
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] HTTP 409: Dimension pe is present in query without any valid dimension options

2018-05-17 Thread Isaiah Nyabuto
Hi DHIS2 community,

How do I fix a chart that has stopped to display data?

Initially my chart was displaying data with relative period set for this
month.

I noticed the period was missing from the the URL (Analytical API) and
therefore when I added the correct period in the URL I got some data in
JSON. This looks like a bag:-)

I am using 2.25.

Looking forward to your insights!
-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] User statistics: Where do I find the number of dashboards shared by a user?

2018-05-01 Thread Isaiah Nyabuto
Thanks Randy!

Please let me see what you have.

Thanks,
Isaiah

On Tue, May 1, 2018 at 5:01 PM, Randy Wilson <rwil...@msh.org> wrote:

> Hi Isiah,
> I've written a SQL query to count how many users from which levels of the
> orgunit hierarchy have created dashboards. I can send you that as a start.
> Randy Wilson
>
> On Mon, 30 Apr 2018, 10:04 Isaiah Nyabuto, <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi DHIS2 Community,
>>
>> I am eagerly looking for data or metadata about the number of dashboards
>> shared by users.
>>
>> What I am only able to see or find from the dashboards are only the user
>> groups where the dashboards were shared.
>>
>> Please, is it possible to find out who exactly shared the dashboards?
>>
>> Any helps will be very much appreciated!
>>
>> Thanks
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>> ___
>> 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
>>
>
> *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.*




-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] User statistics: Where do I find the number of dashboards shared by a user?

2018-04-30 Thread Isaiah Nyabuto
Hi DHIS2 Community,

I am eagerly looking for data or metadata about the number of dashboards
shared by users.

What I am only able to see or find from the dashboards are only the user
groups where the dashboards were shared.

Please, is it possible to find out who exactly shared the dashboards?

Any helps will be very much appreciated!

Thanks
-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Can't delete some data elements

2018-04-25 Thread Isaiah Nyabuto
Hi Aljosa,

You cannot directly delete data elements that are already assigned to other
objects due to some dependencies.

Please try to unassigned the data elements from the dataset and ensure that
there there is no other dependencies before deleting. - This should work.

All the best!
==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Apr 25, 2018 12:59, "Aljosa Celebic" <aljosa.cele...@lih.lu> wrote:

> Hi,
>
> I am actually testing DHIS2 live, so I’ve builded a data set including
> several data elements. I also tested Data Entry.
>
> But when I want to delete some data elements I have this message : “Could
> not delete due to association with another object: DataValue”.
>
> What should I do be able to delete all data elements, and to start from
> the beginning with the real project?
>
> I am sorry if this question was asked before, but I can’t find how to
> reach all forum conversations.
>
> Thank you.
>
> Kind regards.
>
> Aljosa
>
> Aljosa Celebic
> Data Manager, Competence Center for Methodology and Statistics
>
> *Luxembourg Institute of Health*
> Department of Population Health
> 1A-B, rue Thomas Edison, L-1445 Strassen
> Luxembourg
> Tel: +352 26970-399
> Fax: +352 26970-719
> Email: aljosa.cele...@lih.lu
> Website: https://www.lih.lu/
>
>
>
>
> Join us on Facebook and follow our activities on Twitter:
> https://www.facebook.com/Luxembourg.Institute.of.Health
> http://twitter.com/LIH_Luxembourg
> aljosa.cele...@lih.lu
>
> This message (including any attachments) is intended for the addressee
> only and may contain confidential and/or privileged information and/or
> information protected by intellectual property rights. If you have received
> this message  by mistake, please notify the sender by return e-mail and
> delete this message from your system. You should not use, alter, copy or
> distribute this message or disclose its contents to anyone. E-mail
> transmission can not be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
> or incomplete, or contain viruses. Luxembourg Institute of Health shall not
> be responsible nor liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt or damage to your system.
>
> ___
> 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] How do I deal with 502 Bad gateway?

2018-04-19 Thread Isaiah Nyabuto
Thanks, I'll check it out.

==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Apr 19, 2018 12:58, "tuzo engelbert" <tuzoengelb...@gmail.com> wrote:

> Dear Isaiah,
>
> You can use uptime roobot to monitor your up and down of the system and
> here is the link https://uptimerobot.com/index.php#mainDashboard
>
>
> Thanks
>
> On Thu, Apr 19, 2018 at 12:49 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Thanks all,
>>
>> Unfortunately, I do not have access to the server and I can do nothing
>> about it.
>>
>> If I may ask, could there be something that monitors the tomcat instance
>> and can regularly restarts it if need be?
>>
>> That might be very useful.
>>
>> Thanks
>>
>> On Thu, Apr 19, 2018 at 12:29 PM, Ocaya Stephen <stepho...@gmail.com>
>> wrote:
>>
>>> Hi, Most likely, the server is not running.  Please ensure that the
>>> server is running and accessible via the set port
>>>
>>> regards
>>>
>>> On Thu, Apr 19, 2018 at 12:24 PM, Isaiah Nyabuto <
>>> isaiahnyab...@gmail.com> wrote:
>>>
>>>> Dear DHIS2 users,
>>>>
>>>> I am working on a super fast internet access *13 Mbps* but I get the
>>>> bad gateway.
>>>> I have cleared my browser cache several times still nothing changes!
>>>>
>>>> Please how do I go about this when everything fails?
>>>>
>>>> Any helps and workarounds will be appreciated.
>>>>
>>>> Thanks
>>>> --
>>>> 
>>>> 
>>>> Isaiah Nyabuto
>>>> +254 729 572 616
>>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>>
>>>> ___
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>> --
>>> *Stephen Ocaya*
>>> Tel: +256 393 217 892 | Mob: +256774558980
>>> www.stephocay.com
>>> SkypeID: stephocay
>>>
>>
>>
>>
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>> ___
>> 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] How do I deal with 502 Bad gateway?

2018-04-19 Thread Isaiah Nyabuto
Thanks all,

Unfortunately, I do not have access to the server and I can do nothing
about it.

If I may ask, could there be something that monitors the tomcat instance
and can regularly restarts it if need be?

That might be very useful.

Thanks

On Thu, Apr 19, 2018 at 12:29 PM, Ocaya Stephen <stepho...@gmail.com> wrote:

> Hi, Most likely, the server is not running.  Please ensure that the server
> is running and accessible via the set port
>
> regards
>
> On Thu, Apr 19, 2018 at 12:24 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Dear DHIS2 users,
>>
>> I am working on a super fast internet access *13 Mbps* but I get the bad
>> gateway.
>> I have cleared my browser cache several times still nothing changes!
>>
>> Please how do I go about this when everything fails?
>>
>> Any helps and workarounds will be appreciated.
>>
>> Thanks
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>> ___
>> 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
>>
>>
>
>
> --
> --
> *Stephen Ocaya*
> Tel: +256 393 217 892 | Mob: +256774558980
> www.stephocay.com
> SkypeID: stephocay
>



-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] How do I deal with 502 Bad gateway?

2018-04-19 Thread Isaiah Nyabuto
Dear DHIS2 users,

I am working on a super fast internet access *13 Mbps* but I get the bad
gateway.
I have cleared my browser cache several times still nothing changes!

Please how do I go about this when everything fails?

Any helps and workarounds will be appreciated.

Thanks
-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Has metadata import stopped working?

2018-04-06 Thread Isaiah Nyabuto
Hi!

I was encountering the same error when trying to import metadata with
collection of other objects (parent and child relations) from the web APIs
in version 2.27.
*ERROR:

org.hibernate.TransientObjectException: object references an unsaved
> transient instance - save the transient instance before flushing:
>
I learnt that this happens when hibernate tries to create an object that
references to another object which do not exist in the database. So I tried
posting the metadata objects separately and it worked!

Best regards
==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Apr 6, 2018 16:57, "Olav Poppe" <ola...@ifi.uio.no> wrote:

I’m having the same issue and error importing into an empty 2.27 database.
Though in this case a slightly modified dependency export of a tracker
programme, not orgunits.

Knut, did you find a solution?

Sending you the payload, Morten.

Olav


12. jan. 2018 kl. 08:39 skrev Morten Olav Hansen <mor...@dhis2.org>:

That sounds weird Knut, would you mind sharing the org unit payload?

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Fri, Jan 12, 2018 at 2:19 AM, Knut Staring <knu...@gmail.com> wrote:

> I have tried doing metadata export without sharing from 2.27 and importing
> into 2.27, just the OU hierarchy and levels.
>
> Importing into a clean instance gives this:
>
>  INFO  2018-01-11 20:16:06,750 [Level: INFO, category: METADATA_IMPORT,
> time: Thu Jan 11 20:16:06 CET 2018, message: (admin) Creating 8 object(s)
> of type OrganisationUnitLevel] (InMemoryNotifier.java [taskScheduler-4])
> * ERROR 2018-01-11 20:16:07,764 Unexpected error occurred in scheduled
> task. (TaskUtils.java [taskScheduler-4])
> org.hibernate.TransientObjectException: object references an unsaved
> transient instance - save the transient instance before flushing:
> org.hisp.dhis.organisationunit.OrganisationUnit
> at org.hibernate.engine.internal.ForeignKeys.getEntityIdentifie
> rIfNotUnsaved(ForeignKeys.java:279)
> at org.hibernate.type.EntityType.getIdentifier(EntityType.java:
> 462)
> at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:
> 281)
> at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:
> 291)
> at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:322)
> at org.hibernate.persister.entity.AbstractEntityPersister.findD
> irty(AbstractEntityPersister.java:4204)
> at org.hibernate.event.internal.DefaultFlushEntityEventListener
> .dirtyCheck(DefaultFlushEntityEventListener.java:528)
> at org.hibernate.event.internal.DefaultFlushEntityEventListener
> .isUpdateNecessary(DefaultFlushEntityEventListener.java:215)
> at org.hibernate.event.internal.DefaultFlushEntityEventListener
> .onFlushEntity(DefaultFlushEntityEventListener.java:142)
> at org.hibernate.event.internal.AbstractFlushingEventListener.f
> lushEntities(AbstractFlushingEventListener.java:216)
> at org.hibernate.event.internal.AbstractFlushingEventListener.f
> lushEverythingToExecutions(AbstractFlushingEventListener.java:85)
> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu
> sh(DefaultFlushEventListener.java:38)
> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
> at org.hisp.dhis.dbms.HibernateDbmsManager.clearSession(Hiberna
> teDbmsManager.java:339)
> at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle
> Service.commit(DefaultObjectBundleService.java:180)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
> gReflection(AopUtils.java:333)
> at org.springframework.aop.framework.ReflectiveMethodInvocation
> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
> at org.springframework.aop.framework.ReflectiveMethodInvocation
> .proceed(ReflectiveMethodInvocation.java:157)
> at org.springframework.transaction.interceptor.TransactionInter
> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
> at org.springframework.transaction.interceptor.TransactionAspec
> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
> at org.springframework.transaction.interceptor.TransactionInter
> ceptor.invoke(TransactionInterceptor.java:96)
> at org.springframework.aop.framework.ReflectiveMethodInvocation
> .proceed(ReflectiveMethodInvocation.java:179)
> at org.springf

Re: [Dhis2-users] Import/Export data between similar but distinct systems

2018-04-05 Thread Isaiah Nyabuto
Hi Martin,

Yes, basically the Idea would be to extract metadata/data from one instance
(source), do some transformations and load into the other instance
(destination). You can extract and load the metadata/data directly using
the dhis2 import/export App or work extensively using dhis2 APIs. There are
various ETL tools that can be used in the process,  I prefer using R.
The following guide can walk you through the whole process.
http://rstudio-pubs-static.s3.amazonaws.com/139589_a81125b491094fe3b5e79e3bcea0a56b.html


@Edward, I would like to see what you guys are working on J


Thank you





On Wed, Apr 4, 2018 at 4:28 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> We’re currently working on something for this – a desktop app that runs on
> Windows / Mac / Linux that allows you to specify some parameters to ‘map’
> from one side to the other and a shell app that runs on a Linux box and
> reads the config file created by the desktop app once a day to transfer
> data from the one to the other using the API.  We specifically need to
> transfer aggregate program indicator values from one side to data elements
> on the other.
>
> Things to think about:
>
>- You need to map Organisational units on both sides
>- You need to specify the from element + category option combo /
>indicator and the to element + category option combo on the other side
>- You need to specify the period type and optionally a start / end
>date so that the system knows what periods to target.
>
> The system is still in development but will effectively enable incremental
> updates by recording periods already taken care of for each source /
> destination / ou.
>
> I’ll keep you posted, at this stage we’re not 100% sure when it will be
> complete, but it should be in the next few weeks.
>
> Ed
>
>
>
> *From:* Dhis2-users <dhis2-users-bounces+erobinson=projectbalance.com@
> lists.launchpad.net> *On Behalf Of *Martin Van Aken
> *Sent:* Tuesday, 09 January 2018 8:56 PM
> *To:* dhis2-users <dhis2-users@lists.launchpad.net>
> *Subject:* [Dhis2-users] Import/Export data between similar but distinct
> systems
>
>
>
> Hello DHIS2 community,
>
> We need to make frequent import/export between two different DHIS2
> systems. While they are similar and the format "fits", we know some
> differences, mainly:
>
>
>
> - The org units concerned exist on both sides but with different ids
>
> - Same for the data elements
>
> - In some situation, the export value may be an indicator, to be imported
> in a data element
>
>
>
> I can imagine making the export in CSV, then having a "matching sheet" in
> XLS with the link between OU in the source system and OU in the destination
> system.
>
>
>
> Is someone doing those kind of operations? What's your typical flow/way of
> working?
>
> I think I remember Lars presenting some feature helping with this on one
> of the last DHIS2 releases, but I'm not sure.
>
>
>
> Martin
>
> --
>
> *Martin Van Aken - Freelance Enthusiast Developer*
>
>
>
> Mobile : +32 486 899 652
>
>
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/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
>
>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Score card

2018-03-26 Thread Isaiah Nyabuto
My pleasure.

==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Mar 26, 2018 16:45, "Barnabas Akumba" <akumbaba...@gmail.com> wrote:

Hello Isaiah,

Thanks for the prompt response.

Regards

On Mon, Mar 26, 2018 at 2:26 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
wrote:

> Hi Barnabas,
>
> Dhis2 apps are usually stored at dhis2 appstore that can be accessed at
> https://play.dhis2.org/appstore/
>
> You can download the scorecard 2.4 at https://play.dhis2.org/apps
> tore/app/ZCIvXjEmrya
>
> All the best!
>
>
>
> On Mon, Mar 26, 2018 at 3:37 PM, Barnabas Akumba <akumbaba...@gmail.com>
> wrote:
>
>> Hello All,
>>
>> Where can I get the Scorecard 2.4-beta-1.4 from.
>> I just realised it isn't a default app that comes with a DHIS2 Setup.
>>
>> Your usual quick response will be highly appreciated.
>>
>> Regards
>>
>> --
>>
>> Barnabas AKUMBA
>>
>> *Mobile:* +2348036195778 <0803%20619%205778>
>> *Skype:* barnabas.akumba
>>
>> ___
>> 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
>>
>>
>
>
> --
> 
> 
> Isaiah Nyabuto
> +254 729 572 616
> Bsc. Health Records Management & Informatics, JKUAT.
>



-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
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] Score card

2018-03-26 Thread Isaiah Nyabuto
Hi Barnabas,

Dhis2 apps are usually stored at dhis2 appstore that can be accessed at
https://play.dhis2.org/appstore/

You can download the scorecard 2.4 at
https://play.dhis2.org/appstore/app/ZCIvXjEmrya

All the best!



On Mon, Mar 26, 2018 at 3:37 PM, Barnabas Akumba <akumbaba...@gmail.com>
wrote:

> Hello All,
>
> Where can I get the Scorecard 2.4-beta-1.4 from.
> I just realised it isn't a default app that comes with a DHIS2 Setup.
>
> Your usual quick response will be highly appreciated.
>
> Regards
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
>
> ___
> 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
>
>


-- 
--------
Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Indicator: Numerator and Denominator objects not found.

2018-03-16 Thread Isaiah Nyabuto
Hi Lars,

Agreed. I imported data elements metadata but yet still, some are not
mapped in the indicators.
I resorted to manually pointing the indicator related data elements to the
correct source. This could be a very tedious process if I had so many
indicators. I believe there could a better way of doing it.

Thank you


==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Mar 16, 2018 18:27, "Lars Helge Øverland" <l...@dhis2.org> wrote:

Hi Isaiah,

very likely you have exported and then imported indicators without
including the data elements part of your indicator expressions.

Currently we have a set of options under "metadata export with
dependencies" (see Import-export app), but we don't support indicators with
related metadata yet. It would be good to support that.

I the mean time you need to import your data elements manually as well.

regards,

Lars



On 16 March 2018 at 12:27, Isaiah Nyabuto <isaiahnyab...@gmail.com> wrote:

> Hi David:
>
> Thank you. I can see that. Firstly I discovered that the numerators and
> denominators data elements uids are not existing in my database. Is there a
> way I can filter metadata by the date it was last updated?
>
> Thank you
>
> On Fri, Mar 16, 2018 at 12:23 PM, David Muturi <dnmut...@gmail.com> wrote:
>
>> Hi Isaiah,
>> The uid showing on the screen should be that of the data element (please
>> check that it is correct). Also it should be enclosed in the chars as shown
>> #{uid}.
>> rgds
>> David
>>
>>
>> On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto, <isaiahnyab...@gmail.com>
>> wrote:
>>
>>> Dear Dhis2 users,
>>>
>>> I recently imported a few indicators using an API.  When I check the
>>> indicator numerator from the maintenance, it shows the data element
>>> description and ID but no valid object found. I suspect this could be a
>>> problem with my metadata version. If so, how do I ensure I get the right
>>> version of data elements metadata?
>>>
>>> Thank you.
>>>
>>>
>>> ==
>>> Isaiah Nyabuto
>>> +254729572616 <+254%20729%20572616>
>>> Bsc. Health Records Management and Informatics
>>> ___
>>> 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
>>>
>>
>
>
> --
> 
> 
> Isaiah Nyabuto
> +254 729 572 616
> Bsc. Health Records Management & Informatics, JKUAT.
>
> ___
> 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
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://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


Re: [Dhis2-users] Indicator: Numerator and Denominator objects not found.

2018-03-16 Thread Isaiah Nyabuto
Hi David:

Thank you. I can see that. Firstly I discovered that the numerators and
denominators data elements uids are not existing in my database. Is there a
way I can filter metadata by the date it was last updated?

Thank you

On Fri, Mar 16, 2018 at 12:23 PM, David Muturi <dnmut...@gmail.com> wrote:

> Hi Isaiah,
> The uid showing on the screen should be that of the data element (please
> check that it is correct). Also it should be enclosed in the chars as shown
> #{uid}.
> rgds
> David
>
>
> On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto, <isaiahnyab...@gmail.com>
> wrote:
>
>> Dear Dhis2 users,
>>
>> I recently imported a few indicators using an API.  When I check the
>> indicator numerator from the maintenance, it shows the data element
>> description and ID but no valid object found. I suspect this could be a
>> problem with my metadata version. If so, how do I ensure I get the right
>> version of data elements metadata?
>>
>> Thank you.
>>
>>
>> ==
>> Isaiah Nyabuto
>> +254729572616
>> Bsc. Health Records Management and Informatics
>> ___
>> 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
>>
>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Setting up GIS

2018-02-20 Thread Isaiah Nyabuto
Hi Knut,

Yes it worked. Thank you.

On Tue, Feb 20, 2018 at 3:25 PM, Knut Staring <knu...@gmail.com> wrote:

> Try opening the orgunit lwvwls and click on Save.
>
> On Feb 20, 2018 12:34 AM, "Isaiah Nyabuto" <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi Knut,
>>
>> I can see the boundaries, however I cannot select organisation units
>> below certain level say level 2.
>>
>> On Tue, Feb 20, 2018 at 6:40 AM, Knut Staring <knu...@gmail.com> wrote:
>>
>>> Probably not. Do you see the boundary layer in the GIS module?
>>>
>>> On Feb 19, 2018 12:01 PM, "Isaiah Nyabuto" <isaiahnyab...@gmail.com>
>>> wrote:
>>>
>>>> Dear Dhis2 Community,
>>>>
>>>> I imported organisationUnits as (geojson file) with coordinates. Am not
>>>> sure whether I'll need to create gml files inorder to get my gis working.
>>>> I understand that the process documented here
>>>> <https://docs.dhis2.org/2.22/en/user/html/ch18.html> requires a
>>>> different set up?
>>>>
>>>> Please advise.
>>>>
>>>> Thank you.
>>>>
>>>>
>>>> --
>>>> 
>>>> 
>>>> Isaiah Nyabuto
>>>> +254 729 572 616
>>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>>
>>>> ___
>>>> 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
>>>>
>>>>
>>
>>
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Setting up GIS

2018-02-19 Thread Isaiah Nyabuto
Hi Knut,

I can see the boundaries, however I cannot select organisation units below
certain level say level 2.

On Tue, Feb 20, 2018 at 6:40 AM, Knut Staring <knu...@gmail.com> wrote:

> Probably not. Do you see the boundary layer in the GIS module?
>
> On Feb 19, 2018 12:01 PM, "Isaiah Nyabuto" <isaiahnyab...@gmail.com>
> wrote:
>
>> Dear Dhis2 Community,
>>
>> I imported organisationUnits as (geojson file) with coordinates. Am not
>> sure whether I'll need to create gml files inorder to get my gis working.
>> I understand that the process documented here
>> <https://docs.dhis2.org/2.22/en/user/html/ch18.html> requires a
>> different set up?
>>
>> Please advise.
>>
>> Thank you.
>>
>>
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>> ___
>> 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
>>
>>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Setting up GIS

2018-02-19 Thread Isaiah Nyabuto
Dear Dhis2 Community,

I imported organisationUnits as (geojson file) with coordinates. Am not
sure whether I'll need to create gml files inorder to get my gis working.
I understand that the process documented here
<https://docs.dhis2.org/2.22/en/user/html/ch18.html> requires a different
set up?

Please advise.

Thank you.


-- 
----
Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Posting Metadata in dhis2.

2018-02-19 Thread Isaiah Nyabuto
Hi Jason,

Thank you. I wasn't able to post my organisation Units metadata because of
the following error.

"{\"httpStatus\":\"Internal Server
Error\",\"httpStatusCode\":500,\"status\":\"ERROR\",\"message\":\"object
references an unsaved transient instance - save the transient instance
before flushing: org.hisp.dhis.organisationunit.OrganisationUnit\"}"

I wish I knew how to solve that through the API. However, I imported the
organisation units using the csv file import. I followed along your guide
and I was able to post all other metadata and data values - Thank you.




On Thu, Feb 15, 2018 at 3:33 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
wrote:

> Hi Jason,
>
> Thank you. I am going to look into that keenly.
> And If I may ask, is there a way I can extract dhis2 metadata that can be
> imported directly or with minimal transformations?
>
> This will be helpful. Thank you.
>
> ==
> Isaiah Nyabuto
> +254729572616
> Bsc. Health Records Management and Informatics
>
> On Feb 15, 2018 15:16, "Jason Pickering" <jason.p.picker...@gmail.com>
> wrote:
>
>> Hi Isaiah,
>>
>> You have
>>
>>
>> "parent":"vpiZlB5cdK7"
>>
>>
>> It should be
>>
>> parent":{"id":"vpiZlB5cdK7"}}
>>
>> Be sure your JSON structure is exactly as it should be, otherwise, you
>> will get those kinds of errors. Study the example here
>> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
>> .
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Thu, Feb 15, 2018 at 1:07 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
>> wrote:
>>
>>> Thank you for the tip. It still doesn't work.
>>> what does this error mean?
>>>
>>> httr::content(r, "text")
>>>
>>> [1] "{\"httpStatus\":\"Internal Server Error\",\"httpStatusCode\":500
>>> ,\"status\":\"ERROR\",\"message\":\"Can not instantiate value of type
>>> [simple type, class org.hisp.dhis.organisationunit.OrganisationUnit]
>>> from String value ('It7fWcKbcZX'); no single-String constructor/factory
>>> method\\n at [Source: org.apache.catalina.connector.
>>> CoyoteInputStream@1efec811; line: 1, column: 73] (through reference
>>> chain: org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\
>>> "])\"}"
>>>
>>> Anyone?
>>>
>>> Thank you.
>>> ==
>>> Isaiah Nyabuto
>>> +254729572616 <+254%20729%20572616>
>>> Bsc. Health Records Management and Informatics
>>>
>>> On Feb 15, 2018 13:14, "Jason Pickering" <jason.p.picker...@gmail.com>
>>> wrote:
>>>
>>> All of your fields must have exactly the correct names:
>>>
>>> shortname -> shortName
>>> featuretype-> featureType
>>>
>>> Keep hacking at it! You will get there!
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Thu, Feb 15, 2018 at 11:08 AM, Isaiah Nyabuto <
>>> isaiahnyab...@gmail.com> wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> Here is some bit of my post data.
>>>>
>>>> {"organisationUnits":[{"name":"Wikithuki 
>>>> Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
>>>>  
>>>> Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
>>>>  Medical 
>>>> Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
>>>>  Medical 
>>>> Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","

Re: [Dhis2-users] link to App store

2018-02-19 Thread Isaiah Nyabuto
Thank you.

I was using this link; https://www.dhis2.org/appstore that I got from
https://www.dhis2.org/how-to-create-find-install-apps

Thank you

On Mon, Feb 19, 2018 at 2:59 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Isaish,
>
> where do you get that error? The app store is found here:
>
> https://play.dhis2.org/appstore/
>
> regards,
>
> Lars
>
>
> On 19 February 2018 at 12:25, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Dear Dhis2 community,
>>
>> Where can I find the link to the app store? I get page not found.
>>
>> Thank you.
>>
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>> ___
>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] link to App store

2018-02-19 Thread Isaiah Nyabuto
Dear Dhis2 community,

Where can I find the link to the app store? I get page not found.

Thank you.

-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Posting Metadata in dhis2.

2018-02-15 Thread Isaiah Nyabuto
This is super, I will try and work around that.

Thank you.

==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Feb 15, 2018 17:10, "Knut Staring" <knu...@gmail.com> wrote:

> Everything done from the user interface is done through the API, so yes.
> The API also gives you more flexibility to filter etc. The manual describes
> this.
>
> https://docs.dhis2.org/master/en/developer/html/webapi_metadata_crud.html
> https://docs.dhis2.org/master/en/developer/html/webapi_
> metadata_export.html
> https://docs.dhis2.org/master/en/developer/html/webapi_
> metadata_synchronization.html
>
>
> On Thu, Feb 15, 2018 at 8:56 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>>
>> Hi Knut,
>>
>> Yes. And is it possible to do that APIs?
>>
>> Thank you.
>>
>>
>> ==
>> Isaiah Nyabuto
>> +254729572616 <+254%20729%20572616>
>> Bsc. Health Records Management and Informatics
>>
>> On Feb 15, 2018 16:29, "Knut Staring" <knu...@gmail.com> wrote:
>>
>>> Hi Isaiah,
>>>
>>> When you say "extract", you mean you want to take metadata from one
>>> instance of DHIS2 and import to another one? That can be done through the
>>> user interface as described in the user manual:
>>> https://docs.dhis2.org/master/en/user/html/import_export.html
>>> https://play.dhis2.org/2.28/dhis-web-importexport/index.action
>>>
>>> You can also load metadata from CSV:
>>> https://docs.dhis2.org/master/en/developer/html/webapi_csv_m
>>> etadata_import.html
>>>
>>> On Thu, Feb 15, 2018 at 7:33 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com
>>> > wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> Thank you. I am going to look into that keenly.
>>>> And If I may ask, is there a way I can extract dhis2 metadata that can
>>>> be imported directly or with minimal transformations?
>>>>
>>>> This will be helpful. Thank you.
>>>>
>>>> ==
>>>> Isaiah Nyabuto
>>>> +254729572616 <+254%20729%20572616>
>>>> Bsc. Health Records Management and Informatics
>>>>
>>>> On Feb 15, 2018 15:16, "Jason Pickering" <jason.p.picker...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi Isaiah,
>>>>>
>>>>> You have
>>>>>
>>>>>
>>>>> "parent":"vpiZlB5cdK7"
>>>>>
>>>>>
>>>>> It should be
>>>>>
>>>>> parent":{"id":"vpiZlB5cdK7"}}
>>>>>
>>>>> Be sure your JSON structure is exactly as it should be, otherwise, you
>>>>> will get those kinds of errors. Study the example here
>>>>> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
>>>>> .
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Feb 15, 2018 at 1:07 PM, Isaiah Nyabuto <
>>>>> isaiahnyab...@gmail.com> wrote:
>>>>>
>>>>>> Thank you for the tip. It still doesn't work.
>>>>>> what does this error mean?
>>>>>>
>>>>>> httr::content(r, "text")
>>>>>>
>>>>>> [1] "{\"httpStatus\":\"Internal Server Error\",\"httpStatusCode\":500
>>>>>> ,\"status\":\"ERROR\",\"message\":\"Can not instantiate value of
>>>>>> type [simple type, class org.hisp.dhis.organisationunit.OrganisationUnit]
>>>>>> from String value ('It7fWcKbcZX'); no single-String constructor/factory
>>>>>> method\\n at [Source: org.apache.catalina.connector.
>>>>>> CoyoteInputStream@1efec811; line: 1, column: 73] (through reference
>>>>>> chain: org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\
>>>>>> "])\"}"
>>>>>>
>>>>>> Anyone?
>>>>>>
>>>>>> Thank you.
>>>>>> ==
>>>>>> Isaiah Nyabuto
>>>>>> +254729572616 <+254%20729%20572616>
>>>>>> Bsc. Health Records Management and Informatics

Re: [Dhis2-users] Posting Metadata in dhis2.

2018-02-15 Thread Isaiah Nyabuto
Hi Knut,

Yes. And is it possible to do that APIs?

Thank you.


==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Feb 15, 2018 16:29, "Knut Staring" <knu...@gmail.com> wrote:

> Hi Isaiah,
>
> When you say "extract", you mean you want to take metadata from one
> instance of DHIS2 and import to another one? That can be done through the
> user interface as described in the user manual:
> https://docs.dhis2.org/master/en/user/html/import_export.html
> https://play.dhis2.org/2.28/dhis-web-importexport/index.action
>
> You can also load metadata from CSV:
> https://docs.dhis2.org/master/en/developer/html/webapi_csv_
> metadata_import.html
>
> On Thu, Feb 15, 2018 at 7:33 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi Jason,
>>
>> Thank you. I am going to look into that keenly.
>> And If I may ask, is there a way I can extract dhis2 metadata that can be
>> imported directly or with minimal transformations?
>>
>> This will be helpful. Thank you.
>>
>> ==
>> Isaiah Nyabuto
>> +254729572616 <+254%20729%20572616>
>> Bsc. Health Records Management and Informatics
>>
>> On Feb 15, 2018 15:16, "Jason Pickering" <jason.p.picker...@gmail.com>
>> wrote:
>>
>>> Hi Isaiah,
>>>
>>> You have
>>>
>>>
>>> "parent":"vpiZlB5cdK7"
>>>
>>>
>>> It should be
>>>
>>> parent":{"id":"vpiZlB5cdK7"}}
>>>
>>> Be sure your JSON structure is exactly as it should be, otherwise, you
>>> will get those kinds of errors. Study the example here
>>> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
>>> .
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> On Thu, Feb 15, 2018 at 1:07 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com
>>> > wrote:
>>>
>>>> Thank you for the tip. It still doesn't work.
>>>> what does this error mean?
>>>>
>>>> httr::content(r, "text")
>>>>
>>>> [1] "{\"httpStatus\":\"Internal Server Error\",\"httpStatusCode\":500
>>>> ,\"status\":\"ERROR\",\"message\":\"Can not instantiate value of type
>>>> [simple type, class org.hisp.dhis.organisationunit.OrganisationUnit]
>>>> from String value ('It7fWcKbcZX'); no single-String constructor/factory
>>>> method\\n at [Source: org.apache.catalina.connector.
>>>> CoyoteInputStream@1efec811; line: 1, column: 73] (through reference
>>>> chain: org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\
>>>> "])\"}"
>>>>
>>>> Anyone?
>>>>
>>>> Thank you.
>>>> ==
>>>> Isaiah Nyabuto
>>>> +254729572616 <+254%20729%20572616>
>>>> Bsc. Health Records Management and Informatics
>>>>
>>>> On Feb 15, 2018 13:14, "Jason Pickering" <jason.p.picker...@gmail.com>
>>>> wrote:
>>>>
>>>> All of your fields must have exactly the correct names:
>>>>
>>>> shortname -> shortName
>>>> featuretype-> featureType
>>>>
>>>> Keep hacking at it! You will get there!
>>>>
>>>> Regards,
>>>> Jason
>>>>
>>>>
>>>> On Thu, Feb 15, 2018 at 11:08 AM, Isaiah Nyabuto <
>>>> isaiahnyab...@gmail.com> wrote:
>>>>
>>>>> Hi Jason,
>>>>>
>>>>> Here is some bit of my post data.
>>>>>
>>>>> {"organisationUnits":[{"name":"Wikithuki 
>>>>> Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
>>>>>  
>>>>> Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
>>>>>  Medical 
>>>>> Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname"

Re: [Dhis2-users] Posting Metadata in dhis2.

2018-02-15 Thread Isaiah Nyabuto
Hi Jason,

Thank you. I am going to look into that keenly.
And If I may ask, is there a way I can extract dhis2 metadata that can be
imported directly or with minimal transformations?

This will be helpful. Thank you.

==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Feb 15, 2018 15:16, "Jason Pickering" <jason.p.picker...@gmail.com>
wrote:

> Hi Isaiah,
>
> You have
>
>
> "parent":"vpiZlB5cdK7"
>
>
> It should be
>
> parent":{"id":"vpiZlB5cdK7"}}
>
> Be sure your JSON structure is exactly as it should be, otherwise, you
> will get those kinds of errors. Study the example here
> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
> .
>
> Regards,
> Jason
>
>
>
> On Thu, Feb 15, 2018 at 1:07 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Thank you for the tip. It still doesn't work.
>> what does this error mean?
>>
>> httr::content(r, "text")
>>
>> [1] "{\"httpStatus\":\"Internal Server Error\",\"httpStatusCode\":500
>> ,\"status\":\"ERROR\",\"message\":\"Can not instantiate value of type
>> [simple type, class org.hisp.dhis.organisationunit.OrganisationUnit]
>> from String value ('It7fWcKbcZX'); no single-String constructor/factory
>> method\\n at [Source: org.apache.catalina.connector.
>> CoyoteInputStream@1efec811; line: 1, column: 73] (through reference
>> chain: org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\
>> "])\"}"
>>
>> Anyone?
>>
>> Thank you.
>> ==
>> Isaiah Nyabuto
>> +254729572616 <+254%20729%20572616>
>> Bsc. Health Records Management and Informatics
>>
>> On Feb 15, 2018 13:14, "Jason Pickering" <jason.p.picker...@gmail.com>
>> wrote:
>>
>> All of your fields must have exactly the correct names:
>>
>> shortname -> shortName
>> featuretype-> featureType
>>
>> Keep hacking at it! You will get there!
>>
>> Regards,
>> Jason
>>
>>
>> On Thu, Feb 15, 2018 at 11:08 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com
>> > wrote:
>>
>>> Hi Jason,
>>>
>>> Here is some bit of my post data.
>>>
>>> {"organisationUnits":[{"name":"Wikithuki 
>>> Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
>>>  
>>> Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
>>>  Medical 
>>> Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
>>>  Medical 
>>> Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
>>>  Community Health 
>>> Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
>>>  CHU","description":"Community 
>>> Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
>>>  Health Centre","uid":"cmay4WXRmhA","code":"12034","parent":
>>>
>>>
>>> After changing the "uid" to "id",  still it doesn't work.
>>>
>>> Thank you
>>>
>>>
>>> On Thu, Feb 15, 2018 at 12:14 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>&g

Re: [Dhis2-users] Posting Metadata in dhis2.

2018-02-15 Thread Isaiah Nyabuto
Thank you for the tip. It still doesn't work.
what does this error mean?

httr::content(r, "text")

[1] "{\"httpStatus\":\"Internal Server Error\",\"httpStatusCode\":
500,\"status\":\"ERROR\",\"message\":\"Can not instantiate value of type
[simple type, class org.hisp.dhis.organisationunit.OrganisationUnit] from
String value ('It7fWcKbcZX'); no single-String constructor/factory
method\\n at [Source: org.apache.catalina.connector.
CoyoteInputStream@1efec811; line: 1, column: 73] (through reference chain:
org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\"])\"}"

Anyone?

Thank you.
==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Feb 15, 2018 13:14, "Jason Pickering" <jason.p.picker...@gmail.com>
wrote:

All of your fields must have exactly the correct names:

shortname -> shortName
featuretype-> featureType

Keep hacking at it! You will get there!

Regards,
Jason


On Thu, Feb 15, 2018 at 11:08 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
wrote:

> Hi Jason,
>
> Here is some bit of my post data.
>
> {"organisationUnits":[{"name":"Wikithuki 
> Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
>  
> Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
>  Medical 
> Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
>  Medical 
> Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
>  Community Health 
> Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
>  CHU","description":"Community 
> Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
>  Health Centre","uid":"cmay4WXRmhA","code":"12034","parent":
>
>
> After changing the "uid" to "id",  still it doesn't work.
>
> Thank you
>
>
> On Thu, Feb 15, 2018 at 12:14 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Isaiah,
>>
>> Post a bit of your JSON here from  toJSON(list(organisationUnits=new_org),
>> auto_unbox = TRUE)
>>
>> One other problem I noticed as well is this
>>
>> [{"name":"Wikithuki Dispensary","uid":"Bc371uxfYD5"
>>
>>
>> It should be
>>
>> [{"name":"Wikithuki Dispensary","id":"Bc371uxfYD5"
>>
>>
>> Regards,
>> Jason
>>
>>
>> On Thu, Feb 15, 2018 at 10:01 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com
>> > wrote:
>>
>>> Hi Jason,
>>>
>>> I get an internal server error code: 500, after trying that. Here is the
>>> response;
>>>
>>> httr::content(r, "text")[1] "{\"httpStatus\":\"Internal Server 
>>> Error\",\"httpStatusCode\":500,\"status\":\"ERROR\",\"message\":\"Can not 
>>> instantiate value of type [simple type, class 
>>> org.hisp.dhis.organisationunit.OrganisationUnit] from String value 
>>> ('It7fWcKbcZX'); no single-String constructor/factory method\\n at [Source: 
>>> org.apache.catalina.connector.CoyoteInputStream@1efec811; line: 1, column: 
>>> 73] (through reference chain: 
>>> org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\"])\"}"
>>>
>>>
>>> Thank you.
>>>
>>> On Th

Re: [Dhis2-users] Posting Metadata in dhis2.

2018-02-15 Thread Isaiah Nyabuto
Hi Jason,

Here is some bit of my post data.

{"organisationUnits":[{"name":"Wikithuki
Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
Medical 
Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
Medical 
Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
Community Health
Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
CHU","description":"Community
Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
Health Centre","uid":"cmay4WXRmhA","code":"12034","parent":


After changing the "uid" to "id",  still it doesn't work.

Thank you


On Thu, Feb 15, 2018 at 12:14 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Isaiah,
>
> Post a bit of your JSON here from  toJSON(list(organisationUnits=new_org),
> auto_unbox = TRUE)
>
> One other problem I noticed as well is this
>
> [{"name":"Wikithuki Dispensary","uid":"Bc371uxfYD5"
>
>
> It should be
>
> [{"name":"Wikithuki Dispensary","id":"Bc371uxfYD5"
>
>
> Regards,
> Jason
>
>
> On Thu, Feb 15, 2018 at 10:01 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi Jason,
>>
>> I get an internal server error code: 500, after trying that. Here is the
>> response;
>>
>> httr::content(r, "text")[1] "{\"httpStatus\":\"Internal Server 
>> Error\",\"httpStatusCode\":500,\"status\":\"ERROR\",\"message\":\"Can not 
>> instantiate value of type [simple type, class 
>> org.hisp.dhis.organisationunit.OrganisationUnit] from String value 
>> ('It7fWcKbcZX'); no single-String constructor/factory method\\n at [Source: 
>> org.apache.catalina.connector.CoyoteInputStream@1efec811; line: 1, column: 
>> 73] (through reference chain: 
>> org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\"])\"}"
>>
>>
>> Thank you.
>>
>> On Thu, Feb 15, 2018 at 10:36 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Isiah,
>>>
>>> The reason for it not working (at least at first glance) is that you are
>>> posing to the /api/metadata endpoint. Thus, you need to tell the server
>>> what you are trying to import. In this case, its organisation units.
>>>
>>> I think changing this to
>>>
>>>   r <- POST(url, authenticate(dest.user, dest.pass),
>>> body = toJSON(list(organisationUnits=new_org), auto_unbox =
>>> TRUE),
>>> content_type_json())
>>>
>>> should work.
>>>
>>> The example works because the file
>>> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
>>> looks like this:
>>>
>>>
>>> {"created":"2016-08-10","organisationUnits":[{"id":"u6yjgvIMzKn",...
>>>
>>>
>>> Hope this helps and best regards,
>>>
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Feb 15, 2018 at 6:34 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com
>>> > wrote:
>>>
>>>>
>>>> Dear Jason and Dhis2 Community,
>>>>

Re: [Dhis2-users] Posting Metadata in dhis2.

2018-02-15 Thread Isaiah Nyabuto
Hi Jason,

I get an internal server error code: 500, after trying that. Here is the
response;

httr::content(r, "text")[1] "{\"httpStatus\":\"Internal Server
Error\",\"httpStatusCode\":500,\"status\":\"ERROR\",\"message\":\"Can
not instantiate value of type [simple type, class
org.hisp.dhis.organisationunit.OrganisationUnit] from String value
('It7fWcKbcZX'); no single-String constructor/factory method\\n at
[Source: org.apache.catalina.connector.CoyoteInputStream@1efec811;
line: 1, column: 73] (through reference chain:
org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\"])\"}"


Thank you.

On Thu, Feb 15, 2018 at 10:36 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Isiah,
>
> The reason for it not working (at least at first glance) is that you are
> posing to the /api/metadata endpoint. Thus, you need to tell the server
> what you are trying to import. In this case, its organisation units.
>
> I think changing this to
>
>   r <- POST(url, authenticate(dest.user, dest.pass),
> body = toJSON(list(organisationUnits=new_org), auto_unbox =
> TRUE),
> content_type_json())
>
> should work.
>
> The example works because the file
> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
> looks like this:
>
>
> {"created":"2016-08-10","organisationUnits":[{"id":"u6yjgvIMzKn",...
>
>
> Hope this helps and best regards,
>
> Jason
>
>
>
>
>
> On Thu, Feb 15, 2018 at 6:34 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>>
>> Dear Jason and Dhis2 Community,
>>
>> I am following your guide on bootstrapping
>> <https://github.com/jason-p-pickering/dhis2-data-munging/blob/master/bootstrap/bootstrap.Rmd>
>>  dhis2 with R while trying to import metadata using the API.
>>
>> I do not understand why my metadata is not imported. Here are my steps,
>> any help will be appreciated.
>>
>>
>> head(org)  name uid   code  parent   
>>   shortname
>> 1 Wikithuki Dispensary Bc371uxfYD5  16925 vpiZlB5cdK7  Wikithuki 
>> Dispensary
>> 2Gemifa Medical Clinic Z7Lf1n3Fcpi  22907 mEZBjj4fLBT
>> Gemifa
>> 3   Olympus Medical Clinic NAbQdHuaJFK  22906 PeEcMfBchbr   
>> Olympus
>> 4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1
>> Masaba CHU
>> 5Gatunga Health Centre cmay4WXRmhA  12034 IcAegRcGuV6 Gatunga Health 
>> Centre
>> 6 Cfw Kimangaru Clinic E52UsoBxJVS  11966 vEAFtHnPDrX  CFW Kimangaru 
>> Clinic
>>  description openingdate closedate comment featuretype  
>> coordinates url
>> 1 NANA   POINT  
>> [37.95263,-0.77819]
>> 2 Clinic  NANANONE 
>> [34.391914,0.059575]
>> 3 Clinic  NANANONE   
>> [34.3994,0.059575]
>> 4 Community Unit  NANANONE   
>> [34.46411,0.19358]
>> 5 NANA   POINT   
>> [37.9423,-0.29656]
>> 6 NANA   POINT  
>> [37.53009,-0.54506]
>>   contactperson address email phonenumber
>> 1NA  NANA  NA
>> 2NA  NANA  NA
>> 3NA  NANA  NA
>> 4NA  NANA  NA
>> 5NA  NANA  NA
>> 6NA  NANA  NA
>>
>>
>> I followed the following steps to prepare my df for import.
>> 1. Removed all the NAs  and columns with entire NAs.
>>
>> head(new_org)  name uid   code  parent   
>>   shortname
>> 1 Wikithuki Dispensary Bc371uxfYD5  16925 vpiZlB5cdK7  Wikithuki 
>> Dispensary
>> 2Gemifa Medical Clinic Z7Lf1n3Fcpi  22907 mEZBjj4fLBT
>> Gemifa
>> 3   Olympus Medical Clinic NAbQdHuaJFK  22906 PeEcMfBchbr   
>> Olympus
>> 4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1
>> Masaba CHU
>> 5Gatunga Health Centre cmay4WXRmhA  12034 IcAegRcGuV6 Gatunga Health 
>> Centre
>> 6 Cfw Kimangaru Clinic E52UsoBxJVS  11966 vEAFtHnPDrX  CFW Kimangaru 
>> Clinic
>>  description comment featuretype  coordinates u

[Dhis2-users] Posting Metadata in dhis2.

2018-02-14 Thread Isaiah Nyabuto
Dear Jason and Dhis2 Community,

I am following your guide on bootstrapping
<https://github.com/jason-p-pickering/dhis2-data-munging/blob/master/bootstrap/bootstrap.Rmd>
 dhis2 with R while trying to import metadata using the API.

I do not understand why my metadata is not imported. Here are my steps, any
help will be appreciated.


head(org)  name uid   code  parent
shortname
1 Wikithuki Dispensary Bc371uxfYD5  16925 vpiZlB5cdK7
Wikithuki Dispensary
2Gemifa Medical Clinic Z7Lf1n3Fcpi  22907 mEZBjj4fLBT
  Gemifa
3   Olympus Medical Clinic NAbQdHuaJFK  22906 PeEcMfBchbr
 Olympus
4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1
  Masaba CHU
5Gatunga Health Centre cmay4WXRmhA  12034 IcAegRcGuV6 Gatunga
Health Centre
6 Cfw Kimangaru Clinic E52UsoBxJVS  11966 vEAFtHnPDrX  CFW
Kimangaru Clinic
 description openingdate closedate comment featuretype
coordinates url
1 NANA   POINT
[37.95263,-0.77819]
2 Clinic  NANANONE
[34.391914,0.059575]
3 Clinic  NANANONE
[34.3994,0.059575]
4 Community Unit  NANANONE
[34.46411,0.19358]
5 NANA   POINT
[37.9423,-0.29656]
6 NANA   POINT
[37.53009,-0.54506]
  contactperson address email phonenumber
1NA  NANA  NA
2NA  NANA  NA
3NA  NANA  NA
4NA  NANA  NA
5NA  NANA  NA
6NA  NANA  NA


I followed the following steps to prepare my df for import.
1. Removed all the NAs  and columns with entire NAs.

head(new_org)  name uid   code
parent shortname
1 Wikithuki Dispensary Bc371uxfYD5  16925 vpiZlB5cdK7
Wikithuki Dispensary
2Gemifa Medical Clinic Z7Lf1n3Fcpi  22907 mEZBjj4fLBT
  Gemifa
3   Olympus Medical Clinic NAbQdHuaJFK  22906 PeEcMfBchbr
 Olympus
4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1
  Masaba CHU
5Gatunga Health Centre cmay4WXRmhA  12034 IcAegRcGuV6 Gatunga
Health Centre
6 Cfw Kimangaru Clinic E52UsoBxJVS  11966 vEAFtHnPDrX  CFW
Kimangaru Clinic
 description comment featuretype  coordinates url
1  POINT  [37.95263,-0.77819]
2 ClinicNONE [34.391914,0.059575]
3 ClinicNONE   [34.3994,0.059575]
4 Community UnitNONE   [34.46411,0.19358]
5  POINT   [37.9423,-0.29656]
6  POINT  [37.53009,-0.54506]


3. Then post the data as follows.

dest.url <- "http://localhost/dhis/;
url <- paste0(dest.url, "api/metadata?importStrategy=C
REATE=NONE")
  r <- POST(url, authenticate(dest.user, dest.pass),
body = toJSON(new_org, auto_unbox = TRUE),
content_type_json())
  assertthat::assert_that(r$status_code==200)

4. The body looks like.

jsonlite::toJSON(me, auto_unbox = TRUE)[{"name":"Wikithuki
Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
Medical 
Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
Medical 
Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
Community Health
Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
CHU","description":"Community
Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
Health 

Re: [Dhis2-users] Possibility of creating non numerical UID prefixes in tracker capture

2018-02-08 Thread Isaiah Nyabuto
Hi Aimee,

What is the length of the UIDs? The dhis2 accepts UID length of 11 and can
accept any other types (letters and numbers) so long as the first one is a
letter.

If you want to avoid duplication of UID, the easiest way is by generating
them yourself using other tools or languages.
See the following example on UID generation.
https://github.com/jason-p-pickering/dhis2-data-munging/blob/master/bootstrap/bootstrap.Rmd

Thank you.
==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics


On Feb 8, 2018 16:32, "Aimee Edmondo" <aedmo...@akros.com> wrote:

Greetings all,
In Zambia we are investigating the possibility of having sub instances of
tracker capture that feed into a main instance, but we want to avoid the
issue of duplicate UIDs coming from the sub instances. We were hoping to
add a prefix onto the automatic UID generation - such as NG###, where
the prefix "NG" remains consistent and the numbers are automatically
generated. We've experimented with the UID options and the system does not
accept this pattern. Has anyone successfully done this before or have any
ideas as to how to do this?
Thanks,
*Aimee Edmondo, MPH* | Informatics Associate
aedmo...@akros.com <acmar...@akros.com> | +260.976.076524

___
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 ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

2018-02-08 Thread Isaiah Nyabuto
Hi Stanley and Dear dhis2 community.

I have been in the same situation and its now two days while still trying
to figure out why some of my data elements are not showing values in the
pivot table.

Maybe my set up is different. I have data elements assigned into a data set
with category combination. My data elements are using the default category
combo -after I was unable to assign categories combo to the data elements.

I posted some data into the data elements while following the section on:
sending datavalues in the dhis2 developers guide. My API client returns a
status code: 200, meaning that data was successfully sent.

So when I run analytics, there are only few data elements displaying data
on the pivot table. I have tried to rerun the analytics and cleared cache
several times, there is no change.

Maybe this is an issue with dhis2 version 2.28? I do understand.

I need help.

Thank you.
==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Feb 6, 2018 14:12, "Stanley Kalyati" <skaly...@gmail.com> wrote:

> Hi All,
>
> I posted something similar sometime two weeks ago.
>
> I have data elements whose value type is number and aggregation type is
> Sum.I created a data set and assigned it to the Organisation unit.
>
> I captured data and run analytics.When i run the pivot tables,no data
> values.
>
> However,when i add a Category Combination which is an attribute to the
> data set,enter data and run pivot tables,data is there.
>
> I am confused.
>
> Anyone with an idea?
>
> Thank you
>
>
> ___
> 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 element not found or not accessible

2018-01-29 Thread Isaiah Nyabuto
Hi all,

Thanks Timothy for sharing this. I am trying to import organisation units
metadata in csv file with UTF-8 encoding. When I import the file with
Metadata import in dhis2, the file is not imported at all and I do get the
summary report.

I wrote the csv file with R function write.table.

Its funny enough that when I write the same file using Excel and save as
csv file with UTF-8, it works well.

I do not understand what could be the problem here, has anyone tried to
write a csv file with an R function that can successfully be imported in
the dhis2?

Looking for your help. I have attached my csv files in this email.

Thanks




==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Jan 17, 2018 17:51, "Thomas Lavreys" <thomaslavr...@gmail.com> wrote:

> Thanks for the in depth info! It will surely help along the way. I’ve only
> started with some testers, but I will probably run into some more issues
> when I load my real data.
>
>
>
> Thanks again!!
>
>
>
> Kind regards,
>
>
>
> Thomas
>
>
>
> *From:* Timothy Harding [mailto:thard...@baosystems.com]
> *Sent:* Wednesday, January 17, 2018 3:35 PM
> *To:* Thomas Lavreys <thomaslavr...@gmail.com>
> *Cc:* Adebusoye Anifalaje <bus...@baosystems.com>; dhis2-users <
> dhis2-users@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] Data element not found or not accessible
>
>
>
> Hello Thomas!
>
>
>
> I am glad you have solved your issue! I noticed a few gotchas so here are
> a couple of things to note when importing csv files in DHIS 2:
>
>
>
> 1. The first row
>
>
>
> dataelement Data element not found or not accessible
>
>
>
> [image: Inline image 1]
>
>
>
> is a* funny error*, because it is actually telling you something about a
> single row, found here in the documentation
> <https://docs.dhis2.org/master/en/developer/html/webapi_data_values.html#webapi_data_values_csv>
> :
>
> "dataelement","period","orgunit","catoptcombo","attroptcombo","value","storedby","lastupd","comment"
>
> DHIS 2 is literally complaining about the fact that it *cannot find a
> data element with the uid "dataelement"*, which is what is assumes you
> are trying to load in that top row. You can try yourself by loading a file
> with only this top line, the error will be the same, 1 ignored row, data
> element not found or not accessible. It is safe to ignore this error, I'd
> be worried if there was a UID called dataelement, which is actually a valid
> UID! Just extremely unlikely to pop up from the random UID generator.
>
>
>
>
>
> 2. Ignored
>
>
>
> Unlike the metadata importer, the data importer will report that it
> ignored *every row on a dry run*. It can make testing difficult because
> you don't know if it will actually import correctly or not as it reports
> back that every row was ignored. Two rules of thumb here:
>
>1. The actual errored out row will be listed in the "Conflicts"
>section, even in a dry run
>2. Sadly, some errors you can only find on a real run, so always
>upload your files with a comment, so you can find them later via the DB to
>delete them if something goes wrong and all else fails
>
>
>
>
>
> 3. File Type
>
>
>
> UTF-8 works well and I use it for all my CSV uploads. Be wary of EXCEL's
> CSV saving habits though, especially on a Mac. Your file should be *UTF-8
> without a BOM* (a byte order marker, DHIS 2 doesn't _really_ care, as it
> will error out on row one anyway (see above)) AND it should be standard *unix
> line feeds (LF)*. Excel for the Mac will default to saving it with circa
> 1990's CRs only AND a BOM (unless you are editing a CSV, in which case it
> will keep the settings it found when it opened it). Easiest way to check is
> to grab a copy of Notepad++ (windows) or BBedit (mac).
>
>
>
> BBedit:
>
> [image: Inline image 2]
>
>
>
> and
>
>
>
> [image: Inline image 3]
>
>
>
>
>
> Notepad++
>
> [image: Inline image 4]
>
>
>
> and
>
>
>
> [image: Inline image 5]
>
>
>
> Hope this helps!
>
>
>
>
>
>
>
>
> *Timothy Harding*
> Sr. Systems Analyst, BAO Systems
>
> +1 202-536-1541 | thard...@baosystems.com | http://www.baosystems.com | Skype:
> hardi...@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007
>
>
>
> On Wed, Jan 17, 2018 at 9:11 AM, Thomas Lavreys <thomaslavr...@gmail.com>
> wrote:
>
> I found the issue. The file was saved as a csv utf-8, which is differ

Re: [Dhis2-users] Installing Shiny App in dhis2

2017-12-18 Thread Isaiah Nyabuto
Hi Jason,

Thanks for the clarification.

I suppose running the app externally will work well in this case. No need
to write another app to connect shiny server with dhis2.

Thanks.






==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics

On Dec 18, 2017 22:54, "Jason Pickering" <jason.p.picker...@gmail.com>
wrote:

> Hi  Isaiah,
>
> Shiny apps are written in the R programming language, so you would need to
> run this on an external R server, and then use another app (I guess) to
> connect with DHIS2 to the Shiny server.
>
> DHIS2 itself has no capability to  run Shiny apps, which must be written
> in pure HTML and JavaScript and utilize only the native API of DHIS2. If
> you are using external services, such as Shiny, you would need to take that
> into account in your DHIS2 facing app.
>
> Regards,
> Jason
>
>
> On Mon, Dec 18, 2017 at 11:03 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi.
>>
>> Has anyone ever tried to install  shiny app in dhis2?
>>
>> I am not able to install my shiny app. I get an error when uploading the
>> zip file: Manifest file missing.
>>
>> Does dhis2 support shiny apps?
>>
>> Kindest regards - Isaiah
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>> ___
>> 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


[Dhis2-users] Installing Shiny App in dhis2

2017-12-18 Thread Isaiah Nyabuto
Hi.

Has anyone ever tried to install  shiny app in dhis2?

I am not able to install my shiny app. I get an error when uploading the
zip file: Manifest file missing.

Does dhis2 support shiny apps?

Kindest regards - Isaiah
-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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 exporting metadata throuhg metadata export

2017-12-04 Thread Isaiah Nyabuto
Hi Vunda,

Yes, I am very happy to assist where I can, and to see you learn in the
community.

If you still stack, let me know, we can plan for a Skype sessions.

Best regards


On Fri, Dec 1, 2017 at 1:43 PM, vunda limbe <vunda...@gmail.com> wrote:

> Hi Isaiah,
>
> Thank you for your help, but I'm a newbie in Web API even in Restfull. I
> need step by step to apply the script you sent me.
> Could you help?
>
> Thanks.
>
> On Wed, Nov 22, 2017 at 6:47 PM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi Vunda,
>>
>> I hope you were sorted out ?
>>
>> You may also want to have look the following script
>> <https://github.com/INyabuto/dhis2_rapi> on web APIs with dhis2 I once
>> did. You only need to construct a URL and change the credentials and you
>> are good to go.
>>
>> Best regards
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Nov 17, 2017 at 3:57 PM, vunda limbe <vunda...@gmail.com> wrote:
>>
>>> Hi Everybody,
>>>
>>> When I try to export meta data in both json or xml, I'm getting this
>>> message: "
>>>
>>> {"httpStatus":"Internal Server Error","httpStatusCode":500,"status":"ERROR"}
>>>
>>> Could someone tell me how to fix this? Alternativly, someone can give me a 
>>> script in order to export dataelement, COC, CO and Dataset using Web Api.
>>>
>>> Your help is welcome.
>>>
>>> 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
>>>
>>>
>>
>>
>> --
>> 
>> 
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>
>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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 exporting metadata throuhg metadata export

2017-11-22 Thread Isaiah Nyabuto
Hi Vunda,

I hope you were sorted out ?

You may also want to have look the following script
<https://github.com/INyabuto/dhis2_rapi> on web APIs with dhis2 I once did.
You only need to construct a URL and change the credentials and you are
good to go.

Best regards







On Fri, Nov 17, 2017 at 3:57 PM, vunda limbe <vunda...@gmail.com> wrote:

> Hi Everybody,
>
> When I try to export meta data in both json or xml, I'm getting this
> message: "
>
> {"httpStatus":"Internal Server Error","httpStatusCode":500,"status":"ERROR"}
>
> Could someone tell me how to fix this? Alternativly, someone can give me a 
> script in order to export dataelement, COC, CO and Dataset using Web Api.
>
> Your help is welcome.
>
> 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
>
>


-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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] Server Specification

2017-11-14 Thread Isaiah Nyabuto
Hello,

Are there guidelines with minimum server specification for setting up a
local instance of dhis2.

Thanks

-- 

Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
___
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