dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #22165
Re: Defualt data entry period
Dear All,
Is it possible to showing only 'Current Period' in the 'data entry' form?
I mean to say.
Suppose the frequency of the data entry form is "daily" then period showing current date by default no need to select from
drop down menu.
Please help me.
Barnali Banerjee
________________________________
From: Lars Helge Øverland <larshelge@xxxxxxxxx>
To: Barnali Bhaduri <barnali760@xxxxxxxxxxx>
Cc: Tran Chau <tran.hispvietnam@xxxxxxxxx>; Morten Olav Hansen <mortenoh@xxxxxxxxx>
Sent: Wednesday, 17 April 2013 4:52 AM
Subject: Re: [Dhis2-devs] Period
No that will also be too often.. At the moment we only support daily scheduling. We could maybe support something like hourly, but I think this will be too much as the data volume grows..
On Wed, Apr 17, 2013 at 9:31 AM, Barnali Bhaduri <barnali760@xxxxxxxxxxx> wrote:
Hi Lars,
>
>Ok,thank you very much.
>I have been created a 'aggregate query' and I have one program with "Single event without registration".
>I want to 'Execute' this query every time after completion of 'Individual record' entry.
>Is it possible?If yes,please let me know the procedure.
>
>
>Regards
>
>Barnali Banerjee
>
>
>________________________________
> From: Lars Helge Øverland <larshelge@xxxxxxxxx>
>To: Barnali Bhaduri <barnali760@xxxxxxxxxxx>
>Cc: Tran Chau <tran.hispvietnam@xxxxxxxxx>; Morten Olav Hansen <mortenoh@xxxxxxxxx>
>Sent: Tuesday, 16 April 2013 2:38 PM
>Subject: Re: [Dhis2-devs] Period
>
>
>
>Hi Barnali,
>
>
>I don't think running queries every second is a good idea... Will eat all of the server resources and make the system slow.
>
>
>
>On Tue, Apr 16, 2013 at 8:03 PM, Barnali Bhaduri <barnali760@xxxxxxxxxxx> wrote:
>
>ok Tran, I mean to say "Aggregation query builder scheduled job".
>>"Every one second" mean "I want to execute automatic aggregation every second automatically"
>>
>>Regards
>>Barnali Banerjee
>>
>>
>>________________________________
>> From: Tran Chau <tran.hispvietnam@xxxxxxxxx>
>>To: Barnali Bhaduri <barnali760@xxxxxxxxxxx>
>>Cc: Lars Helge Øverland <larshelge@xxxxxxxxx>; Morten Olav Hansen <mortenoh@xxxxxxxxx>
>>Sent: Tuesday, 16 April 2013 6:54 PM
>>Subject: Re: [Dhis2-devs] Period
>>
>>
>>
>>Dear Barnali,
>>
>>
>>@ Is it possible at the time of data entry period showing only current period, no need to select from the drop down list.
>>Example.
>>Suppose frequency of the dataset may be 'yearly'.At the time of data entry period display '2013' automaticaly,no need to select from drop down list.
>>
>>
>>Sorry, I cannot answer this. It looks like a requirement. I think Morten or Lars can reply this.
>>
>>
>>
>>@It is possible to run scheduled job every one second or customize the scheduled job ,if yes then how.
>>
>>
>>Which scheduled job you're talking about is ? You mean data mart ( schedule job for datavalues ) OR Aggregation query builder scheduled job ?
>>
>>
>>And what do you mean about "every one second" ?
>>
>>
>>
>>
>>
>>
>>Best regards,
>>------------------------------------------------
>>Châu Thu Trân
>>HISP Viet Nam
>>Email: tran.hispvietnam@xxxxxxxxx
>>
>>
>>On Tue, Apr 16, 2013 at 4:50 PM, Barnali Bhaduri <barnali760@xxxxxxxxxxx> wrote:
>>
>>Dear Tran Chatu,
>>> Is it possible at the time of data entry period showing only current period, no need to select from the drop down list.
>>>Example.
>>>Suppose frequency of the dataset may be 'yearly'.At the time of data entry period display '2013' automaticaly,no need to select from drop down list.
>>>
>>>
>>>
>>>It is possible to run scheduled job every one second or customize the scheduled job ,if yes then how.
>>>
>>>Regards
>>>
>>>Barnali Banerjee
>>>
>>>
>>>________________________________
>>> From: Tran Chau <tran.hispvietnam@xxxxxxxxx>
>>>To: Barnali Bhaduri <barnali760@xxxxxxxxxxx>
>>>Cc: Lars Helge Øverland <larshelge@xxxxxxxxx>; DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>>Sent: Monday, 15 April 2013 9:06 AM
>>>Subject: [Dhis2-devs] Requirement
>>>
>>>
>>>
>>>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 <barnali760@xxxxxxxxxxx> 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 <rajibs123@xxxxxxxxx>
>>>> To: Tanusree Bag <tanusree.bag@xxxxxxxxx>; Barnali Bhaduri <barnali760@xxxxxxxxxxx>
>>>> Sent: Monday, 15 April 2013 3:02 AM
>>>> Subject: Fw: [Dhis2-devs] Fwd: Re: Requirement
>>>>
>>>>
>>>> ----- Forwarded Message -----
>>>> From: Tran Chau <tran.hispvietnam@xxxxxxxxx>
>>>> To: Lars Helge Øverland <larshelge@xxxxxxxxx>
>>>> Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>>> 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.hispvietnam@xxxxxxxxx
>>>>
>>>> On Thu, Apr 11, 2013 at 2:44 PM, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:
>>>>
>>>> ---------- Forwarded message ----------
>>>> From: "Barnali Bhaduri" <
>>>>
>>>>
>>>
>>>--
>>>Best regards,
>>>------------------------------------------------
>>>Châu Thu Trân
>>>HISP Viet Nam
>>>Email: tran.hispvietnam@xxxxxxxxx
>>>
>>>
>>>
>>
>>
>>
>
>
>
Follow ups
References
-
Requirement
From: Barnali Bhaduri, 2013-04-07
-
Re: Requirement
From: Rodolfo Melia, 2013-04-08
-
Re: Requirement
From: Barnali Bhaduri, 2013-04-09
-
Re: Requirement
From: Rodolfo Melia, 2013-04-09
-
Re: Requirement
From: Lars Helge Øverland, 2013-04-10
-
Fwd: Re: Requirement
From: Lars Helge Øverland, 2013-04-11
-
Re: Fwd: Re: Requirement
From: Tran Chau, 2013-04-11
-
Re: Fwd: Re: Requirement
From: Barnali Bhaduri, 2013-04-15
-
Requirement
From: Tran Chau, 2013-04-15
-
Re: Period
From: Barnali Bhaduri, 2013-04-16