Re: [Dhis2-users] several links in api/resources pointing to the same ("dimensions") url

[Edward Ari Bichetero]

Lars, is there an intention to fix this bug in 2.15 ? I understand that the Web 
API is being rewritten but this is a major bug. Or is 2.15 not to be regarded 
as a stable release, with the userbase being encouraged to move directly to 
2.16?

- Edward -

On Sunday, July 6, 2014 7:17 PM, Lars Helge Øverland  
wrote:

>
>
>Hi Lavi,
>
>
>this has been corrected in latest development version so will be okay in 2.16. 
>It is not intentional but also not completely arbitrary - all those classes 
>implement a common "dimensional" interface and as a result ended up with wrong 
>re-directs. The Web API has undergone a rewrite for 2.16 so unfortunately we 
>are not able to back-port the "fix".
>
>
>regards,
>
>
>Lars
>
>
>
>
>
>
>
>On Sun, Jul 6, 2014 at 1:36 PM, Lavi Shpigelman  wrote:
>
>Hi.
>>I noticed that in in version 2.15 (and also in version 2.13), some of the 
>>resources in the api/resources page point to the same url  (api/dimensions)
>>
>>These include:
>>
>>
>>
>>https://apps.dhis2.org/demo/api/dimensions";>
>>>href="https://apps.dhis2.org/demo/api/dimensions";>
>>>href="https://apps.dhis2.org/demo/api/dimensions";>
>>>href="https://apps.dhis2.org/demo/api/dimensions";>
>>https://apps.dhis2.org/demo/api/dimensions";>
>>>href="https://apps.dhis2.org/demo/api/dimensions";>
>>>href="https://apps.dhis2.org/demo/api/dimensions";>
>>Is this intentional or should each of the resources point to a url with the 
>>resource name (only camelCased)
>>
>>___
>>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] Data import to a Dataset linked to a combination of categories

[Maheed Ramadan]

Hello Lars,

As you know, we are still investigating the DHIS system to see if we can use it 
in our organization.
Actually, we started implementing a small pilot project in one country area and 
we are trying to collect the data and move it into DHIS and then analyze it and 
create some reports.

A requirement in our design is to have all our datasets be linked to a category 
combination attribute which allows us to add another dimension to our data 
entry forms. The extra dimension we need to specify is the actual “Project” 
that will be linked to the data in addition to the org unit and period 
dimensions.

Since we have a lot of data that we need to push into DHIS, we need a quick and 
fast solution for this and the only path we have is to import this data from an 
external source (i.e. Excel/CSV file). As you know, the data import tool still 
does not support datasets with custom category combination.

Honestly I was following up and reviewing all recent updates to the system 
including bugs and blueprints and I was shocked when I found that this bug ==> 
(Import) Attribute option combos in import 

  has been moved/postponed to milestone 2.17 !!!

For us, this is a very important & critical feature to have for the reasons 
mentioned above. Our decision to use DHIS is highly based on the import 
functionality. Not having this functionality will prevent us to move forward.

We were hoping that this will be resolved in milestone 2.16 so waiting for this 
release was not a big deal. However, this is a problem if we have to wait 3-4 
months until 2.17 is released.

Sorry Lars for all these details. I don’t know if this issue could be revised 
from your side and be included in the upcoming release? We like the system and 
we appreciate your support with all the developers contributing to make it 
successful.

As a final request, is there any possible solution that we could use to get 
data in batch into DHIS, taking into consideration the requirement we have? 
This could be a turnaround or a temporary solution until the issue is resolved.


Thanks a lot.
Hope to hear from you soon….


Maheed.



From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Wednesday, July 02, 2014 12:17 PM
To: Maheed Ramadan
Cc: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data import to a Dataset linked to a combination of 
categories

Hi there,

according to schedule we will release on July 4th. It seems that we will need 
some extra days to wrap up the last features.

cheers

Lars



On Wed, Jul 2, 2014 at 11:13 AM, Maheed Ramadan 
mailto:maheed.rama...@nrc.no>> wrote:
Hello Lars,

Thanks for the quick response. Hoping this issue can be resolved soon.

One question please. When do you think the next version of DHIS (i.e. 2.16) 
will be released?


Thanks again.

Maheed



From: Lars Helge Øverland 
[mailto:larshe...@gmail.com]
Sent: Wednesday, July 02, 2014 11:12 AM
To: Maheed Ramadan
Cc: dhis2-d...@lists.launchpad.net; 
dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data import to a Dataset linked to a combination of 
categories

HI Maheed,

good spot and you are correct. We simply haven't implemented it yet due to time 
constraints. We have a blueprint for it 
here.
 We will prioritize it and let you know when its done.

regards,

Lars



On Wed, Jul 2, 2014 at 8:39 AM, Maheed Ramadan 
mailto:maheed.rama...@nrc.no>> wrote:
Dear DHIS users/developers,

As you know, we have a feature in DHIS that allows a dataset to be linked to a 
“Combination of categories”.
In the data entry form, these category combinations will be rendered as 
dropdown lists in addition to the Org Unit and period.

These category combinations are configured as “Attributes” so they could be 
linked to the dataset in that way.
This is a very good feature and works well from the web user interface data 
entry forms.

However, if we want to import data using xml/csv file, this doesn’t work as 
needed. That is because the import template does not support any category 
combinations defined in the dataset. It only works if the dataset is configured 
with the “default” category combination.

My question ==> is there any way that we can import data to this kind of 
dataset and set the values of the category combination attributes from the 
input file (xml/csv).

Has anyone faced this issue and found a solution for it? If it is it a bug in 
the system, do you know if there is any plan to fix it?
Awaiting your feedback please…

Note that I am using the latest version of DHIS 2.15 Rev. 15181


Thanks,

Maheed





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

Re: [Dhis2-users] [Dhis2-devs] Data import to a Dataset linked to a combination of categories

[Jason Pickering]

One possible solution is to simply transform your data directly to a form
which can be imported directly into the database itself.  If you are doing
a one off or supervised data import, it should be relatively simple to
transform the data to import to SQL and inject it directly, while this
feature is implemented.

Regards,
Jason

--
Sent from my mobile
On Jul 22, 2014 10:42 AM, "Maheed Ramadan"  wrote:

>  Hello Lars,
>
>
>
> As you know, we are still investigating the DHIS system to see if we can
> use it in our organization.
>
> Actually, we started implementing a small pilot project in one country
> area and we are trying to collect the data and move it into DHIS and then
> analyze it and create some reports.
>
>
>
> A requirement in our design is to have all our datasets be linked to a
> category combination attribute which allows us to add another dimension to
> our data entry forms. The extra dimension we need to specify is the actual
> “Project” that will be linked to the data in addition to the org unit and
> period dimensions.
>
>
>
> Since we have a lot of data that we need to push into DHIS, we need a
> quick and fast solution for this and the only path we have is to import
> this data from an external source (i.e. Excel/CSV file). As you know, the
> data import tool still does not support datasets with custom category
> combination.
>
>
>
> Honestly I was following up and reviewing all recent updates to the system
> including bugs and blueprints and I was shocked when I found that this bug
> è (Import) Attribute option combos in import
> 
>  has
> been moved/postponed to milestone 2.17 !!!
>
>
>
> For us, this is a very important & critical feature to have for the
> reasons mentioned above. Our decision to use DHIS is highly based on the
> import functionality. Not having this functionality will prevent us to move
> forward.
>
>
>
> We were hoping that this will be resolved in milestone 2.16 so waiting for
> this release was not a big deal. However, this is a problem if we have to
> wait 3-4 months until 2.17 is released.
>
>
>
> Sorry Lars for all these details. I don’t know if this issue could be
> revised from your side and be included in the upcoming release? We like the
> system and we appreciate your support with all the developers contributing
> to make it successful.
>
>
>
> As a final request, is there any possible solution that we could use to
> get data in batch into DHIS, taking into consideration the requirement we
> have? This could be a turnaround or a temporary solution until the issue is
> resolved.
>
>
>
>
>
> Thanks a lot.
>
> Hope to hear from you soon….
>
>
>
>
>
> Maheed.
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Wednesday, July 02, 2014 12:17 PM
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> Hi there,
>
>
>
> according to schedule we will release on July 4th. It seems that we will
> need some extra days to wrap up the last features.
>
>
>
> cheers
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 11:13 AM, Maheed Ramadan 
> wrote:
>
>  Hello Lars,
>
>
>
> Thanks for the quick response. Hoping this issue can be resolved soon.
>
>
>
> One question please. When do you think the next version of DHIS (i.e.
> 2.16) will be released?
>
>
>
>
>
> Thanks again.
>
>
>
> Maheed
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Wednesday, July 02, 2014 11:12 AM
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> HI Maheed,
>
>
>
> good spot and you are correct. We simply haven't implemented it yet due to
> time constraints. We have a blueprint for it here
> .
> We will prioritize it and let you know when its done.
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 8:39 AM, Maheed Ramadan 
> wrote:
>
>  Dear DHIS users/developers,
>
>
>
> As you know, we have a feature in DHIS that allows a dataset to be linked
> to a “Combination of categories”.
>
> In the data entry form, these category combinations will be rendered as
> dropdown lists in addition to the Org Unit and period.
>
>
>
> These category combinations are configured as “Attributes” so they could
> be linked to the dataset in that way.
>
> This is a very good feature and works well from the web user interface
> data entry forms.
>
>
>
> However, if we want to import data using xml/csv file, this doesn’t work
> as needed. That is because the import template does not support any
> category combinations defined in the dataset. It only works if the dataset
> is configured with the “defa

Re: [Dhis2-users] DHIS2 - Versioning of data

[Lars Helge Øverland]

Hi Robin,

its a good question and actually something that has been discussed before.
You highlight some of the pros and cons in your email.

The reason why we haven't done it so far is simply that we want to avoid
the complexity that comes with validity dates instead of routine time
periods and data aggregation. If this is used with care it would work well
but the system must take handle the quirky cases as well. Example: if
someone enters 10 data sets with completely arbitrary validity dates during
a year, then what should be the yearly average?

So far we have been relying on scripts to move data over to new time
periods. The typical use case is population data (like you say), where you
have censuses being done every 3-10 years. In this case one would enter the
data for a year (month is often too granular), then apply a SQL script to
copy the data to coming years, taking a growth rate into account. This
works pretty well.

Data with validity dates is also bordering to what we call "events", or
"surveys", which you can capture through the "tracker" component. Here,
events are capture for a timestamp, and you can capture any number of
events during a timeline.


regards,

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

Re: [Dhis2-users] several links in api/resources pointing to the same ("dimensions") url

[Lars Helge Øverland]

Hi Edward,

I'm sorry but we don't plan to fix this. If you let us know your use-case
we are happy to suggest a work-around.

regards,

Lars



On Tue, Jul 22, 2014 at 9:32 AM, Edward Ari Bichetero 
wrote:

> Lars, is there an intention to fix this bug in 2.15 ? I understand that
> the Web API is being rewritten but this is a major bug. Or is 2.15 not to
> be regarded as a stable release, with the userbase being encouraged to move
> directly to 2.16?
>
> - Edward -
>
> On Sunday, July 6, 2014 7:17 PM, Lars Helge Øverland 
> wrote:
>
> >
> >
> >Hi Lavi,
> >
> >
> >this has been corrected in latest development version so will be okay in
> 2.16. It is not intentional but also not completely arbitrary - all those
> classes implement a common "dimensional" interface and as a result ended up
> with wrong re-directs. The Web API has undergone a rewrite for 2.16 so
> unfortunately we are not able to back-port the "fix".
> >
> >
> >regards,
> >
> >
> >Lars
> >
> >
> >
> >
> >
> >
> >
> >On Sun, Jul 6, 2014 at 1:36 PM, Lavi Shpigelman  wrote:
> >
> >Hi.
> >>I noticed that in in version 2.15 (and also in version 2.13), some of
> the resources in the api/resources page point to the same url
> (api/dimensions)
> >>
> >>These include:
> >>
> >>
> >>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>https://apps.dhis2.org/demo/api/dimensions";>
> >>Is this intentional or should each of the resources point to a url with
> the resource name (only camelCased)
> >>
> >>___
> >>Mailing list: https://launchpad.net/~dhis2-users
> >>Post to : dhis2-users@lists.launchpad.net
> >>Unsubscribe : https://launchpad.net/~dhis2-users
> >>More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
> >
> >___
> >Mailing list: https://launchpad.net/~dhis2-users
> >Post to : dhis2-users@lists.launchpad.net
> >Unsubscribe : https://launchpad.net/~dhis2-users
> >More help   : https://help.launchpad.net/ListHelp
> >
> >
> >
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] DHIS2 - Tracker data aggregation

[Robin Martens]

Hi devs and users,

I've been exploring the aggregation query builder which is effectively the link 
between tracker data and aggregated data. Now I'm a bit stuck on the following 
limits of the system, namely that a single query seems able to produce only a 
single data value, for any combination of orgunit and other dimensions there 
might be. On the other hand, it does calculate (and recalculate in case of past 
data?) this data value for each past period of the aggregated data element 
(monthly, quarterly, or any other). Can anyone confirm this is correct?

If so, imagine the following case: you have the aggregated data element 
"average patient age" which has 3 dimensions: orgunit, gender, and disease 
type. If you happen to have 20 orgunits, 2 genders, and 5 disease types, this 
makes 20x2x5=200 separate aggregation queries to be defined manually one by 
one! And that's only for a single aggregated data element!

Just wondering if I missed a functionality of the query builder somewhere 
(which I really hope I did).

Thanks for any feedback,

Robin
___
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] aggregate builder

[rin.channara]

HI all users,

anyone know how to use datediff in aggregate builder. I try many time with 
datediff function in aggregate builder. when I click test, I got the alert 
“warning message”. do you know why?

I use datediff to calculate many day of date of birth with date of enrollment.


thank you

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

Re: [Dhis2-users] Data import to a Dataset linked to a combination of categories

[Lars Helge Øverland]

Hi Maheed,

I agree with you. I have implemented it now in trunk for XML and CSV. Will
be part of 2.16. You can try it from the CI server in 40 min:

https://apps.dhis2.org/ci/job/dhis-trunk/

regards,

Lars




On Tue, Jul 22, 2014 at 10:42 AM, Maheed Ramadan 
wrote:

>  Hello Lars,
>
>
>
> As you know, we are still investigating the DHIS system to see if we can
> use it in our organization.
>
> Actually, we started implementing a small pilot project in one country
> area and we are trying to collect the data and move it into DHIS and then
> analyze it and create some reports.
>
>
>
> A requirement in our design is to have all our datasets be linked to a
> category combination attribute which allows us to add another dimension to
> our data entry forms. The extra dimension we need to specify is the actual
> “Project” that will be linked to the data in addition to the org unit and
> period dimensions.
>
>
>
> Since we have a lot of data that we need to push into DHIS, we need a
> quick and fast solution for this and the only path we have is to import
> this data from an external source (i.e. Excel/CSV file). As you know, the
> data import tool still does not support datasets with custom category
> combination.
>
>
>
> Honestly I was following up and reviewing all recent updates to the system
> including bugs and blueprints and I was shocked when I found that this bug
> è (Import) Attribute option combos in import
> 
>  has
> been moved/postponed to milestone 2.17 !!!
>
>
>
> For us, this is a very important & critical feature to have for the
> reasons mentioned above. Our decision to use DHIS is highly based on the
> import functionality. Not having this functionality will prevent us to move
> forward.
>
>
>
> We were hoping that this will be resolved in milestone 2.16 so waiting for
> this release was not a big deal. However, this is a problem if we have to
> wait 3-4 months until 2.17 is released.
>
>
>
> Sorry Lars for all these details. I don’t know if this issue could be
> revised from your side and be included in the upcoming release? We like the
> system and we appreciate your support with all the developers contributing
> to make it successful.
>
>
>
> As a final request, is there any possible solution that we could use to
> get data in batch into DHIS, taking into consideration the requirement we
> have? This could be a turnaround or a temporary solution until the issue is
> resolved.
>
>
>
>
>
> Thanks a lot.
>
> Hope to hear from you soon….
>
>
>
>
>
> Maheed.
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Wednesday, July 02, 2014 12:17 PM
>
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> Hi there,
>
>
>
> according to schedule we will release on July 4th. It seems that we will
> need some extra days to wrap up the last features.
>
>
>
> cheers
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 11:13 AM, Maheed Ramadan 
> wrote:
>
>  Hello Lars,
>
>
>
> Thanks for the quick response. Hoping this issue can be resolved soon.
>
>
>
> One question please. When do you think the next version of DHIS (i.e.
> 2.16) will be released?
>
>
>
>
>
> Thanks again.
>
>
>
> Maheed
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Wednesday, July 02, 2014 11:12 AM
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> HI Maheed,
>
>
>
> good spot and you are correct. We simply haven't implemented it yet due to
> time constraints. We have a blueprint for it here
> .
> We will prioritize it and let you know when its done.
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 8:39 AM, Maheed Ramadan 
> wrote:
>
>  Dear DHIS users/developers,
>
>
>
> As you know, we have a feature in DHIS that allows a dataset to be linked
> to a “Combination of categories”.
>
> In the data entry form, these category combinations will be rendered as
> dropdown lists in addition to the Org Unit and period.
>
>
>
> These category combinations are configured as “Attributes” so they could
> be linked to the dataset in that way.
>
> This is a very good feature and works well from the web user interface
> data entry forms.
>
>
>
> However, if we want to import data using xml/csv file, this doesn’t work
> as needed. That is because the import template does not support any
> category combinations defined in the dataset. It only works if the dataset
> is configured with the “default” category combination.
>
>
>
> My question è is there any way that we can import data to this kind of
> dataset and set the values 

Re: [Dhis2-users] aggregate builder

[Tran Chau]

Hi Channara,

There are four kinds of datediff formulas supported :

*1.* Incident date diff : Get the number of days between a data element and
incident-date of tracked entity instance ( TEI ). Below is an example for
this case :
* DATEDIFF([DE:1.2.3] , dateOfIncident)  > 1*

*2.* Enrollment date diff : Get the number of days between a data element
and enrollment-date of tracked entity instance ( TEI ). Below is an example
for this case :
* DATEDIFF([DE:1.2**.3**] , enrollmentDate)  > 1*

*3. *Report date diff : Get the number of days between a data element and a
report-date of an event of tracked entity instance ( TEI ). Below is an
example for this case :
* DATEDIFF([DE:1.2**.3**] , executionDate)  > 1*

*4. *Data element date diff : Get the number of days between a data element
and a report-date of an event of tracked entity instance ( TEI ). Below is
an example for this case :
* DATEDIFF([DE:1.2**.3**] , [DE:1.2.4])  > 1*

The formulas to calculate the number of days related to DATE attributes
haven't supported yet.


Best regards,

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


On Tue, Jul 22, 2014 at 10:54 PM,  wrote:

>  HI all users,
> anyone know how to use datediff in aggregate builder. I try many time with
> datediff function in aggregate builder. when I click test, I got the
> alert “warning message”. do you know why?
> I use datediff to calculate many day of date of birth with date of
> enrollment.
>
> thank you
> channara
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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] aggregate builder

[rin.channara]

thank you. I understand,

but I would to confirm with you that the attribute with date type is not 
support for calculate in aggregate builder?

if SO, when they will plan implement it?





From: Tran Chau
Sent: ‎Wednesday‎, ‎July‎ ‎23‎, ‎2014 ‎10‎:‎57‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list





Hi Channara,



There are four kinds of datediff formulas supported :




1. Incident date diff : Get the number of days between a data element and 
incident-date of tracked entity instance ( TEI ). Below is an example for this 
case :

 DATEDIFF([DE:1.2.3] , dateOfIncident)  > 1





2. Enrollment date diff : Get the number of days between a data element and 
enrollment-date of tracked entity instance ( TEI ). Below is an example for 
this case :

 DATEDIFF([DE:1.2.3] , enrollmentDate)  > 1




3. Report date diff : Get the number of days between a data element and a 
report-date of an event of tracked entity instance ( TEI ). Below is an example 
for this case :

 DATEDIFF([DE:1.2.3] , executionDate)  > 1




4. Data element date diff : Get the number of days between a data element and a 
report-date of an event of tracked entity instance ( TEI ). Below is an example 
for this case :

 DATEDIFF([DE:1.2.3] , [DE:1.2.4])  > 1




The formulas to calculate the number of days related to DATE attributes haven't 
supported yet.






Best regards,

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



On Tue, Jul 22, 2014 at 10:54 PM,  wrote:




HI all users,

anyone know how to use datediff in aggregate builder. I try many time with 
datediff function in aggregate builder. when I click test, I got the alert 
“warning message”. do you know why?

I use datediff to calculate many day of date of birth with date of enrollment.




thank you

channara


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp___
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] Dataset Section

[rin.channara]

Hi all developers,

MY SUGGESTION:

In “section grey field management” of combo category options. Has only “Disable 
field” for disable entry value. But I think it is important, we should have 
“Hide field” to hide some combo category. Because it effect on showing in Data 
Entry, if we has many combo category option cross with data element.


thank you

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

Re: [Dhis2-users] Dataset Section

[Knut Staring]

Related to this, we have a big form where most sections are very simple
and broken down only by gender, but one is also broken down by A LOT of age
groupings, so the auto-generated form becomes extremely wide and the users
have to scroll a lot horizontally. This also means it is very easy for them
to lose track of where they are, though of course they do have the little
box in the upper right corner which is meant to help with exactly those
cases.

So, in general we are very happy with the autogenerated form (and it is
huge, with 10 sections), but would like to be able to customize the layout
for this particular section (actually, the IDEAL option would be to be able
to specify the width of the cells - as we could well have cells only a
third of the automatic width).

I suppose the best solution for now is to separate out this particular
section into a separate form, but are we planning to support custom forms
for sections?

Knut




On Wed, Jul 23, 2014 at 6:23 AM,  wrote:

>  Hi all developers,
> *MY SUGGESTION:*
> In “section grey field management” of combo category options. Has
> only “Disable field” for disable entry value. But I think it is
> important, we should have “Hide field” to hide some combo category. Because
> it effect on showing in Data Entry, if we has many combo category option
> cross with data element.
>
> thank you
> CHANNARA
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] aggregate builder

[Tran Chau]

No, the DATE attributes haven't supported in aggregate builder. I sent
email to Oslo to discuss about supporting it for version 2.17.

Best regards,

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


On Wed, Jul 23, 2014 at 11:05 AM,  wrote:

>  thank you. I understand,
> but I would to confirm with you that the attribute with date type is not
> support for calculate in aggregate builder?
> if SO, when they will plan implement it?
>
> *From:* Tran Chau 
> *Sent:* ‎Wednesday‎, ‎July‎ ‎23‎, ‎2014 ‎10‎:‎57‎ ‎Morning
> *To:* channara rin 
> *Cc:* DHIS 2 Users list 
>
> Hi Channara,
>
> There are four kinds of datediff formulas supported :
>
> *1.* Incident date diff : Get the number of days between a data element
> and incident-date of tracked entity instance ( TEI ). Below is an example
> for this case :
> * DATEDIFF([DE:1.2.3] , dateOfIncident)  > 1*
>
> *2.* Enrollment date diff : Get the number of days between a data element
> and enrollment-date of tracked entity instance ( TEI ). Below is an example
> for this case :
> * DATEDIFF([DE:1.2**.3**] , enrollmentDate)  > 1*
>
> *3. *Report date diff : Get the number of days between a data element and
> a report-date of an event of tracked entity instance ( TEI ). Below is an
> example for this case :
> * DATEDIFF([DE:1.2**.3**] , executionDate)  > 1*
>
> *4. *Data element date diff : Get the number of days between a data
> element and a report-date of an event of tracked entity instance ( TEI ).
> Below is an example for this case :
> * DATEDIFF([DE:1.2**.3**] , [DE:1.2.4])  > 1*
>
> The formulas to calculate the number of days related to DATE attributes
> haven't supported yet.
>
>
> Best regards,
> 
> Châu Thu Trân
> HISP Viet Nam
> Email: tran.hispviet...@gmail.com
>
>
> On Tue, Jul 22, 2014 at 10:54 PM,  wrote:
>
>>  HI all users,
>> anyone know how to use datediff in aggregate builder. I try many time
>> with datediff function in aggregate builder. when I click test, I got the
>> alert “warning message”. do you know why?
>> I use datediff to calculate many day of date of birth with date of
>> enrollment.
>>
>> thank you
>> channara
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
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] Dataset Section

[rin.channara]

YES knut, custom forms is good for user can do any things to design and assign 
any DE to show. but the main problem of custom forms is when I go to report → 
dataset report. I can’t export in excel or pdf. It work only printing function…





From: Knut Staring
Sent: ‎Wednesday‎, ‎July‎ ‎23‎, ‎2014 ‎11‎:‎42‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list





Related to this, we have a big form where most sections are very simple and 
broken down only by gender, but one is also broken down by A LOT of age 
groupings, so the auto-generated form becomes extremely wide and the users have 
to scroll a lot horizontally. This also means it is very easy for them to lose 
track of where they are, though of course they do have the little box in the 
upper right corner which is meant to help with exactly those cases.



So, in general we are very happy with the autogenerated form (and it is huge, 
with 10 sections), but would like to be able to customize the layout for this 
particular section (actually, the IDEAL option would be to be able to specify 
the width of the cells - as we could well have cells only a third of the 
automatic width).




I suppose the best solution for now is to separate out this particular section 
into a separate form, but are we planning to support custom forms for sections?




Knut










On Wed, Jul 23, 2014 at 6:23 AM,  wrote:




Hi all developers,

MY SUGGESTION:

In “section grey field management” of combo category options. Has only “Disable 
field” for disable entry value. But I think it is important, we should have 
“Hide field” to hide some combo category. Because it effect on showing in Data 
Entry, if we has many combo category option cross with data element.




thank you

CHANNARA


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






-- 

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

Re: [Dhis2-users] DHIS2 - Tracker data aggregation

[Jørn Braa]

Hi Robin,
in the 'DHIS world' we distinguish between
- data elements, ('data variable', 'count'), which is may be regarded as an
atomic unit / raw piece of data, such as in your case cases of patient
encounters by diagnosed disease and by gender (gender / age group will
typically be defined as dimension of the data element e.g. cases of measles)
and
- indicators, which may be any further calculation based on the data
elements, but typically percentages, rates, ..

You define your indicators - as well as your data elements-  in the DHIS
meta data management module.

In your case you define the 'five diseases' as data elements and the
'averages' as indicators.

query builder only then used to aggregate the cases. The averages and other
indicators  are calculated as indicators by DHIS.
You can see the manual about indicators and data elements and meta data
managment

Jørn



On Tue, Jul 22, 2014 at 5:39 PM, Robin Martens  wrote:

>   Hi devs and users,
>
>
>
> I've been exploring the aggregation query builder which is effectively the
> link between tracker data and aggregated data. Now I'm a bit stuck on the
> following limits of the system, namely that a single query seems able to
> produce only a single data value, for any combination of orgunit and other
> dimensions there might be. On the other hand, it does calculate (and
> recalculate in case of past data?) this data value for each past period of
> the aggregated data element (monthly, quarterly, or any other). Can anyone
> confirm this is correct?
>
>
>
> If so, imagine the following case: you have the aggregated data element
> "average patient age" which has 3 dimensions: orgunit, gender, and disease
> type. If you happen to have 20 orgunits, 2 genders, and 5 disease types,
> this makes 20x2x5=200 separate aggregation queries to be defined manually
> one by one! And that's only for a single aggregated data element!
>
>
>
> Just wondering if I missed a functionality of the query builder somewhere
> (which I really hope I did).
>
>
>
> Thanks for any feedback,
>
>
>
> Robin
>
> ___
> 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] Dataset Section

[Neranga]

Hi,

I faced a similar issue when I was customizing DHIS2 tracked instance to
collect patient-based data for the cancer screening clinic in Sri Lanka.
(DHIS2.15)
In our case, client details are collected for registration and then for the
visit clinical history, examination, investigations and follow up details
are recorded. As you understand there are elements which are very specific
to females and males, however it was difficult to implement the "hiding
fields" according to the value given to the sex attribute. I couldn't find
a way to implement that logic. Instead we designed 2 separate programs for
males and females, and it was not too bad to do so.
On the other hand I also found the "sections" in the program stages quite
useful too. But I had to give up the custom designed forms and go ahead
with the auto generated forms, because when I designed the form, the
section tab was no longer available.
I think these experiences will help developers to make future changes.
Thanks.


*L.A. Neranga Prabhath*
*Trainee - MSc in Medical Informatics*
*Postgraduate Institute of Medicine*
*University of Colombo-Sri Lanka.*
*Telephone: +94772531559*



On 23 July 2014 10:12, Knut Staring  wrote:

> Related to this, we have a big form where most sections are very simple
> and broken down only by gender, but one is also broken down by A LOT of age
> groupings, so the auto-generated form becomes extremely wide and the users
> have to scroll a lot horizontally. This also means it is very easy for them
> to lose track of where they are, though of course they do have the little
> box in the upper right corner which is meant to help with exactly those
> cases.
>
> So, in general we are very happy with the autogenerated form (and it is
> huge, with 10 sections), but would like to be able to customize the layout
> for this particular section (actually, the IDEAL option would be to be able
> to specify the width of the cells - as we could well have cells only a
> third of the automatic width).
>
> I suppose the best solution for now is to separate out this particular
> section into a separate form, but are we planning to support custom forms
> for sections?
>
> Knut
>
>
>
>
> On Wed, Jul 23, 2014 at 6:23 AM,  wrote:
>
>>  Hi all developers,
>> *MY SUGGESTION:*
>> In “section grey field management” of combo category options. Has
>> only “Disable field” for disable entry value. But I think it is
>> important, we should have “Hide field” to hide some combo category. Because
>> it effect on showing in Data Entry, if we has many combo category option
>> cross with data element.
>>
>> thank you
>> CHANNARA
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> 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] Data import to a Dataset linked to a combination of categories

[Maheed Ramadan]

Hi Lars,

Thanks very much for considering this issue and including it in the next 
version. I will check it and see how it works.

In relation to this bug/fix, there is one place that should also be fixed. This 
is when you navigate to a Dataset (configured with an attribute category 
combo), then try to Get PDF for Data entry. It turns out that the generated PDF 
is missing the option to select the attribute combination. It only includes the 
PERIOD & ORG Units.

It will be perfect if this can also be resolved in 2.16 because using PDF 
method for importing data is also very important and useful.

On last question. Any idea when will 2.16 be released?


Thank you again for your continuous support.


Best Regards,

Maheed


From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Tuesday, July 22, 2014 7:46 PM
To: Maheed Ramadan
Cc: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data import to a Dataset linked to a combination of 
categories

Hi Maheed,

I agree with you. I have implemented it now in trunk for XML and CSV. Will be 
part of 2.16. You can try it from the CI server in 40 min:

https://apps.dhis2.org/ci/job/dhis-trunk/

regards,

Lars



On Tue, Jul 22, 2014 at 10:42 AM, Maheed Ramadan 
mailto:maheed.rama...@nrc.no>> wrote:
Hello Lars,

As you know, we are still investigating the DHIS system to see if we can use it 
in our organization.
Actually, we started implementing a small pilot project in one country area and 
we are trying to collect the data and move it into DHIS and then analyze it and 
create some reports.

A requirement in our design is to have all our datasets be linked to a category 
combination attribute which allows us to add another dimension to our data 
entry forms. The extra dimension we need to specify is the actual “Project” 
that will be linked to the data in addition to the org unit and period 
dimensions.

Since we have a lot of data that we need to push into DHIS, we need a quick and 
fast solution for this and the only path we have is to import this data from an 
external source (i.e. Excel/CSV file). As you know, the data import tool still 
does not support datasets with custom category combination.

Honestly I was following up and reviewing all recent updates to the system 
including bugs and blueprints and I was shocked when I found that this bug ==> 
(Import) Attribute option combos in import 

  has been moved/postponed to milestone 2.17 !!!

For us, this is a very important & critical feature to have for the reasons 
mentioned above. Our decision to use DHIS is highly based on the import 
functionality. Not having this functionality will prevent us to move forward.

We were hoping that this will be resolved in milestone 2.16 so waiting for this 
release was not a big deal. However, this is a problem if we have to wait 3-4 
months until 2.17 is released.

Sorry Lars for all these details. I don’t know if this issue could be revised 
from your side and be included in the upcoming release? We like the system and 
we appreciate your support with all the developers contributing to make it 
successful.

As a final request, is there any possible solution that we could use to get 
data in batch into DHIS, taking into consideration the requirement we have? 
This could be a turnaround or a temporary solution until the issue is resolved.


Thanks a lot.
Hope to hear from you soon….


Maheed.



From: Lars Helge Øverland 
[mailto:larshe...@gmail.com]
Sent: Wednesday, July 02, 2014 12:17 PM

To: Maheed Ramadan
Cc: dhis2-d...@lists.launchpad.net; 
dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data import to a Dataset linked to a combination of 
categories

Hi there,

according to schedule we will release on July 4th. It seems that we will need 
some extra days to wrap up the last features.

cheers

Lars



On Wed, Jul 2, 2014 at 11:13 AM, Maheed Ramadan 
mailto:maheed.rama...@nrc.no>> wrote:
Hello Lars,

Thanks for the quick response. Hoping this issue can be resolved soon.

One question please. When do you think the next version of DHIS (i.e. 2.16) 
will be released?


Thanks again.

Maheed



From: Lars Helge Øverland 
[mailto:larshe...@gmail.com]
Sent: Wednesday, July 02, 2014 11:12 AM
To: Maheed Ramadan
Cc: dhis2-d...@lists.launchpad.net; 
dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data import to a Dataset linked to a combination of 
categories

HI Maheed,

good spot and you are correct. We simply haven't implemented it yet due to time 
constraints. We have a blueprint for it 
here.
 We will prioritize it and let you know when i

Re: [Dhis2-users] DHIS2 - Tracker data aggregation

[Lars Helge Øverland]

Hi Robin,

in fact the organisation unit dimension should not be part of the
aggregation queries - you can set one aggregation query to run for any
number of org units. You could create the gender and disease type as
categories + category options. However you are right that to populate all
variations of this data element you would need 2 x 5 aggregation queries.

That said, in version 2.15 and 2.16 you have better support for doing
aggregated analysis without using aggregation queries. The "event reports"
app lets you create pivot tables and specify queries directly for
aggregated data, and you can similarly create charts through the "event
visualizer" app, which can then be included directly in the dashboard
together with the routine data charts. Have a look at those apps on the /dev
 instance - the queries can be specified on the
left side panel e.g. under the "data" tab.

These apps are backed by the event analytics web api resource (docs
). Our
medium-term plan is to phase out the current aggregation queries function
by instead linking routine elements with such event analytics queries.

Now conceptually you would still have to define a query per such data
element + category option combination - it isn't really trivial to convert
events into aggregated data elements "auto-magically".

best regards,

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

Re: [Dhis2-users] Dataset Section

[Lars Helge Øverland]

Hi there,

thanks for the input. I don't think we will implement custom forms in
section forms in the near future. When you have a form which is super-wide
with mostly unused fields then that's usually a sign that the form itself
should be re-designed.

I have been thinking of a function for using the section form HTML as basis
for custom forms - ie. you could get the section form layout as a starting
point and then go on to modify the parts you need.

Neranga: If you need tabs also for custom forms we have jquery ui included
in the page and its pretty simple to set up the "tabs" widget with a little
bit of HTML/javascript, see docs here .

best regards,

Lars




On Wed, Jul 23, 2014 at 7:02 AM, Neranga 
wrote:

> Hi,
>
> I faced a similar issue when I was customizing DHIS2 tracked instance to
> collect patient-based data for the cancer screening clinic in Sri Lanka.
> (DHIS2.15)
> In our case, client details are collected for registration and then for
> the visit clinical history, examination, investigations and follow up
> details are recorded. As you understand there are elements which are very
> specific to females and males, however it was difficult to implement the
> "hiding fields" according to the value given to the sex attribute. I
> couldn't find a way to implement that logic. Instead we designed 2 separate
> programs for males and females, and it was not too bad to do so.
> On the other hand I also found the "sections" in the program stages quite
> useful too. But I had to give up the custom designed forms and go ahead
> with the auto generated forms, because when I designed the form, the
> section tab was no longer available.
> I think these experiences will help developers to make future changes.
> Thanks.
>
>
> *L.A. Neranga Prabhath*
> *Trainee - MSc in Medical Informatics*
> *Postgraduate Institute of Medicine*
> *University of Colombo-Sri Lanka.*
> *Telephone: +94772531559 <%2B94772531559>*
>
>
>
> On 23 July 2014 10:12, Knut Staring  wrote:
>
>> Related to this, we have a big form where most sections are very simple
>> and broken down only by gender, but one is also broken down by A LOT of age
>> groupings, so the auto-generated form becomes extremely wide and the users
>> have to scroll a lot horizontally. This also means it is very easy for them
>> to lose track of where they are, though of course they do have the little
>> box in the upper right corner which is meant to help with exactly those
>> cases.
>>
>> So, in general we are very happy with the autogenerated form (and it is
>> huge, with 10 sections), but would like to be able to customize the layout
>> for this particular section (actually, the IDEAL option would be to be able
>> to specify the width of the cells - as we could well have cells only a
>> third of the automatic width).
>>
>> I suppose the best solution for now is to separate out this particular
>> section into a separate form, but are we planning to support custom forms
>> for sections?
>>
>> Knut
>>
>>
>>
>>
>> On Wed, Jul 23, 2014 at 6:23 AM,  wrote:
>>
>>>  Hi all developers,
>>> *MY SUGGESTION:*
>>> In “section grey field management” of combo category options. Has
>>> only “Disable field” for disable entry value. But I think it is
>>> important, we should have “Hide field” to hide some combo category. Because
>>> it effect on showing in Data Entry, if we has many combo category option
>>> cross with data element.
>>>
>>> thank you
>>> CHANNARA
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> 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
>
>
___
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 import to a Dataset linked to a combination of categories

[Lars Helge Øverland]

Hi Maheed,

okay thanks. Can't promise to fix that right now but we will implement it
and back-port to 2.16 shortly.

best regards,

Lars





On Wed, Jul 23, 2014 at 8:05 AM, Maheed Ramadan 
wrote:

>  Hi Lars,
>
>
>
> Thanks very much for considering this issue and including it in the next
> version. I will check it and see how it works.
>
>
>
> In relation to this bug/fix, there is one place that should also be fixed.
> This is when you navigate to a Dataset (configured with an attribute
> category combo), then try to *Get PDF for Data entry.* It turns out that
> the generated PDF is missing the option to select the attribute
> combination. It only includes the PERIOD & ORG Units.
>
>
>
> It will be perfect if this can also be resolved in 2.16 because using PDF
> method for importing data is also very important and useful.
>
>
>
> On last question. Any idea when will 2.16 be released?
>
>
>
>
>
> Thank you again for your continuous support.
>
>
>
>
>
> Best Regards,
>
>
>
> Maheed
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Tuesday, July 22, 2014 7:46 PM
>
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> Hi Maheed,
>
>
>
> I agree with you. I have implemented it now in trunk for XML and CSV. Will
> be part of 2.16. You can try it from the CI server in 40 min:
>
>
>
> https://apps.dhis2.org/ci/job/dhis-trunk/
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
>
>
> On Tue, Jul 22, 2014 at 10:42 AM, Maheed Ramadan 
> wrote:
>
>  Hello Lars,
>
>
>
> As you know, we are still investigating the DHIS system to see if we can
> use it in our organization.
>
> Actually, we started implementing a small pilot project in one country
> area and we are trying to collect the data and move it into DHIS and then
> analyze it and create some reports.
>
>
>
> A requirement in our design is to have all our datasets be linked to a
> category combination attribute which allows us to add another dimension to
> our data entry forms. The extra dimension we need to specify is the actual
> “Project” that will be linked to the data in addition to the org unit and
> period dimensions.
>
>
>
> Since we have a lot of data that we need to push into DHIS, we need a
> quick and fast solution for this and the only path we have is to import
> this data from an external source (i.e. Excel/CSV file). As you know, the
> data import tool still does not support datasets with custom category
> combination.
>
>
>
> Honestly I was following up and reviewing all recent updates to the system
> including bugs and blueprints and I was shocked when I found that this bug
> è (Import) Attribute option combos in import
> 
>  has
> been moved/postponed to milestone 2.17 !!!
>
>
>
> For us, this is a very important & critical feature to have for the
> reasons mentioned above. Our decision to use DHIS is highly based on the
> import functionality. Not having this functionality will prevent us to move
> forward.
>
>
>
> We were hoping that this will be resolved in milestone 2.16 so waiting for
> this release was not a big deal. However, this is a problem if we have to
> wait 3-4 months until 2.17 is released.
>
>
>
> Sorry Lars for all these details. I don’t know if this issue could be
> revised from your side and be included in the upcoming release? We like the
> system and we appreciate your support with all the developers contributing
> to make it successful.
>
>
>
> As a final request, is there any possible solution that we could use to
> get data in batch into DHIS, taking into consideration the requirement we
> have? This could be a turnaround or a temporary solution until the issue is
> resolved.
>
>
>
>
>
> Thanks a lot.
>
> Hope to hear from you soon….
>
>
>
>
>
> Maheed.
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Wednesday, July 02, 2014 12:17 PM
>
>
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> Hi there,
>
>
>
> according to schedule we will release on July 4th. It seems that we will
> need some extra days to wrap up the last features.
>
>
>
> cheers
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 11:13 AM, Maheed Ramadan 
> wrote:
>
>  Hello Lars,
>
>
>
> Thanks for the quick response. Hoping this issue can be resolved soon.
>
>
>
> One question please. When do you think the next version of DHIS (i.e.
> 2.16) will be released?
>
>
>
>
>
> Thanks again.
>
>
>
> Maheed
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshe...@gmail.com]
> *Sent:* Wednesday, July 02, 2014 11:12 AM
> *To:* Maheed Ramadan
> *Cc:* dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users

[Dhis2-users] need solution for running out of disk space generating analytics tables

[Lavi Shpigelman]

Hi
I am experimenting with a non-production instance of dhis2 (version 2.15).
After I imported data from a production instance (using web api), the
postgres user's home directory takes 7.5 GB
I have 99GB of available disk space
When I try to generate the analytics tables, I run out of disk space (does
this make any sense?)

My dhis2 instance has some historical data going back 10+ years.
Perhaps if analytics tables were generated for only the last couple of
years, it would fit in the available disk space?

1. I don't mind throwing away data before 2010. Is there an easy way to
purge all older data?
2. Is there a way to tell dhis2 to generate analytics data for only 2010
and onward?

Best regards,
Lavi
___
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