[Dhis2-users] complex category combo for Datasets doesn't show outputs

[Dipali Sahu]

Hi DHIS2 Community

I am wondering if assigning complex category combinations to a DATASET will
work. I have a use case where the activities are supported by 2 donors and
hence data is accounted in 2 different projects. I created a dataset shown
as below. Although on in(or even any 2 categories like both the donors),
the report shows no values.

In a similar case, where I assign a complex category combo to a data
element, everything works fine.
Am I doing something wrong here?? Kindly help


[image: Inline image 1]

Thank you
Deepali
International Medical Corps
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Fwd: user access to create program indicators

[Dipali Sahu]

Hi,, any hints will be helpful :)

-- Forwarded message --
From: Dipali Sahu 
Date: Wed, Sep 28, 2016 at 2:48 PM
Subject: user access to create program indicators
To: DHIS 2 Users list 


Hi

Is there a user access right to allow users to create/edit Program
indicators.

I have around 20 Programs and one of the user needs access only to one
program and create program indicator in it. The user is not able to 'View
program indicators' function on left clicking the program until I provide
'All' user rights to the user role.

Please advise

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

Re: [Dhis2-users] [Dhis2-devs] Fwd: user access to create program indicators

[Elmarie Claasen]

Diphali,

I have not tried it but if you give the relevant program permissions and
share the one program and all the dependencies like Attributes, Data
elements, optionsets etc with a group that user belongs to to "view and
edit" the user shohmd only be able to create program indicaors for that
program.

Elmarie

On 29 Sep 2016 17:10, "Dipali Sahu"  wrote:

> Hi,, any hints will be helpful :)
>
> -- Forwarded message --
> From: Dipali Sahu 
> Date: Wed, Sep 28, 2016 at 2:48 PM
> Subject: user access to create program indicators
> To: DHIS 2 Users list 
>
>
> Hi
>
> Is there a user access right to allow users to create/edit Program
> indicators.
>
> I have around 20 Programs and one of the user needs access only to one
> program and create program indicator in it. The user is not able to 'View
> program indicators' function on left clicking the program until I provide
> 'All' user rights to the user role.
>
> Please advise
>
> Thank you
> Deepali
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

-- 


*This message and any attachments are subject to a disclaimer published at 
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.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] UID generation

[Morten Olav Hansen]

A third alternative is to just get it from DHIS2 itself,

https://play.dhis2.org/dev/api/system/id.json?limit=1000
https://play.dhis2.org/dev/api/system/id.xml?limit=1000
https://play.dhis2.org/dev/api/system/id.csv?limit=1000

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

On Thu, Sep 29, 2016 at 5:00 PM, Arun Paul  wrote:

> Thanks Lars, Jason for the quick response !
> That solution worked for me.
>
> ​Regards
> ,
> - Arun Paul
>
> On Thu, Sep 29, 2016 at 2:55 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> If you are using Postgres to inject the data directly, you can use this
>>
>> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/uid.sql
>>
>> Regards,
>> Jason
>>
>> On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland 
>> wrote:
>>
>>> In fact,  generateCode(); will do.
>>>
>>> Lars
>>>
>>>
>>> On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland 
>>> wrote:
>>>
 Hi Arun,

 if you are using the DHIS 2 Java service layers there is no need to
 manually generate and set UIDs. They will be automatically set before the
 object is saved.

 To generate UIDs you should use this class: 
 org.hisp.dhis.commonCodeGenerator
 -> generateCode( 11 );

 Javadoc:

 http://ci.dhis2.org/job/dhis2-2.24-javadoc/javadoc/org/hisp/
 dhis/common/CodeGenerator.html



 regards,

 Lars


 On Thu, Sep 29, 2016 at 11:17 AM, Arun Paul 
 wrote:

> Hello everyone,
>
> I am trying to import legacy data into a new DHIS2 installation using
> custom code.
>
> While adding new entries into a database table, I need to assign new
> UID values. What is the algorithm I should use to generated these IDs ? I
> tried using a postgresql extension called uuid-ossp and the
> function uuid_generate_v1() that comes with that extension. But it
> generates uuid of the format ebe87e56-8624-11e6-a4ce-040157be4e01 and
> it's bigger than what CHARACTER VARYING(11) can hold. Any idea what
> strategy should I follow here to easily generate UIDs while inserting
> database entries?
>
> Thanks in advance.
> - Arun Paul
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 l...@dhis2.org
 http://www.dhis2.org 


>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> l...@dhis2.org
>>> http://www.dhis2.org 
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] UID generation

[Arun Paul]

Thanks Lars, Jason for the quick response !
That solution worked for me.

​Regards
,
- Arun Paul

On Thu, Sep 29, 2016 at 2:55 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> If you are using Postgres to inject the data directly, you can use this
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/uid.sql
>
> Regards,
> Jason
>
> On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland 
> wrote:
>
>> In fact,  generateCode(); will do.
>>
>> Lars
>>
>>
>> On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Arun,
>>>
>>> if you are using the DHIS 2 Java service layers there is no need to
>>> manually generate and set UIDs. They will be automatically set before the
>>> object is saved.
>>>
>>> To generate UIDs you should use this class: 
>>> org.hisp.dhis.commonCodeGenerator
>>> -> generateCode( 11 );
>>>
>>> Javadoc:
>>>
>>> http://ci.dhis2.org/job/dhis2-2.24-javadoc/javadoc/org/hisp/
>>> dhis/common/CodeGenerator.html
>>>
>>>
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Thu, Sep 29, 2016 at 11:17 AM, Arun Paul  wrote:
>>>
 Hello everyone,

 I am trying to import legacy data into a new DHIS2 installation using
 custom code.

 While adding new entries into a database table, I need to assign new
 UID values. What is the algorithm I should use to generated these IDs ? I
 tried using a postgresql extension called uuid-ossp and the
 function uuid_generate_v1() that comes with that extension. But it
 generates uuid of the format ebe87e56-8624-11e6-a4ce-040157be4e01 and
 it's bigger than what CHARACTER VARYING(11) can hold. Any idea what
 strategy should I follow here to easily generate UIDs while inserting
 database entries?

 Thanks in advance.
 - Arun Paul

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


>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> l...@dhis2.org
>>> http://www.dhis2.org 
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] UID generation

[Arun Paul]

Hello everyone,

I am trying to import legacy data into a new DHIS2 installation using
custom code.

While adding new entries into a database table, I need to assign new UID
values. What is the algorithm I should use to generated these IDs ? I tried
using a postgresql extension called uuid-ossp and the
function uuid_generate_v1() that comes with that extension. But it
generates uuid of the format ebe87e56-8624-11e6-a4ce-040157be4e01 and it's
bigger than what CHARACTER VARYING(11) can hold. Any idea what strategy
should I follow here to easily generate UIDs while inserting database
entries?

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

Re: [Dhis2-users] UID generation

[Lars Helge Øverland]

In fact,  generateCode(); will do.

Lars


On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland 
wrote:

> Hi Arun,
>
> if you are using the DHIS 2 Java service layers there is no need to
> manually generate and set UIDs. They will be automatically set before the
> object is saved.
>
> To generate UIDs you should use this class: org.hisp.dhis.commonCodeGenerator
> -> generateCode( 11 );
>
> Javadoc:
>
> http://ci.dhis2.org/job/dhis2-2.24-javadoc/javadoc/org/hisp/
> dhis/common/CodeGenerator.html
>
>
>
> regards,
>
> Lars
>
>
> On Thu, Sep 29, 2016 at 11:17 AM, Arun Paul  wrote:
>
>> Hello everyone,
>>
>> I am trying to import legacy data into a new DHIS2 installation using
>> custom code.
>>
>> While adding new entries into a database table, I need to assign new UID
>> values. What is the algorithm I should use to generated these IDs ? I tried
>> using a postgresql extension called uuid-ossp and the
>> function uuid_generate_v1() that comes with that extension. But it
>> generates uuid of the format ebe87e56-8624-11e6-a4ce-040157be4e01 and
>> it's bigger than what CHARACTER VARYING(11) can hold. Any idea what
>> strategy should I follow here to easily generate UIDs while inserting
>> database entries?
>>
>> Thanks in advance.
>> - Arun Paul
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>


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

Re: [Dhis2-users] UID generation

[Lars Helge Øverland]

Hi Arun,

if you are using the DHIS 2 Java service layers there is no need to
manually generate and set UIDs. They will be automatically set before the
object is saved.

To generate UIDs you should use this
class: org.hisp.dhis.commonCodeGenerator -> generateCode( 11 );

Javadoc:

http://ci.dhis2.org/job/dhis2-2.24-javadoc/javadoc/org/hisp/dhis/common/CodeGenerator.html



regards,

Lars


On Thu, Sep 29, 2016 at 11:17 AM, Arun Paul  wrote:

> Hello everyone,
>
> I am trying to import legacy data into a new DHIS2 installation using
> custom code.
>
> While adding new entries into a database table, I need to assign new UID
> values. What is the algorithm I should use to generated these IDs ? I tried
> using a postgresql extension called uuid-ossp and the
> function uuid_generate_v1() that comes with that extension. But it
> generates uuid of the format ebe87e56-8624-11e6-a4ce-040157be4e01 and
> it's bigger than what CHARACTER VARYING(11) can hold. Any idea what
> strategy should I follow here to easily generate UIDs while inserting
> database entries?
>
> Thanks in advance.
> - Arun Paul
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-users] How to define data element with multiple input type ?

[Brajesh Murari]

Hello Devs,

I have a data element "Child Care Institutions (CCIs) that have submitted
quarterly report" with three different input type

1. Boolean ( Yes/No )
2. Number
3. Percentage

How should i define above data element that i can use it for capturing data
for above all the three different input types ?

-- 
Brajesh Murari
| Senior Technical Annalist | www.sdrc.co.in | Ph: (+91) -9430124938 |
Skype: brajesh.murari |
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Fwd: Problem with hibernate_sequence on DHIS2 2.22 installation process

[Lars Helge Øverland]

Hi Bacabar,

this indicates that your database configuration file is not picked up.

Try having a "dhis.conf" configuration file with the following property
files (Brajesh your example is wrong) as stated in the docs

:

Lars

# --
# Database connection for PostgreSQL
# --

# Hibernate SQL dialect
connection.dialect = org.hibernate.dialect.PostgreSQLDialect

# JDBC driver class
connection.driver_class = org.postgresql.Driver

# Database connection URL
connection.url = jdbc:postgresql:dhis2

# Database username
connection.username = dhis

# Database password (sensitive)
connection.password = 

# Database schema behavior, can be 'validate', 'update', 'create', 'create-drop'
connection.schema = update

# Max size of connection pool (default: 40)
# connection.pool.max_size = 40


On Thu, Sep 29, 2016 at 6:31 AM, Brajesh Murari 
wrote:

> Hello Babacar,
>
> Replace and reconfigure your "dhis.conf" file available in "DHIS2_HOME"
> directory with following as given below, from
>
> hibernate.connection.schema = update
>
> to
>
> hibernate.hbm2ddl.auto = update
>
> Your dhis.conf should looks like as given below, if you are using
> postgresql database
>
>   hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
>   hibernate.connection.driver_class = org.postgresql.Driver
>   hibernate.connection.url = jdbc:postgresql:dhis2-UN
>   hibernate.connection.username = postgres
>   hibernate.connection.password = postgres
>   #Database schema behavior, can be validate, update, create, create-drop
>   #hibernate.connection.schema = update
>   hibernate.hbm2ddl.auto = update
>   encryption.password = abcd
>
>
> On Thu, Sep 29, 2016 at 5:33 AM, Knut Staring  wrote:
>
>> -- Forwarded message --
>> From: "Babacar NGOM" 
>> Date: Sep 28, 2016 7:18 PM
>> Subject: Problem with hibernate_sequence on DHIS2 2.22 installation
>> process
>> To: "Knut Staring" 
>> Cc:
>>
>> Hello,
>> I am about to install version 2.22 of DHIS2. After deployment, my
>> console displays the following errors:
>>
>> ​ERROR 2016-09-28 11:47:20,754 ERROR: sequence "hibernate_sequence" does
>> not exist (SchemaExport.java [localhost-startStop-1])
>>
>> Thank you to bring your help if possible.
>>
>> For completeness I add the lines from the log file catalina.out:
>>
>> * ERROR 2016-09-28 11: 47: 19.398 ERROR: relation "attribute" does not
>> exist (SchemaExport.java [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.401 HHH000389: Unsuccessful: alter table
>> drop constraint fk_attributevalue_attributeid AttributeValue
>> (SchemaExport.java [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.404 ERROR: relation "AttributeValue" does
>> not exist (SchemaExport.java [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.407 HHH000389: Unsuccessful: alter table
>> drop constraint caseaggregationcondition
>> fk_caseaggregationcondition_dataelement (SchemaExport.java [localhost
>> StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.409 ERROR: relation
>> "caseaggregationcondition" does not exist (SchemaExport.java [localhost
>> StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.413 HHH000389: Unsuccessful: alter table
>> drop constraint caseaggregationcondition
>> fk_caseaggregationcondition_categoryoptioncomboid (SchemaExport.java
>> [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.414 ERROR: relation
>> "caseaggregationcondition" does not exist (SchemaExport.java [localhost
>> StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.421 HHH000389: Unsuccessful: alter table
>> drop constraint caseaggregationcondition
>> fk_caseaggregationcondition_deSum (SchemaExport.java [localhost
>> StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.421 ERROR: relation
>> "caseaggregationcondition" does not exist (SchemaExport.java [localhost
>> StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.427 HHH000389: Unsuccessful: alter table
>> drop constraint categories_categoryoptions fk_category_categoryoptionid
>> (SchemaExport.java [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.428 ERROR: relation
>> "categories_categoryoptions" does not exist (SchemaExport.java
>> [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.430 HHH000389: Unsuccessful: alter table
>> drop constraint categories_categoryoptions
>> fk_categories_categoryoptions_categoryid (SchemaExport.java [localhost
>> StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.431 ERROR: relation
>> "categories_categoryoptions" does not exist (SchemaExport.java
>> [localhost StartStop-1])
>> * ERROR 2016-09-28 11: 47: 19.433 HHH000389: Unsuccessful: alter table
>> drop constraint categorycombo fk_categorycombo_userid (SchemaExport.java
>> [localhost StartStop-1])
>> *