Re: [Dhis2-users] how to delete org?

[林晓东]

Thanks！





--

此致

   林晓东

莫愁前路无知己，天下谁人不识君。

在 2017-11-27 16:05:41，"Markus Bekken"  写道：
There is some SQL resources to delete orgunits here:
https://github.com/dhis2/dhis2-utils/tree/master/resources/sql


27. nov. 2017 kl. 09.01 skrev Nayeem Al Mifthah :


You may delete from database after deleting constrains.


Nayeem Al Mifthah
Consultant for HSS, Health MIS, M&E
Email: n.mift...@gmail.com 
Cell:+8801914030574

Skype: nayeem.a.m


On Mon, Nov 27, 2017 at 9:27 AM, 林晓东  wrote:

Hi,all，


   I have added some orginaztion and some DE、DS， so ,can't delete org, how can 
I do it, what's steps should I do?


 Thanks.




--

此致
 easy

莫愁前路无知己，天下谁人不识君。



 


___
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] Excel data connection options

[Ned Jaszi]

Excel will prompt you for the credentials in a separate dialogue box. These
are saved and applied for all queries to the same URL. I'm not yet sure how
this works when sharing the file with other users.

On Nov 28, 2017 12:05 AM, "Ime Asangansi"  wrote:

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]




Ime Asangansi MD,PhD
Chief Excellence Officer, ehealth4everyone

+2348180790150
i...@ehealth4everyone.com
Skype: asangansiime <#m_-9129064155246557617_>
www.ehealth4everyone.com



On Mon, Nov 27, 2017 at 9:13 PM, Ned Jaszi  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"  wrote:
>>
>>
>> 0down votefavorite
>> 
>>
>> 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] 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]




Ime Asangansi MD,PhD
Chief Excellence Officer, ehealth4everyone

+2348180790150
i...@ehealth4everyone.com
Skype: asangansiime <#>
www.ehealth4everyone.com



On Mon, Nov 27, 2017 at 9:13 PM, Ned Jaszi  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"  wrote:
>>
>>
>> 0down votefavorite
>> 
>>
>> 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] Excel data connection options

[Ned Jaszi]

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"  wrote:
>
>
> 0down votefavorite
> 
>
> 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

[Dhis2-users] How to get logged in to dhis2 from other website?

[Raja Imran Qamer]

Hi everyone,

I am working on a project where we have users of many roles, When user 
of a specific role comes we have a separate MIS System where they enters 
username and password which is being validated from dhis2 database and 
hence they authenticated to log in, The problem is we want when user's 
username and password authenticated they automatically get log-in to 
dhis2 system along with our custom MIS (developed in php), Is there any 
way to achieve it?


Currently they need to log-in to PHP system separately and dhis2 system 
separately.


Thanks
Regards,
--
RAJA IMRAN QAMER,

Senior Software Engineer, Project Manager,
PACE TECHNOLOGIES Pvt Ltd.,
Islamabad, Pakistan.
Email:im...@pace-tech.com, rajaimranqa...@gmail.com
Phone: +923345073573, +92512361110
Web: www.pace-tech.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

Re: [Dhis2-users] Update Category option combination

[Ifeanyi Okoye]

Hello Lars,This is similar to the issue I raised on this platform last week.
What I noticed is that some data elements will carry the old category option 
combo even after it has been changed or updated. This affects the form designer 
and section forms. In our own case, everything refused to update. I ran 
maintenance severally with no effect whatsoever. 
I am posting the thread below as only one person weighed in on this:
Thread:

Hello Laura,Thank you for your response.
We are currently running the 22nd Nov (dbf5f18) build of version 2.27 which we 
upgraded to on Thursday, this past week but the issue is still persisting.
I have recreated the category option combination and applied it to the data 
element but the same issue is still persisting. When I do a metadata export 
from the API, the missing categories are not on the list. It is as though DHIS 
does not even create them for whatever reason.
I don't know if anyone can provide some insight on what we could do to fix this 
since upgrading did not help.
It's affecting our roll out plans.
Thank you once again.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


On Tuesday, November 21, 2017, 10:21:58 PM GMT+1, Laura E. Lincks 
 wrote:

You may want to upgrade to the latest build. We had a similar problem with 2.27 
(on a build from August) and we just upgraded this very minute to the latest 
build 37edfc2 (Nov 8, 2017) and the problem appears fixed.

Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132


On Mon, Nov 20, 2017 at 1:13 PM, Ifeanyi Okoye  wrote:

Hello All,We are encountering this issue with the form designer where either 
the data element does not show up in the form designer i.e. after having been 
assigned to a dataset, or some of the category options do not show up.

In this instance I have a data element disaggregated by testing modalities, 
sex, and age (age categories <1,1-4,5-9,10-14,15-19,20-24, 
25-29,30-34,35-39,40-44,45-49, 50+).
The way it is showing up, a number of the age bands are missing in the form 
designer and it is not uniform. E.g. VCT has female 15-19, VCT is missing male 
15-19.
I have run maintenance, generated resource tables, run analytics, removed the 
options from the category combo and put them back again, but still not showing 
up.
We use custom forms a lot and this is not the first time we are encountering 
this, but then, not to this degree.

Can anybody please help with this?
We are running DHIS2 ver 2.27 Build revision: a8283e0 Build date: 2017-09-21 
06:25
Thank you.




Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Sunday, November 26, 2017, 9:51:05 AM GMT+1, Lars Helge Øverland 
 wrote:  
 
 For data entry module, you might have to clean your browser cache.
regards,
Lars

On 25 November 2017 at 08:52, Djibril Dione  wrote:

Hi Lars,I did perform Update category option combinations as decrypt on my 
email but there was no change in the name.similarly, I renamed the category 
option "Improve Access to Improve access to clean water" on Sierra Leon demo 
2.27. but no change after performing maintenance.
On Fri, Nov 24, 2017 at 11:28 PM, Lars Helge Øverland  wrote:

Hi there,
try going to data administration app > maintenance > select "Update category 
option combinations"  and click "perform maintenance".
regards,
Lars

On 24 November 2017 at 15:01, Djibril Dione  wrote:

Dear DHIS2 community, We are setting up an aggregated system using Attribute 
option as part of the disaggregation. Some of the category option names were 
not correct and we have renamed them.
Now after updating the category option combination through data 
administration/Maintenance, the old combination name is still appearing on the 
category option combinations on the frontend and at the backend.
we have renamed some attribute option on Sierra Leon Demo 2.27 and still found 
the same issue.
Is there anyone experiencing the same issue.
we are using version 2.27 build:5c148f4
-- 


Kind Regards




Djibril Dione 

Database Specialist



Health Information Systems Program – SA

Cell: +27 71 711 5421

Skype: dione.djibril

Address: 66 Rigel Ave North, Waterkloof Ridge, Pretoria, 0181
Web: www.hisp.org
NPR Reg No: 2003/005786/08


This message and any attachments are subject to a disclaimer publishedat 
http://www.hisp.org/policies.h tml#comms_disclaimer. Please read the disclaimer 
before opening any attachment or taking any otheraction in terms of this 
electronic transmission.  If you cannot access thedisclaimer, kindly send an 
email to disclai...@hisp.org and a copy will be provided to you. Byreplying to 
this e-mail or opening any attachment you agree to be bound by theprovisions of 
the disclaimer.

__ _
Mailing list: https://launchpad.net/~dhis2-u sers
Post to     : dhis2-us...@lists.launchpad.ne t
Unsubscribe : https://launchpad.

Re: [Dhis2-users] how to delete org?

[Markus Bekken]

There is some SQL resources to delete orgunits here:
https://github.com/dhis2/dhis2-utils/tree/master/resources/sql

> 27. nov. 2017 kl. 09.01 skrev Nayeem Al Mifthah :
> 
> You may delete from database after deleting constrains.
> 
> Nayeem Al Mifthah
> Consultant for HSS, Health MIS, M&E
> Email: n.mift...@gmail.com  
> Cell:+8801914030574
> Skype: nayeem.a.m
> 
> On Mon, Nov 27, 2017 at 9:27 AM, 林晓东 mailto:lin...@126.com>> 
> wrote:
> Hi,all，
> 
>I have added some orginaztion and some DE、DS， so ,can't delete org, how 
> can I do it, what's steps should I do?
> 
>  Thanks.
> 
> 
> 
> --
> 此致
>  easy
> 
> 莫愁前路无知己，天下谁人不识君。
> 
> 
>  
> 
> ___
> 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] how to delete org?

[Nayeem Al Mifthah]

You may delete from database after deleting constrains.

*Nayeem Al Mifthah*
*Consultant for HSS, Health MIS, M&E*
Email: n.mift...@gmail.com
Cell:+8801914030574
Skype: nayeem.a.m

On Mon, Nov 27, 2017 at 9:27 AM, 林晓东  wrote:

> Hi,all，
>
>I have added some orginaztion and some DE、DS， so ,can't delete org, how
> can I do it, what's steps should I do?
>
>  Thanks.
>
>
>
> --
> 此致
>  easy
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
>
> ___
> 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