Re: [Dhis2-devs] dhis sms dependency

[Tran Chau]

Sorry all. I added missing files.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Tue, May 29, 2012 at 7:06 PM, Bob Jolliffe  wrote:

> Thanks Lars.  I had commented it out and things are building fine.
> But there seems to be a slew of runtime errors now resulting from what
> looks like a partial commit last night:
>
> ClassNotFoundException
> org.hisp.dhis.caseentry.action.report.LoadPatientPropertiesAction
>
> On 29 May 2012 12:52, Lars Helge Øverland  wrote:
> > No I have removed it.
> >
> > Em, remember you cannot commit a dependency to a WAR which is not part of
> > the standard dhis build.
> >
> > Lars
> >
> > On Tue, May 29, 2012 at 1:48 PM, Bob Jolliffe 
> wrote:
> >>
> >> Currently my build of dhis-web is failing because of missing
> >> dhis-web-sms jar.  I now see that is in dhis-mobile project which I
> >> had not built.  Is it the intention that this should be a dependency
> >> of core dhis?
> >>
> >> ___
> >> 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
>
___
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] dhis sms dependency

[Tran Chau]

Hi Bob,

I built source on trunk with revision 7241. It runs ok.

Please test with the lastest revision again :)

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Fri, Jun 8, 2012 at 4:23 AM, Bob Jolliffe  wrote:

> Hi Tran
>
> I am getting the following compilation error:
>
> [INFO] Compilation failure
>
> /home/bobj/src/dhis/trunk-final/dhis2/dhis-2/dhis-services/dhis-service-sms/src/main/java/org/hisp/dhis/sms/incoming/HibernateIncomingSmsStore.java:[42,7]
> error: HibernateIncomingSmsStore is not abstract and does not override
> abstract method delete(IncomingSms) in IncomingSmsStore
>
> HibernateIncomingSmsStore doesn't seem to be in the dhis main sources.
>  I'm guessing this is in the dhis-mobile project again ...
>
> Bob
>
> On 29 May 2012 14:05, Tran Chau  wrote:
> > Sorry all. I added missing files.
> >
> > Best regards,
> > 
> > Châu Thu Trân
> > HISP Viet Nam
> > Email: tran.hispviet...@gmail.com
> >
> >
> >
> > On Tue, May 29, 2012 at 7:06 PM, Bob Jolliffe 
> wrote:
> >>
> >> Thanks Lars.  I had commented it out and things are building fine.
> >> But there seems to be a slew of runtime errors now resulting from what
> >> looks like a partial commit last night:
> >>
> >> ClassNotFoundException
> >> org.hisp.dhis.caseentry.action.report.LoadPatientPropertiesAction
> >>
> >> On 29 May 2012 12:52, Lars Helge Øverland  wrote:
> >> > No I have removed it.
> >> >
> >> > Em, remember you cannot commit a dependency to a WAR which is not part
> >> > of
> >> > the standard dhis build.
> >> >
> >> > Lars
> >> >
> >> > On Tue, May 29, 2012 at 1:48 PM, Bob Jolliffe 
> >> > wrote:
> >> >>
> >> >> Currently my build of dhis-web is failing because of missing
> >> >> dhis-web-sms jar.  I now see that is in dhis-mobile project which I
> >> >> had not built.  Is it the intention that this should be a dependency
> >> >> of core dhis?
> >> >>
> >> >> ___
> >> >> 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
> >
> >
>
___
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] [Bug 1040661] [NEW] Patient based quarry reports

[Tran Chau]

Dear Jeremiah,

Please explain this more clearly.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Thu, Aug 23, 2012 at 9:01 PM, Jeremiah  wrote:

> Public bug reported:
>
> There is no function to report or quarry report from patient module
> based on the organization unit, period and disease comparison.
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1040661
>
> Title:
>   Patient based quarry reports
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   There is no function to report or quarry report from patient module
>   based on the organization unit, period and disease comparison.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1040661/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 8178: Add datapicker for future

[Tran Chau]

Hi Lars, This is minor fix.  I added dataPickerFuture in commons.js in
rev. 8175. Sorry about the message :'(

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Fri, Sep 21, 2012 at 4:06 PM,  wrote:

> 
> revno: 8178
> committer: Tran Chau 
> branch nick: dhis2
> timestamp: Fri 2012-09-21 16:04:02 +0700
> message:
>   Add datapicker for future
> modified:
>
> dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm
>
>
> --
> lp:dhis2
> https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
>
> Your team DHIS 2 developers is subscribed to branch lp:dhis2.
> To unsubscribe from this branch go to
> https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
>
> === modified file
> 'dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm'
> ---
> dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm
> 2012-09-18 03:50:06 +
> +++
> dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm
> 2012-09-21 09:04:02 +
> @@ -119,6 +119,7 @@
> var i18n_comfirm_delete_event = '$encoder.jsEscape(
> $i18n.getString( "comfirm_delete_event" ) , "'")';
> var i18n_please_select_criteria = '[' + '$encoder.jsEscape(
> $i18n.getString( "please_select_criteria" ) , "'")' + ']';
> var i18n_program_stage = '$encoder.jsEscape( $i18n.getString(
> "program_stage" ) , "'")';
> -
> +   var i18n_show_all_items = '$encoder.jsEscape( $i18n.getString(
> "show_all_items" ) , "'")';
> +
> setDateRange();
>  
>
>
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] Date validation in Tracker data entry - problematic and confusing

[Tran Chau]

Dear all,

Sorry about the later response.

The validation-rule for date fields is used for checking an inputted
date in data entry form. Before single event program occurs, the date
values are in range [ due-date ] and [ due-date +  Maximum number of days
allowed to input data] ( which is defined when creating a new program
). And currently, this rule isn't longer consistent.

Besides, the *Maximum number of days allowed to input data* is used for
creating activity plans in mobile project.

So as discussed ( with Ola, Lars, Bharath, John ), some things are changed
as follows :

A. Removed all *date validation* related to due date and *added new
features to validation rules* for data elements with type Date.


B. Created *9 rules* for date data elements as follows:


1. Before current-date

2. Before or equals to current-date

3. After current-date

4. After  or equals to current-date


The current-date is the lastest date we enter data value.


5. Before due date

6. Before or equals to due date

7. After due date

8. After  or equals to due date


9. Range  [ due date -/+ the number of days ( which users define for each
rule ) ]


Please click *Define program validation managenent* icon, and find the
validation with name "*Validation for date date elements*", click on the *
edit *icon to set validation for date-elements in each program-stage.

C. Renamed "*Maximum number of days allowed to input data"*  in Add/Update
program form to "*Date range for activities**".*

Please take a look at it :)

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Sat, Jan 14, 2012 at 2:04 AM, Mark Spohr  wrote:

> Ola,
> Sorry for the delay in responding to this subject but life was busy over
> the past few weeks.
> Thanks for taking the time to explore these issues and come up with a plan.
> We are not using this section (yet) but may in the future.
> I agree with your conclusions about removing some date checks since they
> can lead to problems in data entry.  In general, I think it is best to
> relax date restrictions except for clear, unambiguous cases since they can
> have unintended consequences for data entry.  In some cases, data entry may
> take place much later than the service date.
>
> One other issue about dates which is a problem with many medical records
> is that often the date is not known precisely.  Birth dates are notoriously
> inaccurate.  Many people do not know their birth dates.  Also, dates of LMP
> are usually approximate and dates of prior pregnancies are usually
> approximate.  In these cases, it would be good to not use a date type
> variable since that forces a level of precision which is not present in the
> original data.  I have seen people enter birth dates where only a year or
> month is known all as 1 Jan of the year or the first of the month.  This
> leads to all kinds of odd unintended consequences.
> I was wondering if would be possible to have a standard method to handle
> approximate dates of birth, LMP, etc.  where one could enter only a year or
> only a year and month if that was the best information available.  This
> "approximate date" would be more accurate and would avoid some oddities in
> data analysis.  However, it would be more complex to program and analyze.
>
> All the best for the new year and thank you all for the great work you are
> doing.
>
> Mark
>
> On Thu, Jan 5, 2012 at 10:22 AM, Ola Hodne Titlestad wrote:
>
>> On 5 January 2012 18:21, Ola Hodne Titlestad  wrote:
>>
>>> Hi,
>>>
>>> This started out as a bug report, but ended being too long and included
>>> so many different bugs so I decided to start here, and then we can
>>> copy-paste to one or multiple bug reports later, if we agree...
>>>
>>> So all this related to DHIS tracker, or what is called *Name based data
>>> entry *(under Services):
>>>
>>> If I am not wrong there seems to be at least two different ways the
>>> values of the dates are validated, in addition to the type of course:
>>>
>>> *A) Date registered vs due date for the program stage instance.*
>>> The way I understand this is that the data cannot be reported before the
>>> consultation/visit is meant to take place. Data for a ANC Month 7 visit
>>> cannot be reported 2 months after the start of the pregnancy (5 months
>>> before the due date of the Month 7 visit). Similarly for Child
>>> Immunisation, the data for the 9 months after birth control cannot be
>>> reported into DHIS 6 months after birth.
>>>
>>> *B) Date registered vs program start + the program's "Maximum number of
>>> days allowed to input data".*
>>> This rule is more tricky, and I think is meant to block data entry too
>>> long after the beneficiary is meant to have finalised the program.
>>> E.g. ANC should not take much more than 9 months, and Child Health
>>> Programs maybe not more than 5 years etc.
>>> We allow some delay in data entry, but not too much.
>>> (Personally, after trying to figure

Re: [Dhis2-devs] [Bug 1096054] [NEW] Custom form doesnt appear when registering a patient

[Tran Chau]

Dear Víctor,

As requirement from end-users, displaying default entry form is better then
custom form in *Add single event with registration form. *But we still
retain custom section entry form when to click on Update data entry icon.


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Fri, Jan 4, 2013 at 8:10 PM, Víctor García  wrote:

> Public bug reported:
>
> Using Dhis 2.10 (stable Jan 2) and checked in the online demo
> application
>
> I want to add a new patient in a single event with registration program,
> which has a custom form for data entry.
> If I go through the "single event with registration" option in individual
> records module I can add the patient and fill the program information in
> the same screen, but the custom form doesn't appear (just a list of data
> elements).
>
> If I enter again to edit the patient information about the program, the
> custom form does appear, it works fine.
>
> Actually, if I add the patient by using the "find/add person" option in
> individual records module, and then I enroll the patient in the program,
> it works fine. The problem only appears when adding patient information
> and program information at the same time.
>
> I hope I clearly explained my point. If not, I could do better.
>
> Thanks!
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1096054
>
> Title:
>   Custom form doesnt appear when registering a patient
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   Using Dhis 2.10 (stable Jan 2) and checked in the online demo
>   application
>
>   I want to add a new patient in a single event with registration program,
> which has a custom form for data entry.
>   If I go through the "single event with registration" option in
> individual records module I can add the patient and fill the program
> information in the same screen, but the custom form doesn't appear (just a
> list of data elements).
>
>   If I enter again to edit the patient information about the program,
>   the custom form does appear, it works fine.
>
>   Actually, if I add the patient by using the "find/add person" option
>   in individual records module, and then I enroll the patient in the
>   program, it works fine. The problem only appears when adding patient
>   information and program information at the same time.
>
>   I hope I clearly explained my point. If not, I could do better.
>
>   Thanks!
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1096054/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1099406] [NEW] enrolled person doesnt appear in tabular report

[Tran Chau]

Hi Victor,

We have two concepts for orgunits in tracker module.

The first one is registration orgunit. This is a place where person is
living. It's registered into system for each person when they register
their information.

The second is service orgunit. This is a facility where person visited for
his event.



When a person enrolls into a certain program, the system creates a visit
schedule ( it is program-stage-instances as you saw ) for him according to
the program-stages defined automatically.

A person lives in an orgunit, but he can come to other orgunit for his
events in schedule. So, when to enrolls into program, we don't set orgunit
for created events because the registration orgunit in this case is not the
same service orgunit.

Service orgunit is updated when to open data entry form to enter data
values for each event. And this orgunit is the one selected on left panel.

...

In tabular report, we based on the service orgunit to get corresponding
events, not registration one. So, only persons enrolled into a certain
program and have data value for selected event are displayed in result.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Mon, Jan 14, 2013 at 8:57 PM, Víctor García  wrote:

> Public bug reported:
>
> A person that is enrolled in a program by the "add/find person" module
> doesn't appear in the tabular report. But if the person is enrolled by
> the "single event with registration" module, it does.
>
> I have checked and compared the database entries for both types of
> registrations. This is the main difference that I found out: when
> enrolling a patient by the "add/find person" module the
> "organisationunitid" field in the "programstageinstance" table is left
> empty. I manually assigned a value to that empty field and, after that,
> the person appeared in the tabular report. So I think the problem is
> there.
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1099406
>
> Title:
>   enrolled person doesnt appear in tabular report
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   A person that is enrolled in a program by the "add/find person" module
>   doesn't appear in the tabular report. But if the person is enrolled by
>   the "single event with registration" module, it does.
>
>   I have checked and compared the database entries for both types of
>   registrations. This is the main difference that I found out: when
>   enrolling a patient by the "add/find person" module the
>   "organisationunitid" field in the "programstageinstance" table is left
>   empty. I manually assigned a value to that empty field and, after
>   that, the person appeared in the tabular report. So I think the
>   problem is there.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1099406/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1099406] [NEW] enrolled person doesnt appear in tabular report

[Tran Chau]

Hi Victor,

We use Single event with registration for certificate of birth/death
progam. So as normally, in this case, the registration orgunit and
service orgunit are the same.

But we can have some exception cases. It means the registration
orgunit is different from service one.

E.g If we want to find an available person in whole system from Find
and Add function / Single event data enry form one, the orgunit where
he lives is not the same select orgunit in the left panel, and open
his data entry form to enter data, then service orgunit of this event
is the selected one, not his registration one.

On 1/16/13, Víctor García  wrote:
> Thanks a lot for the explanation, it was really clear and helpful. But I
> still think something is going wrong with "single event with registration".
>
> Everything is fine in "multiple individual records" programs. I have
> noticed that it can be assigned a different service orgunit to each event
> in the program, which is great.
>
> But it is not the same with "single event with registration" programs. If a
> person has been added using the "add/find person" module, when entering
> data value for the single-event I think the service orgunit is not properly
> assigned.
>
>
> On 16 January 2013 00:54, Thu Tran <1099...@bugs.launchpad.net> wrote:
>
>> Hi Victor,
>>
>> We have two concepts for orgunits in tracker module.
>>
>> The first one is registration orgunit. This is a place where person is
>> living. It's registered into system for each person when they register
>> their information.
>>
>> The second is service orgunit. This is a facility where person visited for
>> his event.
>>
>> 
>>
>> When a person enrolls into a certain program, the system creates a visit
>> schedule ( it is program-stage-instances as you saw ) for him according to
>> the program-stages defined automatically.
>>
>> A person lives in an orgunit, but he can come to other orgunit for his
>> events in schedule. So, when to enrolls into program, we don't set orgunit
>> for created events because the registration orgunit in this case is not
>> the
>> same service orgunit.
>>
>> Service orgunit is updated when to open data entry form to enter data
>> values for each event. And this orgunit is the one selected on left panel.
>>
>> ...
>>
>> In tabular report, we based on the service orgunit to get corresponding
>> events, not registration one. So, only persons enrolled into a certain
>> program and have data value for selected event are displayed in result.
>>
>> Best regards,
>> 
>> Châu Thu Trân
>> HISP Viet Nam
>> Email: tran.hispviet...@gmail.com
>>
>>
>> On Mon, Jan 14, 2013 at 8:57 PM, Víctor García 
>> wrote:
>>
>> > Public bug reported:
>> >
>> > A person that is enrolled in a program by the "add/find person" module
>> > doesn't appear in the tabular report. But if the person is enrolled by
>> > the "single event with registration" module, it does.
>> >
>> > I have checked and compared the database entries for both types of
>> > registrations. This is the main difference that I found out: when
>> > enrolling a patient by the "add/find person" module the
>> > "organisationunitid" field in the "programstageinstance" table is left
>> > empty. I manually assigned a value to that empty field and, after that,
>> > the person appeared in the tabular report. So I think the problem is
>> > there.
>> >
>> > ** Affects: dhis2
>> >  Importance: Undecided
>> >  Status: New
>> >
>> > --
>> > You received this bug notification because you are a member of DHIS 2
>> > developers, which is subscribed to DHIS.
>> > https://bugs.launchpad.net/bugs/1099406
>> >
>> > Title:
>> >   enrolled person doesnt appear in tabular report
>> >
>> > Status in DHIS 2 - District Health Information Software:
>> >   New
>> >
>> > Bug description:
>> >   A person that is enrolled in a program by the "add/find person" module
>> >   doesn't appear in the tabular report. But if the person is enrolled by
>> >   the "single event with registration" module, it does.
>> >
>> >   I have checked and compared the database entries for both types of
>> >   registrations. This is the main difference that I found out: when
>> >   enrolling a patient by the "add/find person" module the
>> >   "organisationunitid" field in the "programstageinstance" table is left
>> >   empty. I manually assigned a value to that empty field and, after
>> >   that, the person appeared in the tabular report. So I think the
>> >   problem is there.
>> >
>> > To manage notifications about this bug go to:
>> > https://bugs.launchpad.net/dhis2/+bug/1099406/+subscriptions
>> >
>> > ___
>> > 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
>> >
>>
>> --
>> You received this bug n

Re: [Dhis2-devs] [Bug 1099406] [NEW] enrolled person doesnt appear in tabular report

[Tran Chau]

Hi,

Thank so much, Victor. It's really a bug. I fixed it on trunk and version
2.10 with revision 9125.


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Thu, Jan 17, 2013 at 1:01 AM, Víctor García  wrote:

> Hi Thu Tran,
>
> I understand what you explain. But I think I have not explained myself
> properly.
>
> Supposed that a person already exists in the system and has been added by
> the "Find/add person" function. When entering data values for a "single
> event" program, the event is not assigned to any service orgunit. That
> field is left empty even when the data values are saved.
>
>
> On 16 January 2013 14:07, Thu Tran <1099...@bugs.launchpad.net> wrote:
>
> > Hi Victor,
> >
> > We use Single event with registration for certificate of birth/death
> > progam. So as normally, in this case, the registration orgunit and
> > service orgunit are the same.
> >
> > But we can have some exception cases. It means the registration
> > orgunit is different from service one.
> >
> > E.g If we want to find an available person in whole system from Find
> > and Add function / Single event data enry form one, the orgunit where
> > he lives is not the same select orgunit in the left panel, and open
> > his data entry form to enter data, then service orgunit of this event
> > is the selected one, not his registration one.
> >
> > On 1/16/13, Víctor García  wrote:
> > > Thanks a lot for the explanation, it was really clear and helpful. But
> I
> > > still think something is going wrong with "single event with
> > registration".
> > >
> > > Everything is fine in "multiple individual records" programs. I have
> > > noticed that it can be assigned a different service orgunit to each
> event
> > > in the program, which is great.
> > >
> > > But it is not the same with "single event with registration" programs.
> > If a
> > > person has been added using the "add/find person" module, when entering
> > > data value for the single-event I think the service orgunit is not
> > properly
> > > assigned.
> > >
> > >
> > > On 16 January 2013 00:54, Thu Tran <1099...@bugs.launchpad.net> wrote:
> > >
> > >> Hi Victor,
> > >>
> > >> We have two concepts for orgunits in tracker module.
> > >>
> > >> The first one is registration orgunit. This is a place where person is
> > >> living. It's registered into system for each person when they register
> > >> their information.
> > >>
> > >> The second is service orgunit. This is a facility where person visited
> > for
> > >> his event.
> > >>
> > >> 
> > >>
> > >> When a person enrolls into a certain program, the system creates a
> visit
> > >> schedule ( it is program-stage-instances as you saw ) for him
> according
> > to
> > >> the program-stages defined automatically.
> > >>
> > >> A person lives in an orgunit, but he can come to other orgunit for his
> > >> events in schedule. So, when to enrolls into program, we don't set
> > orgunit
> > >> for created events because the registration orgunit in this case is
> not
> > >> the
> > >> same service orgunit.
> > >>
> > >> Service orgunit is updated when to open data entry form to enter data
> > >> values for each event. And this orgunit is the one selected on left
> > panel.
> > >>
> > >> ...
> > >>
> > >> In tabular report, we based on the service orgunit to get
> corresponding
> > >> events, not registration one. So, only persons enrolled into a certain
> > >> program and have data value for selected event are displayed in
> result.
> > >>
> > >> Best regards,
> > >> 
> > >> Châu Thu Trân
> > >> HISP Viet Nam
> > >> Email: tran.hispviet...@gmail.com
> > >>
> > >>
> > >> On Mon, Jan 14, 2013 at 8:57 PM, Víctor García 
> > >> wrote:
> > >>
> > >> > Public bug reported:
> > >> >
> > >> > A person that is enrolled in a program by the "add/find person"
> module
> > >> > doesn't appear in the tabular report. But if the person is enrolled
> by
> > >> > the "single event with registration" module, it does.
> > >> >
> > >> > I have checked and compared the database entries for both types of
> > >> > registrations. This is the main difference that I found out: when
> > >> > enrolling a patient by the "add/find person" module the
> > >> > "organisationunitid" field in the "programstageinstance" table is
> left
> > >> > empty. I manually assigned a value to that empty field and, after
> > that,
> > >> > the person appeared in the tabular report. So I think the problem is
> > >> > there.
> > >> >
> > >> > ** Affects: dhis2
> > >> >  Importance: Undecided
> > >> >  Status: New
> > >> >
> > >> > --
> > >> > You received this bug notification because you are a member of DHIS
> 2
> > >> > developers, which is subscribed to DHIS.
> > >> > https://bugs.launchpad.net/bugs/1099406
> > >> >
> > >> > Title:
> > >> >   enrolled person doesnt appear in tabular report
> > >> >
> > >> > S

Re: [Dhis2-devs] [Bug 1099406] [NEW] enrolled person doesnt appear in tabular report

[Tran Chau]

Hi Victor,

Thank you very much for reporting this bug. I fixed it on trunk and version
2.10 with revision 9125.


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Thu, Jan 17, 2013 at 1:01 AM, Víctor García  wrote:

> Hi Thu Tran,
>
> I understand what you explain. But I think I have not explained myself
> properly.
>
> Supposed that a person already exists in the system and has been added by
> the "Find/add person" function. When entering data values for a "single
> event" program, the event is not assigned to any service orgunit. That
> field is left empty even when the data values are saved.
>
>
> On 16 January 2013 14:07, Thu Tran <1099...@bugs.launchpad.net> wrote:
>
> > Hi Victor,
> >
> > We use Single event with registration for certificate of birth/death
> > progam. So as normally, in this case, the registration orgunit and
> > service orgunit are the same.
> >
> > But we can have some exception cases. It means the registration
> > orgunit is different from service one.
> >
> > E.g If we want to find an available person in whole system from Find
> > and Add function / Single event data enry form one, the orgunit where
> > he lives is not the same select orgunit in the left panel, and open
> > his data entry form to enter data, then service orgunit of this event
> > is the selected one, not his registration one.
> >
> > On 1/16/13, Víctor García  wrote:
> > > Thanks a lot for the explanation, it was really clear and helpful. But
> I
> > > still think something is going wrong with "single event with
> > registration".
> > >
> > > Everything is fine in "multiple individual records" programs. I have
> > > noticed that it can be assigned a different service orgunit to each
> event
> > > in the program, which is great.
> > >
> > > But it is not the same with "single event with registration" programs.
> > If a
> > > person has been added using the "add/find person" module, when entering
> > > data value for the single-event I think the service orgunit is not
> > properly
> > > assigned.
> > >
> > >
> > > On 16 January 2013 00:54, Thu Tran <1099...@bugs.launchpad.net> wrote:
> > >
> > >> Hi Victor,
> > >>
> > >> We have two concepts for orgunits in tracker module.
> > >>
> > >> The first one is registration orgunit. This is a place where person is
> > >> living. It's registered into system for each person when they register
> > >> their information.
> > >>
> > >> The second is service orgunit. This is a facility where person visited
> > for
> > >> his event.
> > >>
> > >> 
> > >>
> > >> When a person enrolls into a certain program, the system creates a
> visit
> > >> schedule ( it is program-stage-instances as you saw ) for him
> according
> > to
> > >> the program-stages defined automatically.
> > >>
> > >> A person lives in an orgunit, but he can come to other orgunit for his
> > >> events in schedule. So, when to enrolls into program, we don't set
> > orgunit
> > >> for created events because the registration orgunit in this case is
> not
> > >> the
> > >> same service orgunit.
> > >>
> > >> Service orgunit is updated when to open data entry form to enter data
> > >> values for each event. And this orgunit is the one selected on left
> > panel.
> > >>
> > >> ...
> > >>
> > >> In tabular report, we based on the service orgunit to get
> corresponding
> > >> events, not registration one. So, only persons enrolled into a certain
> > >> program and have data value for selected event are displayed in
> result.
> > >>
> > >> Best regards,
> > >> 
> > >> Châu Thu Trân
> > >> HISP Viet Nam
> > >> Email: tran.hispviet...@gmail.com
> > >>
> > >>
> > >> On Mon, Jan 14, 2013 at 8:57 PM, Víctor García 
> > >> wrote:
> > >>
> > >> > Public bug reported:
> > >> >
> > >> > A person that is enrolled in a program by the "add/find person"
> module
> > >> > doesn't appear in the tabular report. But if the person is enrolled
> by
> > >> > the "single event with registration" module, it does.
> > >> >
> > >> > I have checked and compared the database entries for both types of
> > >> > registrations. This is the main difference that I found out: when
> > >> > enrolling a patient by the "add/find person" module the
> > >> > "organisationunitid" field in the "programstageinstance" table is
> left
> > >> > empty. I manually assigned a value to that empty field and, after
> > that,
> > >> > the person appeared in the tabular report. So I think the problem is
> > >> > there.
> > >> >
> > >> > ** Affects: dhis2
> > >> >  Importance: Undecided
> > >> >  Status: New
> > >> >
> > >> > --
> > >> > You received this bug notification because you are a member of DHIS
> 2
> > >> > developers, which is subscribed to DHIS.
> > >> > https://bugs.launchpad.net/bugs/1099406
> > >> >
> > >> > Title:
> > >> >   enrolled person doesnt appear in tabular report
> > >> >
>

Re: [Dhis2-devs] [Bug 1154060] [NEW] can not delete program stages in a programme

[Tran Chau]

Dear Ingvild,

If program created has type* Single event with registration* or* Single
event without registration*, you cannot see the *Remove *icon for the
program-stage.

For single event programs, one program stage will be created as soon as the
program created automatically. And one program only have one stage. You can
edit the stage such as rename, add data elements, 

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Tue, Mar 12, 2013 at 7:45 PM, Ingvild Indrebø wrote:

> Public bug reported:
>
> No option to delete a programme stage made in a programme. Only the
> programme in it self.
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1154060
>
> Title:
>   can not delete program stages in a programme
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   No option to delete a programme stage made in a programme. Only the
>   programme in it self.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1154060/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1154479] [NEW] Complete a programme stage without provide values for required data elements

[Tran Chau]

Dear Ingvild,
*
*
I tried to test on* http://apps.dhis2.org/dev/* with *Inpatient morbidity
and mortality program *and *Birth *stage of *Child Program ( did set *Weight
(Kg)  as compulsary data element *)*. And this bug doesn't occur. You can
create a program/events with this bug on this server and we can see it ?

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Wed, Mar 13, 2013 at 3:34 PM, Ingvild Indrebø wrote:

> Public bug reported:
>
> It is possible to submit forms without "filling out" fields that are
> required. I have a single event programme which have three data elements
> which all are required to be filled out. But i can complete the
> stage/programme without providing any value for the data element(s).
> This also applies for multiple events programmes.
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1154479
>
> Title:
>   Complete a programme stage without provide values for required data
>   elements
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   It is possible to submit forms without "filling out" fields that are
>   required. I have a single event programme which have three data
>   elements which all are required to be filled out. But i can complete
>   the stage/programme without providing any value for the data
>   element(s). This also applies for multiple events programmes.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1154479/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1154513] [NEW] Repeatable event not repeatable

[Tran Chau]

Dear sir and Ingvild,

*Repeatable program stage details* section is hidden in add/update program
stage form of single event programs.


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Wed, Mar 13, 2013 at 5:52 PM, Ola Hodne Titlestad wrote:

> Hi Ingvild,
>
> Single event programs are only allowed to have one event/visit, so no need
> to schedule a second visit.
>
> The repeatable option should be disabled when editing the stage in a
> single event program.
> Currently it is not, and I can see that this can cause some confusion.
>
> Ola
> -
>
>
> --
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps 
> link
>
>
> On 13 March 2013 11:02, Ingvild Indrebø  wrote:
>
>> Public bug reported:
>>
>> Single event with registration and the event is repeatable and "Display
>> generate event box after completed" is not checked then there are no
>> options to add a new event. Should be a box similar to repeatable
>> multiple events: "Create new event". Trunk 2.11 chrome
>>
>> ** Affects: dhis2
>>  Importance: Undecided
>>  Status: New
>>
>> ** Description changed:
>>
>>   Single event with registration and the event is repeatable and "Display
>>   generate event box after completed" is not checked then there are no
>>   options to add a new event. Should be a box similar to repeatable
>> - multiple events: "Create new event".
>> + multiple events: "Create new event". Trunk 2.11 chrome
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1154513
>>
>> Title:
>>   Repeatable event not repeatable
>>
>> Status in DHIS 2 - District Health Information Software:
>>   New
>>
>> Bug description:
>>   Single event with registration and the event is repeatable and
>>   "Display generate event box after completed" is not checked then there
>>   are no options to add a new event. Should be a box similar to
>>   repeatable multiple events: "Create new event". Trunk 2.11 chrome
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1154513/+subscriptions
>>
>> ___
>> 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
>
>
___
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] [Bug 1154497] [NEW] "Data entry screen" in Person Dashboard/History is empty

[Tran Chau]

Sorry, but the bug not occurs in my laptop. You can create an example in the
* http://apps.dhis2.org/dev/ *and we can see it ? Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Wed, Mar 13, 2013 at 4:24 PM, Ingvild Indrebø wrote:

> Public bug reported:
>
> Programme and programme stage with the following settings: "Single event
> with registration" and "repeatable events" and "Display generate event box
> after completed" :
> After completed the programme stage and entered follow up date the tab
> "Data entry screen" in person dashboard is empty. If you click
> "the_programme _name" in the list of active programmes nothing comes up.
> Not the previous completed stage or the follow-up date is shown. However,
> the "report tab" next to the "data entry screen" shows the details
> previously entered. Trunk 2.11 chrome
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1154497
>
> Title:
>   "Data entry screen" in Person Dashboard/History is empty
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   Programme and programme stage with the following settings: "Single event
> with registration" and "repeatable events" and "Display generate event box
> after completed" :
>   After completed the programme stage and entered follow up date the tab
> "Data entry screen" in person dashboard is empty. If you click
> "the_programme _name" in the list of active programmes nothing comes up.
> Not the previous completed stage or the follow-up date is shown. However,
> the "report tab" next to the "data entry screen" shows the details
> previously entered. Trunk 2.11 chrome
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1154497/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1154514] [NEW] Buttons disappear when clicking "incomplete"

[Tran Chau]

Sorry, I tested and the bug doesn't occur. "*Complete", "Incomplete" and
"Update*" buttons still there. But I cannot see where *Cancel *button
in *Reschedule
and set status* tab in *Dashboard*. Please talk to me if I tested wrong
function.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Wed, Mar 13, 2013 at 5:06 PM, Ingvild Indrebø wrote:

> Public bug reported:
>
> In person dashboard in data entry screen, when clicking "incomplete" all
> the buttons: "Complete", "Incomplete" and "Cancel" disappears. Trunk
> 2.11 chrome
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1154514
>
> Title:
>   Buttons disappear when clicking "incomplete"
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   In person dashboard in data entry screen, when clicking "incomplete"
>   all the buttons: "Complete", "Incomplete" and "Cancel" disappears.
>   Trunk 2.11 chrome
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1154514/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1154517] [NEW] Clicking "History" link there are no options to close the pop-up window that appears

[Tran Chau]

Dear Ingvild,

You can re-click on History link to hide it. But it make users confused. I
added more button on the header to hide the div. Thank you for reporting
bug.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Wed, Mar 13, 2013 at 5:10 PM, Ingvild Indrebø wrote:

> Public bug reported:
>
> In Person management • Person dashboard » History, when clicking on the
> "History"-link a pop-up occurs, but there are no ways to close it. Trunk
> 2.11 Chrome
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1154517
>
> Title:
>   Clicking "History" link there are no options to close the pop-up
>   window that appears
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   In Person management • Person dashboard » History, when clicking on
>   the "History"-link a pop-up occurs, but there are no ways to close it.
>   Trunk 2.11 Chrome
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1154517/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1158178] [NEW] "List all persons" not listing all persons

[Tran Chau]

Hi, the List all person button only load persons registered the selected
orgunit. If you want to more options for searching person, please click on
Advanced search button.

On Thursday, March 21, 2013, Ingvild Indrebø  wrote:
> Public bug reported:
>
> A state or district (or other parent object) are not listing the people
that are registered under their children. Say you have the following
hierarchy:
> District1
>   PHC1: person1
>   PHC2: person2, person3
>
> Then you should be able to get a list of person1-3 when clicking "List
> all persons" in District. If district also can have persons then their
> should be an option where you can ask either for persons in District or
> persons in Districts children. Trunk 2.11 chrome
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1158178
>
> Title:
>   "List all persons" not listing all persons
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   A state or district (or other parent object) are not listing the people
that are registered under their children. Say you have the following
hierarchy:
>   District1
> PHC1: person1
> PHC2: person2, person3
>
>   Then you should be able to get a list of person1-3 when clicking "List
>   all persons" in District. If district also can have persons then their
>   should be an option where you can ask either for persons in District
>   or persons in Districts children. Trunk 2.11 chrome
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1158178/+subscriptions
>
> ___
> 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
>

-- 
Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.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] [Dhis2-users] Period frequency

[Tran Chau]

Dear Barnali,

1. Why 2013 year is not showing  in the drop down list of period in the
data entry form?

Please check your yearly dataset again. If the property Allow future
periods as NO, the current period and periods in the future will not
displayed on entry form.

3. How to write aggregate query  builder condition.

To define *Aggregation Query Builder* formula, from the *Maintenance
>* *Persons
and Programs *> *Aggregation Query Builder* link on left menu to proceed.

You can click on the Question mark icon next to the header after open this
link. I added a quick user-guide for this function

4. How to show aggregate query builder result.

There are two way to run the formulas defined:
1. Run automatically :  From the *Maintenance >* *Persons and Programs
*> Automated
Aggregation. Please click Question mark icon to see user-guide.

2. Run manually : From the *Services *> *Individual Records* > *Manual
Person Aggregation* on left menu. And also please click Question mark icon
to see user-quide.



Please contact to me if you have any questions.


Please help me, I am in big problem.


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.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] Fwd: Re: Requirement

[Tran Chau]

Dear Barnali,

@Suppose I have one data element Gender,I want to count Total Female and
show the result.,

I assume that :

1. *Patient data element* which you want to define a formula is*
Patient-Gender.
This data element links to  an optionset with defined values as Female,
Male, Unknown.*
*
*
2. The name of your *program *is *P*
*
*
3. The *stage *of program *P* which included patient data value *
Patient-Gender *is *S*
*
*
4. *Aggregate data element *which you want to put the aggregate result
after running this formula is *Gender.*
*
*
5. The name of *data set* which includes data element *Gender *is* D*.*
*

*I. *To define an aggregate query builder formula, please select menu
*Maintenance
> Persons and Programs > Aggregation Query Builder *link on left menu
.
In* Create new aggregation query builder* form,

   -

   Name - Provide name of query, this name is usually same with the name of
   aggregate data element, such as *Total Female.*
-

   Dataset - Select dataset *D*
-

   Data element - *Gender*.
-

   Operator - In your case, select the option *Number of persons*
-

   *Program *- Select program *P*
-

   *Program Stage* - Select program stage* S*.
-

   *Data element for sum/average/min/max* - Ignore this field.
- In Data elements tab: Select data element *Patient-Gender*


   - Click on button* =*


   - In Condition section, type *'Female' *after *= *sign

Click *Save *button.


II. To run this formula, please come to Services > Individual Records
> Manual Person Aggregation

1. Select data set *D*

2. Select the *date range*. The system will generate *period list* based on
date range and period type of data set *D*. E.g If data set D has period
type is monthly, you select 2013-03-11 --> 2013-04-11, you will have two
periods for running are March 2013 and April 2013.

3. Select *orgunit *where you want want to count *Total Female*.

4. Click Aggregate and Save button to calculate result and save it as a
data value of data element *Gender.* These data values are calculated by
the selected *orgunit* ( on step 3 ), *periods *created ( on step 2 ) and
data element *Gender.*
*
*


Hope this can help you. Please contact me if you have any question.


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Thu, Apr 11, 2013 at 2:44 PM, Lars Helge Øverland wrote:

> -- Forwarded message --
> From: "Barnali Bhaduri" 
> Date: Apr 10, 2013 8:35 PM
> Subject: Re: [Dhis2-devs] Requirement
> To: "Lars Helge Øverland" 
> Cc:
>
> Hi Lars,
> Ok,Thank you for the reply.
>  I am creating one program ,type of the program is 'single
> event without registration',and entering some data,now I am  want to
> counting the particular data element value and want to show this value.
> Example :
>  Suppose I have one data element Gender,I want to count Total Female and
> show the result.
> Regards,
> Barnali Banerjee
>   --
>  *From:* Lars Helge Øverland 
> *To:* Rodolfo Melia 
> *Cc:* Barnali Bhaduri ; "
> dhis2-devs@lists.launchpad.net" 
> *Sent:* Wednesday, 10 April 2013 12:01 PM
> *Subject:* Re: [Dhis2-devs] Requirement
>
>
> Hi Barnali,
>
> it would be good if could provide some more info re your problem, like the
> aggregation query, potential exceptions - makes it easier to help.
>
> regards,
>
> Lars
>
>
>
>
>
>
>
>
>
> On Tue, Apr 9, 2013 at 9:31 PM, Rodolfo Melia  wrote:
>
> Sometimes, if you are simply counting encounters or similar, you may not
> even need to set a condition. If you set a condition, then it must be a
> full logical statement, like gender='female'.
>
>
> On Tue, Apr 9, 2013 at 8:10 PM, Barnali Bhaduri wrote:
>
> Hi,
>Thank you very much.
>I have one requirement,related to aggregation query builder
> using single event without registration program data element.I try to
> follow DHIS2 user guide ,but it is not clear to me,when I try to follow
> the  step,the test condition not run successfully .From where I get the
> result.
> Thanks
> Barnali Banerjee
>--
> *From:* Rodolfo Melia 
> *To:* Barnali Bhaduri 
> *Cc:* "dhis2-devs@lists.launchpad.net" 
> *Sent:* Monday, 8 April 2013 2:00 PM
> *Subject:* Re: [Dhis2-devs] Requirement
>
> Hi - you seem to want to use the system for recording individual
> transactions, rather than data reported in a pre-stablished interval using
> a recurrent reporting frequency. Perhaps you should use Single Event
> without registration?
>
> Regarding your UI requirements, you can create a custom form that could
> incorporate jscript, so you can achieve what you describe in your email.
>
> R
>
>
> On Sun, Apr 7, 2013 at 8:24 AM, Barnali Bhaduri wrote:
>
> Dear All,
> We have the following requirement for an data element. Please let me know
> what will be the best way to implement it in DHIS2
>
> Say the aggregate data elemen

[Dhis2-devs] Requirement

[Tran Chau]

Dear Barnali,

The Automated Aggregation function is a tool for automatically scheduling
to run on regular intervals. At every midnight, this job runs and get all
datasets which have data elements defined into Aggregate Query Builder
formulas. The result is datavalues save in database.

Click Start button to enable the scheduled job to run at mid-night. It
means data value will be updated after every night. Or we can run
immediately by pressing Execute button.

Please try to open data entry form of the datasets to see the aggregate
result.



On Monday, April 15, 2013, Barnali Bhaduri  wrote:
> Dear Tran Chau,
>   Thank you very much for all the help and all
the suggestion. Now I am understood the 'Aggregation query builder '
process.
>After 'Save' the 'Aggregation query builder'
there is any automatic result  generation process.I was try with '
Automated Aggregation'
> but the result was not updating.In my project
every time aggregated result will be generated automatically.
>
>
> Barnali Banerjee
> 
> From: Rajib Sengupta 
> To: Tanusree Bag ; Barnali Bhaduri <
barnali...@yahoo.co.in>
> Sent: Monday, 15 April 2013 3:02 AM
> Subject: Fw: [Dhis2-devs] Fwd: Re: Requirement
>
>
> - Forwarded Message -
> From: Tran Chau 
> To: Lars Helge Øverland 
> Cc: DHIS 2 developers 
> Sent: Thursday, April 11, 2013 8:05 PM
> Subject: Re: [Dhis2-devs] Fwd: Re: Requirement
>
> Dear Barnali,
> @Suppose I have one data element Gender,I want to count Total Female and
show the result.,
> I assume that :
> 1. Patient data element which you want to define a formula
is Patient-Gender. This data element links to  an optionset with defined
values as Female, Male, Unknown.
> 2. The name of your program is P
> 3. The stage of program P which included patient data
value Patient-Gender is S
> 4. Aggregate data element which you want to put the aggregate result
after running this formula is Gender.
> 5. The name of data set which includes data element Gender is D.
>
> I. To define an aggregate query builder formula, please select menu
Maintenance > Persons and Programs > Aggregation Query Builder link on left
menu
> .
> In Create new aggregation query builder form,
>
> Name - Provide name of query, this name is usually same with the name of
aggregate data element, such as Total Female.
> Dataset - Select dataset D
> Data element - Gender.
> Operator - In your case, select the option Number of persons
> Program - Select program P
> Program Stage - Select program stage S.
> Data element for sum/average/min/max - Ignore this field.
> In Data elements tab: Select data element Patient-Gender
>
> Click on button =
>
> In Condition section, type 'Female' after = sign
>
> Click Save button.
>
> II. To run this formula, please come to Services > Individual Records
> Manual Person Aggregation
> 1. Select data set D
> 2. Select the date range. The system will generate period list based on
date range and period type of data set D. E.g If data set D has period type
is monthly, you select 2013-03-11 --> 2013-04-11, you will have two periods
for running are March 2013 and April 2013.
> 3. Select orgunit where you want want to count Total Female.
> 4. Click Aggregate and Save button to calculate result and save it as a
data value of data element Gender. These data values are calculated by the
selected orgunit ( on step 3 ), periods created ( on step 2 ) and data
element Gender.
> 
> Hope this can help you. Please contact me if you have any question.
>
> Best regards,
> 
> Châu Thu Trân
> HISP Viet Nam
> Email: tran.hispviet...@gmail.com
>
> On Thu, Apr 11, 2013 at 2:44 PM, Lars Helge Øverland 
wrote:
>
> -- Forwarded message --
> From: "Barnali Bhaduri" <
>
>

-- 
Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.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] [Bug 1179832] [NEW] Tabular reporting doesn't load

[Tran Chau]

Dear Rodolfo,

I fixed this bug in revision 10823 after James informed with me. Please
help me to test it again. If it's still there, please send to me the log
file. Thanks so much, Rodolfo.


On Tuesday, May 14, 2013, Rodolfo Melia  wrote:
> Hi Ola - we have scheduling active for our servers, and I'm assuming that
you do for Sierra Leone's dev and demo sites. In any case, I just tried
re-generating the resource tables, and I still having the problem - it
tries loading for ever.
> I only reported this as a bug because I could easily reproduce it on you
demo & dev environment. Hopefully is something that can be addressed with a
quick fix.
> R
>
> On Tue, May 14, 2013 at 10:01 AM, Ola Hodne Titlestad 
wrote:
>>
>> Hi Rodolfo,
>>
>> Have you generated the resource tables?
>>
>> Tabular reports depends on the _organisationunitstructure table.
>>
>> This is generated as part of the nightly scheduled jobs, but if
>> scheduling is not started then you need to generate these resource
>> tables manually in Maintenance->Data Administration->Resource Tables.
>>
>> Ola
>> ---
>>
>> --
>> Ola Hodne Titlestad (Mr)
>> HISP
>> Department of Informatics
>> University of Oslo
>>
>> Mobile: +47 48069736
>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>>
>>
>> On 14 May 2013 10:38, Rodolfo Melia  wrote:
>> > By the way, nothing shows on the catalina log, so no log output to
>> > add...
>> >
>> > --
>> > You received this bug notification because you are a member of DHIS 2
>> > developers, which is subscribed to DHIS.
>> > https://bugs.launchpad.net/bugs/1179832
>> >
>> > Title:
>> >   Tabular reporting doesn't load
>> >
>> > Status in DHIS 2 - District Health Information Software:
>> >   New
>> >
>> > Bug description:
>> >   Tabular report doesn't load any results. This applies to all type of
>> >   programs (with and without registration). After selecting your
>> >   criteria, the 'loading' message appears, but it never displays any
>> >   answers. This is occurring in 2.11 and 2.12. I've tested on my own
>> >   environments as well as on http://apps.dhis2.org/dev &
>> >   http://apps.dhis2.org/demo
>> >
>> >   On an old 2.11, for which tabular report works, everything loads
until
>> >   you add a data element of type 'Yes Only' or 'Yes/No'. I believe that
>> >   because there are records with Null values, then the whole answer
>> >   query gets cancelled, resulting in no records returned.
>> >
>> >   Let me know if you need further info.
>> >
>> > To manage notifications about this bug go to:
>> > https://bugs.launchpad.net/dhis2/+bug/1179832/+subscriptions
>> >
>> > ___
>> > 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
>
>
>
> --
> Rodolfo Meliá
> Principal
> rme...@knowming.com
> www.knowming.com
> +1 708 872 7636
> +44 777 576 4090
> Skype: rod.melia
> Twitter: @RodolfoMelia
> Note: Please note my new email address, which I will be using for PSI
related work: rme...@knowming.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] introducing jim grace

[Tran Chau]

Welcome, Jim. This is great news for us :)

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Fri, May 31, 2013 at 4:51 PM, Saptarshi Purkayastha wrote:

> Great to have you work with us...
> Welcome onboard!!
>
> ---
> Regards,
> Saptarshi PURKAYASTHA
>
> My Tech Blog:  http://sunnytalkstech.blogspot.com
> You Live by CHOICE, Not by CHANCE
>
>
> On 31 May 2013 11:26, Lars Helge Øverland  wrote:
>
>>  Hi all,
>>
>> this week we have the great pleasure of getting Jim Grace on board as a
>> new member of the DHIS 2 developer team. Jim has long and extensive
>> experience from IT including operating systems, databases, project
>> management and has done some groundbreaking research and development within
>> network protocols.
>>
>> Lately Jim has been working in for FACES  in 
>> Kisumu,
>> Kenya as a data analyst, overseeing PEPFAR reporting in DHIS, and hence
>> already has a solid understanding of the DHIS 2 software.
>>
>> We wish you a warm welcome to our team.
>>
>> best regards,
>>
>> Lars
>>
>>
>> ___
>> 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
>
>
___
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] [Bug 1187931] Re: Manual Person Aggregation Contains Duplicates

[Tran Chau]

Dear Dan,

Thank you very much for fixing this bug. I applied it. You can see it in
revision 11148.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Thu, Jun 6, 2013 at 3:55 AM, Dan Cocos <1187...@bugs.launchpad.net>wrote:

> I've attached a patch.
>
> ** Patch added: "1187931.patch"
>
> https://bugs.launchpad.net/dhis2/+bug/1187931/+attachment/3695696/+files/1187931.patch
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1187931
>
> Title:
>   Manual Person Aggregation Contains Duplicates
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   Manual person aggregation at /dhis-web-
>   caseentry/caseAggregationForm.action contains the same Data set list
>   multiple times.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1187931/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] Individual record error 2.12

[Tran Chau]

Dear Fatema,

A person can enroll into program which he/she doesn't need to fill
incident-date. And events of multi events with registration programs need
due-dates. For single event program, we don't use due-date for events.

I unactive the auto-generate event property of Birth stage of Child
Programme in DHIS Demo server. In data entry form of Bith stage of a
certain person, created a new event of this stage, it works fine. Could you
give me more details of the steps you did ?


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Mon, Jul 29, 2013 at 5:08 AM, Uddin Fatema  wrote:

> Dear All
>
> Using dhis2 2.12 and postgres 9.2.4.1.
>
> Individual Record-> child program (auto generate false)->create event .
>
> This event can create without duedate(incidentdate) but when it will try
> to view the viewform.vm file, it is looking duedate and shows error.
>
> How can i insure that without duedate the event cant able to create.
>
> Here i attached the screen short of it.
>
> Please check the 2.12 and give us update that will help us a lot.
>
> Thanks in advance
>
> --
>
> *Fatema Uddin**
> *
> *Technical Advisor HIS*
> Priority Area Health
> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
> House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
> *Office location:*
> Room # 304, Shshid Dr.Milan Bhavan,
> Management Information System,
> Directorate General of Health Services of MoHFW,
> Mohakhali, Dhaka-1212, Bangladesh
>
> Phone: +880 2 881 64 59
> Fax:   +880 2 881 38 75
> **
>
> ___
> 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

Re: [Dhis2-devs] Individual record error 2.12

[Tran Chau]

Dear Fatema,

This bug is fixed on trunk and 2.12. Please help me to test it on your side
again. Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Tue, Jul 30, 2013 at 12:30 PM, Uddin Fatema  wrote:

> Dear Tran
>
> dhis2 version 2.12. I am using multi events with registration programs and
> yes its need due-dates.
>
> In child program stage, if i create a new event without duedate, the event
> can possible to create but after creating that event it shows error.
>
> If i select duedate and creat a new event that time it is not showing any
> error.
>
> However, here i attached the screen short.
>
> Thanks
>
>
> On Mon, Jul 29, 2013 at 12:22 PM, Tran Chau wrote:
>
>> Dear Fatema,
>>
>> A person can enroll into program which he/she doesn't need to fill
>> incident-date. And events of multi events with registration programs need
>> due-dates. For single event program, we don't use due-date for events.
>>
>> I unactive the auto-generate event property of Birth stage of Child
>> Programme in DHIS Demo server. In data entry form of Bith stage of a
>> certain person, created a new event of this stage, it works fine. Could you
>> give me more details of the steps you did ?
>>
>>
>> Best regards,
>> 
>> Châu Thu Trân
>> HISP Viet Nam
>> Email: tran.hispviet...@gmail.com
>>
>>
>> On Mon, Jul 29, 2013 at 5:08 AM, Uddin Fatema wrote:
>>
>>> Dear All
>>>
>>> Using dhis2 2.12 and postgres 9.2.4.1.
>>>
>>> Individual Record-> child program (auto generate false)->create event .
>>>
>>> This event can create without duedate(incidentdate) but when it will try
>>> to view the viewform.vm file, it is looking duedate and shows error.
>>>
>>> How can i insure that without duedate the event cant able to create.
>>>
>>> Here i attached the screen short of it.
>>>
>>> Please check the 2.12 and give us update that will help us a lot.
>>>
>>> Thanks in advance
>>>
>>> --
>>>
>>> *Fatema Uddin**
>>> *
>>> *Technical Advisor HIS*
>>> Priority Area Health
>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>> House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
>>> *Office location:*
>>> Room # 304, Shshid Dr.Milan Bhavan,
>>> Management Information System,
>>> Directorate General of Health Services of MoHFW,
>>> Mohakhali, Dhaka-1212, Bangladesh
>>>
>>> Phone: +880 2 881 64 59
>>> Fax:   +880 2 881 38 75
>>> **
>>>
>>> ___
>>> 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
>>>
>>>
>>
>
>
> --
>
> *Fatema Uddin**
> *
> *Technical Advisor HIS*
> Priority Area Health
> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
> House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
> *Office location:*
> Room # 304, Shshid Dr.Milan Bhavan,
> Management Information System,
> Directorate General of Health Services of MoHFW,
> Mohakhali, Dhaka-1212, Bangladesh
>
> Phone: +880 2 881 64 59
> Fax:   +880 2 881 38 75
> **
>
___
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] SMS REMINDERS CONFIGURATION IN DHIS

[Tran Chau]

Hi Joseph,

I tested this bug on my laptop. This bug didn't occur. Could you please
send to me the tomcat log file ?

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Tue, Aug 20, 2013 at 8:47 PM, Joseph Thobias  wrote:

> Hi,
> Iam in TANZANIA-DODOMA using DHIS 2.12 (latest version). I used BulkSMS
> gateway to configure my SMS service in DHIS under mobile configuration. I
> tested to send SMS to a raw phone number it went but when I set the
> reminders and test it failed!!
>
> What might be a problem?
> Thanks in advance!
>
> --
> JOSEPH THOBIAS
> P.O.BOX 490,
> DODOMA.
> *Phone*:+255 713951382
> *email:* jthobi...@gmail.com
> *website:* www.udom.ac.tz
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1286687] [NEW] selecting attributes for tracked entity throws exception

[Tran Chau]

Hi Adebusoye,

It works fine with R.
14131.
Can you test it again with latest version ?

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Sun, Mar 2, 2014 at 10:46 AM, Adebusoye Anifalaje wrote:

> Public bug reported:
>
> To create a program for tracking villages, I defined 3 attributes: Name,
> Population and Date. Name and Date are mandatory.
>
> In Programs, selected Multiple entry with registration, set enrolment
> date as Registration Date and unchecked show incident date.
>
> When I select the 3 attributes I created and update, this comes up with
> an error. I checked the program-attributes table but this doesn't have
> any records as the programattributesid is not generated for some reason.
> Is there a step I am missing in this new world of Trackedentity?
>
> Relevant section of log  pasted below.
>
> Any help most welcome.
>
> Thanks.
>
> Busoye
>
> Version:
> 2.15-SNAPSHOT
> Build revision:
> 14116
>
> ** Affects: dhis2
>  Importance: Undecided
>  Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1286687
>
> Title:
>   selecting attributes for tracked entity throws exception
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   To create a program for tracking villages, I defined 3 attributes:
>   Name, Population and Date. Name and Date are mandatory.
>
>   In Programs, selected Multiple entry with registration, set enrolment
>   date as Registration Date and unchecked show incident date.
>
>   When I select the 3 attributes I created and update, this comes up
>   with an error. I checked the program-attributes table but this doesn't
>   have any records as the programattributesid is not generated for some
>   reason. Is there a step I am missing in this new world of
>   Trackedentity?
>
>   Relevant section of log  pasted below.
>
>   Any help most welcome.
>
>   Thanks.
>
>   Busoye
>
>   Version:
>   2.15-SNAPSHOT
>   Build revision:
>   14116
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1286687/+subscriptions
>
> ___
> 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

Re: [Dhis2-devs] [Bug 1286687] [NEW] selecting attributes for tracked entity throws exception

[Tran Chau]

framework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:158)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>
> at
> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
>
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
>
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
>
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
>
> at
> org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
> Source)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>
> at java.lang.Thread.run(Unknown Source)
>
> Caused by: java.lang.NullPointerException
>
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)
>
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)
>
> ... 28 more
>
>
>
>
>
> On 3 March 2014 12:45, Tran Chau  wrote:
>
>> Hi Adebusoye,
>>
>> It works fine with R. 
>> 14131<http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/revision/14131>.
>> Can you test it again with latest version ?
>>
>> Best regards,
>> 
>> Châu Thu Trân
>> HISP Viet Nam
>> Email: tran.hispviet...@gmail.com
>>
>>
>> On Sun, Mar 2, 2014 at 10:46 AM, Adebusoye Anifalaje wrote:
>>
>>> Public bug reported:
>>>
>>> To create a program for tracking villages, I defined 3 attributes: Name,
>>> Population and Date. Name and Date are mandatory.
>>>
>>> In Programs, selected Multiple entry with registration, set enrolment
>>> date as Registration Date and unchecked show incident date.
>>>
>>> When I select the 3 attributes I created and update, this comes up with
>>> an error. I checked the program-attributes table but this doesn't have
>>> any records as the programattributesid is not generated for some reason.
>>> Is there a step I am missing in this new world of Trackedentity?
>>>
>>> Relevant section of log  pasted below.
>>>
>>> Any help most welcome.
>>>
>>> Thanks.
>>>
>>> Busoye
>>>
>>> Version:
>>> 2.15-SNAPSHOT
>>> Build revision:
>>> 14116
>>>
>>> ** Affects: dhis2
>>>  Importance: Undecided
>>>  Status: New
>>>
>>> --
>>> You received this bug notification because you are a member of DHIS 2
>>> developers, which is subscribed to DHIS.
>>> https://bugs.launchpad.net/bugs/1286687
>>>
>>> Title:
>>>   selecting attributes for tracked entity throws exception
>>>
>>> Status in DHIS 2:
>>>   New
>>>
>>> Bug description:
>>>   To create a program for tracking villages, I defined 3 attributes:
>>>   Name, Population and Date. Name and Date are mandatory.
>>>
>>>   In Programs, selected Multiple entry with registration, set enrolment
>>>   date as Registration Date and unchecked show incident date.
>>>
>>>   When I select the 3 attributes I created and update, this comes up
>>>   with an error. I checked the program-attributes table but this doesn't
>>>   have any records as the programattributesid is not generated for some
>>>   reason. Is there a step I am missing in this new world of
>>>   Trackedentity?
>>>
>>>   Relevant section of log  pasted below.
>>>
>>>   Any help most welcome.
>>>
>>>   Thanks.
>>>
>>>   Busoye
>>>
>>>   Version:
>>>   2.15-SNAPSHOT
>>>   Build revision:
>>>   14116
>>>
>>> To manage notifications about this bug go to:
>>> https://bugs.launchpad.net/dhis2/+bug/1286687/+subscriptions
>>>
>>> ___
>>> 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
>>
>>
>
___
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] Bug: with Template reminder message

[Tran Chau]

Hi Sam,

Thank you for informing this bug.

I will deploy a database with some template messages. And see if the template 
messages will be removed after couple day.

I am seeing your log file.
I will inform you when I find out the problem.

Best regards,
Tran Chau.

> On Nov 20, 2014, at 5:28 PM, Sam Kasozi  wrote:
> 
> Hi Trau,
> 
> the problem seems to have reoccurred. I added the programstageid from the 
> database yesterday in the afternoon, however Some time at about 10:00am, i 
> realized that 3 messages for one stage and the 1 template message for another 
> stage were missing as shown below.
> 
> I am attaching the logs files modified from yesterday to sometime this 
> morning to check is there is anything that affects the message templates, a 
> csv file with the programid/ programstageids and the dump.
> 
> Yesterday after restoring the messages in the database, i navigated to the 
> system to the VHF program stages to confirm that the messages templates were 
> visible from the program stage. This morning, my activities included 
> troubleshooting the another Airport screening custom form. Later on when i 
> checked on the Message templates is when i realized that some were missing.
> 
> 
> 
> 
> 
> If you can setup the dump on a server, monitor the activity for a day or 2, i 
> believe you might find some templates missing.
> 
> P.s the only people that logged into the system other than myself include:
> 
> 1) Juliet - Doing Data entry for the Airport screening form
> 2) DHIS account  - Authenticating the delivery of incoming messages  into the 
> system
> 
> regards,
> 
> 
> Sam Kasozi
> Information Systems Consultant
> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
> +256 788 993565 | +256 757 662752  
> kaso...@gmail.com | skas...@pheoc.go.ug | Skype: sam.kasoziug
> 
>> On Mon, Nov 10, 2014 at 10:15 AM, Tran Chau (HISP Vietnam) 
>>  wrote:
>> Hi Sam,
>> 
>> It means those template messages were removed by somebody.
>> 
>> Tran Chau.
>> 
>>> On Mon, Nov 10, 2014 at 11:41 AM, Sam Kasozi  wrote:
>>> HI Tran,
>>> 
>>> Yes, the IDs 8024, 8023, 8026, 8021, 8020 are among the missing templates
>>> 
>>> Template reminder messages
>>> 
>>> PROGRAM – VHF Suspect
>>> 8016 - VHF Registration – Notification to DRRT Team (Okay)
>>> 3139 - VHF Registration - Notification to Alternative Phone Numbers (Okay)
>>> 384 - VHF Registration - Notification to Initial Alert Response Team (Okay)
>>>  
>>> STAGE 1 - VHF Spx Special Pathogens Receipt
>>> 8017 - VHF Special Pathogens Receipt - Notification to DRRT Team (Okay)
>>> 8018 - VHF Special Pathogens Receipt - Notification to Alternative Phone 
>>> Numbers (Okay)
>>> 8019 - VHF Special Pathogens Receipt - Notification to Initial Alert 
>>> Response Team (Okay)
>>>  
>>> STAGE 2 - VHF Spx Special Pathogens Results
>>> 8021 - VHF Spx Special Pathogens Results - Notification to DRRT Team 
>>> (Missing)
>>> 8023 - VHF Spx Special Pathogens Results - Notification to Alternative 
>>> Phone Numbers (Missing)
>>> VHF Spx Special Pathogens Results - Notification to Initial Alert Response 
>>> Team (Missing)
>>>  
>>> STAGE 3 - VHF Spx Arboviruses Receipt
>>> VHF Spx Arboviruses Receipt - Notification to DRRT Team (Missing)
>>> 8020 - VHF Spx Arboviruses Receipt - Notification to Alternative Phone 
>>> Numbers (Missing)
>>> VHF Spx Arboviruses Receipt - Notification to Initial Alert Response Team 
>>> (Missing)
>>>  
>>> STAGE 4 - VHF Spx Arboviruses Results
>>> 8024 - VHF Spx Arboviruses Results - Notification to DRRT Team (Missing)
>>> VHF Spx Arboviruses Results - Notification to Alternative Phone Numbers 
>>> (Missing)
>>> VHF Spx Arboviruses Results - Notification to Initial Alert Response Team 
>>> (Missing)
>>> 
>>> 
>>> Sam Kasozi
>>> Information Systems Consultant
>>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>>> +256 788 993565 | +256 757 662752  
>>> kaso...@gmail.com | skas...@pheoc.go.ug | Skype: sam.kasoziug
>>> 
>>>> On Mon, Nov 10, 2014 at 7:05 AM, Tran Chau (HISP Vietnam) 
>>>>  wrote:
>>>> Hi,
>>>> 
>>>> Could you please answer my previous email questions ?
>>>> 
>>>> Tran Chau.
>>>> 
>>>>> On Sat, Nov 8, 2014 at 6:08 PM, Emma Kassy  wrote:
>>>>> Hi Tran, 
>>>>> This same scenario h

Re: [Dhis2-devs] get blank attribute in individual records

[Tran Chau]

Hi Channara,

This will take some effort on our side to look at it since I Do not have exact 
idea on your issue.
So, I am waiting permission from DHIS to spend time on this.

Meanwhile, I need you to provide me all the things that would help me 
understand your import process.
- php code, explanation on ( data structure you sent to create a new patient, 
the format of the file used for importing, data structure in that file ). And 
any file/data/explanation you think that will help me.

Thanks

Best regards,
Tran Chau

> On Jan 15, 2015, at 9:46 AM, channara rin  wrote:
> 
> Hi tran,
> If i choose "Track Capture" for entry, it seem doesn't delete my attribute 
> value. 
> SO i clearly that the "individual record" has some thing wrong code to delete 
> attribute value.
> 
> Thanks
> 
>> On Thu, Jan 15, 2015 at 12:08 AM, channara rin  
>> wrote:
>> Hi tran,
>> i use CURL command to post JSON through the webAPI. but i build in PHP code. 
>> i follow the instruction of document: 
>> https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s35.html#d5e3716
>> 
>> Before using the previous version was DHIS2 v2.15 or 2.16 seem work fine. 
>> but when i upgraded to v2.17 seem many problem occure like create tracker 
>> entity, approve data function, user role.
>> 
>> THE STEP TO GET BLANK ATTRIBUTE ARE:
>> 1.After import through webAPI, we can view all track entity by choose: 
>> program: [View All]
>> 2.And then click on one track entity for register into the program
>> 3.After fill some data elements and then press "Complete".
>> 4.Back to view all track entity, you will get the blank attribute of your 
>> track entity was filled program
>> 
>> I hope you can understand my problem.
>> try help me, now my most track entity that filled program already, now got 
>> blank attribute, when i go to check table trackentityattributevalue, it 
>> doesn't store, so i losed my data so many records.
>> 
>> Thank you
>> 
>>> On Wed, Jan 14, 2015 at 9:52 PM, Tran Chau (HISP Vietnam) 
>>>  wrote:
>>> Hi Channara,
>>> 
>>> I wonder what kind of app you used for importing. I think this app has some 
>>> problems.
>>> Maybe you should try again with another way.
>>> 
>>> ...
>>> 
>>> Best regards,
>>> Tran Chau
>>> 
>>>> On Wed, Jan 14, 2015 at 5:16 PM, channara rin  
>>>> wrote:
>>>> SORRY, i got your mail in junk mail,
>>>> (I mean the version 17707)
>>>> but the way, if i create new, that is OK 
>>>> but if i import from webAPI, and then i fill service like in my video, it 
>>>> will got the blank all fields. 
>>>> 
>>>> 
>>>>> On Wed, Jan 7, 2015 at 10:03 PM, Tran Chau (HISP Vietnam) 
>>>>>  wrote:
>>>>> Hi Channara,
>>>>> 
>>>>> I need your help to find out the problem. Can you :
>>>>> 
>>>>> 1. Try register a new patient in Find/Add Instance > Add new
>>>>> 2. Send me log file, program definition screenshot, program stage 
>>>>> definition screen shot and any other information that might be useful to 
>>>>> analyze.
>>>>> 3. Also try same thing on demo server and show me.
>>>>> 
>>>>> .
>>>>> 
>>>>> Best regards,
>>>>> Tran Chau
>>>>> 
>>>>> 
>>>>>> On Wed, Jan 7, 2015 at 9:15 PM, Tran Chau (HISP Vietnam) 
>>>>>>  wrote:
>>>>>> Hi Channara,
>>>>>> 
>>>>>> Thanks for the video.
>>>>>> 
>>>>>> I will try to find out the problem and inform you.
>>>>>> 
>>>>>> .
>>>>>> 
>>>>>> Best regards,
>>>>>> Tran Chau.
>>>>>> 
>>>>>>> On Wed, Jan 7, 2015 at 10:09 AM, channara rin  
>>>>>>> wrote:
>>>>>>> Hi tran,
>>>>>>> i used:
>>>>>>> Version:
>>>>>>> 2.17
>>>>>>> Build revision:
>>>>>>> 17684
>>>>>>> Build date:
>>>>>>> 2015-01-06 02:03
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>>> On Tue, Jan

Re: [Dhis2-devs] Bug in Messages and Reports on the Tracked Instance Dashboard

[Tran Chau]

Hi Prosper,

This bug is fixed in revision 15142. Please take a look at it.

Thank you for reporting this bug.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Sun, May 25, 2014 at 4:51 PM, Prosper BT  wrote:

> Dear Abyot and Development Team,
>
> With 2.15 build 15072
>
> Under the tracked Instance dashboard, the messages button doesnt load for
> viewing sent messages and sending messages.
>
> Also the Reports dont load for viewing and download
>
> Regards
>
> --
> Prosper Behumbiize, MPH
> Phone:+256 414 320076
> Cell: +256 772 139037
>  +256 752 751776
>
>
> ___
> 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

Re: [Dhis2-devs] Issues importing ProgramStageSection

[Tran Chau]

Hi Morten,

I looked the bug :

"We created a Program say "Program1" and then "Program Stage" under it.
This stage has approximately 20 "ProgramStageDataElements".

On "Event Capture screen", after selecting relevant fields ("Program1" as
program and "orgUnit" as organization Unit), on clicking "Register Event",
I am able to see only few "ProgramStageDataElements" (around 10) and not
all of them."

..
It doesn't occur on demo side and my side. I tested with revision *15144*,
version 2.15. Maybe it was fixed before


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Thu, Jun 12, 2014 at 5:34 PM, Morten Olav Hansen 
wrote:

> That sounds weird. Abyor or Tran, could you have a look at it?
>
> --
> Morten
>
>
> On Thu, Jun 12, 2014 at 11:26 AM, Mansi Singhal  > wrote:
>
>> Hey Morten,
>>
>> Thanks for that.
>>
>> I just wanted a clarification on one more thing:
>>
>> We created a Program say "Program1" and then "Program Stage" under it.
>> This stage has approximately 20 "ProgramStageDataElements".
>>
>> On "Event Capture screen", after selecting relevant fields ("Program1" as
>> program and "orgUnit" as organization Unit), on clicking "Register Event",
>> I am able to see only few "ProgramStageDataElements" (around 10) and not
>> all of them.
>>
>> Is it the expected behavior or its a bug?
>>
>>
>>
>> On Thu, Jun 12, 2014 at 2:28 PM, Morten Olav Hansen 
>> wrote:
>>
>>> Hi,
>>>
>>> The tracker metadata web-api should still be considered wip (it's new
>>> for 2.16). I haven't tested with programStageSections at all.
>>>
>>> I will have a look at it.
>>>
>>> --
>>> Morten
>>>
>>>
>>> On Thu, Jun 12, 2014 at 10:49 AM, Mansi Singhal <
>>> msing...@thoughtworks.com> wrote:
>>>
 Hello All,

 We were trying to create "Program", "Program Stage" and "Program Stage
 Section" using "/metadata" api.

 We are facing issues creating "Program Stage Section".
 *Status : 409 Conflict*

 When we tried debugging the issue, we got some ClassCastExceptions for
 "List to Set" and "Set to List" in "extractProgramStageDataElements" and
 "saveProgramStageDataElements" methods in
 "DefaultIdentifiableObjectImporter" class under "dhis-services-dxf2".

 We tried fixing it, and we got some more exceptions (Constraint
 Violation Exception)

 *Input to the api "/metadata"*:

 {
 "programStageSections": [
 {
 "name": "SomeName",
 "programStageDataElements": [
 {
 "allowDateInFuture": false,
 "allowProvidedElsewhere": false,
 "compulsory": false,
 "dataElement": {
 "id": "DataElementId",
 "name": "DataElementName"
 },
 "displayInReports": false
 }
 ],
 "sortOrder": 1
 }
 ]
 }

 Can you please have a look onto this and fix it if needed.



 --
 Thanks,
 Mansi Singhal

>>>
>>>
>>
>>
>> --
>> Regards,
>> Mansi Singhal
>>
>>
>
___
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] Programme validation rule exception with decimals

[Tran Chau]

Thank you for reporting this bug. It is fixed in revision 15171.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Tue, Jun 24, 2014 at 7:13 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Seems from this (https://bugs.launchpad.net/dhis2/+bug/1251718) it may
> have been fixed in 15169 but
>
> int leftSide = Integer.parseInt( leftSideValue );
> int rightSide = Integer.parseInt( rightSideValue );
>
> would seem to indicate the problem with decimal values.
>
>
>
>
> On Tue, Jun 24, 2014 at 1:08 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Not sure if this has already been reported, but thought just in case not.
>> We have defined a programme validation rule which states that the height
>> of a client (in meters) should be less than 2.5. However ,we get this
>> exception
>>
>>
>> * ERROR 2014-06-24 07:02:24,750 Error while executing action
>> (ExceptionInterceptor.java [http-apr-8080-exec-5])
>> java.lang.NumberFormatException: For input string: "2.6" at
>> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
>>   at java.lang.Integer.parseInt(Integer.java:492)at
>> java.lang.Integer.parseInt(Integer.java:527) at
>> org.hisp.dhis.program.DefaultProgramValidationService.validate(DefaultProgramValidationService.java:176)
>>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>   at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>   at java.lang.reflect.Method.invoke(Method.java:606)
>>
>> Version:2.15Build revision:15170
>> Regards, Jason
>>
>
>
> ___
> 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

Re: [Dhis2-devs] Programme validation rule exception with decimals

[Tran Chau]

Hi Jason,

We haven't support the program validation rule with multi data elements or
something like 0+3+6+6+0+0 yet. Just supported with one data element for
one side ( one data element for left side/right side ).


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Tue, Jun 24, 2014 at 9:45 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Tran,
> Thanks for this, but I think it is only a partial fix. Now the problem is
> that we have some data elements which needed to be added together and
> compared to other ones, similar to the aggregate validation rules, but this
> is event data. The error we get now is..
>
> * ERROR 2014-06-24 09:34:47,979 Error while executing action
> (ExceptionInterceptor.java [http-apr-8080-exec-7])
> java.lang.NumberFormatException: For input string: "0+3+6+6+0+0"
>  at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492)
> at java.lang.Integer.parseInt(Integer.java:527)
> at
> org.hisp.dhis.program.DefaultProgramValidationService.validate(DefaultProgramValidationService.java:177)
> at sun.reflect.GeneratedMethodAccessor1771.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
>
> Looks like the formula is not being parsed?
>
> Best regards,
> Jason
>
>
> On Tue, Jun 24, 2014 at 3:16 PM, Tran Chau 
> wrote:
>
>> Thank you for reporting this bug. It is fixed in revision 15171.
>>
>> Best regards,
>> 
>> Châu Thu Trân
>> HISP Viet Nam
>> Email: tran.hispviet...@gmail.com
>>
>>
>> On Tue, Jun 24, 2014 at 7:13 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Seems from this (https://bugs.launchpad.net/dhis2/+bug/1251718) it may
>>> have been fixed in 15169 but
>>>
>>> int leftSide = Integer.parseInt( leftSideValue );
>>> int rightSide = Integer.parseInt( rightSideValue );
>>>
>>> would seem to indicate the problem with decimal values.
>>>
>>>
>>>
>>>
>>> On Tue, Jun 24, 2014 at 1:08 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> Not sure if this has already been reported, but thought just in case
>>>> not.
>>>> We have defined a programme validation rule which states that the
>>>> height of a client (in meters) should be less than 2.5. However ,we get
>>>> this exception
>>>>
>>>>
>>>> * ERROR 2014-06-24 07:02:24,750 Error while executing action
>>>> (ExceptionInterceptor.java [http-apr-8080-exec-5])
>>>> java.lang.NumberFormatException: For input string: "2.6" at
>>>> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
>>>>   at java.lang.Integer.parseInt(Integer.java:492)at
>>>> java.lang.Integer.parseInt(Integer.java:527) at
>>>> org.hisp.dhis.program.DefaultProgramValidationService.validate(DefaultProgramValidationService.java:176)
>>>>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>   at
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>   at
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>   at java.lang.reflect.Method.invoke(Method.java:606)
>>>>
>>>> Version:2.15Build revision:15170
>>>> Regards, Jason
>>>>
>>>
>>>
>>> ___
>>> 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

Re: [Dhis2-devs] [Dhis2-users] Problem Saving Event Coordinates- DHIS 2.15 build 15055

[Tran Chau]

Hi Adebusoye,

This bug is fixed in revision 15171, version 2.15.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Mon, May 26, 2014 at 6:04 PM,  wrote:

>  Thanks Dayo. Devs, Please find console output attached for more
> information.
>
> Thanks.
>
>
>
>
>
>
>
>
> On 2014-05-26 09:23, Deemoyes wrote:
>
> You may not be missing something though it may be a bug.
>
> But I will like to ask whether you are still using the same browser even
> after you probably have cleared your cache. You may just try Chrome
> incognito to narrow down the challenge and if it persists, you can right
> click on the page and inspect the element of that page to check what error
> you may be having.
>
> The inspect page could be useful to help you and the developers move
> forward also.
>
> I will also try to run the demo on my computer once I get a hold of space
> here.
>
> Regards,
>
> Adedayo
>
> Sent from my BlackBerry 10 smartphone.
>*From: *Adebusoye Anifalaje
> *Sent: *Sunday, 25 May 2014 23:11
> *To: *Adebusoye Anifalaje
> *Cc: *DHIS 2 Users list; DHIS 2 developers
> *Subject: *Re: [Dhis2-users] Problem Saving Event Coordinates- DHIS 2.15
> build 15055
>
>
> I just tested this on the demo site and i am getting the same problem.
>
> To replicate:
>
> 1) select Capture Coordonates on Delivery program stage for MNCH Program
> 2) Find/add instance
> 3) choose ou and program etc
> 4) go to Delivery program stage and enter coordinates
> 5) Program Stage Instance does not save the number
>
> Did I miss something?
>
> Cheers
> Busoye
>
> On Sunday, May 25, 2014, Adebusoye Anifalaje  wrote:
>
>> Sorry, I forgot to include version and build details:
>>
>> Version:2.15Build revision:15055
>>
>>  On 25 May 2014, at 12:50, Adebusoye Anifalaje  wrote:
>>
>> Hi
>>
>> I am having trouble saving event GPS coordinates for my program stages.
>> When the fields are empty the save icon works but as soon as I enter a
>> number it will not save.
>>
>> Any ideas or help would be appreciate.
>>
>> Thanks.
>>
>> Busoye
>>
>>
>
> ___
> 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

Re: [Dhis2-devs] ERROR after add attribute in program

[Tran Chau]

Hi Channara,

This bug didn't occur on my side and DHIS demo server. Could you please
create an example on demo server (https://apps.dhis2.org/demo) where we can
see the bug on ?

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Mon, Jun 23, 2014 at 8:48 PM, rin.chann...@gmail.com <
rin.chann...@gmail.com> wrote:

> Here is version I test
> Version:
> 2.15
> Build revision:
> 15163
>
>
> Tran Chau  wrote:
>
> Hi Channara,
>
> Could you please give us more information about version and revision of
> DHIS which you used for testing ?
>
> Best regards,
> 
> Châu Thu Trân
> HISP Viet Nam
> Email: tran.hispviet...@gmail.com
>
>
> On Mon, Jun 23, 2014 at 9:40 AM,  wrote:
>
>>  Sorry for late reply.
>>
>> Here is the console of tomcat v7.
>> =XXX
>> Jun 22, 2014 7:13:48 PM org.apache.catalina.core.ApplicationContext log
>> INFO: No Spring WebApplicationInitializer types detected on classpath
>> Jun 22, 2014 7:13:49 PM org.apache.catalina.core.ApplicationContext log
>> INFO: Initializing Spring root WebApplicationContext
>> Jun 22, 2014 7:16:44 PM org.apache.catalina.core.ApplicationContext log
>> INFO: Initializing Spring FrameworkServlet 'ohie'
>> Jun 22, 2014 7:16:59 PM org.apache.catalina.core.ApplicationContext log
>> INFO: Initializing Spring FrameworkServlet 'mobile'
>> Jun 22, 2014 7:17:02 PM org.apache.catalina.core.ApplicationContext log
>> INFO: Initializing Spring FrameworkServlet 'webapi'
>> Jun 22, 2014 7:31:11 PM org.apache.catalina.core.StandardWrapperValve
>> invoke
>> SEVERE: Servlet.service() for servlet [webapi] in context with path
>> [/dhis] threw exception [Request processing failed; nested exception is
>> org.hibernate.exception.SQLGrammarException: could not extract ResultSet]
>> with root cause
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
>> 'dashboard0_.externalAccess' in 'field list'
>>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
>>  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
>> Source)
>>  at java.lang.reflect.Constructor.newInstance(Unknown Source)
>>  at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>>  at com.mysql.jdbc.Util.getInstance(Util.java:386)
>>  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
>>  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
>>  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
>>  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
>>  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
>>  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
>>  at
>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
>>  at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323)
>>  at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
>>  at
>> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
>>  at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
>>  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
>>  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
>>  at org.hibernate.loader.Loader.doQuery(Loader.java:899)
>>  at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
>>  at org.hibernate.loader.Loader.doList(Loader.java:2516)
>>  at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
>>  at org.hibernate.loader.Loader.list(Loader.java:2324)
>>  at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
>>  at
>> org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
>>  at
>> org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
>>  at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1268)
>>  at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
>>  at
>> org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllOrderedName(HibernateIdentifiableObjectStore.java:342)
>>  at
>> org.hisp.dhis.common.DefaultIdentifiableObjectManager.getAllSorted(DefaultIdentifiableObjectM

Re: [Dhis2-devs] Individual Records Aggregation failure

[Tran Chau]

Hi Prosper.

I need to check something first with you.
After you do the manual aggregation query builder run, do you see the data
values on the data entry form?
If you do see them on the data entry form, that means the data have been
moved successfully.
If so, and when you run analytics at this point and did not get any data in
pivot table, that sounds like it is analytics problem, not aggregation
problem.

Also, on your automatic aggregation, do you see those data in the data
entry?


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Sat, Aug 23, 2014 at 1:54 PM, Prosper BT  wrote:

> Dear Abyot and Team,
>
> We are running two instances one with 2.15 build 15206 and 2.16 build 16332,
> on the two instance we have built aggregate queries using the aggregate
> query build and set the automatic aggregation and analytic to run.
>
> We have been testing this for now over a week and the automatic
> aggregation is not working on both versions, later alone the analytics.
>
> When we aggregate manually and save the data, aggregate are accessible
> through data entry apart from the daily ones and when we further run
> analytics manually we dont get any  data in data set reports, pivot tables,
> visualizer and GIS.
>
> Could this be a bug? Emma can share the logs,
> smgl.dhis2.org and wemr.ug
>
> Regards
>
> --
> Prosper Behumbiize, MPH
> Phone:+256 414 320076
> Cell: +256 772 139037
>  +256 752 751776
>
>
> ___
> 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

Re: [Dhis2-devs] Individual Records Aggregation failure

[Tran Chau]

Hi Prosper,

Is your problem "The data-values were generated by running manual aggregate
functionality, but no data-values were generated by using auto-scheduling"?

The first, can you see any error on tomcat log file ?

The second, after running manual aggregate function, what are the periods
of data values you got ? In those periods, do the data values belong
to only the current period ( current date/current week / current month /
current year period . ) ? ( because the aggregate data-values after
running manual aggregate function can belong to current period, but for
scheduling function, the system will not generate data-values for current
period ).

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Mon, Aug 25, 2014 at 12:13 AM, Prosper BT  wrote:

> Thanks Tran
>
> Yes when I run manual aggregation I get the data in data entry I think for
> tracker aggregation what is not working is the automatic scheduling.
>
> I guess  for the analytics is running Emma and team will help check out
> logs.
>
> Regards
>  On 24 Aug 2014 18:07, "Tran Chau"  wrote:
>
>> Hi Prosper.
>>
>> I need to check something first with you.
>> After you do the manual aggregation query builder run, do you see the
>> data values on the data entry form?
>> If you do see them on the data entry form, that means the data have been
>> moved successfully.
>> If so, and when you run analytics at this point and did not get any data
>> in pivot table, that sounds like it is analytics problem, not aggregation
>> problem.
>>
>> Also, on your automatic aggregation, do you see those data in the data
>> entry?
>>
>>
>> Best regards,
>> 
>> Châu Thu Trân
>> HISP Viet Nam
>> Email: tran.hispviet...@gmail.com
>>
>>
>> On Sat, Aug 23, 2014 at 1:54 PM, Prosper BT  wrote:
>>
>>> Dear Abyot and Team,
>>>
>>> We are running two instances one with 2.15 build 15206 and 2.16 build 16332,
>>> on the two instance we have built aggregate queries using the aggregate
>>> query build and set the automatic aggregation and analytic to run.
>>>
>>> We have been testing this for now over a week and the automatic
>>> aggregation is not working on both versions, later alone the analytics.
>>>
>>> When we aggregate manually and save the data, aggregate are accessible
>>> through data entry apart from the daily ones and when we further run
>>> analytics manually we dont get any  data in data set reports, pivot tables,
>>> visualizer and GIS.
>>>
>>> Could this be a bug? Emma can share the logs,
>>> smgl.dhis2.org and wemr.ug
>>>
>>> Regards
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Phone:+256 414 320076
>>> Cell: +256 772 139037
>>>  +256 752 751776
>>>
>>>
>>> ___
>>> 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

Re: [Dhis2-devs] dhis2.16 SQLSyntax Error

[Tran Chau]

Hi Yemi,

The 1st and 2st bugs are fixed. Please test them again in your side.

For the 3rd, please stop your web-server and run the statement below in
your database directly. And then start your server again.

*ALTER TABLE programstageinstance MODIFY status varchar(25);*



Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Sat, Aug 30, 2014 at 3:35 AM, Yemi Awe  wrote:

> Dear Developers,
> This error is on dhis2.16
>
> *1. Program Stage Completeness*
> *Running Program stage completeness returns this error*
>
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
> have an error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'by ou.name, ps.name,
> psi.completeduser, psi.completeddate, psi.status having psi' at line 1
>
>
>
> *2. Manual Aggregation (On 2.15 and 2.16)*
>
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
> have an error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'DOUBLE PRECISION ) )
> FROM trackedentitydatavalue pdv INNER JOIN programstage' at line 1
>
> *3. Error ON Individual Records (2.16)*
> ProgramStageInstace Table with column 'STATUS' has a datatype 'INT' but
> inserts 'String' like 'ACTIVE', 'COMPLETED'
> Workaround is to change the data type to of 'STATUS' column.
> With this you data type mismatch getInt(1) error is thrown when running
> Program Stage Completeness.
>
>
>  Any quick fix for the above?
>
>
> ___
> 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

Re: [Dhis2-devs] Tracker - Patient dashboard problem

[Tran Chau]

Hi Sumudu,

Could you please run these statements below in your database directly to
fix this bug ? Then restart tomcat again ?

*ALTER TABLE programstageinstance MODIFY status INTEGER;*
*UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';*
*UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';*
*UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';*


Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com

On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe 
wrote:

> Sorry, my system detail as follow
> *Version: 2.16**Build revision:16414**Database type:MySQL*
> *Java version:1.7.0_04**OS name:Windows 7*
>
>
> On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe 
> wrote:
>
>> Dear all ,
>> I have updated my instance from 2.15 to 2.16  over the old mysql
>> database. Then i list the clinic patient . But it was unable to go for
>> patient dashboard through the list and give error as exception occur (shown
>> in screen shot). Log also show some error. Log and screenshots are attached
>> here.
>>
>> Regards,
>> Sumudu
>>
>
>
___
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] Tracker - Patient dashboard problem

[Tran Chau]

Hi Sumudu,

I am sorry I sent wrong statements by mistake. The *status *column should
be change to* varchar(25)*.
Could you please run the statements below and re-start tomcat ?

*ALTER TABLE programstageinstance MODIFY status varchar(25);*
*UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';*
*UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';*
*UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';*

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com

On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe 
wrote:

> Hi Tran,
> I tried it but there is error in some query. My database "status" is a
> integer.
> I got following error?
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *mysql> ALTER TABLE programstageinstance MODIFY status INTEGER;Query OK, 0
> rows affected (0.10 sec)Records: 0  Duplicates: 0  Warnings: 0mysql> UPDATE
> programstageinstance SET status='ACTIVE' WHERE status='0';ERROR 1366
> (HY000): Incorrect integer value: 'ACTIVE' for column 'status' at
> row 2mysql> UPDATE programstageinstance SET status='COMPLETED' WHERE
> status='1';ERROR 1366 (HY000): Incorrect integer value: 'COMPLETED' for
> column 'status' atrow 1mysql> UPDATE programstageinstance SET
> status='SKIPPED' WHERE status='5';Query OK, 0 rows affected (0.00 sec)Rows
> matched: 0  Changed: 0  Warnings: 0mysql>*
>
> Sumudu
>
>
> On Tue, Sep 16, 2014 at 7:47 PM, Tran Chau 
> wrote:
>
>> Hi Sumudu,
>>
>> Could you please run these statements below in your database directly to
>> fix this bug ? Then restart tomcat again ?
>>
>> *ALTER TABLE programstageinstance MODIFY status INTEGER;*
>> *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';*
>> *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';*
>> *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';*
>>
>>
>> Best regards,
>> 
>> Châu Thu Trân
>> HISP Viet Nam
>> Email: tran.hispviet...@gmail.com
>>
>> On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe 
>> wrote:
>>
>>> Sorry, my system detail as follow
>>> *Version: 2.16**Build revision:16414**Database type:MySQL*
>>> *Java version:1.7.0_04**OS name:Windows 7*
>>>
>>>
>>> On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe >> > wrote:
>>>
>>>> Dear all ,
>>>> I have updated my instance from 2.15 to 2.16  over the old mysql
>>>> database. Then i list the clinic patient . But it was unable to go for
>>>> patient dashboard through the list and give error as exception occur (shown
>>>> in screen shot). Log also show some error. Log and screenshots are attached
>>>> here.
>>>>
>>>> Regards,
>>>> Sumudu
>>>>
>>>
>>>
>>
>
___
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] [trunk] Automated Message Reminder.Help.

[Tran Chau (HISP Vietnam)]

Hi Harsh,

I fixed this bug in R. 18727, trunk version.
Please also test it on your side.

Thank you.
Tran Chau



On Wed, Mar 25, 2015 at 4:16 PM, Harsh Atal  wrote:

> Gentle Reminder.
>
> Regards
>
> On 24 March 2015 at 13:26, Harsh Atal  wrote:
>
>> Hi
>>
>> We are trying to use the automated message reminder for tracker capture
>> and have come across an error.
>> Please let us know if we missed some steps/settings in order to configure
>> the automated reminder system.
>> These were the steps we tried:
>> 1. Added a new gateway(smscountry) in the mobile configuration, made it
>> default. Have checked through the dhis-web-sms send message interface , it
>> is sending message.
>> 2. Have set up the template messages in the program stages.
>> 3. started message scheduling, clicked on execute.
>> 4. Got Error message on the console:
>>
>> 3* INFO  2015-03-24 13:08:36,229 Aggregate process started, number of CPU
>> cores: 4, Mem Total in JVM: 821 Free in JVM: 257 Max Limit: 1737:
>> 0:00:00.000 (Clock.java [taskScheduler-1])
>> * INFO  2015-03-24 13:08:36,229 Start to send messages in outbound:
>> 0:00:00.001 (Clock.java [taskScheduler-1])
>> * INFO  2015-03-24 13:08:36,235 Sending messages in outbound completed:
>> 0:00:00.007 (Clock.java [taskScheduler-1])
>> * INFO  2015-03-24 13:08:36,235 Aggregate process started, number of CPU
>> cores: 4, Mem Total in JVM: 821 Free in JVM: 253 Max Limit: 1737:
>> 0:00:00.000 (Clock.java [taskScheduler-2])
>> * INFO  2015-03-24 13:08:36,237 Start to prepare reminder messages:
>> 0:00:00.001 (Clock.java [taskScheduler-2])
>> * ERROR 2015-03-24 13:08:36,240 Unexpected error occurred in scheduled
>> task. (TaskUtils.java [taskScheduler-2])
>> java.lang.NullPointerException
>> at
>> org.hisp.dhis.program.hibernate.HibernateProgramStageInstanceStore.getSendMesssageEvents(HibernateProgramStageInstanceStore.java:133)
>> at
>> org.hisp.dhis.program.DefaultProgramStageInstanceService.getSendMesssageEvents(DefaultProgramStageInstanceService.java:170)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:606)
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>> at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>> at
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
>> at com.sun.proxy.$Proxy76.getSendMesssageEvents(Unknown Source)
>> at
>> org.hisp.dhis.scheduling.SendScheduledMessageTask.scheduleProgramStageInstanceMessage(SendScheduledMessageTask.java:164)
>> at
>> org.hisp.dhis.scheduling.SendScheduledMessageTask.run(SendScheduledMessageTask.java:147)
>> at
>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>> at java.lang.Thread.run(Thread.java:745

Re: [Dhis2-devs] how to run aggregate query builder?

[Tran Chau (HISP Vietnam)]

Hi Channara,

You can find it in *Apps > Individual Records > Manual aggregation*.
Hope this one is the function you are looking for.


Best regards,
Tran Chau.

On Fri, Apr 10, 2015 at 10:08 AM, channara rin 
wrote:

> Hi all,
> How can i specific organisation unit to run aggregate querly builder only?
>
>
> ___
> 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

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

HI Simanta and others,

The issue is in Manual Aggregate, the "0" values are not displayed/saved.
I am working on it to display and save "0" values in Manual Aggregate
functionality.


Thank you for reporting this bug.

..
Best regards,
Tran Chau

On Mon, Apr 27, 2015 at 5:48 PM, Simanta Jyoti Handique <
shandi...@thoughtworks.com> wrote:

> Hi, thanks for the response. The data elements were already configured to
> store zero data values.
>
> This may be another symptom to the problem: If I run the aggregation
> manually and preview the data that will be saved, there are no results with
> 0 values
>
> Regards,
> Simanta
>
>
>
> On Mon, Apr 27, 2015 at 1:58 PM, Adebusoye Anifalaje 
> wrote:
>
>> Sorry,
>>
>> Just re read your question. My mistake. To overwrite values with 0, you
>> have to choose to store zero data values when creating the aggregate data
>> element.
>>
>>
>> On Monday, April 27, 2015, Adebusoye Anifalaje  wrote:
>>
>>> Hi Simanta,
>>>
>>> You should try changing the Operator to Number of tracked entities.
>>> Visits are technically for program stages and since you are not registering
>>> programs then you can't have visits.
>>>
>>> Try tracked entities and let's know whether it worked.
>>>
>>> Cheers.
>>>
>>> Busoye
>>>
>>>
>>>
>>> On Monday, April 27, 2015, Simanta Jyoti Handique <
>>> shandi...@thoughtworks.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> We have set up an aggregation query with the following details:
>>>>
>>>> Name: Number of Patients (Measles Outbreak)
>>>> Operator: Number of Visits
>>>> Data set: Geographic Origin
>>>> Data Element: Number of Patients (Measles Outbreak) - Geographic Origin
>>>> (Number)
>>>> Condition: [Measles Outbreak.Measles Outbreak stage.Date of admission]
>>>> is not null
>>>>
>>>> "Measles Outbreak" is a Single Event without Registration type program.
>>>> "Date of admission" is a Data Element of type Date
>>>>
>>>> We register an event, run the aggregation query and the "Number of
>>>> Patients (Measles Outbreak) - Geographic Origin (Number)" data element is
>>>> correctly populated with the count of the number of patients. We delete the
>>>> event and re-run the query. The data element for the number of patients
>>>> does not get updated with the value 0.
>>>>
>>>> Is this a defect with the Aggregation Query feature or is there
>>>> something wrong with the formula we're using?
>>>>
>>>> Regards,
>>>> Simanta
>>>>
>>>>
>
> ___
> 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

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

Hi Shantala,

Are you sure if the snapshots are from 2.19 version, R 19075  ?
It looks like old version.

...
Best regards,
Tran Chau
Hi Tran,

We are still seeing issues with the aggregation. We followed the below
steps -

   - Created a data element with *Store zero data values* property set to
   Yes
   - Created an aggregation query for the data element
   - Created 3 events for the program of type* single event without
   registration* - 2 events under orgunit 1 (origin 1) and 1 event under
   orgunit 2 (origin 2)
   - Ran manual aggregation for both org units
   - Deleted the event under org unit 2 (origin 2)
   - Ran manual aggregation for both org units

We observe that the data entry screen for org unit 2 (origin 2) still has
the number of events as 1.

Please find attached the screenshots for the various steps. Please let us
know if you need any other information.

Thanks,
Shantala & Shashank


On Fri, May 8, 2015 at 8:12 AM, Tran Chau (HISP Vietnam) <
tran.hispviet...@gmail.com> wrote:

> HI Simata,
>
> Yes, this bug is fixed on 19075, trunk version.
>
> I created an example on dev server ( https://apps.dhis2.org/dev/ ) for
> testing.
>
> I am sending snapshot about the test step by step on dev server here.
>
>
> *Step 1 - Create a data element and an aggregate query builder formula*
>
> *Step 1.1* - Create a data element with* '**Store zero data values' *property 
> as
> '*Yes' ( see snapshot [1.1] ). And add it into a dataset.*
>
> *Step 1.2*  - Defined an aggregate query builder formula* ( see snapshot
> [1.2] )*
>
>
> *Step 2 - Generate data values*
>
> *Step 2.1* - Create a  new person and an event in April 2015. Fill a data
> value for data element which I used in Step 1.2  ( see snapshot [*2.1*] )
>
> *Step 2.2 *- Run Aggregate Manual ( see snapshot [*2.2*]  )
>
> *Step 2.3 *- Result after clicking "Preview" button ( see snapshot [*2.3*]
> )
>
> *Step 2.4* - Data values imported in the data set  ( see snapshot [*2.4*]
>  ,  [*2.5*] )
>
>
> *Step 3 - Modified data value of event in Step 2.1 and see the result
> after aggregate*
>
> *Step 3.1* - Remove the data which was filled in Step* 2.1* ( see
> snapshot [*3.1*] )
>
> *Step 32 *- Run Aggregate Manual ( see snapshot [*3.2*]  )
>
> *Step 3.3 *- Result after clicking "*Preview*" button ( see snapshot [
> *3.3*]  )
>
> *Step 3.4* - Data values imported in the data set  ( see snapshot [*3.4*]
>  ,  [*3.5*] ).
>
> We can see the data value in April ( snapshot [*3.4*] ) is 0 now )
>
> .....
>
> If you got different result, send me the images and description like
> these.
>
> We will take a look at it.
>
> .
>
> Best regards,
> Tran Chau.
> On May 7, 2015 1:03 PM, "Simanta Jyoti Handique" <
> shandi...@thoughtworks.com> wrote:
>
>> Hello,
>>
>> We were wondering if this bug has been fixed as part of rev #19075. We
>> are on rev #19097 and are still facing this issue
>>
>> Regards,
>> Simanta
>>
>>
>> On Tue, Apr 28, 2015 at 5:51 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> HI Simanta and others,
>>>
>>> The issue is in Manual Aggregate, the "0" values are not displayed/saved.
>>> I am working on it to display and save "0" values in Manual Aggregate
>>> functionality.
>>>
>>>
>>> Thank you for reporting this bug.
>>>
>>> ..
>>> Best regards,
>>> Tran Chau
>>>
>>> On Mon, Apr 27, 2015 at 5:48 PM, Simanta Jyoti Handique <
>>> shandi...@thoughtworks.com> wrote:
>>>
>>>> Hi, thanks for the response. The data elements were already configured
>>>> to store zero data values.
>>>>
>>>> This may be another symptom to the problem: If I run the aggregation
>>>> manually and preview the data that will be saved, there are no results with
>>>> 0 values
>>>>
>>>> Regards,
>>>> Simanta
>>>>
>>>>
>>>>
>>>> On Mon, Apr 27, 2015 at 1:58 PM, Adebusoye Anifalaje 
>>>> wrote:
>>>>
>>>>> Sorry,
>>>>>
>>>>> Just re read your question. My mistake. To overwrite values with 0,
>>>>> you have to choose to store zero data values when creating the
>>>>> aggregate data element.
>>>>>
>>>>>
&g

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

HI Shantala,

Sorry, I saw your snapshot came from Dev server.
Let me go to the sever and see it now.

On Mon, May 11, 2015 at 8:02 PM, Tran Chau (HISP Vietnam) <
tran.hispviet...@gmail.com> wrote:

> Hi Shantala,
>
> Are you sure if the snapshots are from 2.19 version, R 19075  ?
> It looks like old version.
>
> ...
> Best regards,
> Tran Chau
> Hi Tran,
>
> We are still seeing issues with the aggregation. We followed the below
> steps -
>
>- Created a data element with *Store zero data values* property set to
>Yes
>- Created an aggregation query for the data element
>- Created 3 events for the program of type* single event without
>registration* - 2 events under orgunit 1 (origin 1) and 1 event under
>orgunit 2 (origin 2)
>- Ran manual aggregation for both org units
>- Deleted the event under org unit 2 (origin 2)
>- Ran manual aggregation for both org units
>
> We observe that the data entry screen for org unit 2 (origin 2) still has
> the number of events as 1.
>
> Please find attached the screenshots for the various steps. Please let us
> know if you need any other information.
>
> Thanks,
> Shantala & Shashank
>
>
> On Fri, May 8, 2015 at 8:12 AM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> HI Simata,
>>
>> Yes, this bug is fixed on 19075, trunk version.
>>
>> I created an example on dev server ( https://apps.dhis2.org/dev/ ) for
>> testing.
>>
>> I am sending snapshot about the test step by step on dev server here.
>>
>>
>> *Step 1 - Create a data element and an aggregate query builder formula*
>>
>> *Step 1.1* - Create a data element with* '**Store zero data values' 
>> *property as
>> '*Yes' ( see snapshot [1.1] ). And add it into a dataset.*
>>
>> *Step 1.2*  - Defined an aggregate query builder formula* ( see snapshot
>> [1.2] )*
>>
>>
>> *Step 2 - Generate data values*
>>
>> *Step 2.1* - Create a  new person and an event in April 2015. Fill a
>> data value for data element which I used in Step 1.2  ( see snapshot [
>> *2.1*] )
>>
>> *Step 2.2 *- Run Aggregate Manual ( see snapshot [*2.2*]  )
>>
>> *Step 2.3 *- Result after clicking "Preview" button ( see snapshot [*2.3*
>> ]  )
>>
>> *Step 2.4* - Data values imported in the data set  ( see snapshot [*2.4*]
>>  ,  [*2.5*] )
>>
>>
>> *Step 3 - Modified data value of event in Step 2.1 and see the result
>> after aggregate*
>>
>> *Step 3.1* - Remove the data which was filled in Step* 2.1* ( see
>> snapshot [*3.1*] )
>>
>> *Step 32 *- Run Aggregate Manual ( see snapshot [*3.2*]  )
>>
>> *Step 3.3 *- Result after clicking "*Preview*" button ( see snapshot [
>> *3.3*]  )
>>
>> *Step 3.4* - Data values imported in the data set  ( see snapshot [*3.4*]
>>  ,  [*3.5*] ).
>>
>> We can see the data value in April ( snapshot [*3.4*] ) is 0 now )
>>
>> .
>>
>> If you got different result, send me the images and description like
>> these.
>>
>> We will take a look at it.
>>
>> .
>>
>> Best regards,
>> Tran Chau.
>> On May 7, 2015 1:03 PM, "Simanta Jyoti Handique" <
>> shandi...@thoughtworks.com> wrote:
>>
>>> Hello,
>>>
>>> We were wondering if this bug has been fixed as part of rev #19075. We
>>> are on rev #19097 and are still facing this issue
>>>
>>> Regards,
>>> Simanta
>>>
>>>
>>> On Tue, Apr 28, 2015 at 5:51 PM, Tran Chau (HISP Vietnam) <
>>> tran.hispviet...@gmail.com> wrote:
>>>
>>>> HI Simanta and others,
>>>>
>>>> The issue is in Manual Aggregate, the "0" values are not
>>>> displayed/saved.
>>>> I am working on it to display and save "0" values in Manual Aggregate
>>>> functionality.
>>>>
>>>>
>>>> Thank you for reporting this bug.
>>>>
>>>> ..
>>>> Best regards,
>>>> Tran Chau
>>>>
>>>> On Mon, Apr 27, 2015 at 5:48 PM, Simanta Jyoti Handique <
>>>> shandi...@thoughtworks.com> wrote:
>>>>
>>>>> Hi, thanks for the response. The data elements were already configured
>>>>>

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

Hi Shantala,

The first, please make sure if the snapshots are from 2.19 version, R
19075  ?  It looks like old version.


I couldn't create an example on dev server ( apps.dhis2.org/dev ) because
the internet is still slow here. I cannot login the dev server to create an
example.

I am sending the SQL statement which I used to generate the data values
from aggregate query formulas.

Can you change the IDs in the SQL statement below according to one of your
formula and see if it is generated "NULL" value records or not  ( these
NULL values will be displayed/saved as "0" values in Manual Aggregate )


 SELECT '55' as dataelementid, '16' as categoryoptioncomboid,
'16' as attributeoptioncomboid, ou.organisationunitid as sourceid,
'1234' as periodid,'aggregated_from_tracker' as storedby,
'201505' as periodIsoDate,'Agg DE 1' as dataelementname,
'(default)' as categoryoptioncomboname, ou.name as organisationunitname,
( select  count(psi.programinstanceid) as value FROM  programinstance as pi

INNER JOIN programstageinstance psi ON
pi.programinstanceid=psi.programinstanceid
 WHERE  EXISTS ( SELECT * FROM trackedentitydatavalue _pdv
inner join programstageinstance _psi ON
_pdv.programstageinstanceid=_psi.programstageinstanceid
JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid
WHERE psi.programstageinstanceid=_pdv.programstageinstanceid
AND _pdv.dataelementid=53  AND _psi.organisationunitid in (50, 51, 52)
AND _pi.programid = 60 AND _psi.executionDate>='2015-05-01'
AND _psi.executionDate <= '2015-05-31'
AND _psi.programstageid = 63 AND _pdv.value   is not null  )
 and psi.organisationunitid=ou.organisationunitid

GROUP BY ou.organisationunitid ) from organisationunit ou where
ou.organisationunitid in ( 50, 51, 52 )


...
Best regards
Tran Chau

On Mon, May 11, 2015 at 8:02 PM, Tran Chau (HISP Vietnam) <
tran.hispviet...@gmail.com> wrote:

> Hi Shantala,
>
> Are you sure if the snapshots are from 2.19 version, R 19075  ?
> It looks like old version.
>
> ...
> Best regards,
> Tran Chau
> Hi Tran,
>
> We are still seeing issues with the aggregation. We followed the below
> steps -
>
>- Created a data element with *Store zero data values* property set to
>Yes
>- Created an aggregation query for the data element
>- Created 3 events for the program of type* single event without
>registration* - 2 events under orgunit 1 (origin 1) and 1 event under
>orgunit 2 (origin 2)
>- Ran manual aggregation for both org units
>- Deleted the event under org unit 2 (origin 2)
>- Ran manual aggregation for both org units
>
> We observe that the data entry screen for org unit 2 (origin 2) still has
> the number of events as 1.
>
> Please find attached the screenshots for the various steps. Please let us
> know if you need any other information.
>
> Thanks,
> Shantala & Shashank
>
>
> On Fri, May 8, 2015 at 8:12 AM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> HI Simata,
>>
>> Yes, this bug is fixed on 19075, trunk version.
>>
>> I created an example on dev server ( https://apps.dhis2.org/dev/ ) for
>> testing.
>>
>> I am sending snapshot about the test step by step on dev server here.
>>
>>
>> *Step 1 - Create a data element and an aggregate query builder formula*
>>
>> *Step 1.1* - Create a data element with* '**Store zero data values' 
>> *property as
>> '*Yes' ( see snapshot [1.1] ). And add it into a dataset.*
>>
>> *Step 1.2*  - Defined an aggregate query builder formula* ( see snapshot
>> [1.2] )*
>>
>>
>> *Step 2 - Generate data values*
>>
>> *Step 2.1* - Create a  new person and an event in April 2015. Fill a
>> data value for data element which I used in Step 1.2  ( see snapshot [
>> *2.1*] )
>>
>> *Step 2.2 *- Run Aggregate Manual ( see snapshot [*2.2*]  )
>>
>> *Step 2.3 *- Result after clicking "Preview" button ( see snapshot [*2.3*
>> ]  )
>>
>> *Step 2.4* - Data values imported in the data set  ( see snapshot [*2.4*]
>>  ,  [*2.5*] )
>>
>>
>> *Step 3 - Modified data value of event in Step 2.1 and see the result
>> after aggregate*
>>
>> *Step 3.1* - Remove the data which was filled in Step* 2.1* ( see
>> snapshot [*3.1*] )
>>
>> *Step 32 *- Run Aggregate Manual ( see snapshot [*3.2*]  )
>>
>> *Step 3.3 *- Result after clicking "*Preview*" button ( see snapshot [
>> *3.3*]  )
>>
>> *Step 3.4* - Data values imported in the data set 

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

HI Shantala,

I will take a look at it couple days later. I will inform you if I find out
the issue.

...
Best regards,
Tran Chau


On Mon, May 18, 2015 at 7:54 PM, Shantala Raman 
wrote:

> Hi Tran,
>
> Here <https://www.dropbox.com/s/zywgr1sys7crx4k/dhis2_db.dump?dl=0> is
> the link to the DB dump of DHIS in dropbox where we have setup the data
> needed to replicate the defect. We have associated the *Cholera CTC*
> program under the organization hierarchy, MSF->OCP->A new country->A new
> project->New Hospital->Cholera->Origin 1. The program is of type *Single
> event without registration*.
>
> Steps to reproduce the defect:
>
>1. In event capture, register an event for the *Cholera CTC* program
>under the *Origin 1* org unit.
>2. Preview the manual aggregation results for *Geographic Origin* data
>set for *Origin 1* org unit for the week of the *Incident date* and
>save all values.
>3. In data entry, you will see that the value of the *Number of
>Patients (Cholera CTC) *data element for the *Geographic Origin* data
>set for the week of the *Incident date* is 1.
>4. In event capture, remove the event for the *Cholera CTC* program
>under the *Origin 1* org unit.
>5. Preview the manual aggregation results for *Geographic Origin* data
>set for *Origin 1* org unit for the week of the *Incident date*. This
>won't return any changes to be updated while the expected behavior is that
>preview shows that the value for the *Number of Patients (Cholera CTC)*
>data element will change from 1 to 0. Save all values.
>6. In data entry, you will see the value of the *Number of Patients
>(Cholera CTC)* data element remains as 1 for the *Geographic Origin*
>data set for the week while the expected behavior is that the value of the 
> *Number
>of Patients (Cholera CTC)* data element is 0.
>
> Thanks,
> Shantala
>
>
> On Tue, May 12, 2015 at 3:05 PM, Shantala Raman 
> wrote:
>
>> Hi Tran,
>>
>> We are on 2.19 rev 19092. We are not using SQL queries for generating
>> summary data values. We are using the aggregation query builder to setup
>> the queries. Could you explain how the SQL query is linked to aggregation
>> query builder?
>>
>> Thanks,
>> Shantala
>>
>> On Mon, May 11, 2015 at 7:10 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Shantala,
>>>
>>> The first, please make sure if the snapshots are from 2.19 version, R
>>> 19075  ?  It looks like old version.
>>>
>>>
>>> I couldn't create an example on dev server ( apps.dhis2.org/dev )
>>> because the internet is still slow here. I cannot login the dev server to
>>> create an example.
>>>
>>> I am sending the SQL statement which I used to generate the data values
>>> from aggregate query formulas.
>>>
>>> Can you change the IDs in the SQL statement below according to one of
>>> your formula and see if it is generated "NULL" value records or not  (
>>> these NULL values will be displayed/saved as "0" values in Manual Aggregate
>>> )
>>>
>>>
>>>  SELECT '55' as dataelementid, '16' as categoryoptioncomboid,
>>> '16' as attributeoptioncomboid, ou.organisationunitid as sourceid,
>>> '1234' as periodid,'aggregated_from_tracker' as storedby,
>>> '201505' as periodIsoDate,'Agg DE 1' as dataelementname,
>>> '(default)' as categoryoptioncomboname, ou.name as
>>> organisationunitname,
>>> ( select  count(psi.programinstanceid) as value FROM  programinstance as
>>> pi
>>> INNER JOIN programstageinstance psi ON
>>> pi.programinstanceid=psi.programinstanceid
>>>  WHERE  EXISTS ( SELECT * FROM trackedentitydatavalue _pdv
>>> inner join programstageinstance _psi ON
>>> _pdv.programstageinstanceid=_psi.programstageinstanceid
>>> JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid
>>> WHERE psi.programstageinstanceid=_pdv.programstageinstanceid
>>> AND _pdv.dataelementid=53  AND _psi.organisationunitid in (50, 51, 52)
>>>
>>> AND _pi.programid = 60 AND _psi.executionDate>='2015-05-01'
>>> AND _psi.executionDate <= '2015-05-31'
>>> AND _psi.programstageid = 63 AND _pdv.value   is not null  )
>>>  and psi.organisationunitid=ou.organisationunitid
>>>
>>> GROUP BY ou.organisationunitid ) from org

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

Hi Shantala,

I took a look at your database and run it on 2.19 version.

It seems that you want to overwrite some data in aggregate side (dataSet
values) by removing events on event side and running the manual
aggregation, correct?

If so, DHIS 'aggregation' from event side does not work like that.
If there is no events, the aggregation process simply skips aggregation for
that.  It does not write over '0' values to aggregation side (dataSet
values).


.
Best regards,
Tran Chau




On Tue, May 19, 2015 at 9:42 AM, Tran Chau (HISP Vietnam) <
tran.hispviet...@gmail.com> wrote:

> HI Shantala,
>
> I will take a look at it couple days later. I will inform you if I find
> out the issue.
>
> ...
> Best regards,
> Tran Chau
>
>
> On Mon, May 18, 2015 at 7:54 PM, Shantala Raman 
> wrote:
>
>> Hi Tran,
>>
>> Here <https://www.dropbox.com/s/zywgr1sys7crx4k/dhis2_db.dump?dl=0> is
>> the link to the DB dump of DHIS in dropbox where we have setup the data
>> needed to replicate the defect. We have associated the *Cholera CTC*
>> program under the organization hierarchy, MSF->OCP->A new country->A new
>> project->New Hospital->Cholera->Origin 1. The program is of type *Single
>> event without registration*.
>>
>> Steps to reproduce the defect:
>>
>>1. In event capture, register an event for the *Cholera CTC* program
>>under the *Origin 1* org unit.
>>2. Preview the manual aggregation results for *Geographic Origin*
>>data set for *Origin 1* org unit for the week of the *Incident date*
>>and save all values.
>>3. In data entry, you will see that the value of the *Number of
>>Patients (Cholera CTC) *data element for the *Geographic Origin* data
>>set for the week of the *Incident date* is 1.
>>4. In event capture, remove the event for the *Cholera CTC* program
>>under the *Origin 1* org unit.
>>5. Preview the manual aggregation results for *Geographic Origin*
>>data set for *Origin 1* org unit for the week of the *Incident date*.
>>This won't return any changes to be updated while the expected behavior is
>>that preview shows that the value for the *Number of Patients
>>(Cholera CTC)* data element will change from 1 to 0. Save all values.
>>6. In data entry, you will see the value of the *Number of Patients
>>(Cholera CTC)* data element remains as 1 for the *Geographic Origin*
>>data set for the week while the expected behavior is that the value of 
>> the *Number
>>of Patients (Cholera CTC)* data element is 0.
>>
>> Thanks,
>> Shantala
>>
>>
>> On Tue, May 12, 2015 at 3:05 PM, Shantala Raman 
>> wrote:
>>
>>> Hi Tran,
>>>
>>> We are on 2.19 rev 19092. We are not using SQL queries for generating
>>> summary data values. We are using the aggregation query builder to setup
>>> the queries. Could you explain how the SQL query is linked to aggregation
>>> query builder?
>>>
>>> Thanks,
>>> Shantala
>>>
>>> On Mon, May 11, 2015 at 7:10 PM, Tran Chau (HISP Vietnam) <
>>> tran.hispviet...@gmail.com> wrote:
>>>
>>>> Hi Shantala,
>>>>
>>>> The first, please make sure if the snapshots are from 2.19 version, R
>>>> 19075  ?  It looks like old version.
>>>>
>>>>
>>>> I couldn't create an example on dev server ( apps.dhis2.org/dev )
>>>> because the internet is still slow here. I cannot login the dev server to
>>>> create an example.
>>>>
>>>> I am sending the SQL statement which I used to generate the data values
>>>> from aggregate query formulas.
>>>>
>>>> Can you change the IDs in the SQL statement below according to one of
>>>> your formula and see if it is generated "NULL" value records or not  (
>>>> these NULL values will be displayed/saved as "0" values in Manual Aggregate
>>>> )
>>>>
>>>>
>>>>  SELECT '55' as dataelementid, '16' as categoryoptioncomboid,
>>>> '16' as attributeoptioncomboid, ou.organisationunitid as sourceid,
>>>> '1234' as periodid,'aggregated_from_tracker' as storedby,
>>>> '201505' as periodIsoDate,'Agg DE 1' as dataelementname,
>>>> '(default)' as categoryoptioncomboname, ou.name as
>>>> organisationunitname,

Re: [Dhis2-devs] Can't unselect/delete relationship when editing program

[Tran Chau (HISP Vietnam)]

Hi Harsh,

To delete that relationship type, you have to first remove that
relationship type from the programs using that relationship.
Also make sure that the persons who enrolled in that program don't have any
relationship of that "relationship-type" with another persons.

There is a bug when we remove the relationship type from programs.
It is fixed in version 2.19 ( R. 19154 ) and trunk ( R. 19172 ).
So update your DHIS to this version and then try to delete relationship
type from the programs and existing person relationship.



Best regards,
Tran Chau.


On Thu, May 21, 2015 at 2:44 PM, Harsh Atal  wrote:

> Hi
>
> We added a relationship type which was added to a program. But now we need
> to delete it. But when we try to do so nothing happens except the progress
> bar keeps moving. Here is the stack trace from my local instance:
>
> *INFO  2015-05-21 12:56:04,619 'admin' delete
> org.hisp.dhis.relationship.RelationshipType, name: Eq/Mo, uid: K7kjkslt5w7
> (AuditLogUtil.java [http-bio-8090-exec-9])*
> ** WARN  2015-05-21 12:56:04,655 SQL Error: 0, SQLState: 23503
> (SqlExceptionHelper.java [http-bio-8090-exec-9])*
> ** ERROR 2015-05-21 12:56:04,656 ERROR: update or delete on table
> "relationshiptype" violates foreign key constraint
> "fk_program_relationshipid" on table "program"*
> *  Detail: Key (relationshiptypeid)=(355) is still referenced from table
> "program". (SqlExceptionHelper.java [http-bio-8090-exec-9])*
> ** ERROR 2015-05-21 12:56:04,766 Error while executing action
> (ExceptionInterceptor.java [http-bio-8090-exec-9])*
> *org.springframework.dao.DataIntegrityViolationException: could not
> execute statement; SQL [n/a]; constraint [fk_program_relationshipid];
> nested exception is org.hibernate.exception.ConstraintViolationException:
> could not execute statement*
> * at
> org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:163)*
> * at
> org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)*
> * at
> org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:592)*
> * at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)*
> *.*
> *.*
> *.*
> *.*
>
> In view of the above error we have tried to delete the relationship from
> the program (by editing it) but it seems that there is no way in which this
> can be done.Please confirm.
>
> Any help is appreciated.
>
>
> Regards
>
> ___
> 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

Re: [Dhis2-devs] Aggregation builder is not the same in event report

[Tran Chau (HISP Vietnam)]

Hi Channara,

For 1st issue, which aggregate formula did you create ? and which DHIS
version did you use ?


Best regards,
Tran Chau


On Wed, Jul 1, 2015 at 4:31 PM, channara rin  wrote:

> Hi DHIS2 family,
> I met problems are:
> 1.The number of aggregation builder running is not the same in event
> report. i tried my best to do it in event report. But i think it is problem
> from aggregation builder calculate wrong...
> 2.In Event report it seem not working with condition in data items like Is
> exact, Contains, and comparing with date type.
>
> I use DHIS2 v2.19:
> Version:2.19Build revision:19249Build date:2015-06-29 02:03
>
>
> ___
> 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

Re: [Dhis2-devs] Aggregation builder is not the same in event report

[Tran Chau (HISP Vietnam)]

Hi Channara,

Which aggregate formula did you create ?
..
Best regards,
Tran Chau


On Wed, Jul 1, 2015 at 6:16 PM, channara rin  wrote:

> Yes i created myself, but when i use V2.18. it work fine with aggregate
> formula.
>
> my version is:
> I use DHIS2 v2.19:
> Version:2.19Build revision:19249Build date:2015-06-29 02:03
>
> On Wed, Jul 1, 2015 at 6:02 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Channara,
>>
>> For 1st issue, which aggregate formula did you create ? and which DHIS
>> version did you use ?
>>
>> 
>> Best regards,
>> Tran Chau
>>
>>
>> On Wed, Jul 1, 2015 at 4:31 PM, channara rin 
>> wrote:
>>
>>> Hi DHIS2 family,
>>> I met problems are:
>>> 1.The number of aggregation builder running is not the same in event
>>> report. i tried my best to do it in event report. But i think it is problem
>>> from aggregation builder calculate wrong...
>>> 2.In Event report it seem not working with condition in data items like
>>> Is exact, Contains, and comparing with date type.
>>>
>>> I use DHIS2 v2.19:
>>> Version:2.19Build revision:19249Build date:2015-06-29 02:03
>>>
>>>
>>> ___
>>> 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

Re: [Dhis2-devs] Bug: with Template reminder message

[Tran Chau (HISP Vietnam)]

Hi Sam,

I didn't see the template messages which were created two days ago in your
csv file. Just there are template messages created on 8/8/2014.

Can you check the log file if the template messages which you created were
removed ?

Tran.

On Fri, Nov 7, 2014 at 8:29 PM, Sam Kasozi  wrote:

> I have a tracker module (Multiple event with registration) with four
> stages.
>
> About 2 days ago, I created 3 template reminder messages for the
> registration and the 4 four stages, however yesterday, when I completed a
> stage and realized that no message was sent out; I looked at the program
> stages and found that template reminder messages for the program stages
> were missing.
>
> I am attaching a copy of the template reminder message from my database
> just in-case there is anything
>
>
> regards,
>
> Sam Kasozi
> Information Systems Consultant
> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
> +256 788 993565 | +256 757 662752
> kaso...@gmail.com | skas...@pheoc.go.ug  | Skype:
> sam.kasoziug
>
> ___
> 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

Re: [Dhis2-devs] Bug: with Template reminder message

[Tran Chau (HISP Vietnam)]

Hi Sam,

The template messages with id 8024, 8023,  8026, 8021, 8020 were removed
from program/program-stage.

Are you sure if the missing templates do not belong to the id list above ?

If the missing templates have program-id/program-stage-id, please give me
more information for testing.

Tran.



On Sat, Nov 8, 2014 at 1:07 AM, Sam Kasozi  wrote:

> Hi Tran, most of the message templates are old, however the ones in
> question are the last ones at the bottom of the list for VHF which begin
> with 'Please note... They were created 3 days ago (4/11/2014); which is
> about 3 days ago.
>
> Regards,
>
> Sam Kasozi
> Information Systems Consultant
> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
> +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype:
> sam.kasoziug
> On Nov 7, 2014 7:48 PM, "Tran Chau (HISP Vietnam)" <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Sam,
>>
>> I didn't see the template messages which were created two days ago in
>> your csv file. Just there are template messages created on 8/8/2014.
>>
>> Can you check the log file if the template messages which you
>> created were removed ?
>>
>> Tran.
>>
>> On Fri, Nov 7, 2014 at 8:29 PM, Sam Kasozi  wrote:
>>
>>> I have a tracker module (Multiple event with registration) with four
>>> stages.
>>>
>>> About 2 days ago, I created 3 template reminder messages for the
>>> registration and the 4 four stages, however yesterday, when I completed a
>>> stage and realized that no message was sent out; I looked at the program
>>> stages and found that template reminder messages for the program stages
>>> were missing.
>>>
>>> I am attaching a copy of the template reminder message from my database
>>> just in-case there is anything
>>>
>>>
>>> regards,
>>>
>>> Sam Kasozi
>>> Information Systems Consultant
>>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>>> +256 788 993565 | +256 757 662752
>>> kaso...@gmail.com | skas...@pheoc.go.ug  | Skype:
>>> sam.kasoziug
>>>
>>> ___
>>> 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

Re: [Dhis2-devs] Bug: with Template reminder message

[Tran Chau (HISP Vietnam)]

Hi,

Could you please answer my previous email questions ?

Tran Chau.

On Sat, Nov 8, 2014 at 6:08 PM, Emma Kassy  wrote:

> Hi Tran,
> This same scenario has happened on the wemr.ug What i noticed was the
> program id is null. Like Sam says the deleted templates seem to remain in
> the database.
>
> One other thing I have noticed is, It seems that program stages whose
> templates disappeared seem to send out reminders from other program stages.
> On Nov 8, 2014 12:05 PM, "Sam Kasozi"  wrote:
>
>> Hi Tran, find attached a list of the template reminder messages the still
>> exist as well as those that are missing.
>>
>> Somethings to note though:
>> - Date Created and Last Updated seem to be the same. For the older
>> templates created earlier that i modified recently, i.e. created 201-8-8
>> and modified 2014 11-04 when i changed the template message format to
>> beginning with '*Please note that ...*',  the last updated date was not
>> changed.
>>
>> - Secondly, my assumption is that if i were to delete a template message
>> reminder, then it would not appear in the database, unless i am mistaken.
>>
>> For that reason, i believe there is a process that runs that either
>> removes the program/ stage IDs OR a bug that prevents those fields from
>> being saves the very first time the template is created.
>>
>> P.s I had wanted to get you a copy of the dump, however i do not have
>> access to the server at the moment.
>>
>>
>> regards,
>>
>> Sam Kasozi
>> Information Systems Consultant
>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>> +256 788 993565 | +256 757 662752
>> kaso...@gmail.com | skas...@pheoc.go.ug  | Skype:
>> sam.kasoziug
>>
>> On Sat, Nov 8, 2014 at 7:18 AM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Sam,
>>>
>>> The template messages with id 8024, 8023,  8026, 8021, 8020 were
>>> removed from program/program-stage.
>>>
>>> Are you sure if the missing templates do not belong to the id list above
>>> ?
>>>
>>> If the missing templates have program-id/program-stage-id, please give
>>> me more information for testing.
>>>
>>> Tran.
>>>
>>>
>>>
>>> On Sat, Nov 8, 2014 at 1:07 AM, Sam Kasozi  wrote:
>>>
>>>> Hi Tran, most of the message templates are old, however the ones in
>>>> question are the last ones at the bottom of the list for VHF which begin
>>>> with 'Please note... They were created 3 days ago (4/11/2014); which is
>>>> about 3 days ago.
>>>>
>>>> Regards,
>>>>
>>>> Sam Kasozi
>>>> Information Systems Consultant
>>>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>>>> +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype:
>>>> sam.kasoziug
>>>> On Nov 7, 2014 7:48 PM, "Tran Chau (HISP Vietnam)" <
>>>> tran.hispviet...@gmail.com> wrote:
>>>>
>>>>> Hi Sam,
>>>>>
>>>>> I didn't see the template messages which were created two days ago in
>>>>> your csv file. Just there are template messages created on 8/8/2014.
>>>>>
>>>>> Can you check the log file if the template messages which you
>>>>> created were removed ?
>>>>>
>>>>> Tran.
>>>>>
>>>>> On Fri, Nov 7, 2014 at 8:29 PM, Sam Kasozi  wrote:
>>>>>
>>>>>> I have a tracker module (Multiple event with registration) with four
>>>>>> stages.
>>>>>>
>>>>>> About 2 days ago, I created 3 template reminder messages for the
>>>>>> registration and the 4 four stages, however yesterday, when I completed a
>>>>>> stage and realized that no message was sent out; I looked at the program
>>>>>> stages and found that template reminder messages for the program stages
>>>>>> were missing.
>>>>>>
>>>>>> I am attaching a copy of the template reminder message from my
>>>>>> database just in-case there is anything
>>>>>>
>>>>>>
>>>>>> regards,
>>>>>>
>>>>>> Sam Kasozi
>>>>>> Information Systems Consultant
>>>>>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>>>>>> +256 788 993565 | +256 757 662752
>>>>>> kaso...@gmail.com | skas...@pheoc.go.ug  | Skype:
>>>>>> sam.kasoziug
>>>>>>
>>>>>> ___
>>>>>> 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

Re: [Dhis2-devs] Bug: with Template reminder message

[Tran Chau (HISP Vietnam)]

Hi Sam,

It means those template messages were removed by somebody.

Tran Chau.

On Mon, Nov 10, 2014 at 11:41 AM, Sam Kasozi  wrote:

> HI Tran,
>
> Yes, the IDs 8024, 8023, 8026, 8021, 8020 are among the missing templates
>
> *Template reminder messages*
>
> PROGRAM – VHF Suspect
>
> 8016 - VHF Registration – Notification to DRRT Team (Okay)
>
> 3139 - VHF Registration - Notification to Alternative Phone Numbers (Okay)
>
> 384 - VHF Registration - Notification to Initial Alert Response Team (Okay)
>
>
>
> STAGE 1 - VHF Spx Special Pathogens Receipt
>
> 8017 - VHF Special Pathogens Receipt - Notification to DRRT Team (Okay)
>
> 8018 - VHF Special Pathogens Receipt - Notification to Alternative Phone
> Numbers (Okay)
>
> 8019 - VHF Special Pathogens Receipt - Notification to Initial Alert
> Response Team (Okay)
>
>
>
> STAGE 2 - VHF Spx Special Pathogens Results
>
> 8021 - VHF Spx Special Pathogens Results - Notification to DRRT Team
> (Missing)
>
> 8023 - VHF Spx Special Pathogens Results - Notification to Alternative
> Phone Numbers (Missing)
>
> VHF Spx Special Pathogens Results - Notification to Initial Alert Response
> Team (Missing)
>
>
>
> STAGE 3 - VHF Spx Arboviruses Receipt
>
> VHF Spx Arboviruses Receipt - Notification to DRRT Team (Missing)
>
> 8020 - VHF Spx Arboviruses Receipt - Notification to Alternative Phone
> Numbers (Missing)
>
> VHF Spx Arboviruses Receipt - Notification to Initial Alert Response Team
> (Missing)
>
>
>
> STAGE 4 - VHF Spx Arboviruses Results
>
> 8024 - VHF Spx Arboviruses Results - Notification to DRRT Team (Missing)
>
> VHF Spx Arboviruses Results - Notification to Alternative Phone Numbers
> (Missing)
>
> VHF Spx Arboviruses Results - Notification to Initial Alert Response Team
> (Missing)
>
>
>
> Sam Kasozi
> Information Systems Consultant
> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
> +256 788 993565 | +256 757 662752
> kaso...@gmail.com | skas...@pheoc.go.ug  | Skype:
> sam.kasoziug
>
> On Mon, Nov 10, 2014 at 7:05 AM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi,
>>
>> Could you please answer my previous email questions ?
>>
>> Tran Chau.
>>
>> On Sat, Nov 8, 2014 at 6:08 PM, Emma Kassy  wrote:
>>
>>> Hi Tran,
>>> This same scenario has happened on the wemr.ug What i noticed was the
>>> program id is null. Like Sam says the deleted templates seem to remain in
>>> the database.
>>>
>>> One other thing I have noticed is, It seems that program stages whose
>>> templates disappeared seem to send out reminders from other program stages.
>>> On Nov 8, 2014 12:05 PM, "Sam Kasozi"  wrote:
>>>
>>>> Hi Tran, find attached a list of the template reminder messages the
>>>> still exist as well as those that are missing.
>>>>
>>>> Somethings to note though:
>>>> - Date Created and Last Updated seem to be the same. For the older
>>>> templates created earlier that i modified recently, i.e. created 201-8-8
>>>> and modified 2014 11-04 when i changed the template message format to
>>>> beginning with '*Please note that ...*',  the last updated date was
>>>> not changed.
>>>>
>>>> - Secondly, my assumption is that if i were to delete a template
>>>> message reminder, then it would not appear in the database, unless i am
>>>> mistaken.
>>>>
>>>> For that reason, i believe there is a process that runs that either
>>>> removes the program/ stage IDs OR a bug that prevents those fields from
>>>> being saves the very first time the template is created.
>>>>
>>>> P.s I had wanted to get you a copy of the dump, however i do not have
>>>> access to the server at the moment.
>>>>
>>>>
>>>> regards,
>>>>
>>>> Sam Kasozi
>>>> Information Systems Consultant
>>>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>>>> +256 788 993565 | +256 757 662752
>>>> kaso...@gmail.com | skas...@pheoc.go.ug  | Skype:
>>>> sam.kasoziug
>>>>
>>>> On Sat, Nov 8, 2014 at 7:18 AM, Tran Chau (HISP Vietnam) <
>>>> tran.hispviet...@gmail.com> wrote:
>>>>
>>>>> Hi Sam,
>>>>>
>>>>> The template messages with id 8024, 8023,  8026, 8021, 8020 were
>>>>> removed from program/program-stage.
>>>>>

Re: [Dhis2-devs] BUG in Program Edit

[Tran Chau (HISP Vietnam)]

Hi Calle,

I just guess the bug happened in *Single event without registration
program.*
For the *Single event without registration program*, I've just removed
the "*Auto-Generate
Event" *in Edit page of program-stage from version* 2.17* (R. 17685) and *trunk
*( R. 17892 ) version because this property doesn't mean in *Single event
without registration program.*

If the program you tested is Single event without registration and run on
version 2.17 or trunk, could you please test it again with new revision ?
If not, please give me which version, and revision you used for testing ?

.

Best regards,
Tran Chau.


On Tue, Jan 6, 2015 at 7:03 PM, Calle Hedberg 
wrote:

> Hi,
>
> The parameter "Auto-Generate Event" under "Edit Program Stage" do not
> change if updated: untick it, click update, then open the Edit Program
> Stage again. That field is still ticked.
>
> 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-19274
>
> 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

Re: [Dhis2-devs] get blank attribute in individual records

[Tran Chau (HISP Vietnam)]

Hi Channara,

Can you give me a video or snapshots to describe this bug ?
Also give me the version you use for testing..

.
Best regards,
Tran Chau.

On Tue, Jan 6, 2015 at 6:13 PM, channara rin  wrote:

> Hi all,
> I am so strange happen to me, After i import individual record through web
> API, and then i go to find instance in individual record, i saw all the
> individual records that i imported. But when i click on one individual
> record to fill some attribute and services of data element. and then i
> click "complete" button. *After that i back to find instance, then i got
> the blank all attributes fields.*
>
> *DHIS2 lastest version
>
> thank you
> channara
>
>
> ___
> 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

Re: [Dhis2-devs] get blank attribute in individual records

[Tran Chau (HISP Vietnam)]

Hi Channara,

Thanks for the video.

I will try to find out the problem and inform you.

.

Best regards,
Tran Chau.

On Wed, Jan 7, 2015 at 10:09 AM, channara rin 
wrote:

> Hi tran,
> i used:
> Version:2.17Build revision:17684Build date:2015-01-06 02:03
>
>
> On Tue, Jan 6, 2015 at 10:35 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Channara,
>>
>> Can you give me a video or snapshots to describe this bug ?
>> Also give me the version you use for testing..
>>
>> .
>> Best regards,
>> Tran Chau.
>>
>> On Tue, Jan 6, 2015 at 6:13 PM, channara rin 
>> wrote:
>>
>>> Hi all,
>>> I am so strange happen to me, After i import individual record through
>>> web API, and then i go to find instance in individual record, i saw all the
>>> individual records that i imported. But when i click on one individual
>>> record to fill some attribute and services of data element. and then i
>>> click "complete" button. *After that i back to find instance, then i
>>> got the blank all attributes fields.*
>>>
>>> *DHIS2 lastest version
>>>
>>> thank you
>>> channara
>>>
>>>
>>> ___
>>> 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

Re: [Dhis2-devs] get blank attribute in individual records

[Tran Chau (HISP Vietnam)]

Hi Channara,

I need your help to find out the problem. Can you :

1. Try register a new patient in *Find/Add Instance > Add new*
2. Send me log file, program definition screenshot, program stage
definition screen shot and any other information that might be useful to
analyze.
3. Also try same thing on demo server and show me.

.

Best regards,
Tran Chau


On Wed, Jan 7, 2015 at 9:15 PM, Tran Chau (HISP Vietnam) <
tran.hispviet...@gmail.com> wrote:

> Hi Channara,
>
> Thanks for the video.
>
> I will try to find out the problem and inform you.
>
> .
>
> Best regards,
> Tran Chau.
>
> On Wed, Jan 7, 2015 at 10:09 AM, channara rin 
> wrote:
>
>> Hi tran,
>> i used:
>> Version:2.17Build revision:17684Build date:2015-01-06 02:03
>>
>>
>> On Tue, Jan 6, 2015 at 10:35 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Channara,
>>>
>>> Can you give me a video or snapshots to describe this bug ?
>>> Also give me the version you use for testing..
>>>
>>> .
>>> Best regards,
>>> Tran Chau.
>>>
>>> On Tue, Jan 6, 2015 at 6:13 PM, channara rin 
>>> wrote:
>>>
>>>> Hi all,
>>>> I am so strange happen to me, After i import individual record through
>>>> web API, and then i go to find instance in individual record, i saw all the
>>>> individual records that i imported. But when i click on one individual
>>>> record to fill some attribute and services of data element. and then i
>>>> click "complete" button. *After that i back to find instance, then i
>>>> got the blank all attributes fields.*
>>>>
>>>> *DHIS2 lastest version
>>>>
>>>> thank you
>>>> channara
>>>>
>>>>
>>>> ___
>>>> 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

Re: [Dhis2-devs] get blank attribute in individual records

[Tran Chau (HISP Vietnam)]

Hi Channara,

I wonder what kind of app you used for importing. I think this app has some
problems.
Maybe you should try again with another way.

...

Best regards,
Tran Chau

On Wed, Jan 14, 2015 at 5:16 PM, channara rin 
wrote:

> SORRY, i got your mail in junk mail,
> (I mean the version 17707)
> but the way, if i create new, that is OK
> but if i import from webAPI, and then i fill service like in my video, it
> will got the blank all fields.
>
>
> On Wed, Jan 7, 2015 at 10:03 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Channara,
>>
>> I need your help to find out the problem. Can you :
>>
>> 1. Try register a new patient in *Find/Add Instance > Add new*
>> 2. Send me log file, program definition screenshot, program stage
>> definition screen shot and any other information that might be useful to
>> analyze.
>> 3. Also try same thing on demo server and show me.
>>
>> .
>>
>> Best regards,
>> Tran Chau
>>
>>
>> On Wed, Jan 7, 2015 at 9:15 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Channara,
>>>
>>> Thanks for the video.
>>>
>>> I will try to find out the problem and inform you.
>>>
>>> .
>>>
>>> Best regards,
>>> Tran Chau.
>>>
>>> On Wed, Jan 7, 2015 at 10:09 AM, channara rin 
>>> wrote:
>>>
>>>> Hi tran,
>>>> i used:
>>>> Version:2.17Build revision:17684Build date:2015-01-06 02:03
>>>>
>>>>
>>>> On Tue, Jan 6, 2015 at 10:35 PM, Tran Chau (HISP Vietnam) <
>>>> tran.hispviet...@gmail.com> wrote:
>>>>
>>>>> Hi Channara,
>>>>>
>>>>> Can you give me a video or snapshots to describe this bug ?
>>>>> Also give me the version you use for testing..
>>>>>
>>>>> .
>>>>> Best regards,
>>>>> Tran Chau.
>>>>>
>>>>> On Tue, Jan 6, 2015 at 6:13 PM, channara rin 
>>>>> wrote:
>>>>>
>>>>>> Hi all,
>>>>>> I am so strange happen to me, After i import individual record
>>>>>> through web API, and then i go to find instance in individual record, i 
>>>>>> saw
>>>>>> all the individual records that i imported. But when i click on one
>>>>>> individual record to fill some attribute and services of data element. 
>>>>>> and
>>>>>> then i click "complete" button. *After that i back to find instance,
>>>>>> then i got the blank all attributes fields.*
>>>>>>
>>>>>> *DHIS2 lastest version
>>>>>>
>>>>>> thank you
>>>>>> channara
>>>>>>
>>>>>>
>>>>>> ___
>>>>>> 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

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

[Tran Chau (HISP Vietnam)]

Hi Channara,

No, we cannot define aggregation query builder for the same data element
with different organisation units.
Organisation unit is not required in one aggregate query builder formula.

When these formulas is run automatically, the system will get tracker data
from orgunits and generate aggregate data for each orgunit.

Besides, we can run the aggregation query builder formulas by manually. For
this functionality, we can choose orgunits where we need to generate
aggregate data. Go to *Individual Records > Manual aggregation* to see this
function.

...
Best regards,
Tran Chau.




On Mon, Feb 23, 2015 at 5:00 PM, channara rin 
wrote:

> seem another data element is OK, but why only that data element meet
> error? s.th wrong with it?
>
> any one tell me?
>
> Thank you
> Channara
>
> On Mon, Feb 23, 2015 at 4:53 PM, channara rin 
> wrote:
>
>> I did like that, but wonder has error. Let me try another data element
>> first, i will inform you soon...
>>
>> Thank you
>> Channara
>>
>> On Mon, Feb 23, 2015 at 4:48 PM, Emma Kassy  wrote:
>>
>>> Hi Channara,
>>> The data element should be assigned to a different data set.
>>> In other wards, you can have the same data element but in different data
>>> sets. That way you will not have an error.
>>>
>>> On Mon, Feb 23, 2015 at 8:13 AM, channara rin 
>>> wrote:
>>>
>>>> Hi all DHIS2,
>>>> I wonder can i make aggregation query builder for the same data element
>>>> but in different organisation unit?
>>>>
>>>> When i did, i go the error?
>>>> [image: Inline image 1]
>>>>
>>>> ___
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>> Thank you and Kind Regards
>>> *Immarcqulate. A (Emma Kassy) *
>>>
>>> *"You miss 100% of the shots you don't take."*
>>>
>>
>>
>
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

[Tran Chau (HISP Vietnam)]

Hi Channara,

Tracker Aggregation formula is for generating Data Elemment data.
It is not 'Data Set' specific.  It generates the Data Element value for all
Data Sets that the Data Element belong to.
On interface, there is 'Data Set' selector before selecting the Data
Element.
This does not limit the Data Set that we are going to generate the Data
Element value.
It is only used for searching/selecting the Data Element, regardless of the
Data Set we are going to generate the value.
We know that it is confusing, because there is Data Set selector before
Data Element selection.  I will discuss with DHIS for doing something about
this in future.

For your case, I would suggest creating two (or more) different data
elements if you want different formula for same data element.  Would this
solve your issue?
If not, could you explain to me the detail of different formula you are
trying to apply to different org unit?
So that I understand what you are trying to do and assist you on it.

....
Best regards,
Tran Chau

On Tue, Feb 24, 2015 at 12:04 PM, channara rin 
wrote:

> Hi Tran,
> if like this seem sound, but when i create New aggregate query builder, it
> require select "Data set" and then choose data element, And my DHIS2 system
> is each Dataset has different organisation unit. because each dataset has
> some is the same data element and some is different data element.
>
> On Mon, Feb 23, 2015 at 6:03 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Channara,
>>
>> No, we cannot define aggregation query builder for the same data element
>> with different organisation units.
>> Organisation unit is not required in one aggregate query builder formula.
>>
>> When these formulas is run automatically, the system will get tracker
>> data from orgunits and generate aggregate data for each orgunit.
>>
>> Besides, we can run the aggregation query builder formulas by manually.
>> For this functionality, we can choose orgunits where we need to generate
>> aggregate data. Go to *Individual Records > Manual aggregation* to see
>> this function.
>>
>> ...
>> Best regards,
>> Tran Chau.
>>
>>
>>
>>
>> On Mon, Feb 23, 2015 at 5:00 PM, channara rin 
>> wrote:
>>
>>> seem another data element is OK, but why only that data element meet
>>> error? s.th wrong with it?
>>>
>>> any one tell me?
>>>
>>> Thank you
>>> Channara
>>>
>>> On Mon, Feb 23, 2015 at 4:53 PM, channara rin 
>>> wrote:
>>>
>>>> I did like that, but wonder has error. Let me try another data element
>>>> first, i will inform you soon...
>>>>
>>>> Thank you
>>>> Channara
>>>>
>>>> On Mon, Feb 23, 2015 at 4:48 PM, Emma Kassy  wrote:
>>>>
>>>>> Hi Channara,
>>>>> The data element should be assigned to a different data set.
>>>>> In other wards, you can have the same data element but in different
>>>>> data sets. That way you will not have an error.
>>>>>
>>>>> On Mon, Feb 23, 2015 at 8:13 AM, channara rin 
>>>>> wrote:
>>>>>
>>>>>> Hi all DHIS2,
>>>>>> I wonder can i make aggregation query builder for the same data
>>>>>> element but in different organisation unit?
>>>>>>
>>>>>> When i did, i go the error?
>>>>>> [image: Inline image 1]
>>>>>>
>>>>>> ___
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thank you and Kind Regards
>>>>> *Immarcqulate. A (Emma Kassy) *
>>>>>
>>>>> *"You miss 100% of the shots you don't take."*
>>>>>
>>>>
>>>>
>>>
>>> ___
>>> 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

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

[Tran Chau (HISP Vietnam)]

Hi Channara,

Does creating two data elements solve your issue ?

...
Best regards,
Tran Chau

On Tue, Feb 24, 2015 at 3:28 PM, channara rin 
wrote:

> Thank you Tran,
> My situation of using tracker is:
> *Example:* in my DHIS2 system has two organisations is (A, and B) and
> Data Element is HTC(HIV Testing and Counseling) and two organisations work
> with Target Group is organisation: "A" work with target group:
> EW(Entertainment Worker) and organisation: "B" work with target group: MSM
> (Man who sex with man).
>
> So two organisations will track record with different target group but the
> same Data Element is HTC and different organisations in one quarterly.
>
> This formula is the same in two organisations. but the type of tracker
> records is differents. so the value get from aggregate query builder can be
> different.
>
> Thank you
> CHANNARA
>
>
>
> On Tue, Feb 24, 2015 at 1:54 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Channara,
>>
>> Tracker Aggregation formula is for generating Data Elemment data.
>> It is not 'Data Set' specific.  It generates the Data Element value for
>> all Data Sets that the Data Element belong to.
>> On interface, there is 'Data Set' selector before selecting the Data
>> Element.
>> This does not limit the Data Set that we are going to generate the Data
>> Element value.
>> It is only used for searching/selecting the Data Element, regardless of
>> the Data Set we are going to generate the value.
>> We know that it is confusing, because there is Data Set selector before
>> Data Element selection.  I will discuss with DHIS for doing something about
>> this in future.
>>
>> For your case, I would suggest creating two (or more) different data
>> elements if you want different formula for same data element.  Would this
>> solve your issue?
>> If not, could you explain to me the detail of different formula you are
>> trying to apply to different org unit?
>> So that I understand what you are trying to do and assist you on it.
>>
>> 
>> Best regards,
>> Tran Chau
>>
>> On Tue, Feb 24, 2015 at 12:04 PM, channara rin 
>> wrote:
>>
>>> Hi Tran,
>>> if like this seem sound, but when i create New aggregate query builder,
>>> it require select "Data set" and then choose data element, And my DHIS2
>>> system is each Dataset has different organisation unit. because each
>>> dataset has some is the same data element and some is different data
>>> element.
>>>
>>> On Mon, Feb 23, 2015 at 6:03 PM, Tran Chau (HISP Vietnam) <
>>> tran.hispviet...@gmail.com> wrote:
>>>
>>>> Hi Channara,
>>>>
>>>> No, we cannot define aggregation query builder for the same data
>>>> element with different organisation units.
>>>> Organisation unit is not required in one aggregate query builder
>>>> formula.
>>>>
>>>> When these formulas is run automatically, the system will get tracker
>>>> data from orgunits and generate aggregate data for each orgunit.
>>>>
>>>> Besides, we can run the aggregation query builder formulas by
>>>> manually. For this functionality, we can choose orgunits where we need to
>>>> generate aggregate data. Go to *Individual Records > Manual
>>>> aggregation* to see this function.
>>>>
>>>> ...
>>>> Best regards,
>>>> Tran Chau.
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Feb 23, 2015 at 5:00 PM, channara rin 
>>>> wrote:
>>>>
>>>>> seem another data element is OK, but why only that data element meet
>>>>> error? s.th wrong with it?
>>>>>
>>>>> any one tell me?
>>>>>
>>>>> Thank you
>>>>> Channara
>>>>>
>>>>> On Mon, Feb 23, 2015 at 4:53 PM, channara rin 
>>>>> wrote:
>>>>>
>>>>>> I did like that, but wonder has error. Let me try another data
>>>>>> element first, i will inform you soon...
>>>>>>
>>>>>> Thank you
>>>>>> Channara
>>>>>>
>>>>>> On Mon, Feb 23, 2015 at 4:48 PM, Emma Kassy 
>>>>>> wrote:
>>>>>>
>>>

Re: [Dhis2-devs] Executing [Schedule automated aggregation] only working for [Last month]

[Tran Chau (HISP Vietnam)]

Hi Greg,

Can you give me more information about snapshots, your formulas, your event
cases, what the *Task strategy* is selected in *Schedule automated
aggregation*  ?

..
Best regards,
Tran Chau



On Thu, Feb 26, 2015 at 5:26 AM, Greg Rowles  wrote:

> Hi Devs
>
> We've noticed our Aggregation-Queries are only loading values for the last
> month regardless of the selected time frame.
>
> Is there a known bug or known cause for this problem? Perhaps its a
> data-quality issue (we're still refining our data quality kinks, i.e. there
> may be programstageinstance.executiondate dates that violate expected
> values, e.g. date value "0013-02-13" and "0022-02-06" is present). Is
> this the likely cause? We cannot aggregate data before 24 Jan 2015...
>
> Greg
>
> --
> *Health Information Systems Program - South Africa*
> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - -
> - *
> Mobile  :073 246 2992
> Landline:   021 554 3130
> Fax:  086 733 8432
> Skype:  gregory_rowles
>
> ___
> 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

Re: [Dhis2-devs] Limit of characters in the Aggregate Query builder

[Tran Chau (HISP Vietnam)]

Hi Prosper,

The lengh of this field is 1000 now ( DHIS version 2.16 )

On Sun, Sep 28, 2014 at 5:14 PM, Prosper BT  wrote:

> Hi Tran,
>
> We have a limit of number of characters to put in the query its 160 and
> its unrealistic for most for the queries we build in the field take un
> example of the one below that cant be saved.
>
> We need to increase it otherwise we cant save queries with long options
> since options are not coded.
>
> Take a look at this one, it cant be saved and I have many even longer than
> this
>
> ( [DE:296580.*.296547]='1.ProFam Routine' OR
> [DE:296580.*.296547]='2.Profam special event' OR
> [DE:296580.*.296547]='6.Partnerother IP led' ) AND ([DE:296580.*.296557]='M
> - Multiload' OR [DE:296580.*.296557]='A - Copper-T380A')
>
> --
> Prosper Behumbiize, MPH
> Phone:+256 414 320076
> Cell: +256 772 139037
>  +256 752 751776
>
>
___
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] Bug when using ==NULL (is null ) in aggregate query builder

[Tran Chau (HISP Vietnam)]

Hi all,

This one *[DE:1.2.3] != null *doesn't work .
Aggregate functionality works with formula  *[DE:1.2.3] is not null*.

Best regard,

Tran

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia  wrote:

> Adding Juan and Jose, who has dealt with similar situations.
>
>>
>>
>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT  wrote:
>>
>>> Using 2.16 demo server, build not specified, there is an error when
>>> dealing with data elements and trying to aggregate when data elements are
>>> null.
>>>
>>> ([DE:2005727.*.2005735]  is null )
>>>
>>> Can you check it works for !=NULL
>>>
>>> Regards
>>> --
>>> Prosper Behumbiize, MPH
>>> Phone:+256 414 320076
>>> Cell: +256 772 139037
>>>  +256 752 751776
>>>
>>>
>>
>>
>
___
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] Bug when using ==NULL (is null ) in aggregate query builder

[Tran Chau (HISP Vietnam)]

Hi Prosper,

*[DE:1.2.3] is null *works fine.

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT  wrote:

> Thanks Tran
>
> the one that doesnt work is *[DE:1.2.3] is null*
>
> On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi all,
>>
>> This one *[DE:1.2.3] != null *doesn't work .
>> Aggregate functionality works with formula  *[DE:1.2.3] is not null*.
>>
>> Best regard,
>>
>> Tran
>>
>> On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia 
>> wrote:
>>
>>> Adding Juan and Jose, who has dealt with similar situations.
>>>
>>>>
>>>>
>>>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT  wrote:
>>>>
>>>>> Using 2.16 demo server, build not specified, there is an error when
>>>>> dealing with data elements and trying to aggregate when data elements are
>>>>> null.
>>>>>
>>>>> ([DE:2005727.*.2005735]  is null )
>>>>>
>>>>> Can you check it works for !=NULL
>>>>>
>>>>> Regards
>>>>> --
>>>>> Prosper Behumbiize, MPH
>>>>> Phone:+256 414 320076
>>>>> Cell: +256 772 139037
>>>>>  +256 752 751776
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Phone:+256 414 320076
> Cell: +256 772 139037
>  +256 752 751776
>
>
___
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] Bug when using ==NULL (is null ) in aggregate query builder

[Tran Chau (HISP Vietnam)]

Thanks for the snapshot, Prosper.

I saw the bug now. I am working on it. Will inform you when I finish.

On Sat, Oct 11, 2014 at 8:59 PM, Prosper BT  wrote:

> Hi Tran,
>
> Am running it both on the demo and dev servers, on testing the expressions
> it fails see snap shot below and attached pdf
>
> [image: Inline image 1]
>
> On Sat, Oct 11, 2014 at 4:48 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Prosper,
>>
>> *[DE:1.2.3] is null *works fine.
>>
>> On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT  wrote:
>>
>>> Thanks Tran
>>>
>>> the one that doesnt work is *[DE:1.2.3] is null*
>>>
>>> On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) <
>>> tran.hispviet...@gmail.com> wrote:
>>>
>>>> Hi all,
>>>>
>>>> This one *[DE:1.2.3] != null *doesn't work .
>>>> Aggregate functionality works with formula  *[DE:1.2.3] is not null*.
>>>>
>>>> Best regard,
>>>>
>>>> Tran
>>>>
>>>> On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia 
>>>> wrote:
>>>>
>>>>> Adding Juan and Jose, who has dealt with similar situations.
>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT 
>>>>>> wrote:
>>>>>>
>>>>>>> Using 2.16 demo server, build not specified, there is an error when
>>>>>>> dealing with data elements and trying to aggregate when data elements 
>>>>>>> are
>>>>>>> null.
>>>>>>>
>>>>>>> ([DE:2005727.*.2005735]  is null )
>>>>>>>
>>>>>>> Can you check it works for !=NULL
>>>>>>>
>>>>>>> Regards
>>>>>>> --
>>>>>>> Prosper Behumbiize, MPH
>>>>>>> Phone:+256 414 320076
>>>>>>> Cell: +256 772 139037
>>>>>>>  +256 752 751776
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Phone:+256 414 320076
>>> Cell: +256 772 139037
>>>  +256 752 751776
>>>
>>>
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Phone:+256 414 320076
> Cell: +256 772 139037
>  +256 752 751776
>
>
___
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] Bug when using ==NULL (is null ) in aggregate query builder

[Tran Chau (HISP Vietnam)]

Hi Prosper,

It is fixed on trunk with revision 17060 and 2.16 version with revision
16512.

Please update your code and take a look at it.
Thank you.



Best regards,
Tran

On Sat, Oct 11, 2014 at 9:12 PM, Tran Chau (HISP Vietnam) <
tran.hispviet...@gmail.com> wrote:

> Thanks for the snapshot, Prosper.
>
> I saw the bug now. I am working on it. Will inform you when I finish.
>
> On Sat, Oct 11, 2014 at 8:59 PM, Prosper BT  wrote:
>
>> Hi Tran,
>>
>> Am running it both on the demo and dev servers, on testing the
>> expressions it fails see snap shot below and attached pdf
>>
>> [image: Inline image 1]
>>
>> On Sat, Oct 11, 2014 at 4:48 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Prosper,
>>>
>>> *[DE:1.2.3] is null *works fine.
>>>
>>> On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT  wrote:
>>>
>>>> Thanks Tran
>>>>
>>>> the one that doesnt work is *[DE:1.2.3] is null*
>>>>
>>>> On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) <
>>>> tran.hispviet...@gmail.com> wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> This one *[DE:1.2.3] != null *doesn't work .
>>>>> Aggregate functionality works with formula  *[DE:1.2.3] is not null*.
>>>>>
>>>>> Best regard,
>>>>>
>>>>> Tran
>>>>>
>>>>> On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia 
>>>>> wrote:
>>>>>
>>>>>> Adding Juan and Jose, who has dealt with similar situations.
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Using 2.16 demo server, build not specified, there is an error when
>>>>>>>> dealing with data elements and trying to aggregate when data elements 
>>>>>>>> are
>>>>>>>> null.
>>>>>>>>
>>>>>>>> ([DE:2005727.*.2005735]  is null )
>>>>>>>>
>>>>>>>> Can you check it works for !=NULL
>>>>>>>>
>>>>>>>> Regards
>>>>>>>> --
>>>>>>>> Prosper Behumbiize, MPH
>>>>>>>> Phone:+256 414 320076
>>>>>>>> Cell: +256 772 139037
>>>>>>>>  +256 752 751776
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Prosper Behumbiize, MPH
>>>> Phone:+256 414 320076
>>>> Cell: +256 772 139037
>>>>  +256 752 751776
>>>>
>>>>
>>>
>>>
>>
>>
>> --
>> Prosper Behumbiize, MPH
>> Phone:+256 414 320076
>> Cell: +256 772 139037
>>  +256 752 751776
>>
>>
>
>
___
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] [Bug 1378893] Re: Prune period and automated aggregation of tracker data fails in 2.16

[Tran Chau (HISP Vietnam)]

Hi Simon,

The bug [1] is fixed in version 2.16, revision 16513. Please take a look at
it on your side.

For the bug [2], I did run on the demo server and my local server. It
doesn't show the same issue.
Maybe giving me the full log file instead of the partial log file will help
me to analyze the issue.
Note that even looking at the full log file might not give me information I
need, but let's try this first.

Best regards,
Tran

On Sat, Oct 11, 2014 at 7:53 PM, Simon Ndira  wrote:

> Hi Thu Trun,
> I am using this version:
> Version:
> 2.16
> Build revision:
> 16506
> Build date:
> 2014-10-08 13:15
>
> Regarding the issue. It has to do with Pruning periods and Tracker.
>
> Pruning periods: When I go to 'Data Administration' -> 'Maintenance' ->
> Perform Maintenance -> 'only for prune period'. This hangs with errors
> further below.
> Aggregation: When I go to 'Program / Attributes' -> 'Automated
> aggregation' -> 'Execute'. This also hangs with errors further below.
>
> Please let me know if you have any further questions.
> Thanks;
> Simon.
>
>
> -Original Message-
> From: boun...@canonical.com [mailto:boun...@canonical.com] On Behalf Of
> Thu Tran
> Sent: Saturday, October 11, 2014 12:35 PM
> To: simon.nd...@ehmis.org
> Subject: [Bug 1378893] Re: Prune period and automated aggregation of
> tracker data fails in 2.16
>
> Hi Simon,
>
> Which revision do you use for testing ?
>
> For 2nd issue, could you talk to me what is the functionality got this
> issue ?
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1378893
>
> Title:
>   Prune period and automated aggregation of tracker data fails in 2.16
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   I have upgraded my database to 2.16. Everything is working fine, apart
>   from two critical functionalities:
>
>   1. Automated aggregate in Programs / Attributes for tracked instances to
> aggregate data raises the following error:
>   at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>   at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>   at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>   at java.lang.Thread.run(Thread.java:724)
>   Caused by: org.postgresql.util.PSQLException: ERROR: null value in
> column "periodid" violates not-null constraint
> Detail: Failing row contains (null, 1, 2013-10-08, 2013-10-08).
>   at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
>   at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
>   at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
>   at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
>   at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
>   at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
>   at
> com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
>   at
> org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
>   at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
>   ... 29 more
>
>   
>   So the only way I can aggregate now is through manual aggregation in
> individual records.
>
>   2. I cannot execute prune periods as the script hangs with 28 more .
>at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
>   at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
>   at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>   at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>   at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>   at java.lang.Thread.run(Thread.java:724)
>   Caused by: java.lang.NullPointerException
>   at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)
>   at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)
>   ... 27 more
>
>   *
>
>   Might someone have figured a way out of this?
>
>   Thanks and looking forward.
>   Simon.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1378893/+subscriptions
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpa