Re: [Dhis2-users] need Assistance

[Murod Latifov]

Hi,

Can we add dataset id to datavalue and make each dataset elements value
unique? This is required most of the time and also easy for analysis
avoiding redundabt dataelements with exact same definition.

Regards,
Murod

On 9 Dec 2016 15:21, "Lars Helge Øverland"  wrote:

> Hi Stephen,
>
> a DHIS 2 data value is linked to data elements, not data sets. The
> implication is that if you have a data element being part of multiple data
> sets and enter a data value for the first data set, then the data value
> will show up pre-filled in the other data set when you open it. So there
> will not be duplication, but you will not be able to have different data
> values for that data element, as the data element will point to the same
> data value irrespective of which data set you open. I am assuming that the
> same org unit, period and data set category has been selected in the this
> scenario.
>
> regards,
>
> Lars
>
>
>
>
> On Fri, Dec 9, 2016 at 11:06 AM, Trøyel Nerbø  wrote:
>
>> Hi Stephen,
>>
>> As far as I understand the data set is just a way to organize and present
>> data elements. If you want to use the same data element in two different
>> data sets, and not share data between them, you have to employ a different
>> disaggregation. Using category combination on the data set will retain the
>> same data element with its disaggregation’s but give the ability to
>> separate the data entered on different data sets. See the manual:
>> https://ci.dhis2.org/docs/master/en/user/html/dhis2_user_
>> manual_en_full.html#d1245e4345
>>
>>
>>
>> (In NRC we use several category options as attributes to specify i.e.
>> which project the reported data belongs to). I hope this helps!
>>
>>
>>
>> Best regards,
>>
>> Trøyel
>>
>>
>> Best Regards
>> *Halvar Trøyel Nerbø*
>> Reporting Advisor
>>
>> +47 992 39 817 <992%2039%20817>
>>
>> Skype: nrc_troyel
>> www.nrc.no
>>
>> [image: nrclogo] 
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *From:* Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=
>> nrc...@lists.launchpad.net] *On Behalf Of *Stephen Gbanyan
>> *Sent:* fredag 9. desember 2016 10.09
>> *To:* dhis2-users 
>> *Subject:* [Dhis2-users] need Assistance
>>
>>
>>
>> Hi All,
>>
>> Is it possible to have a data element sharing two different data sets? If
>> so will it not duplicate figures?
>>
>> Thanks
>>
>>
>> --
>>
>> __
>> Stephen M. Gbanyan, Jr. - ASc. BA.
>> Director
>> Health Information System
>> Ministry of Health and Social Welfare
>> Republic of Liberia
>> +231-886-847-915
>> skype: mambu9
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Datasets with the same data element overwrite datavalues

[Murod Latifov]

Hi devs,

I have set of data elements with YESONLY value. While two datasets are
assigned the same data elements, result overwrites datavalues. Checking
data element in one data entry form affects other from different dataset.
Is this a bug or a normal behaviour?

DHIS2 version 2.25

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

[Dhis2-users] Pivot4j integration

[Murod Latifov]

Dear devs and users,

I integrated Pivot4j (its user interface and backend) into DHIS2 codebase.
Its a tooling like "analytics" of DHIS2 based on global standards of OLAP.
For more info please look at http://www.pivot4j.org

If anybody is interested I can share integration prcoess to make it run
within DHIS2.

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

Re: [Dhis2-users] org unit type

[Murod Latifov]

Hi Jason,

Thanks again, I'll try your method, but don't know if it works with
value/price/fac type calculations. No we have our own RBF module that we
shared with BlueSquare guys who also work with Oslo team on RBF.

best regards,
murod

On Thu, Jan 7, 2016 at 11:35 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Murod,
> Yes, that would be a use of the group set functionality which would need
> of course to be implemented in some way. Whether it be implemented in the
> core, through a custom module or set of scripts running on the server is
> really more an implementation problem I guess.  However the advantage of
> designing it with the way which I mentioned, would be that all of the other
> analytical tools would work out of the box, with the defined group sets.
> You might in addition to performing certain calculations based on orgunit
> group type, simply aggregate data according to group type, which would not
> be possible with the standard tools (PivotTables, GIS, DataVisualizer, etc)
> when the group is defined in the phone number!
>
> I still think implementing it this way would be best, then your specific
> functionality (implemented as a module or part of the core) would of course
> need to be implemented.
>
> I know the India team has a custom RBF module, but I am not sure if this
> is what you are after.
>
> Best regards,
> Jason
>
>
> On Thu, Jan 7, 2016 at 6:32 AM, Murod Latifov  wrote:
>
>> Hi Jason,
>>
>> Thanks for the hint and Happy New Year! All is fine, thanks. Hope you are
>> doing well!
>>
>> I think this was an old blueprint to be implemented. The way you are
>> proposing does not solve the problem. An idea is to route calculations and
>> other adjustments depending on facility type. For instance, different
>> facility types have different responsibility and reporting capacity. This
>> becomes actual when RBF is in use.
>> I think to have such field is important. We have hierarchy, we have
>> facilities, facilities perform health services, administrative divisions
>> (district, province) do not, etc.
>>
>> Meanwhile I am using phone numeber to mark types of facilities. Hope in
>> the future this will be implemented as useful feature for better reporting
>> and aggregation purposes.
>>
>> best regards,
>> murod
>>
>> On Wed, Jan 6, 2016 at 10:37 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Murod
>>> Hope you are well and happy new year.
>>>
>>> Just create an orgunit group set called "Type" and make groups of all
>>> your types as members of this group set.  Then assign each of you orgunits
>>> to exactly one of these groups.
>>>
>>> Regards
>>> Jason
>>>
>>> On Wed, Jan 6, 2016, 18:29 Murod Latifov  wrote:
>>>
>>>> Hi all,
>>>>
>>>> Is there a way to define org unit type, e.g health center, health
>>>> house, hospital, etc?
>>>> DHIS2.21
>>>> best regards,
>>>> murod
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] org unit type

[Murod Latifov]

Hi Jason,

Thanks for the hint and Happy New Year! All is fine, thanks. Hope you are
doing well!

I think this was an old blueprint to be implemented. The way you are
proposing does not solve the problem. An idea is to route calculations and
other adjustments depending on facility type. For instance, different
facility types have different responsibility and reporting capacity. This
becomes actual when RBF is in use.
I think to have such field is important. We have hierarchy, we have
facilities, facilities perform health services, administrative divisions
(district, province) do not, etc.

Meanwhile I am using phone numeber to mark types of facilities. Hope in the
future this will be implemented as useful feature for better reporting and
aggregation purposes.

best regards,
murod

On Wed, Jan 6, 2016 at 10:37 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Murod
> Hope you are well and happy new year.
>
> Just create an orgunit group set called "Type" and make groups of all your
> types as members of this group set.  Then assign each of you orgunits to
> exactly one of these groups.
>
> Regards
> Jason
>
> On Wed, Jan 6, 2016, 18:29 Murod Latifov  wrote:
>
>> Hi all,
>>
>> Is there a way to define org unit type, e.g health center, health house,
>> hospital, etc?
>> DHIS2.21
>> best regards,
>> murod
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] org unit type

[Murod Latifov]

Hi all,

Is there a way to define org unit type, e.g health center, health house,
hospital, etc?
DHIS2.21
best regards,
murod
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data entry forms and functions

[Murod Latifov]

Thanks Prosper,

For the clarification. I found a solution by creating "month one", "two"
"three" category options. though data are saved for the quarter. This way
we can have more accurate form and distinguish between months in a quarter.

regards,
murod

On Mon, Jan 4, 2016 at 10:09 PM, Prosper BT  wrote:

> Dear Murod,
>
> This is not available in DHIS2 at the moment. As you say you can only
> enter data for one given period at a time. What is available is only
> entering at multiple orgunits with sections datasets.
>
> Regards
>
> On Mon, Jan 4, 2016 at 7:10 AM, Murod Latifov  wrote:
>
>> Hi,
>>
>> Is it possible to have datasets of monthly period and select 3 months
>> fields upon selection of quarter period? This is important for simplicity
>> of forms and user friendliness. I think this is not possible because only
>> single period is selectable for data entry? Anybody had such requirement or
>> is there an easy solution for this?
>>
>> best regards,
>> murod
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Data entry forms and functions

[Murod Latifov]

Hi,

Is it possible to have datasets of monthly period and select 3 months
fields upon selection of quarter period? This is important for simplicity
of forms and user friendliness. I think this is not possible because only
single period is selectable for data entry? Anybody had such requirement or
is there an easy solution for this?

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

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Felix,

Your sql query should be something like this:

select de.name as dename, ou.name as ouname, pe.startdate,
dv.dataelementid, categoryoptioncomboid, pe.periodid, value as val,
dv.sourceid as orgunitid from datavalue dv
left join dataelement de
on dv.dataelementid = de.dataelementid
left join period pe
on dv.periodid = pe.periodid
left join organisationunit ou
on dv.sourceid = ou.organisationunitid
WHERE de.dataelementid in (2323, 2334, 2335) and dv.periodid=343




On Fri, Nov 29, 2013 at 10:05 PM, Felix Obareh wrote:

> Murod,
>
> Ok, let me explain myself...
> Assume i am collecting data with regard to facility Assessment and my data
> elements
>
> 1) "Lighting and ventilation is observed to be adequate" (YES/NO)
> 2) "General state of facility" (Option Set) --i) Poor ii) Fair iii)
> Average
> 3) "Additional notes related to facility" (string)
> 4) Does the facility have Handwashing Faility (YES/NO) * This only mean we
> want to make sure each facility has a handwashing facility
>
> This will be done by a District Public Health Officer. You can aggregate
> this about the facility. I can actually create a form for the DPHO to enter
> the data for his monthly facility assessment for each facility. The chief
> DPHO wants a report about each facility. The data is stored into the value
> table.
>
> Value Count is a good idea but i don't want a count but the actual value
> for analysis
>
> Cheers
>
> I don't need a count but a
>
>
> On Fri, Nov 29, 2013 at 7:33 PM, Murod Latifov  wrote:
>
>> Hi Felix,
>>
>> I do not understand for large on what you mean with "raw data" but can
>> say if you are not looking for aggregated data for the sake of SQL
>> requirements, just use count(1 as nothing) or count(value as value)
>> avoiding type cast issues.
>>
>> best,
>> murod
>>
>>
>> On Fri, Nov 29, 2013 at 9:19 PM, Felix Obareh wrote:
>>
>>> Thank you people for you input..
>>>
>>> If i can clarify that the query is to pick raw data that otherwise is
>>> recorded but we cannot retrieve because its not aggregated. This data would
>>> include the following
>>> Here is my full query:-
>>>
>>> select county.name as county,subcounty.name as subcounty,division.nameas 
>>> division,
>>> sublocation.name as sublocation, ou.name as facility,triggerstate.value
>>> as triggerstate
>>> from organisationunit ou
>>> left outer join _orgunitstructure ous
>>>   on (ou.organisationunitid=ous.organisationunitid)
>>>   left outer join organisationunit county
>>>   on (ous.idlevel2=county.organisationunitid)
>>>   left outer join organisationunit subcounty
>>>   on (ous.idlevel3=subcounty.organisationunitid)
>>>   left outer join organisationunit division
>>>   on (ous.idlevel4= division.organisationunitid)
>>> left outer join organisationunit location
>>>   on (ous.idlevel5=location.organisationunitid)
>>> left outer join organisationunit Sublocation
>>>   on (ous.idlevel6=sublocation.organisationunitid)
>>>left outer join (
>>>  * select sourceid, sum(cast(value as double precision)) as value*
>>>   from datavalue
>>>   where dataelementid=8305
>>>  group by sourceid) as triggerstate on
>>> triggerstate.sourceid=ou.organisationunitid
>>> where ous.level=7
>>>
>>> 
>>> ERROR:  invalid input syntax for type double precision: "false"
>>>
>>> ** Error **
>>>
>>> ERROR: invalid input syntax for type double precision: "false"
>>> SQL state: 22P02
>>>
>>> ==
>>> I want to just get the list of facilities trigger states Trues/False
>>> ---I dont need aggregated data because the other elements i would want to
>>> include are date, i have an element with option type (with text) also
>>> stored into value table. I need to retrieve that and create a report.
>>>
>>> I can't use the * select sourceid, sum(cast(value as double precision))
>>> as value --- *To get the raw data
>>>
>>> A good test is to use the Siera Leone demo and create a query to display
>>> the facility assessment raw data.
>>> 1) "General state of facility"
>>> 2) "Lighting and ventilation is observed to be adequate"
>>>
>>> Cheers
>>>
>>>
>>>
>>> On Fri, Nov 29, 2013 at 6:25 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Jason,

Than as I said earlier, it should be fairly simple SQL query to datavalue
table, adding iner tables from which he wants DE name, Period name, etc. I
don't see any problem here. Call datavalue table, add data element name
from iner join of dataelement table and so forth for others, filter on
WHERE clause what you want to omit and report is ready. As for Jasper I
don't know how fat it can be productive in producing report in the layout
Felix wants it. We use plain word or opendoc to express what is needed,
system will decide and make necessary calls to get data in. It is also
possible to perform logical and math operations as expression in the
template document, like I want this DE minus that DE divided to this
Indicator, or logic of "if values is this do this, otherwise do something
or nothing". Sort of "No sql", no worries, no techie stuff. Design word
doc, nice formatted tables and each cell describes what should be in there,
that's it.

best,
murod


On Fri, Nov 29, 2013 at 10:46 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Murod,
> The issue here is that these values (text, etc) are not visible through
> data set reports, as they are not able to be aggregated. So Felix needs a
> way to get the "raw data" out, without any aggregation. Perhaps I am as
> well totally off-topic as well, but this was the original request as I
> understood it. The above query, will simply return the contents of the data
> value table, with a bit basic information. Likely, it would need to be
> modified with more fields, and pulled into a Jasper report, along with some
> paramaters (such as the period and orgunit of interest) along with
> filtering for specific data elements, which might be present in a data set.
> We have implemented similar types of reports, but of course, it is possible
> do to the same thing through the data entry screens now, when you can limit
> who has access to alter the data. But creating a report  or pulling this
> "raw data" into Excel may also be needed in certain cases. This is the
> purpose of this query.
>
> Regards,
> Jason
>
>
>
> On Fri, Nov 29, 2013 at 7:39 PM, Murod Latifov  wrote:
>
>> Hi Felix,
>>
>> It is still unclear to me. If you have a combination of yes/no, custom
>> text values you definitely need an advanced query pointing each criteria
>> type or create indicator that brings this all in one possible value. If you
>> want simply report these exact data just read them and print, should be
>> fairly easy.
>>
>> best,
>> murod
>>
>>
>> On Fri, Nov 29, 2013 at 10:05 PM, Felix Obareh wrote:
>>
>>> Murod,
>>>
>>> Ok, let me explain myself...
>>> Assume i am collecting data with regard to facility Assessment and my
>>> data elements
>>>
>>> 1) "Lighting and ventilation is observed to be adequate" (YES/NO)
>>> 2) "General state of facility" (Option Set) --i) Poor ii) Fair iii)
>>> Average
>>> 3) "Additional notes related to facility" (string)
>>> 4) Does the facility have Handwashing Faility (YES/NO) * This only mean
>>> we want to make sure each facility has a handwashing facility
>>>
>>> This will be done by a District Public Health Officer. You can aggregate
>>> this about the facility. I can actually create a form for the DPHO to enter
>>> the data for his monthly facility assessment for each facility. The chief
>>> DPHO wants a report about each facility. The data is stored into the value
>>> table.
>>>
>>> Value Count is a good idea but i don't want a count but the actual value
>>> for analysis
>>>
>>> Cheers
>>>
>>> I don't need a count but a
>>>
>>>
>>> On Fri, Nov 29, 2013 at 7:33 PM, Murod Latifov wrote:
>>>
>>>> Hi Felix,
>>>>
>>>> I do not understand for large on what you mean with "raw data" but can
>>>> say if you are not looking for aggregated data for the sake of SQL
>>>> requirements, just use count(1 as nothing) or count(value as value)
>>>> avoiding type cast issues.
>>>>
>>>> best,
>>>> murod
>>>>
>>>>
>>>> On Fri, Nov 29, 2013 at 9:19 PM, Felix Obareh 
>>>> wrote:
>>>>
>>>>> Thank you people for you input..
>>>>>
>>>>> If i can clarify that the query is to pick raw data that otherwise is
>>>>> recorded but we cannot retrieve because its not aggregated. This data 
>>>>> would
>>

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Felix,

It is still unclear to me. If you have a combination of yes/no, custom text
values you definitely need an advanced query pointing each criteria type or
create indicator that brings this all in one possible value. If you want
simply report these exact data just read them and print, should be fairly
easy.

best,
murod


On Fri, Nov 29, 2013 at 10:05 PM, Felix Obareh wrote:

> Murod,
>
> Ok, let me explain myself...
> Assume i am collecting data with regard to facility Assessment and my data
> elements
>
> 1) "Lighting and ventilation is observed to be adequate" (YES/NO)
> 2) "General state of facility" (Option Set) --i) Poor ii) Fair iii)
> Average
> 3) "Additional notes related to facility" (string)
> 4) Does the facility have Handwashing Faility (YES/NO) * This only mean we
> want to make sure each facility has a handwashing facility
>
> This will be done by a District Public Health Officer. You can aggregate
> this about the facility. I can actually create a form for the DPHO to enter
> the data for his monthly facility assessment for each facility. The chief
> DPHO wants a report about each facility. The data is stored into the value
> table.
>
> Value Count is a good idea but i don't want a count but the actual value
> for analysis
>
> Cheers
>
> I don't need a count but a
>
>
> On Fri, Nov 29, 2013 at 7:33 PM, Murod Latifov  wrote:
>
>> Hi Felix,
>>
>> I do not understand for large on what you mean with "raw data" but can
>> say if you are not looking for aggregated data for the sake of SQL
>> requirements, just use count(1 as nothing) or count(value as value)
>> avoiding type cast issues.
>>
>> best,
>> murod
>>
>>
>> On Fri, Nov 29, 2013 at 9:19 PM, Felix Obareh wrote:
>>
>>> Thank you people for you input..
>>>
>>> If i can clarify that the query is to pick raw data that otherwise is
>>> recorded but we cannot retrieve because its not aggregated. This data would
>>> include the following
>>> Here is my full query:-
>>>
>>> select county.name as county,subcounty.name as subcounty,division.nameas 
>>> division,
>>> sublocation.name as sublocation, ou.name as facility,triggerstate.value
>>> as triggerstate
>>> from organisationunit ou
>>> left outer join _orgunitstructure ous
>>>   on (ou.organisationunitid=ous.organisationunitid)
>>>   left outer join organisationunit county
>>>   on (ous.idlevel2=county.organisationunitid)
>>>   left outer join organisationunit subcounty
>>>   on (ous.idlevel3=subcounty.organisationunitid)
>>>   left outer join organisationunit division
>>>   on (ous.idlevel4= division.organisationunitid)
>>> left outer join organisationunit location
>>>   on (ous.idlevel5=location.organisationunitid)
>>> left outer join organisationunit Sublocation
>>>   on (ous.idlevel6=sublocation.organisationunitid)
>>>left outer join (
>>>  * select sourceid, sum(cast(value as double precision)) as value*
>>>   from datavalue
>>>   where dataelementid=8305
>>>  group by sourceid) as triggerstate on
>>> triggerstate.sourceid=ou.organisationunitid
>>> where ous.level=7
>>>
>>> 
>>> ERROR:  invalid input syntax for type double precision: "false"
>>>
>>> ** Error **
>>>
>>> ERROR: invalid input syntax for type double precision: "false"
>>> SQL state: 22P02
>>>
>>> ==
>>> I want to just get the list of facilities trigger states Trues/False
>>> ---I dont need aggregated data because the other elements i would want to
>>> include are date, i have an element with option type (with text) also
>>> stored into value table. I need to retrieve that and create a report.
>>>
>>> I can't use the * select sourceid, sum(cast(value as double precision))
>>> as value --- *To get the raw data
>>>
>>> A good test is to use the Siera Leone demo and create a query to display
>>> the facility assessment raw data.
>>> 1) "General state of facility"
>>> 2) "Lighting and ventilation is observed to be adequate"
>>>
>>> Cheers
>>>
>>>
>>>
>>> On Fri, Nov 29, 2013 at 6:25 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> Hi Murod,
>>>> Just trying to keep it focused on the original topic, but it seems you
>>>> want to persist.

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

d ventilation is observed to be adequate"
>>
>> Cheers
>>
>>
>>
>> On Fri, Nov 29, 2013 at 6:25 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Murod,
>>> Just trying to keep it focused on the original topic, but it seems you
>>> want to persist.  The initial part of this post was about getting out text
>>> data (read the title).  In this case, there is no need for any casting or
>>> aggregation. Period.
>>>
>>> That regex  you post again unfortunately will also not work in many
>>> cases , especially if you have integers stored are decimals or negative
>>> integers which might be perfectly valid. Please refer to the source code
>>> for a more appropriate one. The data which I mention is not "dummy data".
>>>  We have lots of problems with this type of data here in Zambia as well as
>>> other countries, because most of our data is submitted through mobiles. The
>>> trunk mobile clients do not have any validation, so getting data like "09"
>>> and "9.0" for an integer is quite common.  We have added some regex
>>> validation to the J2ME client to try and prevent most of this junk for
>>> getting in, but with the new Light and Smartphone clients, it does not
>>> always work. Normally, we run other scripts to flag these values for
>>> "follow-up" automatically, to try and resolve what the number is, but it
>>> can take time.
>>>
>>>  In your case, you might think that this regex suits your needs, and
>>> would want to reject all decimals and negative numbers. That is up to you.
>>> But in our case, we attempt to salvage as much data as possible. Whether
>>> that is the right approach or not, well, maybe we can start a new thread
>>> for this.  :)
>>>
>>> Best regards,
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Nov 29, 2013 at 5:13 PM, Murod Latifov wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> I thought my points were of some help to solve the issue and discuss
>>>> those appearing from initial issue. What you thought about first call is
>>>> not right and what I proposed was a solution. After you added dummy data
>>>> being stored, where new topic was introduced (off initial topic). And now
>>>> you are saying this kind of bureaucratic on topic/off topic things.
>>>> With regards to regexp you are not bound with what I demonstrated, you
>>>> can with the same ease, please use " and dv.value~E'^[1-9][0-9]?$'" instead
>>>> if the case is so worth, no probs.
>>>>
>>>> best,
>>>> murod
>>>>
>>>>
>>>> On Fri, Nov 29, 2013 at 7:58 PM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> Hi Murod,
>>>>>
>>>>> I do not think anyone is happy about it, and thus my blueprint to
>>>>> provide server-side regex validation of data, which has yet to be
>>>>> implemented. However, the fact of the matter is, it can happen now, and
>>>>> having some data is usually better than having no data at all.  That regex
>>>>> which you mention there will also not work in all cases, because things
>>>>> like "00" are quite common and cannot be cast, thus the need for the
>>>>> "heavier" regex which is used by the analytics process. Such values would
>>>>> pass the regex because it is all digits, but will fail the cast.  You may
>>>>> not be happy about it, but it is usually necessary to be sure the values
>>>>> which should be numeric, can actually be cast to an integer.
>>>>>
>>>>> Again, seemingly off-topic from the original post?
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Fri, Nov 29, 2013 at 4:51 PM, Murod Latifov wrote:
>>>>>
>>>>>> Hi Jason,
>>>>>>
>>>>>> By telling these you mean data stored in DHIS2 at some
>>>>>> implementations is not trusted, that is not cleaned enough. How can one 
>>>>>> use
>>>>>> these data for analysis? Does it bring TRUE result for decision making? I
>>>>>> don't think such data should exist. 

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Felix,

I do not understand for large on what you mean with "raw data" but can say
if you are not looking for aggregated data for the sake of SQL
requirements, just use count(1 as nothing) or count(value as value)
avoiding type cast issues.

best,
murod


On Fri, Nov 29, 2013 at 9:19 PM, Felix Obareh wrote:

> Thank you people for you input..
>
> If i can clarify that the query is to pick raw data that otherwise is
> recorded but we cannot retrieve because its not aggregated. This data would
> include the following
> Here is my full query:-
>
> select county.name as county,subcounty.name as subcounty,division.name as
> division,
> sublocation.name as sublocation, ou.name as facility,triggerstate.value
> as triggerstate
> from organisationunit ou
> left outer join _orgunitstructure ous
>   on (ou.organisationunitid=ous.organisationunitid)
>   left outer join organisationunit county
>   on (ous.idlevel2=county.organisationunitid)
>   left outer join organisationunit subcounty
>   on (ous.idlevel3=subcounty.organisationunitid)
>   left outer join organisationunit division
>   on (ous.idlevel4= division.organisationunitid)
> left outer join organisationunit location
>   on (ous.idlevel5=location.organisationunitid)
> left outer join organisationunit Sublocation
>   on (ous.idlevel6=sublocation.organisationunitid)
>left outer join (
>  * select sourceid, sum(cast(value as double precision)) as value*
>   from datavalue
>   where dataelementid=8305
>  group by sourceid) as triggerstate on
> triggerstate.sourceid=ou.organisationunitid
> where ous.level=7
>
> 
> ERROR:  invalid input syntax for type double precision: "false"
>
> ** Error **
>
> ERROR: invalid input syntax for type double precision: "false"
> SQL state: 22P02
>
> ==
> I want to just get the list of facilities trigger states Trues/False ---I
> dont need aggregated data because the other elements i would want to
> include are date, i have an element with option type (with text) also
> stored into value table. I need to retrieve that and create a report.
>
> I can't use the * select sourceid, sum(cast(value as double precision))
> as value --- *To get the raw data
>
> A good test is to use the Siera Leone demo and create a query to display
> the facility assessment raw data.
> 1) "General state of facility"
> 2) "Lighting and ventilation is observed to be adequate"
>
> Cheers
>
>
>
> On Fri, Nov 29, 2013 at 6:25 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Murod,
>> Just trying to keep it focused on the original topic, but it seems you
>> want to persist.  The initial part of this post was about getting out text
>> data (read the title).  In this case, there is no need for any casting or
>> aggregation. Period.
>>
>> That regex  you post again unfortunately will also not work in many cases
>> , especially if you have integers stored are decimals or negative integers
>> which might be perfectly valid. Please refer to the source code for a more
>> appropriate one. The data which I mention is not "dummy data".  We have
>> lots of problems with this type of data here in Zambia as well as other
>> countries, because most of our data is submitted through mobiles. The trunk
>> mobile clients do not have any validation, so getting data like "09" and
>> "9.0" for an integer is quite common.  We have added some regex validation
>> to the J2ME client to try and prevent most of this junk for getting in, but
>> with the new Light and Smartphone clients, it does not always work.
>> Normally, we run other scripts to flag these values for "follow-up"
>> automatically, to try and resolve what the number is, but it can take time.
>>
>>  In your case, you might think that this regex suits your needs, and
>> would want to reject all decimals and negative numbers. That is up to you.
>> But in our case, we attempt to salvage as much data as possible. Whether
>> that is the right approach or not, well, maybe we can start a new thread
>> for this.  :)
>>
>> Best regards,
>> Jason
>>
>>
>>
>>
>>
>>
>> On Fri, Nov 29, 2013 at 5:13 PM, Murod Latifov wrote:
>>
>>> Hi Jason,
>>>
>>> I thought my points were of some help to solve the issue and discuss
>>> those appearing from initial issue. What you thought about first call is
>>> not right and what I proposed was a solution. After you added dummy data
>>> being stored, where new topic was introduced (off initial topic). And now
>

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Jason,

No need for the new thread. We do not have such data stored and we do not
use smartphones for unclean data collection. The regexp I presented is just
a hint on how to deal with such abnormal cases. You can tune it to what you
need, thats why regexp are there:)
What I initially said was within the frame of my understanding of how data
should be stored in DHIS, not something that you late explained. We do not
use regexp for such issues, because we simply do not have these issues.
We have issues with reporting aggregated data and data in general. For
which are building solutions. We have kind of "noSQL" reporting based on
atomicity concepts and in the same line we are developing aggregation
engine.
A small things we wanted to bring some changes was to persist org unit
level, that didn't create much discussion, maybe I am always off topic?

best,
murod


On Fri, Nov 29, 2013 at 8:25 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Murod,
> Just trying to keep it focused on the original topic, but it seems you
> want to persist.  The initial part of this post was about getting out text
> data (read the title).  In this case, there is no need for any casting or
> aggregation. Period.
>
> That regex  you post again unfortunately will also not work in many cases
> , especially if you have integers stored are decimals or negative integers
> which might be perfectly valid. Please refer to the source code for a more
> appropriate one. The data which I mention is not "dummy data".  We have
> lots of problems with this type of data here in Zambia as well as other
> countries, because most of our data is submitted through mobiles. The trunk
> mobile clients do not have any validation, so getting data like "09" and
> "9.0" for an integer is quite common.  We have added some regex validation
> to the J2ME client to try and prevent most of this junk for getting in, but
> with the new Light and Smartphone clients, it does not always work.
> Normally, we run other scripts to flag these values for "follow-up"
> automatically, to try and resolve what the number is, but it can take time.
>
>  In your case, you might think that this regex suits your needs, and would
> want to reject all decimals and negative numbers. That is up to you. But in
> our case, we attempt to salvage as much data as possible. Whether that is
> the right approach or not, well, maybe we can start a new thread for this.
>  :)
>
> Best regards,
> Jason
>
>
>
>
>
>
> On Fri, Nov 29, 2013 at 5:13 PM, Murod Latifov  wrote:
>
>> Hi Jason,
>>
>> I thought my points were of some help to solve the issue and discuss
>> those appearing from initial issue. What you thought about first call is
>> not right and what I proposed was a solution. After you added dummy data
>> being stored, where new topic was introduced (off initial topic). And now
>> you are saying this kind of bureaucratic on topic/off topic things.
>> With regards to regexp you are not bound with what I demonstrated, you
>> can with the same ease, please use " and dv.value~E'^[1-9][0-9]?$'" instead
>> if the case is so worth, no probs.
>>
>> best,
>> murod
>>
>>
>> On Fri, Nov 29, 2013 at 7:58 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Murod,
>>>
>>> I do not think anyone is happy about it, and thus my blueprint to
>>> provide server-side regex validation of data, which has yet to be
>>> implemented. However, the fact of the matter is, it can happen now, and
>>> having some data is usually better than having no data at all.  That regex
>>> which you mention there will also not work in all cases, because things
>>> like "00" are quite common and cannot be cast, thus the need for the
>>> "heavier" regex which is used by the analytics process. Such values would
>>> pass the regex because it is all digits, but will fail the cast.  You may
>>> not be happy about it, but it is usually necessary to be sure the values
>>> which should be numeric, can actually be cast to an integer.
>>>
>>> Again, seemingly off-topic from the original post?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Nov 29, 2013 at 4:51 PM, Murod Latifov wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> By telling these you mean data stored in DHIS2 at some implementations
>>>> is not trusted, that is not cleaned enough. How can one use these data for
>>>> analysis? Does it bring TRUE result for decision 

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Jason,

I thought my points were of some help to solve the issue and discuss those
appearing from initial issue. What you thought about first call is not
right and what I proposed was a solution. After you added dummy data being
stored, where new topic was introduced (off initial topic). And now you are
saying this kind of bureaucratic on topic/off topic things.
With regards to regexp you are not bound with what I demonstrated, you can
with the same ease, please use " and dv.value~E'^[1-9][0-9]?$'" instead if
the case is so worth, no probs.

best,
murod


On Fri, Nov 29, 2013 at 7:58 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Murod,
>
> I do not think anyone is happy about it, and thus my blueprint to provide
> server-side regex validation of data, which has yet to be implemented.
> However, the fact of the matter is, it can happen now, and having some data
> is usually better than having no data at all.  That regex which you mention
> there will also not work in all cases, because things like "00" are quite
> common and cannot be cast, thus the need for the "heavier" regex which is
> used by the analytics process. Such values would pass the regex because it
> is all digits, but will fail the cast.  You may not be happy about it, but
> it is usually necessary to be sure the values which should be numeric, can
> actually be cast to an integer.
>
> Again, seemingly off-topic from the original post?
>
> Regards,
> Jason
>
>
>
>
>
> On Fri, Nov 29, 2013 at 4:51 PM, Murod Latifov  wrote:
>
>> Hi Jason,
>>
>> By telling these you mean data stored in DHIS2 at some implementations is
>> not trusted, that is not cleaned enough. How can one use these data for
>> analysis? Does it bring TRUE result for decision making? I don't think such
>> data should exist. At least some Data management action could clean data
>> against data element declarations and value stored. After, there shouldn't
>> be such worries.
>> You can use regexp within SQL command to:
>> select dv.dataelementid, categoryoptioncomboid, periodid, sum(cast (value
>> as int)) as val, dv.sourceid as orgunit, aggregationtype from datavalue dv
>>  left join dataelement de
>> on dv.dataelementid = de.dataelementid
>> WHERE aggregationtype = 'sum' and domaintype='aggregate' and
>> dv.value~E'^\\d+$'
>> group by dv.dataelementid, dv.sourceid, categoryoptioncomboid, periodid,
>> aggregationtype
>>
>> Please note this addition  and dv.value~E'^\\d+$', which makes SQL run
>> failure safe.
>> But in overall am not happy with such data being stored without cleansing
>> after import.
>>
>> best,
>> murod
>>
>>
>> On Fri, Nov 29, 2013 at 7:10 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Murod,
>>> You would think this would work, and it might for you. The problem is
>>> there is no way to "trust" that the raw data values can be cast. We have
>>> had a lot of problems with this, but mostly because of 1) Legacy data
>>> before the different value types were implemented and 2) data which is
>>> received from mobile clients, which do not have the same restrictions as
>>> from the front-end. So, by relying on the aggregationtype, you must really
>>> know your data is clean, otherwise, it only takes one bad value for the
>>> aggregation with SQL not to work. You can see the way the analytics gets
>>> around this, by applying a regex. Whether it is "heavy" or not, I guess
>>> really depends on your reference frame.
>>>
>>> However, getting back to the top of the thread, I thought Felix's
>>> original issue was not being able to data which was stored as a date or
>>> text. My original point was that the casting and summing of this type of
>>> data is simply not possible with these simple SQL statements. But maybe I
>>> misunderstood Felx's original issue.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> On Fri, Nov 29, 2013 at 3:15 PM, Murod Latifov wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> Yes, it holds true in case if raw data being called. But query was with
>>>> aggregation elements. Technique I proposed will exactly remove none
>>>> convertible values from the query, thus there won't be cast exception. No
>>>> need to deploy heavy regex or stored procedure here, this is doable. Sample
>>>> code here:
>>>>
>>>> select dv.

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Jason,

By telling these you mean data stored in DHIS2 at some implementations is
not trusted, that is not cleaned enough. How can one use these data for
analysis? Does it bring TRUE result for decision making? I don't think such
data should exist. At least some Data management action could clean data
against data element declarations and value stored. After, there shouldn't
be such worries.
You can use regexp within SQL command to:
select dv.dataelementid, categoryoptioncomboid, periodid, sum(cast (value
as int)) as val, dv.sourceid as orgunit, aggregationtype from datavalue dv
left join dataelement de
on dv.dataelementid = de.dataelementid
WHERE aggregationtype = 'sum' and domaintype='aggregate' and
dv.value~E'^\\d+$'
group by dv.dataelementid, dv.sourceid, categoryoptioncomboid, periodid,
aggregationtype

Please note this addition  and dv.value~E'^\\d+$', which makes SQL run
failure safe.
But in overall am not happy with such data being stored without cleansing
after import.

best,
murod


On Fri, Nov 29, 2013 at 7:10 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Murod,
> You would think this would work, and it might for you. The problem is
> there is no way to "trust" that the raw data values can be cast. We have
> had a lot of problems with this, but mostly because of 1) Legacy data
> before the different value types were implemented and 2) data which is
> received from mobile clients, which do not have the same restrictions as
> from the front-end. So, by relying on the aggregationtype, you must really
> know your data is clean, otherwise, it only takes one bad value for the
> aggregation with SQL not to work. You can see the way the analytics gets
> around this, by applying a regex. Whether it is "heavy" or not, I guess
> really depends on your reference frame.
>
> However, getting back to the top of the thread, I thought Felix's original
> issue was not being able to data which was stored as a date or text. My
> original point was that the casting and summing of this type of data is
> simply not possible with these simple SQL statements. But maybe I
> misunderstood Felx's original issue.
>
> Regards,
> Jason
>
>
>
> On Fri, Nov 29, 2013 at 3:15 PM, Murod Latifov  wrote:
>
>> Hi Jason,
>>
>> Yes, it holds true in case if raw data being called. But query was with
>> aggregation elements. Technique I proposed will exactly remove none
>> convertible values from the query, thus there won't be cast exception. No
>> need to deploy heavy regex or stored procedure here, this is doable. Sample
>> code here:
>>
>> select dv.dataelementid, categoryoptioncomboid, periodid, sum(cast (value
>> as int)) as val, dv.sourceid as orgunit, aggregationtype from datavalue dv
>> left join dataelement de
>> on dv.dataelementid = de.dataelementid
>> WHERE aggregationtype = 'sum' and domaintype='aggregate'
>> group by dv.dataelementid, dv.sourceid, categoryoptioncomboid, periodid,
>> aggregationtype
>>
>> This should give an idea on how to manage avoiding these exceptions just
>> with plain SQL.
>>
>> regards,
>> murod
>>
>>
>> On Fri, Nov 29, 2013 at 5:46 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Well, it is very hard to see what is going on without the entire query.
>>> My point here is there is no way to aggregate text, without some sort of
>>> procedure, so you cannot cast anything, nor can you sum it, because in the
>>> datavalue table, everything is stored as text. Just like with the
>>> analytics, you must first filter out all values which you think can be cast
>>> to a double with a regex, and then perform the sum/average/other
>>> aggregation operator.  If you just want to get the raw data values back,
>>> then there should be no aggregation anyway, thus, no need for the sum
>>> operator.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Nov 29, 2013 at 2:39 PM, Murod Latifov wrote:
>>>
>>>> I am afraid Jason, it won't work that way. In Postgres aggregating
>>>> (SUM, AVG) for varchar will give exception. There is no onbuilt type
>>>> casting at this point.
>>>>
>>>>
>>>> On Fri, Nov 29, 2013 at 5:09 PM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> You cannot cast text to a double so just remove that cast operator and
>>>>> you should be fine.
>>>>>
>>>>> --Sent 

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Jason,

Yes, it holds true in case if raw data being called. But query was with
aggregation elements. Technique I proposed will exactly remove none
convertible values from the query, thus there won't be cast exception. No
need to deploy heavy regex or stored procedure here, this is doable. Sample
code here:

select dv.dataelementid, categoryoptioncomboid, periodid, sum(cast (value
as int)) as val, dv.sourceid as orgunit, aggregationtype from datavalue dv
left join dataelement de
on dv.dataelementid = de.dataelementid
WHERE aggregationtype = 'sum' and domaintype='aggregate'
group by dv.dataelementid, dv.sourceid, categoryoptioncomboid, periodid,
aggregationtype

This should give an idea on how to manage avoiding these exceptions just
with plain SQL.

regards,
murod


On Fri, Nov 29, 2013 at 5:46 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Well, it is very hard to see what is going on without the entire query. My
> point here is there is no way to aggregate text, without some sort of
> procedure, so you cannot cast anything, nor can you sum it, because in the
> datavalue table, everything is stored as text. Just like with the
> analytics, you must first filter out all values which you think can be cast
> to a double with a regex, and then perform the sum/average/other
> aggregation operator.  If you just want to get the raw data values back,
> then there should be no aggregation anyway, thus, no need for the sum
> operator.
>
> Regards,
> Jason
>
>
>
>
>
> On Fri, Nov 29, 2013 at 2:39 PM, Murod Latifov  wrote:
>
>> I am afraid Jason, it won't work that way. In Postgres aggregating (SUM,
>> AVG) for varchar will give exception. There is no onbuilt type casting at
>> this point.
>>
>>
>> On Fri, Nov 29, 2013 at 5:09 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> You cannot cast text to a double so just remove that cast operator and
>>> you should be fine.
>>>
>>> --Sent from my mobile
>>> On Nov 29, 2013 1:16 PM, "Felix Obareh"  wrote:
>>>
>>>> Thank Jason,
>>>> I have decided to go with the SQL Query. I am using the SQL Query
>>>> example i the user manual together with the demo database for Sierra Leone.
>>>>
>>>> It is working fine for elements of integer type and i can run the query
>>>> from my pgAdmin and i get them fine. I have a problem with displaying data
>>>> elements of text and varchar type.
>>>>
>>>> Here is what am running as querry:-
>>>>
>>>> --Trancated
>>>>
>>>> left outer join organisationunit Sublocation
>>>>   on (ous.idlevel6=sublocation.organisationunitid)
>>>> left outer join (
>>>>   *select sourceid, sum(cast(value as double precision)) as value*
>>>>   from datavalue
>>>>   where dataelementid=8305
>>>>
>>>>  group by sourceid) as *triggerstate* on
>>>> triggerstate.sourceid=ou.organisationunitid
>>>> where ous.level=7
>>>>
>>>> If i run the same query for a data element of date of text type or
>>>> yes/no
>>>> ***NB the triggerstate store a true or false value in the the datavalue
>>>> table
>>>>
>>>> *HERE is the SQL error i get*
>>>>
>>>> ERROR:  invalid input syntax for type double precision: "false"
>>>>
>>>> ** Error **
>>>>
>>>> ERROR: invalid input syntax for type double precision: "false"
>>>> SQL state: 22P02
>>>>
>>>>
>>>> --
>>>> Please assist
>>>>
>>>>
>>>> On Wed, Nov 27, 2013 at 5:44 PM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> Hi Obare,
>>>>> The reason for this is because you will only be able to see the
>>>>> aggregated data in DHIS2. In your case, it does not seem you need the
>>>>> aggregated data, but instead the raw data. One way to do this is with a
>>>>> custom report, which would use a JDBC data source, and then an SQL query 
>>>>> to
>>>>> retreive the data. You might need some paramaters like the period and the
>>>>> particular orgunit. You can read about custom reports in the DHIS2
>>>>> documentation. Another possible solution would be an SQL Query, which 
>>>>> would
>>>>> allow you to pull out t

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

I am afraid Jason, it won't work that way. In Postgres aggregating (SUM,
AVG) for varchar will give exception. There is no onbuilt type casting at
this point.


On Fri, Nov 29, 2013 at 5:09 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> You cannot cast text to a double so just remove that cast operator and you
> should be fine.
>
> --Sent from my mobile
> On Nov 29, 2013 1:16 PM, "Felix Obareh"  wrote:
>
>> Thank Jason,
>> I have decided to go with the SQL Query. I am using the SQL Query example
>> i the user manual together with the demo database for Sierra Leone.
>>
>> It is working fine for elements of integer type and i can run the query
>> from my pgAdmin and i get them fine. I have a problem with displaying data
>> elements of text and varchar type.
>>
>> Here is what am running as querry:-
>>
>> --Trancated
>>
>> left outer join organisationunit Sublocation
>>   on (ous.idlevel6=sublocation.organisationunitid)
>> left outer join (
>>   *select sourceid, sum(cast(value as double precision)) as value*
>>   from datavalue
>>   where dataelementid=8305
>>
>>  group by sourceid) as *triggerstate* on
>> triggerstate.sourceid=ou.organisationunitid
>> where ous.level=7
>>
>> If i run the same query for a data element of date of text type or
>> yes/no
>> ***NB the triggerstate store a true or false value in the the datavalue
>> table
>>
>> *HERE is the SQL error i get*
>>
>> ERROR:  invalid input syntax for type double precision: "false"
>>
>> ** Error **
>>
>> ERROR: invalid input syntax for type double precision: "false"
>> SQL state: 22P02
>>
>>
>> --
>> Please assist
>>
>>
>> On Wed, Nov 27, 2013 at 5:44 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Obare,
>>> The reason for this is because you will only be able to see the
>>> aggregated data in DHIS2. In your case, it does not seem you need the
>>> aggregated data, but instead the raw data. One way to do this is with a
>>> custom report, which would use a JDBC data source, and then an SQL query to
>>> retreive the data. You might need some paramaters like the period and the
>>> particular orgunit. You can read about custom reports in the DHIS2
>>> documentation. Another possible solution would be an SQL Query, which would
>>> allow you to pull out the raw data into a CSV file for subsequent analysis.
>>>
>>> Hope this helps.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> On Wed, Nov 27, 2013 at 2:34 PM, Felix Obareh wrote:
>>>
 Hi,

 I a form similar to the Facility Assessment Form in the demo.dhis2.org. I 
 have done some data entry but i don't know how to get the report for
 that form

 Among my Elements are:-

 1) Date Facility was commissioned
 2) Facility state on Commissioning with options set of ( Ready, Lacking
 Some Departments, Not ready)
 3) Date of Certification
 4) Date of Verification
 5) Source of Funds with option sets (Government, Donor)
 6) Is facility well maintained (Yes/No)
 7) Key issues identified & suggested solutions (Text)
 8) Number of Practitioners in the Facility

 I can the above data on the entry form by i cant create a single report
 about the facility. The pivot tables on show the value of element 8. The
 value of the number of practitioners.

 Any assistance will be highly appreciated. I have three more Facility
 based forms which i want to get reports for across the country

 Cheers



 --

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


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

Re: [Dhis2-users] Retrieving Data of type value:- Date , text and Yes or No in DHIS2

[Murod Latifov]

Hi Obare,

You also need to join dataelement table and add the followoing in your
WHERE clause:
domaintype='aggregate' and aggregationtype= bla bla to reduce in away that
non numeric values do not get into query. Hope this helps.

best,
murod



On Fri, Nov 29, 2013 at 4:16 PM, Felix Obareh wrote:

> Thank Jason,
> I have decided to go with the SQL Query. I am using the SQL Query example
> i the user manual together with the demo database for Sierra Leone.
>
> It is working fine for elements of integer type and i can run the query
> from my pgAdmin and i get them fine. I have a problem with displaying data
> elements of text and varchar type.
>
> Here is what am running as querry:-
>
> --Trancated
>
> left outer join organisationunit Sublocation
>   on (ous.idlevel6=sublocation.organisationunitid)
> left outer join (
>   *select sourceid, sum(cast(value as double precision)) as value*
>   from datavalue
>   where dataelementid=8305
>
>  group by sourceid) as *triggerstate* on
> triggerstate.sourceid=ou.organisationunitid
> where ous.level=7
>
> If i run the same query for a data element of date of text type or
> yes/no
> ***NB the triggerstate store a true or false value in the the datavalue
> table
>
> *HERE is the SQL error i get*
>
> ERROR:  invalid input syntax for type double precision: "false"
>
> ** Error **
>
> ERROR: invalid input syntax for type double precision: "false"
> SQL state: 22P02
>
>
> --
> Please assist
>
>
> On Wed, Nov 27, 2013 at 5:44 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Obare,
>> The reason for this is because you will only be able to see the
>> aggregated data in DHIS2. In your case, it does not seem you need the
>> aggregated data, but instead the raw data. One way to do this is with a
>> custom report, which would use a JDBC data source, and then an SQL query to
>> retreive the data. You might need some paramaters like the period and the
>> particular orgunit. You can read about custom reports in the DHIS2
>> documentation. Another possible solution would be an SQL Query, which would
>> allow you to pull out the raw data into a CSV file for subsequent analysis.
>>
>> Hope this helps.
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Wed, Nov 27, 2013 at 2:34 PM, Felix Obareh wrote:
>>
>>> Hi,
>>>
>>> I a form similar to the Facility Assessment Form in the demo.dhis2.org. I 
>>> have done some data entry but i don't know how to get the report for
>>> that form
>>>
>>> Among my Elements are:-
>>>
>>> 1) Date Facility was commissioned
>>> 2) Facility state on Commissioning with options set of ( Ready, Lacking
>>> Some Departments, Not ready)
>>> 3) Date of Certification
>>> 4) Date of Verification
>>> 5) Source of Funds with option sets (Government, Donor)
>>> 6) Is facility well maintained (Yes/No)
>>> 7) Key issues identified & suggested solutions (Text)
>>> 8) Number of Practitioners in the Facility
>>>
>>> I can the above data on the entry form by i cant create a single report
>>> about the facility. The pivot tables on show the value of element 8. The
>>> value of the number of practitioners.
>>>
>>> Any assistance will be highly appreciated. I have three more Facility
>>> based forms which i want to get reports for across the country
>>>
>>> Cheers
>>>
>>>
>>>
>>> --
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] ireport deprecated

[Murod Latifov]

Hi Bob,

There is atomicity at play. We are not using analytics API no jdbc, only
simple calls to an existing DHIS2 services (not analytics). Interesting
part is that query parameters are stored within office documents, making
report designer free of creating separate query string or table to fill in
the report. In other words what you see is what you get (WYSIWYG). I hope
this clarifies your questions.

With regards to sharing, it is teamwork and I do not have freedom to do
anything I want. Moreover it is work in progress. Thus it comes with some
obligations and expectations as such, sorry for this.

regards,
murod



On Thu, Nov 7, 2013 at 12:42 PM, Bob Jolliffe  wrote:

> Hi Murod
>
> That does sound interesting.  So you are manipulating the odf xml somehow.
>  But in the end it is linked to what? A jdbc link to a database view?  Or
> are you getting data with the analytics api?
>
> My earlier look at openoffice calc showed that it was not so good at
> manipulating very large amounts of data - like for example the way we used
> excel for pivot tables.  So you have to do this processing elsewhere.  This
> is why I wonder whether you make use of analytics in dhis.
>
> Shame you can't share more.
>
> Bob
>
>
> On 7 November 2013 05:44, Murod Latifov  wrote:
>
>> Hi Samta,
>>
>> No, we are not using any libreoffice applications in thiis sense. This
>> means no need to have libreoffice installed to manipulate documents. No any
>> heavy web application like jasper server ore the like. Libreoffice is used
>> to design the template. Simply reading and writing XML files inside this
>> docs.
>>
>> regards,
>> murod
>>
>>
>> On Thu, Nov 7, 2013 at 10:07 AM, Samta  wrote:
>>
>>> Hi Murod,
>>>
>>> Are you using libreoffice java application for generating template
>>> without using any tool like: iReport or jasper studio ?
>>>
>>>
>>> On Thu, Nov 7, 2013 at 9:01 AM, Murod Latifov wrote:
>>>
>>>> Hi Knut,
>>>>
>>>> Yes, we are using libreoffice applications for report templates as was
>>>> in excel reporting module of DHIS2, but in a different way that allows
>>>> reports of any complexity to be generated.
>>>> Unfortunately I cannot share the module at this time.
>>>>
>>>> regards,
>>>> murod
>>>>
>>>>
>>>>
>>>> On Thu, Nov 7, 2013 at 12:42 AM, Knut Staring  wrote:
>>>>
>>>>> That's interesting, Murod. Are you saying you are linking in Word or
>>>>> Excel? Could you explain a bit more? Anything you can share?
>>>>> Knut
>>>>> 6. nov. 2013 16:31 skrev "Murod Latifov" 
>>>>> følgende:
>>>>>
>>>>> Hi all,
>>>>>> I think there should be other options than Jasper Reports.
>>>>>> We are developing a reporting module to eliminate "end user - DHIS2
>>>>>> healthcare user", "report designer - I(Jasper)report master", "query
>>>>>> builder - SQL or DBMS" into a single source. So far we did lots of 
>>>>>> progress
>>>>>> producing reports in many famous formats without attention from above
>>>>>> three. This means anybody designing report can produce it without the
>>>>>> knowledge of "three above" just by knowing elementary office apps. We are
>>>>>> stepping into more advanced development to reduce calculation times,
>>>>>> scheduling, etc.
>>>>>> Best regards,
>>>>>> murod
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Nov 6, 2013 at 1:12 PM, Knut Staring wrote:
>>>>>>
>>>>>>> Hi Samta,
>>>>>>>
>>>>>>> I think it is quite new to all of us - would be great if you could
>>>>>>> try it out and report back to the DHIS community about your experiences.
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Knut
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Nov 6, 2013 at 9:00 AM, Samta wrote:
>>>>>>>
>>>>>>>> What are new feature in jasper studio? I was searched on this
>>>>>>>> jasper studio it is same as iReport for designing. Is it possible to
>>>>>>>> use/create multiple query or table without using sub report in

Re: [Dhis2-users] [Dhis2-devs] ireport deprecated

[Murod Latifov]

Hi Samta,

No, we are not using any libreoffice applications in thiis sense. This
means no need to have libreoffice installed to manipulate documents. No any
heavy web application like jasper server ore the like. Libreoffice is used
to design the template. Simply reading and writing XML files inside this
docs.

regards,
murod


On Thu, Nov 7, 2013 at 10:07 AM, Samta  wrote:

> Hi Murod,
>
> Are you using libreoffice java application for generating template
> without using any tool like: iReport or jasper studio ?
>
>
> On Thu, Nov 7, 2013 at 9:01 AM, Murod Latifov  wrote:
>
>> Hi Knut,
>>
>> Yes, we are using libreoffice applications for report templates as was in
>> excel reporting module of DHIS2, but in a different way that allows reports
>> of any complexity to be generated.
>> Unfortunately I cannot share the module at this time.
>>
>> regards,
>> murod
>>
>>
>>
>> On Thu, Nov 7, 2013 at 12:42 AM, Knut Staring  wrote:
>>
>>> That's interesting, Murod. Are you saying you are linking in Word or
>>> Excel? Could you explain a bit more? Anything you can share?
>>> Knut
>>> 6. nov. 2013 16:31 skrev "Murod Latifov"  følgende:
>>>
>>> Hi all,
>>>> I think there should be other options than Jasper Reports.
>>>> We are developing a reporting module to eliminate "end user - DHIS2
>>>> healthcare user", "report designer - I(Jasper)report master", "query
>>>> builder - SQL or DBMS" into a single source. So far we did lots of progress
>>>> producing reports in many famous formats without attention from above
>>>> three. This means anybody designing report can produce it without the
>>>> knowledge of "three above" just by knowing elementary office apps. We are
>>>> stepping into more advanced development to reduce calculation times,
>>>> scheduling, etc.
>>>> Best regards,
>>>> murod
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, Nov 6, 2013 at 1:12 PM, Knut Staring  wrote:
>>>>
>>>>> Hi Samta,
>>>>>
>>>>> I think it is quite new to all of us - would be great if you could try
>>>>> it out and report back to the DHIS community about your experiences.
>>>>>
>>>>> Thanks,
>>>>> Knut
>>>>>
>>>>>
>>>>> On Wed, Nov 6, 2013 at 9:00 AM, Samta wrote:
>>>>>
>>>>>> What are new feature in jasper studio? I was searched on this jasper
>>>>>> studio it is same as iReport for designing. Is it possible to use/create
>>>>>> multiple query or table without using sub report in this jasper studio?
>>>>>>
>>>>>>
>>>>>> On Wed, Nov 6, 2013 at 1:23 PM, Lars Helge Øverland <
>>>>>> larshe...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Randy,
>>>>>>>
>>>>>>> yes the jrxml format is the same. Jasper studio is just another
>>>>>>> design tool for the format. Also, there is nothing stopping you from 
>>>>>>> using
>>>>>>> iReport even though they will not put more features into it.
>>>>>>>
>>>>>>> Lars
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Nov 6, 2013 at 7:42 AM, Wilson,Randy wrote:
>>>>>>>
>>>>>>>>  Hi Lars,
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Does Jaspersoft Studio produce the .jrxml files that can be
>>>>>>>> incorporated into DHIS-2 or do you have to do some work on your end 
>>>>>>>> before
>>>>>>>> we can use it?  I’m organizing an advanced training in iReport for 
>>>>>>>> Rwanda
>>>>>>>> data managers and need to know if I can switch to Studio before the
>>>>>>>> training.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Randy
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> *From:* Dhis2-users [mailto:dh

Re: [Dhis2-users] [Dhis2-devs] ireport deprecated

[Murod Latifov]

Hi Knut,

Yes, we are using libreoffice applications for report templates as was in
excel reporting module of DHIS2, but in a different way that allows reports
of any complexity to be generated.
Unfortunately I cannot share the module at this time.

regards,
murod



On Thu, Nov 7, 2013 at 12:42 AM, Knut Staring  wrote:

> That's interesting, Murod. Are you saying you are linking in Word or
> Excel? Could you explain a bit more? Anything you can share?
> Knut
> 6. nov. 2013 16:31 skrev "Murod Latifov"  følgende:
>
> Hi all,
>> I think there should be other options than Jasper Reports.
>> We are developing a reporting module to eliminate "end user - DHIS2
>> healthcare user", "report designer - I(Jasper)report master", "query
>> builder - SQL or DBMS" into a single source. So far we did lots of progress
>> producing reports in many famous formats without attention from above
>> three. This means anybody designing report can produce it without the
>> knowledge of "three above" just by knowing elementary office apps. We are
>> stepping into more advanced development to reduce calculation times,
>> scheduling, etc.
>> Best regards,
>> murod
>>
>>
>>
>>
>> On Wed, Nov 6, 2013 at 1:12 PM, Knut Staring  wrote:
>>
>>> Hi Samta,
>>>
>>> I think it is quite new to all of us - would be great if you could try
>>> it out and report back to the DHIS community about your experiences.
>>>
>>> Thanks,
>>> Knut
>>>
>>>
>>> On Wed, Nov 6, 2013 at 9:00 AM, Samta  wrote:
>>>
>>>> What are new feature in jasper studio? I was searched on this jasper
>>>> studio it is same as iReport for designing. Is it possible to use/create
>>>> multiple query or table without using sub report in this jasper studio?
>>>>
>>>>
>>>> On Wed, Nov 6, 2013 at 1:23 PM, Lars Helge Øverland <
>>>> larshe...@gmail.com> wrote:
>>>>
>>>>> Hi Randy,
>>>>>
>>>>> yes the jrxml format is the same. Jasper studio is just another design
>>>>> tool for the format. Also, there is nothing stopping you from using 
>>>>> iReport
>>>>> even though they will not put more features into it.
>>>>>
>>>>> Lars
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Nov 6, 2013 at 7:42 AM, Wilson,Randy  wrote:
>>>>>
>>>>>>  Hi Lars,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Does Jaspersoft Studio produce the .jrxml files that can be
>>>>>> incorporated into DHIS-2 or do you have to do some work on your end 
>>>>>> before
>>>>>> we can use it?  I’m organizing an advanced training in iReport for Rwanda
>>>>>> data managers and need to know if I can switch to Studio before the
>>>>>> training.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Randy
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+rwilson=
>>>>>> msh@lists.launchpad.net] *On Behalf Of *Lars Helge Øverland
>>>>>> *Sent:* Wednesday, November 06, 2013 12:39 AM
>>>>>> *To:* DHIS 2 Users list; DHIS 2 Developers list
>>>>>> *Subject:* [Dhis2-users] ireport deprecated
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>>
>>>>>>
>>>>>> it seems iReport is deprecated and that jaspersoft now focuses on
>>>>>> jasper studio, an eclipse-based report designer for jasper reports.
>>>>>>
>>>>>>
>>>>>>
>>>>>> http://community.jaspersoft.com/project/ireport-designer
>>>>>>
>>>>>>
>>>>>>
>>>>>> Lars
>>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Thanks & Regards,
>>>>
>>>> Samta
>>>>
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-d...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> +4791880522
>>> http://dhis2.org
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] ireport deprecated

[Murod Latifov]

Hi all,
I think there should be other options than Jasper Reports.
We are developing a reporting module to eliminate "end user - DHIS2
healthcare user", "report designer - I(Jasper)report master", "query
builder - SQL or DBMS" into a single source. So far we did lots of progress
producing reports in many famous formats without attention from above
three. This means anybody designing report can produce it without the
knowledge of "three above" just by knowing elementary office apps. We are
stepping into more advanced development to reduce calculation times,
scheduling, etc.
Best regards,
murod




On Wed, Nov 6, 2013 at 1:12 PM, Knut Staring  wrote:

> Hi Samta,
>
> I think it is quite new to all of us - would be great if you could try it
> out and report back to the DHIS community about your experiences.
>
> Thanks,
> Knut
>
>
> On Wed, Nov 6, 2013 at 9:00 AM, Samta  wrote:
>
>> What are new feature in jasper studio? I was searched on this jasper
>> studio it is same as iReport for designing. Is it possible to use/create
>> multiple query or table without using sub report in this jasper studio?
>>
>>
>> On Wed, Nov 6, 2013 at 1:23 PM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Randy,
>>>
>>> yes the jrxml format is the same. Jasper studio is just another design
>>> tool for the format. Also, there is nothing stopping you from using iReport
>>> even though they will not put more features into it.
>>>
>>> Lars
>>>
>>>
>>>
>>> On Wed, Nov 6, 2013 at 7:42 AM, Wilson,Randy  wrote:
>>>
  Hi Lars,



 Does Jaspersoft Studio produce the .jrxml files that can be
 incorporated into DHIS-2 or do you have to do some work on your end before
 we can use it?  I’m organizing an advanced training in iReport for Rwanda
 data managers and need to know if I can switch to Studio before the
 training.



 Thanks,



 Randy



 *From:* Dhis2-users [mailto:dhis2-users-bounces+rwilson=
 msh@lists.launchpad.net] *On Behalf Of *Lars Helge Øverland
 *Sent:* Wednesday, November 06, 2013 12:39 AM
 *To:* DHIS 2 Users list; DHIS 2 Developers list
 *Subject:* [Dhis2-users] ireport deprecated



 Hi,



 it seems iReport is deprecated and that jaspersoft now focuses on
 jasper studio, an eclipse-based report designer for jasper reports.



 http://community.jaspersoft.com/project/ireport-designer



 Lars

>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>>
>> Thanks & Regards,
>>
>> Samta
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS zeros and saving data?

[Murod Latifov]

I meant if there is 0 value indicator at some orgunit, its absence may
affect value of indicator for "all orgunits" in that hierarchy.

On Thu, Nov 10, 2011 at 7:08 PM, Ola Hodne Titlestad wrote:

>
> On 10 November 2011 14:57, Murod Latifov  wrote:
>
>> You are right Ola, it is mostly indicators' case with regards to average
>> values, not data elements and saving zero values in most cases is
>> inefficient.
>> murod
>>
>>
> Yes, and currently DHIS is not using "number of facilities that reported"
> as e.g. denominator in the indicator formulas, so as far as I can see, this
> doesn't really affect the indicator values either. Or how do you mean?
>
> We have discussed to the possibility of including a variable in indicator
> formulas that provides this number, and when we do, it might be more
> relevant to keep track of at least some of the '0's.
>
> Ola
> 
>
>
>
>>
>> On Thu, Nov 10, 2011 at 3:23 PM, Ola Hodne Titlestad wrote:
>>
>>> That's true Murod, but most of the data elements collected will have an
>>> aggregation operator "SUM" and never be averaged (in DHIS at least).
>>> Typically the average data elements such as population estimates are never
>>> '0', so this has never been an issue for data processing.
>>>
>>> When people have reacted to the ignoring of '0' values it has mostly
>>> been related to completeness issues. As Jason says the complete button can
>>> solve that problem.
>>> You can also define certain data elements (called compulsory) to be
>>> filled for a a dataset to be considered complete.
>>>
>>> Note that the default behaviour in DHIS is to ignore the '0's. If you
>>> want to save them, then you must set 'Store Zero Data Value' to "Yes"
>>> for each data element where you want this behaviour.
>>>
>>> Ola
>>> -
>>>
>>> --
>>> 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>
>>>
>>>
>>>
>>> On 10 November 2011 11:08, Murod Latifov  wrote:
>>>
>>>> Hi Mark,
>>>>
>>>> Ignoring true zeros will affect average figure. e.g. division by number
>>>> of occurence will be wrong if you didn't save zero.
>>>>
>>>> regards,
>>>> murod
>>>>
>>>>
>>>> On Thu, Nov 10, 2011 at 11:52 AM, Muhire Andrew >>> > wrote:
>>>>
>>>>> Dear Mark,
>>>>> Most people takes zero as a data, that is also the way i believe but
>>>>> in other side there are people who dont like zero`s to appear in their
>>>>> database in that case they dont store it in their data (durin the creation
>>>>> of data element ) . But you have to think also on this:  zero is different
>>>>> from blank fields(Because if you ignore zero, data quality for 
>>>>> completeness
>>>>> of the data fields will be more complicated because here you see all 
>>>>> filled
>>>>> fields and unfilled fields with percentage).So this means when you 
>>>>> activate
>>>>> " dont store zero", the system will automatically ignore zero`s.
>>>>>
>>>>>  Note that : This can also depend on the data management protocols of
>>>>> the institution.
>>>>>
>>>>> Thanks
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>> *Muhire Andrew
>>>>> *
>>>>> *HMIS/Ministry of Health*
>>>>> *God is my provider.*
>>>>>
>>>>>
>>>>> --
>>>>> *From:* Mark Spohr 
>>>>> *To:* dhis2-users@lists.launchpad.net
>>>>> *Sent:* Thursday, November 10, 2011 2:35 AM
>>>>> *Subject:* [Dhis2-users] DHIS zeros and saving data?
>>>>>
>>>>> Hi,
>>>>> We just started data entry and things are going well and they like the
>>>>> data entry.
>>>>> I just have a few questions.

Re: [Dhis2-users] DHIS zeros and saving data?

[Murod Latifov]

You are right Ola, it is mostly indicators' case with regards to average
values, not data elements and saving zero values in most cases is
inefficient.
murod

On Thu, Nov 10, 2011 at 3:23 PM, Ola Hodne Titlestad wrote:

> That's true Murod, but most of the data elements collected will have an
> aggregation operator "SUM" and never be averaged (in DHIS at least).
> Typically the average data elements such as population estimates are never
> '0', so this has never been an issue for data processing.
>
> When people have reacted to the ignoring of '0' values it has mostly been
> related to completeness issues. As Jason says the complete button can solve
> that problem.
> You can also define certain data elements (called compulsory) to be filled
> for a a dataset to be considered complete.
>
> Note that the default behaviour in DHIS is to ignore the '0's. If you want
> to save them, then you must set 'Store Zero Data Value' to "Yes" for each
> data element where you want this behaviour.
>
> Ola
> -
>
> --
> 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>
>
>
>
> On 10 November 2011 11:08, Murod Latifov  wrote:
>
>> Hi Mark,
>>
>> Ignoring true zeros will affect average figure. e.g. division by number
>> of occurence will be wrong if you didn't save zero.
>>
>> regards,
>> murod
>>
>>
>> On Thu, Nov 10, 2011 at 11:52 AM, Muhire Andrew 
>> wrote:
>>
>>> Dear Mark,
>>> Most people takes zero as a data, that is also the way i believe but in
>>> other side there are people who dont like zero`s to appear in their
>>> database in that case they dont store it in their data (durin the creation
>>> of data element ) . But you have to think also on this:  zero is different
>>> from blank fields(Because if you ignore zero, data quality for completeness
>>> of the data fields will be more complicated because here you see all filled
>>> fields and unfilled fields with percentage).So this means when you activate
>>> " dont store zero", the system will automatically ignore zero`s.
>>>
>>>  Note that : This can also depend on the data management protocols of
>>> the institution.
>>>
>>> Thanks
>>>
>>> --
>>>
>>>
>>> *Muhire Andrew
>>> *
>>> *HMIS/Ministry of Health*
>>> *God is my provider.*
>>>
>>>
>>> --
>>> *From:* Mark Spohr 
>>> *To:* dhis2-users@lists.launchpad.net
>>> *Sent:* Thursday, November 10, 2011 2:35 AM
>>> *Subject:* [Dhis2-users] DHIS zeros and saving data?
>>>
>>> Hi,
>>> We just started data entry and things are going well and they like the
>>> data entry.
>>> I just have a few questions.
>>>
>>> Zeros:
>>> - All of the data items are set to "Don't store zeros" what does
>>> that mean?
>>> When totaling, aggregating, averaging, etc.  will these data fields be
>>> counted as zeros?
>>>
>>> Related.. on data entry I have them skipping over zero fields leaving
>>> them blank... I assume this will be assumed to be a zero?
>>>
>>> Also,  there doesn't seem to be an explicit "SAVE FORM" but the data
>>> does appear to be saved (even though the User General Settings does NOT
>>> have the "Auto-save data entry form" box checked).  How does this work?
>>>
>>> Thanks for this great software!
>>> --
>>> Mark Spohr, MD
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to: dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help  : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS zeros and saving data?

[Murod Latifov]

Hi Mark,

Ignoring true zeros will affect average figure. e.g. division by number of
occurence will be wrong if you didn't save zero.

regards,
murod

On Thu, Nov 10, 2011 at 11:52 AM, Muhire Andrew wrote:

> Dear Mark,
> Most people takes zero as a data, that is also the way i believe but in
> other side there are people who dont like zero`s to appear in their
> database in that case they dont store it in their data (durin the creation
> of data element ) . But you have to think also on this:  zero is different
> from blank fields(Because if you ignore zero, data quality for completeness
> of the data fields will be more complicated because here you see all filled
> fields and unfilled fields with percentage).So this means when you activate
> " dont store zero", the system will automatically ignore zero`s.
>
>  Note that : This can also depend on the data management protocols of the
> institution.
>
> Thanks
>
> --
>
>
> *Muhire Andrew
> *
> *HMIS/Ministry of Health*
> *God is my provider.*
>
>
> --
> *From:* Mark Spohr 
> *To:* dhis2-users@lists.launchpad.net
> *Sent:* Thursday, November 10, 2011 2:35 AM
> *Subject:* [Dhis2-users] DHIS zeros and saving data?
>
> Hi,
> We just started data entry and things are going well and they like the
> data entry.
> I just have a few questions.
>
> Zeros:
> - All of the data items are set to "Don't store zeros" what does that
> mean?
> When totaling, aggregating, averaging, etc.  will these data fields be
> counted as zeros?
>
> Related.. on data entry I have them skipping over zero fields leaving them
> blank... I assume this will be assumed to be a zero?
>
> Also,  there doesn't seem to be an explicit "SAVE FORM" but the data does
> appear to be saved (even though the User General Settings does NOT have the
> "Auto-save data entry form" box checked).  How does this work?
>
> Thanks for this great software!
> --
> Mark Spohr, MD
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] looking for some examples on the use of multidimensional dataelements

[Murod Latifov]

Hi Abyot,

Very interesting, but it seems to me more of levels or categories of the
same dimention, not a multidimentionality. Combination of data elements and
categories are instances of the same dimention or levels of hierarchy as it
comes in data warehouse cube definition. Moreover its representation in
datavalue table (fact table) with two keys is ambigious. DHIS2 has the
following dimentions: data elements, periods and organisation units and
data could be analysed from different angles of these dimentions.

regards,
murod

On Wed, Nov 9, 2011 at 1:12 PM, Abyot Gizaw  wrote:

>
> On Tue, Nov 8, 2011 at 7:00 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> As far as I can see there is no difference other than a visual element of
>> presentation.
>>
>
> Yes with the example we mentioned there might not be a difference if we
> are only interested in the value. But I thought the two are different in
> the sense that those in the row are dataelements and those in the column
> are optioncombinations. I thought what we choose to be a dataelement and a
> dimension affects our subsequent data analysis including indicator
> definition. I remember encountering a case previously, but I couldn't
> remember it.
>
> The current model has no sense of hierarchy, but is merely the Cartesian
>> product of possible category options.
>>
>
> That is true. Currently we are using only the final product (or the last
> level in the hierarchy) which is the option combination. But the whole idea
> with the multidimensional is to kind of slice the aggregate figure from
> different perspectives and corresponding units. Given a total figure of
> 100, say for example those who have TB, how many of them are male, how many
> are female. Out of those who are male, how many of them fall under a
> particular age category, similarly for those who are female.
>
> But we are not utilizing the full potential of *dimension *and *unit 
> *conceptualization
> of the multidimensional. We only use the final optioncombination. I always
> think the possibility of allowing data collection and analysis at any
> category or option level - not only optioncombination. But a problem I have
> is, if we allow that it will really be a mess with lots of overlaps !
>
>
>> What you present here seems to me to be completely equivalent in DHIS2
>> unless I am misinterpreting the model, which is very possible.
>>
>
>
>> On Nov 8, 2011 7:17 PM, "Abyot Gizaw"  wrote:
>>
> Thank you Jason and Kamugunga!
>>>
>>> I just wanted to see how the multidimensional is used. Because there are
>>> some tricky cases where one can design a particular data collection form as
>>>
>>>
>>>
>>> *D*
>>>
>>> *E*
>>>
>>> *A*
>>>
>>> value
>>>
>>> value
>>>
>>> *B*
>>>
>>> value
>>>
>>> value
>>>
>>> *C*
>>>
>>> Value
>>>
>>> value
>>>
>>>
>>>
>>>
>>>
>>> and others as
>>>
>>>
>>>
>>> *A*
>>>
>>> *B*
>>>
>>> *C*
>>>
>>> *D*
>>>
>>> value
>>>
>>> value
>>>
>>> value
>>>
>>> *E*
>>>
>>> value
>>>
>>> value
>>>
>>> value
>>>
>>>
>>>
>>>
>>>
>>> so what I am interested to know is what are the merits and demerits
>>> between the two? Is this because the model (I mean the multidimensional
>>> design) is flexible or confusing one that that kept everything open?
>>>
>>> Thank you
>>> Abyot.
>>>
>>>
>>> On Tue, Nov 8, 2011 at 3:01 PM, Kamugunga Adolphe wrote:
>>>
 Hi
 Can this help?

 *Diagnosis*

 *Under 5 years*

 *5 yrs and above*

 M

 F

 M

 F

  Diarrhoea with Dehydration





  Diarrhoea bloody











 Diarrhoea Chronic









  Intestinal parasites









  Malaria confirmed simple









  Malaria confirmed simple, in pregnancy









 Regards,
 Adolphe


 On 8 November 2011 14:38, Jason Pickering 
 wrote:

> Hi Abyot,
> Not sure if I understand your question, but this is a very typical one
> for many HIV related data elements.
>
>
>
> *Male*
>
> *Female*
>
> *<1*
>
> value
>
> value
>
> *1-15*
>
> value
>
> value
>
> *15+*
>
> Value
>
> value
>
>
>
>
>
> However, I am not sure what the difference between this is?
>
>
>
>
> *<1*
>
> *1-15*
>
> *15+*
>
> *Male*
>
> value
>
> value
>
> value
>
> *Female*
>
> value
>
> value
>
> value
>
>
>
>
> Regards,
> Jason
>
>
> On Tue, Nov 8, 2011 at 11:41 AM, Abyot Gizaw  wrote:
>
>> Hi all,
>>
>> Can any one provide me an example, possibly from your implementation
>> experience, on the use of multidimensional data

Re: [Dhis2-users] Assigning a category / category combo to a data element.

[Murod Latifov]

I didn't understand why we have concept? What concept does in this relation?

On Sat, Feb 19, 2011 at 7:12 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Sorry. Early morning typo.. :O
>
> My point was that it is not "required" to have multi-dimensional data
> elements, although in some cases it does many a lot of sense to use them.
>
> *Perhaps obviously,  it it also possible  to use the "default" category as
> well. This essentially means that you have no categories
>
> and would need to create separate data elements for each level of
> disaggregation.*
>
> Regards,Jason
>
>
>
> >
> > Data element 1) Number of patients testing positive for disease X in
> phase A
> > Data element 2) Number of patients testing positive for disease X in
> phase B
> >
> > Regards,
> > Jason
> >
> >
> > On Fri, Feb 18, 2011 at 10:48 PM, Dave Trombley 
> wrote:
> >>
> >>
> >>   Ah, thanks for the informative replies!   One of
> >  the problems I was having
> >> was that I was using the latest snapshot compiled from bzr and not the
> >> latest release, and the data element edit screen is completely
> different!
> >> Is there a way to do this currently in the current dev. branch?  (We've
> >> already switched our proof-of-concept to the current release version, so
> >> this is making a lot more sense now following your advice and the user
> >> manual, which was confusing us in relation to the snapshot!)
> >>
> >>
> >>
> >> On Fri, Feb 18, 2011 at 3:02 PM, Ola Hodne Titlestad 
> >> wrote:
> >>>
> >>> Dave,
> >>> I recommend reading the following parts of the user manual:
> >>> - chapter 4 on Data Elements
> >>> - chapter 5 on Data Sets and Forms
> >>> - chapter 19 - Data Dimensions in DHIS 2, especially sections 19.2 The
> >>> data element dimension, and section 19.8 "From paper forms to
> >>> multidimensional data sets - lessons learned"
> >>> Just to add to what Jason wrote:
> >>> Category combinations are linked to individual data elements, not data
> >>> sets or sections.
> >>> If your forms consists of multiple tables (with or without different
> >>> column headings) you can split a data set into multiple sections with
> _1_
> >>> category combination (and a subset of the dataset's data elements - all
> >>> sharing the same category combo) for each section. Then your section
> form
> >>> design will automatically reflect the tables/sections in your paper
> form
> >>> (given that the category options are on columns and data elements on
> rows).
> >>> If you need to design an electronic form that e.g. has data elements on
> >>> columns and category options on rows or combining multiple category
> >>> combinations on columns in the same table you need to go for custom
> forms.
> >>> Although the category combinations simplifies how you design forms I
> >>> recommend thinking about how the data will be used in analysis and
> >>> presentation after the data has been collected, e.g. how aggregation
> will
> >>> take place,  and let that guide how you design data elements and
> categories,
> >>> and not let  the data entry form structure control that. The total and
> >>> subtotal of data elements are used in many data analysis components
> (such as
> >>> validation rules, indicators, reports, pivot tables) and it is
> definitely an
> >>> advantage if the total of the data element's category options add up to
> >>> something meaningful and is not just picked to mimic column headings in
> a
> >>> form.  Many more thoughts and examples on this in section 19.8 in the
> >>> manual.
> >>> We also have some very fresh material on this topic from a recent
> >>> workshop, which you can find here (look under Tuesday and the session
> called
> >>> "Design of data elements and data sets"):
> >>> http://www.hisp.uio.no/events/201102-impl-workshop/programme2.html
> >>>
> >>> Ola
> >>> -
> >>>
> >>>
> >>> --
> >>> Ola Hodne Titlestad (Mr)
> >>> HISP
> >>> Department of Informatics
> >>> University of Oslo
> >>>
> >>> Mobile: +47 48069736
> >>> Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
> >>>
> >>>
> >>> On 18 February 2011 18:02, Jason Pickering <
> jason.p.picker...@gmail.com>
> >>> wrote:
> 
>  Hi Dave,
>  Welcome!
> 
>  Its is a bit confusing to me as well. Let me try and explain as best
>  as I can. Others that understand the model may correct me.
> 
> 
>  You need to create a "Concept". In this case, it would probably
>  "Phase" as well.
> 
>   You need to create categories. In your case this would be a "Phase".
> 
>  You need to create category options, "Phase A" and "Phase B" for the
>  category "Phase".
> 
>  You need a "Data element category combination" as well. In your case,
>  it would be "Phases" perhaps. If the data elements is further
>  disaggregated by categories "Age" and "Gender" you could add these
>  categories as well.
> 
>  Finally , you need a data element "Num