[Dhis2-users] update tracker profile form

[channara rin]

dear all,
when i want to update some information of tracker profile. i got this below
error...
[image: Inline image 1]

how to fix this problem

best regards,
channara
___
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] Active Program in tracker capture

[channara rin]

Dear all,
i has problem with tracker capture.
when i open individual records, i can see program with tracker
But when i use tracker capture, i didn't see Active program like individual
records.
Any body know what is the problem? how to fix this problem?

[image: Inline image 1]

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

Re: [Dhis2-users] API: dataSets.dataElements

[Bob Jolliffe]

The reason why there isn't a backward compatible api is because the
underlying model has changed to support overriding the categorycombo per
dataset.  So a dataset no longer has dataElements, but dataSetElements.
The dataSetElement is a compound object consisting of both a dataelement
reference and (possibly) an overridden categoryCombo.  Where you haven't
overriden anything you don't see the latter.

I am sure this has broken a few things out there.

I wonder if a non-breaking solution would be to support the same behaviour
as before with the dereferencing being done behind the scenes.  With the
possible surprise that the response might also include a sibling
categorycombo with the dataelement.  And the risk that if legacy api users
ignore that fact (which almost by definition they will) they will report
the wrong categorycombo for the dataelement.

Or, even more transparently, any overriden categorycombo could be used to
replace the categorycombo in the returned dataelement.  In which case
everything would look exactly as before.  But users should be warned to not
make any assumption about categorycombo and *always* return that field as
part of the query.  I can see that becomes a pretty ugly constraint
though.  Possibly the previous suggestion is safer.

Lars and/or Morten would know best the reasons for taking the plunge and
doing it the way that it is done.  I wasn't in on the design discussion.
Possibly over the longer term it is a cleaner implementation to have the
api reflect the actual underlying changed model.  Not sure.





On 3 November 2016 at 14:21, Michael Mwebaze 
wrote:

> Thanks Uwe,
>
> I have been trying to figure this out as well.
>
>
>
> On 3 November 2016 at 04:04, Uwe Wahser  wrote:
>
>> just found the answer myself: it has to be
>> https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?pa
>> ging=false&fields=dataSetElements[dataElement[id,code,name]]
>>
>> the other question remains: why cant I use the old syntax by adding 24 or
>> 23 to
>> the url?
>>
>> Regards,
>>
>> Uwe
>>
>> ---
>> > Uwe Wahser  hat am 3. November 2016 um 09:52
>> geschrieben:
>> >
>> >
>> > Dear all,
>> >
>> > I am a bit confused about the api in 2.25. Before, I was able to list
>> > dataElements of a given dataSet via
>> > https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?pa
>> ging=false&fields=dataElements[id,code,name]
>> >
>> > As I understand from the manual, this has changed to
>> > https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?pa
>> ging=false&fields=dataSetElements[id,code,name]
>> >
>> > Two issues in this context:
>> > 1 - I would have expected to be able to use the old syntax by adding 24
>> or 23
>> > into the url - that doesn't work.
>> > 2 - the new syntax only works for the id of a dataSetElement and
>> doesn't bring
>> > up code nor name. fields=dataSetElements[:all] only brings up a few
>> attribute,
>> > but not neither code nor name.
>> >
>> > Am I missing something? Haven't tested with other sub-ressources, yet.
>> >
>> > Thanks,
>> >
>> > Uwe
>> >
>> > ___
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to : dhis2-users@lists.launchpad.net
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help   : https://help.launchpad.net/ListHelp
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] API: dataSets.dataElements

[Michael Mwebaze]

Thanks Uwe,

I have been trying to figure this out as well.



On 3 November 2016 at 04:04, Uwe Wahser  wrote:

> just found the answer myself: it has to be
> https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?
> paging=false&fields=dataSetElements[dataElement[id,code,name]]
>
> the other question remains: why cant I use the old syntax by adding 24 or
> 23 to
> the url?
>
> Regards,
>
> Uwe
>
> ---
> > Uwe Wahser  hat am 3. November 2016 um 09:52 geschrieben:
> >
> >
> > Dear all,
> >
> > I am a bit confused about the api in 2.25. Before, I was able to list
> > dataElements of a given dataSet via
> > https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?
> paging=false&fields=dataElements[id,code,name]
> >
> > As I understand from the manual, this has changed to
> > https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?
> paging=false&fields=dataSetElements[id,code,name]
> >
> > Two issues in this context:
> > 1 - I would have expected to be able to use the old syntax by adding 24
> or 23
> > into the url - that doesn't work.
> > 2 - the new syntax only works for the id of a dataSetElement and doesn't
> bring
> > up code nor name. fields=dataSetElements[:all] only brings up a few
> attribute,
> > but not neither code nor name.
> >
> > Am I missing something? Haven't tested with other sub-ressources, yet.
> >
> > Thanks,
> >
> > Uwe
> >
> > ___
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to : dhis2-users@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Issue with calculation of Age through program indicator

[Saurabh]

Thanks Markus for the response.

Will try again and share the results.

Regards

Saurabh

On 3 Nov 2016 19:16, "Markus Bekken"  wrote:

> Hi there Saurabh,
>
> The d2:yearsBetween() is not yet supported in the server side aggregation
> of program indicators. For now you would have to use d2:daysBetween() / 365
> - which is not 100% correct as the leap years is not considered. You wrote
> d2daysBetween in your mail below(without the colon between d2 and
> daysBetween), but i assume that was a typo in the mail.
> If you used the expression 
> *d2:daysBetween(A{yourDateOfBirthAttributeUID},V{event_date})
> / 365* that should work fine on both the server and client side. Let me
> know if this was the expression you tried. Note that the attribute UID
> should be prefixed with A.
>
> In the dev instance the example indicators on the MNCH / PHC program use
> the V{event_date} as basis for the age calculation. This causes the
> indicators to be calculated to NaN until you enter an event date. If you do
> not explicitly want the age at the event, you can use V{enrollment_date}
> instead.
>
> Markus
>
> P.S. The attributes of type date is not shown in the expression part of
> the Program Indicator UI, only in the filter further down. This is all
> getting reworked and sorted out soon, but as a workaround for avoiding
> typos you can add the attribute in the filter part of the UI then
> cut'n'paste.
>
> 18. okt. 2016 kl. 18.11 skrev Saurabh :
>
> Hi Devs
>
> Have been trying to create a program indicator for calculation of Age (in
> years) using the ‘d2yearsBetween’ expression (have tried with
> ‘d2daysBetween’ as well), and then putting the attribute for date of birth,
> and event/current date. The date of birth is not part of the attribute list
> in the ‘Expression’ part of the program indicator, hence the attribute UID
> (for DOB) is used instead in the expression.
>
> Although the expression is shown as valid, but the output is still ‘NaN’.
>
> Similar indicators are available on the dev instance (
> https://play.dhis2.org/dev/) for the MNCH program for Mother’s Age at
> visit in years/days, but there also the value shows as ‘NaN’.
>
> Would appreciate some help around this, if this can be fixed, or we are
> doing something wrong here!
>
> Regards
>
> Saurabh
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Issue with calculation of Age through program indicator

[Markus Bekken]

Hi there Saurabh,

The d2:yearsBetween() is not yet supported in the server side aggregation of 
program indicators. For now you would have to use d2:daysBetween() / 365 - 
which is not 100% correct as the leap years is not considered. You wrote 
d2daysBetween in your mail below(without the colon between d2 and daysBetween), 
but i assume that was a typo in the mail. 
If you used the expression 
d2:daysBetween(A{yourDateOfBirthAttributeUID},V{event_date}) / 365 that should 
work fine on both the server and client side. Let me know if this was the 
expression you tried. Note that the attribute UID should be prefixed with A. 

In the dev instance the example indicators on the MNCH / PHC program use the 
V{event_date} as basis for the age calculation. This causes the indicators to 
be calculated to NaN until you enter an event date. If you do not explicitly 
want the age at the event, you can use V{enrollment_date} instead.

Markus

P.S. The attributes of type date is not shown in the expression part of the 
Program Indicator UI, only in the filter further down. This is all getting 
reworked and sorted out soon, but as a workaround for avoiding typos you can 
add the attribute in the filter part of the UI then cut'n'paste.

> 18. okt. 2016 kl. 18.11 skrev Saurabh :
> 
> Hi Devs
>  
> Have been trying to create a program indicator for calculation of Age (in 
> years) using the ‘d2yearsBetween’ expression (have tried with ‘d2daysBetween’ 
> as well), and then putting the attribute for date of birth, and event/current 
> date. The date of birth is not part of the attribute list in the ‘Expression’ 
> part of the program indicator, hence the attribute UID (for DOB) is used 
> instead in the expression.
>  
> Although the expression is shown as valid, but the output is still ‘NaN’.
>  
> Similar indicators are available on the dev instance 
> (https://play.dhis2.org/dev/ ) for the MNCH 
> program for Mother’s Age at visit in years/days, but there also the value 
> shows as ‘NaN’.
>  
> Would appreciate some help around this, if this can be fixed, or we are doing 
> something wrong here!
>  
> Regards
>  
> Saurabh
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> 
> Post to : dhis2-d...@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Program indicators: how to calculate the proportion of female?

[Prosper BT]

Dear Lise,

You will need to create two program indicators

1. Count the number of patients enrolled
2. Count the number of patients enrolled who are Female

Then go to Aggregate Indicators and create an indicator using program
Indicators with Indicator 2 as numerator and Indicator 1 and denominator.

Then this can be analyzed in Pivot tables as an aggregate indicator

Regards



Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Thu, Nov 3, 2016 at 3:41 PM, GROUT, Lise  wrote:

> Dear all,
>
>
> Sorry if it is a basic question, but we are trying to create a program
> indicator which is the proportion of female among the patients enrolled.
> How can we do this?
>
>
>
> We tried to first calculate the number of patients who are female, but
> then we cannot use this indicator to calculate the proportion…
>
>
>
> Any idea?
>
>
>
> Lise.
>
> ___
> 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] Program indicators: how to calculate the proportion of female?

[GROUT , Lise]

Dear Prosper, 
 
Thanks a lot. We have just seen it in maintenance, but it is very important to 
have your confirmation. 
 
Thanks. 
 
Lise
 
From: Prosper BT [mailto:ptb3...@gmail.com] 
Sent: 03 November 2016 13:49
To: GROUT, Lise
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] Program indicators: how to calculate the proportion 
of female?
 
Dear Lise,

 

You will need to create two program indicators

 

1. Count the number of patients enrolled

2. Count the number of patients enrolled who are Female

 

Then go to Aggregate Indicators and create an indicator using program 
Indicators with Indicator 2 as numerator and Indicator 1 and denominator.

 

Then this can be analyzed in Pivot tables as an aggregate indicator

 

Regards

 

 



Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139

pros...@hispuganda.org | pros...@dhis2.org | Skype: prospertb

 
On Thu, Nov 3, 2016 at 3:41 PM, GROUT, Lise  wrote:
Dear all, 

Sorry if it is a basic question, but we are trying to create a program 
indicator which is the proportion of female among the patients enrolled. How 
can we do this? 
 
We tried to first calculate the number of patients who are female, but then we 
cannot use this indicator to calculate the proportion…
 
Any idea?
 
Lise.


___
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] Program indicators: how to calculate the proportion of female?

[GROUT , Lise]

I have just seen that the program indicators are then available in 
“Maintenance”. 

Should we therefore create numerators and denominators as “Program indicators” 
and the proportion in “Indicators” ?
 
Best
 
From: GROUT, Lise 
Sent: 03 November 2016 13:42
To: DHIS 2 Users list
Subject: Program indicators: how to calculate the proportion of female?

 
Dear all, 

Sorry if it is a basic question, but we are trying to create a program 
indicator which is the proportion of female among the patients enrolled. How 
can we do this? 
 
We tried to first calculate the number of patients who are female, but then we 
cannot use this indicator to calculate the proportion…
 
Any idea?
 
Lise.


___
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] Program indicators: how to calculate the proportion of female?

[GROUT , Lise]

Dear all, 

Sorry if it is a basic question, but we are trying to create a program 
indicator which is the proportion of female among the patients enrolled. How 
can we do this? 
 
We tried to first calculate the number of patients who are female, but then we 
cannot use this indicator to calculate the proportion…
 
Any idea?
 
Lise.


___
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] 2.24 version. Error in program stage sections ordering

[Prosper BT]

Hi Marc,

We have been experiencing the same issue and reported it as a bug, lets
hope it will be fixed soon, otherwise we have been going to the back end
changing the section from null.

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Thu, Nov 3, 2016 at 12:55 PM, Marc Garnica 
wrote:

> Hi all,
>
> We recently found an error in dhis2 2.24 which we think can be a big
> issue. After creating several program stage sections we wanted to reorder
> them but when we tried to change the order of one section the section
> disappeared. We thought that they just were deleted but if we try to
> recreate them the system says that the Name of the section already exists
> (although it's not shown in the program stage section list).
>
> After looking at the database, we found these "ghost" sections which we
> don't how/when the programstageid was changed to null.
>
> Thank you all with advance,
>
> Marc Garnica
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Ant Snyman]

Hi Stanley,
To add on to what Abyot - if you are doing it via sql statements then the
following tables might also have been populated:

trackedentityaudit
trackedentitydatavalueaudit
trackedentityattributevalueaudit
programstageinstance_messageconversation
programstageinstancecomments

and would need to be cleaned up otherwise you will hit foreign key
constraints.

I would think it would be a lot easier to update the organisationunit id in
the following tables:

Programstageinstance
Programinstance
Trackedentityinstance

and the sql statement would be something like:

update programstageinstance
set organisationunitid =  (new orgunit's internal id)
where organisationunitid = nnn (current orgunit's internal id)
*(this will move all the trackerdata from the current orgunit to the new
orgunit)*

and

exactly the same for programinstance and trackedentityinstance.

Afterwards you would have to clear cache and re-run analytics

Regards

Ant

On 3 November 2016 at 11:57, Abyot Asalefew Gizaw  wrote:

> I don't have ready made statements at hand.
>
> But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in
> question
>
>1. Delete event values from trackedentitydatavalue
>2. Delete events from programstageinstance
>3. Delete enrollments from programinstance
>4. Delete attribute values from trackedentityattributevalue
>5. Delete the instance from trackedentityinstance
>
> More on the associations:
>
> trackedentityinstance uid -> trackedentityinstance id -> programinstance
> id -> programstageinstance id
>
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati 
> wrote:
>
>> Abyot,
>>
>> Could you help with the sql statements?
>>
>> Thanks in advance.
>>
>> Stanley
>>
>> On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw 
>> wrote:
>>
>>> Hi Stanley,
>>>
>>> It is only version 2.25 that has UI support for deleting Tracked Entity
>>> Instance. For the other versions, one has to do it manually using sql
>>> statements.
>>>
>>> --
>>> Abyot A. Gizaw.
>>> Senior Engineer, DHIS2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati 
>>> wrote:
>>>
 Colleagues,

 My colleague entered a tracked entity in a wrong OU and i want to
 delete that.Can someone tell me how to delete this entity? or move this
 entity to another OU.

 You usual support is always appreciated.

 Stanley


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


-- 

*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 
.  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] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Abyot Asalefew Gizaw]

I don't have ready made statements at hand.

But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in
question

   1. Delete event values from trackedentitydatavalue
   2. Delete events from programstageinstance
   3. Delete enrollments from programinstance
   4. Delete attribute values from trackedentityattributevalue
   5. Delete the instance from trackedentityinstance

More on the associations:

trackedentityinstance uid -> trackedentityinstance id -> programinstance id
-> programstageinstance id

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati  wrote:

> Abyot,
>
> Could you help with the sql statements?
>
> Thanks in advance.
>
> Stanley
>
> On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw 
> wrote:
>
>> Hi Stanley,
>>
>> It is only version 2.25 that has UI support for deleting Tracked Entity
>> Instance. For the other versions, one has to do it manually using sql
>> statements.
>>
>> --
>> Abyot A. Gizaw.
>> Senior Engineer, DHIS2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati 
>> wrote:
>>
>>> Colleagues,
>>>
>>> My colleague entered a tracked entity in a wrong OU and i want to delete
>>> that.Can someone tell me how to delete this entity? or move this entity to
>>> another OU.
>>>
>>> You usual support is always appreciated.
>>>
>>> Stanley
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[channara rin]

has sql statement to delete?

On Thu, Nov 3, 2016 at 4:57 PM, Abyot Asalefew Gizaw 
wrote:

> I don't have ready made statements at hand.
>
> But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in
> question
>
>1. Delete event values from trackedentitydatavalue
>2. Delete events from programstageinstance
>3. Delete enrollments from programinstance
>4. Delete attribute values from trackedentityattributevalue
>5. Delete the instance from trackedentityinstance
>
> More on the associations:
>
> trackedentityinstance uid -> trackedentityinstance id -> programinstance
> id -> programstageinstance id
>
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati 
> wrote:
>
>> Abyot,
>>
>> Could you help with the sql statements?
>>
>> Thanks in advance.
>>
>> Stanley
>>
>> On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw 
>> wrote:
>>
>>> Hi Stanley,
>>>
>>> It is only version 2.25 that has UI support for deleting Tracked Entity
>>> Instance. For the other versions, one has to do it manually using sql
>>> statements.
>>>
>>> --
>>> Abyot A. Gizaw.
>>> Senior Engineer, DHIS2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati 
>>> wrote:
>>>
 Colleagues,

 My colleague entered a tracked entity in a wrong OU and i want to
 delete that.Can someone tell me how to delete this entity? or move this
 entity to another OU.

 You usual support is always appreciated.

 Stanley


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


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

[Dhis2-users] 2.24 version. Error in program stage sections ordering

[Marc Garnica]

Hi all,

We recently found an error in dhis2 2.24 which we think can be a big issue.
After creating several program stage sections we wanted to reorder them but
when we tried to change the order of one section the section disappeared.
We thought that they just were deleted but if we try to recreate them the
system says that the Name of the section already exists (although it's not
shown in the program stage section list).

After looking at the database, we found these "ghost" sections which we
don't how/when the programstageid was changed to null.

Thank you all with advance,

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

Re: [Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Stanley Kalyati]

Erling,

It was on a desktop and the data is already in the database.

Should i just deactivate the entity?

Thanks

On Thu, Nov 3, 2016 at 11:23 AM, Erling Fjelstad  wrote:

> Hi Stanley,
> If the data has been entered from the Android client, and is still not
> sent to the server, you can delete with long pressing on the tracked entity
> instance and then press 'delete'. If the icon next to the tracked entity
> instance is a orange disk, this means it is still unsent. If it is marked
> with a green tick then it is sent to the server, and at the moment we
> cannot delete it. It is on the roadmap to implement this feature
>
> Regards,
> Erling
>
> On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati 
> wrote:
>
>> Colleagues,
>>
>> My colleague entered a tracked entity in a wrong OU and i want to delete
>> that.Can someone tell me how to delete this entity? or move this entity to
>> another OU.
>>
>> You usual support is always appreciated.
>>
>> Stanley
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Stanley Kalyati]

Abyot,

Could you help with the sql statements?

Thanks in advance.

Stanley

On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw 
wrote:

> Hi Stanley,
>
> It is only version 2.25 that has UI support for deleting Tracked Entity
> Instance. For the other versions, one has to do it manually using sql
> statements.
>
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati 
> wrote:
>
>> Colleagues,
>>
>> My colleague entered a tracked entity in a wrong OU and i want to delete
>> that.Can someone tell me how to delete this entity? or move this entity to
>> another OU.
>>
>> You usual support is always appreciated.
>>
>> Stanley
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Erling Fjelstad]

Hi Stanley,
If the data has been entered from the Android client, and is still not sent
to the server, you can delete with long pressing on the tracked entity
instance and then press 'delete'. If the icon next to the tracked entity
instance is a orange disk, this means it is still unsent. If it is marked
with a green tick then it is sent to the server, and at the moment we
cannot delete it. It is on the roadmap to implement this feature

Regards,
Erling

On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati  wrote:

> Colleagues,
>
> My colleague entered a tracked entity in a wrong OU and i want to delete
> that.Can someone tell me how to delete this entity? or move this entity to
> another OU.
>
> You usual support is always appreciated.
>
> Stanley
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Abyot Asalefew Gizaw]

Hi Stanley,

It is only version 2.25 that has UI support for deleting Tracked Entity
Instance. For the other versions, one has to do it manually using sql
statements.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati  wrote:

> Colleagues,
>
> My colleague entered a tracked entity in a wrong OU and i want to delete
> that.Can someone tell me how to delete this entity? or move this entity to
> another OU.
>
> You usual support is always appreciated.
>
> Stanley
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

[Stanley Kalyati]

Colleagues,

My colleague entered a tracked entity in a wrong OU and i want to delete
that.Can someone tell me how to delete this entity? or move this entity to
another OU.

You usual support is always appreciated.

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

Re: [Dhis2-users] API: dataSets.dataElements

[Uwe Wahser]

just found the answer myself: it has to be 
https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?paging=false&fields=dataSetElements[dataElement[id,code,name]]

the other question remains: why cant I use the old syntax by adding 24 or 23 to
the url?

Regards,

Uwe

---
> Uwe Wahser  hat am 3. November 2016 um 09:52 geschrieben:
> 
> 
> Dear all,
> 
> I am a bit confused about the api in 2.25. Before, I was able to list
> dataElements of a given dataSet via
> https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?paging=false&fields=dataElements[id,code,name]
> 
> As I understand from the manual, this has changed to 
> https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?paging=false&fields=dataSetElements[id,code,name]
> 
> Two issues in this context:
> 1 - I would have expected to be able to use the old syntax by adding 24 or 23
> into the url - that doesn't work.
> 2 - the new syntax only works for the id of a dataSetElement and doesn't bring
> up code nor name. fields=dataSetElements[:all] only brings up a few attribute,
> but not neither code nor name.
> 
> Am I missing something? Haven't tested with other sub-ressources, yet.
> 
> Thanks, 
> 
> Uwe
> 
> ___
> 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