[Dhis2-users] Mission: DHIS2 Training specialist in Kyrgystan
Hello DHIS2 community, We are reaching out to the community to reinforce Bluesquare's DHIS2 team for an opportunity we are pitching on in Kyrgystan (it is a project is funded by giz). Specific tasks we would be looking for additional support on include: - propose a methodology and the set of tasks to address the issue of training a pool of DHIS2 experts in Russian language through the use of a short-term expert. - develop strategic partnerships between academic institutes and the Health Information System Program (HISP) from Oslo University are encouraged (i.e. Kyrgyz technical academy, Kyrgyz medical academy, etc.) to promote sustainable training capacities. Ideally someone with 10 years experience in DHIS2 and in Development Cooperation. The total days support requested are: 20 days in country - with 4 travel days. We are looking for an interested candidate would who be available to support us on this bid. Please do not hesitate to let me know if you have any questions or if we can provide any additional clarifications. Kind regards, The Bluesquare Team -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Metadata audit for user class
Hello, Can the Metadata audit feature work for modification to Users? Ie, is User a metadata in this case? We have situations where rights where added/removed and we are asked to check who did the modification for auditing purposes. Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] User manuals translation?
Thanks, I understand the effort needed and most technical profile I know can read english, so I suppose this is both huge and difficult to priorise. A sort of "stupid" id - could we not start by putting the whole manual (or the various XML parts) through google translate as a basis, and accept contributions from that point? I tested it, it is surprinsingly good. Martin On Wed, Jun 13, 2018 at 8:16 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Martin, > Unfortunately, that version of the manual is extremely out of date and > incomplete. It has not been updated in a number of years. > > The translation process is currently a community driven one, with limited > support from the core team. The core team maintains a translation server ( > https://translate.dhis2.org) for the software. > > Community contributions would certainly be welcome and if there are > specific questions about how to get started, please let me know. > > Regards, > Jason > > > On Wed, Jun 13, 2018 at 7:53 AM Martin Van Aken > wrote: > >> Hi, >> Some of our users are French speaking, and while I know the interface is >> translated, are some of the doc (user or even implementer manual) available >> in French somewhere? >> >> I though not then found a GitHub repo here: https://github.com/dhis2/ >> dhis2-docs-fr but I'm unsure about the status (one year old is not that >> bad if needed). >> >> Is there a goal to drive such an effort, possibly community driven? >> >> Martin >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> ___ >> 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 > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] User manuals translation?
Hi, Some of our users are French speaking, and while I know the interface is translated, are some of the doc (user or even implementer manual) available in French somewhere? I though not then found a GitHub repo here: https://github.com/dhis2/dhis2-docs-fr but I'm unsure about the status (one year old is not that bad if needed). Is there a goal to drive such an effort, possibly community driven? Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Setting default values for some data elements
Hi, We have some data entry for which there should be default values (ie: they are very common, could be overwritten but typically won't be). What would be a way to achieve this in DHIS2? I think I could make it work with predictors, any easier way? Thanks! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Get tracker entity instance id from an event analytics query
Hi! I'm retrieving a bunch of events through the event analytics API and I would like to be able to get their related TrackerEntityInstance - I can see those using the api/events endpoint, but I did not find a way to get them directly out of the analytics query. Is there anyway to get them (else I'll have do to a second query on the /events end point, which is possible but cumbersome). Ie, I've a query like this: api/25/analytics/events/query/jqKm7VLgdzL?stage=tbLC6IHktf0=pe:2017;2018=ou:USER_ORGUNIT - how could I get the tei associated with each event that is returned? Thanks! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Hiring a DHIS2 Specialist (Belgium)
Hi DHIS2 Community! We are Bluesquare, a company active in health financing based in Brussels, Bujumbura and Kinshasa. Our mission is to help health resources to go where they are needed the most. Due to increasing interest by our various users, we are hiring a DHIS2 Specialist to help us with configuration and best practices all around DHIS2, from Predictors to Tracker stages and Alerts. More information about working with us: https://bluesquarehub.com/about-us/vacancies/ and the specific position here: https://bluesquarehub.com/about-us/vacancies/dhis2-specialist/ Don't hesitate to get in touch! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Program Indicator using data from multiple event stages to find TEA
Ok, thanks for the clarification. I'll check our concrete situation and see what are our options there. Martin On Wed, Feb 14, 2018 at 10:39 AM, Markus Bekken <mar...@dhis2.org> wrote: > Hi Martin, > to my knowledge the parenthesis work in general, with the exception of > passing parenthesis into the d2:condition() function: DHIS2-2813 > <https://jira.dhis2.org/browse/DHIS2-2813> > > You would be able to write parenthesis in program indicators expressions > and filters. What is not supported is nested d2: function calls. > > Please report if you experience problems with parenthesis outside the > known issue above. > > Markus > > 14. feb. 2018 kl. 08:30 skrev Martin Van Aken <mar...@joyouscoding.com>: > > Hi everyone. > > Thanks Lars for the answer - we face problems with priorities (hence > needing parenthesis) there too. Glad to know this will be solved, but what > would be the possible workarounds in the meantime? I wanted to decompose in > different indicators, but programIndicators can't use other > programIndicators (like the "aggregate" indicators does), correct? Any > other way we would apply our proper priorities ? > > Thanks, > > Martin > > On Wed, Feb 14, 2018 at 8:18 AM, Lars Helge Øverland <l...@dhis2.org> > wrote: > >> HI Aaron, >> >> that sounds good, glad to hear you got cross-stage calculations to work. >> >> Unfortunately program indicator expressions do not support nested >> parentheses/functions - we plan to develop a new version of our program >> indicator parser which will be more flexible in this regard. >> >> regards, >> >> Lars >> >> >> On 13 February 2018 at 20:56, Aaron C White <aaroncwh...@gmail.com> >> wrote: >> >>> Thanks, Lars and Preeti. I checked the indicator formulation and found >>> a problem with a d2:condition() statement using a text option set value. I >>> converted it to an integer and was able to see the calculated data across >>> stages. I think it might be related to the parentheses issue inside the >>> condition as a few other recent emails have suggested. How should the >>> condition be formulated if you also need to check a text option inside that >>> condition? Using double quotes on the outside of the formulation does not >>> seem to work properly. i.e. d2:condition("my_de == '3'", true, false) >>> >>> Aaron >>> >>> >>> -- >>> Aaron C. White >>> 919.522.5585 <(919)%20522-5585> >>> >>> On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland <l...@dhis2.org> >>> wrote: >>> >>>> Hi Aaron, >>>> >>>> from your description I think enrollment type program indicators will >>>> be appropriate. Can you tell us a bit more about your usecase? I am >>>> assuming you want information from two different stages in the *same* >>>> program. Do you have multiple enrollments per person (TEI) in your program? >>>> If not I think enrollment indicators will do the job. >>>> >>>> regards, >>>> >>>> Lars >>>> >>>> >>>> On 8 February 2018 at 21:49, Aaron C White <aaroncwh...@gmail.com> >>>> wrote: >>>> >>>>> Hi all, >>>>> >>>>> I'm trying to create a program indicator (or just query to the API >>>>> directly) that evaluates conditions on data elements from two different >>>>> event stages and then be used to find a relevant tracked entity attribute. >>>>> >>>>> From the docs, it seems that a program indicator type of enrollment >>>>> would be most appropriate, but this only works at the aggregate level and >>>>> not at an individual tracked entity instance level. When I use an event >>>>> type indicator, I don't receive any values back because the indicator >>>>> definition contains data from two stages. >>>>> >>>>> Am I correct in this assessment? Any thoughts on how to get around >>>>> this? >>>>> >>>>> I've been testing on a v2.28 instance. A similar reference example >>>>> from the demo server would be the "Weight gain(in g) between birth and >>>>> last >>>>> postnatal for Child Programme" program indicator. The one change would be >>>>> that I want to see the weight gain for individual TEIs and view a TEA >>>>> based >>>>>
Re: [Dhis2-users] [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA
Hi everyone. Thanks Lars for the answer - we face problems with priorities (hence needing parenthesis) there too. Glad to know this will be solved, but what would be the possible workarounds in the meantime? I wanted to decompose in different indicators, but programIndicators can't use other programIndicators (like the "aggregate" indicators does), correct? Any other way we would apply our proper priorities ? Thanks, Martin On Wed, Feb 14, 2018 at 8:18 AM, Lars Helge Øverland <l...@dhis2.org> wrote: > HI Aaron, > > that sounds good, glad to hear you got cross-stage calculations to work. > > Unfortunately program indicator expressions do not support nested > parentheses/functions - we plan to develop a new version of our program > indicator parser which will be more flexible in this regard. > > regards, > > Lars > > > On 13 February 2018 at 20:56, Aaron C White <aaroncwh...@gmail.com> wrote: > >> Thanks, Lars and Preeti. I checked the indicator formulation and found a >> problem with a d2:condition() statement using a text option set value. I >> converted it to an integer and was able to see the calculated data across >> stages. I think it might be related to the parentheses issue inside the >> condition as a few other recent emails have suggested. How should the >> condition be formulated if you also need to check a text option inside that >> condition? Using double quotes on the outside of the formulation does not >> seem to work properly. i.e. d2:condition("my_de == '3'", true, false) >> >> Aaron >> >> >> -- >> Aaron C. White >> 919.522.5585 <(919)%20522-5585> >> >> On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland <l...@dhis2.org> >> wrote: >> >>> Hi Aaron, >>> >>> from your description I think enrollment type program indicators will be >>> appropriate. Can you tell us a bit more about your usecase? I am assuming >>> you want information from two different stages in the *same* program. >>> Do you have multiple enrollments per person (TEI) in your program? If not I >>> think enrollment indicators will do the job. >>> >>> regards, >>> >>> Lars >>> >>> >>> On 8 February 2018 at 21:49, Aaron C White <aaroncwh...@gmail.com> >>> wrote: >>> >>>> Hi all, >>>> >>>> I'm trying to create a program indicator (or just query to the API >>>> directly) that evaluates conditions on data elements from two different >>>> event stages and then be used to find a relevant tracked entity attribute. >>>> >>>> From the docs, it seems that a program indicator type of enrollment >>>> would be most appropriate, but this only works at the aggregate level and >>>> not at an individual tracked entity instance level. When I use an event >>>> type indicator, I don't receive any values back because the indicator >>>> definition contains data from two stages. >>>> >>>> Am I correct in this assessment? Any thoughts on how to get around >>>> this? >>>> >>>> I've been testing on a v2.28 instance. A similar reference example >>>> from the demo server would be the "Weight gain(in g) between birth and last >>>> postnatal for Child Programme" program indicator. The one change would be >>>> that I want to see the weight gain for individual TEIs and view a TEA based >>>> on the weight gain amount instead of the average over all tracked entity >>>> instances. >>>> >>>> Thanks in advance, >>>> >>>> Aaron >>>> >>>> -- >>>> Aaron C. White >>>> 919.522.5585 <(919)%20522-5585> >>>> >>>> ___ >>>> 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 >>>> >>>> >>> >>> >>> -- >>> Lars Helge Øverland >>> Lead developer, DHIS 2 >>> University of Oslo >>> Skype: larshelgeoverland >>> l...@dhis2.org >>> http://www.dhis2.org <https://www.dhis2.org/> >>> >>> >> > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > > ___ > 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 > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Problem with the d2:condition function in program operator
Just tried, it works! This will help me & more importantly some users a lot! Long history of being bitten by operator priorities, so I tend to go the "non ambiguous way". Are the operator priorities documented somewhere (I expect the "standard math ones", but better safe than sorry) Thanks for the quick answer - I'll fill the Jira. A very small fix would be to add this to the doc - if the doc is on GitHub I'll gladly submit a PR. Martin On Wed, Feb 7, 2018 at 9:05 AM, Markus Bekken <mar...@dhis2.org> wrote: > Hi Martin, > I think it is the parenthesis within the condition that breaks the > evaluation. When I would always argue for adding the parenthesis for the > clarity of reading the expression, I think you are in luck here - if you > remove all the parenthesis your numerical operators will be applied in the > same order even if you remove them. > > Please consider registering an issue on the parenthesis problem if it > turns out to be the source of the problem. > > Best regards > Markus > > 7. feb. 2018 kl. 08:46 skrev Martin Van Aken <mar...@joyouscoding.com>: > > Hello, > I'm trying to create a program indicator which would evaluate if a ratio > is equal higher than 80 and return 1 or 0 if not the case. > > This is what I have in the expression: > > d2:condition('((#{tbLC6IHktf0.CpOPiHrFG8C} * 100) / > #{tbLC6IHktf0.spWKINz7xwF}) >= 80', 100, 0) > > The program indicator show the expression as valid, but when I try to use > it in a event report, I get this error: > > "Illegal arguments, expected 3 arguments: condition, true-value, > false-value." > > I tested the ratio separately and it works. > > Any one have any insight of what could be wrong there? I could not find a > lot of public examples using d2:condition so I may have done a basic > mistake here. > > Thanks ! > > Martin > > -- > *Martin Van Aken - **Freelance Enthusiast Developer* > > Mobile : +32 486 899 652 > > Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> > Call me on Skype : vanakenm > Hang out with me : mar...@joyouscoding.com > Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken > Company website : www.joyouscoding.com > ___ > 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 > > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Problem with the d2:condition function in program operator
Hello, I'm trying to create a program indicator which would evaluate if a ratio is equal higher than 80 and return 1 or 0 if not the case. This is what I have in the expression: d2:condition('((#{tbLC6IHktf0.CpOPiHrFG8C} * 100) / #{tbLC6IHktf0.spWKINz7xwF}) >= 80', 100, 0) The program indicator show the expression as valid, but when I try to use it in a event report, I get this error: "Illegal arguments, expected 3 arguments: condition, true-value, false-value." I tested the ratio separately and it works. Any one have any insight of what could be wrong there? I could not find a lot of public examples using d2:condition so I may have done a basic mistake here. Thanks ! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Event Report (Events) - select data items which have no value
Hello ! Good to know, thanks. To be fair - the doc does not refer to any support of a null operator, I just tried my luck there. I'll try Aaron logic - if I can create an indicator whose value would be 0 when the 'main' indicator has no value, I got a proxy for my query which is all I need. I'll follow the jira anyway. Martin On Tue, Feb 6, 2018 at 5:46 AM, Prosper BT <ptb3...@gmail.com> wrote: > Dear Martin, > > Refer to this jira issues DHIS2-1219 > <https://jira.dhis2.org/browse/DHIS2-1219> requesting additional support > for Null and missing in Events report filters > Its to be done in 2.30 > > Regards > > Prosper Behumbiize, MPH > DHIS2 Implementation Adviser| HISP Uganda > pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype: > prospertb > > On Tue, Feb 6, 2018 at 12:57 AM, Abyot Asalefew Gizaw <ab...@dhis2.org> > wrote: > >> Hi, >> >> Seems we have a bug there... please file a JIRA issue and we would >> address it as soon as we can. >> >> Otherwise, since 2.25 on we have introduced support to filter events >> based on data element values. You can play around with columns of the event >> grid in event capture app to see the request url sent to server. Below is >> an example >> >> https://play.dhis2.org/dev/api/28/events/query.json?orgUnit= >> DiszpKrYNg8=Zj7UnCAulEk=qrur9Dvnyt5:GT:10:LT:100 >> =qrur9Dvnyt5,S33cRBsnXPo,fWIAEtYVEGk,K6uUAvq500H& >> order=lastUpdated:desc=50=1=true >> >> It goes by something like >> >> *api/events/query?filter=DATAELEMENT_UID:OPERATOR:VALUE* >> >> *api/events/query?filter=DATAELEMENT_UID:EQ:NULL* >> >> Unfortunately, we have a bug in handling NULL as part of the query >> parameter. >> >> -- >> Abyot A. Gizaw. >> Senior Engineer, DHIS2 >> University of Oslo >> http://www.dhis2.org >> >> On Mon, Feb 5, 2018 at 10:01 PM, Martin Van Aken <mar...@joyouscoding.com >> > wrote: >> >>> Ok, got it, I was missing some context. Looks an interesting way to >>> actually tackle some of the "queries" I have to do for a project. >>> >>> Thanks a lot! >>> >>> Martin >>> >>> On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White <aaroncwh...@gmail.com> >>> wrote: >>> >>>> I just had to tackle something similar recently, so it's fresh on my >>>> mind. The functions are built in to DHIS2 (but I believe are part of the >>>> JEXL library according to the docs).You would need to create the >>>> program indicator first, run analytics, and then request the program >>>> indicator instead of the data element in question. I don't think you >>>> can use it to hit the analytics endpoint directly. You can find some >>>> examples and more detail here >>>> <https://docs.dhis2.org/2.28/en/user/html/configure_program_indicator.html#program_indicator_functions_variables_operators> >>>> . >>>> >>>> Aaron >>>> >>>> >>>> -- >>>> Aaron C. White >>>> 919.522.5585 <(919)%20522-5585> >>>> >>>> On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken < >>>> mar...@joyouscoding.com> wrote: >>>> >>>>> Would not have though of that approach - your examples uses the d2 JS >>>>> library? Are those "operators" usable in a analytics/events/query filter >>>>> string? (tried the "aggregate" null operator, but it did not work) >>>>> >>>>> Thanks ! >>>>> >>>>> Martin >>>>> >>>>> On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White <aaroncwh...@gmail.com> >>>>> wrote: >>>>> >>>>>> Martin, >>>>>> >>>>>> What if you made a program indicator with inverse logic? Something >>>>>> like "!d2:hasValue(#{your_de_uid})", since if the value is numeric >>>>>> "d2:oizp(#{your_de_uid})". d2:oizp returns 1 if the value is zero or >>>>>> positive and otherwise returns 0. I bet one of those or a combination >>>>>> would solve that problem. >>>>>> >>>>>> Aaron >>>>>> >>>>>> >>>>>> -- >>>>>> Aaron C. White >>>>>> 919.522.5585 <(919)%20522-5585> >>>>>> >>>>>> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Ak
Re: [Dhis2-users] Event Report (Events) - select data items which have no value
Ok, got it, I was missing some context. Looks an interesting way to actually tackle some of the "queries" I have to do for a project. Thanks a lot! Martin On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White <aaroncwh...@gmail.com> wrote: > I just had to tackle something similar recently, so it's fresh on my > mind. The functions are built in to DHIS2 (but I believe are part of the > JEXL library according to the docs).You would need to create the > program indicator first, run analytics, and then request the program > indicator instead of the data element in question. I don't think you can > use it to hit the analytics endpoint directly. You can find some > examples and more detail here > <https://docs.dhis2.org/2.28/en/user/html/configure_program_indicator.html#program_indicator_functions_variables_operators> > . > > Aaron > > > -- > Aaron C. White > 919.522.5585 <(919)%20522-5585> > > On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Would not have though of that approach - your examples uses the d2 JS >> library? Are those "operators" usable in a analytics/events/query filter >> string? (tried the "aggregate" null operator, but it did not work) >> >> Thanks ! >> >> Martin >> >> On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White <aaroncwh...@gmail.com> >> wrote: >> >>> Martin, >>> >>> What if you made a program indicator with inverse logic? Something like >>> "!d2:hasValue(#{your_de_uid})", since if the value is numeric >>> "d2:oizp(#{your_de_uid})". d2:oizp returns 1 if the value is zero or >>> positive and otherwise returns 0. I bet one of those or a combination >>> would solve that problem. >>> >>> Aaron >>> >>> >>> -- >>> Aaron C. White >>> 919.522.5585 <(919)%20522-5585> >>> >>> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken < >>> mar...@joyouscoding.com> wrote: >>> >>>> Hi everyone, >>>> We are interested to get an event report with all events where a >>>> specific data item has no value (ie, not 0, no value at all). We're on >>>> 2.26, an all the conditins available are <, <=, =, > etc. >>>> >>>> Putting "=" then an empty field does not filter anything, and in this >>>> case "0" is taken as a separated value than "no value". >>>> >>>> Is there any way to do this? >>>> >>>> Thanks, >>>> >>>> Martin >>>> >>>> -- >>>> *Martin Van Aken - **Freelance Enthusiast Developer* >>>> >>>> Mobile : +32 486 899 652 >>>> >>>> Follow me on Twitter : @martinvanaken >>>> <http://twitter.com/martinvanaken> >>>> Call me on Skype : vanakenm >>>> Hang out with me : mar...@joyouscoding.com >>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>>> Company website : www.joyouscoding.com >>>> >>>> ___ >>>> 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 >>>> >>>> >>> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Event Report (Events) - select data items which have no value
Would not have though of that approach - your examples uses the d2 JS library? Are those "operators" usable in a analytics/events/query filter string? (tried the "aggregate" null operator, but it did not work) Thanks ! Martin On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White <aaroncwh...@gmail.com> wrote: > Martin, > > What if you made a program indicator with inverse logic? Something like > "!d2:hasValue(#{your_de_uid})", since if the value is numeric > "d2:oizp(#{your_de_uid})". d2:oizp returns 1 if the value is zero or > positive and otherwise returns 0. I bet one of those or a combination > would solve that problem. > > Aaron > > > -- > Aaron C. White > 919.522.5585 <(919)%20522-5585> > > On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi everyone, >> We are interested to get an event report with all events where a specific >> data item has no value (ie, not 0, no value at all). We're on 2.26, an all >> the conditins available are <, <=, =, > etc. >> >> Putting "=" then an empty field does not filter anything, and in this >> case "0" is taken as a separated value than "no value". >> >> Is there any way to do this? >> >> Thanks, >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Event Report (Events) - select data items which have no value
Hi everyone, We are interested to get an event report with all events where a specific data item has no value (ie, not 0, no value at all). We're on 2.26, an all the conditins available are <, <=, =, > etc. Putting "=" then an empty field does not filter anything, and in this case "0" is taken as a separated value than "no value". Is there any way to do this? Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] New DHIS2 App - Meta Navigator
Hi DHIS2 community, Part to solve a personal need, part to learn more about DHIS2 Apps, I've created a small "DHIS2 Meta Navigator" - basically a way to navigate through any Meta (Organisation Unit, Data Element, etc). The code (under a MIT licence) and a quick demo are available here: https://github.com/vanakenm/dhis2-meta-navigator - I also installed it on the https://play.dhis2.org/2.27/ version. Any feedback is most welcome - if this could fill a need don't hesitate to let me know. Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Import/Export data between similar but distinct systems
Hello DHIS2 community, We need to make frequent import/export between two different DHIS2 systems. While they are similar and the format "fits", we know some differences, mainly: - The org units concerned exist on both sides but with different ids - Same for the data elements - In some situation, the export value may be an indicator, to be imported in a data element I can imagine making the export in CSV, then having a "matching sheet" in XLS with the link between OU in the source system and OU in the destination system. Is someone doing those kind of operations? What's your typical flow/way of working? I think I remember Lars presenting some feature helping with this on one of the last DHIS2 releases, but I'm not sure. Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Check how many time reports are generated
Yep, that's the road we are raking right now, but interesting to know there is something inside DHIS2 for the job. Thanks! Martin On Wed, Oct 4, 2017 at 12:13 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Martin, > You can also use Google Analytics for this task probably or any number of > tools to parse the DHIS2/Nginx logs. > > Regards, > Jason > > > On Wed, Oct 4, 2017 at 4:19 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Thanks! No luck for me right now but interesting nonetheless. I'll have a >> look at the provided examples. >> >> Martin >> >> On Wed, Oct 4, 2017 at 11:04 AM, Lars Helge Øverland <l...@dhis2.org> >> wrote: >> >>> Hi Martin, >>> >>> we do have a web API endpoint that supports usage statistics for most >>> analytical entities (pivot table, chart, map..) _except_ for standard >>> reports. >>> >>> https://docs.dhis2.org/master/en/developer/html/webapi_usage >>> _analytics.html >>> >>> If you want to create a patch and extend this to include standard >>> reports (html reports) you can look at the following classes: >>> >>> DataStatistics.java >>> DataStatisticsEventType.java >>> DataStatisticsController.java >>> GetReportAndParamsAction.java >>> >>> >>> regards, >>> >>> Lars >>> >>> >>> >>> >>> On Wed, Oct 4, 2017 at 9:16 AM, Martin Van Aken <mar...@joyouscoding.com >>> > wrote: >>> >>>> Hello DHIS2 community, >>>> >>>> We have a set of custom reports we built for a customer, and I'm >>>> interested to follow which one are used (and how often). >>>> >>>> Is there any way to retrieve how many times a given report has been >>>> generated? I'm talking about HTML reports in this case some something like: >>>> >>>> http://DHIS2_urL/dhis-web-reporting/generateHtmlReport.actio >>>> n?uid=ThScKdiP4Cp=201708=eov2pDYbAK0 >>>> >>>> Does DHIS2 stores something about it anywhere? >>>> >>>> Thanks, >>>> >>>> Martin >>>> >>>> -- >>>> *Martin Van Aken - **Freelance Enthusiast Developer* >>>> >>>> Mobile : +32 486 899 652 >>>> >>>> Follow me on Twitter : @martinvanaken >>>> <http://twitter.com/martinvanaken> >>>> Call me on Skype : vanakenm >>>> Hang out with me : mar...@joyouscoding.com >>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>>> Company website : www.joyouscoding.com >>>> >>>> ___ >>>> 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 <https://www.dhis2.org/> >>> >>> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 <+46%2076%20414%2070%2049> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Check how many time reports are generated
Thanks! No luck for me right now but interesting nonetheless. I'll have a look at the provided examples. Martin On Wed, Oct 4, 2017 at 11:04 AM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi Martin, > > we do have a web API endpoint that supports usage statistics for most > analytical entities (pivot table, chart, map..) _except_ for standard > reports. > > https://docs.dhis2.org/master/en/developer/html/webapi_ > usage_analytics.html > > If you want to create a patch and extend this to include standard reports > (html reports) you can look at the following classes: > > DataStatistics.java > DataStatisticsEventType.java > DataStatisticsController.java > GetReportAndParamsAction.java > > > regards, > > Lars > > > > > On Wed, Oct 4, 2017 at 9:16 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello DHIS2 community, >> >> We have a set of custom reports we built for a customer, and I'm >> interested to follow which one are used (and how often). >> >> Is there any way to retrieve how many times a given report has been >> generated? I'm talking about HTML reports in this case some something like: >> >> http://DHIS2_urL/dhis-web-reporting/generateHtmlReport.actio >> n?uid=ThScKdiP4Cp=201708=eov2pDYbAK0 >> >> Does DHIS2 stores something about it anywhere? >> >> Thanks, >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Check how many time reports are generated
Hello DHIS2 community, We have a set of custom reports we built for a customer, and I'm interested to follow which one are used (and how often). Is there any way to retrieve how many times a given report has been generated? I'm talking about HTML reports in this case some something like: http://DHIS2_urL/dhis-web-reporting/generateHtmlReport.action?uid=ThScKdiP4Cp=201708=eov2pDYbAK0 Does DHIS2 stores something about it anywhere? Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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 2 to support PostgreSQL only?
Hi Lars, Make a lot of sense, and would free time in your team to provide more value (seems you are not lacking ideas). I would say go for it, with maybe dedicated documentation about how to move (even if it's basically using the import/export feature "as is", may be worth a couple of hours to write a step by step guide). Martin On Fri, Sep 8, 2017 at 10:26 AM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi all, > > I want to bring up the idea of solely support PostgreSQL for DHIS 2 for > production use to get feedback from the community. > > The DHIS 2 team is seeing clear benefits of moving to PostgreSQL-only. The > main ones are: > > 1. Supporting and testing for more than one database platform is > time-consuming. The majority of DHIS 2 implementations is using PostgreSQL > already. > > 2. PostgreSQL supports advanced geospatial features through PostGIS. We > are already depending on these for the GIS module to work optimally (i.e. > for event clustering in GIS). There are no direct equivalent in e.g. MySQL. > We are also considering using PostGIS data types in main data model. > > 3. PostgreSQL will provide some impressive features which will become very > useful for us in version 10 > <https://wiki.postgresql.org/wiki/New_in_postgres_10> and 11. E.g. native > partitioning, parallel queries, logical replication, foreign tables and > improved query performance will be useful and allow us to develop the next > DHIS 2 analytics solution. > > > We are aware this will be inconvenient for users of other databases such > as MySQL, but there is the option of migrating your database through the > DHIS 2 metadata and data value import-export feature. > > On a technical note, we will keep the Hibernate development framework and > keep supporting the H2 database for unit testing purposes. > > Please let us know your thoughts on this. > > regards, > > Lars > > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://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 > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Interoperability of ODK & DHIS2
Interesting, thanks! Martin On Fri, Sep 1, 2017 at 10:23 AM, Knut Staring <knu...@gmail.com> wrote: > Hi Carlos, > > You can also have a look here: > https://github.com/hispindia/dhis-odk-integration > > Knut > > On Wed, Aug 30, 2017 at 11:47 AM, Martin Van Aken <mar...@joyouscoding.com > > wrote: > >> Hi Carlos, >> We (bluesquarehub.com) have been doing this for several of our customers >> as part as a (commercial) product. While I can't share the code, I'll be >> happy to discuss about the lessons learned, and to better understand your >> needs to see if our cases are similar. >> >> Don't hesitate to contact me if interested. >> >> Regards, >> >> Martin >> >> On Tue, Aug 29, 2017 at 3:24 PM, Carlos Nyembwe <nyem...@gmail.com> >> wrote: >> >>> Hello All >>> >>> I'm starting to do that, now I need a help about the main points what I >>> must set up before using this >>> >>> Regards >>> >>> -- >>> *Carlos Nyembwe* >>> *I'm just a Computer Scientist* >>> >>> *Skype: carloscnk1* >>> *Cell: (+243)813166381 <+243%20813%20166%20381>* >>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | >>> **Linkedin >>> <http://www.linkedin.com/in/carloscnk> | Facebook >>> <https://www.facebook.com/carloscnksys> | Twitter >>> <https://twitter.com/Carlos_CNK> |* >>> >>> ___ >>> 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 >>> >>> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 > Norway: +4791880522 <+47%20918%2080%20522> > Skype: knutstar > http://dhis2.org > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Interoperability of ODK & DHIS2
Hi Carlos, We (bluesquarehub.com) have been doing this for several of our customers as part as a (commercial) product. While I can't share the code, I'll be happy to discuss about the lessons learned, and to better understand your needs to see if our cases are similar. Don't hesitate to contact me if interested. Regards, Martin On Tue, Aug 29, 2017 at 3:24 PM, Carlos Nyembwe <nyem...@gmail.com> wrote: > Hello All > > I'm starting to do that, now I need a help about the main points what I > must set up before using this > > Regards > > -- > *Carlos Nyembwe* > *I'm just a Computer Scientist* > > *Skype: carloscnk1* > *Cell: (+243)813166381 <+243%20813%20166%20381>* > *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | > **Linkedin > <http://www.linkedin.com/in/carloscnk> | Facebook > <https://www.facebook.com/carloscnksys> | Twitter > <https://twitter.com/Carlos_CNK> |* > > ___ > 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 > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Timeout when updating large organisation unit group in large instance (2.23)
Not sure I understand what you mean? Agree that the logical path is the upgrade. Martin On Mon, Aug 28, 2017 at 10:20 PM, Morten Olav Hansen <mor...@dhis2.org> wrote: > Sure, but if you are on 2.23... dot dot dot... some concessions has to be > made > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Tue, Aug 29, 2017 at 2:07 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Agree on the upgrade but not every system we support is ours - ie >> decision not 100% in our hands. We manage with the API for now, but that's >> not practical for end users. >> >> Martin >> >> On Mon, Aug 28, 2017 at 8:47 PM, Morten Olav Hansen <mor...@dhis2.org> >> wrote: >> >>> If you are willing to do manual import (using the command line), in 223 >>> you can use /api/23/metadata I think... it will use the "new" importer.. >>> which should be quicker, please be aware that 223 is not supported anymore, >>> so please update ASAP if you can.. >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Tue, Aug 29, 2017 at 1:09 AM, Martin Van Aken < >>> mar...@joyouscoding.com> wrote: >>> >>>> Hi Morten, >>>> This is on 2.23 - I tried to manipulate big groups on the play demo >>>> instance and it goes well there. >>>> >>>> I'll try to get some logs. >>>> >>>> Martin >>>> >>>> On Mon, Aug 28, 2017 at 5:27 PM, Morten Olav Hansen <mor...@dhis2.org> >>>> wrote: >>>> >>>>> Hi Martin >>>>> >>>>> What version of DHIS2 are you on? if you are on 227 there is currently >>>>> a bug that has lowered performance in 227 vs the older versions (226, 225, >>>>> etc..) >>>>> >>>>> If you are not, if you could.. please file a JIRA issue and either >>>>> attach the org units, or email me directly >>>>> >>>>> -- >>>>> Morten Olav Hansen >>>>> Senior Engineer, DHIS 2 >>>>> University of Oslo >>>>> http://www.dhis2.org >>>>> >>>>> On Mon, Aug 28, 2017 at 10:14 PM, Martin Van Aken < >>>>> mar...@joyouscoding.com> wrote: >>>>> >>>>>> Hello Joseph, >>>>>> Thanks for the feedback. I'll try rh >>>>>> >>>>>> On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn < >>>>>> osbornlegr...@hotmail.fr> wrote: >>>>>> >>>>>>> Hello Martin, >>>>>>> >>>>>>> We had this problem with 2.22 or 2.23, the solution was to perform >>>>>>> these updates during off-peak hours, times when the server was not too >>>>>>> busy, so after 10pm, and it worked. >>>>>>> >>>>>>> But with 2.26 which has improved the analytic time and executions of >>>>>>> several queries, we do our updates even during the day. >>>>>>> >>>>>>> Regards. >>>>>>> >>>>>>> >>>>>>> Osborn >>>>>>> -- >>>>>>> *De :* Dhis2-devs <dhis2-devs-bounces+osbornlegrand= >>>>>>> hotmail...@lists.launchpad.net> de la part de Martin Van Aken < >>>>>>> mar...@joyouscoding.com> >>>>>>> *Envoyé :* lundi 28 août 2017 15:34:53 >>>>>>> *À :* Michael Mwebaze >>>>>>> *Cc :* dhis2-users; DHIS 2 Developers list >>>>>>> *Objet :* Re: [Dhis2-devs] [Dhis2-users] Timeout when updating >>>>>>> large organisation unit group in large instance (2.23) >>>>>>> >>>>>>> Got nothing until now but I'm investigating in that direction right >>>>>>> now. >>>>>>> >>>>>>> Thanks already for the pointer! >>>>>>> >>>>>>> Martin >>>>>>> >>>>>>> On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze < >>>>>>> michael.mweb...@gmail.com> wrote: >>>>>>> >>>>>>>> Hi Martin, >>>>>>>> >>>>>>>>
Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)
Agree on the upgrade but not every system we support is ours - ie decision not 100% in our hands. We manage with the API for now, but that's not practical for end users. Martin On Mon, Aug 28, 2017 at 8:47 PM, Morten Olav Hansen <mor...@dhis2.org> wrote: > If you are willing to do manual import (using the command line), in 223 > you can use /api/23/metadata I think... it will use the "new" importer.. > which should be quicker, please be aware that 223 is not supported anymore, > so please update ASAP if you can.. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Tue, Aug 29, 2017 at 1:09 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi Morten, >> This is on 2.23 - I tried to manipulate big groups on the play demo >> instance and it goes well there. >> >> I'll try to get some logs. >> >> Martin >> >> On Mon, Aug 28, 2017 at 5:27 PM, Morten Olav Hansen <mor...@dhis2.org> >> wrote: >> >>> Hi Martin >>> >>> What version of DHIS2 are you on? if you are on 227 there is currently a >>> bug that has lowered performance in 227 vs the older versions (226, 225, >>> etc..) >>> >>> If you are not, if you could.. please file a JIRA issue and either >>> attach the org units, or email me directly >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Mon, Aug 28, 2017 at 10:14 PM, Martin Van Aken < >>> mar...@joyouscoding.com> wrote: >>> >>>> Hello Joseph, >>>> Thanks for the feedback. I'll try rh >>>> >>>> On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn < >>>> osbornlegr...@hotmail.fr> wrote: >>>> >>>>> Hello Martin, >>>>> >>>>> We had this problem with 2.22 or 2.23, the solution was to perform >>>>> these updates during off-peak hours, times when the server was not too >>>>> busy, so after 10pm, and it worked. >>>>> >>>>> But with 2.26 which has improved the analytic time and executions of >>>>> several queries, we do our updates even during the day. >>>>> >>>>> Regards. >>>>> >>>>> >>>>> Osborn >>>>> -- >>>>> *De :* Dhis2-devs <dhis2-devs-bounces+osbornlegrand= >>>>> hotmail...@lists.launchpad.net> de la part de Martin Van Aken < >>>>> mar...@joyouscoding.com> >>>>> *Envoyé :* lundi 28 août 2017 15:34:53 >>>>> *À :* Michael Mwebaze >>>>> *Cc :* dhis2-users; DHIS 2 Developers list >>>>> *Objet :* Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large >>>>> organisation unit group in large instance (2.23) >>>>> >>>>> Got nothing until now but I'm investigating in that direction right >>>>> now. >>>>> >>>>> Thanks already for the pointer! >>>>> >>>>> Martin >>>>> >>>>> On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze < >>>>> michael.mweb...@gmail.com> wrote: >>>>> >>>>>> Hi Martin, >>>>>> >>>>>> do you have access to the Tomcat logs? If an exception is being >>>>>> thrown that would also be helpful to figure out what is happening. >>>>>> >>>>>> Regards, >>>>>> >>>>>> Michael >>>>>> >>>>>> On 28 August 2017 at 10:04, Martin Van Aken <mar...@joyouscoding.com> >>>>>> wrote: >>>>>> >>>>>>> Hi DHIS2 users & developers, >>>>>>> We have a relatively large instance of DHIS2 (30 000 org units) >>>>>>> where we have several groups that can make up to 3 000 org unit each. >>>>>>> >>>>>>> When trying to update them through the UX, our server get a timeout >>>>>>> (looking in the console for the network calls). >>>>>>> >>>>>>> The call is like this: >>>>>>> >>>>>>> /api/organisationUnitGroups/RZYPaa6gxq8?mergeMode=REPLACE >>>>>>> >>>>>>> When using the API, we get no problem but we typically add/remove >>>
Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)
Hi Morten, This is on 2.23 - I tried to manipulate big groups on the play demo instance and it goes well there. I'll try to get some logs. Martin On Mon, Aug 28, 2017 at 5:27 PM, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi Martin > > What version of DHIS2 are you on? if you are on 227 there is currently a > bug that has lowered performance in 227 vs the older versions (226, 225, > etc..) > > If you are not, if you could.. please file a JIRA issue and either attach > the org units, or email me directly > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, Aug 28, 2017 at 10:14 PM, Martin Van Aken <mar...@joyouscoding.com > > wrote: > >> Hello Joseph, >> Thanks for the feedback. I'll try rh >> >> On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn < >> osbornlegr...@hotmail.fr> wrote: >> >>> Hello Martin, >>> >>> We had this problem with 2.22 or 2.23, the solution was to perform these >>> updates during off-peak hours, times when the server was not too busy, so >>> after 10pm, and it worked. >>> >>> But with 2.26 which has improved the analytic time and executions of >>> several queries, we do our updates even during the day. >>> >>> Regards. >>> >>> >>> Osborn >>> -- >>> *De :* Dhis2-devs <dhis2-devs-bounces+osbornlegrand= >>> hotmail...@lists.launchpad.net> de la part de Martin Van Aken < >>> mar...@joyouscoding.com> >>> *Envoyé :* lundi 28 août 2017 15:34:53 >>> *À :* Michael Mwebaze >>> *Cc :* dhis2-users; DHIS 2 Developers list >>> *Objet :* Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large >>> organisation unit group in large instance (2.23) >>> >>> Got nothing until now but I'm investigating in that direction right now. >>> >>> Thanks already for the pointer! >>> >>> Martin >>> >>> On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze < >>> michael.mweb...@gmail.com> wrote: >>> >>>> Hi Martin, >>>> >>>> do you have access to the Tomcat logs? If an exception is being thrown >>>> that would also be helpful to figure out what is happening. >>>> >>>> Regards, >>>> >>>> Michael >>>> >>>> On 28 August 2017 at 10:04, Martin Van Aken <mar...@joyouscoding.com> >>>> wrote: >>>> >>>>> Hi DHIS2 users & developers, >>>>> We have a relatively large instance of DHIS2 (30 000 org units) where >>>>> we have several groups that can make up to 3 000 org unit each. >>>>> >>>>> When trying to update them through the UX, our server get a timeout >>>>> (looking in the console for the network calls). >>>>> >>>>> The call is like this: >>>>> >>>>> /api/organisationUnitGroups/RZYPaa6gxq8?mergeMode=REPLACE >>>>> >>>>> When using the API, we get no problem but we typically add/remove >>>>> relations one by one (so the call is very different). >>>>> >>>>> I tested on the last version on play and everything is working there, >>>>> but the version is quite different too. >>>>> >>>>> Is this something someone encountered already? Anything we could do to >>>>> avoid this ? >>>>> >>>>> Thanks, >>>>> >>>>> Martin >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> *Martin Van Aken - **Freelance Enthusiast Developer* >>>>> >>>>> Mobile : +32 486 899 652 >>>>> >>>>> Follow me on Twitter : @martinvanaken >>>>> <http://twitter.com/martinvanaken> >>>>> Call me on Skype : vanakenm >>>>> Hang out with me : mar...@joyouscoding.com >>>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>>>> Company website : www.joyouscoding.com >>>>> >>>>> ___ >>>>> 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 >>>>> >>&g
Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)
Hello Joseph, Thanks for the feedback. I'll try rh On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn <osbornlegr...@hotmail.fr> wrote: > Hello Martin, > > We had this problem with 2.22 or 2.23, the solution was to perform these > updates during off-peak hours, times when the server was not too busy, so > after 10pm, and it worked. > > But with 2.26 which has improved the analytic time and executions of > several queries, we do our updates even during the day. > > Regards. > > > Osborn > -- > *De :* Dhis2-devs <dhis2-devs-bounces+osbornlegrand=hotmail.fr@ > lists.launchpad.net> de la part de Martin Van Aken < > mar...@joyouscoding.com> > *Envoyé :* lundi 28 août 2017 15:34:53 > *À :* Michael Mwebaze > *Cc :* dhis2-users; DHIS 2 Developers list > *Objet :* Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large > organisation unit group in large instance (2.23) > > Got nothing until now but I'm investigating in that direction right now. > > Thanks already for the pointer! > > Martin > > On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze < > michael.mweb...@gmail.com> wrote: > >> Hi Martin, >> >> do you have access to the Tomcat logs? If an exception is being thrown >> that would also be helpful to figure out what is happening. >> >> Regards, >> >> Michael >> >> On 28 August 2017 at 10:04, Martin Van Aken <mar...@joyouscoding.com> >> wrote: >> >>> Hi DHIS2 users & developers, >>> We have a relatively large instance of DHIS2 (30 000 org units) where we >>> have several groups that can make up to 3 000 org unit each. >>> >>> When trying to update them through the UX, our server get a timeout >>> (looking in the console for the network calls). >>> >>> The call is like this: >>> >>> /api/organisationUnitGroups/RZYPaa6gxq8?mergeMode=REPLACE >>> >>> When using the API, we get no problem but we typically add/remove >>> relations one by one (so the call is very different). >>> >>> I tested on the last version on play and everything is working there, >>> but the version is quite different too. >>> >>> Is this something someone encountered already? Anything we could do to >>> avoid this ? >>> >>> Thanks, >>> >>> Martin >>> >>> >>> >>> >>> -- >>> *Martin Van Aken - **Freelance Enthusiast Developer* >>> >>> Mobile : +32 486 899 652 >>> >>> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >>> Call me on Skype : vanakenm >>> Hang out with me : mar...@joyouscoding.com >>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>> Company website : www.joyouscoding.com >>> >>> ___ >>> 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 >>> >>> >> > > > -- > *Martin Van Aken - **Freelance Enthusiast Developer* > > Mobile : +32 486 899 652 > > Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> > Call me on Skype : vanakenm > Hang out with me : mar...@joyouscoding.com > Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken > Company website : www.joyouscoding.com > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Timeout when updating large organisation unit group in large instance (2.23)
Got nothing until now but I'm investigating in that direction right now. Thanks already for the pointer! Martin On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze <michael.mweb...@gmail.com> wrote: > Hi Martin, > > do you have access to the Tomcat logs? If an exception is being thrown > that would also be helpful to figure out what is happening. > > Regards, > > Michael > > On 28 August 2017 at 10:04, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi DHIS2 users & developers, >> We have a relatively large instance of DHIS2 (30 000 org units) where we >> have several groups that can make up to 3 000 org unit each. >> >> When trying to update them through the UX, our server get a timeout >> (looking in the console for the network calls). >> >> The call is like this: >> >> /api/organisationUnitGroups/RZYPaa6gxq8?mergeMode=REPLACE >> >> When using the API, we get no problem but we typically add/remove >> relations one by one (so the call is very different). >> >> I tested on the last version on play and everything is working there, >> but the version is quite different too. >> >> Is this something someone encountered already? Anything we could do to >> avoid this ? >> >> Thanks, >> >> Martin >> >> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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 to DHIS2 integration cases
Hi Michael, Thanks for your answer. The architecture you explain looks sound to me - my problem is that it would mean that I would reproduce something you (and probably a lot of people) did already, so I'm wondering if someone did a sort of "generic-ish" solution to this. Should I have to build it, yes, this helps! Martin On Tue, Aug 22, 2017 at 3:19 PM, Michael Mwebaze <michael.mweb...@gmail.com> wrote: > Hi Martin, > > what I have done in the past to achieve this is to build a 3rd party > utility say in Python and sync any number of dhis2 instances through their > web apis. I then went on to create cron jobs which run the utility > periodically. The major assumption I made was that the changes only > happened on the master and never on the slaves. The slaves just got updates > from the master. I hope this helps. > > Michael > > On 21 August 2017 at 12:13, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi DHIS2 community! >> We start having a number of cases for "DHIS2 to DHIS2" integration. >> Typically, we have a DHIS2 at the HMIS level and one or more dedicated to >> vertical programs. In this situation: >> >> - the vertical program need the health pyramid from the HMIS >> - the HMIS may be interested to get back a part of the data element & >> values generated by the vertical program >> >> Examples: >> >> - every time an org unit is created or updated in the HMIS we want to >> create/update in the vertical program system >> - every time an data element is created or updated in a given group in >> the vertical program system we want to create/update it in the HMIS >> - every period (week/month/quarter) we want to push back the data from >> the vertical program to the HMIS for a given set of data element >> >> While all the individual elements are there for this to works (can use >> export/import and/or the API), is there any "advised way" to make this run >> on an automated basis? Missing this, any case/experience to share? >> >> Thanks & regards, >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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 to DHIS2 integration cases
Hi DHIS2 community! We start having a number of cases for "DHIS2 to DHIS2" integration. Typically, we have a DHIS2 at the HMIS level and one or more dedicated to vertical programs. In this situation: - the vertical program need the health pyramid from the HMIS - the HMIS may be interested to get back a part of the data element & values generated by the vertical program Examples: - every time an org unit is created or updated in the HMIS we want to create/update in the vertical program system - every time an data element is created or updated in a given group in the vertical program system we want to create/update it in the HMIS - every period (week/month/quarter) we want to push back the data from the vertical program to the HMIS for a given set of data element While all the individual elements are there for this to works (can use export/import and/or the API), is there any "advised way" to make this run on an automated basis? Missing this, any case/experience to share? Thanks & regards, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] (API) Ordering analytics results
Will do, thanks for the quick answer. Regards, Martin On Fri, Aug 11, 2017 at 10:44 AM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hey Martin, > > sorry but that is not currently possible. Feel free to write a Jira issue > and we can look into it. > > regards, > > Lars > > > On Thu, Aug 10, 2017 at 8:32 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> We want to retreive the 5 entities with the highest values for a given >> period and data element. I can retreive all values easily with an analytics >> call, but is there any way to order the results on the values (I can then >> limit the call to five entities). >> >> I saw example of "order" or "defaultOrder" clauses, but those were all >> related to meta data - in my case I want to order values. >> >> Any help would be most welcome, >> >> Thanks, >> >> Martin >> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] (API) Ordering analytics results
We want to retreive the 5 entities with the highest values for a given period and data element. I can retreive all values easily with an analytics call, but is there any way to order the results on the values (I can then limit the call to five entities). I saw example of "order" or "defaultOrder" clauses, but those were all related to meta data - in my case I want to order values. Any help would be most welcome, Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Mix quarterly and monthly data in a (Jasper) report
Great, thanks. I sort of tested this this afternoon in a bit trial and error mode, good to know it's actually possible. BTW, small point, since the report tables have been merged with the pivot table, I think part of the documentation is not more valid (ex: https://docs.dhis2.org/2.24/en/user/html/ch16s02.html). I had some trouble understanding the good layout to use in a pivot table in order to have a good structure for Jasper Studio. Some quick examples in the doc would be great, mostly to get the equivalent of the "crosstab" feature. Martin On Fri, Jun 2, 2017 at 4:12 PM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi Martin, > > the analytics app and the API allow you retrieve months and quarters (both > fixed and relative) in a single report / API call. > > E.g. in pivot table, select "Last 12 months" as well as "Last 4 quarters" > as load the table. > > If you place the periods on columns you can easily include only the needed > periods in your report design. > > > > [image: Inline image 1] > > The corresponding analytics API call: > > https://play.dhis2.org/dev/api/26/analytics.json?dimension=dx:Jtf34kNZhzP; > cYeuwXTCPkU;fbfJHSPpUQD=pe:LAST_12_MONTHS; > LAST_4_QUARTERS=ou:ImspTQPwCqd > > So yes I think you can achieve this, unless I am missing something in your > question. > > regards, > > Lars > > > > > On Fri, Jun 2, 2017 at 3:03 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi, >> We have a report that requires both montly & quartery data - basically, >> some information (quantity of services provided) are collected monthly, >> while another type (quality of service) is done quarterly. On months 1 and >> 2, we show only the quantity of services, but every third month, we need a >> report showing the quantity for the current month + the quality for the >> quarter. >> >> Is this possible? Showing a mix of monthly data & quarterly values? Are >> there any examples working that way? Does anyone have the same requirement? >> >> Thanks, >> >> Martin >> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Mix quarterly and monthly data in a (Jasper) report
Hi, We have a report that requires both montly & quartery data - basically, some information (quantity of services provided) are collected monthly, while another type (quality of service) is done quarterly. On months 1 and 2, we show only the quantity of services, but every third month, we need a report showing the quantity for the current month + the quality for the quarter. Is this possible? Showing a mix of monthly data & quarterly values? Are there any examples working that way? Does anyone have the same requirement? Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Upgrade 2.22 to 2.24 - SQL to run
That was from memory, hence the lack of details, sorry for that. I'll get my 2.24 instance back and send you the exact messages. Regards, Martin On Tue, Mar 28, 2017 at 3:12 PM, Lars Helge Øverland <l...@dhis2.org> wrote: > Okay. Which ones - could you paste the exact errors? > > On Tue, Mar 28, 2017 at 9:12 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi, >> Thanks a lot for the quick answer. On server start (2.24 server on a 2.22 >> DB) I get errors such as: "cannot run ALTER TABLE table XXX contains null >> values". >> >> From my understanding of the release notes, looks like 2.23 was >> creating/populating some columns and 2.24 putting them as not null, correct >> ? >> >> Martin >> >> On Tue, Mar 28, 2017 at 3:06 PM, Lars Helge Øverland <l...@dhis2.org> >> wrote: >> >>> Hi Martin, >>> >>> going directly from 2.22 -> 2.24 should in theory be fine, as we retain >>> all the update statements in the source code. Look for TableAlteror.java. >>> >>> Could you paste the actual SQL errors you get during update? I am sure >>> we can work around this without upgrading to each instance. >>> >>> regards, >>> >>> Lars >>> >>> >>> >>> >>> >>> >>> On Tue, Mar 28, 2017 at 8:40 AM, Martin Van Aken < >>> mar...@joyouscoding.com> wrote: >>> >>>> Hello, >>>> We're upgrading a 2.22 instance to 2.24. >>>> Looking at the release notes, 2.23 has a SQL to run for >>>> ProgramIndicators (which we don't have) but 2.24 warns about setting some >>>> columns as "not null" and that those should be filled by the 2.23. To avoid >>>> installing each version in turn, is there any way to find the SQL that are >>>> run by the 2.23 to fill those column, so I can just run them on my 2.22 >>>> based DB & have the 2.24 run directly ? >>>> >>>> I tried to have a look in the source code with could not find the >>>> initial SQLs. >>>> >>>> Thanks ! >>>> >>>> Martin >>>> >>>> -- >>>> *Martin Van Aken - **Freelance Enthusiast Developer* >>>> >>>> Mobile : +32 486 899 652 >>>> >>>> Follow me on Twitter : @martinvanaken >>>> <http://twitter.com/martinvanaken> >>>> Call me on Skype : vanakenm >>>> Hang out with me : mar...@joyouscoding.com >>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>>> Company website : www.joyouscoding.com >>>> >>>> ___ >>>> 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 <https://www.dhis2.org/> >>> >>> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Upgrade 2.22 to 2.24 - SQL to run
Hi, Thanks a lot for the quick answer. On server start (2.24 server on a 2.22 DB) I get errors such as: "cannot run ALTER TABLE table XXX contains null values". >From my understanding of the release notes, looks like 2.23 was creating/populating some columns and 2.24 putting them as not null, correct ? Martin On Tue, Mar 28, 2017 at 3:06 PM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi Martin, > > going directly from 2.22 -> 2.24 should in theory be fine, as we retain > all the update statements in the source code. Look for TableAlteror.java. > > Could you paste the actual SQL errors you get during update? I am sure we > can work around this without upgrading to each instance. > > regards, > > Lars > > > > > > > On Tue, Mar 28, 2017 at 8:40 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello, >> We're upgrading a 2.22 instance to 2.24. >> Looking at the release notes, 2.23 has a SQL to run for ProgramIndicators >> (which we don't have) but 2.24 warns about setting some columns as "not >> null" and that those should be filled by the 2.23. To avoid installing each >> version in turn, is there any way to find the SQL that are run by the 2.23 >> to fill those column, so I can just run them on my 2.22 based DB & have the >> 2.24 run directly ? >> >> I tried to have a look in the source code with could not find the initial >> SQLs. >> >> Thanks ! >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Upgrade 2.22 to 2.24 - SQL to run
Hello, We're upgrading a 2.22 instance to 2.24. Looking at the release notes, 2.23 has a SQL to run for ProgramIndicators (which we don't have) but 2.24 warns about setting some columns as "not null" and that those should be filled by the 2.23. To avoid installing each version in turn, is there any way to find the SQL that are run by the 2.23 to fill those column, so I can just run them on my 2.22 based DB & have the 2.24 run directly ? I tried to have a look in the source code with could not find the initial SQLs. Thanks ! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] API: Retreive indicators values
Hi, Quick question: is there any way to retrieve indicators values for a given group/set for a given period & entity except via analytics (we want to avoid being dependent on the analytics having run). Thanks ! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] API: Retreive indicators values
Ok, thanks for the quick reply ! Martin On Thu, Mar 16, 2017 at 10:10 AM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi Martin, > > unfortunately not. You need to use the analytics API. > > regards, > > Lars > > > On Thu, Mar 16, 2017 at 10:07 AM, Martin Van Aken <mar...@joyouscoding.com > > wrote: > >> Hi, >> Quick question: is there any way to retrieve indicators values for a >> given group/set for a given period & entity except via analytics (we want >> to avoid being dependent on the analytics having run). >> >> Thanks ! >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Cannot create a custom attribute on demo last version
Ok, thanks! The dangers of running a public instance :) Martin On Thu, Jan 26, 2017 at 11:04 AM, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi > > This is happening because someone is playing around with the calendar > settings ;-) You can try and set it back to gregorian in the "system > settings -> calendar", but of course.. there is a risk someone will change > it again (probably someone is trying something out) > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Thu, Jan 26, 2017 at 4:19 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Any attempt to create a custom attribute fail with a message of "Month >> not valid [1,7]" (see attached screenshot). >> >> I'm speaking of the "custom attribute to add" not the "tracker attribute" >> here. My attempt use the following info: >> >> - Type text >> - Name & Code: picture >> - Target: organisation unit >> - No option set >> >> Changing those leads to the same result. >> >> Any leads here? >> >> Martin >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Analytics query - filter on org unit group
This is exactly what I needed. Just tested it. I did not expect to have to specify the group set (even if I can understand). Great, thanks. On Fri, Jan 20, 2017 at 4:30 PM, Jan Henrik Øverland <j...@dhis2.org> wrote: > Hi Martin, > > Keep Sierra Leone as the "ou" and simply add filter=J5jldMd8OHv:CXw2yu5fodb > where J5jldMd8OHv = Facility type (dimension) and CXw2yu5fodb = CHC > (dimension item). > > https://play.dhis2.org/demo/api/25/analytics.json? > dimension=dx:Uvn6LCg7dVU=ou:ImspTQPwCqd& > dimension=pe:LAST_12_MONTHS=J5jldMd8OHv:CXw2yu5fodb > > You can easily replicate that in the pivot tables app by finding the > Facility type tab to the left, select CHC only, then open the layout window > and move Facility type to "filter". > > Like you said, the OU_GROUP keyword will explicitly select the orgunits in > the specified group(s) instead. > > Jan > > On 20 January 2017 at 16:15, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello everyone, >> I've a question on the analytics API. If I want to get a result for a >> single org unit, I can do something like this: >> >> https://play.dhis2.org/demo/api/analytics.json?dimension=dx: >> fbfJHSPpUQD=pe:LAST_MONTH=ou:ImspTQPwCqd >> >> (in this case, asking for the ANC 1st visit result for the last month for >> the Sierra Leone country). >> >> This is actually giving me the aggregation of all the org unit in the >> country, as per the documentation: >> >> "For the organisation unit dimension the dimension items are the >> organisation units and their sub-hierarchy - data will be aggregated for >> all organisation units below the given organisation unit in the hierarchy." >> >> Now in my case, I would like to run the same query (result for the whole >> country), but limiting the org unit to a given group - let's say the CHCs. >> The thing is: I don't want the results for each CHC, but still a single >> result at the top level - I just want to include only the CHC in the >> aggregation. >> >> Can this be expressed using the DHIS2 API? I've the feeling I could use a >> filter there, but could not manage to make it work. >> >> Attempting to add filter=ou:OU_GROUP-CXw2yu5fodb to the above query >> result to the API returning an error as: "Dimensions cannot be specified as >> dimension and filter simultaneously" - and I don't see how I can say "give >> me the aggregate for all units under Sierra Leone that are part of the CHC >> group". >> >> Any help or pointer would be most welcome. >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > > > -- > Jan Henrik Øverland > Software developer, DHIS 2 > University of Oslo > http://www.dhis2.org <https://www.dhis2.org/> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Embed viz in DHIS2 2.22
Hello, Yes, more success there, thanks. I'm still getting error messages from my browser regarding Control-Allow-Origin - I'll investigate that one further. Martin On Thu, Jan 19, 2017 at 7:09 PM, Jan Henrik Øverland <j...@dhis2.org> wrote: > Okay. Did you follow the instructions for 2.25? > > https://docs.dhis2.org/2.25/en/developer/html/webapi_plugins.html#d0e7117 > > > On Jan 19, 2017 18:40, "Martin Van Aken" <mar...@joyouscoding.com> wrote: > > Thanks, I'll try it out. > > On the 2.25 version it's working with a catch - even with my url > whitelisted in DHIS2 Setting page, I get a "Control-Allow-Origin' header is > present on the requested resource. Origin 'http://x is therefore not > allowed access." > > From my own browser I can disable cors (using a chrome extension), but > that's not really sustainable. Any pointers there? > > Thanks, > > Martin > > On Jan 18, 2017 9:45 PM, "Jan Henrik Øverland" <j...@dhis2.org> wrote: > >> Hi Martin, >> >> We have obviously not been able to keep the cdn/docs up to date for all >> versions. Sorry about that. >> >> I have put up the 2.22 chart plugin here: https://dhis2-cdn.org >> >> To make this work, please add your client domain to the CORS whitelist in >> your 2.22 instance (system settings). >> >> Then there were some parts missing in the html. Please try: >> >> >> >> http://dhis2-cdn.org/v22 >> 2/ext/resources/css/ext-plugin-gray.css" /> >> http://dhis2-cdn.org/v222/ext/ext-all.js"</a>;> >> http://dhis2-cdn.org/v222/plugin/chart.js"</a>;> >> >> >> >> >> >> >> var crossDomain = true; >> var url = 'myInstance'; >> var username = 'myUsername'; >> var password = 'myPassord'; >> >> Ext.onReady(function() { >> >> DHIS.getChart({ >> "crossDomain": crossDomain, >> "url": url, >> "username": username, >> "password": password, >> >> "id": "DkPKc1EUmC2", >> "el": "chart1" >> }); >> >> }); >> >> >> >> >> Hope this helps. >> >> Jan >> >> >> >> >> On 18 January 2017 at 16:49, Martin Van Aken <mar...@joyouscoding.com> >> wrote: >> >>> Hello, >>> I've a DHIS2 2.22 running with some chart we did. I want to embed one in >>> an external page. When I ask for "Embed" I got code like this: >>> >>> >>> >>> http://dhis2-cdn.org/v22 >>> 2/ext/resources/css/ext-plugin-gray.css" /> >>> http://dhis2-cdn.org/v222/ext/ext-all.js"</a>;> >>> http://dhis2-cdn.org/v222/plugin/chart.js"</a>;> >>> >>> >>> >>> >>> >>> Ext.onReady(function() { >>> >>> DHIS.getChart({ >>> "id": "nIn1JofuIm3" >>> }); >>> >>> }); >>> >>> >>> >>> >>> I get several problems there - first of all on the CDN the v222 does not >>> exists at all. Going on http://dhis2-cdn.org/ looks like nothing exists >>> between 2.21 & 2.25. >>> >>> The second thing is I don't understand how this can work without any >>> reference to the server I'm running on. >>> >>> I did some test in the play with success, but that's with the 2.25 (and >>> looks like a quite different API). Any help for a version between 2.21 & >>> 2.25? >>> >>> Thanks, >>> >>> Martin >>> >>> -- >>> *Martin Van Aken - **Freelance Enthusiast Developer* >>> >>> Mobile : +32 486 899 652 >>> >>> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >>> Call me on Skype : vanakenm >>> Hang out with me : mar...@joyouscoding.com >>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>> Company website : www.joyouscoding.com >>> >>> ___ >>> 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 >>> >>> >> >> >> -- >> Jan Henrik Øverland >> Software developer, DHIS 2 >> University of Oslo >> http://www.dhis2.org <https://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 > > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Analytics query - filter on org unit group
Hello everyone, I've a question on the analytics API. If I want to get a result for a single org unit, I can do something like this: https://play.dhis2.org/demo/api/analytics.json?dimension=dx:fbfJHSPpUQD=pe:LAST_MONTH=ou:ImspTQPwCqd (in this case, asking for the ANC 1st visit result for the last month for the Sierra Leone country). This is actually giving me the aggregation of all the org unit in the country, as per the documentation: "For the organisation unit dimension the dimension items are the organisation units and their sub-hierarchy - data will be aggregated for all organisation units below the given organisation unit in the hierarchy." Now in my case, I would like to run the same query (result for the whole country), but limiting the org unit to a given group - let's say the CHCs. The thing is: I don't want the results for each CHC, but still a single result at the top level - I just want to include only the CHC in the aggregation. Can this be expressed using the DHIS2 API? I've the feeling I could use a filter there, but could not manage to make it work. Attempting to add filter=ou:OU_GROUP-CXw2yu5fodb to the above query result to the API returning an error as: "Dimensions cannot be specified as dimension and filter simultaneously" - and I don't see how I can say "give me the aggregate for all units under Sierra Leone that are part of the CHC group". Any help or pointer would be most welcome. Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Embed viz in DHIS2 2.22
Thanks, I'll try it out. On the 2.25 version it's working with a catch - even with my url whitelisted in DHIS2 Setting page, I get a "Control-Allow-Origin' header is present on the requested resource. Origin 'http://x is therefore not allowed access." >From my own browser I can disable cors (using a chrome extension), but that's not really sustainable. Any pointers there? Thanks, Martin On Jan 18, 2017 9:45 PM, "Jan Henrik Øverland" <j...@dhis2.org> wrote: > Hi Martin, > > We have obviously not been able to keep the cdn/docs up to date for all > versions. Sorry about that. > > I have put up the 2.22 chart plugin here: https://dhis2-cdn.org > > To make this work, please add your client domain to the CORS whitelist in > your 2.22 instance (system settings). > > Then there were some parts missing in the html. Please try: > > > > http://dhis2-cdn.org/v22 > 2/ext/resources/css/ext-plugin-gray.css" /> > http://dhis2-cdn.org/v222/ext/ext-all.js"</a>;> > http://dhis2-cdn.org/v222/plugin/chart.js"</a>;> > > > > > > > var crossDomain = true; > var url = 'myInstance'; > var username = 'myUsername'; > var password = 'myPassord'; > > Ext.onReady(function() { > > DHIS.getChart({ > "crossDomain": crossDomain, > "url": url, > "username": username, > "password": password, > > "id": "DkPKc1EUmC2", > "el": "chart1" > }); > > }); > > > > > Hope this helps. > > Jan > > > > > On 18 January 2017 at 16:49, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello, >> I've a DHIS2 2.22 running with some chart we did. I want to embed one in >> an external page. When I ask for "Embed" I got code like this: >> >> >> >> http://dhis2-cdn.org/v22 >> 2/ext/resources/css/ext-plugin-gray.css" /> >> http://dhis2-cdn.org/v222/ext/ext-all.js"</a>;> >> http://dhis2-cdn.org/v222/plugin/chart.js"</a>;> >> >> >> >> >> >> Ext.onReady(function() { >> >> DHIS.getChart({ >> "id": "nIn1JofuIm3" >> }); >> >> }); >> >> >> >> >> I get several problems there - first of all on the CDN the v222 does not >> exists at all. Going on http://dhis2-cdn.org/ looks like nothing exists >> between 2.21 & 2.25. >> >> The second thing is I don't understand how this can work without any >> reference to the server I'm running on. >> >> I did some test in the play with success, but that's with the 2.25 (and >> looks like a quite different API). Any help for a version between 2.21 & >> 2.25? >> >> Thanks, >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > > > -- > Jan Henrik Øverland > Software developer, DHIS 2 > University of Oslo > http://www.dhis2.org <https://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
[Dhis2-users] Embed viz in DHIS2 2.22
Hello, I've a DHIS2 2.22 running with some chart we did. I want to embed one in an external page. When I ask for "Embed" I got code like this: http://dhis2-cdn.org/v222/ext/resources/css/ext-plugin-gray.css; /> http://dhis2-cdn.org/v222/ext/ext-all.js"</a>;> http://dhis2-cdn.org/v222/plugin/chart.js"</a>;> Ext.onReady(function() { DHIS.getChart({ "id": "nIn1JofuIm3" }); }); I get several problems there - first of all on the CDN the v222 does not exists at all. Going on http://dhis2-cdn.org/ looks like nothing exists between 2.21 & 2.25. The second thing is I don't understand how this can work without any reference to the server I'm running on. I did some test in the play with success, but that's with the 2.25 (and looks like a quite different API). Any help for a version between 2.21 & 2.25? Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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: Manage data that does not change often
Hi Lars, Thanks a lot for your detailed answer. This is the direction we were aiming, but I wanted confirmation that it was "the good way". Not that painful on our side, as we do have an external app which could generate the values using DHIS2 API. Thanks and congrats again by the way for an API that 1/ allow us to do everything that the UX can 2/ is documented 3/ work. Our goal is exactly what you outlined - even if it does not change often, we want the prices to be available for analytics, hence they need to be data elements. Regards, Martin On Fri, Sep 2, 2016 at 7:25 PM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi Martin, > > good question. There is no perfect solution at this point. I assume you > need these values for analytics. This means that the best solution is > likely: > > 1. Find and use the lowest common period type (frequency) for which data > will change (I assume Quarterly) > > 2. Store the RBF specific data in an external data source, e.g. using data > store > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/webapi_data_store.html>, > where you can store the Quarter, data element (Consultation Price) and > value. You can write a front end app that provides a user-friendly > interface to this data. > > 3. Generate values for all org units. You can write code in your component > to keep this data in check, e.g. every time someone changes a value in your > RBF data source/app, then automatically generate/populate data values > accordingly in DHIS 2. > > This is admittedly a bit painful, but its not too bad, and it gives you > the benefit that all analytics features of DHIS 2 will just work > (indicators, dashboards and so on). > > > best, > > Lars > > > > > > On Fri, Aug 19, 2016 at 8:46 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi everyone, >> I'm wondering about the best way to manage a use case of ours in DHIS2. >> We have a specific element of data (prices for services in an RBF system) >> which is normally the same for every org unit for a given period (and in >> most case stable for several periods). As an example, we could have >> something like: >> >> Consultation Price: >> - Jan-December 2016: 2.5$ >> - Jan-June 2016: 2$ >> - July-December 2016: 3$ >> >> I'm not sure what to use to represent this kind of data in DHIS2: >> >> - Constant is not good as it can evolve >> - Standard Data Element means that when we make a change, we need to >> "apply" it to every entity for the given period (thus generating hundreds >> or thousand of copies of that values) >> >> Added question: if we go for a Data Element, how could we "fill it" at >> regular basis (like for the next period each time) - we don't want people >> to fill as a data entry for individual entities (it does not make any >> sense, and it's not something they "report" anyway). >> >> Any opinion is welcome! >> >> Martin >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___________ >> 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 <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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: Manage data that does not change often
Hi Propser, The problem is that it all depends - those are linked to changes at the health program manager level, and it's not a predictable variable. The problem is that it's stable-ish - for a given month, it will be stable for a most facilities, but there will probably be changes for a set of facilities each month or tow (in other words: at least one subset/group of facilities will have a change every period of two - not the same group each time of course). So, the dataSet frequency is not stable - can stay stable for six months, then change twice in the next three, etc. Thanks already for your help, Martin On Tue, Aug 30, 2016 at 10:53 AM, Prosper BT <ptb3...@gmail.com> wrote: > Dear Martin, > > Can you share the frequency of change or required frequency that you would > have to maintain if you choose to create a data element and dataset for > this case, because its the most viable and given ability to track changes > over time. This could be a data set only assigned to one Orgunits. > > Also how often to use this in analysis, this can also guide on on the > dataset frequency. > > Regards > > > > > On Fri, Aug 19, 2016 at 9:46 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hi everyone, >> I'm wondering about the best way to manage a use case of ours in DHIS2. >> We have a specific element of data (prices for services in an RBF system) >> which is normally the same for every org unit for a given period (and in >> most case stable for several periods). As an example, we could have >> something like: >> >> Consultation Price: >> - Jan-December 2016: 2.5$ >> - Jan-June 2016: 2$ >> - July-December 2016: 3$ >> >> I'm not sure what to use to represent this kind of data in DHIS2: >> >> - Constant is not good as it can evolve >> - Standard Data Element means that when we make a change, we need to >> "apply" it to every entity for the given period (thus generating hundreds >> or thousand of copies of that values) >> >> Added question: if we go for a Data Element, how could we "fill it" at >> regular basis (like for the next period each time) - we don't want people >> to fill as a data entry for individual entities (it does not make any >> sense, and it's not something they "report" anyway). >> >> Any opinion is welcome! >> >> Martin >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 DHIS2 Implementation| HISP Uganda/University Of Oslo > +256 752 751 776 | +256 776 139 139 > pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype: > prospertb > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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: Manage data that does not change often
Hi everyone, I'm wondering about the best way to manage a use case of ours in DHIS2. We have a specific element of data (prices for services in an RBF system) which is normally the same for every org unit for a given period (and in most case stable for several periods). As an example, we could have something like: Consultation Price: - Jan-December 2016: 2.5$ - Jan-June 2016: 2$ - July-December 2016: 3$ I'm not sure what to use to represent this kind of data in DHIS2: - Constant is not good as it can evolve - Standard Data Element means that when we make a change, we need to "apply" it to every entity for the given period (thus generating hundreds or thousand of copies of that values) Added question: if we go for a Data Element, how could we "fill it" at regular basis (like for the next period each time) - we don't want people to fill as a data entry for individual entities (it does not make any sense, and it's not something they "report" anyway). Any opinion is welcome! Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Using a File as custom attributes for Organisation Units
Thanks fo the quick reply - the fix will be useful. I'll use an url as a workaround and store the picture somewhere else then. Martin On Thu, Aug 4, 2016 at 12:19 PM, Halvdan Hoem Grelland <halv...@dhis2.org> wrote: > Hi, and thanks for reporting! > > Attributes of type File are unfortunately not supported. That they're > available in the UI is a mishap (which will be fixed promptly). > > On Thu, Aug 4, 2016 at 12:12 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello, >> I try to add a new fields for the Organization Units to store a picture >> of them. >> >> I've created an Attribute attached to the Org Unit, with a value type of >> "File": >> >> >> [image: Inline image 1] >> I can see it on the Org Unit edit screen, but as a simple text field >> (instead of the upload file that I expected): >> >> [image: Inline image 2] >> >> Is it possible to attach a File (picutre or other) to an Org Unit through >> an attribute? Am I missing something here? >> >> (BTW, this is visible right now on the demo instance: >> https://play.dhis2.org/demo/dhis-web-maintenance/#/edit/organisationUnitSection/organisationUnit/YuQRtpLP10I?_k=kibz3r >> and >> https://play.dhis2.org/demo/dhis-web-maintenance/#/edit/otherSection/attribute/EBoenrW7m9F?_k=vybsfb >> ) >> >> Thanks, >> >> Martin >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> ___ >> 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 >> >> > > > -- > Halvdan Hoem Grelland > Software developer, DHIS 2 > University of Oslo > http://www.dhis2.org <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] Using a File as custom attributes for Organisation Units
Hello, I try to add a new fields for the Organization Units to store a picture of them. I've created an Attribute attached to the Org Unit, with a value type of "File": [image: Inline image 1] I can see it on the Org Unit edit screen, but as a simple text field (instead of the upload file that I expected): [image: Inline image 2] Is it possible to attach a File (picutre or other) to an Org Unit through an attribute? Am I missing something here? (BTW, this is visible right now on the demo instance: https://play.dhis2.org/demo/dhis-web-maintenance/#/edit/organisationUnitSection/organisationUnit/YuQRtpLP10I?_k=kibz3r and https://play.dhis2.org/demo/dhis-web-maintenance/#/edit/otherSection/attribute/EBoenrW7m9F?_k=vybsfb ) Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] API call on reportTable with parameters?
This looks to be working, even if I'm not clear on the relationship between dates & periods. Last but not least - I had two ideas to make this work: either use the reportTable as API source (pro: it already existed) or create the equivalent using the analytics web API. My problem in that second case it that I did not find any way to collect all the indicators for a given group for a specific organisation unit except by listing them one by one. There is something call a data element group using a syntax like: dx:DE_GROUP- but it does not look to work for indicators group. Is there an alternate, non documented syntax for those? If both approach can work, any advice on using one vs the other (analytics vs reportTable) ? Martin On Mon, May 9, 2016 at 10:39 AM, Morten Olav Hansen <mor...@dhis2.org> wrote: > I'm honestly not sure, Lars would have to answer that. The date itself is > a normal date object, which means multiple date formats are supported. > > @Lars ? > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, May 9, 2016 at 3:37 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Thanks a lot for the quick answer. Is the date a period ? (in my case the >> table represent a selection of data element and indicators which are >> collected each month in each org units). >> >> Martin >> >> On Mon, May 9, 2016 at 10:34 AM, Morten Olav Hansen <mor...@dhis2.org> >> wrote: >> >>> Hi Martin >>> >>> You can use ou and date as query parameters >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Mon, May 9, 2016 at 3:18 PM, Martin Van Aken <mar...@joyouscoding.com >>> > wrote: >>> >>>> Hi, >>>> We currently have a reportTable used to generate a PDF report. We now >>>> want to be able to extract the exact same info using the API. I've seen >>>> that there is a reportTables//data.json option, but I cannot find how >>>> to pass it parameters (our table take two - the organisation unit and the >>>> period). >>>> >>>> Any pointers? >>>> >>>> Thanks, >>>> >>>> Martin >>>> >>>> -- >>>> *Martin Van Aken - **Freelance Enthusiast Developer* >>>> >>>> Mobile : +32 486 899 652 >>>> >>>> Follow me on Twitter : @martinvanaken >>>> <http://twitter.com/martinvanaken> >>>> Call me on Skype : vanakenm >>>> Hang out with me : mar...@joyouscoding.com >>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>>> Company website : www.joyouscoding.com >>>> >>>> ___ >>>> 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 >>>> >>>> >>> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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] API call on reportTable with parameters?
Hi, We currently have a reportTable used to generate a PDF report. We now want to be able to extract the exact same info using the API. I've seen that there is a reportTables//data.json option, but I cannot find how to pass it parameters (our table take two - the organisation unit and the period). Any pointers? Thanks, Martin -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com ___ 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