Re: [Dhis2-users] [Dhis2-devs] WHO DQA tool and Zeros not storing in DHIS2

[Jason Pickering]

Hi Gerald,
No, they will not appear unless people re-enter the data. When this setting
is used, what happens on the client side, is that even if people enter a
zero, it will never get transmitted to the server. In most cases, having
zeros simply leads to massive numbers of zeros stored in the database,
which are not important when things get aggregated. Users are often not
consistent about entering zeros, and trying to divine what the user's
intent was, can be exceedingly difficult. This is the reason that the
"Complete" button was implemented. With proper training and messaging, this
can be used to indicate that the report it complete, and that everything
which is blank, should be able to be assumed to be zero. Often people want
to try and use a zero to indicate that a particular service is offered, but
that there were simply no clients for that reporting period. The problem of
course is whether the data entry staff understand this. I am not sure what
the need for zeroes actually is in your case, but you may want to consider
to use the completion information instead, if possible. We have seen
numerous cases were more than 60% of the values stored in a DHIS2 database
are zeros. This leads to slower performance of analytics, as well as
inflation of backup sizes, so I hope if you do change this, to think
carefully about whether you really, really need all those zeros!

Best regards,
Jason


On Thu, Nov 22, 2018 at 5:03 AM gerald thomas  wrote:

> Dear Barnabas,
> Thanks for your help.
> The issue now is that we had been ignoring it all this time. Now, we want
> to consider it again which means we will have to enable them as a batch by
> API method but I am inquiring if the previous missing zeros will appear.
>
> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
> wrote:
>
>> Hello Gerald,
>>
>> Storing of zeros in the DHIS2 is configured during the Data Element
>> Creation stage. There is an option where you need to enable the Data
>> Element to store zero values (see attached screen shot).
>> [image: image.png]
>> Once that is done for all the Data Elements, then the Form will be able
>> to store Zero values.
>> Regards
>>
>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
>> wrote:
>>
>>> Dear all,
>>> We are looking at the WHO tool and there was a concern about the zeros
>>> which are not storing in the PostgreSQL database.
>>> Please is there any solution for these zeros not storing?
>>> Is there another way for the WHO tool to differentiate between an actual
>>> blank space and Zeros?
>>>
>>> Thanks in advance for your contribution.
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>> ___
>>> 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
>>>
>>
>>
>> --
>>
>> Barnabas AKUMBA
>>
>> *Mobile:* +2348036195778
>> *Skype:* barnabas.akumba
>>
>
>
> --
> Regards,
>
> Gerald
> ___
> 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
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Analytics schedule

[Jason Pickering]

Hi Edward,
If you are using later versions of DHIS2  (I think 2.29 and above) you can
schedule analytics to run as you would like with the built in scheduler
app. See the docs.


Many people also use custom cron scripts to trigger analytics via the API.
See the docs here
.

Depending on how much data you have, and the speed of your machine, you
should be able to run analytics much more frequently than once a day. Its
possible to perform "partial" runs, which would only run analytics on data
which is less than a year old for instance, but this too is configurable.

Best regards,
Jason


On Mon, Nov 5, 2018 at 10:39 AM Edward Robinson <
erobin...@projectbalance.com> wrote:

> Is there a way to have analytics run at a time of my choice?  We have two
> DHIS2 servers – a tracker for certain programs (TB, etc.) and an aggregate
> instance that encompasses aggregate data for all national programs.  We
> transfer data daily from certain program indicators on the tracker instance
> to data elements on the aggregate instance but would like all data captured
> that day on the tracker instance to be available on the aggregate instance
> following analytics.  As I understand it, we need to transfer the data
> using the API after analytics runs on the tracker instance, though it will
> only be available on the aggregate instance a day later since analytics
> will have run already when the data is transferred, effectively meaning
> data will be available 2 days later.
>
>
>
> Is there a good approach to solving this?  Some thoughts I’ve had include
> forcing analytics an hour earlier by setting the server time back and then
> forward again in a cron job.  Has anyone tried this?
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Script to disassociate Orgunit with Datavalue

[Jason Pickering]

Just load the script in your database and execute it with

SELECT * FROM delete_site_with_data('tPR9B5xETb');

Regards,
Jason

On Thu, Oct 11, 2018 at 4:08 PM Walusiku Muyunda  wrote:

> Hi Jason,
>
> Please help with syntax for this line:
> EXECUTE 'SELECT organisationunitid from organisationunit where uid =
> 'tPR9B5xETb ||   $1  ||   INTO organisationunitid; Is this where I
> need to specify the uid?
>
> Thanks.
>
> *Walusiku J. Muyunda*
>
>
> *Cell: +260967006614Cell: +260971000614*
> *Cell: +260953063387*
>
> *"We have heaven to win and hell to shun, our lives testify better!"
> <http://wildvoices.blogspot.com/>*
>
>
> On Thu, Oct 11, 2018 at 1:10 PM Walusiku Muyunda 
> wrote:
>
>> Thank you Jason, this will be very helpful. Am using v2.28 and hope the
>> script will run without complaints.
>>
>> Regards.
>>
>>
>> *Walusiku J. Muyunda*
>>
>>
>> *Cell: +260967006614Cell: +260971000614*
>> *Cell: +260953063387*
>>
>> *"We have heaven to win and hell to shun, our lives testify better!"
>> <http://wildvoices.blogspot.com/>*
>>
>>
>> On Thu, Oct 11, 2018 at 12:12 PM Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi there!
>>>
>>> You can have a look here
>>> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql
>>>
>>> which will delete the site and all object associated with it. You should
>>> supply the UID of the orgunit you wish to delete as a paramater to the
>>> Postgresql function.
>>>
>>> You may also need to update the script to suit the version of DHIS2 you
>>> are running.
>>>
>>> As usual, be sure to test this on a development database first!
>>>
>>> Best regards,
>>> Jason
>>>
>>>
>>> On Thu, Oct 11, 2018 at 10:49 AM Walusiku Muyunda 
>>> wrote:
>>>
>>>> Dear All,
>>>>
>>>> Is there there anyone with a script to disassociate an Orgunit from all
>>>> associated programs or data sets so I can be able to delete it from within
>>>> DHIS2?
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>> *Walusiku J. Muyunda*
>>>>
>>>>
>>>> *Cell: +260967006614Cell: +260971000614*
>>>> *Cell: +260953063387*
>>>>
>>>> *"We have heaven to win and hell to shun, our lives testify better!"
>>>> <http://wildvoices.blogspot.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
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049
>>>
>>

-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Script to disassociate Orgunit with Datavalue

[Jason Pickering]

Hi there!

You can have a look here
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql

which will delete the site and all object associated with it. You should
supply the UID of the orgunit you wish to delete as a paramater to the
Postgresql function.

You may also need to update the script to suit the version of DHIS2 you are
running.

As usual, be sure to test this on a development database first!

Best regards,
Jason


On Thu, Oct 11, 2018 at 10:49 AM Walusiku Muyunda 
wrote:

> Dear All,
>
> Is there there anyone with a script to disassociate an Orgunit from all
> associated programs or data sets so I can be able to delete it from within
> DHIS2?
>
> Thank you.
>
>
>
> *Walusiku J. Muyunda*
>
>
> *Cell: +260967006614Cell: +260971000614*
> *Cell: +260953063387*
>
> *"We have heaven to win and hell to shun, our lives testify better!"
> *
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data set with biweekly period type

[Jason Pickering]

Maybe try a later version? This should be available.

[image: image.png]

On Sat, Sep 15, 2018 at 11:16 AM Nada Ghosn  wrote:

> Greetings,
> I am preparing a data set with biweekly period type.
> However, this option is not currently available.
> Will it be possible to find way to have such option?
> If not, how can i proceed?
> Sincerely
> NG
>
> --
> Nada Ghosn, MD
> Head, Epidemiology Surveillance Program (Esumoh)
> Ministry of Public Health
> Beirut, Museum square
> Lebanon
> Tel +961.1.614194
> Fax +961.1.610920
> Email esumoh...@gmail.com, esu...@moph.gov.lb
> Website www.moph.gov.lb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] SQL protected Table Issue

[Jason Pickering]

Hi John and Tuzo,

While that may work, there are problems with that approach since during
upgrades, that table may be modified, and if there is a view referencing
it, the upgrade may fail. So, its not a recommended approach.

These tables are "protected" because the API enforces various sharing and
security restrictions and an SQL view could easily expose data which would
otherwise be protected.

Best approach is to use a report table or a direct call to the analytics
API to get what you need.

Best regards,
Jason


On Wed, Sep 12, 2018 at 2:00 PM tuzo engelbert 
wrote:

> Dear john,
> If you have access at the backend(server side) you might need to create
> view of that trackedentityattributevalue like
> create view te_trackedentutyattributevalue as select * from
> trackedentityattributevalue;
>
> And hence use view created in your sql
>
> Thanks
>
>
> On Tue, 11 Sep 2018, 4:54 p.m. ,  wrote:
>
>> Hello everyone,
>>
>>
>>
>> I am having an issue creating a SQL view from the DHIS2 using this query.
>>
>>
>>
>> SELECT DISTINCT public._orgunitstructure.uidlevel4 AS UID4,
>> public._organisationunitgroupsetstructure.organisationunitname AS name4,
>> public._orgunitstructure.uidlevel5 AS UID5, public.organisationunit.name
>> AS orgUnitName, public.organisationunit.hierarchylevel AS orgUnitLevel,
>> public.trackedentityattributevalue.value AS woman,
>> public.trackedentityinstance.uid AS womanuid,
>> public.trackedentityinstance.created AS womancreationdate,
>> public.trackedentityinstance.lastupdated AS womanupdated
>>
>> FROM public.trackedentityattribute
>>
>> INNER JOIN public.trackedentityattributevalue ON
>> (public.trackedentityattribute.trackedentityattributeid =
>> public.trackedentityattributevalue.trackedentityattributeid)
>>
>> INNER JOIN public.trackedentityinstance ON
>> (public.trackedentityattributevalue.trackedentityinstanceid =
>> public.trackedentityinstance.trackedentityinstanceid)
>>
>> INNER JOIN public.organisationunit ON
>> (public.trackedentityinstance.organisationunitid =
>> public.organisationunit.organisationunitid)
>>
>> LEFT JOIN public._orgunitstructure ON public._orgunitstructure.uidlevel5
>> = public.organisationunit.uid
>>
>> LEFT JOIN public._organisationunitgroupsetstructure ON
>> public._organisationunitgroupsetstructure.organisationunitid =
>> public.organisationunit.parentid
>>
>> WHERE public.trackedentityattribute.name = 'Name of Member'
>>
>>
>>
>>
>>
>> Please, any advice on how to go about this.
>>
>>
>>
>> Thanks
>>
>> John
>> ___
>> 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
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] request for dhis2 swahili version

[Jason Pickering]

Hi Alberto,

Please send these requests to the users list Cc'ed here.

There is unfortunately not a complete Swahili translation of DHIS2. Some
translations are available  but they are far from complete.

Best regards,
Jason

On Sun, Aug 26, 2018, 09:33 Alberto Sanga 
wrote:

> Dear Developer,
> Im requesting for the swahili version of dhis 2 . please can you share the
> link with me where i can download it.
>
> thanks
> regard
> Alberto
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] User roles un-assigned some authorities after restarting the server

[Jason Pickering]

Hi Morten,
I have observed something similar but note in Ems report it's impossible to
reproduce on the play server since a reboot is required.

Regards,
Jason

On Thu, Aug 23, 2018, 11:14 Morten Olav Hansen  wrote:

> Hi Em, please try and see if you can reproduce on our play servers
>
> https://play.dhis2.org/2.29/
> https://play.dhis2.org/2.30/
>
> Also adding in Viet, who made some fixes I think might be relevant to
> this..
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> Team Integration Lead
> University of Oslo
> http://www.dhis2.org
>
>
> On Thu, Aug 23, 2018 at 11:02 AM Em Le Hong 
> wrote:
>
>> Hi all,
>>
>> Does anyone notice that DHIS2 2.29 generated some new authorities for
>> user roles like in screenshots below
>> [image: image.png]
>> When we assigned these user roles to a user, it works fine. But these
>> authorities will be un-assigned from user role after we restart the server.
>>
>> Is it a bug or something else? Because we need to restart the server to
>> test, so I can't test on DHIS2 demo server to compare.
>>
>> I created a ticket on Jira for Dev to check if it is the same with Demo
>> https://jira.dhis2.org/browse/DHIS2-4462
>>
>> Sincerely,
>>
>> --
>> *Em Le Hong*
>> DHIS2 Implementation| *HISP Vietnam *
>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>>
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-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] Analytics error

[Jason Pickering]

Hi Ngoni,
>From the error message, you still do not have enough disk space.

Analytics uses a large amount of disk space during regeneration because it
effectively creates a copy of of the analytics tables. These tables can get
very large, so its important to be sure you have enough disk space.

You can get a good estimate of your disk usage using one of the queries
listed here https://wiki.postgresql.org/wiki/Disk_Usage.

In my case, the output looks like this:

dhis2-# LIMIT 20;
   name|  owner   |  size
---+--+-
 training  | postgres | 73 GB

Usually, the analytics tables occupies a large part of the disk space, so I
generally would want to be sure I have at least 150 GB free disk space
before I attempt to do a full run  of analytics.

The simplest way to solve this problem is just to ensure you have enough
disk space, but if that is not an option you can

1) Drop all analytics tables prior to a full regeneration.
2) Perform a partial analytics regeneration (like the last two years) and
see if that works.

Best regards,
Jason



On Mon, Aug 6, 2018 at 10:57 AM Ngoni Manika  wrote:

> Greeting team
>
>
>
> I am trying to run analytics but I get the following error.
>
>
>
>
>
> org.postgresql.util.PSQLException: ERROR: could not extend file
> "base/28039/3075745": wrote only 4096 of 8192 bytes at block 472 Hint:
> Check free disk space.
>
>
>
> I have cleared some log files and the server has space, but I am still
> getting the error.
>
>
>
> Could you please assist
>
>
>
> Regards
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] How to apply disaggregation to indicators

[Jason Pickering]

Hi there.

I was able to create a reproducible example on the play server. If you look
quickly, you should be able to see  this favorite.

https://play.dhis2.org/2.30/dhis-web-pivot/?id=YNj2tzobrnB

which looks like this:
[image: image.png]

Here were the steps:

I defined an indicator for number of data elements:
Numerator: ART enrollment stage 1 + ART enrollment stage 2 + ART enrollment
stage 3 + ART enrollment stage 4
Denominator : 1
Indicator type: Number

2) Create a pivot with this indicator and add the "Implementing Partner"
category option groups.

You can also use the "Funding agency" groups as well.

I am 100% this feature works, as it is used quite frequently in the PEPFAR
instance of DHIS2.

I suspect something is not configured properly with  your category option
group set.

Give a try however on play.dhis2.org and it should work!

Best regards,
Jason



On Thu, Jul 26, 2018 at 2:42 PM Olaleke Seweje 
wrote:

> Hi all,
>
> Please let me put my steps here again for all to see.
>
> I created data elements and applied categories. Entered data for all the
> elements.
>
> I created indicators by dividing all the data elements by another data
> element. (I believe the categorization is lost at this point).
>
> I created a category option group and with the same options used for the
> data elements. I then created category option group set containing the
> option group. In the option group and in the option group set, I selected
> data dimension and data dimension type Disaggregation.
>
> On visualizer app, i selected the indicators, the applicable period and
> location, this gives me data. But when i applied the dimensions of the
> category option group set, no error is displayed but no data to display. I
> have attached the final chart and my layout arrangements.
>
> By my understanding, this is expected since there was no connection
> between the indicators and category option group set. The question is have
> I set things up correctly? if not what did i miss or do wrongly pls?
>
>
> On Thu, Jul 26, 2018 at 12:42 PM Olaleke Seweje 
> wrote:
>
>> Yes, I believe. I went to reports->analytics and exported.
>> Is that what you mean by refresh?
>>
>>
>> On Thu, Jul 26, 2018 at 11:45 AM Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Did you do a full refresh of analytics after creating the group set and
>>> before using the data visualizer?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Thu, Jul 26, 2018 at 12:34 PM Olaleke Seweje 
>>> wrote:
>>>
>>>> Hello Jason,
>>>> Thanks for your response but I tried your suggestion to no avail. Let
>>>> me explain my steps in case there is something i did wrong.
>>>>
>>>> I created data elements and applied categories. Entered data for all
>>>> the elements.
>>>>
>>>> I created indicators by dividing all the data elements by another data
>>>> element. (I believe the categorization is lost at this point).
>>>>
>>>> I created a category option group and with the same options used for
>>>> the data elements. I then created category option group set containing the
>>>> option group. In the option group and in the option group set, I selected
>>>> data dimension and data dimension type Disaggregation.
>>>>
>>>> On visualizer app, i selected the indicators, the applicable period and
>>>> location, this gives me data. But when i applied the dimensions of the
>>>> category option group set, no error is displayed but no data to display. I
>>>> have attache the final chart and my layout arrangements.
>>>>
>>>> By my understanding, this is expected since there was no connection
>>>> between the indicators and category option group set. The question is have
>>>> I set things up correctly? if not what did i miss or do wrongly pls?
>>>>
>>>> Thanks.
>>>>
>>>>
>>>> On Thu, Jul 26, 2018 at 9:14 AM Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> Hi Peter,
>>>>>
>>>>> I may need to clarify my comment a bit. It will work with category
>>>>> option group sets, *but not categories*. That seems like the feature
>>>>> which is not supported.
>>>>>
>>>>> Try and create a category option group set which mirrors the category,
>>>>> and which is also a dimension It should work after rebuilding analytics.
>>>>>
>>>&g

Re: [Dhis2-users] How to apply disaggregation to indicators

[Jason Pickering]

Did you do a full refresh of analytics after creating the group set and
before using the data visualizer?

Regards,
Jason


On Thu, Jul 26, 2018 at 12:34 PM Olaleke Seweje 
wrote:

> Hello Jason,
> Thanks for your response but I tried your suggestion to no avail. Let me
> explain my steps in case there is something i did wrong.
>
> I created data elements and applied categories. Entered data for all the
> elements.
>
> I created indicators by dividing all the data elements by another data
> element. (I believe the categorization is lost at this point).
>
> I created a category option group and with the same options used for the
> data elements. I then created category option group set containing the
> option group. In the option group and in the option group set, I selected
> data dimension and data dimension type Disaggregation.
>
> On visualizer app, i selected the indicators, the applicable period and
> location, this gives me data. But when i applied the dimensions of the
> category option group set, no error is displayed but no data to display. I
> have attache the final chart and my layout arrangements.
>
> By my understanding, this is expected since there was no connection
> between the indicators and category option group set. The question is have
> I set things up correctly? if not what did i miss or do wrongly pls?
>
> Thanks.
>
>
> On Thu, Jul 26, 2018 at 9:14 AM Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Peter,
>>
>> I may need to clarify my comment a bit. It will work with category option
>> group sets, *but not categories*. That seems like the feature which is
>> not supported.
>>
>> Try and create a category option group set which mirrors the category,
>> and which is also a dimension It should work after rebuilding analytics.
>>
>> See below for a trivial example from the PEPFAR system, which seems quite
>> similar to what you are looking at.
>>
>> [image: Selection_999(567).png]
>> ​
>>
>> In  this case, HTS_TST is defined from data elements which have positive
>> and negative category options as part of a category. How
>> ever a category option group set is used (instead of the category).
>>
>> Regards,
>> Jason
>>
>>
>> On Jul 26, 2018 10:06, "Peter D Lubambi"  wrote:
>>
>> Hi Jason,
>> Thanks for this info, which version works? Or you mean it will work in
>> the coming versions?
>> I am currently using ver 2.29, and gives me conflict error - or i am
>> missing something on defining the indicator?
>> [image: image.png]
>>
>> Regards,
>> Peter Dotto Lubambi,
>> Skype: plubambi
>> Mobile: +255 786 087 087
>>
>>
>> On Thu, Jul 26, 2018 at 10:42 AM Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Peter and Olaleke,
>>>
>>> While this feature is not documented anywhere, it will work for
>>> indicators. Any applicable dimension (including categories and category
>>> option group sets) can be used with indicators in the pivots, when the
>>> indicator contains one of those dimensions.
>>>
>>> Not exactly sure how this would work with validation rules, but would be
>>> it would be good to hear your use case for this.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> On Thu, Jul 26, 2018 at 9:33 AM Peter D Lubambi 
>>> wrote:
>>>
>>>> Hi Seweje,
>>>> I think this is currently not supported, but it a feature that I have
>>>> been looking (probably week we need to vote for it in Jira).  Also, similar
>>>> thing with validation rules - Once you have created a validation rule for
>>>> the total data element to make it apply to their category options (for data
>>>> elements with the same category options).
>>>> Regards,
>>>>
>>>> Peter Dotto Lubambi,
>>>> Skype: plubambi
>>>> Mobile: +255 786 087 087
>>>>
>>>>
>>>> On Tue, Jul 24, 2018 at 6:16 PM Olaleke Seweje 
>>>> wrote:
>>>>
>>>>> Hi all,
>>>>> Is there a way I can disaggregate indicators to get the chart below?
>>>>> So e.g. for an indicator called Implants Jadelle, there are 4 classes
>>>>> namely In stock, stock out, Providing unknown, do not provide. The classes
>>>>> are shown as different colours on the each bar.
>>>>>
>>>>> For data elements, this is easily done as category options but is
>>>

Re: [Dhis2-users] Indicator - Maximum number of data elements in the expression

[Jason Pickering]

@ Peter: This sounds quite similar to what we have done  in the PEPFAR
system as well, except we have about 1400 data element + category option
combos in one of the bigger indicators. It was not of course possible to
define these through the user interface, but worked fine through the API.

@Jane : Good to hear that it works for you. We'll be sure to include a
regression test for this to be sure this continues to be "supported".

Regards,
Jason



On Thu, Jul 26, 2018 at 10:37 AM Jane Greig 
wrote:

> Hi Jason,
>
> Thanks, your hint solved a problem for us too where we had a large number
> of data elements needing to be included in denominators of indicators – now
> we can make indicators to insert into other indicators. We are working in
> 2.26 and hoping this will not break in the newer versions when we update.
>
> Regards
>
> Jane
>
>
>
> *From:* Dhis2-users  london.msf@lists.launchpad.net> *On Behalf Of *Peter D Lubambi
> *Sent:* 26 July 2018 18:31
> *To:* jason.p.picker...@gmail.com
> *Cc:* dhis2-users ; DHIS 2 developers <
> dhis2-d...@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] Indicator - Maximum number of data elements
> in the expression
>
>
>
> Hi Jason,
>
> My indicator expression consist a total of 220 data elements (1
> Positive*11 age bands *2 Sex*10 Testing points ), Alternative is, since I
> have created POS Male and POS Female so adding these two indicators would
> serve the purpose.
>
> Regards,
>
>
>
> Peter Dotto Lubambi,
>
> Skype: plubambi
> Mobile: +255 786 087 087
>
>
>
>
>
> On Tue, Jul 17, 2018 at 1:57 PM Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
> Hi Peter,
>
>
>
> I believe the limit to the number of expressions which are included in an
> indicator is that of the underlying database field which stores the
> expression, which should be very large. I think in practice, you may reach
> a limit where the indicator may be too complex to calculate quickly enough.
> We have created indicators with many hundreds of data elements, and while
> they do work, it can be a bit slow.
>
>
>
> You may also encounter a limit in the user interface when defining the
> indicators, but if you are creating one with many dozens or hundreds of
> expression elements, you are probably not going to want to use the UI
> anyway, and would script the creation of the indicator.
>
>
>
> While not supported through the user interface, adding together indicators
> will work it seems.
>
>
>
> Would be interested to hear what your experience is if you create a
> "large" indicator, or one which consists of multiple indicator components.
>
>
>
> Best regards,
>
> Jason
>
>
>
>
>
> On Tue, Jul 17, 2018 at 11:11 AM Peter D Lubambi 
> wrote:
>
> Dear All,
>
> Is there a maximum number of data elements to be included in the
> Numerator/Denominator expression?
>
> If so, is it possible to include another indicator in the indicator
> calculation expression?
>
>
>
> Regards,
>
> Peter Dotto Lubambi,
>
> Skype: plubambi
> Mobile: +255 786 087 087
>
> ___
> 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 <+46764147049>
>
>

-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Indicator - Maximum number of data elements in the expression

[Jason Pickering]

Hi Peter,

I believe the limit to the number of expressions which are included in an
indicator is that of the underlying database field which stores the
expression, which should be very large. I think in practice, you may reach
a limit where the indicator may be too complex to calculate quickly enough.
We have created indicators with many hundreds of data elements, and while
they do work, it can be a bit slow.

You may also encounter a limit in the user interface when defining the
indicators, but if you are creating one with many dozens or hundreds of
expression elements, you are probably not going to want to use the UI
anyway, and would script the creation of the indicator.

While not supported through the user interface, adding together indicators
will work it seems.

Would be interested to hear what your experience is if you create a "large"
indicator, or one which consists of multiple indicator components.

Best regards,
Jason


On Tue, Jul 17, 2018 at 11:11 AM Peter D Lubambi  wrote:

> Dear All,
> Is there a maximum number of data elements to be included in the
> Numerator/Denominator expression?
> If so, is it possible to include another indicator in the indicator
> calculation expression?
>
> Regards,
> Peter Dotto Lubambi,
> Skype: plubambi
> Mobile: +255 786 087 087
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] User manuals translation?

[Jason Pickering]

Hi Martin,
Unfortunately, that version of the manual is extremely out of date and
incomplete. It has not been updated in a number of years.

The translation process is currently a community driven one, with limited
support from the core team. The core team maintains a translation server (
https://translate.dhis2.org) for the software.

Community contributions would certainly be welcome and if there are
specific questions about how to get started, please let me know.

Regards,
Jason


On Wed, Jun 13, 2018 at 7:53 AM Martin Van Aken 
wrote:

> Hi,
> Some of our users are French speaking, and while I know the interface is
> translated, are some of the doc (user or even implementer manual) available
> in French somewhere?
>
> I though not then found a GitHub repo here:
> https://github.com/dhis2/dhis2-docs-fr but I'm unsure about the status
> (one year old is not that bad if needed).
>
> Is there a goal to drive such an effort, possibly community driven?
>
> Martin
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Event report is showing data after deleting all events also

[Jason Pickering]

Do you have any server caching active?

Were you able to reproduce this in incognito mode?

Regards,
Jason


On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati <
rajes...@thoughtworks.com> wrote:

> Hi Markus,
>
> Do you think it is an issue in DHIS?
>
> On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati <
> rajes...@thoughtworks.com> wrote:
>
>> Hi Markus,
>>
>> We have tried alternative i.e created a case in 2016 and ran analytics.
>> Now in Event Reports we are able to see 1 case under 2016. We will try the
>> first option also and let you know the result soon.
>>
>> On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati <
>> rajes...@thoughtworks.com> wrote:
>>
>>> Hi Markus,
>>>
>>> We are using DHIS 2.27. We will perform the action items what ever you
>>> mentioned and will update you soon.
>>>
>>> On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken 
>>> wrote:
>>>
 Hey there,
 which version are you using? This seems to be a bug. Can you try and
 delete the analytics tables called analytics_event_*, then run analytics
 again? Alternatively, try to add one event for 2016, run analytics again
 and see if the number of events in the event report goes down from 149 to 
 1.

 Best regards
 Markus

 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati <
 rajes...@thoughtworks.com>:

 Hi DHIS Team,

 We have deleted all events for specific orgunit, ran analytics and
 cleared browser cache. Observed that there is no data in Event Capture app.

 

 But still we are seeing numbers in Event Reports app as below

 


 We have observed the same for other Orgunits also. Could you please let
 us know why event report still showing numbers.

 --
 Rajeswari Gottipati
 Sr Consultant
 Email rajes...@thoughtworks.com
 Telephone +91 9949292931 <+91%209949292931>
 [image: ThoughtWorks]
 
 ___
 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



>>>
>>>
>>> --
>>> Rajeswari Gottipati
>>> Sr Consultant
>>> Email rajes...@thoughtworks.com
>>> Telephone +91 9949292931 <+91%209949292931>
>>> [image: ThoughtWorks]
>>> 
>>>
>>
>>
>>
>> --
>> Rajeswari Gottipati
>> Sr Consultant
>> Email rajes...@thoughtworks.com
>> Telephone +91 9949292931 <+91%209949292931>
>> [image: ThoughtWorks]
>> 
>>
>
>
>
> --
> Rajeswari Gottipati
> Sr Consultant
> Email rajes...@thoughtworks.com
> Telephone +91 9949292931 <+91%209949292931>
> [image: ThoughtWorks]
> 
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] How to perform logical operations in indicator calculations

[Jason Pickering]

Hi  Leke,

This is currently not possible with aggregate data. You can have a look at
this app (https://play.dhis2.org/appstore/app/dXX2Fk6jwCX) which may help
you to implement this.

You may also want to have a look at the documentation on analytics hooks,
which may help you to implement these types of indicators with custom
scripts.

https://docs.dhis2.org/master/en/developer/html/webapi_analytics_table_hooks.html

Best regards,
Jason


On Tue, May 22, 2018 at 4:14 PM, Olaleke Seweje 
wrote:

> Hello all,
> Please I am looking for a way to perform logical operations in DHIS.
> I have an indicator calculation that has a denominator specified as
>
> org unit counts that belong to a group (e.g. Group 1) AND have reported in
> the past month.
>
> Any ideas on how I can set this up in DHIS will be appreciated.
>
> Thanks
>
>
> --
> Regards,
> Leke Seweje
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] how to define multi-select checkbox in tracker app?

[Jason Pickering]

Hi Easy,

This has been a much requested feature, but its currently not possible. I
would suggest that you define all of your options as boolean/true false
data elements, and then use a custom HTML form to implement the
multi-select box.

Best regards,
Jason



On Wed, May 23, 2018 at 1:23 AM, 林晓东  wrote:

> Hi, all,
>Is there some way to define a element input mode as multi-select
> checkbox?
>only found option for defining input as radio button.
>
>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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Single Data Set with different data elements possible?

[Jason Pickering]

Hi Sele,

There will be NO value, not a null value. I am not sure the distinction is
important, but there should not be a value in analytics at all if no data
has been transmitted.

Regards,
Jason


On Fri, May 11, 2018 at 7:03 AM, Olaleke Seweje <sewejeolal...@gmail.com>
wrote:

> okay, i was looking at that option but won't that create null values for
> the hidden data elements?
> So if i have Elements 1 and 2 filled and hide Element 3, my understanding
> is that there will be a null value for Element 3 in the DB and analysis
> tools like Pivot table.
> Is that correct?
>
> On Fri, May 11, 2018 at 11:55 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Leke,
>>
>> There is no native functionality in the aggregate data entry modules to
>> do this. You would need to implement this with JavaScript in your custom
>> form.
>>
>> Best regards,
>> Jason
>>
>>
>> On Fri, May 11, 2018 at 6:49 AM, Olaleke Seweje <sewejeolal...@gmail.com>
>> wrote:
>>
>>> Dear community,
>>> Is it possible to have a data set with different data elements per usage
>>> scenario? So for example,
>>>
>>> Data elements
>>> Element 1
>>> Element 2
>>> Element 3
>>>
>>> Category
>>> Cat 1
>>> Cat 2
>>>
>>> Data Set
>>> Elements out of stock
>>>
>>> In the above, is is possible to have the data set form show Element 1
>>> and 2 when Cat 1 is selected and show only Element 3 when Cat 2 is selected?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Leke Seweje
>>>
>>> ___
>>> 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
>>
>
>
>
> --
> Regards,
> Leke Seweje
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Single Data Set with different data elements possible?

[Jason Pickering]

Hi Leke,

There is no native functionality in the aggregate data entry modules to do
this. You would need to implement this with JavaScript in your custom form.

Best regards,
Jason


On Fri, May 11, 2018 at 6:49 AM, Olaleke Seweje 
wrote:

> Dear community,
> Is it possible to have a data set with different data elements per usage
> scenario? So for example,
>
> Data elements
> Element 1
> Element 2
> Element 3
>
> Category
> Cat 1
> Cat 2
>
> Data Set
> Elements out of stock
>
> In the above, is is possible to have the data set form show Element 1 and
> 2 when Cat 1 is selected and show only Element 3 when Cat 2 is selected?
>
>
>
>
>
>
>
> --
> Regards,
> Leke Seweje
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Uploading translations of existing indicators

[Jason Pickering]

Hi Himanshu,

There is no way to do this automatically in the system currently. I think
you would need to develop your own script for this purpose using the
translations API as described in the user manual.

https://docs.dhis2.org/master/en/developer/html/webapi_browsing_the_web_api.html#webapi_translation

Best regards,
Jason Pickering



On Fri, May 4, 2018 at 11:00 AM, Himanshu Ardawatia <
himanshu.ardawa...@nrc.no> wrote:

> Hi DHIS2 Users,
>
>
>
> We uploaded several indicators in our system. Now we need to add
> translations of the indicator names, descriptions and few other properties.
> Codes, UIDs, formulas remain the same. Is there a way to do so in bulk from
> our excel file?
>
>
>
> Thanks,
>
> Himanshu
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] dhis2 Report not shown version 2.25

[Jason Pickering]

Hi Shams Shah,

Have a look here https://docs.dhis2.org/2.23/en/user/html/ch33.html and be
sure you have run analytics first.

Regards,
Jason


On Thu, May 3, 2018 at 9:51 AM, Shams-ur-Rehman 
wrote:

> Hi,
>
> After data entry in dhis2 verson 2.25 un able to view the report from
> report menu.
>
>
>
> Regards
>
> Shams Shah
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Can't delete some data elements

[Jason Pickering]

Hi Aljosa,

Based on the message you are seeing and as was pointed out before, you have
data which is associated with the data element. The system will thus not
allow you to delete the data element, when there is still data associated
with the data element. You could delete the data manually (if you have a
small amount) but if you need to delete large amounts of data, this may not
be practical.

If you have access to the database, you can execute an SQL command like

DELETE FROM datavalue where dataelementid = (SELECT dataelementid from
dataelement where uid = '');
DELETE FROM datavalueaudit where dataelementid = (SELECT dataelementid from
dataelement where uid = '');

where  is the UID of the data element you wish to delete.

Please be aware that this will permanently remove the data from the
database, so be sure you have a backup copy first before you perform this
operation.

Regards,
Jason

P.S. You can search the mail archives here
https://www.mail-archive.com/dhis2-devs@lists.launchpad.net/

On Wed, Apr 25, 2018 at 12:24 PM, Isaiah Nyabuto 
wrote:

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


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] How do I deal with 502 Bad gateway?

[Jason Pickering]

This usually indicates that your DHIS2 Tomcat instance is dead and needs to
be restarted.

Best regards,
Jason

On Thu, Apr 19, 2018 at 11:24 AM, Isaiah Nyabuto 
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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS sample Sierra Leone data not being fully imported from PostgreSQL into DHIS

[Jason Pickering]

Hi Ryan,
Its described in more detail here in our FAQ.

https://docs.dhis2.org/master/en/user/html/ch34.html

Regards,
Jason


On Wed, Mar 21, 2018 at 3:22 PM, Henning Håkonsen  wrote:

> Hello
>
> The demo database does not include analysed data, hence you need to run
> analytics before you can view the aggregated data in charts and so forth.
>
> Regards,
> Henning Håkonsen
> Developer
>
> On 21 Mar 2018, at 15:19, Ryan Nazareth  wrote:
>
> Dear DHIS community,
>
> I have installed DHIS2 live on a windows desktop. Ive tried installing the
> sample Sierra Leone dataset by restoring in PgAdmin and adapting the dhis
> conf file according to the instructions.  When I open dhis, only the
>  dimensions (indicators, time period, org unit etc) seem to be imported but
> no associated values.  Hence I cannot build any charts.  I was wondering if
> anyone else has faced this problem or if it’s a possible bug or if I have
> missed something out ?
>
> Any help would be greatly appreciated !
>
> Best Wishes
> Ryan
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Web API - Finding organization units assigned to a program

[Jason Pickering]

Hi Edoard,
Try

dev/api/programs/UID?fields=organisationUnits[id,name]

where UID is the UID of your program.

Regards,
Jason

On Wed, Feb 28, 2018 at 10:44 AM, Edouard Lavaud 
wrote:

> Hi there,
>
> Using 2.28 and its web API, I need to find all the organisation units
> which have been assigned a specific tracker program.
>
> Any idea how I could handle that? (I  could loop through all OU and test
> them, but that is not super beautiful, isn't it?)
>
> Thanks!
>
> Edouard
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[Jason Pickering]

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

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

[Jason Pickering]

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

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

[Jason Pickering]

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

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

[Jason Pickering]

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

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

>
> Dear Jason and Dhis2 Community,
>
> I am following your guide on bootstrapping
> 
>  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 
> 

Re: [Dhis2-users] Dataset Custom Forms (CSS & JS)

[Jason Pickering]

Did you have a look at our developer documentation on the use of custom
CSS/JS?

https://docs.dhis2.org/master/en/developer/html/webapi_ui_customization.html

This should also work for inline JS in the form.







On Wed, Feb 7, 2018 at 6:38 AM, Makhate Makhate 
wrote:

> Hi Diao,
>
> Thanks for helping out.
>
> What do you mean when you say "*it maybe possible to use files*" what do
> you mean by files.
>
> The only trick that I could come up with is doing it like this but it
> doesn't quite work:
>
> 
>   /*
>  CSS code here
>   */
> 
>
> 
>
> 
>
> Well, doing it like this, when i hit Preview i can see basic interactivity
> but when i load the actuall dataset, it doesn't work.
>
> Does anyone know exactly where to put JS and CSS code.
>
> Kind regards,
> Makhate,
> ICAP Lesotho
>
> On Tue, Feb 6, 2018 at 5:54 PM, Mamadou Diao Diallo <
> diao_dia...@gn.jsi.com> wrote:
>
>> Hi Makhate,
>>
>> It maybe possible to use files but I used to paste Javascript code in the
>> Source window at the custom form editor, following this link
>> https://docs.dhis2.org/master/en/user/html/database_design.html#d0e36608
>> see the section *30.5.3.1.2. Custom Forms.*
>>
>> Best
>>
>> *Diao*
>>
>> 30.5.3.1.2. Custom Forms
>>
>> On Tue, Feb 6, 2018 at 2:30 PM, Makhate Makhate > > wrote:
>>
>>> ​Hello Communit​y,
>>>
>>> I am customizing the UI form of our datasets here. We need help on where
>>> to put CSS and Javascript files.
>>>
>>> Kind regards,
>>> Makhate Makhate
>>> ICAP, Lesotho
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
>> Health Information Software )*
>>
>>
>> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
>> *Phone : 623909413 | 662256106*
>> *Skype : diawwdiallo*
>> www.jsi.com
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] How to track users activity in Dhis2

[Jason Pickering]

Hi Jean,

If you have the possibility, using Google Analytics is an option. There are
some security considerations you may need to take into account however.

At the moment however, this approach is a bit limited, as many apps do not
use Google Analytics due to this limitation
https://jira.dhis2.org/browse/DHIS2-1436.

If you are able to create an SQL view through the data administration app,
you should be able to get some CSV data back which you could work up in
Excel.

Here is a simple SQL snippet which might help you get started.

SELECT username,eventtype,extract(month from timestamp) as month,count(*)
from datastatisticsevent where age(now(),timestamp) < '6 months'::interval
GROUP BY username,eventtype,extract(month from timestamp)

Note, that usernames can be exposed here, so you should be careful who has
access to this view.

The easiest way is to just use the "Usage analytics app" which will provide
you basically the same data, but not per user.

Hope this helps.

Best regards,
Jason




On Tue, Feb 6, 2018 at 11:35 AM, Antonia - Pro  wrote:

> You can get a file (xml or json - then convert in Excel if you want) with
> the user's metadata using the export - there are also the last login time
> of all users, if this is what you want.
>
> Best
> Antonia
>
>
> 2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi 
> :
>
>> Hi Bernard
>> I cannot use sql query in our instance because I don't have access to the
>> server. And SQL View is  too limited.
>>
>> Best
>>
>>
>> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) <
>> lib@pu-ami.org>:
>>
>>> Hello Jean,
>>>
>>> I am pretty sure you can run a query in the DB to do so, not sure the
>>> graphical interface has this (other than the SQL view to run the queries)
>>>
>>> @Others, please correct me if I am mistaken.
>>>
>>> All the best,
>>>
>>> Bernard
>>>
>>>
>>>
>>> [image: cid:image002.png@01D36F50.572585A0]
>>>
>>> *Bernard Sadaka*
>>>
>>> *Information Management Advisor*
>>>
>>> Première Urgence - Aide Médicale Internationale
>>>
>>> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>>>
>>> Ain el Remmaneh, Beirut, Lebanon
>>>
>>> *E-mail:* lib@pu-ami.org
>>>
>>> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>>>
>>> *Skype:* imapuami
>>>
>>> *Website:* https://www.pu-ami.org
>>>
>>>
>>>
>>>
>>>
>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
>>> pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
>>> *Sent:* Tuesday, February 6, 2018 11:51 AM
>>> *To:* DHIS Users 
>>> *Subject:* [Dhis2-users] How to track users activity in Dhis2
>>>
>>>
>>>
>>> Hello all,
>>>
>>> Is it possible to know what users are doing in the system.?
>>>
>>> If yes what is the procedure
>>>
>>>
>>>
>>> Thank you
>>>
>>>
>>> 
>>>  Virus-free.
>>> www.avast.com
>>> 
>>> <#m_3355446565635688959_m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>
>>
>>
>> ___
>> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Option sets and data elements

[Jason Pickering]

Hi Nada,

This sounds like a "cascading drop down". This is not supported directly in
DHIS2, so you will need to implement your own front-end solution for this.

Regards,
Jason


On Sat, Jan 27, 2018 at 9:49 AM, Nada Ghosn  wrote:

> Good morning,
> Reference is made to tacker/event capture
> Is it possible to have one data element having different option sets based
> on specific criteria?
>
> Example:
> data element_province (text)
> data element_district.
> Based on the value of the data element_province, the data element_district
> will show different option sets.
>
> Sincerely
> NG
>
> --
> Nada Ghosn, MD
> Head, Epidemiology Surveillance Program (Esumoh)
> Ministry of Public Health
> Beirut, Museum square
> Lebanon
> Tel +961.1.614194 <+961%201%20614%20194>
> Fax +961.1.610920 <+961%201%20610%20920>
> Email esumoh...@gmail.com, esu...@moph.gov.lb
> Website www.moph.gov.lb
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Fast/bulk delete of events

[Jason Pickering]

Hi Petar,

You might be able to adapt this script

to
your needs. This script will actually delete the orgunit, but I think the
relevant part you need is here

and
here

.

It sounds like in your case you want to delete the data, but not the
orgunit itself.

You could then wrap this function in a loop, to remove the data in bulk,
going one org unit at a time.

Hope this helps,
Jason




On Wed, Jan 24, 2018 at 11:01 PM, Calle Hedberg 
wrote:

> Hi,
>
> For events without registration, bulk deleting directly in the database is
> easy:
> 1. Delete all relevant data element records in the table
> trackedentitydatavalue (and if relevant trackedentitydatavalueaudit)
> 2. Delete the "case" records in the table programstageinstance
>
> Alex' method using the webAPI is OK for moderate number of records, but
> can be painful for large numbers
>
> Regards
> Calle
>
> On 24 January 2018 at 22:41, Petar Jovanovic  wrote:
>
>> Thanks a lot Alex!
>>
>> Anyhow, it would be a convenient feature for end users to do it through
>> the DHIS2 interface as well.
>>
>> Best,
>> Petar
>>
>> Obtener Outlook para Android 
>>
>>
>>
>>
>> On Wed, Jan 24, 2018 at 9:32 PM +0100, "Alex Tumwesigye" <
>> atumwesi...@gmail.com> wrote:
>>
>> Hi,
>>> The easier way is to use the api/events endpoint and query for events
>>> uids you want to delete. Once you have them, you can send http delete
>>> method via curl or nodejs or python or php,etc and loop through each to
>>> delete them via api/events/uid.
>>>
>>> Alex
>>>
>>> On Wednesday, January 24, 2018, Petar Jovanovic 
>>> wrote:
>>>
 Hi,

 We want to quickly (in groups) delete events related to a specific
 program and/or to a specific org unit (or list of org units). In DHIS2, we
 only managed to go one by one in the event capture app.

 Can anyone recommend us any other convenient and faster way to do this,
 or if you are aware of an app that may help us?

 We have also checked if it is possible to do it through the database,
 but we did not find easy to locate the table where the event data are
 stored and it is safe to delete them without loosing references to other
 objects.


 Thank you!


 Best,
 Petar

 --
 _
 Petar Jovanovic
 Department of Service and Information System Engineering (ESSI)
 Universitat Politècnica de Catalunya, BarcelonaTech
 Barcelona, Spain
 _ http://www.essi.upc.edu/~petar/ ___


 ___
 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

>>>
>>>
>>> --
>>> Alex Tumwesigye
>>>
>>> Technical Advisor - DHIS2 (Consultant),
>>> Ministry of Health/AFENET  | HISP Uganda
>>> Kampala
>>> Uganda
>>> +256 774149 775, + 256 759 800161
>>> Skype ID: talexie
>>>
>>> IT Consultant (Servers, Networks and Security, Health Information
>>> Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>>>
>>>
>>> "I don't want to be anything other than what I have been - one tree hill
>>> "
>>>
>>>
>> ___
>> 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
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Constructing indicators from boolean data elements

[Jason Pickering]

Hi Jennifer,

With aggregate data, Boolean "Yes" values will have the value of "1" in
analytics, while "No" values will have a value of zero.

So, it should just be a matter of creating an indicator like:

Numerator: Your data element
Denominator: 1
Indicator type: Percentage

That should provide the percentage of values which responded "Yes".

Regards,
Jason Pickering




On Tue, Jan 2, 2018 at 1:01 AM, Spratt, Jennifer <spr...@rti.org> wrote:

> Thanks very much, but I am working with a dataset not a program, so how do
> I access the relevant data elements in the program indicators construction
> app?
>
>
>
> *Jennifer E. Spratt, Ph.D.*
>
> Senior Education Research Analyst
>
> International Development Group at RTI International
>
> Email: spr...@rti.org   Skype: j_spratt
>
> Mobile: 443-562-2129  Messages: 410-235-0019
>
>
>
> *From:* Shurajit Dutta [mailto:shurajitdu...@gmail.com]
> *Sent:* Monday, January 01, 2018 6:22 PM
> *To:* Spratt, Jennifer <spr...@rti.org>
> *Cc:* dhis1-users <dhis2-users@lists.launchpad.net>; Preston, Adam <
> apres...@rti.org>; Pavluck, Alexandre <apavl...@rti.org>; Alexander,
> Keely <kalexan...@rti.org>; Kochetkova, Emily <ekochetk...@rti.org>
> *Subject:* Re: [Dhis2-users] Constructing indicators from boolean data
> elements
>
>
>
> Hi Jennifer
>
>
>
> In order to do this you should create two program indicators.
>
>
>
> 1. Count events with the yes responses
>
> 2. Count the total events
>
>
>
> You can then make a combined indicator in the maintenance indicator app
> using these two program indicators.
>
>
>
> To do this choose 'programs' followed by program indicators when you
> select the numerator/denominator
>
>
>
> Nick
>
>
>
>
>
> On Jan 1, 2018 6:16 PM, "Spratt, Jennifer" <spr...@rti.org> wrote:
>
> Hello all, I am trying to create an indicator that is the proportion of
> entities that replied “yes” on a Boolean data element in a dataset. (Number
> replying yes divided by total number responding).
>
>
>
> I have searched high and low in the DHIS2 user’s guide, but find nothing
> to help me construct what should be a pretty basic indicator.
>
>
>
> I have specified the Indicator type as “percentage”, the numerator as
> #{UID}==1 and the denominator as #{UID}>=0,  (replacing “UID” with the
> actual UID of course)  and I KNOW there are both 1s and 0s in the data
> element in question, but the result is always “0”.
>
>
>
> Also, I thought one could use an indicator as the basis for another
> indicator, but am unable to see “indicator” among the choice of items when
> creating numerators and denominators…
>
>
>
> PS, I have also tried +(#{UID}==1)  and #{UID}==”TRUE”  as the numerator,
> but the result is the same… Evidently filters do not work in aggregate
> indicator construction? Or do they?
>
>
>
> Could you enlighten me as to what I may be doing wrong, and ideally, point
> me to the elegant obvious solution?
>
>
>
> Much obliged,
>
>
>
> *Jennifer E. Spratt, Ph.D.*
>
> Senior Education Research Analyst
>
> International Development Group at RTI International
>
> Email: spr...@rti.org   Skype: j_spratt
>
> Mobile: 443-562-2129 <(443)%20562-2129>  Messages: 410-235-0019
> <(410)%20235-0019>
>
>
>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[Jason Pickering]

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

Re: [Dhis2-users] [Dhis2-devs] In DHIS 2.27 Issues with deleting organisation unit

[Jason Pickering]

Hi Joseph
Thanks for sharing the script.

One thing to watch out for is the reordering of components of analytical
objects. You can see this here
<https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql#L64-L71>
in
the script I linked to in the earlier mail. If you delete an organisation
unit from say a chart, without reordering the other organisation units, it
will lead to an error when trying to load that object after the
organisation unit has been deleted.

Regards,
Jason


On Fri, Dec 15, 2017 at 9:39 AM, Joseph Chingalo <profsching...@gmail.com>
wrote:

> Hello Jhansi Reddy Karee and All,
>
> I have work around for this by creating  SQL view  procedure for deleting
> an organisation unit in dhis 2 instance .
>
> Just kindly find attached SQL file with all procedure functions for
> delete an Organisation unit.
>
> *Steps on how to use this*
>
> *Step 1:*
>
> All you need to do edit variable for storage of all backup files as csv in
> case you want to rollback all deleted data.
> Below is variable to changes on line number 6 with path to directory for
> backup of deleted data, for instance on my case is "/tmp/data" but it must
> have readable and writable.
> " temp_dir VARCHAR := '/tmp/data'; "
>
> *Step 2:*
>
> Apply this sql file into your database
>
> *Step 3:*
>
> Create sql view and excute it.
> For instance if zs9X8YYBOnK is uid for organisation unit to be deleted
> then SQL view will be
> SELECT deleteOrganisationUnit('zs9X8YYBOnK');
>
> *Hopes might help you.*
>
>
>
>
> On Fri, Dec 15, 2017 at 10:16 AM, Jhansi Reddy Karee <
> jhans...@thoughtworks.com> wrote:
>
>> Thanks Jason,
>>
>> Since we just have data values for the organisation units (which should
>> be deleted), we are able to remove them after clearing the data associated
>> with them using /api/maintenance/dataPruning/organisationUnits API.
>>
>> Thanks,
>> Jhansi
>>
>> On Fri, Dec 15, 2017 at 11:51 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> It might work for you, but I am not 100% sure if that API endpoint will
>>> clear out everything. As you can  see from the SQL function, orgunits may
>>> also have other dependencies, like pivots, charts, user associations, etc.
>>> The deletion handler for orgunits may refuse to remove it,  if the object
>>> is associated with other objects.
>>>
>>> It might work in your case, but may not.
>>>
>>> Good luck,
>>> Jason
>>>
>>>
>>> On Fri, Dec 15, 2017 at 7:14 AM, Jhansi Reddy Karee <
>>> jhans...@thoughtworks.com> wrote:
>>>
>>>> Thanks for the quick reply Jason,
>>>>
>>>> In DHIS documentation
>>>> <https://docs.dhis2.org/2.27/en/developer/html/webapi_maintenance.html>,
>>>> we came across a WEB API which can clear all the data of the organisation
>>>> unit.
>>>>
>>>> /api/26/maintenance/dataPruning/organisationUnits/
>>>>
>>>> API Details: Data pruning will remove complete data set registrations,
>>>> data approvals, data value audits and data values, in this case of an
>>>> organisation unit.
>>>>
>>>> We are expecting that this API will clear all the data of the given
>>>> organisation unit and any data/approvals of its parent organisation units
>>>> will be untouched. Is our expectation correct?
>>>>
>>>> Do you see any problem with deleting data for the organisation unit
>>>> using this API.
>>>>
>>>> Thanks,
>>>> Jhansi
>>>>
>>>> On Thu, Dec 14, 2017 at 9:12 PM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> Hi Jhansi,
>>>>> You will also need to get rid of the data in the data value audit
>>>>> table.
>>>>>
>>>>> Here is an SQL function which might work for you.
>>>>>
>>>>> https://github.com/dhis2/dhis2-utils/blob/master/resources/s
>>>>> ql/delete_orgunit_with_data.sql
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>> On Thu, Dec 14, 2017 at 2:49 PM, Jhansi Reddy Karee <
>>>>> jhans...@thoughtworks.com> wrote:
>>>>>
>>>>>> Hello Team,
>>>>>>
>>>>>>
>>>>>> In DHIS 2.27, we are not able to delete an organisation

Re: [Dhis2-users] [Dhis2-devs] In DHIS 2.27 Issues with deleting organisation unit

[Jason Pickering]

It might work for you, but I am not 100% sure if that API endpoint will
clear out everything. As you can  see from the SQL function, orgunits may
also have other dependencies, like pivots, charts, user associations, etc.
The deletion handler for orgunits may refuse to remove it,  if the object
is associated with other objects.

It might work in your case, but may not.

Good luck,
Jason


On Fri, Dec 15, 2017 at 7:14 AM, Jhansi Reddy Karee <
jhans...@thoughtworks.com> wrote:

> Thanks for the quick reply Jason,
>
> In DHIS documentation
> <https://docs.dhis2.org/2.27/en/developer/html/webapi_maintenance.html>,
> we came across a WEB API which can clear all the data of the organisation
> unit.
>
> /api/26/maintenance/dataPruning/organisationUnits/
>
> API Details: Data pruning will remove complete data set registrations,
> data approvals, data value audits and data values, in this case of an
> organisation unit.
>
> We are expecting that this API will clear all the data of the given
> organisation unit and any data/approvals of its parent organisation units
> will be untouched. Is our expectation correct?
>
> Do you see any problem with deleting data for the organisation unit using
> this API.
>
> Thanks,
> Jhansi
>
> On Thu, Dec 14, 2017 at 9:12 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Jhansi,
>> You will also need to get rid of the data in the data value audit table.
>>
>> Here is an SQL function which might work for you.
>>
>> https://github.com/dhis2/dhis2-utils/blob/master/resources/
>> sql/delete_orgunit_with_data.sql
>>
>> Regards,
>> Jason
>>
>>
>> On Thu, Dec 14, 2017 at 2:49 PM, Jhansi Reddy Karee <
>> jhans...@thoughtworks.com> wrote:
>>
>>> Hello Team,
>>>
>>>
>>> In DHIS 2.27, we are not able to delete an organisation unit after
>>> deleting all the data associated to it.
>>>
>>>
>>> Following are the steps we have followed to do this:
>>>
>>>-
>>>
>>>Delete all the data associated to the organisation unit
>>>-
>>>
>>>In Data administration app, under maintenance, we have performed
>>>maintenance over “Permanently remove soft deleted data values”.
>>>-
>>>
>>>Tried deleting the organisation unit. But, we are getting the
>>>following error: Could not delete due to association with another object:
>>>DataValueAudit
>>>
>>>
>>> Please let us know if we have missed anything.
>>>
>>>
>>> Thanks,
>>>
>>> Jhansi
>>>
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <076-414%2070%2049>
>>
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] In DHIS 2.27 Issues with deleting organisation unit

[Jason Pickering]

Hi Jhansi,
You will also need to get rid of the data in the data value audit table.

Here is an SQL function which might work for you.

https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql

Regards,
Jason


On Thu, Dec 14, 2017 at 2:49 PM, Jhansi Reddy Karee <
jhans...@thoughtworks.com> wrote:

> Hello Team,
>
>
> In DHIS 2.27, we are not able to delete an organisation unit after
> deleting all the data associated to it.
>
>
> Following are the steps we have followed to do this:
>
>-
>
>Delete all the data associated to the organisation unit
>-
>
>In Data administration app, under maintenance, we have performed
>maintenance over “Permanently remove soft deleted data values”.
>-
>
>Tried deleting the organisation unit. But, we are getting the
>following error: Could not delete due to association with another object:
>DataValueAudit
>
>
> Please let us know if we have missed anything.
>
>
> Thanks,
>
> Jhansi
>
>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Pruning the OU hierarchy

[Jason Pickering]

Try this

https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunittree_with_data.sql

which will prune an entire branch of the orgunit tree.

Regards,
Jason


On Tue, Dec 5, 2017 at 9:07 AM, Knut Staring  wrote:

> Hi everyone,
>
> Are there some easy ways of pruning an OrgUnit tree?
>
> Basically, I have a number of countries with varying numbers of
> subnational levels, but am only interested in one of the countries. I guess
> in previous DHIS2 versions I could have done a detailed metadata export.
> What would be a quick way to prune now?
>
> Knut
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Excel data connection options

[Jason Pickering]

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

Re: [Dhis2-users] [Dhis2-devs] Reset DataSet completeness to zero - DHIS2 2.25

[Jason Pickering]

If you have access to the backend database, you can just do something like

DELETE FROM completedatasetregistration WHERE ... (put your conditions
here);

using one of these paramaters

 datasetid  | integer | not null
 periodid   | integer | not null
 sourceid   | integer | not null
 attributeoptioncomboid | integer | not null


Otherwise, use the API for this as described here:

https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_registrations.html#webapi_uncompleting_data_sets

Regards,
Jason


On Wed, Nov 22, 2017 at 8:49 AM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear DHIS2 community,
>
> I would like to ask if there is a way to reset report completeness to 0
> (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API?
> We know the Orgunit uid, period and DataSet uid to reset.
>
> Thank you already for your suggestions!
>
> Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Complete DataSet Registration

[Jason Pickering]

This seems to work fine. I just copied the request from the data entry form
on the demo site as a curl command and modified it slightly. There are
other ways to do this as well as mentioned in the docs.  Otherwise, you
should provide the exact request you are making, the exact payload, and the
exact response from the server.

curl 'https://play.dhis2.org/demo/api/25/completeDataSetRegistrations'  \
-u admin:district \
-H 'Accept-Encoding: gzip, deflate, br' \
-H 'Content-Type: application/x-www-form-urlencoded; charset=UTF-8' \
-H 'Accept: application/json, text/javascript, */*; q=0.01' \
-H 'Connection: keep-alive' -H 'DNT: 1' \
--data 'ds=pBOMPrpg1QX=201712=ImspTQPwCqd=false' \
--compressed -v


On Wed, Nov 22, 2017 at 9:16 AM, <rab...@pace-tech.com> wrote:

> Hi Jason,
>  yeah, i have already read the documentation and i've tried it as well but
> still its not working. I don't know what the issue is. Kindly guide me.
> Thank You.
>
> Regards: Rabbia Naz Ali
>
>
> On 2017-11-22 12:51, Jason Pickering wrote:
>
>> Hi Rabia,
>>
>> Did you have chance to read our documentation about completing data
>> sets?
>>
>> https://docs.dhis2.org/master/en/developer/html/webapi_compl
>> ete_data_set_registrations.html#webapi_completing_data_sets
>> [4]
>>
>> Regards,
>> Jason
>>
>> On Wed, Nov 22, 2017 at 8:46 AM, <rab...@pace-tech.com> wrote:
>>
>> Aoa,
>>>
>>> i've inserted some data into database against dataset in dhis2 but
>>> it doesn't marked it as completed in "completedatasetregistration"
>>> this table of Database. I want to ask about how can i do this using
>>> API.
>>> I've tried this one
>>> "$url =
>>> "http://64.50.171.246:8080/api/26/completeDataSetRegistrations [1]
>>> period=201503 dataSet=Ep9cqvuYYKb organisationUnit=AMaQFVRNoaL
>>> storedBy=imported"
>>> but its not working as it shows the status as 'success' but not
>>> marked the data set.
>>>
>>> Your response will be appreciated.
>>> Thank You.
>>>
>>> Regards: Rabia Naz Ali
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users [2]
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users [2]
>>> More help : https://help.launchpad.net/ListHelp [3]
>>>
>>
>> --
>>
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>> Links:
>> --
>> [1] http://64.50.171.246:8080/api/26/completeDataSetRegistrations
>> [2] https://launchpad.net/~dhis2-users
>> [3] https://help.launchpad.net/ListHelp
>> [4]
>> https://docs.dhis2.org/master/en/developer/html/webapi_compl
>> ete_data_set_registrations.html#webapi_completing_data_sets
>>
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Complete DataSet Registration

[Jason Pickering]

Hi Rabia,

Did you have chance to read our documentation about completing data sets?

https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_registrations.html#webapi_completing_data_sets

Regards,
Jason


On Wed, Nov 22, 2017 at 8:46 AM,  wrote:

> Aoa,
>
> i've inserted some data into database against dataset in dhis2 but it
> doesn't marked it as completed in "completedatasetregistration" this table
> of Database. I want to ask about how can i do this using API.
> I've tried this one
>"$url = "http://64.50.171.246:8080/api
> /26/completeDataSetRegistrations period=201503 dataSet=Ep9cqvuYYKb
> organisationUnit=AMaQFVRNoaL storedBy=imported"
> but its not working as it shows the status as 'success' but not marked the
> data set.
>
> Your response will be appreciated.
> Thank You.
>
> Regards: Rabia Naz Ali
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Browser Cache cleaner Problem

[Jason Pickering]

Hi Diksha,
I think we have fixed this problem. You will need to update your version of
DHIS2. Give our continuous integration server about 45 minutes to build a
new version, and then the problem should be fixed. If not, please let us
know.

Regards,
Jason


On Thu, Nov 16, 2017 at 9:17 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Diksha,
>
> Thanks for the report. We have been doing some work on that app recently,
> and I see there is a problem. We will fix it quickly and let you know.
>
> Regards,
> Jason
>
>
> On Thu, Nov 16, 2017 at 9:16 AM, diksha insa <dikshains...@gmail.com>
> wrote:
>
>> Hi All
>>
>>
>> I am using the following version of dhis2
>> Version:2.27Build revision:1f91196Build date:2017-11-16 06:42
>> and facing a issue of browser cache cleaner while clicking on browser
>> cache cleaner some syntax text is displayed. Attached is the screenshot
>> of the issue
>> Thanks & RegardsDiksha
>>
>> On Thu, Nov 16, 2017 at 1:39 PM, diksha insa <dikshains...@gmail.com>
>> wrote:
>>
>>> Hi All,
>>>
>>>
>>>
>>>
>>
>> ___
>> 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 <076-414%2070%2049>
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Browser Cache cleaner Problem

[Jason Pickering]

Hi Diksha,

Thanks for the report. We have been doing some work on that app recently,
and I see there is a problem. We will fix it quickly and let you know.

Regards,
Jason


On Thu, Nov 16, 2017 at 9:16 AM, diksha insa  wrote:

> Hi All
>
>
> I am using the following version of dhis2
> Version:2.27Build revision:1f91196Build date:2017-11-16 06:42
> and facing a issue of browser cache cleaner while clicking on browser
> cache cleaner some syntax text is displayed. Attached is the screenshot
> of the issue
> Thanks & RegardsDiksha
>
> On Thu, Nov 16, 2017 at 1:39 PM, diksha insa 
> wrote:
>
>> Hi All,
>>
>>
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS2.ORG is down

[Jason Pickering]

If you need to download the DHIS2 software, you can try and get it from

https://ci.dhis2.org

most docs should also be available from

https://docs.dhis2.org

On Mon, Nov 13, 2017 at 3:23 AM, Barnabas Akumba 
wrote:

> Hello All,
>
> I've been trying to download files on the dhis2.org site but encounter
> "502 Bad Gateway".
>
>
> Regards
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778 <+234%20803%20619%205778>
> *Skype:* barnabas.akumba
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Dashboard Not Showing Up

[Jason Pickering]

Hi Kunle,

If you have already entered data, try running analytics.

https://docs.dhis2.org/master/en/user/html/ch32.html

Regards,
Jason


On Wed, Nov 8, 2017 at 1:45 PM, Oladiran, Olakunle Francis <
oolad...@iupui.edu> wrote:

>
> Hello Experts,
>
> I trust  you are well. I am trying to create a dashboard on DHIS2 but the
> charts are not showing. It keeps showing 'No Data to Display'(please see
> the image below).
> My question is what is the minimum datasets required for the charts to
> show up? Please note that I have checked the indicators properly. Kindly
> give me any pointers to fix it.
>
> Thanks,
> Kunle
>
>
>
>
> [image: Inline image 2]
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements

[Jason Pickering]

Yes, it sounds like the same thing.

This has come up many times as a feature request I think and sounds similar
to this

https://jira.dhis2.org/browse/DHIS2-1677

Its currently not possible, but you can have a look at the work from HISP
Tanzania which may make this possible at least in the front-end

https://play.dhis2.org/appstore/app/dXX2Fk6jwCX

Regards,
Jason


On Wed, Nov 1, 2017 at 1:16 PM, GROUT, Lise <gro...@who.int> wrote:

> Hi Rabbia,
>
> Would it be similar to what I asked last week: to be able to have logical
> indicator, like Indicator = sum of DE1 if DE2=yes ?
>
> Best
> Lise
>
> -Original Message-
> From: Dhis2-users [mailto:dhis2-users-bounces+groutl=who.int@lists.
> launchpad.net] On Behalf Of rab...@pace-tech.com
> Sent: 01 November 2017 12:50
> To: Jason Pickering
> Cc: Dhis2 Users
> Subject: Re: [Dhis2-users] Conditional Indicators for Aggregated type Data
> Elements
>
> Hi jason,
>   I'm asking about data element of type "Number" or "integer" .how can we
> get the conditional sum for these type ? when the type is aggregated not
> trackers. Like I've created Data Elements of the type aggregated, created a
> 'data entry form' of these data elements. also the indicators I've created
> for this till now are simple indicators but now i want to create some
> indicator with condition.
> Regards: Rabbia Naz
>
>
> On 2017-11-01 15:45, Jason Pickering wrote:
> > Hi Rabbia,
> > What is not working? Could you be more specific?
> >
> > Data elements of type "True only" should aggregate to 1 when marked as
> > true.
> >
> > Regards,
> > Jason
> >
> > On Tue, Oct 31, 2017 at 2:05 PM, <rab...@pace-tech.com> wrote:
> >
> >> On 2017-10-30 19:28, Jason Pickering wrote:
> >>
> >>> Hi Rabbia,
> >>> Just use the True Only type of data element. It should work.
> >>>
> >>> Regards,
> >>> Jason
> >> Hi Jason,
> >> its not working and if we want the same thing to be done on number
> >> data type or you can say integer. what i need to do then ?
> >>
> >> Regards: Rabbia Naz
> >>
> >> On Oct 30, 2017 08:09, <rab...@pace-tech.com> wrote:
> >>
> >> Aoa,
> >>
> >> I need to ask a question about indicators like i want to sum the
> >> value of numerator on the basis of data element like "sum(case when
> >> devalue=true then 1 else 0 end) as totaltrue". like how can we
> >> calculate the conditional sum for data element whose type is
> >> aggregated not tracker. Kindly explain in detail.
> >> Thank You
> >> Regards: Rabbia Naz
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-users [1] [1] Post to :
> >> dhis2-users@lists.launchpad.net Unsubscribe :
> >> https://launchpad.net/~dhis2-users [1] [1] More help :
> >> https://help.launchpad.net/ListHelp [2] [2]
> >>
> >> Links:
> >> --
> >> [1] https://launchpad.net/~dhis2-users [1] [2]
> >> https://help.launchpad.net/ListHelp [2]
> >
> > --
> >
> > Jason P. Pickering
> > email: jason.p.picker...@gmail.com
> > tel:+46764147049
> >
> > Links:
> > --
> > [1] https://launchpad.net/~dhis2-users
> > [2] 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
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements

[Jason Pickering]

Hi Rabbia,
What is not working? Could you be more specific?

Data elements of type "True only" should aggregate to 1 when marked as
true.

Regards,
Jason




On Tue, Oct 31, 2017 at 2:05 PM, <rab...@pace-tech.com> wrote:

> On 2017-10-30 19:28, Jason Pickering wrote:
>
>> Hi Rabbia,
>> Just use the True Only type of data element. It should work.
>>
>> Regards,
>> Jason
>>
>> Hi Jason,
> its not working and if we want the same thing to be done on number data
> type or you can say integer. what i need to do then ?
>
> Regards: Rabbia Naz
>
> On Oct 30, 2017 08:09, <rab...@pace-tech.com> wrote:
>>
>> Aoa,
>>>
>>> I need to ask a question about indicators like i want to sum the
>>> value of numerator on the basis of data element like "sum(case when
>>> devalue=true then 1 else 0 end) as totaltrue". like how can we
>>> calculate the conditional sum for data element whose type is
>>> aggregated not tracker. Kindly explain in detail.
>>> Thank You
>>> Regards: Rabbia Naz
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users [1]
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users [1]
>>> More help : https://help.launchpad.net/ListHelp [2]
>>>
>>
>>
>> Links:
>> --
>> [1] https://launchpad.net/~dhis2-users
>> [2] https://help.launchpad.net/ListHelp
>>
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements

[Jason Pickering]

Hi Rabbia,
Just use the True Only type of data element. It should work.

Regards,
Jason


On Oct 30, 2017 08:09,  wrote:

>
> Aoa,
>
> I need to ask a question about indicators like i want to sum the value of
> numerator on the basis of data element like "sum(case when devalue=true
> then 1 else 0 end) as totaltrue". like how can we calculate the conditional
> sum for data element whose type is aggregated not tracker. Kindly explain
> in detail.
> Thank You
> Regards: Rabbia Naz
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Populating data from Excel to DHIS2 Data Entry Web Form with Internet Explorer

[Jason Pickering]

You may also want to consider just making the HTTP request, instead of
working with the form itself

https://support.microsoft.com/en-us/help/301102/how-to-make-a-get-request-by-using-visual-basic--net-or-visual-basic-2

The DHIS2 dataValue API is documented in here

in "Section 1.19.7. Sending, reading and deleting individual data values"

Regards,
Jason


On Thu, Oct 26, 2017 at 4:18 PM, Damasceno Lopes 
wrote:

> Hi!
>
>
>
> I’m trying to populate data from Excel to  DHIS2 Data Entry Web Form using
> VBA code in Excel with Internet Explorer, the data goes to form but not
> persisted to database. Anyone already try to do that?
>
>
>
> The VBA code, tested to fill form in the demo instance:
>
>
>
> 'Before run this Macro make sure to login into dhis2-demo using Internet
> Explorer
>
> Sub FillInternetForm()
>
> Dim IE As Object
>
>
>
> Set IE = CreateObject("InternetExplorer.Application")
>
>
>
> IE.Navigate "https://play.dhis2.org/demo/dhis-web-dataentry/index.action;
>
> IE.Visible = True
>
>
>
> While IE.busy
>
> DoEvents 'wait until IE is done loading page.
>
> Wend
>
>
>
> 'You have 30 seconds to choose Orgunit, form and period
>
> 'Eg. Sierra Leone, Emergency Response, Result
>
> Application.Wait Now + TimeValue("00:00:30")
>
>
>
> 'Populating Data to two first fields
>
> IE.document.getElementById("KFnFpbqDqji-bRowv6yZOF2-val").Focus
>
> IE.document.getElementById("KFnFpbqDqji-bRowv6yZOF2-val").Value = "20"
>
> Application.Wait Now + TimeValue("00:00:02")
>
> IE.document.getElementById("zFFb3bar4Ct-bRowv6yZOF2-val").Focus
>
> IE.document.getElementById("zFFb3bar4Ct-bRowv6yZOF2-val").Value = "30"
>
>
>
> End Sub
>
>
>
> The result:
>
>
>
>
>
> The Data goes to the field but not persisted, the field don’t change color.
>
> I appreciate your help if you can provide.
>
>
>
> Thank you
>
> *Damasceno Lopes,  MSc*
>
> *Health Information System Officer*
>
> Friends in Global Health, Mozambique
>
> *+258844626770 <+258%2084%20462%206770>*  | *+258829502145
> *
>
> [image: FGH]
>
>
>
>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Error in Pivot Table after taking SSL certificate

[Jason Pickering]

Hi there.

You need to modify your Tomcat's server.xml file to match this




Be sure to use the correct port number.

Regards,
Jason


On Mon, Oct 9, 2017 at 9:14 AM, Mithilesh Kumar Thakur <
mithilesh.h...@gmail.com> wrote:

> Dear All,
>
> We are facing a issue in pivot and data visulizer after taking a SSL
> certificate(HTTP to HTTPS) for one of our instance. The version of the
> application is 2.23. Can you please look into the below error and suggest
> anything if you have faced same kind of issue.
>
> jquery.min.js:2 Mixed Content: The page at 'https://fpanmis.org/fpanpro/
> dhis-web-pivot/#' was loaded over HTTPS, but requested an insecure
> XMLHttpRequest endpoint 'http://fpanmis.org/fpanpro/
> api/systemSettings.json?key=keyCalendar=keyDateFormat&
> key=keyAnalysisRelativePeriod=keyHideUnapprovedDataInAnalytics=
> keyAnalysisDigitGroupSeparator'. This request has been blocked; the
> content must be served over HTTPS.
>
>
>
> --
>
> Thanks and Regards
>
> Mithilesh Kumar Thakur
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Check how many time reports are generated

[Jason Pickering]

Hi Martin,
You can also use Google Analytics for this task probably or any number of
tools to parse the DHIS2/Nginx logs.

Regards,
Jason


On Wed, Oct 4, 2017 at 4:19 PM, Martin Van Aken 
wrote:

> Thanks! No luck for me right now but interesting nonetheless. I'll have a
> look at the provided examples.
>
> Martin
>
> On Wed, Oct 4, 2017 at 11:04 AM, Lars Helge Øverland 
> wrote:
>
>> Hi Martin,
>>
>> we do have a web API endpoint that supports usage statistics for most
>> analytical entities (pivot table, chart, map..) _except_ for standard
>> reports.
>>
>> https://docs.dhis2.org/master/en/developer/html/webapi_usage
>> _analytics.html
>>
>> If you want to create a patch and extend this to include standard reports
>> (html reports) you can look at the following classes:
>>
>> DataStatistics.java
>> DataStatisticsEventType.java
>> DataStatisticsController.java
>> GetReportAndParamsAction.java
>>
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>> On Wed, Oct 4, 2017 at 9:16 AM, Martin Van Aken 
>> wrote:
>>
>>> Hello DHIS2 community,
>>>
>>> We have a set of custom reports we built for a customer, and I'm
>>> interested to follow which one are used (and how often).
>>>
>>> Is there any way to retrieve how many times a given report has been
>>> generated? I'm talking about HTML reports in this case some something like:
>>>
>>> http://DHIS2_urL/dhis-web-reporting/generateHtmlReport.actio
>>> n?uid=ThScKdiP4Cp=201708=eov2pDYbAK0
>>>
>>> Does DHIS2 stores something about it anywhere?
>>>
>>> Thanks,
>>>
>>> Martin
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken 
>>> Call me on Skype : vanakenm
>>> Hang out with me : mar...@joyouscoding.com
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Sharing settings

[Jason Pickering]

I was seeing this more as a per-user-choice actually, to account for the
experience of the user.

Suppose I  do not want to share anything (and supposedly know what I am
doing), I could enable in my profile "Do not share publicly by default".

Maybe that is the same thing however Lars?

Regards,
Jason




On Thu, Sep 7, 2017 at 5:30 PM, Prosper BT <ptb3...@gmail.com> wrote:

> I vote for also adding sharing in the "Add New" at min Public Vs Private
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
> prospertb
>
> On Thu, Sep 7, 2017 at 6:21 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Right. I think this has two sides to it - for basic metadata like data
>> elements it makes sense to at least allow it to become public when creating
>> an object. Otherwise, inexperienced users might have a hard time
>> understanding that you need to share it before anyone else can see it. A
>> solution to this would be to have a basic sharing UI inside the "add new"
>> object screens, so that for users with "create public" authorities, you can
>> choose whether to make it public or private before creating an object.
>>
>>
>>
>> On Thu, Sep 7, 2017 at 3:31 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Lars,
>>> I think this is the problem however. In certain instances, it would be
>>> better if this permission was granted explicitly. Right now, if you are a
>>> super user, anytime you create a favorite, it is shared publically.
>>>
>>> I think what Lisa is asking for is something we have seen a need for as
>>> well, and that is basically that analytical objects and metadata should NOT
>>> be public by default, but rather granted on a case by case basis as desired
>>> by the user.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Thu, Sep 7, 2017 at 3:25 PM, Lars Helge Øverland <l...@dhis2.org>
>>> wrote:
>>>
>>>> Hi Lise,
>>>>
>>>> you can achieve this by simply not granting "Add/Update Public Chart"
>>>> (and report table, map) to users through user roles. Creating private
>>>> charts/maps is implicitly allowed for anyone.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>> On Thu, Sep 7, 2017 at 2:45 PM, GROUT, Lise <gro...@who.int> wrote:
>>>>
>>>>> Dear all,
>>>>>
>>>>>
>>>>>
>>>>> Is there a way of configuring the instance so that by default all
>>>>> favorites are not public (public acces=none), i.e. by default only the
>>>>> creator of the favorites can see it and then he can chose to share it with
>>>>> user groups?
>>>>>
>>>>>
>>>>>
>>>>> Thanks
>>>>>
>>>>> Lise.
>>>>>
>>>>>
>>>>>
>>>>> Dr. Lise Grout
>>>>>
>>>>> *Epidemiologist*
>>>>>
>>>>>
>>>>>
>>>>> *World Health Organization*
>>>>>
>>>>> *Department of Neglected Tropical Diseases (HTM/NTD/IDM)*
>>>>> *Innovative and Intensified Disease Management Unit*
>>>>> *20, Avenue Appia; CH
>>>>> <https://maps.google.com/?q=20,+Avenue+Appia;+CH=gmail=g>-1211
>>>>> Geneva 27*
>>>>> *Tel. **+41 22 791 2341 <+41%2022%20791%2023%2041>*
>>>>>
>>>>> *Mobile +41 79 290 68 61 <+41%2079%20290%2068%2061>*
>>>>>
>>>>> *Skype: tigrouveto*
>>>>>
>>>>> http://www.who.int/neglected_diseases
>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> 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/>
>>>>
>>>>
>>>> ___
>>>> 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 <+46%2076%20414%2070%2049>
>>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.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
>>
>>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Sharing settings

[Jason Pickering]

Hi Lars,
I think this is the problem however. In certain instances, it would be
better if this permission was granted explicitly. Right now, if you are a
super user, anytime you create a favorite, it is shared publically.

I think what Lisa is asking for is something we have seen a need for as
well, and that is basically that analytical objects and metadata should NOT
be public by default, but rather granted on a case by case basis as desired
by the user.

Regards,
Jason


On Thu, Sep 7, 2017 at 3:25 PM, Lars Helge Øverland  wrote:

> Hi Lise,
>
> you can achieve this by simply not granting "Add/Update Public Chart" (and
> report table, map) to users through user roles. Creating private
> charts/maps is implicitly allowed for anyone.
>
> regards,
>
> Lars
>
> On Thu, Sep 7, 2017 at 2:45 PM, GROUT, Lise  wrote:
>
>> Dear all,
>>
>>
>>
>> Is there a way of configuring the instance so that by default all
>> favorites are not public (public acces=none), i.e. by default only the
>> creator of the favorites can see it and then he can chose to share it with
>> user groups?
>>
>>
>>
>> Thanks
>>
>> Lise.
>>
>>
>>
>> Dr. Lise Grout
>>
>> *Epidemiologist*
>>
>>
>>
>> *World Health Organization*
>>
>> *Department of Neglected Tropical Diseases (HTM/NTD/IDM)*
>> *Innovative and Intensified Disease Management Unit*
>> *20, Avenue Appia; CH-1211 Geneva 27*
>> *Tel. **+41 22 791 2341 <+41%2022%20791%2023%2041>*
>>
>> *Mobile +41 79 290 68 61 <+41%2079%20290%2068%2061>*
>>
>> *Skype: tigrouveto*
>>
>> http://www.who.int/neglected_diseases
>>
>>
>>
>> ___
>> 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 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Setting up an yearly period: Yearly September

[Jason Pickering]

I do not think this is easily achievable without modification of the core
software and apps.

Have a look here https://github.com/dhis2/dhis2-core/blob/master/dhis-2/
dhis-api/src/main/java/org/hisp/dhis/period/FinancialOctoberPeriodType.java

You would need to add a new period type to add the period you want. All
analysis apps would probably also require changes here as well.

Regards,
Jason




On Thu, Sep 7, 2017 at 2:02 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

>
> Dear DHIS2 Community,
>
>
> Is there a way to create a new group for the data agregation period ? In
> DHIS2, there is already the following period option:
>
>
> Financial Oct: Financial year period beginning on October 1st and ending
> on September 30st of the calendar next year.
>
>
> I would like to set up a new one for Yearly September: Year period
> beginning on September 1st and ending on August 31st of the calendar next
> year?
>
>
> Any thoughts would be appreciated!
>
> Best,
>
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] API call to list all data elements within a dataset

[Jason Pickering]

In later versions of DHIS2, it would be something like this I think

https://play.dhis2.org/dev/api/dataSets/lyLU2wR22tC?fields=dataSetElements[dataElement[id,name,description]]

On Thu, Aug 17, 2017 at 2:30 PM, Vladimer Shioshvili 
wrote:

> This should get you started:
>
> api/dataElements?filter=dataSets.id:eq:DATASET_UID
>
>
> On Thu, Aug 17, 2017 at 8:26 AM Shurajit Dutta 
> wrote:
>
>> Hi everyone,
>>
>> Can someone share with me the API call to list all data elements within a
>> dataset, perhaps the uid and name? Though if someone has something already
>> that provides more fields that would also be great.
>>
>> Thanks,
>> Nick
>> ___
>> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Saving favorites with User Orgunit

[Jason Pickering]

Hi Randy,
This is a known issue reported here https://jira.dhis2.org/browse/DHIS2-2021

No known workaround as far as I know at this point.

Regards,
Jason


On Mon, Aug 14, 2017 at 2:57 PM, Wilson, Randy  wrote:

> We've been trying to configure some standard dashboards for users in each
> of the 30 districts but have come to realize that the user orgunit that can
> be saved for the favorite refers to the orgunits that data entry staff are
> assigned for visualization, not the orgunits they are assigned for data
> entry.
>
> This is problematic since we want people to be able to see data across the
> country and compare their performance with other districts so we have
> assigned the data visualization orgunits to level 1 - national.
>
> In our use case it would make more sense to assign the userorgunit for
> data entry as the one that is used for data entry.  Would it be possible to
> change this - or to give us the option of setting user orgunit to one or
> the other?
>
> In the current scenario, I we are going to have to create new analysis
> objects for each of our 30 districts and 42 district hospitals (maps,
> charts, pivot tables) so that they can be filtered for their orgunit
> levels.  I'm trying to script this process in R, but it is a labor of love.
>
> Anyone else have a workaround?
>
> --
> *Randy Wilson*
> *Team Leader: **Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Direct: +250 788308835 <+250%20788%20308%20835>
> E-mail: rwil...@msh.org
> Skype: wilsonrandy_us
> 
> Stronger health systems. Greater health impact.
> 
> 
> 
> www.msh.org
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS 2

[Jason Pickering]

Just assign the user to the district and they will have access to all the
facilities under neath it.

If the dataset they need to enter data into has been assigned to them, and
the user has the data set assigned to their role, it should work just fine.

Regards,
Jason


On Tue, Aug 8, 2017 at 11:26 AM, Omer Butt  wrote:

> Issue I face is that :
> when district User is login: For example Peshawar Is District
> That user have to fill the data entry (FM-2 form ) for all facilities that
> lies in this District. (It May be 10 or 20 or more etc.)
> How Can i Utilize it in DHIS 2 ?
>
>
> On Tue, Aug 8, 2017 at 2:16 PM, Omer Butt  wrote:
>
>> By Default Selection of Organization Unit is through Tree.
>>
>> [image: Inline image 1]
>> Will I change it to Drop Down menu Base Selection.
>> Means on basis of levels.
>> Example :
>>
>>   Level 1  Drop Down (Select Province )
>>   Level 2   Drop Down (Select District)
>>   Level 3  Drop Down (Select Tehsil )
>>   Level 4   Drop Down (Select UC)
>>   Level 5   Drop Down (Select Facility )
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Cannot view data elements when creating left and right side components of a validation rule

[Jason Pickering]

You can see here


That the server is not reachable.
​

On Thu, Aug 3, 2017 at 11:29 AM, Timothy Kiyemba  wrote:

> Dear All,
>
> I am unable to view data elements when creating left and right side
> components of a validation rule. Any one faced this problem? Please
> support. I am using DHIS2 2.26. See screen shot attached.
>
> Timothy Kiyemba
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data not showing on pivot table and data set report

[Jason Pickering]

Have you had a look at our Frequently Asked Questions?

https://docs.dhis2.org/master/en/user/html/ch32.html

Regards,
Jason


On Thu, Aug 3, 2017 at 10:38 AM, gérard Bisama  wrote:

> Hi All,
>
> I have configured a new DHIS2 instance and every thing happens well. We
> have start to do some data entry to test the system and every thing is
> working fine. But when we go in the pivot table module and data set report,
> we are not able to see any data values. I have performed maintenance and
> cleared the cache but nothing happen.
>
> Any suggestion will be helpfull, thank you!
>
> --
> Gérard Bisama
> Tel:+243810890810 <+243%20810%20890%20810>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS 2

[Jason Pickering]

Hi Omer,

I do not think this is going to work at all. What are the data elements in
the second row?  Are these dynamically generated as well?

As noted in a previous mail from one of your queires, this really looks
more like event data than aggregate data. For aggregate data you can only
have a single value for a given organisationunit/period/data
element/category combination at a time. So whatever is in that next row
would need to use another dimension, like the category  combination. So,
you would need something like "ACT AS + SP" as your data element, and it
would need to be disaggregated by "Page 1" and "Page 2". If this is dynamic
however, you would need to already have these category option combos
generated as metadata and then you could add them to your data entry form I
guess.

But, it simply does not look like aggregate data to me, since you could
have any number of pages I guess?

Regards,
Jason




On Thu, Aug 3, 2017 at 7:04 AM, Omer Butt  wrote:

> Aoa Sir ,
>
> I have designed a Custom form in Data-Set For Data Entry module.
> In That form i have added a functionality of dynamic Row (tr of table with
> input fields) Generated.
> (Using JavaScript )
>
> As in Below Image :
> The Issue I faced here is that new generated fields(inputs) can't work as
> a default function of Saving Data-elements Values into DB.
>  As it is in first row (tr), fields are green . But in second row(tr),
> inputs are not work the functionality of auto save and get Green.
>
>  (These fields are generated on run time by clicking Add Button )
> Hope so From image you better understand my problem.
>
> Kindly guide me how to save dynamic row generated( input fields) in Data
> Entry form.
>
>
> [image: Inline image 1]
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Hazelcast instance not active

[Jason Pickering]

Hi Edward,

The security issues I am referring to are related to vulnerabilities in
component libraries of DHIS2, as you note. They have nothing to due with
the underlying operating system itself, so even if you move to Windows, you
will not be any safer, as the vulnerabilities exist in the DHIS2 software
itself.

Perhaps moving your server prevented the attack from happening again?

Regardless, Hazelcast is no longer in use, so I think once you upgrade,
that problem should disappear.

Regards,
Jason



On Fri, Jul 28, 2017 at 12:16 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> Hi Jason, indeed, upgrading the instance is very high on the priority
> list.  This is a server that we have taken over.  It had been compromised
> previously on Linux with a well known bitcoin mining zero-day vulnerability
> affecting out of date struts instances.  That has since been sorted out.  A
> second server running Windows has not been affected.  We had migrated this
> machine to a Windows box as a short term solution since the zero-day script
> was written to specifically target Linux.  Since Upgrading is a time
> consuming process, we are scheduling it for ‘as soon as possible’ beginning
> this weekend.  It will happen off-line, incrementally, until we are up to
> date but it’s not likely to be complete in the next few days.
>
> For now, is there anything obviously amiss in the reported output from
> ‘about DHIS2’?
>
>
>
> Thanks!
>
> Ed
>
>
>
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* Friday, 28 July 2017 11:58 AM
> *To:* Edward Robinson <erobin...@projectbalance.com>
> *Cc:* dhis2-users <dhis2-users@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] Hazelcast instance not active
>
>
>
> Hi Edward,
>
>
>
> You would be well advised to upgrade that instance as soon as possible.
> There are  number of very serious security issues which have been fixed in
> later versions, but not as far as I know, as far back as 2.16. It would not
> surprise me at all of your server had been compromised, which might explain
> why this is happening. I would carefully check the server logs for any
> strange activity, but would recommend that you upgrade to a later version
> as soon as possible, where a number of security problems have been recently
> rectified.
>
>
>
> Regards,
>
> Jason
>
>
>
>
>
> On Fri, Jul 28, 2017 at 11:55 AM, Edward Robinson <
> erobin...@projectbalance.com> wrote:
>
> For reference, this is my setup according to the ‘about DHIS2’ page:
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+erobinson=
> projectbalance@lists.launchpad.net] *On Behalf Of *Edward Robinson
> *Sent:* Friday, 28 July 2017 11:48 AM
> *To:* dhis2-users <dhis2-users@lists.launchpad.net>
> *Subject:* [Dhis2-users] Hazelcast instance not active
>
>
>
> For the past two days I’ve woken up to this after logging in to DHIS2
> (2.16) on Windows:
>
> *HTTP Status 500 - Hazelcast instance is not active!*
>
> I’m not sure what’s causing it and I need to investigate the logs but I
> wondered if anything obvious comes to mind from the user group – has anyone
> else experienced this and what should I look out for?
>
> I’ll reboot the server (sorts it out) and continue with some urgent work
> then investigate what may be causing this.
>
>
>
> Thanks!
>
>
>
> Ed
>
>
>
>
> ___
> 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 <+46764147049>
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] WebAPI Bugs when filtering by level and ancestor

[Jason Pickering]

Seems to work as its documented (at least in some cases)

https://play.dhis2.org/dev/api/dataElements?filter=name:like:IPT

Gives all data elements which contain IPT

https://play.dhis2.org/dev/api/dataElements?filter=name:like:IPT=name:like:1st

Gives all data elements which contain IPT and 1st (but no others).

This however, does not work

https://play.dhis2.org/dev/api/27/organisationUnits.json?filter=level:eq:4=ancestors.id:eq:O6uvpzGd5pu=id,name,ancestors,level

as you get some level 3 and some level 4 units.

This however does work

https://play.dhis2.org/dev/api/27/organisationUnits.json?filter=level:eq:4=path:like:O6uvpzGd5pu=id,name,ancestors,level


So, maybe the problem is filtering in the nested collections?

/Jason

On Thu, Jul 27, 2017 at 10:09 AM, Gaurav Kumar <
gku...@internationalmedicalcorps.org> wrote:

> Hi Morten,
>
>
>
> Could this be linked to the issue I reported earlier?
>
>
>
> [image: Bug]DHIS2-1911 (WEB
> API: Recursive filtering not working with more than one AND filter).
>
>
>
> Regards,
>
> GAURAV
>
>
>
> *From:* Dhis2-devs [mailto:dhis2-devs-bounces+gkumar=
> internationalmedicalcorps@lists.launchpad.net] *On Behalf Of *Morten
> Olav Hansen
> *Sent:* Thursday, July 27, 2017 7:16 AM
> *To:* Mamadou Diao Diallo 
> *Cc:* dhis2-users ; DHIS 2 developers <
> dhis2-d...@lists.launchpad.net>
> *Subject:* Re: [Dhis2-devs] [Dhis2-users] WebAPI Bugs when filtering by
> level and ancestor
>
>
>
> Hi Mamadou
>
>
>
> Could you please report a bug to JIRA? jira.dhis2.org
>
>
> --
>
> Morten Olav Hansen
>
> Senior Engineer, DHIS 2
>
> University of Oslo
>
> http://www.dhis2.org
>
>
>
> On Wed, Jul 26, 2017 at 11:52 PM, Mamadou Diao Diallo <
> diao_dia...@gn.jsi.com> wrote:
>
> Hi Devs,
>
> I'm currently using dhis2 API to develop an App, but I have some troubles
> when I filter by *level* and *ancestor* in the same time.
>
>
>
> To clarify:
>
>
>
> *Everything is ok with this one :* URL/api/25/organisationUnits.
> json?filter=level:eq:'+level+'=[id,displayName]
>
>
>
> *But by adding ancestor parameter the level is just ignored:*
>
> URL/api/25/organisationUnits.json?filter=level:eq:'+level+'
> =ancestors.id:eq:'+ancestorId+'=[id,displayName]
>
>
>
> I will really appreciate your help and any link for an advanced dhis2 API
> topic.
>
>
>
> Best,
>
>
>
> Diao
>
>
>
> --
>
> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 ( District
> Health Information Software )*
>
> *[image:
> https://www.measureevaluation.org/++theme++wink-measure/images/meval_logo.png]*
>  *[image: http://jsi.com/Managed/Images/Common/JSI_WebHeader.png]*
>
> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
>
> *Phone : 623909413 | 662256106*
>
> *Skype : diawwdiallo*
>
> www.jsi.com
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Request User Table in DHIS2

[Jason Pickering]

The other alternative is to use the API of course. What exactly are you
trying to achieve?


On Tue, Jul 25, 2017 at 11:28 AM, Carlos Nyembwe <nyem...@gmail.com> wrote:

> thanks Jason,
>
> I understand you well but, I'm sorry for that because I don't have the
> local database now, I have to download it
>
>
>
> On Tue, Jul 25, 2017 at 10:22 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Carlos,
>> This has been put into place as a measure to prevent the potential
>> accidental exposure of usernames and password hashes.
>>
>> You can perform the query using a direct connection to the database, but
>> DHIS2 should block any SQL views with references to some protected tables.
>>
>> Regards,
>> Jason Pickering
>>
>> On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe <nyem...@gmail.com>
>> wrote:
>>
>>> Hi all
>>>
>>> I have a problem about SQL request in DHIS2
>>>
>>>
>>> When I request the table User in front end, I see this message, but for
>>> now, I want to have some situation about User in my extence DHIS2
>>> SQL query contains references to protected tables
>>>
>>> How can help me?
>>>
>>> Regards
>>>
>>> Carlos
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381 <+243%20813%20166%20381>*
>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
>>> **Linkedin
>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>> <https://www.facebook.com/carloscnksys> | Twitter
>>> <https://twitter.com/Carlos_CNK> |*
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
> **Linkedin
> <http://www.linkedin.com/in/carloscnk> | Facebook
> <https://www.facebook.com/carloscnksys> | Twitter
> <https://twitter.com/Carlos_CNK> |*
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Request User Table in DHIS2

[Jason Pickering]

Hi Carlos,
This has been put into place as a measure to prevent the potential
accidental exposure of usernames and password hashes.

You can perform the query using a direct connection to the database, but
DHIS2 should block any SQL views with references to some protected tables.

Regards,
Jason Pickering

On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe <nyem...@gmail.com> wrote:

> Hi all
>
> I have a problem about SQL request in DHIS2
>
>
> When I request the table User in front end, I see this message, but for
> now, I want to have some situation about User in my extence DHIS2
> SQL query contains references to protected tables
>
> How can help me?
>
> Regards
>
> Carlos
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
> **Linkedin
> <http://www.linkedin.com/in/carloscnk> | Facebook
> <https://www.facebook.com/carloscnksys> | Twitter
> <https://twitter.com/Carlos_CNK> |*
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Missing Key Step when Aggregating Tracker Data--please help!

[Jason Pickering]

Hi Chase,
DId you run analytics?

https://docs.dhis2.org/master/en/user/html/ch32.html

Regards,
Jason


On Mon, Jul 17, 2017 at 4:54 PM, Freeman, Chase 
wrote:

> Dear Users & Devs,
>
>
>
> I’ve been researching how to integrate Tracker Data into the main database
> but am continually running into a challenge when testing on the DHIS2 Demo.
> I can successfully view my individual enrollments on the Tracker Reports
> but cannot see any aggregate data input for the same information under
> pivot tables or event reports.  As an example, if I register a new male
> birth on 7/17/17, I cannot see an added value in aggregated male births for
> 7/17/17—It is clear to me I am missing the crucial link.
>
>
>
> Do I need to specify a program indicator to make this happen?
>
>
>
> I have read the docs but do not understand what I am missing. I am also
> wondering if it could just be the Demo system not setup to aggregate
> tracker elements which is why I am reaching out—I don’t want to drive
> myself crazy J
>
>
>
> Regards,
>
>
>
> *Chase Freeman*
>
> Jr. Web Developer
> Management Systems International
> A Tetra Tech Company
> Arlington, VA USA
>
> (Work) +1 703 979 7170 x219 <+1%20703-979-7170>
>
> chase.free...@msi-inc.com
>
>
>
> www.msiworldwide.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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Any open source GIS/map database tools other than DHIS2

[Jason Pickering]

qgis.org 

Is another great alternative. 

On June 21, 2017 4:01:58 PM GMT+02:00, Knut Staring  wrote:
>Hi Dipali,
>Take a look at http://www.diva-gis.org/
>
>Knut
>
>On Jun 21, 2017 15:28, "Dipali Sahu"  wrote:
>
>> Hi
>>
>> I am wondering if there are any open source tools other than DHIS2
>that
>> anyone has used for projecting data on maps.
>>
>> My requirement is to create just a few maps, hence creating all the
>OU
>> hierarchy in DHIS2 is too big an exercise. I am looking for a tool
>that
>> already has administrative boundaries from UN OCHA or OSM etc. and
>where I
>> can just project my coordinates , change admin division colors and
>some
>> very basic stuff.
>>
>> Thank you in advance, any leads will be helpful.
>> Deepali
>>
>>
>>
>> ___
>> 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
>>
>>

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Problem rendering a pivot table

[Jason Pickering]

Hi Chris,

This normally is a result of loading a pivot with "too much" data. What too
much is is not entirely clear and can depend on a number of factors. Do you
get an "Aww snap!" message in the browser? Are you trying to load a "big"
pivot with lots of data?

If possible,  I would suggest to load smaller subsets of data or use the
"Download CSV" function if you are experiencing this issue.


​

Also, any browser console and/or server messages when executing the pivot
would be helpful to diagnose the problem.

Regards,
Jason


On Tue, Jun 20, 2017 at 4:46 PM, Chris van Hasselt 
wrote:

> We are experiencing a problem running pivot tables on  version 2.26 of
> DHIS 2.   When the data is requested via the API, the data is returned very
> quickly. However when we  launch a pivot table, specifically with the all
> the data elements, the pivot table hangs.
>
>
>
> From what we can tell via the Chrome developer tools (and other tools),
> there is a lot of Javascript garbage collection.  The same sort of behavior
> happens in IE and Firefox, but the upshot is that the pivot table hangs as
> it is trying to render, and eventually the browser crashes.
>
>
>
> Has anyone seen this type of thing before?  Any suggestions on what to
> look for?
>
>
>
> Thanks in advance,
>
> CvH
>
>
>
> *Chris van Hasselt* | *IT Project Manager*
>
> 359 Blackwell Street, Suite 200 | Durham, NC  27701
>
> O: 919.544.7040 x11271 | cvanhass...@fhi360.org |
>
>
>
> [image: Description: Description: fhi 360 email.jpg]
>
> Visit us at www.fhi360.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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 Translation app

[Jason Pickering]

Hi Georgi,
Yes,  I see it now. The filter seems to work for some objects (such as
categories) but not for others (such as data elements). We will look into
it.

Due to the way in which translations were reimplemented, I do not think
importation of translations is supported any longer. The translations API
is described in detail however here.

https://docs.dhis2.org/master/en/developer/html/webapi_browsing_the_web_api.html#webapi_translation_api

Regards,
Jason


On Fri, Jun 16, 2017 at 11:35 AM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:

> Hi Jason,
>
>
>
> Thanks for your response!
>
>
>
> Regretfully, I do not see the filter working properly in the demo as well.
> See a screenshot at the end of the email.
>
>
>
> What is not working for us is that despite we have the majority of the
> data elements translated in French and Spanish we still see a full list (of
> both translated and not translated), regardless of the Filter option
> selected. With 1000+ elements it would be really handy to get a list of the
> untranslated ones only.
>
>
>
> Another question to you: Is there a way to import translations through the
> Translation app or Import/Export app? Older versions of DHIS2 supported csv
> imports but not anymore.
>
>
>
>
>
> I filter by untranslated data elements (Locale French) but I still see a
> data element that has been translated (look at the second one)
>
>
>
>
>
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* Friday, June 16, 2017 11:38 AM
> *To:* Georgi Chakarov <geo...@logicaloutcomes.net>
> *Cc:* DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers
> list <dhis2-d...@lists.launchpad.net>; Yann Vergriete <
> yvergri...@usc-canada.org>; Paula Richardson <prichard...@usc-canada.org>
> *Subject:* Re: [Dhis2-users] DHIS2 Translation app
>
>
>
> Hi Georgi,
>
>
>
> ->Would you know why the Filter by function is not working?
>
>
>
> This seems to work fine on the demo site. Could you give more details
> about what is not working?
>
>
>
> I think this is the expected behaviour if you do not have any
> translations.Everything is in the untranslated state.
>
>
>
> This app is fairly new, and so your feedback would be appreciated.
>
>
>
> Best regards,
>
> Jason
>
>
>
>
>
>
>
>
>
>
>
> On Thu, Jun 15, 2017 at 9:56 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hello!
>
>
>
> Does anyone has experience with the DHIS2 Translation app? Would you know
> why the Filter by function is not working?
>
> It is really useful to filter by “Untranslated” data elements, for
> example, but when selecting this option nothing changes. We still get a
> list of all data elements.
>
>
>
> Any idea?
>
>
>
> Thanks,
>
>
>
> Georgi
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <+1%20647-478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* <i...@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
>
>
>
>
>
> --
>
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46764147049>
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 Translation app

[Jason Pickering]

Hi Georgi,

->Would you know why the Filter by function is not working?

This seems to work fine on the demo site. Could you give more details about
what is not working?

I think this is the expected behaviour if you do not have any
translations.Everything is in the untranslated state.

This app is fairly new, and so your feedback would be appreciated.

Best regards,
Jason





On Thu, Jun 15, 2017 at 9:56 PM, Georgi Chakarov  wrote:

> Hello!
>
>
>
> Does anyone has experience with the DHIS2 Translation app? Would you know
> why the Filter by function is not working?
>
> It is really useful to filter by “Untranslated” data elements, for
> example, but when selecting this option nothing changes. We still get a
> list of all data elements.
>
>
>
> Any idea?
>
>
>
> Thanks,
>
>
>
> Georgi
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <+1%20647-478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 Data set reports issue

[Jason Pickering]

Check and see if the data appears in the pivot tables.

If so, then  check the browser console for any errors there. There could be
some issue with your custom form layout preventing the data from appearing
in the data set reports.

If you do not see anything in the pivots, are you perhaps using approvals?

Regards,
Jason


On Fri, Jun 9, 2017 at 10:20 AM, Raja Imran Qamer <im...@pace-tech.com>
wrote:

> On 2017-06-09 13:13, Jason Pickering wrote:
>
>> Did you run analytics?
>>
>> https://docs.dhis2.org/master/en/user/html/ch32.html [6]
>>
>> Regards,
>> Jason
>>
>> On Fri, Jun 9, 2017 at 10:08 AM, Raja Imran Qamer
>> <im...@pace-tech.com> wrote:
>>
>> Dear All,
>>>
>>> Please find attached images for problem listed below.
>>>
>>> I filled a dataset form with values for a period week 29 of year
>>> 2017 (data set 1 .png)
>>> Now I trying to view data set report for this but it shows me empty
>>> form (data set report.png)
>>>
>>> What are the possible issue(s).
>>>
>>> Thanks
>>> --
>>> RAJA IMRAN QAMER,
>>>
>>> Senior Software Engineer, Team Lead,
>>>> PACE TECHNOLOGIES,
>>>> Email:im...@pace-tech.com, rajaimranqa...@gmail.com
>>>> Phone: +923345073573 [1], +92512361110 [2]
>>>> Web: www.pace-tech.com [3]
>>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users [4]
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users [4]
>>> More help : https://help.launchpad.net/ListHelp [5]
>>>
>>
>> --
>>
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>> Links:
>> --
>> [1] tel:%2B923345073573
>> [2] tel:%2B92512361110
>> [3] http://www.pace-tech.com
>> [4] https://launchpad.net/~dhis2-users
>> [5] https://help.launchpad.net/ListHelp
>> [6] https://docs.dhis2.org/master/en/user/html/ch32.html
>>
>
> Dear Jason P. Pickering,
>
> Thanks for quick response.
> I just ran analytics and still same issue.
>
> Thanks.
>
> --
> RAJA IMRAN QAMER,
>
>> Senior Software Engineer, Team Lead,
>> PACE TECHNOLOGIES,
>> Email:im...@pace-tech.com, rajaimranqa...@gmail.com
>> Phone: +923345073573, +92512361110
>> Web: www.pace-tech.com
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 Data set reports issue

[Jason Pickering]

Did you run analytics?

https://docs.dhis2.org/master/en/user/html/ch32.html

Regards,
Jason


On Fri, Jun 9, 2017 at 10:08 AM, Raja Imran Qamer 
wrote:

> Dear All,
>
> Please find attached images for problem listed below.
>
> I filled a dataset form with values for a period week 29 of year 2017
> (data set 1 .png)
> Now I trying to view data set report for this but it shows me empty form
> (data set report.png)
>
> What are the possible issue(s).
>
> Thanks
> --
> RAJA IMRAN QAMER,
>
>> Senior Software Engineer, Team Lead,
>> PACE TECHNOLOGIES,
>> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Search data elements by Code

[Jason Pickering]

Seems like a good feature and I think it's planned. Maybe you can use data 
element groups to accomplish the same purpose? 

On June 7, 2017 4:11:13 PM GMT+02:00, Petar Jovanovic  
wrote:
>Hello everybody,
>
>We have in our DHIS2 instance data elements belonging to different 
>programs/data sets, but also to different domains (packages) or
>diseases 
>we are dealing with. Also, some of them are common across different 
>diseases and domains.
>
>So far, in order to easy the search for specific data elements in the 
>maintenance app, we were including additional codes (like tags) inside 
>the names of these data elements. The problem arose when we used 
>analytic apps and these long codified names started showing very ugly
>in 
>the charts and tables. We found a way to enforce using short names 
>instead of names, although there are some bugs preventing this in 
>event-based analytics apps and we reported it.
>
>Anyhow, we feel that names of data elements should be something human 
>readable and without specific codifications and tags. Thus we first 
>planned to move these codified names to data element codes instead,
>but, 
>currently there is no possibility to search data elements by their code
>
>in the maintenance app.
>
>We've seen that in 2.27 the search of data elements improved and gives 
>more options, but not searching by code unfortunately.
>
>We think that it could be very useful and user friendly if we are able 
>to search of data elements using specific tags (disease, package, 
>common...) codified inside the code attribute of data elements, so we 
>would like to raise the question of possibility of including such 
>functionality in DHIS2.
>
>
>Thank you!
>
>
>Best,
>Petar
>
>
>___
>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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
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] [Event graphs or event pivots tables appear as blank in my dashboard]

[Jason Pickering]

There is likely either an error on the server or in the browser console.
See if you can check both of those places for a year error.

Have you tried incognito mode to exclude any possible cache effects?

On Tue, May 23, 2017, 10:02 AM Marc Garnica  wrote:

> Hi! It might a little bit confusing but we are experiencing the same
> problem with some of our graphs, but in our case we were plotting
> indicators for a single organisation unit.
>
> It will be so useful if we can figure out what is happening.
>
> Marc
>
> 2017-05-23 9:44 GMT+02:00 Julie Vanhamme :
>
>> Hi DHIS2 community members,
>>
>> I created graphs with the *event reporter* and *event visualizer app*.
>> To create those graphs, I used data element. I saved those graphs and add
>> them in a dashboard.
>>
>> My problem is that in my dashboard I only see* a blank frame instead of
>> the graph* (see screenshot in attachment). When I click on the button
>> "Explore", I go to my saved graph and I can see it.
>>
>> The only graph that I can see in my dasboard is one that I created trough
>> the Data visualizer app using indicators.
>>
>> Why can I not see my graphs (from event reporter or event visualizer
>> apps) in my dashboard and how can I fix it?
>>
>> Thanks
>>
>>
>> Julie Vanhamme
>>
>>
>>
>> ___
>> 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] User log in and log out status

[Jason Pickering]

Hi Muhammad,
Try this on 2.22

api/users?fields=userCredentials[name,lastLogin]=userCredentials.lastLogin:gt:2015-03-30


Adjust the date to which ever date you want.

Regards,s
Jason


On Thu, May 11, 2017 at 7:53 AM, Muhammad Nadeem <nade...@gmail.com> wrote:

> I am using 2.22
>
> thanks
> Nad
>
> On Thu, May 11, 2017 at 10:03 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Muhammad,
>> Which version are you using?
>>
>> Regards,
>> Jason
>>
>> On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem <nade...@gmail.com> wrote:
>>
>>> Hi
>>>
>>> I have tried earlier date and in my case its shows like as follows:
>>>
>>> {"pager":{"page":1,"pageCount":2,"total":81,"pageSize":50,"nextPage":"http://greenstar/api/users?page=2"},"users":[{"userCredentials":{"lastLogin":"2017-02-26T14:40:53.728+"}},{"userCredentials":{"lastLogin":"2017-02-26T14:38:37.332+"}}
>>>
>>> not showing who login to system.
>>>
>>>
>>> please help
>>>
>>>
>>>
>>> On Mon, May 8, 2017 at 5:37 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> Well that means no one has logged in since the 1st of May. Try an
>>>> earlier date maybe like?
>>>>
>>>>
>>>> https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code,
>>>> lastLogin]=userCredentials.lastLogin:gt:2016-05-01
>>>>
>>>> On Mon, May 8, 2017 at 2:24 PM, Muhammad Nadeem <nade...@gmail.com>
>>>> wrote:
>>>>
>>>>> Thanks Jason,
>>>>>
>>>>> I did process and follow your instruction and in result this is what i
>>>>> have got it.
>>>>>
>>>>>
>>>>>
>>>>> {"pager":{"page":1,"pageCount":1,"total":0,"pageSize":50},"users":[]}
>>>>>
>>>>>
>>>>>
>>>>> please help me
>>>>>
>>>>> thanks Nad
>>>>>
>>>>>
>>>>>
>>>>> On Mon, May 8, 2017 at 12:48 PM, Jason Pickering <
>>>>> jason.p.picker...@gmail.com> wrote:
>>>>>
>>>>>> Hi Muhammad,
>>>>>>
>>>>>> We fixed a bug a while back which allowed access to protected
>>>>>> tables.  This query may have worked for you before (but it was intended 
>>>>>> not
>>>>>> to) but it should not work now.  The "users" tables contains user 
>>>>>> password
>>>>>> hashes, and should be considered to be very sensitive. That query could
>>>>>> expose user password hashes to all users who can access SQL views, which
>>>>>> would not be a great idea to have available via an SQL query, thus it has
>>>>>> been protected  to be exposed via an SQL query.
>>>>>>
>>>>>> There are other ways of achieving what you want to do. For instance.
>>>>>>
>>>>>> https://play.dhis2.org/dev/api/users.json?fields=userCredent
>>>>>> ials[code,lastLogin]=userCredentials.lastLogin:gt:2017-05-01
>>>>>>
>>>>>> would show you all users (with their user name) who have logged in
>>>>>> since May 1st 2017.
>>>>>>
>>>>>> You can also look for inactive users easily through the user admin
>>>>>> app
>>>>>>
>>>>>>
>>>>>>
>>>>>> ​
>>>>>> Hope this helps.
>>>>>>
>>>>>> Best regards,
>>>>>> Jason
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, May 8, 2017 at 9:37 AM, Muhammad Nadeem <nade...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi All,
>>>>>>>
>>>>>>> I am having problems in retrieving user log in and log out status.
>>>>>>> Any one can help me out in how to get details who's login and log out
>>>>>>> details. Please help me out.
>>>>>>>
>>>>>>> I am using SQL view query "SELECT * from USERS;" it shows me some
>>>>>>> information but not the updated one.
>>>>>>>
>>>>>>> Please help me out.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Nad
>>>>>>>
>>>>>>> ___
>>>>>>> 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 <076-414%2070%2049>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Jason P. Pickering
>>>> email: jason.p.picker...@gmail.com
>>>> tel:+46764147049 <076-414%2070%2049>
>>>>
>>>
>>>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] User log in and log out status

[Jason Pickering]

Hi Muhammad,
Which version are you using?

Regards,
Jason

On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem <nade...@gmail.com> wrote:

> Hi
>
> I have tried earlier date and in my case its shows like as follows:
>
> {"pager":{"page":1,"pageCount":2,"total":81,"pageSize":50,"nextPage":"http://greenstar/api/users?page=2"},"users":[{"userCredentials":{"lastLogin":"2017-02-26T14:40:53.728+"}},{"userCredentials":{"lastLogin":"2017-02-26T14:38:37.332+"}}
>
> not showing who login to system.
>
>
> please help
>
>
>
> On Mon, May 8, 2017 at 5:37 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Well that means no one has logged in since the 1st of May. Try an earlier
>> date maybe like?
>>
>>
>> https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code,
>> lastLogin]=userCredentials.lastLogin:gt:2016-05-01
>>
>> On Mon, May 8, 2017 at 2:24 PM, Muhammad Nadeem <nade...@gmail.com>
>> wrote:
>>
>>> Thanks Jason,
>>>
>>> I did process and follow your instruction and in result this is what i
>>> have got it.
>>>
>>>
>>>
>>> {"pager":{"page":1,"pageCount":1,"total":0,"pageSize":50},"users":[]}
>>>
>>>
>>>
>>> please help me
>>>
>>> thanks Nad
>>>
>>>
>>>
>>> On Mon, May 8, 2017 at 12:48 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> Hi Muhammad,
>>>>
>>>> We fixed a bug a while back which allowed access to protected tables.
>>>> This query may have worked for you before (but it was intended not to) but
>>>> it should not work now.  The "users" tables contains user password hashes,
>>>> and should be considered to be very sensitive. That query could expose user
>>>> password hashes to all users who can access SQL views, which would not be a
>>>> great idea to have available via an SQL query, thus it has been protected
>>>>  to be exposed via an SQL query.
>>>>
>>>> There are other ways of achieving what you want to do. For instance.
>>>>
>>>>
>>>> https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code,lastLogin]=userCredentials.lastLogin:gt:2017-05-01
>>>>
>>>> would show you all users (with their user name) who have logged in
>>>> since May 1st 2017.
>>>>
>>>> You can also look for inactive users easily through the user admin app
>>>>
>>>>
>>>>
>>>> ​
>>>> Hope this helps.
>>>>
>>>> Best regards,
>>>> Jason
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, May 8, 2017 at 9:37 AM, Muhammad Nadeem <nade...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> I am having problems in retrieving user log in and log out status.
>>>>> Any one can help me out in how to get details who's login and log out
>>>>> details. Please help me out.
>>>>>
>>>>> I am using SQL view query "SELECT * from USERS;" it shows me some
>>>>> information but not the updated one.
>>>>>
>>>>> Please help me out.
>>>>>
>>>>> Thanks
>>>>> Nad
>>>>>
>>>>> ___
>>>>> 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 <076-414%2070%2049>
>>>>
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] User log in and log out status

[Jason Pickering]

Well that means no one has logged in since the 1st of May. Try an earlier
date maybe like?


https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code,
lastLogin]=userCredentials.lastLogin:gt:2016-05-01

On Mon, May 8, 2017 at 2:24 PM, Muhammad Nadeem <nade...@gmail.com> wrote:

> Thanks Jason,
>
> I did process and follow your instruction and in result this is what i
> have got it.
>
>
>
> {"pager":{"page":1,"pageCount":1,"total":0,"pageSize":50},"users":[]}
>
>
>
> please help me
>
> thanks Nad
>
>
>
> On Mon, May 8, 2017 at 12:48 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Muhammad,
>>
>> We fixed a bug a while back which allowed access to protected tables.
>> This query may have worked for you before (but it was intended not to) but
>> it should not work now.  The "users" tables contains user password hashes,
>> and should be considered to be very sensitive. That query could expose user
>> password hashes to all users who can access SQL views, which would not be a
>> great idea to have available via an SQL query, thus it has been protected
>>  to be exposed via an SQL query.
>>
>> There are other ways of achieving what you want to do. For instance.
>>
>> https://play.dhis2.org/dev/api/users.json?fields=userCredent
>> ials[code,lastLogin]=userCredentials.lastLogin:gt:2017-05-01
>>
>> would show you all users (with their user name) who have logged in since
>> May 1st 2017.
>>
>> You can also look for inactive users easily through the user admin app
>>
>>
>>
>> ​
>> Hope this helps.
>>
>> Best regards,
>> Jason
>>
>>
>>
>>
>> On Mon, May 8, 2017 at 9:37 AM, Muhammad Nadeem <nade...@gmail.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> I am having problems in retrieving user log in and log out status.  Any
>>> one can help me out in how to get details who's login and log out
>>> details. Please help me out.
>>>
>>> I am using SQL view query "SELECT * from USERS;" it shows me some
>>> information but not the updated one.
>>>
>>> Please help me out.
>>>
>>> Thanks
>>> Nad
>>>
>>> ___
>>> 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 <076-414%2070%2049>
>>
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] User Authorities and Dashboards

[Jason Pickering]

Hi Georgi,
Good. You are on the  right track then.

>From the user management app, each investor needs to be restricted by the
dimension you mentioned.


Like from the demo site, you might decide to restrict a user to the
"Funding agency" dimension.

In order for you to obfuscate data from other users, the category option
which is part of that dimension, should only be shared with a user group
which the user actually belongs to and with no other users.

The category option should have "Public access" set to none and should be
shared with a group with at least "Can view" which the user also belongs
to. This will allow the user to see these analytics values, but will not
allow other users to see them.

Even if you were able to restrict which pivots the users could see, savvy
users could always use the API to extract data from the system, thus, it
must be protected by proper configuration of sharing. With correct use of
sharing between users and category options, you should be able to achieve
this.

Regards,
Jason



​

On Thu, May 4, 2017 at 1:52 PM, Georgi Chakarov <geo...@logicaloutcomes.net>
wrote:

> Hi Jason,
>
>
>
> Thank you for your response!
>
>
>
> This is exactly how I have structured my data originally. I have organized
> each investor as an Attribute category options and have created Attribute
> option combos and assigned to selected data sets. Here are my questions:
>
> 1)  How do I share only one category option with one user?
>
> 2)  What do you mean by "Selected dimension restrictions for data
> analytics"? Unless I allow users to “See Pivot table module” they do not
> see the reports on the dashboard. And from within the Pivot they have
> access to other Attribute options (namely investors). I cannot assign
> authorities to only part of the Pivot table functions, regretfully.
>
>
>
> Regards,
>
>
>
> Georgi
>
>
>
>
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+georgi=
> logicaloutcomes@lists.launchpad.net] *On Behalf Of *Jason Pickering
> *Sent:* Thursday, May 4, 2017 2:15 PM
> *To:* Antonia - Pro <anto...@informa.pro>
> *Cc:* dhis2-users@lists.launchpad.net; dhis2-d...@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] User Authorities and Dashboards
>
>
>
> Hi Georgi,
>
>
>
> To be most specific I think, you will need to use the "Attribute option
> combo" to control who can see what. This is basically a way to disaggregate
> data by a custom dimension, in this case, by an investor group. Its often
> used in situations where multiple partners are entering data for the same
> health facility, but you do not want one partner to be able to see another
> partners data.  Once you disaggregate your data set this way, you can then
> use sharing to control who can see what, by only sharing the category
> option which is applicable to a given user, with that user.  Each investor
> would need to be belong to a common group with "their" category option. You
> would then need to restrict users in their user role  with "Selected
> dimension restrictions for data analytics" as well.
>
> This type of setup can get complex quickly, but has been used in larger
> implementations (i.e with the PEPFAR system) , but usually only when the
> groups are properly designed and the creation of users is done in a
> scripted way, to ensure that all of the permissions are set correctly.
>
>
>
> Hope that helps!
>
>
>
> Jason
>
>
>
>
>
> On Thu, May 4, 2017 at 12:58 PM, Antonia - Pro <anto...@informa.pro>
> wrote:
>
> Exactly Morten.
>
> For Dashboards, sharing also works at user level after the last update
> 2.26, but reports (data, event visualizer and reports and pivot tables)
> only work at group level currently (on the demo server).
>
>
> [image: Image removed by sender.]
>
> *Eng. Antonia Bezenchek*
>
> CIO - ICT Engineer
>
> *InformaPRO S.r.l.* via Guido Guinizelli, 98/100, Roma 00152, Italy
>
>
>
> 2017-05-04 12:29 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>:
>
> Hm, I think maybe we support this only for the dashboards, so it might not
> help you (you can share dashboards directly to users, but reporting apps
> are not updated for that yet).
>
>
> --
>
> Morten Olav Hansen
>
> Senior Engineer, DHIS 2
>
> University of Oslo
>
> http://www.dhis2.org
>
>
>
> On Thu, May 4, 2017 at 5:28 PM, Antonia - Pro <anto...@informa.pro> wrote:
>
> Permissions for Dashboard and Favorites are managed at the group level, so
> if they are not groupable, you need to create a group for each user.
>
>
>
> Regards,
>
> Antonia
>
>

Re: [Dhis2-users] User Authorities and Dashboards

[Jason Pickering]

Hi Georgi,

To be most specific I think, you will need to use the "Attribute option
combo" to control who can see what. This is basically a way to disaggregate
data by a custom dimension, in this case, by an investor group. Its often
used in situations where multiple partners are entering data for the same
health facility, but you do not want one partner to be able to see another
partners data.  Once you disaggregate your data set this way, you can then
use sharing to control who can see what, by only sharing the category
option which is applicable to a given user, with that user.  Each investor
would need to be belong to a common group with "their" category option. You
would then need to restrict users in their user role  with "Selected
dimension restrictions for data analytics" as well.

This type of setup can get complex quickly, but has been used in larger
implementations (i.e with the PEPFAR system) , but usually only when the
groups are properly designed and the creation of users is done in a
scripted way, to ensure that all of the permissions are set correctly.

Hope that helps!

Jason


On Thu, May 4, 2017 at 12:58 PM, Antonia - Pro  wrote:

> Exactly Morten.
> For Dashboards, sharing also works at user level after the last update
> 2.26, but reports (data, event visualizer and reports and pivot tables)
> only work at group level currently (on the demo server).
>
>
> *Eng. Antonia Bezenchek*
> CIO - ICT Engineer
> *InformaPRO S.r.l.* via Guido Guinizelli, 98/100, Roma 00152, Italy
>
>
> 2017-05-04 12:29 GMT+02:00 Morten Olav Hansen :
>
>> Hm, I think maybe we support this only for the dashboards, so it might
>> not help you (you can share dashboards directly to users, but reporting
>> apps are not updated for that yet).
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Thu, May 4, 2017 at 5:28 PM, Antonia - Pro 
>> wrote:
>>
>>> Permissions for Dashboard and Favorites are managed at the group level,
>>> so if they are not groupable, you need to create a group for each user.
>>>
>>> Regards,
>>> Antonia
>>>
>>>
>>>
>>> 2017-05-04 9:47 GMT+02:00 Georgi Chakarov :
>>>
 Hi Alex,



 Thanks for the response!



 I have 150 investors and none of them should be able to see the reports
 of the other investors.

 Does this mean that I have to create 150 user groups with one investor
 each?



 Regards,



 Georgi



 *From:* Alex Tumwesigye [mailto:atumwesi...@gmail.com]
 *Sent:* Thursday, May 4, 2017 8:53 AM
 *To:* Georgi Chakarov 
 *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
 *Subject:* Re: [Dhis2-users] User Authorities and Dashboards



 Dear Georgi,



 The solution is Sharing and User Groups



 Implement the same sharing on each report/chart/gis map as you did on
 the dashboard.

 That is Set Public to *None *and then add the Investor User Group
 (which is has access) and set sharing to *View*



 *Alex*



 On Wed, May 3, 2017 at 7:27 PM, Georgi Chakarov <
 geo...@logicaloutcomes.net> wrote:

 Hello all,



 I have a big problem setting up the correct authorities so that users
 see what I need them to.

 In brief, I am reporting on financial data. I have a few investors for
 whom I have prepared personal dashboards with pivots on how much return
 they have earned. I DO NOT want investors to be able to see each other’s
 data.



 This is what I have done:

 1)  User Authorities:

 -  See dashboards

 -  See browser cache

 -  See pivot table module

 *IMPORTANT:* If I remove the “See pivot table module” the users are
 not able to see the saved pivot tables on their dashboard! So I need this
 authority.



 2)  Dashboards

 -  Created personal dashboard for each investor

 -  Shared the dashboard only with the respective investor



 Every investor is able to see only their dashboard. Here comes the *BIG
 PROBLEM: *When an investor clicks “Explore” pivot table from the
 dashboard it takes him to the Pivot table app. From there, they can go to
 Favorites and open a saved report for any of the other investors and see
 data.



 Two questions here:

 1)  Is there a way for user to see pivots on a dashboard without
 necessarily having access to the Pivot reporting module?

 2)  If not, is there a way to restrict user of opening reports
 saved as favorites in the Pivot reporting module?





 Your 

Re: [Dhis2-users] report generation

[Jason Pickering]

Hi Payoj,
There is no easy way to do this in DHIS2 at the moment, but it may be
possible once the "row" and "column" total feature has been implemented as
described here https://jira.dhis2.org/browse/DHIS2-1107

Otherwise for now, you may need to implement a custom report or pull your
data into Excel in order to calculate this.

Regards,
Jason


On Tue, May 2, 2017 at 8:03 AM, payoj gaikwad  wrote:

> Hello
>
> I stuck to the proble of generating reports
>
> Problem is:-
>
> 1.I have gevin option set to data elements. So I have to make reports on
> it in the percentage,
>
> LikeDISEASE-  options are
>
> Cancer
>
> Hiv
>
> Etc.
>
> So I  have to make percentage report on them. Like in year 2016 how many
> of people got suffured from cancer etc
>
>
>
> Please help
>
> Your Help will be appreciated.
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS2 users list from SQL View

[Jason Pickering]

This is really the only way to get it, since users can have multiple user
roles and organisation units, which would not be able to be properly
represented in a flat CSV list anyway!

Regards,
Jason


On Tue, Apr 11, 2017 at 4:01 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Ok, thanks. I have to get my feet wet with this method! I will try to
> adapt this syntax with our case.
>
> Regards,
>
> Tantely.
>
> On Tue, Apr 11, 2017 at 4:52 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Maybe
>>
>> https://play.dhis2.org/dev/api/users?fields=firstName,surnam
>> e,email,userCredentials[username,lastLogin,created,disabled,
>> userRoles[id,name]],organisationUnits[id,name]=false
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Tue, Apr 11, 2017 at 3:46 PM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Hi Jason,
>>>
>>> If I would like to bypass this SQL scripts and use the Web API as you
>>> already proposed, how could we write the Web API in order to pull out a
>>> list of the following informations from the users:
>>>
>>> username,surname, firstname, email, phonenumber, lastlogin, created,
>>> disabled, user role, user orgunits
>>>
>>> Regards,
>>>
>>> Tantely.
>>>
>>> On Tue, Apr 11, 2017 at 4:29 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> Hi there.
>>>> We have had enough security problems lately, It may not be a good idea
>>>> to encourage even more of them.
>>>>
>>>> This is a "good" way around the security attempts which have put in
>>>> place, but its a very bad idea to have this table as an SQL view. This was
>>>> the entire reason of why we attempted to protect it from direct access via
>>>> SQL views, but, the regular expression which does this does not catch the
>>>> use of the schema name. We will fix it
>>>>
>>>> Of course, its easy enough to dump the password hash out with a small
>>>> change to the SQL view, but you would probably not want to do this.
>>>>
>>>> See below for an example with a  small modification to your SQL view.
>>>>
>>>>
>>>> Regards,
>>>> Jason
>>>>
>>>>
>>>>
>>>>
>>>>- "admin",
>>>>- "$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C",
>>>>- "Traore",
>>>>- "John",
>>>>- "some...@dhis2.org",
>>>>- "",
>>>>- "2017-04-11 13:24:55.914",
>>>>- "2013-04-18 17:15:08.401",
>>>>- "false",
>>>>- "MNCH / PNC (Adult Woman) program",
>>>>- "ZyjSDLHGPv4"
>>>>
>>>>
>>>> On Tue, Apr 11, 2017 at 3:01 PM, Raminosoa Rabemanantsoa, Tantely <
>>>> tramino...@mikolo.org> wrote:
>>>>
>>>>> Hi Harivola,
>>>>>
>>>>> Thank you very much for the SQL scripts querying the users
>>>>> information. The syntax is accepted by SQL View, but I am a bit
>>>>> encountering a blank result as illustrated by the attached file. I am
>>>>> wondering where I am doing wrong?
>>>>>
>>>>> Thank you for your help!
>>>>>
>>>>> Regards,
>>>>>
>>>>> Tantely.
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Apr 11, 2017 at 3:38 PM, Harivola RANDRIANJAFY <
>>>>> harivo...@psi.mg> wrote:
>>>>>
>>>>>> Tantely,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Below the SQL View :
>>>>>>
>>>>>>
>>>>>>
>>>>>> SELECT
>>>>>>
>>>>>> "public".users.username,
>>>>>>
>>>>>> "public".userinfo.surname,
>>>>>>
>>>>>> "public".userinfo.firstname,
>>>>>>
>>>>>> "public".userinfo.email,
>>>>>>
>>>>>> "public".userinfo.phonenumber,
>>>>>>
>>>>>> "public".users.lastlogin,
>>>>

Re: [Dhis2-users] [Dhis2-devs] DHIS2 users list from SQL View

[Jason Pickering]

Maybe

https://play.dhis2.org/dev/api/users?fields=firstName,surname,email,userCredentials[username,lastLogin,created,disabled,userRoles[id,name]],organisationUnits[id,name]=false

Regards,
Jason



On Tue, Apr 11, 2017 at 3:46 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Hi Jason,
>
> If I would like to bypass this SQL scripts and use the Web API as you
> already proposed, how could we write the Web API in order to pull out a
> list of the following informations from the users:
>
> username,surname, firstname, email, phonenumber, lastlogin, created,
> disabled, user role, user orgunits
>
> Regards,
>
> Tantely.
>
> On Tue, Apr 11, 2017 at 4:29 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi there.
>> We have had enough security problems lately, It may not be a good idea to
>> encourage even more of them.
>>
>> This is a "good" way around the security attempts which have put in
>> place, but its a very bad idea to have this table as an SQL view. This was
>> the entire reason of why we attempted to protect it from direct access via
>> SQL views, but, the regular expression which does this does not catch the
>> use of the schema name. We will fix it
>>
>> Of course, its easy enough to dump the password hash out with a small
>> change to the SQL view, but you would probably not want to do this.
>>
>> See below for an example with a  small modification to your SQL view.
>>
>>
>> Regards,
>> Jason
>>
>>
>>
>>
>>- "admin",
>>- "$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C",
>>- "Traore",
>>- "John",
>>- "some...@dhis2.org",
>>- "",
>>- "2017-04-11 13:24:55.914",
>>- "2013-04-18 17:15:08.401",
>>- "false",
>>- "MNCH / PNC (Adult Woman) program",
>>- "ZyjSDLHGPv4"
>>
>>
>> On Tue, Apr 11, 2017 at 3:01 PM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Hi Harivola,
>>>
>>> Thank you very much for the SQL scripts querying the users information.
>>> The syntax is accepted by SQL View, but I am a bit encountering a blank
>>> result as illustrated by the attached file. I am wondering where I am doing
>>> wrong?
>>>
>>> Thank you for your help!
>>>
>>> Regards,
>>>
>>> Tantely.
>>>
>>>
>>>
>>> On Tue, Apr 11, 2017 at 3:38 PM, Harivola RANDRIANJAFY <harivo...@psi.mg
>>> > wrote:
>>>
>>>> Tantely,
>>>>
>>>>
>>>>
>>>> Below the SQL View :
>>>>
>>>>
>>>>
>>>> SELECT
>>>>
>>>> "public".users.username,
>>>>
>>>> "public".userinfo.surname,
>>>>
>>>> "public".userinfo.firstname,
>>>>
>>>> "public".userinfo.email,
>>>>
>>>> "public".userinfo.phonenumber,
>>>>
>>>> "public".users.lastlogin,
>>>>
>>>> "public".users.created,
>>>>
>>>> "public".users.disabled,
>>>>
>>>> "public".userrole."name",
>>>>
>>>> "public".users.uid
>>>>
>>>> FROM
>>>>
>>>> "public".users
>>>>
>>>> INNER JOIN "public".userinfo ON "public".users.userid =
>>>> "public".userinfo.userinfoid
>>>>
>>>> INNER JOIN "public".userrole ON "public".userrole.userid =
>>>> "public".userinfo.userinfoid
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> Harivola
>>>>
>>>>
>>>>
>>>> *De :* Dhis2-users [mailto:dhis2-users-bounces+harivolar=
>>>> psi...@lists.launchpad.net] *De la part de* Raminosoa Rabemanantsoa,
>>>> Tantely
>>>> *Envoyé :* lundi 10 avril 2017 17:19
>>>> *À :* DHIS 2 Users list <dhis2-users@lists.launchpad.net>; DHIS 2
>>>> Developers list <dhis2-d...@lists.launchpad.net>
>>>> *Objet :* [Dhis2-users] DHIS2 users list from SQL View
>>>>
>>>>

Re: [Dhis2-users] [Dhis2-devs] DHIS2 users list from SQL View

[Jason Pickering]

Hi there.
We have had enough security problems lately, It may not be a good idea to
encourage even more of them.

This is a "good" way around the security attempts which have put in place,
but its a very bad idea to have this table as an SQL view. This was the
entire reason of why we attempted to protect it from direct access via SQL
views, but, the regular expression which does this does not catch the use
of the schema name. We will fix it

Of course, its easy enough to dump the password hash out with a small
change to the SQL view, but you would probably not want to do this.

See below for an example with a  small modification to your SQL view.


Regards,
Jason




   - "admin",
   - "$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C",
   - "Traore",
   - "John",
   - "some...@dhis2.org",
   - "",
   - "2017-04-11 13:24:55.914",
   - "2013-04-18 17:15:08.401",
   - "false",
   - "MNCH / PNC (Adult Woman) program",
   - "ZyjSDLHGPv4"


On Tue, Apr 11, 2017 at 3:01 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Hi Harivola,
>
> Thank you very much for the SQL scripts querying the users information.
> The syntax is accepted by SQL View, but I am a bit encountering a blank
> result as illustrated by the attached file. I am wondering where I am doing
> wrong?
>
> Thank you for your help!
>
> Regards,
>
> Tantely.
>
>
>
> On Tue, Apr 11, 2017 at 3:38 PM, Harivola RANDRIANJAFY 
> wrote:
>
>> Tantely,
>>
>>
>>
>> Below the SQL View :
>>
>>
>>
>> SELECT
>>
>> "public".users.username,
>>
>> "public".userinfo.surname,
>>
>> "public".userinfo.firstname,
>>
>> "public".userinfo.email,
>>
>> "public".userinfo.phonenumber,
>>
>> "public".users.lastlogin,
>>
>> "public".users.created,
>>
>> "public".users.disabled,
>>
>> "public".userrole."name",
>>
>> "public".users.uid
>>
>> FROM
>>
>> "public".users
>>
>> INNER JOIN "public".userinfo ON "public".users.userid =
>> "public".userinfo.userinfoid
>>
>> INNER JOIN "public".userrole ON "public".userrole.userid =
>> "public".userinfo.userinfoid
>>
>>
>>
>>
>>
>> Thanks,
>>
>> Harivola
>>
>>
>>
>> *De :* Dhis2-users [mailto:dhis2-users-bounces+harivolar=
>> psi...@lists.launchpad.net] *De la part de* Raminosoa Rabemanantsoa,
>> Tantely
>> *Envoyé :* lundi 10 avril 2017 17:19
>> *À :* DHIS 2 Users list ; DHIS 2
>> Developers list 
>> *Objet :* [Dhis2-users] DHIS2 users list from SQL View
>>
>>
>>
>> Dear Community,
>>
>>
>>
>> I would like to output from SQL View a list of all DHIS2 users by using
>> headers like the information listed by the users details information, like
>> illustrated by the image below (inside red ellipse).
>>
>>
>>
>>
>> ​
>>
>>
>>
>> I am using DHIS2 2.24. I would like to check the users table fields but I
>> could not output any information from the following query
>>
>>
>>
>> select * from users;
>>
>>
>>
>> as trhere are some protected info.
>>
>>
>>
>> My question is in which fields should I base the SQL query to output such
>> information?
>>
>>
>>
>> Thank you for your support,
>>
>>
>>
>> Regards,
>>
>>
>>
>> Tantely
>>
>> ​
>>
>>
>>
>>
>>
>>
>>
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>>
>> 
>>  Garanti
>> sans virus. www.avast.com
>> 
>>
>
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] storing/linking sequence metadata in DHIS2

[Jason Pickering]

Hi Andres,

As Johan mentioned, the best way to do this probably would be with an
option set.  Looking at NextStrains process, they import some metadata on
Ebola strains (
https://github.com/nextstrain/augur/blob/master/ebola/ebola.py#L117) and
process this into the format they need for the website. I think it should
be possible to do the same for DHIS2, and process this into an option set (
https://docs.dhis2.org/master/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_option_sets)
which could then be imported into your DHIS2 database. Once you have the
metadata in the correct format, it would just be a matter of importing it
as an option set into DHIS2. Once you do that, you could then use the
events module to link an event (like a case detection) .

The link you provided looks much more unstructured, so it might be more
difficult to parse and scrape this data.


Regards,
Jason




On Mon, Apr 10, 2017 at 4:48 AM, Andres Colubri <andres.colu...@gmail.com>
wrote:

> Hi Jason,
>
> Yes, in principle we would like to link a number of clinical cases with
> Ebola sequences such as these
> <https://www.ncbi.nlm.nih.gov/nuccore?term=257197[BioProject]>.
>
> But more generally, l we are interested in a number of viral pathogens in
> addition to Ebola (Lassa fever, Zika, etc).
>
> By using ETL process you mean that we should be able to integrate the
> sequence information directly into the DHIS2 DB?
>
> Andres
>
> On Fri, Apr 7, 2017 at 11:14 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Andres.
>>
>> There may be some overlap here with some other scripts we have written to
>> syncronize category options.
>>
>> Looking at this file
>>
>> https://github.com/nextstrain/fauna/blob/master/source-data/
>> flu_strain_name_fix.tsv
>>
>> is seems to be a bunch of flu strains. I guess something similar exists
>>  for Ebola?
>>
>> The approach we have taken with another system is to transform and import
>> these into DHIS2 through an ETL process. I think something similar might be
>> possible. It might be worth looking into and I would be happy to discuss
>> further with you about our approach.
>>
>> Regards,
>> Jason
>>
>>
>> On Fri, Apr 7, 2017 at 2:55 PM, Andres Colubri <andres.colu...@gmail.com>
>> wrote:
>>
>>> Hi Johan,
>>>
>>> Many thanks for your kind reply. Yes, that's correct, we would like to
>>> associate pathogen sequence data to clinical cases. It sounds like storing
>>> the link to the NCBI records in a metadata attribute would be the simplest
>>> solution, as long as the sequences are already deposited publicly somewhere
>>> else. Then the app would pull the links from the DHIS2 DB and retrieve the
>>> full sequences. We will look into it, and will get back with more questions.
>>>
>>> Best,
>>>
>>> Andres
>>>
>>> On Fri, Apr 7, 2017 at 4:00 AM, Johan Ivar Sæbø <joha...@ifi.uio.no>
>>> wrote:
>>>
>>>> Hi Andres,
>>>>
>>>> Welcome to the list! From what I understand, you want to associate a
>>>> given strain, such as MK13013 or the longer version Ebola
>>>> virus/H.sapiens-wt/SLE/2015/Makona-1309_C2_MK13013, with a clinical
>>>> case? That should be possible in several ways, either as a free text data
>>>> element, an option set, or as metadata attribute
>>>>
>>>> Take a look at some of the options in the manual:
>>>> Metadata attributes: https://docs.dhis2.org/master/
>>>> en/user/html/manage_attribute.html#about_attribute
>>>> Option sets: https://docs.dhis2.org/master/
>>>> en/user/html/manage_option_set.html
>>>>
>>>> If you want more of the meta-data such as the complete sequence, it
>>>> should in theory be possible, but a link to the ncbi would perhaps be the
>>>> best.
>>>>
>>>> Regards,
>>>> Johan Ivar Sæbø
>>>>
>>>> >-Original Message-
>>>> >From: Dhis2-users [mailto:dhis2-users-
>>>> >bounces+johansa=ifi.uio...@lists.launchpad.net] On Behalf Of Andres
>>>> >Colubri
>>>> >Sent: Thursday, April 06, 2017 3:40 PM
>>>> >To: dhis2-users@lists.launchpad.net
>>>> >Subject: [Dhis2-users] storing/linking sequence metadata in DHIS2
>>>> >
>>>> >I'm new to this mailing list, and to DHIS2 in general, so would like
>>>> to start by
>>>> >saying hi to everyone!
>>>> >
>>>

Re: [Dhis2-users] storing/linking sequence metadata in DHIS2

[Jason Pickering]

Hi Andres.

There may be some overlap here with some other scripts we have written to
syncronize category options.

Looking at this file

https://github.com/nextstrain/fauna/blob/master/source-data/flu_strain_name_fix.tsv

is seems to be a bunch of flu strains. I guess something similar exists
 for Ebola?

The approach we have taken with another system is to transform and import
these into DHIS2 through an ETL process. I think something similar might be
possible. It might be worth looking into and I would be happy to discuss
further with you about our approach.

Regards,
Jason


On Fri, Apr 7, 2017 at 2:55 PM, Andres Colubri 
wrote:

> Hi Johan,
>
> Many thanks for your kind reply. Yes, that's correct, we would like to
> associate pathogen sequence data to clinical cases. It sounds like storing
> the link to the NCBI records in a metadata attribute would be the simplest
> solution, as long as the sequences are already deposited publicly somewhere
> else. Then the app would pull the links from the DHIS2 DB and retrieve the
> full sequences. We will look into it, and will get back with more questions.
>
> Best,
>
> Andres
>
> On Fri, Apr 7, 2017 at 4:00 AM, Johan Ivar Sæbø 
> wrote:
>
>> Hi Andres,
>>
>> Welcome to the list! From what I understand, you want to associate a
>> given strain, such as MK13013 or the longer version Ebola
>> virus/H.sapiens-wt/SLE/2015/Makona-1309_C2_MK13013, with a clinical
>> case? That should be possible in several ways, either as a free text data
>> element, an option set, or as metadata attribute
>>
>> Take a look at some of the options in the manual:
>> Metadata attributes: https://docs.dhis2.org/master/
>> en/user/html/manage_attribute.html#about_attribute
>> Option sets: https://docs.dhis2.org/master/en/user/html/manage_option_set
>> .html
>>
>> If you want more of the meta-data such as the complete sequence, it
>> should in theory be possible, but a link to the ncbi would perhaps be the
>> best.
>>
>> Regards,
>> Johan Ivar Sæbø
>>
>> >-Original Message-
>> >From: Dhis2-users [mailto:dhis2-users-
>> >bounces+johansa=ifi.uio...@lists.launchpad.net] On Behalf Of Andres
>> >Colubri
>> >Sent: Thursday, April 06, 2017 3:40 PM
>> >To: dhis2-users@lists.launchpad.net
>> >Subject: [Dhis2-users] storing/linking sequence metadata in DHIS2
>> >
>> >I'm new to this mailing list, and to DHIS2 in general, so would like to
>> start by
>> >saying hi to everyone!
>> >
>> >
>> >I'm looking to create an DHIS2-based app that displays viral sequencing
>> >information on top of clinical cases (something along the lines of
>> NextStrain
>> > ). Is this
>> possible?
>> >Would I need to modify the underlying DataElement in dhis2-core to
>> support
>> >genetic metadata? Or would it be enough to add a reference to sequences
>> >stored elsewhere, for example in GenBank?
>> >
>> >Best,
>> >
>> >Andres
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Problem loading pivot table results

[Jason Pickering]

You maybe getting a "HTTP Error 414 Request URI too long" error in the
browser. This happens when the URL generated by the client is too big to be
handled by the HTTP server. Check the JS console in the browser and see.

Jan's method may work, but it will not work if you are getting that error.

Regards,
Jason



On Wed, Apr 5, 2017 at 9:06 AM, Jan Henrik Øverland  wrote:

> Hi Tantely,
>
> You can dump larger chunks of data by doing the following:
>
> - Open the pivot tables app
> - Select what you need in the left menu
> - Do not click "update" -  instead click the small down-arrow next to the
> update button and download as CSV
>
> Jan
>
> On 5 April 2017 at 08:32, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear Calle,
>>
>> Thank you for your suggestions. In order to dump the results, I have to
>> lower the number of OrgUnits by splitting them by parents OrgUnits and loop
>> the process unitl all OrgUnits are done.
>>
>> Regards,
>>
>> Tantely.
>>
>>
>> On Tue, Apr 4, 2017 at 11:00 AM, Calle Hedberg 
>> wrote:
>>
>>> Hi
>>>
>>> This is a common problem - the pivot table app cannot process/display
>>> larger sets of data, which is typically what you get when selecting the
>>> lowest OU level.
>>>
>>> Try dumping the result out into another format (CSV, Excel), and then
>>> process that into the report format you want.
>>>
>>> Regards
>>> Calle
>>>
>>> On 3 April 2017 at 13:05, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
 Dear DHIS2 community,


 We are using DHIS2 2.24. When we are running pivot table and are using
 some indicators by selecting the lowest level of OrgUnit (Community Health
 Workers), the application is running without any results output (an
 illustration is attached). The application is only responding when we are
 going up to a higher level in the OrgUnit tree. Are there some memories
 parameters to tune or what should be done to troubleshoot this issue, as we
 really need the results presented with the lowest OrgUnit. In the server
 side, we are using 16 cores CPU and 64 Gb of RAM.


 Thank you for your support,


 Regards,


 Tantely.

 *This message and its attachments are confidential and solely for the
 intended recipients. If received in error, please delete them and notify
 the sender via reply e-mail immediately.*

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


>>>
>>>
>>> --
>>>
>>> ***
>>>
>>> Calle Hedberg
>>>
>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>
>>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>>
>>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>>
>>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>>
>>> Email: calle.hedb...@gmail.com
>>>
>>> Skype: calle_hedberg
>>>
>>> ***
>>>
>>>
>>
>>
>>
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jan Henrik Øverland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org 
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Limit on data attribute - category options

[Jason Pickering]

Yes, you can  use "Sharing" controlled with user groups. However, it can
get complex quickly, and usually requires very careful user management
routines, coupled with automatic scripting to get it right.



On Mon, Apr 3, 2017 at 9:31 AM, Marc Garnica 
wrote:

> Dear all,
>
> This is also a requirement for us but we are wondering if it is possible
> to implement a "user" visibility of the data sets category options. For
> example a user from Spain only being acessible to the Spain Implementer
> Partners or a user only accessing to the category options where he's in
> charge to enter data.
>
> Thanks a lot!
> Marc Garnica
>
> 2017-04-03 9:15 GMT+02:00 Sam Kasozi :
>
>> Yes, we do have fixed relationships within those categories, so this
>> works for us!
>>
>> This implementation is much safer as well since it will not require a
>> data entrant to filter through the different categories.
>>
>>
>> Thank you.
>>
>> Sam Kasozi
>> +256 788-993-565
>> Skype: sam.kasoziug
>>
>> On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Sam,
>>>
>>> yes it should be possible to set this up in DHIS 2.
>>>
>>> In your case, if you create all 4 as categories you might end up with a
>>> very high number of option combo permutations.
>>>
>>> However, it might be that you have fixed relationships within those
>>> categories. For example, it could be that one grant is supported by exactly
>>> one implementing partner and donor. In that case, you should not ask end
>>> users to actively select partner and donor in data entry; rather have them
>>> select the grant only (as a data set category). From there, you can set up
>>> category option groups and group sets:
>>>
>>> Group set: Donor
>>> Groups: USAID, DFID, etc
>>>
>>> Group set: Implementing partner
>>> Groups: PartnerA, PartnerB, etc
>>>
>>> Then you assign each grant to exactly one group per group set. You can
>>> now do analytics based on the above dimensions without having end users
>>> explicitly selecting them in data entry. This will keep number of category
>>> option combos low and reduce time and errors during data entry. Make sure
>>> you set the category option group sets as "data dimension".
>>>
>>> Docs here
>>> .
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>>
>>> On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi  wrote:
>>>
 We would like to add the data attributes: Donor, Program, Implementing
 Partner and Grant in a category combination to some datasets.

 Looking at the data that needs to be imported, the Donors and Programs
 are few, however, the IPs and grants are in the range of 200 and 500
 respectively; of course with potential to increase over time.

 I am wondering if the DHIS2 is designed to manage that kind of data.


 regards,

 Sam Kasozi
 +256 788-993-565
 Skype: sam.kasoziug

 ___
 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


>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> l...@dhis2.org
>>> http://www.dhis2.org 
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Data Set Report is not Downloading to Excel

[Jason Pickering]

Hi Gerald,
Check the server logs when  you make the API call below. There seems to be
an error here.

https://sl.dhis2.org/hmis/api/dimensions/dataSet/UQGPrAQtDIV.json [HTTP/1.1
409 Conflict 435ms]

Regards,
Jason

On Sat, Mar 25, 2017, 05:01 gerald thomas <gerald17...@gmail.com> wrote:

> Dear Jason,
> The only error found during the data set report process:
>
> https://sl.dhis2.org/hmis/api/dataStatistics [HTTP/1.1 201 Created 184ms]
> XML Parsing Error: no root element found
> Location:
> https://sl.dhis2.org/hmis/api/dataStatistics?eventType=DATA_SET_REPORT_VIEW=UQGPrAQtDIV
>
>
>
> On 3/24/17, Jason Pickering <jason.p.picker...@gmail.com> wrote:
> > Ok. Please post it.
> >
> > This error likely results from invalid HTML in your data set report form.
> >
> > On Fri, Mar 24, 2017, 18:10 gerald thomas <gerald17...@gmail.com> wrote:
> >
> >> Dear Jason,
> >> I am receiving a parse error when I execute the report
> >>
> >> On Mar 24, 2017 22:05, "Jason Pickering" <jason.p.picker...@gmail.com>
> >> wrote:
> >>
> >> Are there any errors in the browser console or the server when  you
> >> execute the report?
> >>
> >> On Fri, Mar 24, 2017, 18:02 gerald thomas <gerald17...@gmail.com>
> wrote:
> >>
> >> Dear Jason,
> >> It is a custom form but there is no JavaScript on it.
> >>
> >>
> >> On Mar 24, 2017 20:17, "Jason Pickering" <jason.p.picker...@gmail.com>
> >> wrote:
> >>
> >> Custom forms MAY work in dataset reports, but it depends. Are you
> getting
> >> any JavaScript errors in the dataset reports? Any server errors?
> >> Are you using any custom JavaScript in your forms?
> >>
> >> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo <d...@baosystems.com>
> >> wrote:
> >>
> >> Hi Gerald,
> >> Unfortunately custom forms are not properly handled in dataset reports.
> A
> >> work around will be to  “print" the dataset report output to pdf using
> >> Chrome.
> >> ….
> >>
> >>
> >>
> >> *Dapo Adejumo*
> >>
> >> On 24 Mar 2017, at 14:46, Mohamed Bangura <mbang...@gmail.com> wrote:
> >>
> >> Dear Gerald,
> >> Use mozilla firefox to extract the data.
> >> Do Ctrl A,Ctrl C
> >> Open your blank excel and do ctrl V.
> >> Hope this helps.
> >> On 3/24/17, gerald thomas <gerald17...@gmail.com> wrote:
> >>
> >> Dear all,
> >> Please i need your your help it is urgent.
> >>
> >> On 3/23/17, gerald thomas <gerald17...@gmail.com> wrote:
> >>
> >> Dear All,
> >> I am having problems downloading Data Set report to excel or pdf. I am
> >> using version 2.25. It is working on demo but not on my instance.
> >> Please can someone help me with a fix.
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >>
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >> ___
> >> 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-devs
> >> Post to : dhis2-d...@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >>
> >>
> >> --
> >> Jason P. Pickering
> >> email: jason.p.picker...@gmail.com
> >> tel:+46764147049 <+46%2076%20414%2070%2049>
> >>
> >>
> >
>
>
> --
> Regards,
>
> Gerald
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Data Set Report is not Downloading to Excel

[Jason Pickering]

Ok. Please post it.

This error likely results from invalid HTML in your data set report form.

On Fri, Mar 24, 2017, 18:10 gerald thomas <gerald17...@gmail.com> wrote:

> Dear Jason,
> I am receiving a parse error when I execute the report
>
> On Mar 24, 2017 22:05, "Jason Pickering" <jason.p.picker...@gmail.com>
> wrote:
>
> Are there any errors in the browser console or the server when  you
> execute the report?
>
> On Fri, Mar 24, 2017, 18:02 gerald thomas <gerald17...@gmail.com> wrote:
>
> Dear Jason,
> It is a custom form but there is no JavaScript on it.
>
>
> On Mar 24, 2017 20:17, "Jason Pickering" <jason.p.picker...@gmail.com>
> wrote:
>
> Custom forms MAY work in dataset reports, but it depends. Are you getting
> any JavaScript errors in the dataset reports? Any server errors?
> Are you using any custom JavaScript in your forms?
>
> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo <d...@baosystems.com> wrote:
>
> Hi Gerald,
> Unfortunately custom forms are not properly handled in dataset reports. A
> work around will be to  “print" the dataset report output to pdf using
> Chrome.
> ….
>
>
>
> *Dapo Adejumo*
>
> On 24 Mar 2017, at 14:46, Mohamed Bangura <mbang...@gmail.com> wrote:
>
> Dear Gerald,
> Use mozilla firefox to extract the data.
> Do Ctrl A,Ctrl C
> Open your blank excel and do ctrl V.
> Hope this helps.
> On 3/24/17, gerald thomas <gerald17...@gmail.com> wrote:
>
> Dear all,
> Please i need your your help it is urgent.
>
> On 3/23/17, gerald thomas <gerald17...@gmail.com> wrote:
>
> Dear All,
> I am having problems downloading Data Set report to excel or pdf. I am
> using version 2.25. It is working on demo but not on my instance.
> Please can someone help me with a fix.
>
> --
> Regards,
>
> Gerald
>
>
>
> --
> Regards,
>
> Gerald
>
> ___
> 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-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Data Set Report is not Downloading to Excel

[Jason Pickering]

Are there any errors in the browser console or the server when  you execute
the report?

On Fri, Mar 24, 2017, 18:02 gerald thomas <gerald17...@gmail.com> wrote:

> Dear Jason,
> It is a custom form but there is no JavaScript on it.
>
>
> On Mar 24, 2017 20:17, "Jason Pickering" <jason.p.picker...@gmail.com>
> wrote:
>
> Custom forms MAY work in dataset reports, but it depends. Are you getting
> any JavaScript errors in the dataset reports? Any server errors?
> Are you using any custom JavaScript in your forms?
>
> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo <d...@baosystems.com> wrote:
>
> Hi Gerald,
> Unfortunately custom forms are not properly handled in dataset reports. A
> work around will be to  “print" the dataset report output to pdf using
> Chrome.
> ….
>
>
>
> *Dapo Adejumo*
>
> On 24 Mar 2017, at 14:46, Mohamed Bangura <mbang...@gmail.com> wrote:
>
> Dear Gerald,
> Use mozilla firefox to extract the data.
> Do Ctrl A,Ctrl C
> Open your blank excel and do ctrl V.
> Hope this helps.
> On 3/24/17, gerald thomas <gerald17...@gmail.com> wrote:
>
> Dear all,
> Please i need your your help it is urgent.
>
> On 3/23/17, gerald thomas <gerald17...@gmail.com> wrote:
>
> Dear All,
> I am having problems downloading Data Set report to excel or pdf. I am
> using version 2.25. It is working on demo but not on my instance.
> Please can someone help me with a fix.
>
> --
> Regards,
>
> Gerald
>
>
>
> --
> Regards,
>
> Gerald
>
> ___
> 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-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Data Set Report is not Downloading to Excel

[Jason Pickering]

Custom forms MAY work in dataset reports, but it depends. Are you getting
any JavaScript errors in the dataset reports? Any server errors?
Are you using any custom JavaScript in your forms?

On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo  wrote:

> Hi Gerald,
> Unfortunately custom forms are not properly handled in dataset reports. A
> work around will be to  “print" the dataset report output to pdf using
> Chrome.
> ….
>
>
>
> *Dapo Adejumo*
>
> On 24 Mar 2017, at 14:46, Mohamed Bangura  wrote:
>
> Dear Gerald,
> Use mozilla firefox to extract the data.
> Do Ctrl A,Ctrl C
> Open your blank excel and do ctrl V.
> Hope this helps.
> On 3/24/17, gerald thomas  wrote:
>
> Dear all,
> Please i need your your help it is urgent.
>
> On 3/23/17, gerald thomas  wrote:
>
> Dear All,
> I am having problems downloading Data Set report to excel or pdf. I am
> using version 2.25. It is working on demo but not on my instance.
> Please can someone help me with a fix.
>
> --
> Regards,
>
> Gerald
>
>
>
> --
> Regards,
>
> Gerald
>
> ___
> 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-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] CSV import for translations

[Jason Pickering]

Hi Georgi,

I think the best solution would be a script which would handle the CSV
file, until it gets reimplemented in the core. It should be pretty
straightforward. If you can send me an example, I should be able to provide
a simple script to deal with the uploading of the translations to the
server from a CSV file.


Regards,
Jason


On Thu, Mar 16, 2017 at 10:08 AM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:

> I have new clients that are already set up in 2.25. Do you suggest to
> downgrade to 2.24, upload and upgrade to 2.25?
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Thursday, March 16, 2017 11:07 AM
> *To:* Georgi Chakarov 
> *Cc:* dhis2-users@lists.launchpad.net; Morten Olav Hansen <
> mor...@dhis2.org>
>
> *Subject:* Re: [Dhis2-users] CSV import for translations
>
>
>
> I suppose you could import to 2.24 and upgrade.
>
>
>
> On Mar 16, 2017 4:00 PM, "Georgi Chakarov" 
> wrote:
>
> Hello Morten,
>
>
>
> Thanks a lot for the quick response! I will definitely report this issue
> in JIRA, because it is really handy and also quicker to compile all
> translation in excel and then quickly import in DHIS2. I’ve had clients
> with 500+ data elements and 150+ indicators, so translation names, short
> names and description for these object could be quite a big task.
>
>
>
> Thanks again,
>
>
>
> Georgi
>
>
>
> *From:* Morten Olav Hansen [mailto:mor...@dhis2.org]
> *Sent:* Thursday, March 16, 2017 8:44 AM
> *To:* Georgi Chakarov 
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] CSV import for translations
>
>
>
> Hi Georgi
>
>
>
> We don't currently support bulk import of translations anymore, as you
> might have noticed the model has changed a bit when it comes to
> translations. The way it works now, is that the translations are directly
> on the object itself, so what is possible.. is to download the full object
> and then add your translations in the translation array.
>
>
>
> { .., translations: [{locale: "", property: 
> NAME/SHORT_NAME/DESCRIPTION/FORM_NAME,
> value: ""}] }
>
>
>
> In 226, we also have a new translation app included in the core.
>
>
>
> I understand that bulk imports can be useful, so please feel free to
> create an issue for it in JIRA (jira.dhis2.org) and we will try and have
> a look at it for 227.
>
>
> --
>
> Morten Olav Hansen
>
> Senior Engineer, DHIS 2
>
> University of Oslo
>
> http://www.dhis2.org
>
>
>
> On Wed, Mar 15, 2017 at 10:55 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hello!
>
> A quick question on translations: Has csv import for translations been
> removed in DHIS2 versions higher than 2.23?
>
>
>
> I was using 2.23 and imported translation for various objects using csv
> files. Now I am using 2.25 and although in the Import/Export app this
> functions appears to be available nothing happens when I try to import
> translations. Any idea?
>
>
>
> Is there a way I can bulk import translations in 2.25?
>
>
>
> Thanks in advance!
>
> Georgi
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@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
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Event importer

[Jason Pickering]

Hi there.
Looks like a problem parsing the date.

Could you change

2016-11-13T17:00:00.000+

to

2016-11-13

And see if that helps?

Regards,
Jason



On Fri, Feb 24, 2017 at 1:37 AM, Furqonuddin Ramdhani 
wrote:

> I'm also have problem using event import function.
>
> *In the browser I got error :*
> 2017-02-24 00:29:38 Process failed: Invalid format: ""
> 2017-02-24 00:29:38 Importing events
>
> *In the log file :*
> * ERROR 2017-02-24 07:29:38,403 java.lang.IllegalArgumentException:
> Invalid format: ""
> at org.joda.time.format.DateTimeFormatter.parseDateTime(
> DateTimeFormatter.java:899)
> at org.hisp.dhis.system.util.DateUtils.parseDate(DateUtils.
> java:665)
> at org.hisp.dhis.dxf2.events.event.AbstractEventService.saveEvent(
> AbstractEventService.java:1026)
> at org.hisp.dhis.dxf2.events.event.AbstractEventService.
> addEvent(AbstractEventService.java:417)
> at org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvents(
> AbstractEventService.java:209)
> at org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvents(
> AbstractEventService.java:229)
> at sun.reflect.GeneratedMethodAccessor1254.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.springframework.aop.support.AopUtils.
> invokeJoinpointUsingReflection(AopUtils.java:317)
> 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.
> TransactionInterceptor$1.proceedWithInvocation(
> TransactionInterceptor.java:99)
> at org.springframework.transaction.interceptor.
> TransactionAspectSupport.invokeWithinTransaction(
> TransactionAspectSupport.java:281)
> at org.springframework.transaction.interceptor.
> TransactionInterceptor.invoke(TransactionInterceptor.java:96)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:179)
> at org.springframework.aop.framework.JdkDynamicAopProxy.
> invoke(JdkDynamicAopProxy.java:207)
> at com.sun.proxy.$Proxy375.addEvents(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor1254.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.springframework.aop.support.AopUtils.
> invokeJoinpointUsingReflection(AopUtils.java:317)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> invokeJoinpoint(ReflectiveMethodInvocation.java:190)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:157)
> at org.springframework.aop.support.DelegatingIntroductionIntercep
> tor.doProceed(DelegatingIntroductionInterceptor.java:133)
> at org.springframework.aop.support.DelegatingIntroductionIntercep
> tor.invoke(DelegatingIntroductionInterceptor.java:121)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:179)
> at org.springframework.aop.framework.JdkDynamicAopProxy.
> invoke(JdkDynamicAopProxy.java:207)
> at com.sun.proxy.$Proxy343.addEvents(Unknown Source)
> at org.hisp.dhis.dxf2.events.event.ImportEventsTask.call(
> ImportEventsTask.java:63)
> at org.hisp.dhis.security.SecurityContextRunnable.run(
> SecurityContextRunnable.java:57)
> at org.springframework.scheduling.support.
> DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
> e.java:54)
> at java.util.concurrent.Executors$RunnableAdapter.
> call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
>  (AbstractEventService.java [taskScheduler-3])
> * INFO  2017-02-24 07:29:38,403 [Level: ERROR, category: EVENT_IMPORT,
> time: Fri Feb 24 07:29:38 WIB 2017, message: Process failed: Invalid
> format: ""] (InMemoryNotifier.java [taskScheduler-3])
>
> I attached my sample data. any suggestion ?
>
> Regards,
> Dhani
>
>
> On Tue, Jan 24, 2017 at 5:54 PM, channara rin 

Re: [Dhis2-users] [Dhis2-devs] Accessing the latest dhis2 builds

[Jason Pickering]

Hi Calle,

Wget is freely available for Windows.

http://unxutils.sourceforge.net/


I will have a look at the CI server, as the reverse proxy configuration
could potentially be causing an issue.

Regards,
Jason


On Mon, Feb 20, 2017 at 3:32 PM, Calle Hedberg 
wrote:

> Knut,
>
> The wget one probably do work better, since I have no complaints related
> to this from our infrastructure team (we are running 150-200 DHIS2
> instances, so they download updates regularly). But I'm using Windows on my
> laptop, so wget won't work.
>
> Regards
> Calle
>
> On 20 February 2017 at 16:19, Knut Staring  wrote:
>
>> Hi Calle,
>>
>> I also had this problem with the ci.dhis2.org link when I was in Burma.
>> But I found the other link that Lars and Morten pointed to to work much
>> better.
>>
>> Knut
>>
>> On Mon, Feb 20, 2017 at 2:26 PM, Calle Hedberg 
>> wrote:
>>
>>> Timothy,
>>>
>>> There is definitely something wrong with the configuration of the server
>>> that provides war files - it bails out immediately if there are delays in
>>> the download, or if you are on a slow connection. This is a relatively
>>> recent problem that appeared a few months ago.
>>>
>>> I discovered this the first time over Christmas, when I was trying to
>>> download a war file from my sister's place (in Norway) - she had a slow
>>> internet connection, and the download kept on bombing out, usually after
>>> downloading the first ~12mb.
>>>
>>> I discussed it with Lars in early January. His advice was the same as
>>> now, to use a download manager - but I have tried that, and it does not
>>> work.
>>>
>>> I've had similar reports from a number of people now, with the only
>>> workable solution being for me or somebody on a faster connection to
>>> download the war file and then make it available on another platform.
>>>
>>> My current home office connection is a 7mbits ADSL line, and download
>>> works OK here - AS LONG AS I ONLY DOWNLOAD ONE WAR FILE AT A TIME.
>>>
>>> On 20 February 2017 at 14:28, Morten Olav Hansen 
>>> wrote:
>>>
 You can also use wget if you are on a unix system (which your server
 probably is)

 wget -c https://www.dhis2.org/download/releases/2.26/dhis.war

 (if it times out or disconnects... just run same command again and it
 will continue)

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

 On Mon, Feb 20, 2017 at 8:20 PM, Lars Helge Øverland 
 wrote:

> Hi Tim,
>
> you can get the latest WAR builds from here:
>
> https://www.dhis2.org/downloads
>
> You can also consider using a download manager with resume
> capabilities:
>
> https://chrome.google.com/webstore/detail/chrono-download-ma
> nager/mciiogijehkdemklbdcbfkefimifhecn
>
>
> regards,
>
> Lars
>
> On Mon, Feb 20, 2017 at 1:08 PM, Timothy Kiyemba 
> wrote:
>
>> Dear all,
>>
>> Can some one help me access the latest build for DHIS2 2.26. I have
>> tried accessing it from
>>
>> https://ci.dhis2.org/job/dhis2-2.26/lastSuccessfulBuild/arti
>> fact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>>
>> But my downloads are not succeeding in completing. Could I be
>> accessing the wrong way? Is there a better way to get a successfull
>> download?
>>
>> Or can someone share with me a copy via googledocs?
>>
>> Timothy
>>
>> ___
>> 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 
>
>
> ___
> 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


>>>
>>>
>>> --
>>>
>>> ***
>>>
>>> Calle Hedberg
>>>
>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>
>>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>>
>>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>>
>>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>>
>>> 

Re: [Dhis2-users] [Dhis2-devs] Period name based on startdate or enddate?

[Jason Pickering]

Hi Tantley,

Have a look at the "_periodstructure" resource table. The name of the
period is there.

Regards,
Jason


On Thu, Feb 16, 2017 at 8:36 AM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> DearCommunity,
>
> We are running SQL code to output data from the SQL View module. We get
> the following table for an organization unit accross multiple periods
> containing results with *startdate* and *enddate*. We have set up the
> period to "*Monthly*".
>
> In order to output the Period name (i.e. January 2017 or 201701), shoud we
> consider the sartdate or enddate (from period table)? Here in this example,
> we could observe the month repeating both for startdate and enddate. In our
> understanding, each value for each category should be unique for each
> month. Or is there another table containing already the period name that we
> have to base the SQL query?
>
>
> [image: Inline image 1]
>
> Thank you for your support!
>
> Kind Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] My DHIS2 Reports app not loading

[Jason Pickering]

>From the look of this error, it seems that you have not assigned this user
to any organisation units?

Regards,
Jason



XML Parsing Error: no root element found
Location: http://localhost:8080/misca/api/legendSets.json?fields=id,
displayName|rename(name),legends[id,displayName|rename(
name),startValue,endValue,color]=false&_dc=1486985622680
Line Number 1, Column 1:  legendSets.json:1:1
XML Parsing Error: no root element found
Location: http://localhost:8080/misca/api/organisationUnitLevels.
json?fields=id,displayName|rename(name),level=false&_dc=1486985622677
Line Number 1, Column 1:  organisationUnitLevels.json:1:1
XML Parsing Error: no root element found
Location: http://localhost:8080/misca/api/organisationUnits.json?
userDataViewFallback=true=false=id,
displayName|rename(name)&_dc=1486985622676
Line Number 1, Column 1:  organisationUnits.json:1:1
XML Parsing Error: no root element found
Location: http://localhost:8080/misca/api/dimensions.json?fields=id,
displayName|rename(name)=dimensionType:eq:
ORGANISATION_UNIT_GROUP_SET=false&_dc=1486985622681
Line Number 1, Column 1:  dimensions.json:1:1

On Mon, Feb 13, 2017 at 2:48 PM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Timothy,
>
> If you are using the latest version of 2.26, then the more stringent
> validation of URL characters in recent versions of Tomcat should be
> supported (for details on the 8.5.x changes, see http://tomcat.apache.org/
> tomcat-8.5-doc/changelog.html )
>
> If your logs still indicate that this is a tomcat issue, try upgrading to
> tomcat 8.5.11 - if that don't work then downgrade to 8.0.36
>
> Regards
> Calle
>
> On 13 February 2017 at 13:20, Jason Pickering <jason.p.picker...@gmail.com
> > wrote:
>
>> The important thing to look for is a JavaScript error from the server,
>> namely an HTTP 400 error code. Could you sent your JavaScript console when
>> you load the app?
>>
>> On Mon, Feb 13, 2017 at 5:57 PM, Timothy Kiyemba <tkiye...@gmail.com>
>> wrote:
>>
>>> Dear Gerald,
>>>
>>> I have tried replacing the war file but the problem persists. See
>>> attached my catalina log file. I am working with Tomcat 8.5.8 and DHIS2
>>> 2.26. Jason, do I still need to downgrade my Tomcat to 8.0.36? All my apps
>>> work except the Event reports app.
>>>
>>> Kind regards
>>>
>>> Timothy
>>>
>>>
>>>
>>> On Mon, Feb 13, 2017 at 9:48 AM, gerald thomas <gerald17...@gmail.com>
>>> wrote:
>>>
>>>> Timothy,
>>>> Please run maintenance and delete war file and name of folder which has
>>>> the name of your war file. Download a new war and tail -f
>>>> /path/Catalina.out if there is no error then everything should be fine.
>>>> Kindly note I am saying "/path/" because I don't the path of your logs.
>>>> Also tomcat must be stop before deleting war file and folder and "tail" the
>>>> logs before starting tomcat.
>>>> Wishing you the best.
>>>>
>>>> On Feb 13, 2017 06:26, "timothy kiyemba" <tkiye...@gmail.com> wrote:
>>>>
>>>>> Anybody with a solution to this problem?
>>>>> --
>>>>> From: Timothy Kiyemba <tkiye...@gmail.com>
>>>>> Sent: ‎12/‎02/‎2017 21:59
>>>>> To: dhis2-devs <dhis2-d...@lists.launchpad.net>; dhis2-users
>>>>> <dhis2-users@lists.launchpad.net>
>>>>> Subject: My DHIS2 Reports app not loading
>>>>>
>>>>> Dear all
>>>>>
>>>>> Has any one faced this challenge before, my DHIS2 reports app is not
>>>>> loading. It just shows that its loading but it never completes. Could I
>>>>> have missed out a step somewhere? See image below;
>>>>>
>>>>> [image: Inline image 1]
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>

Re: [Dhis2-users] [Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

[Jason Pickering]

Hi Tantely,

Well, you can use  a series of union statements to create a column for each
of your data elements, but it might get unwieldy.

You can  also use the "tablefunc" tools to generate such a cross tab. Its
documented here

https://www.postgresql.org/docs/9.5/static/tablefunc.html

Regards,
Jason


On Tue, Feb 14, 2017 at 9:37 AM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear Community,
>
>
> With DHIS2 2.24, I am trying to output raw data in a matrix format. I have
> used SQL View to output the data. Data values table is presented as
> following:
>
>
> *orgUnit UID,  dataElement1, Value, Period*
>
> *orgUnit UID,  dataElement2, Value, Period*
>
> *orgUnit UID,  dataElement3, Value, Period*
>
> *orgUnit UID,  dataElement4, Value, Period*
>
> *...*
>
>
> I have used the following code:
>
>
> select dv.sourceid as organisationunitid, ou.name, ou.shortname, ou.code
> as CodeAC, de.name as intitule, pe.startdate, pe.enddate,
> coc.categoryoptioncomboname, dv.value from datavalue dv inner join
> organisationunit ou on (dv.sourceid=ou.organisationunitid) inner join
> dataelement de on (dv.dataelementid=de.dataelementid) inner join period
> pe on (pe.startdate='2016-02-01') inner join _categoryoptioncomboname coc
> on (dv.categoryoptioncomboid=coc.categoryoptioncomboid) where
> dv.dataelementid in (select dataelementid from datasetmembers where
> datasetid in (select datasetid from dataset where name='dataSetName'));
>
>
>
> I would like to output “raw data” for each orgUnit as following:
>
>
>
> *orgUnit UID,  dataElement1, Value, dataElement2, Value, dataElement3,
> Value, dataElement4,  Value, Period*
>
> *...*
>
>
>
> I have used pivot tables , but it is each time doing data agregation of
> the dataElement.
>
>
>
> How should I arrange the SQL code in order to have this result?
>
>
>
> Kind Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] My DHIS2 Reports app not loading

[Jason Pickering]

Its hard to say if this is the same issue but it probably is.

The issue is described here

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer version of Tomcat do not allow for the "|" character in
URLs. So, if you have upgraded your operating system to a version which has
this version of Tomcat and it does not work you have two choices.

1) Downgrade Tomcat to a version which does work. I beleive 8.0.36 is known
to work.
2) Upgrade DHIS2 to a version which fixes this issue, which should be a
later build of 2.24, 2.25 or 2.26.


Regards,
Jason




On Mon, Feb 13, 2017 at 3:20 PM, gerald thomas 
wrote:

> Kamugunga,
> If he had provided the logs then that should had been easy to confirm but
> currently the information seem like a bug on the war file. So the best
> option is to replace the war file and monitor the logs. If it is a tomcat
> issue it will definitely show on the logs.
>
> On Feb 13, 2017 08:14, "Kamugunga Adolphe"  wrote:
>
> Dear Gerald,
> This could be also related to your tomcat version, we had the similar
> issue here in Rwanda with data visualizer, pivot and event report apps not
> loading after upgrading to dhis 2.24. We have upgraded to our tomcat from
> 7.052  to  7.0.68 and it worked.
>
> Please trace back Bob,Lars, and Jason discussion on the tomcat version for
> the new dhis2 releases.
>
> Regards.
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> Mobile: +250 788 740 578 <+250%20788%20740%20578>
> Email:kaa...@gmail.com
> Skype: ka.adolphe
>  RWANDA
>
>
> On 13 February 2017 at 08:48, gerald thomas  wrote:
>
>> Timothy,
>> Please run maintenance and delete war file and name of folder which has
>> the name of your war file. Download a new war and tail -f
>> /path/Catalina.out if there is no error then everything should be fine.
>> Kindly note I am saying "/path/" because I don't the path of your logs.
>> Also tomcat must be stop before deleting war file and folder and "tail" the
>> logs before starting tomcat.
>> Wishing you the best.
>>
>> On Feb 13, 2017 06:26, "timothy kiyemba"  wrote:
>>
>>> Anybody with a solution to this problem?
>>> --
>>> From: Timothy Kiyemba 
>>> Sent: ‎12/‎02/‎2017 21:59
>>> To: dhis2-devs ; dhis2-users
>>> 
>>> Subject: My DHIS2 Reports app not loading
>>>
>>> Dear all
>>>
>>> Has any one faced this challenge before, my DHIS2 reports app is not
>>> loading. It just shows that its loading but it never completes. Could I
>>> have missed out a step somewhere? See image below;
>>>
>>> [image: Inline image 1]
>>>
>>> ___
>>> 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-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] heads up on tomcat versions and dhis

[Jason Pickering]

Lars had advised me this would not be easy, as this fix would need to be
made in several apps.

I did not have time to figure out exactly which Tomcat package would work,
but your approach sounds reasonable to me. We took a temporary route and
used one we knew would work until the upgrade to at least 2.24 is feasible.

On Wed, Feb 1, 2017, 18:38 Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Thanks Jason.  To make matters more complicated it looks like ubuntu
> maintains its own patch release numbering of tomcat.  So for example it
> looks like the problem first raised in Zim after
> upgrading 7.0.52-1ubuntu0.7 to 7.0.52-1ubuntu0.8.
>
> They can try to rewind that upgrade to see if good behaviour is restored.
>
> Then I believe you can hold back further upgrades to certain packages
> with apt-mark hold .  We'll see.
>
> How painful is it to patch dhis2 older versions?  I was looking (without
> success) for relevant github commit.
>
>
>
> On 1 February 2017 at 11:54, Jason Pickering <jason.p.picker...@gmail.com>
> wrote:
>
> Hi Bob,
>
> https://archive.apache.org/dist/tomcat/tomcat-8/v8.0.35/
>
> is known to work in this situation for me. Lars suggested this version and
> it worked for us.
>
> We had the exact same thing happen on another instance, which basically
> "broke" dhis2-tools, so for the time being, we are using this specific
> version of Tomcat as a local install to work around the problem until that
> instance can be upgraded.
>
> Specifically, it was this commit  (thanks to BAO for finding it)
>
>
> https://github.com/apache/tomcat70/commit/a3d7be9e35505f85fc01f5f36451c710f9c9bbcc
>
> which introduced this, which seems to be Tomcat 7.0.73, so something
> earlier than that should work as well. I am not sure which commit this was
> in Tomcat 8.
>
> Hope that helps.
>
> Regards,
> Jason
>
>
> On Wed, Feb 1, 2017 at 6:06 PM, Bob Jolliffe <bobjolli...@gmail.com>
> wrote:
>
> Hi Lars and all
>
> I can see this is going to cause quite a bit of chaos with large country
> installations where they are not able to be too agile with upgrading.
>
> Do you have more precise info on the exact tomcat version numbers?  We
> just saw in Zim (DHIS 2.22) that the package manager automatically upgraded
> to 7.0.52 and they started seeing these problems.  So maybe it is that
> version?
>
> They will have to try and come up with a process of downgrading tomcat and
> holding that version via the package manager as a short term measure while
> they plan any dhis2 upgrade process.
>
> So getting the exact tomcat versions where the URL checking was introduced
> will be helpful if you have them.
>
> On 7 January 2017 at 12:56, Lars Helge Øverland <l...@dhis2.org> wrote:
>
> Hi all,
>
> the latest builds of tomcat (the servlet container mostly used with DHIS
> 2) has tightened up validation of characters in URLs, so that only
> characters defined as safe per RFC 1738
> <https://www.ietf.org/rfc/rfc1738.txt> are allowed. Our apps had some
> cases of un-escaped use of the pipe character which was causing tomcat to
> occasionally return 400 bad request.
>
> We have patched this now in 2.24, 2.25 and master.
>
> Bottom line: If you plan to upgrade to very latest Tomcat 7, 8 or 8.5
> builds on your server, make sure to upgrade to latest 2.24 or 2.25 of DHIS
> 2.
>
>
> regards,
>
> Lars
>
>
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.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
>
>
>
> ___
> 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
>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
>
>
___
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