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

[Raminosoa Rabemanantsoa, Tantely]

Hello Jason,

Thank you for your support!

Regards,

*Tantely*

On Wed, Nov 22, 2017 at 11:39 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

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

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Reset DataSet completeness to 0 (incomplete)

[Raminosoa Rabemanantsoa, Tantely]

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,
if we know the Orgunit uid, period and DataSet uid to reset? I am using
DHIS2 2.25.

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Troubleshoot DHIS2 Admin account -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Hi Georgi,

Re-selecting the OrgUnits from the user's profile has fixed the issue.

Thank you!

Best,

Tantely.



On Sun, Oct 15, 2017 at 11:17 PM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:

> Hi,
>
>
>
> For the users that experience this problem, try deselecting the
> organization units from their profiles and assign them only to the top
> level. Clean cache and see if this helps.
>
>
>
> Georgi
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+georgi=
> logicaloutcomes@lists.launchpad.net] *On Behalf Of *Raminosoa
> Rabemanantsoa, Tantely
> *Sent:* Sunday, October 15, 2017 10:52 PM
> *To:* DHIS 2 Users list ; DHIS 2
> Developers list 
> *Subject:* [Dhis2-users] Troubleshoot DHIS2 Admin account -- DHIS2 2.25
>
>
>
> Dear Community,
>
>
>
> I would like to have some advice to troubleshoot the account where the
> orgunits at lower level (inside red rectangle) are displayed at the same
> hierarchy as the higher level. The two accounts have admin access to DHIS2
> (2.25). There are some illustrations of the Maintenance (Organisation Unit)
> App.
>
>
>
> ​The following picture illustrates the account to troubleshoot: The
> orgunits at lower level (inside red rectangle) are always displayed at the
> same hierarchy as the higher level.
>
> ​The following  picture illustrates the correct appearance of the OrgUnit
> hierarchy with the other account.
>
>
>
>
>
> I thought to delete the account with the abnormal behaviour and re-create
> it afterwards, but I am not sure if there are some associated parameters
> associated with this account (saved favorites, ...) that will be deleted
> with it?
>
>
>
>
>
> 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.*
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Troubleshoot DHIS2 Admin account -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

I would like to have some advice to troubleshoot the account where the
orgunits at lower level (inside red rectangle) are displayed at the same
hierarchy as the higher level. The two accounts have admin access to DHIS2
(2.25). There are some illustrations of the Maintenance (Organisation Unit)
App.


​The following picture illustrates the account to troubleshoot: The
orgunits at lower level (inside red rectangle) are always displayed at the
same hierarchy as the higher level.



​The following  picture illustrates the correct appearance of the OrgUnit
hierarchy with the other account.





I thought to delete the account with the abnormal behaviour and re-create
it afterwards, but I am not sure if there are some associated parameters
associated with this account (saved favorites, ...) that will be deleted
with it?



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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Could not drill down a parent OrgUnit -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

No, there is any error message. This is happening when accessing to the
data entry app in DHIS2 web, for this single parent OrgUnit. I have tried
to clear browser cache, change to another computer, but same thing.
However, all the children OrgUnits are listed when accessing in the DHIS2
Android data capture. I have also checked the Data Integrity app  but there
is any anomaly.

Regards,

Tantely.

On Sun, Sep 17, 2017 at 5:08 AM, Knut Staring  wrote:

> Any messages in the browser console?
>
> On Sep 17, 2017 03:34, "Raminosoa Rabemanantsoa, Tantely" <
> tramino...@mikolo.org> wrote:
>
>> Dear Community,
>>
>>
>>
>> Do you know the possible cause for a parent OrgUnit with which we could
>> not drill down to access to the lowest OrgUnit in the data entry app (could
>> not unfold the plus sign)? When looking at the OrgUnit maintenance, all
>> ancestors, the parent itself and the lowest level OrgUnits seem to be all
>> okay. This is happening for this single parent OrgUnit.
>>
>>
>>
>> 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-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Could not drill down a parent OrgUnit -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,



Do you know the possible cause for a parent OrgUnit with which we could not
drill down to access to the lowest OrgUnit in the data entry app (could not
unfold the plus sign)? When looking at the OrgUnit maintenance, all
ancestors, the parent itself and the lowest level OrgUnits seem to be all
okay. This is happening for this single parent OrgUnit.



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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

Hi Jason,

Thank you for your input. So, this is then something that is not reachable
for a short-term goal. I will find another work around by grouping the
monthly data and arrange them within the desired period range.

Best,

Tantely.

On Thu, Sep 7, 2017 at 3:22 PM, Jason Pickering  wrote:

> 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/FinancialOctober
> PeriodType.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-devs@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>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Create additional customized OrgUnits attributes

[Raminosoa Rabemanantsoa, Tantely]

Hi Prosper,

Thank you for your support!

Best.

Tantely.

On Tue, Sep 5, 2017 at 3:35 PM, Prosper BT  wrote:

> Dear Tantely,
>
> You will need to create them as attributes and choose Orgunit option;
>
> https://docs.dhis2.org/master/en/user/html/dhis2_user_
> manual_en_full.html#manage_attribute
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> On Tue, Sep 5, 2017 at 3:00 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear DHIS2 Community,
>>
>>
>> While managing OrgUnit (Add, Edit), we have the following fields
>> appearing on the edition form (using DHIS2 2.25):
>>
>>
>> Parent organisation unit
>>
>> Name (*)
>>
>> Short name (*)
>>
>> Code
>>
>> Description
>>
>> Opening date (*)
>>
>> Closed date
>>
>> Comment
>>
>> URL
>>
>> Contact person
>>
>> Address
>>
>> Email
>>
>> Phone number
>>
>> Latitude
>>
>> Longitude
>>
>>
>> In the case I would use another customized attributes for the OrgUnit,
>> how to create and define that field, for it to appear in the edition form?
>> Would it then be possible to upload the information via CSV import into the
>> new customized field, or via Web API in a batch context?
>>
>>
>> Thank you for your input!
>>
>>
>> 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-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Create additional customized OrgUnits attributes

[Raminosoa Rabemanantsoa, Tantely]

Dear DHIS2 Community,


While managing OrgUnit (Add, Edit), we have the following fields appearing
on the edition form (using DHIS2 2.25):


Parent organisation unit

Name (*)

Short name (*)

Code

Description

Opening date (*)

Closed date

Comment

URL

Contact person

Address

Email

Phone number

Latitude

Longitude


In the case I would use another customized attributes for the OrgUnit, how
to create and define that field, for it to appear in the edition form?
Would it then be possible to upload the information via CSV import into the
new customized field, or via Web API in a batch context?


Thank you for your input!


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Defining Compulsory Data Element Unsuccessfull

[Raminosoa Rabemanantsoa, Tantely]

You're right! This is the quickest way.

Thank you Barnabas. I could work with this method.

Regards!

Tantely.



On Mon, Aug 7, 2017 at 9:11 PM, Barnabas Akumba 
wrote:

> Yes. That should be possible if you have access to the DB and you know the
> element ID, categoryoptioncombo and attributeoptioncombo of both the old
> and new DEs.
> The easiest work around for me would be to export the data to CSV and
> import into the new DE.
>
> Regards
>
> On Aug 7, 2017 7:03 PM, "Raminosoa Rabemanantsoa, Tantely" <
> tramino...@mikolo.org> wrote:
>
> Hi Barnabas,
>
> Thank you for this straightforward workaround. Would it then possible via
> SQL view (or another way?) to transfer the existing data of the old DE to
> the new one? By doing so, we can also set the empty value to an hypothetic
> one, so that the new DE won't contain any null value.
>
> Regards,
>
> Tantely.
>
> On Mon, Aug 7, 2017 at 8:47 PM, Barnabas Akumba 
> wrote:
>
>> Hello Raminosoa,
>>
>> The issue is because the Data Element has already been used for data
>> entry and changing the property of the DE at this time will bring about
>> some violations.
>>
>> The solution is to create another DE with the compulsory attribute and
>> remove the previous one from the Dataset.
>> But you might need to trade with the data that was previously entered
>> using the DE.
>>
>> Regards
>>
>> On Aug 7, 2017 6:32 PM, "Raminosoa Rabemanantsoa, Tantely" <
>> tramino...@mikolo.org> wrote:
>>
>> Dear Users,
>>
>> I would like to report the following issue when changing some data
>> elements to be compulsory for the data entry. This DE was already used for
>> a dataset. Please find attached 2 screenshots during the data compulsory
>> edition and the associated unsuccessful message. I am wondering if this is
>> due to the fact that there is already some existing empty values in the
>> data element, or is this issue linked with other consideration?
>>
>> I am using DHIS2 2.25.
>>
>> 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-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Defining Compulsory Data Element Unsuccessfull

[Raminosoa Rabemanantsoa, Tantely]

Hi Barnabas,

Thank you for this straightforward workaround. Would it then possible via
SQL view (or another way?) to transfer the existing data of the old DE to
the new one? By doing so, we can also set the empty value to an hypothetic
one, so that the new DE won't contain any null value.

Regards,

Tantely.

On Mon, Aug 7, 2017 at 8:47 PM, Barnabas Akumba 
wrote:

> Hello Raminosoa,
>
> The issue is because the Data Element has already been used for data entry
> and changing the property of the DE at this time will bring about some
> violations.
>
> The solution is to create another DE with the compulsory attribute and
> remove the previous one from the Dataset.
> But you might need to trade with the data that was previously entered
> using the DE.
>
> Regards
>
> On Aug 7, 2017 6:32 PM, "Raminosoa Rabemanantsoa, Tantely" <
> tramino...@mikolo.org> wrote:
>
> Dear Users,
>
> I would like to report the following issue when changing some data
> elements to be compulsory for the data entry. This DE was already used for
> a dataset. Please find attached 2 screenshots during the data compulsory
> edition and the associated unsuccessful message. I am wondering if this is
> due to the fact that there is already some existing empty values in the
> data element, or is this issue linked with other consideration?
>
> I am using DHIS2 2.25.
>
> 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-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Delete data values based on dataset -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear Djibril,

Thank you for your response. Yes, I could access to the database. Could you
please point a link to an appropriate SQL query in order to do this process?

Kind regards,
Tantely.

On Mon, Jul 24, 2017 at 5:50 PM, Djibril Dione  wrote:

> Hi Raminosoa.
> You can do it using sql script if you have access to the database.
>
>
> Kind regards
> Djibril
>
> On 24 Jul 2017 16:33, "Raminosoa Rabemanantsoa, Tantely" <
> tramino...@mikolo.org> wrote:
>
> Hello everyone,
>
>
> I need to delete data values based on some datasets and each corresponding
> completeness. I can delete all the data values by importing “null” data
> from csv format, but with this, the completeness do not change. My question
> is what is the simplest way to do the data values deletion and
> simultaneously make the change in the completeness information.
>
>
> All your suggestions are welcome!
>
>
> 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-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Delete data values based on dataset -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Hello everyone,


I need to delete data values based on some datasets and each corresponding
completeness. I can delete all the data values by importing “null” data
from csv format, but with this, the completeness do not change. My question
is what is the simplest way to do the data values deletion and
simultaneously make the change in the completeness information.


All your suggestions are welcome!


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear Alex,

Thank you for your suggestion! While trying to run the SQL script I get the
following error message: "SQL query contains illegal keywords" when
bringing the "zeroissignificant" field name in the script, even closing it
between brackets. Here it is:

update dataelement
set [zeroissignificant] = true
where lastupdated::date ='2017-05-25';

Thanks,

Tantely.


On Thu, May 25, 2017 at 9:57 PM, Alex Tumwesigye 
wrote:

> Dear Raminosoa,
>
> U can update the dataelement table directly and set the zeroissignificant
> to true for all after update for dataelement created that day. Then go to
> data administration->maintenance and the clear application cache.
> That works too.
> Sql script looks like
>
> Update dataelement set zeroissignificant = true where created::date
> ='2017-05-25'
>
> Note that the created helps not to update all dataelements, you can choose
> any other filter e.g a starting string.
>
> Alex
>
>
> On Thursday, May 25, 2017, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear DHIS2 community,
>>
>>
>> When doing data elements upload from csv file (both add new or edit
>> existing) we are using the following csv file structure:
>>
>>
>> *Name, uid, code, shortname, description, formname, domaintype,
>> valuetype, aggregationtype, **zeroissignificant*
>>
>>
>> The last field is set to *true* for numeric data element as we would
>> like to store zero data values. As shown in the image below, the checkbox
>> still has to be checked manually.
>>
>>
>> Is there some step that I am missing, or should I use another syntax for
>> this last column. I have to update hundreds of data elements.
>>
>>
>> Your suggestions are welcome!
>>
>>
>> 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.*
>
>
>
> --
> 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 "
>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear DHIS2 community,


When doing data elements upload from csv file (both add new or edit
existing) we are using the following csv file structure:


*Name, uid, code, shortname, description, formname, domaintype, valuetype,
aggregationtype, **zeroissignificant*


The last field is set to *true* for numeric data element as we would like
to store zero data values. As shown in the image below, the checkbox still
has to be checked manually.


Is there some step that I am missing, or should I use another syntax for
this last column. I have to update hundreds of data elements.


Your suggestions are welcome!


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

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,
> surname,email,userCredentials[username,lastLogin,created,
> disabled,userRoles[id,name]],organisationUnits[id,name]&paging=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.userinfo

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

[Raminosoa Rabemanantsoa, Tantely]

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

Re: [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

[Raminosoa Rabemanantsoa, Tantely]

Hi Lars,

Thank you for this very clear instruction. It is straightforward and very
useful!

Regards,

Tantely.

Le 7 avr. 2017 6:25 PM, "Lars Helge Øverland"  a écrit :

>
> Hi Tantely,
>
> to achieve this I think you should use the "org unit group" selection
> mode. Under the organisation unit dimension section, click the gear icon
> and select "Select groups", then select the org unit group which contains
> the org units you would like to display.
>
> In the org unit tree you can leave the selected org unit at the national
> level if you would like to include facilities from the entire country.
>
>
> [image: Inline image 3]
>
>
> This will render the actual org units from that group in your pivot table.
>
> regards,
>
> Lars
>
>
>
>
>
> On Thu, Apr 6, 2017 at 5:38 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear community,
>>
>> I am trying to create a filter to be used with the pivot table results,
>> so that only the filtered OrgUnits will appear. For that I have created
>> OrgUnit groups and have used them in the pivot table. The layout is
>> illustrated in the attached file, by using the OrgUnits in the row
>> dimensions. As a result, the pivot table is only using the OrgUnit groups
>> as a categorization of the results but not filtering them as all OrgUnits
>> are still displayed. I think that an interest using a filter is to avoid
>> dumping a huge amount of data, which is sometimes freezing DHIS2 when
>> displaying the results at the lowest level of OrgUnits.
>>
>> Which way should I follow in order to filter the OrgUnits according to
>> some criteria (like using a spreadsheet filter)? Would it be possible doing
>> that in the pivot table or it would be worth creating an equivalent SQL
>> uery? One constraint with using SQL View is that we can only call
>> DataElements but not Indicators.
>>
>> I am using DHIS2 2.24.
>>
>> Thank you for your support and 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-devs@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 <https://www.dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

Hi Jan, Jason,

Thank you for this suggestion! Clicking on csv under update is working! It
is giving the raw data with only the selected dataelements in the query in
the left side. It seems interesting, I only have to build the
crosstabulation in the spreadsheet.

Also, could you please mention the step-by-step way in order to change the
parameters in the browser JS console to handle a big URL? Or it will affect
system stability? I am using Mozilla Firefox.

Regards,

Tantely.

On Wed, Apr 5, 2017 at 10:20 AM, Jan Henrik Øverland  wrote:

> As long as you are selecting orgunits by level, and not explicitly, that
> should not be a problem.
>
> On 5 April 2017 at 09:08, Jason Pickering 
> wrote:
>
>> 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-devs@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>

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

[Raminosoa Rabemanantsoa, Tantely]

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-devs@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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Lock dataset for data entry

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

While editing dataSet, I am giving the "Expiry days" value in order to lock
the dataset for further entry, with DHIS2 2.24. I have put a value of 60 in
order to have the dataset unlocked for the 2 last months. But the dataset
is still open for data entry for all periods. Did I do wrong or is there
another parameter I should tune in order to do that?

 Thank you already for your support!

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Lock dataset for past data entry

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

I am trying to use the "Expiry days" parameter in order to lock the dataset
for further entry, with DHIS2 2.24. I have put a value of 60 in order to
have the dataset unlocked for the 2 last months. But the dataset is still
open for data entry for all periods. Could anyone give a hand on this?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] SQL query for DataSets

[Raminosoa Rabemanantsoa, Tantely]

Hi Greg, Tim,

Thank you for sharing the alternative way using API. Is it possible to go
backward using the API, if I would like to go beyound getting the list of
assigned dataSets and this time assign a set of dataSets to a group of OU?
That will also be helpful!

Kind Regards,

Tantely

On Tue, Feb 21, 2017 at 10:54 PM, Greg Wilson 
wrote:

> And to tag onto Tim's message, if you know the particular OU of interest,
> you can all datasets associated with it via:
>   https://play.dhis2.org/demo/api/dataSet?filter=organisationUnits.id:eq:
> THEOUUIDGOESHERE
>
> Greg
>
>
> On Tue, Feb 21, 2017 at 1:41 PM, Timothy Harding 
> wrote:
>
>> An alternative way to do this is to use an API call to the
>> /organisationUnits/ and have it also return the names of the dataSets
>> assigned:
>>
>> https://play.dhis2.org/dev/api/organisationUnits/?fields=nam
>> e,id,dataSets[name,id]&paging=false
>>
>> Replace the "https://play.dhis2.org/dev"; with your DHIS 2 instance
>>
>> [image: Inline image 1]
>>
>> Also note that paging=false will return all the org units, depending on
>> how many you have, this can take a while to return to your browser.
>>
>>
>>
>>
>>
>>
>> *Timothy Harding*
>> Sr. Systems Analyst, BAO Systems
>> +1 202-536-1541 | thard...@baosystems.com | http://www.baosystems.com | 
>> Skype:
>> hardi...@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007
>>
>> On Tue, Feb 21, 2017 at 1:31 PM, Jim Grace  wrote:
>>
>>> If you want to show each pair of assigned orgUnit and dataSet, try
>>> something like:
>>>
>>> SELECT ou.name AS orgunit, ds.name AS dataset
>>> FROM dataset ds
>>> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
>>> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
>>> ORDER BY ou.name, ds.name;
>>>
>>> If you want only one row per orgUnit and a column that concatenates all
>>> assigned dataset names, try (in Postgresql):
>>>
>>> SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name)
>>> AS datasets
>>> FROM dataset ds
>>> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
>>> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
>>> GROUP BY ou.name
>>> ORDER BY ou.name;
>>>
>>> Cheers,
>>> Jim
>>>
>>>
>>> On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Dear Community,
>>>>
>>>> I am trying to pull out the list of all orgUnits and the name of the
>>>> questionnaire assigned to each of them via SQL View. In which table should
>>>> I base the SQL query in order to have the list of dataSet assigned to an
>>>> orgUnit?
>>>>
>>>> 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-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@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-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Greg Wilson
> BAO Systems
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] SQL query for DataSets

[Raminosoa Rabemanantsoa, Tantely]

Thank you Ant, that is straightforward! We need that sometimes to counter
check all things.

Regards,

Tantely.


On Wed, Feb 22, 2017 at 7:16 AM, Ant Snyman  wrote:

> and if you also want the datasets that are NOT assigned to ANY
> orgunits you could change the two JOINs to LEFT OUTER JOIN.
>
> On 21 February 2017 at 20:31, Jim Grace  wrote:
>
>> If you want to show each pair of assigned orgUnit and dataSet, try
>> something like:
>>
>> SELECT ou.name AS orgunit, ds.name AS dataset
>> FROM dataset ds
>> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
>> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
>> ORDER BY ou.name, ds.name;
>>
>> If you want only one row per orgUnit and a column that concatenates all
>> assigned dataset names, try (in Postgresql):
>>
>> SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name)
>> AS datasets
>> FROM dataset ds
>> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
>> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
>> GROUP BY ou.name
>> ORDER BY ou.name;
>>
>> Cheers,
>> Jim
>>
>>
>> On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Dear Community,
>>>
>>> I am trying to pull out the list of all orgUnits and the name of the
>>> questionnaire assigned to each of them via SQL View. In which table should
>>> I base the SQL query in order to have the list of dataSet assigned to an
>>> orgUnit?
>>>
>>> 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-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jim Grace
>> Core developer, DHIS 2
>> HISP US Inc.
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *Ant Snyman*
>
> *Cell: 0824910449*
>
> *Landline: 028 2713242*
>
>
> Health Information Systems Program - SA
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer*
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] SQL query for DataSets

[Raminosoa Rabemanantsoa, Tantely]

Dear Jim,

I have tested both scripts and they are all working. The second one is more
straightforward for the analyzes that I will run with external list.

Thank you for your support!

Regards,

Tantely.

Le 21 févr. 2017 9:32 PM, "Jim Grace"  a écrit :

> If you want to show each pair of assigned orgUnit and dataSet, try
> something like:
>
> SELECT ou.name AS orgunit, ds.name AS dataset
> FROM dataset ds
> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
> ORDER BY ou.name, ds.name;
>
> If you want only one row per orgUnit and a column that concatenates all
> assigned dataset names, try (in Postgresql):
>
> SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name) AS
> datasets
> FROM dataset ds
> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
> GROUP BY ou.name
> ORDER BY ou.name;
>
> Cheers,
> Jim
>
>
> On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear Community,
>>
>> I am trying to pull out the list of all orgUnits and the name of the
>> questionnaire assigned to each of them via SQL View. In which table should
>> I base the SQL query in order to have the list of dataSet assigned to an
>> orgUnit?
>>
>> 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-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jim Grace
> Core developer, DHIS 2
> HISP US Inc.
> http://www.dhis2.org <https://www.dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] SQL query for DataSets

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

I am trying to pull out the list of all orgUnits and the name of the
questionnaire assigned to each of them via SQL View. In which table should
I base the SQL query in order to have the list of dataSet assigned to an
orgUnit?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] SQL query for DataSets

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

I am trying to pull out the list of all orgUnits and the name of the
questionnaire assigned to each of them via SQL View. In which table should
I base the SQL query in order to have the list of dataSet assigned to an
orgUnit?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Unassigned dataSet -- pivot table

[Raminosoa Rabemanantsoa, Tantely]

Hi Knut,

They do have historical data. It is possible to query from SQL View, and I
would like to do cross analyses (via pivot table) with other dataSets that
are currently assigned to orgUnits. What should I do?

Regards,

Tantely

On Thu, Feb 16, 2017 at 5:23 PM, Knut Staring  wrote:

> Hi Tantely,
>
> Sorry, but if you don't assign them, then you don't have any data anymore?
> You still want to look at the historical data in Pivots?
>
> Knut
>
> On Thu, Feb 16, 2017 at 2:12 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear Community,
>>
>>
>> I would like to ask the question for dataSets that we do not assign no
>> more to any organization units, how to make them available in pivot table
>> for analysis? I am using DHIS2 2.24.
>>
>>
>> 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-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522 <+47%20918%2080%20522>
> Skype: knutstar
> http://dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Unassigned dataSet -- pivot table

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,


I would like to ask the question for dataSets that we do not assign no more
to any organization units, how to make them available in pivot table for
analysis? I am using DHIS2 2.24.


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

Hi Jason,

Yes, it is there. We get it. Thank you!

Regards,

Tantely.

On Thu, Feb 16, 2017 at 10:39 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

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

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Unassigned dataSet -- pivot table

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,


I would like to ask the question for dataSet that we do not assign no more
to any organization units, how to make them available in pivot table for
analysis? I am using DHIS2 2.24.


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

Dear Jason,

Thank you for this instruction. This is what I am looking for.

Kind Regards,

*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0344280040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
www.msh.org

On Tue, Feb 14, 2017 at 11:42 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

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

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

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



I would like to have your support for the SQL code that I should run to
obtain this result.



With 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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Generate data output

[Raminosoa Rabemanantsoa, Tantely]

Dear Lars,

Thank you for those new development that have been newly introduced which
are interesting. So for version 2.24, if we output raw data through SQL
View, is it possible to integrate the results into dashboards?

Regards,

Tantely

On Tue, Feb 7, 2017 at 9:10 PM, Lars Helge Øverland  wrote:

> Hi Tantely,
>
> we introduced a new analytics web API resource in 2.26 for "raw" data
> which you might find interesting. Docs:
>
> https://docs.dhis2.org/master/en/developer/html/webapi_
> analytics.html#webapi_analytics_raw_data
>
> It follows the same syntax as the regular analytics resource (at
> /api/analytics) but it does not perform any aggregation (e.g. in the org
> unit hierarchy dimension), and instead gives you the raw data in a
> tabular/grid format.
>
> You can use the pivot table > download to browse your metadata, and then
> use the /api/analytics/rawData as base URL instead. Note that this might
> return a ton of data so you might want to split up into multiple requests.
>
> Example:
>
> https://play.dhis2.org/demo/api/26/analytics/rawData.json?
> dimension=dx:s46m5MS0hxu;UOlfIjgN8X6&dimension=pe:THIS_
> YEAR&dimension=ou:YuQRtpLP10I
>
> You can use the outputIdScheme param to give you names instead of IDs:
>
> https://play.dhis2.org/demo/api/26/analytics/rawData.json?
> dimension=dx:s46m5MS0hxu;UOlfIjgN8X6&dimension=pe:THIS_
> YEAR&dimension=ou:YuQRtpLP10I&outputIdScheme=NAME
>
> You can also use the startDate and endDate params for more flexibility.
>
> regards,
>
> Lars
>
>
>
> On Tue, Feb 7, 2017 at 6:41 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear community,
>>
>> I would like to output data in a tabular format (data elements in
>> columns, orgUnits and periods per row) at the lowest level of orgUnits. In
>> which way should I do that as data in text format could not be displayed
>> through pivot table?
>>
>> 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-users
>> Post to : dhis2-us...@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/>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Generate data output

[Raminosoa Rabemanantsoa, Tantely]

Dear community,

I would like to output data in a tabular format (data elements in columns,
orgUnits and periods per row) at the lowest level of orgUnits. In which way
should I do that as data in text format could not be displayed through
pivot table?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Table for SQL query for Indicators

[Raminosoa Rabemanantsoa, Tantely]

Thank you John for the information.

Kind Regards,

Tantely.

On Sun, Feb 5, 2017 at 6:47 PM, John Mukulu  wrote:

> Hello Raminosoa,
>
> Analytics supports generation of query based on data, period and orgunit
> selection. You can use pivot table, select your periods, orgunits and
> indicators and use download option under advanced menu to download the
> query.
>
> I can't recall, but I think support for generation sql query even for
> indicators was added either in 2.23, 2.24 or 2.25 so you could also try to
> explore this option.
>
> On 3 Feb 2017 11:05, "Raminosoa Rabemanantsoa, Tantely" <
> tramino...@mikolo.org> wrote:
>
>> Dear friends,
>>
>> I am trying to output data of a questionnaire (called DataSetName here)
>> from SQL View  for the period of September 2016 from  data values using 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-09-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')));
>>
>> If I would like to output data from indicator tables, on which table in
>> DHIS2 should I base the select query?
>>
>> 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-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Tables for SQL queries -- indicators

[Raminosoa Rabemanantsoa, Tantely]

Dear Jason,

Thank you for this information. I will adapt the calculations from
dataElements then. It is a bit hard to output from the analytics as we need
the values of specific indicators of all the lowest level of orgUnits
across all periods, so we need to split the queries into orgUnits / periods.

With Kind Regards,

Tantely.

Le 5 févr. 2017 10:26 AM, "Jason Pickering"  a
écrit :

> Hi Tantley,
> This is not really so straightforward with SQL as far as I know, as
> indicators are calculated "on-the-fly" from the "analytics_***" tables.
> They are never persisted in the database, so you would need a means to
> parse the syntax of the indicator, and make the calculation from that. I
> seem to recall that someone had done something a while back with
> materializing indicators, so you might want to search through the email
> archive of this list to see if you can find more information.
>
> The easier way, by far however, would be the use the analytics API, and
> let DHIS2 do the calculation for you.
>
> Regards,
> Jason
>
>
> On Sun, Feb 5, 2017 at 9:34 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear DHIS2 Users,
>>
>> I would like to run SQL to query indicators values through SQL View. On
>> which tables should I query from if for the dataelements, the SQL queries
>> are based on dataValues (dv) table?
>>
>> I am using DHIS2 2.24
>>
>> 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-devs@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>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Tables for SQL queries -- indicators

[Raminosoa Rabemanantsoa, Tantely]

Dear DHIS2 Users,

I would like to run SQL to query indicators values through SQL View. On
which tables should I query from if for the dataelements, the SQL queries
are based on dataValues (dv) table?

I am using DHIS2 2.24

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Table for SQL query for Indicators

[Raminosoa Rabemanantsoa, Tantely]

Dear friends,

I am trying to output data of a questionnaire (called DataSetName here)
from SQL View  for the period of September 2016 from  data values using 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-09-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')));

If I would like to output data from indicator tables, on which table in
DHIS2 should I base the select query?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Integrating additional fields of information for organization units

[Raminosoa Rabemanantsoa, Tantely]

Yes, hitting F5 has solved the issue!

Thanks!

Tantely.

On Mon, Jan 16, 2017 at 4:27 PM, Lars Helge Øverland  wrote:

> Hi,
>
> you might have to reload the web page (hit F5) for the attribute to load
> the first time. We are working on that.
>
> regards,
>
> Lars
>
>
> On Mon, Jan 16, 2017 at 1:51 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> I have created the attributes and assign them to Organization Units at
>> the moment of creation. I do not see them yet when editing Organization
>> units, may be I missed some steps?
>>
>> Thanks,
>>
>> Tantely.
>>
>> On Mon, Jan 16, 2017 at 3:22 PM, Knut Staring  wrote:
>>
>>> You can create additional attributes for orgunits
>>>
>>> On Jan 16, 2017 1:18 PM, "Raminosoa Rabemanantsoa, Tantely" <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Dear Community,
>>>>
>>>>
>>>> While managing information related to organization units, I would like
>>>> to integrate additional information concerning the orgUnit other than those
>>>> that are already proposed by DHIS2 (Name, Short name, Code, Description,
>>>> Opening date, Closed Date, Comment, URL…). Do you know how to create
>>>> additional fields for the orgUnit information? Thank you for your help!
>>>>
>>>>
>>>> Tantely.
>>>>
>>>> *This message and its attachments are confidential and solely for the
>>>> intended recipients. If received in error, please delete them and notify
>>>> the sender via reply e-mail immediately.*
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@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/>
>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Integrating additional fields of information for organization units

[Raminosoa Rabemanantsoa, Tantely]

I have created the attributes and assign them to Organization Units at the
moment of creation. I do not see them yet when editing Organization units,
may be I missed some steps?

Thanks,

Tantely.

On Mon, Jan 16, 2017 at 3:22 PM, Knut Staring  wrote:

> You can create additional attributes for orgunits
>
> On Jan 16, 2017 1:18 PM, "Raminosoa Rabemanantsoa, Tantely" <
> tramino...@mikolo.org> wrote:
>
>> Dear Community,
>>
>>
>> While managing information related to organization units, I would like to
>> integrate additional information concerning the orgUnit other than those
>> that are already proposed by DHIS2 (Name, Short name, Code, Description,
>> Opening date, Closed Date, Comment, URL…). Do you know how to create
>> additional fields for the orgUnit information? Thank you for your help!
>>
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Integrating additional fields of information for organization units

[Raminosoa Rabemanantsoa, Tantely]

Thank you Jason, got it!

Tantely.

On Mon, Jan 16, 2017 at 3:21 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> https://docs.dhis2.org/master/en/user/html/manage_attribute.html
>
> On Mon, Jan 16, 2017 at 1:17 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear Community,
>>
>>
>> While managing information related to organization units, I would like to
>> integrate additional information concerning the orgUnit other than those
>> that are already proposed by DHIS2 (Name, Short name, Code, Description,
>> Opening date, Closed Date, Comment, URL…). Do you know how to create
>> additional fields for the orgUnit information? Thank you for your help!
>>
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@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>
>



-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0344280040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Integrating additional fields of information for organization units

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,


While managing information related to organization units, I would like to
integrate additional information concerning the orgUnit other than those
that are already proposed by DHIS2 (Name, Short name, Code, Description,
Opening date, Closed Date, Comment, URL…). Do you know how to create
additional fields for the orgUnit information? Thank you for your help!


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] SQL View to output all levels of orgUnits

[Raminosoa Rabemanantsoa, Tantely]

Dear Ant, Jason,

Thank you for your support. Those scripts are all responding to what I
need! Many thanks!

Best,

Tantely.

On Wed, Jan 11, 2017 at 9:43 AM, Ant Snyman  wrote:

> Thanks Jason,
> Nice output and the advantage is you do not have to join to the resource
> table _orgunitstructure. It is quite a complex query though, but still a
> nice example of using arrays and the path column.
> Thanks
> Ant
>
>
> On 11 January 2017 at 07:18, Jason Pickering 
> wrote:
>
>> Here is another piece of SQL which will transform the "path" to names.
>>
>> You can then join this clause with your organisation unit table (or
>> whatever) on the organisationunitid property. It presents all names in a
>> single column, as opposed to the multiple columns in Ant's example
>>
>> SELECT z.organisationunitid,
>> array_to_string(array_agg(z.name
>> ORDER BY z.rn),'/') AS path
>> FROM
>> (SELECT y.organisationunitid,
>> ou.name,
>> y.elem,
>> y.rn
>> FROM organisationunit ou
>> INNER JOIN
>> (SELECT *,
>> x.path[x.rn] AS elem
>> FROM
>> (SELECT * ,
>> generate_subscripts(arr.path,1) AS rn
>> FROM
>> (SELECT organisationunitid,
>> string_to_array(substring(path
>> FROM 2), '/') AS path
>> FROM organisationunit) arr) x) y ON y.elem = ou.uid) z
>> GROUP BY organisationunitid;
>>
>> Regards,
>> Jason
>>
>>
>> On Wed, Jan 11, 2017 at 6:14 AM, Ant Snyman  wrote:
>>
>>> I should also add that by changing the where clause you can use this
>>> code for any level, for example if you change it to:
>>>
>>> where ous.level = 6 you will only get the structure for your level 6
>>> orgunits
>>>
>>> Regards
>>>
>>> Ant Snyman
>>>
>>>
>>> On 11 January 2017 at 07:05, Ant Snyman  wrote:
>>>
>>>> Hi Tantely,
>>>>
>>>> Try the code below. I normally exclude OU1 in the list because that is
>>>> generally the country code and just makes the report even more wide.
>>>>
>>>> Regards
>>>>
>>>> Ant Snyman
>>>>
>>>>
>>>> SELECT ous.level,
>>>> ou2.name as ou2_name, ou2.shortname as ou2_shortnamme, ou2.uid as
>>>> ou2_uid, ou2.code as ou2_code, ou2.organisationunitid as
>>>> ou2_organisationunitid,
>>>> ou3.name as ou3_name, ou3.shortname as ou3_shortnamme, ou3.uid as
>>>> ou3_uid, ou3.code as ou3_code, ou3.organisationunitid as
>>>> ou3_organisationunitid,
>>>> ou4.name as ou4_name, ou4.shortname as ou4_shortnamme, ou4.uid as
>>>> ou4_uid, ou4.code as ou4_code, ou4.organisationunitid as
>>>> ou4_organisationunitid,
>>>> ou5.name as ou5_name, ou5.shortname as ou5_shortnamme, ou5.uid as
>>>> ou5_uid, ou5.code as ou5_code, ou5.organisationunitid as
>>>> ou5_organisationunitid,
>>>> ou6.name as ou6_name, ou6.shortname as ou6_shortnamme, ou6.uid as
>>>> ou6_uid, ou6.code as ou6_code, ou6.organisationunitid as
>>>> ou6_organisationunitid
>>>> FROM organisationunit ou
>>>> INNER JOIN _orgunitstructure ous ON ou.organisationunitid =
>>>> ous.organisationunitid
>>>> LEFT OUTER JOIN organisationunit ou2 on ous.idlevel2 =
>>>> ou2.organisationunitid
>>>> LEFT OUTER JOIN organisationunit ou3 on ous.idlevel3 =
>>>> ou3.organisationunitid
>>>> LEFT OUTER JOIN organisationunit ou4 on ous.idlevel4 =
>>>> ou4.organisationunitid
>>>> LEFT OUTER JOIN organisationunit ou5 on ous.idlevel5 =
>>>> ou5.organisationunitid
>>>> LEFT OUTER JOIN organisationunit ou6 on ous.idlevel6 =
>>>> ou6.organisationunitid
>>>> where ous.level > 1
>>>> order by ous.level, ou2.name, ou3.name, ou4.name, ou5.name, ou6.name
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 10 January 2017 at 23:56, Raminosoa Rabemanantsoa, Tantely <
>>>> tramino...@mikolo.org> wrote:
>>>>
>>>>> Dear Community,
>>>>>
>>>>> I am trying to output a list of all the orgUnits from the SQLView
>>>>> (DHIS2 2.24). I would like to have all the information of all the levels 
>>>>> of
>>>>> the orgUnits for each of the  6 levels implemented. I would like to have a
>>>>> result in the following form:
>>>>>
>>>>> orgUnit

[Dhis2-devs] SQL View to output all levels of orgUnits

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

I am trying to output a list of all the orgUnits from the SQLView (DHIS2
2.24). I would like to have all the information of all the levels of the
orgUnits for each of the  6 levels implemented. I would like to have a
result in the following form:

orgUnitName (level6), orgUnitName (level5), orgUnitName (level4),
orgUnitName (level3), orgUnitName (level2), orgUnitName (level1)

I have used the following code to output all the information of the level 6:

SELECT organisationunit.organisationunitid, organisationunit.uid,
organisationunit.code, organisationunit.name, organisationunit.shortname
FROM public.organisationunit, public._orgunitstructure WHERE
organisationunit.organisationunitid = _orgunitstructure.idlevel6 AND
organisationunit.code is not null;


How should I update this code in order to pull out the desired output?

Thank you for your support!

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Merge multiple orgUnits DHIS2 2.24

[Raminosoa Rabemanantsoa, Tantely]

Dear Jason,

Thank you for your response. I will use those SQL scripts to merge multiple
orgUnits. I will be back in case of trouble.

Many thanks !

Tantely.

Le 10 janv. 2017 10:59 AM, "Jason Pickering" 
a écrit :

> Hi there,
> This functionality was removed from the core due to some issues with its
> implementation.
>
> I have created two SQL functions which may help you to merge organisation
> units
>
> 1) https://github.com/dhis2/dhis2-utils/blob/master/resource
> s/sql/merge_orgunits.sql
> 2) https://github.com/dhis2/dhis2-utils/blob/master/
> resources/sql/delete_site_with_data.sql
>
> You may need to make some changes to these scripts to suit your version,
> but we have used them on a few different production systems with success.
>
> Hope this helps.
>
> Regards,
> Jason
>
>
> On Tue, Jan 10, 2017 at 8:28 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear community,
>>
>> Do you find the way to merge multiple orgUnits into a single one in DHIS2
>> 2.24. Do you have suggestions on doing this manually or via web API?
>>
>> 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-users
>> Post to : dhis2-us...@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>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Merge multiple orgUnits DHIS2 2.24

[Raminosoa Rabemanantsoa, Tantely]

Dear community,

Do you find the way to merge multiple orgUnits into a single one in DHIS2
2.24. Do you have suggestions on doing this manually or via web API?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Merge orgUnits DHIS2 2.24

[Raminosoa Rabemanantsoa, Tantely]

Dear community,

I do not find the way to merge multiple orgUnits into a single one in DHIS2
2.24. Do you have suggestions on doing this manually or via web API?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Interpret and troubleshoot log-ERROR

[Raminosoa Rabemanantsoa, Tantely]

OK. Thank you for your input.

Regards.

Le 21 sept. 2016 5:01 PM, "wanjala pepela"  a écrit :

> Generally DHIS is down
>
> PEPELA WANJALA
> *MINISTRY OF HEALTH HEADQUARTERS*
> *HEALTH SECTOR MONITORING & EVALUATION - AMRO- KENYA CHAIRMAN*
> *AFYA HOUSE, LG 37*
> *P.O BOX 30016, NAIROBI, KENYA*
> *TEL: +254 (020) 2717077 EXT 45097
> <%2B254%20%28020%29%202717077%20EXT%2045097>*
> *CELL: +254 (0) 722375633 <%2B254%20%280%29%20722375633> *
> *EMAIL: wanjal...@yahoo.com , wanjal...@gmail.com
> *
> *h...@health.go.ke , *meunit...@gmail.com
>  *"HealthInformation Management - Making a World of Difference”*
>
>
>
> ----------
> *From:* Knut Staring 
> *To:* "Raminosoa Rabemanantsoa, Tantely" 
> *Cc:* DHIS 2 Users list ; DHIS 2
> Developers list 
> *Sent:* Wednesday, September 21, 2016 4:54 PM
> *Subject:* Re: [Dhis2-users] Interpret and troubleshoot log-ERROR
>
> Looks like you have network problems...
>
> On Wed, Sep 21, 2016 at 3:39 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
> Dear DHIS2 Community,
>
> I have this kind of errors (cf. attached file) which are repeating  all
> the timein the DHIS2 log file. Could you please explain what may cause them
> and how to troubleshoot? The DHIS2 webapp is running fine, but we should be
> aware of any kind of error happening in the log file. Here are the versions
> we are using: DHIS2 2.19, Tomcat 8.5, Java 1.7.
>
> Your suggestions are welcome!
>
> 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- users
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-users@lists.launchpad. net
> 
> Unsubscribe : https://launchpad.net/~dhis2- users
> <https://launchpad.net/~dhis2-users>
>
> More help   : https://help.launchpad.net/ ListHelp
> <https://help.launchpad.net/ListHelp>
>
>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
>
> More help  : https://help.launchpad.net/ListHelp
>
>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Interpret and troubleshoot log-ERROR

[Raminosoa Rabemanantsoa, Tantely]

Dear DHIS2 Community,

I have this kind of errors (cf. attached file) which are repeating  all the
timein the DHIS2 log file. Could you please explain what may cause them and
how to troubleshoot? The DHIS2 webapp is running fine, but we should be
aware of any kind of error happening in the log file. Here are the versions
we are using: DHIS2 2.19, Tomcat 8.5, Java 1.7.

Your suggestions are welcome!

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


20160921_dhis_error_log
Description: Binary data
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] DHIS2 2.19 Data entry unable to load DataSet

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

I would like to have your advice on troubleshooting these issues:

-In the DHIS2 data entry web module, once an OrgUnit is selected, any
DataSet could not be loaded (running loading status eternally)

-In the Android data capture, the user is loading the list of OrgUnits for
a very long time. The process is terminated by the message "Swipe to
Update".

Is there some parameters that I should consider in order to fix them?

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 Network Out

[Raminosoa Rabemanantsoa, Tantely]

Dear Alex,

Thank you for your suggestions. We are tuning the memories for JWM and
postgreSQL right now and get back to you after.

Regards,

Tantely.

On Tue, Sep 13, 2016 at 11:01 AM, Alex Tumwesigye 
wrote:

> Dear Raminosoa,
>
> I faced a similar problem sometime a year ago.
> This problem is attributed to SQL queries that take long to finish.
> Consider installing pgtop
> You may need to increase your shared_buffers a bit and
> effective_cache_size  or connections parameters until you get the best
> optimal settings. You can also allocate more memory (-Xmx7500m) to tomcat
> process if you have more.
> Note that if you increase your postgres connections, pay attention to
> memory settings you set as you can easily run out of memory too.
>
> Alex
>
>
> On Mon, Sep 12, 2016 at 6:13 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi Halvdan,
>>
>> We have already restarted the server and it has solved temporarily the
>> problem. We are going to try the command you mentioned and see what is
>> happening. Thank you.
>>
>> Regards,
>>
>> Tantely.
>>
>> Le 12 sept. 2016 5:55 PM, "Halvdan Hoem Grelland"  a
>> écrit :
>>
>>> You should probably look into what specific processes on the server are
>>> hogging the CPU. Try using 'htop' from the console (or similar). The logs
>>> you've provided unfortunately do not provide any useful information.
>>>
>>> Also, does a simple server reboot solve the issue? If so, does it
>>> re-occur?
>>>
>>> On Mon, Sep 12, 2016 at 4:37 PM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Hi All,
>>>>
>>>> We are using DHIS2 2.19 and it was working really fine for several
>>>> months.
>>>> We have followed the HISP recommendations for the JVM parameters and the
>>>> PostgreSQL memory tunning. We noticed few days ago a slow access to our
>>>> DHIS2 server on Amazon from web version as well as from data capture.
>>>> When
>>>> checking the status, the server CPU is constantly running at 100%. We
>>>> would
>>>> like to have your advice on the possible sources of the errors. I note
>>>> that
>>>> Amazon has upgraded the Linux system to a newer version (2016.03). Does
>>>> this change have impact on the installation of Tomact and postgreSQL? I
>>>> am
>>>> attaching the DHIS2 log file which is containing several errors.
>>>>
>>>> We are stuck, your help are welcome!
>>>>
>>>> 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-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Halvdan Hoem Grelland
>>> Software developer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org <https://www.dhis2.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-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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 "
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Groups - Tables

[Raminosoa Rabemanantsoa, Tantely]

Hi there,
.
I am trying to connect to those resources using the web API and it seems
that the requested resources are not available. Could you please mention
the way to connect to them by using DHIS2 2.19?

Regards,

Tantely

On Mon, Sep 12, 2016 at 9:31 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Tantely,
>
> 1- the table where are stored all organization units groups with the list
> of their members.
>
> \d orgunitgroupmembers
>
> 2- the table where are stored the datasets assigned to the organization
> units
>
> \d datasetsource
>
> 3- the table where are stored the organization units assigned to all users
>
> \d usermembership
>
> You should not really try and update these tables manually. Its much
> better to use the API.
>
>
> Regards,
> Jason
>
>
>
> On Mon, Sep 12, 2016 at 7:52 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear Members,
>>
>> I am looking for 3 database tables:
>>
>> 1- the table where are stored all organization units groups with the list
>> of their members.
>> 2- the table where are stored the datasets assigned to the organization
>> units
>> 3- the table where are stored the organization units assigned to all
>> users
>>
>> Does anyone know in which tables should I query to select and update
>> their records? I am using DHIS2 2.19 and I connect to the DHIS2 database
>> directly with psql.
>>
>> Thank you for your advice.
>>
>> 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-devs@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
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 Network Out

[Raminosoa Rabemanantsoa, Tantely]

Hi Halvdan,

We have already restarted the server and it has solved temporarily the
problem. We are going to try the command you mentioned and see what is
happening. Thank you.

Regards,

Tantely.

Le 12 sept. 2016 5:55 PM, "Halvdan Hoem Grelland"  a
écrit :

> You should probably look into what specific processes on the server are
> hogging the CPU. Try using 'htop' from the console (or similar). The logs
> you've provided unfortunately do not provide any useful information.
>
> Also, does a simple server reboot solve the issue? If so, does it re-occur?
>
> On Mon, Sep 12, 2016 at 4:37 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi All,
>>
>> We are using DHIS2 2.19 and it was working really fine for several months.
>> We have followed the HISP recommendations for the JVM parameters and the
>> PostgreSQL memory tunning. We noticed few days ago a slow access to our
>> DHIS2 server on Amazon from web version as well as from data capture. When
>> checking the status, the server CPU is constantly running at 100%. We
>> would
>> like to have your advice on the possible sources of the errors. I note
>> that
>> Amazon has upgraded the Linux system to a newer version (2016.03). Does
>> this change have impact on the installation of Tomact and postgreSQL? I am
>> attaching the DHIS2 log file which is containing several errors.
>>
>> We are stuck, your help are welcome!
>>
>> 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-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Halvdan Hoem Grelland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] DHIS2 Network Out

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

We are using DHIS2 2.19 and it was working really fine for several months.
We have followed the HISP recommendations for the JVM parameters and the
PostgreSQL memory tunning. We noticed few days ago a slow access to our
DHIS2 server on Amazon from web version as well as from data capture. When
checking the status, the server CPU is constantly running at 100%. We would
like to have your advice on the possible sources of the errors. I note that
Amazon has upgraded the Linux system to a newer version (2016.03). Does
this change have impact on the installation of Tomact and postgreSQL? I am
attaching the DHIS2 log file which is containing several errors.

We are stuck, your help are welcome!

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.*
* ERROR 2016-09-12 00:45:52,280 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:45:52,562 Importing data values 
(DefaultDataValueSetService.java [http-bio-8080-exec-6540])
* ERROR 2016-09-12 00:45:56,789 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:46:09,773 Data value import done, total: 558, import: 0, 
update: 69 (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* ERROR 2016-09-12 00:46:10,458 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6551])
* ERROR 2016-09-12 00:46:15,648 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6551])
* ERROR 2016-09-12 00:46:42,437 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6546])
* ERROR 2016-09-12 00:46:47,430 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6546])
* INFO  2016-09-12 00:46:49,986 Login success for user: 'dhis120asos10', ip: 
'172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:56,088 Import options: [Id scheme: null, data element 
id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, 
async: false, strategy: null, skip check: false] 
(DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:56,088 Data value set scheme: null, data element 
scheme: null, org unit scheme: null (DefaultDataValueSetService.java 
[http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:56,088 Scheme: UID, data element scheme: UID, org unit 
scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:59,184 Importing data values 
(DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:47:00,903 Data value import done, total: 558, import: 0, 
update: 97 (DefaultDataValueSetService.java [http-bio-8080-exec-6540])
* ERROR 2016-09-12 00:47:34,676 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6525])
* ERROR 2016-09-12 00:47:37,250 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6525])
* ERROR 2016-09-12 00:47:49,313 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6525])
* ERROR 2016-09-12 00:47:52,326 Initialised statement manager 
(StatementInterceptor.java [http-bio-8080-exec-6525])
* INFO  2016-09-12 00:47:57,969 Login success for user: 'dhis120asos10', ip: 
'172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:06,793 Data value import done, total: 558, import: 0, 
update: 207 (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:48:09,247 Import options: [Id scheme: null, data element 
id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, 
async: false, strategy: null, skip check: false] 
(DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:09,247 Data value set scheme: null, data element 
scheme: null, org unit scheme: null (DefaultDataValueSetService.java 
[http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:09,248 Scheme: UID, data element scheme: UID, org unit 
scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:11,954 Importing data values 
(DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:49:11,426 Login success for user: 'dhis120asos10', ip: 
'172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:15,672 Import options: [Id scheme: null, data element 
id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, 
async: false, strategy: null, skip check: false] 
(DefaultDataValueSetService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:15,673 Data value set scheme: null, data element 
scheme: null, org unit scheme: null (DefaultDataValueSetService.java 
[http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:15

Re: [Dhis2-devs] Groups - Tables

[Raminosoa Rabemanantsoa, Tantely]

Hi Jason,

Thank your advice.

Regards,

Tantely.

On Mon, Sep 12, 2016 at 9:31 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Tantely,
>
> 1- the table where are stored all organization units groups with the list
> of their members.
>
> \d orgunitgroupmembers
>
> 2- the table where are stored the datasets assigned to the organization
> units
>
> \d datasetsource
>
> 3- the table where are stored the organization units assigned to all users
>
> \d usermembership
>
> You should not really try and update these tables manually. Its much
> better to use the API.
>
>
> Regards,
> Jason
>
>
>
> On Mon, Sep 12, 2016 at 7:52 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear Members,
>>
>> I am looking for 3 database tables:
>>
>> 1- the table where are stored all organization units groups with the list
>> of their members.
>> 2- the table where are stored the datasets assigned to the organization
>> units
>> 3- the table where are stored the organization units assigned to all
>> users
>>
>> Does anyone know in which tables should I query to select and update
>> their records? I am using DHIS2 2.19 and I connect to the DHIS2 database
>> directly with psql.
>>
>> Thank you for your advice.
>>
>> 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-devs@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
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Groups - Tables

[Raminosoa Rabemanantsoa, Tantely]

Dear Members,

I am looking for 3 database tables:

1- the table where are stored all organization units groups with the list
of their members.
2- the table where are stored the datasets assigned to the organization
units
3- the table where are stored the organization units assigned to all users

Does anyone know in which tables should I query to select and update their
records? I am using DHIS2 2.19 and I connect to the DHIS2 database directly
with psql.

Thank you for your advice.

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Coordinates capture in DHIS2

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

Is there anyone using DHIS2 2.19 who  already developped a form that
automatically capture geographic coordinates in DHIS2? Thank you for
sharing your experiences.

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Dataset Assignation programmatically

[Raminosoa Rabemanantsoa, Tantely]

I see. Thank you for your suggestion. I will familiarise myself with that
as it will be helpfull for interacting with DHIS2.

Thank you for your support!

Regards,

Tantely.

On Fri, Aug 5, 2016 at 1:58 PM, Jason Pickering  wrote:

> There are numerous examples in the documentation about how to work with
> the API. Have you had a look there?
>
> This is a good start.
>
> http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/ch01s10.html
>
>
>
> On Fri, Aug 5, 2016 at 12:48 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Thank you for your explanation. I had a look at the link and it returned
>> the following message instead of what you mentioned:
>>
>> falsefalsefalseART monthly summaryrw--falsefalseART
>> 2010falsefalsefalseCUSTOMfalselyLU2wR22tCfalse220Monthly00RE
>> PORTING_RATEtruetruefalsetruetruetruerw--L4XTzgbdza3WakikiL4XTzgbdza3
>>
>> In addition to your explanation, could you please point me to a practical
>> example of manipulating the data through the web API interface as I am new
>> on this?
>>
>> Regards,
>>
>> Tantely.
>>
>> On Fri, Aug 5, 2016 at 12:57 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>>
>>> Look at https://play.dhis2.org/demo/api/dataSets/lyLU2wR22tC
>>> and you will see something like
>>>
>>> 
>>> 
>>> 
>>>
>>> So you can just add them there and post the entire payload back. This is
>>> probably the easiest way.
>>>
>>> You can also add them one at a time by POSTing
>>> to api/dataSets/A/organisationUnits/B
>>> where A is the dataset UID and B is the organisation unit UID.
>>>
>>> You can also insert them directly into the table "datasetsource" with
>>> SQL. You will need to clear your server cache after this for the changes to
>>> become visible.
>>>
>>> Regards,
>>> Jaosn
>>>
>>>
>>>
>>> On Fri, Aug 5, 2016 at 11:38 AM, Knut Staring  wrote:
>>>
>>>> The best way would be through the Web API.
>>>>
>>>> I think directly in the db might work (you can test it on a copy of
>>>> your db).  You will have to clear the server cache or restart.
>>>>
>>>> You should also consider an upgrade, as you are a lot of versions
>>>> behind now...
>>>>
>>>> Knut
>>>>
>>>> On Fri, Aug 5, 2016 at 11:35 AM, Raminosoa Rabemanantsoa, Tantely <
>>>> tramino...@mikolo.org> wrote:
>>>>
>>>>> Dear All,
>>>>>
>>>>> I would like to ask if someone has already experinced a batch
>>>>> assignation of dataset to organization units directly in DHIS2 database? I
>>>>> have 10 datasets to assign to a thousands of orguints (which  will vary in
>>>>> time) and it will be time consuming if using the Data Set Assignment 
>>>>> Editor
>>>>> manually. Your suggestions are welcome.
>>>>>
>>>>> I am using DHIS2 2.19.
>>>>>
>>>>> 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-devs@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-devs@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
>>>
>>
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Dataset Assignation programmatically

[Raminosoa Rabemanantsoa, Tantely]

Thank you for your explanation. I had a look at the link and it returned
the following message instead of what you mentioned:

falsefalsefalseART monthly summaryrw--falsefalseART
2010falsefalsefalseCUSTOMfalselyLU2wR22tCfalse220Monthly00RE
PORTING_RATEtruetruefalsetruetruetruerw--L4XTzgbdza3WakikiL4XTzgbdza3

In addition to your explanation, could you please point me to a practical
example of manipulating the data through the web API interface as I am new
on this?

Regards,

Tantely.

On Fri, Aug 5, 2016 at 12:57 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

>
> Look at https://play.dhis2.org/demo/api/dataSets/lyLU2wR22tC
> and you will see something like
>
> 
> 
> 
>
> So you can just add them there and post the entire payload back. This is
> probably the easiest way.
>
> You can also add them one at a time by POSTing
> to api/dataSets/A/organisationUnits/B
> where A is the dataset UID and B is the organisation unit UID.
>
> You can also insert them directly into the table "datasetsource" with SQL.
> You will need to clear your server cache after this for the changes to
> become visible.
>
> Regards,
> Jaosn
>
>
>
> On Fri, Aug 5, 2016 at 11:38 AM, Knut Staring  wrote:
>
>> The best way would be through the Web API.
>>
>> I think directly in the db might work (you can test it on a copy of your
>> db).  You will have to clear the server cache or restart.
>>
>> You should also consider an upgrade, as you are a lot of versions behind
>> now...
>>
>> Knut
>>
>> On Fri, Aug 5, 2016 at 11:35 AM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Dear All,
>>>
>>> I would like to ask if someone has already experinced a batch
>>> assignation of dataset to organization units directly in DHIS2 database? I
>>> have 10 datasets to assign to a thousands of orguints (which  will vary in
>>> time) and it will be time consuming if using the Data Set Assignment Editor
>>> manually. Your suggestions are welcome.
>>>
>>> I am using DHIS2 2.19.
>>>
>>> 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-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@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
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Dataset Assignation programmatically

[Raminosoa Rabemanantsoa, Tantely]

Dear All,

I would like to ask if someone has already experinced a batch assignation
of dataset to organization units directly in DHIS2 database? I have 10
datasets to assign to a thousands of orguints (which  will vary in time)
and it will be time consuming if using the Data Set Assignment Editor
manually. Your suggestions are welcome.

I am using DHIS2 2.19.

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 - Reporting rate + count of the submitted reports.

[Raminosoa Rabemanantsoa, Tantely]

Dear Prosper,

Yes, I am planning to upgrade first with the development instance of DHIS2.

Regards,

Tantely.

On Wed, Jul 27, 2016 at 5:36 PM, Prosper BT  wrote:

> Dear Tantely
>
> You are  not in position to upgrade?
>
> You may have to run a few SQL queries with 1.19.
>
> Regards
>
>
> On Wed, Jul 27, 2016, 1:00 PM Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi Prosper,
>>
>> I am using DHIS2 2.19. Yes, this display is not yet integrated in the
>> reporting rate from pivot table but they are already in the Reporting Rate
>> Summary of the "Reports" module. So may be my question is falling in a
>> limitation of the version DHIS2 2.19.
>>
>> Thank you for your answer.
>>
>> Regards,
>>
>> Tantely.
>>
>> On Wed, Jul 27, 2016 at 12:39 PM, Prosper BT  wrote:
>>
>>> Hi Raminosoa,
>>>
>>> Which version are you using, It a new feature in 2.24 - pivot tables,
>>> see below
>>>
>>> [image: Inline image 1]
>>>
>>> Regards
>>>
>>> On Wed, Jul 27, 2016 at 10:32 AM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Dear All,
>>>>
>>>> Does someone have some suggestions on having the number of submitted
>>>> report as output in addition to the rate value itself? I am using the pivot
>>>> table reporting rates and the option "count" and "sum" all give only the
>>>> reporting rate value.
>>>>
>>>> Thank you for your advice.
>>>>
>>>> Tantely.
>>>>
>>>> *This message and its attachments are confidential and solely for the
>>>> intended recipients. If received in error, please delete them and notify
>>>> the sender via reply e-mail immediately.*
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Global DHIS2 Implementation| HISP Uganda/University Of Oslo
>>> +256 752 751 776 | +256 776 139 139
>>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>>> prospertb
>>>
>>
>>
>>
>> *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.*
>
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 - Reporting rate + count of the submitted reports.

[Raminosoa Rabemanantsoa, Tantely]

Hi Prosper,

I am using DHIS2 2.19. Yes, this display is not yet integrated in the
reporting rate from pivot table but they are already in the Reporting Rate
Summary of the "Reports" module. So may be my question is falling in a
limitation of the version DHIS2 2.19.

Thank you for your answer.

Regards,

Tantely.

On Wed, Jul 27, 2016 at 12:39 PM, Prosper BT  wrote:

> Hi Raminosoa,
>
> Which version are you using, It a new feature in 2.24 - pivot tables, see
> below
>
> [image: Inline image 1]
>
> Regards
>
> On Wed, Jul 27, 2016 at 10:32 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear All,
>>
>> Does someone have some suggestions on having the number of submitted
>> report as output in addition to the rate value itself? I am using the pivot
>> table reporting rates and the option "count" and "sum" all give only the
>> reporting rate value.
>>
>> Thank you for your advice.
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] DHIS2 - Reporting rate + count of the submitted reports.

[Raminosoa Rabemanantsoa, Tantely]

Dear All,

Does someone have some suggestions on having the number of submitted report
as output in addition to the rate value itself? I am using the pivot table
reporting rates and the option "count" and "sum" all give only the
reporting rate value.

Thank you for your advice.

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Store external spreadheet-like data in DHIS2

[Raminosoa Rabemanantsoa, Tantely]

Hi Knut,

We are really interested in that app.

Regards,

Tantely

On Tue, Jul 26, 2016 at 9:31 AM, Knut Staring  wrote:

> Hi Jerome,
>
> not yet, I think. I will check the status of it and get back to you.
>
> Knut
>
> On Tue, Jul 26, 2016 at 12:59 PM, Jerome Shaguy 
> wrote:
>
>> Hi Knut,
>>
>> Is this app available on the playstore?
>>
>> On Tue, Jul 26, 2016 at 11:26 AM, Knut Staring  wrote:
>>
>>> If however you want to use the analytical output and visualization in
>>> DHIS2, there is now an app available that allows you to map the spreadsheet
>>> to data elements, periods and orgunits in DHIS2 - in other words, there is
>>> a way to import from Excel provided it the structure is relatively
>>> straightforward and mappable. But you will first have to make sure all the
>>> metadata is in DHIS2 or if not, create them.
>>>
>>> Knut
>>>
>>> On Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> Thank you for your suggestions. This is helpful.
>>>>
>>>> Regards
>>>>
>>>> Tantely
>>>>
>>>> Le 25 juil. 2016 18:34, "Jason Pickering" 
>>>> a écrit :
>>>>
>>>> Hi Tantely,
>>>>
>>>> Please have a look here
>>>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html
>>>>
>>>> for how DHIS2 can be used to store file resources.
>>>>
>>>> Data stored there however will not be available for visualization or
>>>> other analytics.
>>>>
>>>> Regards,
>>>> Jason
>>>>
>>>>
>>>> On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely <
>>>> tramino...@mikolo.org> wrote:
>>>>
>>>>> Dear Community,
>>>>>
>>>>> I would like to use DHIS2, in addition to its classic uses (data
>>>>> capture, data analysis and reporting,...), to store a tabular data that is
>>>>> sourced from MS Excel spreadsheet (or probably from another database)
>>>>> without any link to organization unit, period or dataset. Would it be
>>>>> possible to integrate this tabular data directly into a dashboard? Or
>>>>> should I still prepare all the data elements to receive the spreadsheet
>>>>> cells values? Or what would be the best way to use the DHIS2 database to
>>>>> store the spreadsheet-like data? I plan to make this spreadsheet to be
>>>>> available in DHIS2 for the users to visualize or to download.
>>>>>
>>>>> Your suggestions are welcome.
>>>>>
>>>>> Ragards,
>>>>>
>>>>> 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-devs@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
>>>>
>>>>
>>>>
>>>> *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-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Store external spreadheet-like data in DHIS2

[Raminosoa Rabemanantsoa, Tantely]

Hi Jason,

Thank you for your suggestions. This is helpful.

Regards

Tantely

Le 25 juil. 2016 18:34, "Jason Pickering"  a
écrit :

Hi Tantely,

Please have a look here
http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other
analytics.

Regards,
Jason


On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear Community,
>
> I would like to use DHIS2, in addition to its classic uses (data capture,
> data analysis and reporting,...), to store a tabular data that is sourced
> from MS Excel spreadsheet (or probably from another database) without any
> link to organization unit, period or dataset. Would it be possible to
> integrate this tabular data directly into a dashboard? Or should I still
> prepare all the data elements to receive the spreadsheet cells values? Or
> what would be the best way to use the DHIS2 database to store the
> spreadsheet-like data? I plan to make this spreadsheet to be available in
> DHIS2 for the users to visualize or to download.
>
> Your suggestions are welcome.
>
> Ragards,
>
> 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-devs@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

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Store external spreadheet-like data in DHIS2

[Raminosoa Rabemanantsoa, Tantely]

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture,
data analysis and reporting,...), to store a tabular data that is sourced
from MS Excel spreadsheet (or probably from another database) without any
link to organization unit, period or dataset. Would it be possible to
integrate this tabular data directly into a dashboard? Or should I still
prepare all the data elements to receive the spreadsheet cells values? Or
what would be the best way to use the DHIS2 database to store the
spreadsheet-like data? I plan to make this spreadsheet to be available in
DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Update datavalues / metadata from SQL

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

I am looking for links or documentations on interacting with DHIS2 database
from the SQL Shell commands. For instance, when I would like to UPDATE,
DELETE or ADD some records values, do I only run the SQL command on the
"datavalue" table or also on all linked tables? Same thing when making
changes on metadata to make some UPDATE, DELETE or ADD some organization
units.

Thank you for your support.

Tantely.

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Connect to DHIS2 with slow internet connection

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

I am just wondering if, in addition to the database memory tuning of DHIS2,
is there an additional parameter to check in the server to allow the users
of "DHIS2 data capture" to log in and download datasets and then send the
entered data easily even with slow internet connection? Sometimes they
could not log into the server, sometimes after logging in, there is only a
message "swipe to update".

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Disable/Enable data editing in DHIS2 dataset

[Raminosoa Rabemanantsoa, Tantely]

Thank you Jason. That is what I have been looking for.

Regards,

Tantely.

On Wed, Jul 20, 2016 at 4:18 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Tantely,
>
> Please have a look at the documentation
> http://dhis2.github.io/dhis2-docs/2.23/en/user/html/ch06.html
>
> Expiry days: Controls for how long it should be possible to enter data in
> data entry for this data set. Expiry days refer to the number of days after
> the end date of the selected data entry period where the data entry form
> should be open for entry. After the number of days has expired, the data
> set will be locked for further entry. You can set manual exceptions to this
> using the lock exception functionality in data administration module.
> Regards,
> Jason
>
>
> On Wed, Jul 20, 2016 at 3:03 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi All,
>>
>>
>> Does someone have experimented disabling data editing after a certain
>> period, let us say 2 weeks after the data entry in a dataset? Then how did
>> you do then to allow some users do the editing of certain data values
>> (after data quality assessments), once the editing has been disabled?
>>
>>
>> Thank you for your support (DHIS2 2.19)
>>
>>
>> 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-devs@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
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Disable/Enable data editing in DHIS2 dataset

[Raminosoa Rabemanantsoa, Tantely]

Hi All,


Does someone have experimented disabling data editing after a certain
period, let us say 2 weeks after the data entry in a dataset? Then how did
you do then to allow some users do the editing of certain data values
(after data quality assessments), once the editing has been disabled?


Thank you for your support (DHIS2 2.19)


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Output from Orgunits and Orgunits Group

[Raminosoa Rabemanantsoa, Tantely]

Dear All,

I am asking if someone has already done, in the pivot table, a single
display of the list of organization units with the name of the organization
unit group where they belong to. In pivot table, I have used the “select
groups” in the selection mode during the selection of the organization
units. The output result I get is only showing the list of the organization
units that belong to the selected group and there is no way to output the
name of the selected group itself in this result. I have tried to show the
organization units hierarchy in the pivot table options but it only output
the names of all orgunits in the hierarchy.


All suggestions are welcome. DHIS2 2.19.


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Zero reporting rates for dataset with imported data values

[Raminosoa Rabemanantsoa, Tantely]

Great. Thanks!

Tantely.

On Wed, Jul 13, 2016 at 12:38 PM, Knut Staring  wrote:

> Sourceid = Organisaitonunitid. This is an unfortunate historical naming.
>
> Knut
>
> On Wed, Jul 13, 2016 at 11:19 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Thank you Knut, I got it. My question is in which table is linked the
>> "sourceid" field of the completedatasetregistration table as I
>> understand the 5 other fields.
>>
>> Regards,
>>
>> Tantely.
>>
>> On Wed, Jul 13, 2016 at 11:20 AM, Knut Staring  wrote:
>>
>>> If you want to look directly in the database, there is a table called
>>> completedatasetregistration.
>>>
>>> On Wed, Jul 13, 2016 at 10:11 AM, Knut Staring  wrote:
>>>
>>>> Hi there,
>>>>
>>>> There are several ways of counting completeness, and it is not
>>>> necessarily related to the datavalues, but rather recorded on the dataset
>>>> (in the extreme case, there could be nothing to report (because no patients
>>>> were seen), so no datavalues, but still the report is complete (we have not
>>>> forgotten to report). Thus, there is a property of the dataset whether it
>>>> is complete or not for a particular OU and period:
>>>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
>>>>
>>>> Here is more on completeness:
>>>>
>>>> http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions---completeness.doc
>>>>
>>>> Knut
>>>>
>>>> On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely <
>>>> tramino...@mikolo.org> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>>
>>>>> I have imported a large amount of data values by uploading via csv
>>>>> file with monthly periods of a specific dataset (with DHIS 2.19). I 
>>>>> thought
>>>>> that when calculating the reporting rate of this dataset, the report 
>>>>> should
>>>>> return the number of actual reports containing values that I have just
>>>>> uploaded, but the number of this “actual reports” is now still counted as
>>>>> ZERO. My question is, in that case, is there a specific field in the
>>>>> database that I should update in order to consider the dataset containing
>>>>> data values in the reporting rates count? Here is the list of fields that 
>>>>> I
>>>>> have used during the import: *dataelement*, *period*, *orgunit*,
>>>>> *categoryoptioncombo*, *attributeoptioncombo*, *value*, *storedby*,
>>>>> *lastupdated*, *comment*, *followup*
>>>>>
>>>>>
>>>>> Thank you for your help!
>>>>>
>>>>>
>>>>> 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-devs@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>
>>
>> *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.*
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Zero reporting rates for dataset with imported data values

[Raminosoa Rabemanantsoa, Tantely]

Thank you Knut, I got it. My question is in which table is linked the
"sourceid" field of the completedatasetregistration table as I understand
the 5 other fields.

Regards,

Tantely.

On Wed, Jul 13, 2016 at 11:20 AM, Knut Staring  wrote:

> If you want to look directly in the database, there is a table called
> completedatasetregistration.
>
> On Wed, Jul 13, 2016 at 10:11 AM, Knut Staring  wrote:
>
>> Hi there,
>>
>> There are several ways of counting completeness, and it is not
>> necessarily related to the datavalues, but rather recorded on the dataset
>> (in the extreme case, there could be nothing to report (because no patients
>> were seen), so no datavalues, but still the report is complete (we have not
>> forgotten to report). Thus, there is a property of the dataset whether it
>> is complete or not for a particular OU and period:
>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
>>
>> Here is more on completeness:
>>
>> http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions---completeness.doc
>>
>> Knut
>>
>> On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Hi All,
>>>
>>>
>>> I have imported a large amount of data values by uploading via csv file
>>> with monthly periods of a specific dataset (with DHIS 2.19). I thought that
>>> when calculating the reporting rate of this dataset, the report should
>>> return the number of actual reports containing values that I have just
>>> uploaded, but the number of this “actual reports” is now still counted as
>>> ZERO. My question is, in that case, is there a specific field in the
>>> database that I should update in order to consider the dataset containing
>>> data values in the reporting rates count? Here is the list of fields that I
>>> have used during the import: *dataelement*, *period*, *orgunit*,
>>> *categoryoptioncombo*, *attributeoptioncombo*, *value*, *storedby*,
>>> *lastupdated*, *comment*, *followup*
>>>
>>>
>>> Thank you for your help!
>>>
>>>
>>> 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-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>

-- 
*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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Zero reporting rates for dataset with imported data values

[Raminosoa Rabemanantsoa, Tantely]

Hi All,


I have imported a large amount of data values by uploading via csv file
with monthly periods of a specific dataset (with DHIS 2.19). I thought that
when calculating the reporting rate of this dataset, the report should
return the number of actual reports containing values that I have just
uploaded, but the number of this “actual reports” is now still counted as
ZERO. My question is, in that case, is there a specific field in the
database that I should update in order to consider the dataset containing
data values in the reporting rates count? Here is the list of fields that I
have used during the import: *dataelement*, *period*, *orgunit*,
*categoryoptioncombo*, *attributeoptioncombo*, *value*, *storedby*,
*lastupdated*, *comment*, *followup*


Thank you for your help!


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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Creating dropdown field

[Raminosoa Rabemanantsoa, Tantely]

Dear Prosper,

I appreciate your input! It is working fine.

Regards,

Tantely

On Wed, Jul 13, 2016 at 9:29 AM, Prosper BT  wrote:

> Dear Tantely,
>
> Have you tried using options sets?
>
> Got to Data Administration and create an option set with options Yes, No,
> and NA, then when you create a data element choose that option set.
>
> Regards
>
> On Wed, Jul 13, 2016 at 9:11 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi there,
>>
>> I would like to insert a field which is expecting one of the three values
>> "yes", "no", "not applicable"  within a questionnaire in DHIS2 2.19. I am
>> asking if someone has already done something similar without using the
>> yes/no field type. 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-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>



-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Creating dropdown field

[Raminosoa Rabemanantsoa, Tantely]

Hi there,

I would like to insert a field which is expecting one of the three values
"yes", "no", "not applicable"  within a questionnaire in DHIS2 2.19. I am
asking if someone has already done something similar without using the
yes/no field type. 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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Questionnaires automatically un-assigned

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

With DHIS2 2.19, something strange is happening on the questionnaire
assignation. Some organization units have a status of non-assigned
questionnaire after the assignation of  all questionnaires to all
organisation units. That was happening three times and we are wondering
what may cause this situation and how to troubleshoot it?

Thank you for your support.

Tantely.

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 SQL View - practical examples

[Raminosoa Rabemanantsoa, Tantely]

Thank you Michael.

Regards,

Tantely.

On Tue, Jul 5, 2016 at 3:35 PM, Michael Mwebaze 
wrote:

> Hi Tantely,
>
> Standard ANSI SQL can be executed easily with-in Sqlviews sub-module in
> DHIS2. The link below should be helpful.
>
> http://dhis2.github.io/dhis2-docs/2.22/en/user/html/ch22s06.html
>
> Regards,
>
> Michael
>
> On 5 July 2016 at 04:45, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Thank you Knut for your suggestion.
>>
>> Regards,
>>
>> Tantely.
>>
>> On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring  wrote:
>>
>>> Hi Raminosa,
>>>
>>> I think you should try to install Postgres locally on your laptop, which
>>> would allow you to easily query the database using PgAdmin.
>>>
>>> Regards,
>>> Knut
>>>
>>> On Tue, Jul 5, 2016 at 9:13 AM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Hi All,
>>>>
>>>>
>>>> I am looking for a documentation of the use of the SQL syntax to run in
>>>> SQL View  (table names, field names specific to DHIS2 ). I have seen for
>>>> example to query organization unit, we have to select from “ou” or to use
>>>> “dv” to select the datavalues. I am planning to list all the uid, code and
>>>> names of all organization units at all levels (1 to 6) in one single query
>>>> result.
>>>>
>>>>
>>>> Thank you for your support.
>>>>
>>>>
>>>> Tantely.
>>>>
>>>> *This message and its attachments are confidential and solely for the
>>>> intended recipients. If received in error, please delete them and notify
>>>> the sender via reply e-mail immediately.*
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] DHIS2 SQL View - practical examples

[Raminosoa Rabemanantsoa, Tantely]

Thank you Knut for your suggestion.

Regards,

Tantely.

On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring  wrote:

> Hi Raminosa,
>
> I think you should try to install Postgres locally on your laptop, which
> would allow you to easily query the database using PgAdmin.
>
> Regards,
> Knut
>
> On Tue, Jul 5, 2016 at 9:13 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi All,
>>
>>
>> I am looking for a documentation of the use of the SQL syntax to run in
>> SQL View  (table names, field names specific to DHIS2 ). I have seen for
>> example to query organization unit, we have to select from “ou” or to use
>> “dv” to select the datavalues. I am planning to list all the uid, code and
>> names of all organization units at all levels (1 to 6) in one single query
>> result.
>>
>>
>> Thank you for your support.
>>
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>



-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] DHIS2 SQL View - practical examples

[Raminosoa Rabemanantsoa, Tantely]

Hi All,


I am looking for a documentation of the use of the SQL syntax to run in SQL
View  (table names, field names specific to DHIS2 ). I have seen for
example to query organization unit, we have to select from “ou” or to use
“dv” to select the datavalues. I am planning to list all the uid, code and
names of all organization units at all levels (1 to 6) in one single query
result.


Thank you for your support.


Tantely.

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Failure with Analytics tables update

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

Thank you for your suggestions. I am on the way to verify the server and I
will be back with informations.

Thank you.

On Mon, Jun 20, 2016 at 6:56 AM, Sultanahamar Mohammad <
sult...@thoughtworks.com> wrote:

> Hi There,
>
> We have experienced similar issues earlier where we were having plenty of
> disk space but most of it was not mounted. Could you please check the mount
> points and then check the disk space available for postgres and other
> stuff. You can use the command 'df' and understand how is the disk
> organized.
>
> Regards,
> Sultan Ahamar.
>
> On Fri, Jun 17, 2016 at 7:13 PM, Halvdan Hoem Grelland 
> wrote:
>
>> This is an issue with Postgres specifically and is therefore not related
>> to the JVM. Most likely it is failing to temporarily store data during a
>> big query due to low capacity.
>>
>> If you have plentiful physical capacity on the disk you could have a look
>> at
>> https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html
>>
>> Specifically see section 18.4.2 which addresses the temp_file_limit.
>>
>> Also try to do a VACUUM FULL
>>
>> On Fri, Jun 17, 2016 at 3:26 PM, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Hi All,
>>>
>>> Thank you for your points of view. I am just wondering on this disk
>>> capacity issue. We are using a cloud  Amazon Web services to host the DHIS2
>>> application. There are 80 gigabyte disk space used only by DHIS2. There are
>>> 30 gigabyte of RAM where 9 GB are for JVM and 9 GB for postgreSQL. My
>>> question is that which parameters should I correct to troubleshoot this
>>> disk issue as physically there is still large available disk space on the
>>> server, or is there other parameters to allocate the physical disk space
>>> (in addition to the RAM) managed by JVM?
>>>
>>> Thank you.
>>>
>>> Tantely.
>>>
>>> *This message and its attachments are confidential and solely for the
>>> intended recipients. If received in error, please delete them and notify
>>> the sender via reply e-mail immediately.*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Halvdan Hoem Grelland
>> Software developer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Failure with Analytics tables update

[Raminosoa Rabemanantsoa, Tantely]

Hi All,

Thank you for your points of view. I am just wondering on this disk
capacity issue. We are using a cloud  Amazon Web services to host the DHIS2
application. There are 80 gigabyte disk space used only by DHIS2. There are
30 gigabyte of RAM where 9 GB are for JVM and 9 GB for postgreSQL. My
question is that which parameters should I correct to troubleshoot this
disk issue as physically there is still large available disk space on the
server, or is there other parameters to allocate the physical disk space
(in addition to the RAM) managed by JVM?

Thank you.

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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] OrgUnit conflicts

[Raminosoa Rabemanantsoa, Tantely]

Thank you Lars for those information.

Regards,

Tantely.

On Thu, May 19, 2016 at 3:17 PM, Lars Helge Øverland  wrote:

> Hi Tantely,
>
> On Thu, May 19, 2016 at 10:40 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hi All,
>>
>>
>> I would like to have your advice on how to fix the following issues:
>>
>>
>> - The first point is that after the creation of users who are entering
>> data through DHIS2 data capture, each of them has the following warning
>> (409 conflict) when logging in the web interface mentioning that the user
>> is not allowed to view the org unit with an org unit UID that I could not
>> locate in the database (through SQL view). How to troubleshoot this issue?
>>
>
> This could be related to a weakness which we just fixed. Can you please
> upgrade to latest 2.21 / 2.22 / 2.23 version and try again?
>
> If you have a server-side cache (e.g. nginx) you could also clear that
> cache as an intermediate fix.
>
> It's quite strange that the org unit in the dialog is not in your database
> - can you double-check directly in the database?
>
>
>>
>>
>>
>> ​
>>
>> -The second point is when using the reporting rate app, I am summarizing
>> the report by the administrative commune level (level 5 in the org unit
>> hierarchy). Instead of having 3 total of expected reports (red circle), the
>> app is counting the level 5 itself so the total expected reports become 4
>> (as illustrated in the image below), which is false. Are there some
>> parameters that I should set to fix this issue?
>>
>
> This depends on how you have assigned your data sets to org units. If you
> have assigned the data set to the org unit on the commune level if will be
> included in the number of expected reports. If you can un-assign the org
> unit form the commune org unit it will not be counted.
>
>
>>
>>
>> ​
>>
>> regards,
>
> Lars
>
>
>
>
>> I am using DHIS2 2.19.
>>
>>
>> Thank you for your help.
>>
>> --
>> *Tantely Raminosoa*
>> *Data Officer*
>> Management Sciences for Health
>> Antananarivo Madagascar
>> Mobile: 0321180040
>> E-mail: tramino...@mikolo.org
>> Skype: traminosoa
>> <http://www.msh.org/>
>> Stronger health systems. Greater health impact.
>> <https://www.facebook.com/ManagementSciencesForHealth>
>> <https://twitter.com/MSHHealthImpact>
>> <https://www.youtube.com/user/MSHHealthImpact>
>> 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-us...@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/>
>
>


-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] OrgUnit conflicts

[Raminosoa Rabemanantsoa, Tantely]

Hi All,


I would like to have your advice on how to fix the following issues:


- The first point is that after the creation of users who are entering data
through DHIS2 data capture, each of them has the following warning (409
conflict) when logging in the web interface mentioning that the user is not
allowed to view the org unit with an org unit UID that I could not locate
in the database (through SQL view). How to troubleshoot this issue?




​

-The second point is when using the reporting rate app, I am summarizing
the report by the administrative commune level (level 5 in the org unit
hierarchy). Instead of having 3 total of expected reports (red circle), the
app is counting the level 5 itself so the total expected reports become 4
(as illustrated in the image below), which is false. Are there some
parameters that I should set to fix this issue?



​

I am using DHIS2 2.19.


Thank you for your help.

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

Stronger health systems. Greater health impact.



www.msh.org

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Android data capture APK archives

[Raminosoa Rabemanantsoa, Tantely]

Thank you Sultan Ahamar. We will try and let you know.

Regards,

Tantely.

On Tue, May 3, 2016 at 9:07 AM, Sultanahamar Mohammad <
sult...@thoughtworks.com> wrote:

> Hi There,
>
> We have the following observation. For org units to show up, user that is
> logging in through android should be assigned to Level3 or level4 for org
> structure drawn below(assigning user to level1 does not work). Please try
> and let us know.
>
> Level1 <-   No datasets
>   Level2   <-  No datasets
>  Level3<- No datases
>Level4  <-   Datasets assigned.
>
> Regards,
> Sultan Ahamar.
>
> On Mon, May 2, 2016 at 3:12 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Thank you in advance for your support.
>>
>> Regards,
>> Tantely.
>>
>> On Mon, May 2, 2016 at 12:40 PM, Erling Fjelstad 
>> wrote:
>>
>>> You can use an older build for Data Capture:
>>> https://github.com/dhis2/dhis2-android-datacapture/releases/download/1.5.8/dhis2-android-app-debug.apk
>>> I'm happy to assist you if you want to use the app from Google Play, but
>>> then we need login credentials to your DHIS2 instance so we can see what is
>>> failing.
>>>
>>> Regards,
>>> Erling
>>>
>>> On Mon, May 2, 2016 at 11:31 AM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Hello Erling,
>>>>
>>>> I am using the one downloaded from Google Play, and have dispatched the
>>>> use of it for 100+ users. Some users find some difficulty to load the forms
>>>> from the Android data capture. They can log in but it takes time to load
>>>> the form and it ends with the message "swipe to update". I have tried to
>>>> solve it multiple times but there is no chance to load any form for them.
>>>> That is why I would like to try with an older version of the APK. Or do you
>>>> have another suggestions for this issue?
>>>>
>>>> Regards,
>>>>
>>>> Tantely.
>>>>
>>>> On Mon, May 2, 2016 at 12:12 PM, Erling Fjelstad 
>>>> wrote:
>>>>
>>>>> Hello Raminosoa,
>>>>> Have you tried the one on Google Play? I think that one should work
>>>>> for 2.19
>>>>>
>>>>> Regards,
>>>>> Erling
>>>>>
>>>>> On Mon, May 2, 2016 at 11:08 AM, Raminosoa Rabemanantsoa, Tantely <
>>>>> tramino...@mikolo.org> wrote:
>>>>>
>>>>>> Hello everyone,
>>>>>>
>>>>>> I am looking for archive versions of the android data capture app
>>>>>> APK. Could you please provide a link for a download of that? I am using
>>>>>> DHIS2 2.19.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> --
>>>>>> *Tantely Raminosoa*
>>>>>> *Data Officer*
>>>>>> Management Sciences for Health
>>>>>> Antananarivo Madagascar
>>>>>> Mobile: 0321180040
>>>>>> E-mail: tramino...@mikolo.org
>>>>>> Skype: traminosoa
>>>>>> <http://www.msh.org/>
>>>>>> Stronger health systems. Greater health impact.
>>>>>> <https://www.facebook.com/ManagementSciencesForHealth>
>>>>>> <https://twitter.com/MSHHealthImpact>
>>>>>> <https://www.youtube.com/user/MSHHealthImpact>
>>>>>> 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-us...@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> *Tantely Raminosoa*
>>>> *Data Officer*
>>>> Management Sciences for Health
>>>> Antananarivo Madagascar
>>>> Mobile: 0321180040
>>>> E-mail: tr

Re: [Dhis2-devs] [Dhis2-users] Android data capture APK archives

[Raminosoa Rabemanantsoa, Tantely]

Hello Erling,

I am using the one downloaded from Google Play, and have dispatched the use
of it for 100+ users. Some users find some difficulty to load the forms
from the Android data capture. They can log in but it takes time to load
the form and it ends with the message "swipe to update". I have tried to
solve it multiple times but there is no chance to load any form for them.
That is why I would like to try with an older version of the APK. Or do you
have another suggestions for this issue?

Regards,

Tantely.

On Mon, May 2, 2016 at 12:12 PM, Erling Fjelstad  wrote:

> Hello Raminosoa,
> Have you tried the one on Google Play? I think that one should work for
> 2.19
>
> Regards,
> Erling
>
> On Mon, May 2, 2016 at 11:08 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hello everyone,
>>
>> I am looking for archive versions of the android data capture app APK.
>> Could you please provide a link for a download of that? I am using DHIS2
>> 2.19.
>>
>> Thanks.
>>
>> --
>> *Tantely Raminosoa*
>> *Data Officer*
>> Management Sciences for Health
>> Antananarivo Madagascar
>> Mobile: 0321180040
>> E-mail: tramino...@mikolo.org
>> Skype: traminosoa
>> <http://www.msh.org/>
>> Stronger health systems. Greater health impact.
>> <https://www.facebook.com/ManagementSciencesForHealth>
>> <https://twitter.com/MSHHealthImpact>
>> <https://www.youtube.com/user/MSHHealthImpact>
>> 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-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Android data capture APK archives

[Raminosoa Rabemanantsoa, Tantely]

Thank you in advance for your support.

Regards,
Tantely.

On Mon, May 2, 2016 at 12:40 PM, Erling Fjelstad  wrote:

> You can use an older build for Data Capture:
> https://github.com/dhis2/dhis2-android-datacapture/releases/download/1.5.8/dhis2-android-app-debug.apk
> I'm happy to assist you if you want to use the app from Google Play, but
> then we need login credentials to your DHIS2 instance so we can see what is
> failing.
>
> Regards,
> Erling
>
> On Mon, May 2, 2016 at 11:31 AM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Hello Erling,
>>
>> I am using the one downloaded from Google Play, and have dispatched the
>> use of it for 100+ users. Some users find some difficulty to load the forms
>> from the Android data capture. They can log in but it takes time to load
>> the form and it ends with the message "swipe to update". I have tried to
>> solve it multiple times but there is no chance to load any form for them.
>> That is why I would like to try with an older version of the APK. Or do you
>> have another suggestions for this issue?
>>
>> Regards,
>>
>> Tantely.
>>
>> On Mon, May 2, 2016 at 12:12 PM, Erling Fjelstad 
>> wrote:
>>
>>> Hello Raminosoa,
>>> Have you tried the one on Google Play? I think that one should work for
>>> 2.19
>>>
>>> Regards,
>>> Erling
>>>
>>> On Mon, May 2, 2016 at 11:08 AM, Raminosoa Rabemanantsoa, Tantely <
>>> tramino...@mikolo.org> wrote:
>>>
>>>> Hello everyone,
>>>>
>>>> I am looking for archive versions of the android data capture app APK.
>>>> Could you please provide a link for a download of that? I am using DHIS2
>>>> 2.19.
>>>>
>>>> Thanks.
>>>>
>>>> --
>>>> *Tantely Raminosoa*
>>>> *Data Officer*
>>>> Management Sciences for Health
>>>> Antananarivo Madagascar
>>>> Mobile: 0321180040
>>>> E-mail: tramino...@mikolo.org
>>>> Skype: traminosoa
>>>> <http://www.msh.org/>
>>>> Stronger health systems. Greater health impact.
>>>> <https://www.facebook.com/ManagementSciencesForHealth>
>>>> <https://twitter.com/MSHHealthImpact>
>>>> <https://www.youtube.com/user/MSHHealthImpact>
>>>> 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-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>>
>> --
>> *Tantely Raminosoa*
>> *Data Officer*
>> Management Sciences for Health
>> Antananarivo Madagascar
>> Mobile: 0321180040
>> E-mail: tramino...@mikolo.org
>> Skype: traminosoa
>> <http://www.msh.org/>
>> Stronger health systems. Greater health impact.
>> <https://www.facebook.com/ManagementSciencesForHealth>
>> <https://twitter.com/MSHHealthImpact>
>> <https://www.youtube.com/user/MSHHealthImpact>
>> 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.*
>>
>
>


-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: tramino...@mikolo.org
Skype: traminosoa
<http://www.msh.org/>
Stronger health systems. Greater health impact.
<https://www.facebook.com/ManagementSciencesForHealth>
<https://twitter.com/MSHHealthImpact>
<https://www.youtube.com/user/MSHHealthImpact>
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Android data capture APK archives

[Raminosoa Rabemanantsoa, Tantely]

Hello everyone,

I am looking for archive versions of the android data capture app APK.
Could you please provide a link for a download of that? I am using DHIS2
2.19.

Thanks.

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

Stronger health systems. Greater health impact.



www.msh.org

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] ERRORS reported by the log file

[Raminosoa Rabemanantsoa, Tantely]

Dear Morten,

Thank you for your answer.

For ERROR 1: I have made an SQL select (in DHIS2) to find the the orgunit
with the mentioned uid but it does not appear in the list. It is something
strange as all the organisation units are listed in the query output.

For ERROR 2: It does not happen for all users. This error can appear
elsewhere in the logfile, without knowing the command which might cause it.
Running with incognito window did not make the error happen.

I am still stuck on this.

Regards.

Tantely

On Tue, Apr 26, 2016 at 5:16 AM, Morten Olav Hansen 
wrote:

> *ERROR 1*
>>
>> I have created a list of data entry users to use the android data capture
>> app. When they are accessing their account through the DHIS2 web interface,
>> the server is returning a pop-up message mentioning “409 conflict, the user
>> is not allowed to view org unit: ky58tsXe83tn”. Here what is telling the
>> log file at that time:.
>>
>>
>> * INFO  2016-04-22 10:48:11,751 Login success for user: 'dhis131miari',
>> ip: '172.31.28.246' (DefaultUserAuditService.java
>> [http-bio-8080-exec-11530])
>>
>> * ERROR 2016-04-22 10:49:44,229 Initialised statement manager
>> (StatementInterceptor.java [http-bio-8080-exec-11507])
>>
>> * ERROR 2016-04-22 10:49:44,371 Initialised statement manager
>> (StatementInterceptor.java [http-bio-8080-exec-11507])
>>
>
> If you go to edit user, make sure that the data view org unit selection
> allows him access to that org unit.
>
>
>> *ERROR 2*
>>
>> The log file error which is attached with this message is occurring
>> repeatedly and I would like some advice on how to get rid of it.
>>
>
> I'm not 100% sure what is causing this, does it always happen when running
> this? and does it happen for all users? also please try and run it a
> incognito window (for Chrome)
>
>
>> I am using DHIS2 2.19 - Java 7
>>
>>
>> Thank you for your support.
>>
>> *Tantely Raminosoa*
>> *Data Officer*
>> Management Sciences for Health
>> Antananarivo Madagascar
>> Mobile: 0321180040
>> E-mail: tramino...@mikolo.org
>> Skype: traminosoa
>> 
>> Stronger health systems. Greater health impact.
>> 
>> 
>> 
>> www.msh.org
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


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

Stronger health systems. Greater health impact.



www.msh.org

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] ERRORS reported by the log file

[Raminosoa Rabemanantsoa, Tantely]

Dear All,


I would like to ask your support in ordre to fix the following errors:


*ERROR 1*

I have created a list of data entry users to use the android data capture
app. When they are accessing their account through the DHIS2 web interface,
the server is returning a pop-up message mentioning “409 conflict, the user
is not allowed to view org unit: ky58tsXe83tn”. Here what is telling the
log file at that time:


* INFO  2016-04-22 10:48:11,751 Login success for user: 'dhis131miari', ip:
'172.31.28.246' (DefaultUserAuditService.java [http-bio-8080-exec-11530])

* ERROR 2016-04-22 10:49:44,229 Initialised statement manager
(StatementInterceptor.java [http-bio-8080-exec-11507])

* ERROR 2016-04-22 10:49:44,371 Initialised statement manager
(StatementInterceptor.java [http-bio-8080-exec-11507])



*ERROR 2*

The log file error which is attached with this message is occurring
repeatedly and I would like some advice on how to get rid of it.


I am using DHIS2 2.19 - Java 7


Thank you for your support.

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

Stronger health systems. Greater health impact.



www.msh.org

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
* ERROR 2016-04-01 08:18:53,023 Error while executing action 
(ExceptionInterceptor.java [http-bio-8080-exec-640])
java.lang.NullPointerException
at 
org.hisp.dhis.reporting.completeness.action.GetDataCompletenessAction.execute(GetDataCompletenessAction.java:207)
at sun.reflect.GeneratedMethodAccessor1448.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
at 
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:91)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:92)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:100)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:150)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:83)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:84)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:85)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:116)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:139)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)
at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at 
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
at 
com.opens

[Dhis2-devs] DHIS2 crashes during login

[Raminosoa Rabemanantsoa, Tantely]

Hello everyone,


I am a new user of DHIS2. I am working with a DHIS2 application that has
already been installed last year inside an Amazon cloud web server.  The
version that we have is DHIS2 2.19. The Tomcat version is 1.7. All the data
elements, organization unit and questionnaires have been integrated into
the system.


We are observing odd situation such as Tomcat is crashing each time a
couple of users (15+) are accessing DHIS2 simultaneously, especially when
they are using the DHIS2 Data Capture within tablets. DHIS2 is only back
after restarting Tomcat.


Do you know the Server and JVM memory specifications that are recommended
to expect about 300 concurrent DHIS2 users?


Here are some Java environment variables and server caracteristics that we
are using:


Java opts:   -Xms1024m -Xmx2048m -XX:PermSize=256m
-XX:MaxPermSize=512m

Java version: 1.7.0_91

OS name:Linux

OS architecture:amd64

OS version:4.1.10-17.31.amzn1.x86_64

Server memory:Mem Total in JVM: 1243 Free in JVM: 547 Max Limit: 1820

CPU cores:2

Server RAM: 3.75 G


Thank you for your support!


Tantely.

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp