date:20180213

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Martin Van Aken

Hi everyone.

Thanks Lars for the answer - we face problems with priorities (hence
needing parenthesis) there too. Glad to know this will be solved, but what
would be the possible workarounds in the meantime? I wanted to decompose in
different indicators, but programIndicators can't use other
programIndicators (like the "aggregate" indicators does), correct? Any
other way we would apply our proper priorities ?

Thanks,

Martin

On Wed, Feb 14, 2018 at 8:18 AM, Lars Helge Øverland  wrote:

> HI Aaron,
>
> that sounds good, glad to hear you got cross-stage calculations to work.
>
> Unfortunately program indicator expressions do not support nested
> parentheses/functions - we plan to develop a new version of our program
> indicator parser which will be more flexible in this regard.
>
> regards,
>
> Lars
>
>
> On 13 February 2018 at 20:56, Aaron C White  wrote:
>
>> Thanks, Lars and Preeti.  I checked the indicator formulation and found a
>> problem with a d2:condition() statement using a text option set value.  I
>> converted it to an integer and was able to see the calculated data across
>> stages.  I think it might be related to the parentheses issue inside the
>> condition as a few other recent emails have suggested.  How should the
>> condition be formulated if you also need to check a text option inside that
>> condition?  Using double quotes on the outside of the formulation does not
>> seem to work properly.  i.e. d2:condition("my_de == '3'", true, false)
>>
>> Aaron
>>
>>
>> --
>> Aaron C. White
>> 919.522.5585 <(919)%20522-5585>
>>
>> On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Aaron,
>>>
>>> from your description I think enrollment type program indicators will be
>>> appropriate. Can you tell us a bit more about your usecase? I am assuming
>>> you want information from two different stages in the *same* program.
>>> Do you have multiple enrollments per person (TEI) in your program? If not I
>>> think enrollment indicators will do the job.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On 8 February 2018 at 21:49, Aaron C White 
>>> wrote:
>>>
 Hi all,

 I'm trying to create a program indicator (or just query to the API
 directly) that evaluates conditions on data elements from two different
 event stages and then be used to find a relevant tracked entity attribute.

 From the docs, it seems that a program indicator type of enrollment
 would be most appropriate, but this only works at the aggregate level and
 not at an individual tracked entity instance level.  When I use an event
 type indicator, I don't receive any values back because the indicator
 definition contains data from two stages.

 Am I correct in this assessment?  Any thoughts on how to get around
 this?

 I've been testing on a v2.28 instance.  A similar reference example
 from the demo server would be the "Weight gain(in g) between birth and last
 postnatal for Child Programme" program indicator.  The one change would be
 that I want to see the weight gain for individual TEIs and view a TEA based
 on the weight gain amount instead of the average over all tracked entity
 instances.

 Thanks in advance,

 Aaron

 --
 Aaron C. White
 919.522.5585 <(919)%20522-5585>

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

-- 
*Martin Van Aken - **Freelance Enthusiast Developer*

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken 
Call me on Skype : vanakenm
Hang out with me : mar...@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Lars Helge Øverland

HI Aaron,

that sounds good, glad to hear you got cross-stage calculations to work.

Unfortunately program indicator expressions do not support nested
parentheses/functions - we plan to develop a new version of our program
indicator parser which will be more flexible in this regard.

regards,

Lars


On 13 February 2018 at 20:56, Aaron C White  wrote:

> Thanks, Lars and Preeti.  I checked the indicator formulation and found a
> problem with a d2:condition() statement using a text option set value.  I
> converted it to an integer and was able to see the calculated data across
> stages.  I think it might be related to the parentheses issue inside the
> condition as a few other recent emails have suggested.  How should the
> condition be formulated if you also need to check a text option inside that
> condition?  Using double quotes on the outside of the formulation does not
> seem to work properly.  i.e. d2:condition("my_de == '3'", true, false)
>
> Aaron
>
>
> --
> Aaron C. White
> 919.522.5585
>
> On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland 
> wrote:
>
>> Hi Aaron,
>>
>> from your description I think enrollment type program indicators will be
>> appropriate. Can you tell us a bit more about your usecase? I am assuming
>> you want information from two different stages in the *same* program. Do
>> you have multiple enrollments per person (TEI) in your program? If not I
>> think enrollment indicators will do the job.
>>
>> regards,
>>
>> Lars
>>
>>
>> On 8 February 2018 at 21:49, Aaron C White  wrote:
>>
>>> Hi all,
>>>
>>> I'm trying to create a program indicator (or just query to the API
>>> directly) that evaluates conditions on data elements from two different
>>> event stages and then be used to find a relevant tracked entity attribute.
>>>
>>> From the docs, it seems that a program indicator type of enrollment
>>> would be most appropriate, but this only works at the aggregate level and
>>> not at an individual tracked entity instance level.  When I use an event
>>> type indicator, I don't receive any values back because the indicator
>>> definition contains data from two stages.
>>>
>>> Am I correct in this assessment?  Any thoughts on how to get around this?
>>>
>>> I've been testing on a v2.28 instance.  A similar reference example from
>>> the demo server would be the "Weight gain(in g) between birth and last
>>> postnatal for Child Programme" program indicator.  The one change would be
>>> that I want to see the weight gain for individual TEIs and view a TEA based
>>> on the weight gain amount instead of the average over all tracked entity
>>> instances.
>>>
>>> Thanks in advance,
>>>
>>> Aaron
>>>
>>> --
>>> Aaron C. White
>>> 919.522.5585 <(919)%20522-5585>
>>>
>>> ___
>>> 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 
>>
>>
>


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

Re: [Dhis2-devs] Support for Time and DateTime

2018-02-13 Thread Bernard Sadaka (IM Advisor)

Thank you.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:52 PM
To: Bernard Sadaka (IM Advisor) 
Cc: dhis2-users ; DHIS 2 developers 

Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi again,

I will push a fix to the repository. The fix will be for version 2.28 and 2.29.

If all goes as planned you should be able to download a new war-file at the end 
of the day or latest tomorrow.



Regards

- Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.48 skrev Bernard Sadaka (IM Advisor)  >:



Thank you Lukas,

You will add them to JIRA? To the repository?

When/where will the fix be available for download? In the WAR file? If yes, 
which one?

All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [  
mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:42 PM
To: Bernard Sadaka (IM Advisor) <  
lib@pu-ami.org>
Cc: dhis2-users <  
dhis2-us...@lists.launchpad.net>; DHIS 2 developers < 
 dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

Apparently they have been missed out. I will add them now.



Best regards,

Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.17 skrev Bernard Sadaka (IM Advisor) < 
 lib@pu-ami.org>:



Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance, the 
Support for Time and DateTime is working in the “maintenance” app but not in 
the “event capture” app (didn’t test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:  
 
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I missing 
something?



Thank you again for the support.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org








  _



  <~WRD000.jpg>

This email has been checked for viruses by Avast antivirus software.
  www.avast.com






___
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 email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Aaron C White

Thanks, Lars and Preeti.  I checked the indicator formulation and found a
problem with a d2:condition() statement using a text option set value.  I
converted it to an integer and was able to see the calculated data across
stages.  I think it might be related to the parentheses issue inside the
condition as a few other recent emails have suggested.  How should the
condition be formulated if you also need to check a text option inside that
condition?  Using double quotes on the outside of the formulation does not
seem to work properly.  i.e. d2:condition("my_de == '3'", true, false)

Aaron


--
Aaron C. White
919.522.5585

On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland  wrote:

> Hi Aaron,
>
> from your description I think enrollment type program indicators will be
> appropriate. Can you tell us a bit more about your usecase? I am assuming
> you want information from two different stages in the *same* program. Do
> you have multiple enrollments per person (TEI) in your program? If not I
> think enrollment indicators will do the job.
>
> regards,
>
> Lars
>
>
> On 8 February 2018 at 21:49, Aaron C White  wrote:
>
>> Hi all,
>>
>> I'm trying to create a program indicator (or just query to the API
>> directly) that evaluates conditions on data elements from two different
>> event stages and then be used to find a relevant tracked entity attribute.
>>
>> From the docs, it seems that a program indicator type of enrollment would
>> be most appropriate, but this only works at the aggregate level and not at
>> an individual tracked entity instance level.  When I use an event type
>> indicator, I don't receive any values back because the indicator definition
>> contains data from two stages.
>>
>> Am I correct in this assessment?  Any thoughts on how to get around this?
>>
>> I've been testing on a v2.28 instance.  A similar reference example from
>> the demo server would be the "Weight gain(in g) between birth and last
>> postnatal for Child Programme" program indicator.  The one change would be
>> that I want to see the weight gain for individual TEIs and view a TEA based
>> on the weight gain amount instead of the average over all tracked entity
>> instances.
>>
>> Thanks in advance,
>>
>> Aaron
>>
>> --
>> Aaron C. White
>> 919.522.5585 <(919)%20522-5585>
>>
>> ___
>> 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 
>
>
___
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] Support for Time and DateTime

2018-02-13 Thread Bernard Sadaka (IM Advisor)

Thank you Lukas,

You will add them to JIRA? To the repository?

When/where will the fix be available for download? In the WAR file? If yes, 
which one?

All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:42 PM
To: Bernard Sadaka (IM Advisor) 
Cc: dhis2-users ; DHIS 2 developers 

Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

Apparently they have been missed out. I will add them now.



Best regards,

Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.17 skrev Bernard Sadaka (IM Advisor)  >:



Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance, the 
Support for Time and DateTime is working in the “maintenance” app but not in 
the “event capture” app (didn’t test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:  
 
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I missing 
something?



Thank you again for the support.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org








  _


 

This email has been checked for viruses by Avast antivirus software.
  www.avast.com





___
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 email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Support for Time and DateTime

2018-02-13 Thread Bernard Sadaka (IM Advisor)

Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance,
the Support for Time and DateTime is working in the maintenance app but
not in the event capture app (didnt test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I
missing something?



Thank you again for the support.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] DHIS 2 Symposium - Register now!

2018-02-13 Thread Lars Helge Øverland

Hi all,

we are gearing up for the biggest DHIS 2 event of the year, happening in
just a few weeks on March 22nd and 23rd in Washington, DC. If you haven't
registered
 yet,
don't wait, as tickets are limited, and we have sold out every year.

This year we have an exciting lineup of nearly 30 speakers across a variety
of organizations, experiences and technical expertise on the agenda. You
can see speakers, sessions and who's attending here
. As we confirm additional speakers
we will update the agenda.

We've added more breakout sessions so that we touch on a variety of
different topics from technical to implementation. Don't miss this
opportunity to learn about the latest and greatest news in the DHIS 2
community.  We look forward to seeing you there!

Register here
!


regards,

Lars



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

Re: [Dhis2-devs] table for Category Options

2018-02-13 Thread Bob Jolliffe

Sure Calle, I guess postgres must defend itself from the likes of us :-)

On 13 February 2018 at 09:48, Calle Hedberg  wrote:
> Morten
>
> Thanks for prompt reply, I had actually looked at the properties for that
> and all other tables with category/options in the name (in pgadmin), but it
> was showing with only 1 records. Had to actually open the table to see the
> options, so I guess postgresql don't automatically update it's meta-data
> tables with accurate record counts. Lesson learnt...
>
> Regards
> Calle
>
> On 13 February 2018 at 11:40, Morten Olav Hansen  wrote:
>>
>> dataelementcategoryoption
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg 
>> wrote:
>>>
>>> Hi
>>>
>>> Quick question: I have just added two CATEGORY OPTIONS to an instance -
>>> but in which table in the database are those options stored?
>>>
>>> Regards
>>> Calle
>>>
>>> ***
>>>
>>> Calle Hedberg
>>>
>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>
>>> Tel/fax (home): +27-21-685-6472
>>>
>>> Cell: +27-82-853-5352
>>>
>>> Iridium SatPhone: +8816-315-19119
>>>
>>> Email: calle.hedb...@gmail.com
>>>
>>> Skype: calle_hedberg
>>>
>>> ***
>>>
>>>
>>>
>>> ___
>>> 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
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
>
> ___
> 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
>

___
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] Updating data elements via CSV import eliminates aggregationlevels

2018-02-13 Thread Calle Hedberg

Hi,

I see that importing a set of data elements - some new, some existing - is
wiping out all stored aggregation levels for existing data elements.

is this a bug or intended behaviour?

Regards
Calle

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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] table for Category Options

2018-02-13 Thread Calle Hedberg

Morten

Thanks for prompt reply, I had actually looked at the properties for that
and all other tables with category/options in the name (in pgadmin), but it
was showing with only 1 records. Had to actually open the table to see the
options, so I guess postgresql don't automatically update it's meta-data
tables with accurate record counts. Lesson learnt...

Regards
Calle

On 13 February 2018 at 11:40, Morten Olav Hansen  wrote:

> dataelementcategoryoption
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg 
> wrote:
>
>> Hi
>>
>> Quick question: I have just added two CATEGORY OPTIONS to an instance -
>> but in which table in the database are those options stored?
>>
>> Regards
>> Calle
>>
>> ***
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>> 
>>
>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>
>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>
>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>
>> Email: calle.hedb...@gmail.com
>>
>> Skype: calle_hedberg
>>
>> ***
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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] Meta-data export with dependencies Fails

2018-02-13 Thread Calle Hedberg

Hi

I'm trying to export a single data set from one instance to another - it is
a relatively simple data set with about 20 data elements, all using the
same categorycombo.

Import fails with the following message:

org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "uk_qp9201a4m6jl53sei0huh4l6s"
  Detail: Key (shortname)=(default) already exists.

So it looks like the import cannot handle that the "default" catcombo
obviously vary from the source to the destination instance.

Is this a bug, or expected behaviour?

Regards
Calle

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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] table for Category Options

2018-02-13 Thread Morten Olav Hansen

dataelementcategoryoption

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

On Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg 
wrote:

> Hi
>
> Quick question: I have just added two CATEGORY OPTIONS to an instance -
> but in which table in the database are those options stored?
>
> Regards
> Calle
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> 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
>
>
___
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 Category Options

2018-02-13 Thread Calle Hedberg

Hi

Quick question: I have just added two CATEGORY OPTIONS to an instance - but
in which table in the database are those options stored?

Regards
Calle

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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] Program Indicator using data from multiple event stages to find TEA

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

Re: [Dhis2-devs] Support for Time and DateTime

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

Re: [Dhis2-devs] Support for Time and DateTime

[Dhis2-devs] Support for Time and DateTime

[Dhis2-devs] DHIS 2 Symposium - Register now!

Re: [Dhis2-devs] table for Category Options

[Dhis2-devs] Updating data elements via CSV import eliminates aggregationlevels

Re: [Dhis2-devs] table for Category Options

[Dhis2-devs] Meta-data export with dependencies Fails

Re: [Dhis2-devs] table for Category Options

[Dhis2-devs] table for Category Options

13 matches

Site Navigation

Mail list logo

Footer information