Calculated elements and reuse of elements

Support - Assistance technique
1

The two forms are attached; the first is in DHIS form generator without totals, the second is from their current system. I take it from your answer that we can't display calculated data elements in read-only mode.

Some miscellaneous questions:
1. Is there a way of developing forms and reports on one machine and transferring them to another?
2. What is the status of individual patient entry? Could there be a combo data type that displayed a list of category combo values in a combo box? I couldn't quite tell from the Case Aggregation Mapping form what was going on. Is there a roadmap or tickets to follow to see where this is going?
3. As I understand it, at this time text fields don't roll up. Could they roll up as counts (null v. populated)? How about yes/no fields, do they roll up as counts of yes? Think of 2 questions like "Did x occur? If yes, how much y was involved?" What you'd like to roll up is sum/average of y for x=yes, could be done with SQL if y=0 can be distinguished from y=null, but safer to do sum(y) where x=true for sum, sum(y)/count(x=true) for average. [In my case, x=had a stockout of 1 week or more, y=days of stockout.]

Thanks, Roger

Malaria Forms.pdf (35.2 KB)

···

-----Original Message-----
From: Ola Hodne Titlestad [mailto:olatitle@gmail.com]
Sent: Friday, September 03, 2010 2:22 AM
To: Friedman, Roger (CDC/CGH/DGHA) (CTR); DHIS 2 developers; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Calculated elements and reuse of elements

Hi Roger, any chance you could share these form layouts with us? The
quick answer is that your totals can be retrieved using the dimension
report tables and you can set up standard reports on top of that for
your totals form. If you decide to key in the totals directly in
addition to the breakdowns you need to use separate data elements for
that. Then you can use validation rules to compare the two sets. More
later. Ola

2010/9/2, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov>:

List --
    We have a form that has outpatient visits disaggregated by sex, age (11
categories including 0-1 and 1-5), new/returning patient, and insurance
yes/no. Can I display calculated data elements for the totals? Can I
validate keyed totals against calculated data elements?
    At the bottom of that form is a small table with total malaria cases
disaggregated by age under and over 5.
    We have a second form that has several aspects of malaria treatment
(means of diagnosis, adverse reactions, adverse reactions with
hospitalization). These are disaggregated into age under 5, pregnant, and
all others, which is a degenerate way of disaggregating by age under and
over 5 and pregnancy status with under 5 pregnant=0.
    The second form is arranged for doing rates against all malaria cases
and all outpatient cases, the totals are copied in from the first form. Can
I do total calculations on the first dataset and display them on the second
dataset?
Thanks, Roger

PS -- Turns out the team lead or deputy spent 6 years in Norway, hope y'all
get to meet him in Accra.

--
Sendt fra min mobile enhet

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway&gt;

1 Like
2

Re: [Dhis2-users] Calculated elements and reuse of elements

  1. In the data element group editor, please turn off tool tips, they just get in the way.

  2. In the data element editor, why is the check box for a data element group set selection rather than for a data element group selection? Seems like what’s needed is a two-step selector, first on data element group set, then on the groups of the selected data element group set.

  3. Form editor perhaps changed control versions in 2.0.4 or maybe Firefox is broken. Column size changes by drag-drop no longer works; column size changes when typing in a cell, squeezing subsequent cells; table handles are frequently in the wrong place; there is no blank space at bottom of form to add new tables or images (had to add
    to source); tables without a
    between don’t render side by side.

1 Like
3

Re: [Dhis2-users] Calculated elements and reuse of elements

More:

  1. When deleting data elements, it’s necessary to delete the data element from any datasets or groups to which they belong. Seems like this cascade could be handled programmatically, perhaps as part of a delete confirm message.

  2. When selecting a data element-category option combo to bind to a field in the html editor, if there is only one category option combo, it should be selected by default. (This is probably so easy I could do it if I could only get my eclipse project set up.) BTW, the data element-category option combo selection box is still coming up inappropriately when Save is clicked. Also, it would be good to have the bind button action on the right-click menu in the html editor, right-click seems to be the action I automatically take in that process.

  3. I had a session time out with the data entry screen on the page. There was no warning, I was able to enter the remaining fields on the page, but they were not saved. Not good, data loss during data entry is a confidence destroyer.

  4. I had MySQL failures while making dataset custom forms. Edits were lost without warning. The same error occurred elsewhere and I got a message, seems like an error is not being properly trapped. BTW, the MySQL error had a helpful message in the Tomcat log, required corrective actions probably should be included in installation instructions:

    The driver was unable to create a connection due to an inability to establish the client portion of a socket.

    This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable.

    For Unix-based platforms, see the manual page for the ‘ulimit’ command. Kernel or system reconfiguration may also be required.

    For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).

  5. In dataset reports, please hide the buttons before printing. Also make printing of headers optional.

  6. The organization unit selection tree retains its gold-colored items when appearing in a new context, but the items are not perceived as selected by the program. (This probably arose when moving from data entry to dataset reports and back.)

···

From: dhis2-users-bounces+rdf4=cdc.gov@lists.launchpad.net [mailto:dhis2-users-bounces+rdf4=cdc.gov@lists.launchpad.net] On Behalf Of Friedman, Roger (CDC/CGH/DGHA) (CTR)

Sent: Wednesday, September 15, 2010 4:45 PM

To: dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Subject: [Dhis2-users] I got issues

  1. In the data element group editor, please turn off tool tips, they just get in the way.

  2. In the data element editor, why is the check box for a data element group set selection rather than for a data element group selection? Seems like what’s needed is a two-step selector, first on data element group set, then on the groups of the selected data element group set.

  3. Form editor perhaps changed control versions in 2.0.4 or maybe Firefox is broken. Column size changes by drag-drop no longer works; column size changes when typing in a cell, squeezing subsequent cells; table handles are frequently in the wrong place; there is no blank space at bottom of form to add new tables or images (had to add
    to source); tables without a
    between don’t render side by side.

1 Like
4

I understand a number of you are staying at the Coconut Grove, I will come over this afternoon, hope to meet many of you. If any of you would like to go to either the Kwame Nkrumah Memorial or Labadie Beach this afternoon, I'd be happy to arrange it. (I think there's also a football match if anyone wants to do that.) Send an e-mail or give me a call at 054-0517905.

1 Like
5

More:

4. When deleting data elements, it’s necessary to delete the data element
from any datasets or groups to which they belong. Seems like this cascade
could be handled programmatically, perhaps as part of a delete confirm
message.

5. When selecting a data element-category option combo to bind to a field
in the html editor, if there is only one category option combo, it should be
selected by default. (This is probably so easy I could do it if I could
only get my eclipse project set up.) BTW, the data element-category option
combo selection box is still coming up inappropriately when Save is
clicked. Also, it would be good to have the bind button action on the
right-click menu in the html editor, right-click seems to be the action I
automatically take in that process.

6. I had a session time out with the data entry screen on the page. There
was no warning, I was able to enter the remaining fields on the page, but
they were not saved. Not good, data loss during data entry is a confidence
destroyer.

7. I had MySQL failures while making dataset custom forms. Edits were lost
without warning. The same error occurred elsewhere and I got a message,
seems like an error is not being properly trapped. BTW, the MySQL error had
a helpful message in the Tomcat log, required corrective actions probably
should be included in installation instructions:

The driver was unable to create a connection due to an inability to

establish the client portion of a socket.

This is usually caused by a limit on the number of sockets imposed by

the operating system. This limit is usually configurable.

Roger this really shouldn't be happening as dhis *should* be
connecting to mysql via a connection pool and the rate of establishing
connections really shouldn't be that high as to exhaust the max number
of sockets/ephemeral ports.

Maybe if you send me your hibernate properties file I can have a look.
Otherwise I think I'll see you tomorrow anyway :slight_smile:

Bob

···

On 19 September 2010 09:57, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov> wrote:

For Unix\-based platforms, see the manual page for the &#39;ulimit&#39; command\.

Kernel or system reconfiguration may also be required.

For Windows\-based platforms, see Microsoft Knowledge Base Article 196271

(Q196271).

8. In dataset reports, please hide the buttons before printing. Also make
printing of headers optional.

9. The organization unit selection tree retains its gold-colored items when
appearing in a new context, but the items are not perceived as selected by
the program. (This probably arose when moving from data entry to dataset
reports and back.)

From: dhis2-users-bounces+rdf4=cdc.gov@lists.launchpad.net
[mailto:dhis2-users-bounces+rdf4=cdc.gov@lists.launchpad.net] On Behalf Of
Friedman, Roger (CDC/CGH/DGHA) (CTR)
Sent: Wednesday, September 15, 2010 4:45 PM
To: dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] I got issues

1. In the data element group editor, please turn off tool tips, they just
get in the way.

2. In the data element editor, why is the check box for a data element
group set selection rather than for a data element group selection? Seems
like what's needed is a two-step selector, first on data element group set,
then on the groups of the selected data element group set.

3. Form editor perhaps changed control versions in 2.0.4 or maybe Firefox
is broken. Column size changes by drag-drop no longer works; column size
changes when typing in a cell, squeezing subsequent cells; table handles are
frequently in the wrong place; there is no blank space at bottom of form to
add new tables or images (had to add <BR> to source); tables without a <BR>
between don't render side by side.

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

1 Like