Re: [Dhis2-users] [Dhis2-devs] ACCESS TO DATA FROM MULTIPLE STAGES IN EVENT REPORTS

[Ime Asangansi]

Stanley,

You can also have a look at this issue raised by Calle:
https://jira.dhis2.org/browse/DHIS2-2461
I think its crucial for what you want.

Not sure how the votes help but please add your vote to that issue.

Thank you

Ime


On Sat, Mar 10, 2018 at 10:48 AM, Stanley Kalyati 
wrote:

> Thank you Markus,
>
> I will add my comments.
>
> Regards
>
> Stanley
>
> On Sat, Mar 10, 2018 at 11:34 AM, Markus Bekken  wrote:
>
>> Hi Stanley,
>> this is currently not possible. It is however something that is being
>> requested, and we have created these epics to capture the functional area:
>> - https://jira.dhis2.org/browse/DHIS2-3140
>> - https://jira.dhis2.org/browse/DHIS2-2106
>>
>> Can you please have a look at the epics and possibly add more about your
>> use case in the comments?
>>
>> Markus
>>
>> > 10. mar. 2018 kl. 10:10 skrev Stanley Kalyati :
>> >
>> > Has anyone got experience with running an event report that merges data
>> from multiple stages? For example connecting the unique identifier to HIV
>> Test results and then ART Initiation Status? Three different sources of
>> data.
>> >
>> > Your assistance is appreciated always
>> >
>> > Stanley
>> >
>> > ___
>> > Mailing list: https://launchpad.net/~dhis2-devs
>> > Post to : dhis2-d...@lists.launchpad.net
>> > Unsubscribe : https://launchpad.net/~dhis2-devs
>> > More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Excel data connection options

[Ime Asangansi]

Hi Ned,

That's quite an interesting approach. Great to see.
If you need to add basic authentication details, where would you add it in
the example query format you sent?

Thanks,
Ime



[image: photo]

<http://twitter.com/imeasangansi>
<http://ng.linkedin.com/company/ehealth4everyone>
<http://twitter.com/ehealth4every1>
Ime Asangansi MD,PhD
Chief Excellence Officer, ehealth4everyone

+2348180790150
i...@ehealth4everyone.com
Skype: asangansiime <#>
www.ehealth4everyone.com
<https://ng.linkedin.com/in/asangansi>


On Mon, Nov 27, 2017 at 9:13 PM, Ned Jaszi <ned.ja...@gmail.com> wrote:

> Thanks. I figured out a more plug and play solution using Excel
> Get/Transform (previously PowerQuery).  The steps are: 1) Create a New
> Query from Other Sources/Web. 2) Enter the API call URL 3) Enter
> credentials in Basic tab when prompted
>
> I've tested so far with calls for CSV format. Some fiddling is required to
> set the query to read as CSV, but altogether pretty straightforward.  The
> source step of the query will end up looking something like: =
> Csv.Document(Web.Contents("https://URL/api/dataElements.csv?paging=false
> "),[Delimiter=","])
>
> Best,
> Ned
>
> On Mon, Nov 27, 2017 at 8:59 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Ned,
>>
>> I don't think there are any plans to support OData at this point.
>>
>> I would suggest you have a look at our documentation and utilize the
>> metadata and analytics  API for this. VBA seems to be capable of making
>> HTTP requests. It might not be the plug and play, standardized solution you
>> are looking for however, but should be possible.
>>
>> Regards,
>> Jason Pickering
>>
>>
>>
>>
>>
>>
>>
>>
>> On Nov 26, 2017 21:12, "Ned Jaszi" <ned.ja...@gmail.com> wrote:
>>
>>
>> 0down votefavorite
>> <https://webmasters.stackexchange.com/questions/110999/data-feed-connection-to-excel#>
>>
>> I'm interested in creating a data connection in Excel to access data from
>> the DHIS2 web api. Essentially I want to be able to generate refreshable
>> tables in an Excel data model from DHIS2 sources: API queries or SQL views.
>> Excel 2016 (or with PowerPivot/PowerQuery add-ins in previous versions)
>> enables connections to OData Data Feeds, but the DHIS2 web api does not use
>> the OData protocol (http://www.odata.org/). I have not found an
>> alternative method. Any suggestions? Are there any plans to develop an
>> OData compatible api?
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] New user guide

[Ime Asangansi]

Dear Nasiru,

We are happy to guide you through the process of starting up with DHIS2 as
an M system for your organization.
And we can conduct training for your teams in all W4H states as well.

We can setup a demonstration installation with a sample form for your
evaluation to allow you understand the system better, with free cloud
hosting for you for the first 6 months since you are a nonprofit program in
Nigeria.

If you are in or near Abuja, we can meet up at your convenience or you can
call me from Kano.

Best regards,
Ime


Ime Asangansi, M
​BBS​
PhD (Informatics)
CEO, eHealth4everyone
​
Skype: asangansiime Twitter: @imeasangansi
<https://twitter.com/imeasangansi> Linkedin:
http://ng.linkedin.com/in/asangansi
Mobile: +2348180790150 (Nigeria), +23279448648 (Sierra Leone), +441172301500
(UK)

On Thu, Aug 17, 2017 at 9:59 AM, Nasiru Sa'adu Fakai <nsfakai2...@gmail.com>
wrote:

> Dear all,
>
> We are considering using Dhis2 as our data collection,  analysis and
> storage application. Can you provide guide on what are needed from
> installation, allocation of organization unit and subsequent use.
> I will really appreciate your help.
>
> Thank you.
> Nasiru S Fakai
> M Advisor
> Women for Health (W4H), Nigeria
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Free DHIS2 Training for Nigeria-based NGOs - Abuja, Feb 22, 2017

[Ime Asangansi]

Dear colleague,

Nonprofit organizations in Nigeria play a major role through their 
healthcare delivery, prevention and advocacy programs.
However, they typically struggle to manage the M / MERL / HIS aspects 
of their projects and are generally not able to keep up with best 
practices and new appropriate technologies.
This shouldn't be, especially as program effectiveness, efficiency and 
funding often depend and need robust data for decisions and reporting - 
and there are great tools such as DHIS2 that meet these needs.


To help support the ecosystem of nonprofits in Nigeria, ehealth4everyone 
has designed a free DHIS2 Training series.
This is in keeping with our mission to make digital health tools 
available and accessible to everyone, especially those in low resource 
settings.


This activity is self-funded and as such we do not have enough room for 
more than 20 persons. Apply soon, as spaces are limited.


Apply at http://ehealth4everyone.com/dhis2-training/

Share with your colleagues working at NGOs in Nigeria.

Best regards,
Ime Asangansi MD, PhD (Informatics)
CEO, eHealth for Everyone Foundation

--
photo   
<http://twitter.com/imeasangansi> 
<http://ng.linkedin.com/company/ehealth4everyone> 
<http://twitter.com/ehealth4every1>

Ime Asangansi MD, PhD (Informatics)
Chief Excellence Officer, ehealth4everyone
Abuja, Nigeria

+2348180790150 <tel:+2348180790150>
i...@ehealth4everyone.com <mailto:i...@ehealth4everyone.com>
Skype: asangansiime <#>
www.ehealth4everyone.com <http://www.ehealth4everyone.com>

<https://twitter.com/ehealth4every1><https://ng.linkedin.com/in/asangansi>

___
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] https://digitalhealth.institute/ Re: Online DHIS2 Training Resource

[Ime Asangansi]

Hi Sarah,


Thanks for this great work! This is really rich!


We've been working on a couple of free courses on various areas of 
digital health, including DHIS2 - for the global digital health learning 
platform - https://digitalhealth.institute/


At the Digital Health Institute (DHI), we believe that digital health 
education will help create new futures. It is common knowledge that the 
futures we all envisage for digitally-enabled health care systems can 
not be achieved without a critical mass of 
knowledgeable health-care workers and Health IT professionals. Yet poor 
access to structured content and low capacity and skills have remained a 
major problem and impediment, especially in low and middle income countries.
We aim to fix this problem through online and offline digital health 
training content and courses.



In the coming months, we will be uploading our free DHIS2 online courses.

Sarah, thanks to your Creative Commons license, we plan to upload yours 
as well, and we'll be designing and setting up a series of quizzes, as 
some sort of certification process, in partnership with some 
universities. Keep you posted on that.



We are also interested in new partnerships and would be excited to 
collaborate. Particularly, we are interested in collaborations with 
organizations in the Health IT value chain - including but not limited 
to universities and schools, innovative organizations, Health IT 
consultants and users such as Ministries of Health, NGOs, private 
companies, organizations and eHealth enthusiasts.



As soon as things are ready in few weeks, we would be inviting beta 
users onto the https://digitalhealth.institute/ platform.


Please write to me privately at i...@ehealth4everyone.org for inquiries, 
suggestions and any interests in partnerships. We'd be excited to discuss.


Thanks and best regards,
Ime
Abuja, Nigeria


photo   
<http://twitter.com/imeasangansi> 
<http://ng.linkedin.com/company/ehealth4everyone> 
<http://twitter.com/ehealth4every1>

Ime Asangansi MD, PhD
Chief Excellence Officer, ehealth4everyone
Abuja, Nigeria

+2348180790150 <tel:+2348180790150>
i...@ehealth4everyone.com <mailto:i...@ehealth4everyone.com>
Skype: asangansiime <#>
www.ehealth4everyone.com <http://www.ehealth4everyone.com>

<https://twitter.com/ehealth4every1><https://ng.linkedin.com/in/asangansi>


On 5/24/2016 4:17 PM, Sara Gaudon wrote:

Hello fellow DHIS2 users,

My name is Sara Gaudon from LogicalOutcomes 
<http://logicaloutcomes.net/>; I'm working with Dr. Gillian Kerr and 
other partners (HISPUganda, Entuura, Knowarth) to offer a 'quick 
start' service for NGOs to pilot DHIS2 for their program monitoring & 
evaluation.


We  recently shared '*DHIS2 curriculum' on GitHub - a free training 
resource*, complimentary to the University of Oslo Academy. The 
resource includes links to the user manual, workshops, custom 
videos and assignments. Relying on Microsoft OneNote, we've laid out 
15 units and 30+ assignments to help beginner users plan for, design, 
and configure a DHIS2 instance.


*Access the DHIS2 Curriculum online 
<https://github.com/LogicalOutcomes/dhis2-templates/wiki/DHIS2-Curriculum>***

(options for desktop/offline)


If you'd like to know more:
1. On May 17 we joined NPOKI for a webinar on this self-study 
<https://vimeo.com/167033856>resource.
2. Watch this quick 2 minute video 
<https://www.youtube.com/watch?v=4isEACMO1fk=em-upload_owner>


We will continue to make improvements to the curriculum; up next, 
we're adding assignment walk-through videos you can access on YouTube.


In the spirit of open access, we would be delighted to hear your 
feedback!


-Sara

---
Sara Gaudon | Executive Director, LogicalOutcomes  | 
www.logicaloutcomes.net <http://www.logicaloutcomes.net/>
Toronto (647) 478-5634 x103 New York (518) 293-2718  | 
 s...@logicaloutcomes.net



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


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

[Dhis2-users] Organisation Unit Pruning

[Ime Asangansi]

Hi,

Someone just asked me why Organisation Unit Pruning was removed from the data 
admin section in the latest 2.7 and where it is now. I'm clueless. Please, who 
knows?

Thanks,
Ime

___
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] Organisation Unit Pruning

[Ime Asangansi]

Ok, thanks Larsinteresting though
Ime
--- On Fri, 4/27/12, Lars Helge Øverland larshe...@gmail.com wrote:

From: Lars Helge Øverland larshe...@gmail.com
Subject: Re: Organisation Unit Pruning
To: Ime Asangansi asanga...@yahoo.com
Cc: dhis2-users@lists.launchpad.net dhis2-users@lists.launchpad.net
Date: Friday, April 27, 2012, 10:01 PM

Hi Ime,
it has been removed as it was buggy and from what I understood not much in use.
Lars

On Fri, Apr 27, 2012 at 8:53 PM, Ime Asangansi asanga...@yahoo.com wrote:

Hi,



Someone just asked me why Organisation Unit Pruning was removed from the data 
admin section in the latest 2.7 and where it is now. I'm clueless. Please, who 
knows?



Thanks,

Ime



___
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