[Dhis2-users] API call on reportTable with parameters?

2016-05-09 Thread Martin Van Aken
eriod). 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 Link

Re: [Dhis2-users] API call on reportTable with parameters?

2016-05-09 Thread Martin Van Aken
s > 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 > wrote: > >> Thanks

[Dhis2-users] Using a File as custom attributes for Organisation Units

2016-08-04 Thread Martin Van Aken
tionUnitSection/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 <

Re: [Dhis2-users] Using a File as custom attributes for Organisation Units

2016-08-04 Thread Martin Van Aken
upported. 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 > wrote: > >> Hello, >> I try to add a new fields for the Organization Units to store a picture >> of them. >> >

[Dhis2-users] DHIS2: Manage data that does not change often

2016-08-19 Thread Martin Van Aken
a 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/mar

Re: [Dhis2-users] DHIS2: Manage data that does not change often

2016-08-30 Thread Martin Van Aken
eate similar xml or json imports but csv seems easier. > > Maybe this could work for you? > > Elmarie Claasen > HISP-SA > > On 19 Aug 2016 09:16, "Martin Van Aken" wrote: > >> Hi everyone, >> I'm wondering about the best way to manage a use case of

Re: [Dhis2-users] DHIS2: Manage data that does not change often

2016-08-30 Thread Martin Van Aken
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

Re: [Dhis2-users] DHIS2: Manage data that does not change often

2016-09-03 Thread Martin Van Aken
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, > &g

[Dhis2-users] Embed viz in DHIS2 2.22

2017-01-18 Thread Martin Van Aken
s 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 betw

Re: [Dhis2-users] Embed viz in DHIS2 2.22

2017-01-19 Thread Martin Van Aken
r crossDomain = true; > var url = 'myInstance'; > var username = 'myUsername'; > var password = 'myPassord'; > > Ext.onReady(function() { > > DHIS.getChart({ > "crossDomain": crossDomain, > "url": url, > "u

[Dhis2-users] Analytics query - filter on org unit group

2017-01-20 Thread Martin Van Aken
b 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 wou

Re: [Dhis2-users] Embed viz in DHIS2 2.22

2017-01-20 Thread Martin Van Aken
25? > > https://docs.dhis2.org/2.25/en/developer/html/webapi_plugins.html#d0e7117 > > > On Jan 19, 2017 18:40, "Martin Van Aken" 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 S

Re: [Dhis2-users] Analytics query - filter on org unit group

2017-01-20 Thread Martin Van Aken
in > the specified group(s) instead. > > Jan > > On 20 January 2017 at 16:15, Martin Van Aken > 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: >>

Re: [Dhis2-users] Cannot create a custom attribute on demo last version

2017-01-26 Thread Martin Van Aken
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,

Re: [Dhis2-users] API: Retreive indicators values

2017-03-16 Thread Martin Van Aken
Ok, thanks for the quick reply ! Martin On Thu, Mar 16, 2017 at 10:10 AM, Lars Helge Ă˜verland 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 > wrot

[Dhis2-users] API: Retreive indicators values

2017-03-16 Thread Martin Van Aken
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

[Dhis2-users] Upgrade 2.22 to 2.24 - SQL to run

2017-03-28 Thread Martin Van Aken
on 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 - **Freela

Re: [Dhis2-users] Upgrade 2.22 to 2.24 - SQL to run

2017-03-28 Thread Martin Van Aken
e 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 > wrote: > >> Hello, >> We're

Re: [Dhis2-users] Upgrade 2.22 to 2.24 - SQL to run

2017-03-28 Thread Martin Van Aken
, 2017 at 9:12 AM, Martin Van Aken > 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 understandin

[Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Martin Van Aken
ed 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 En

Re: [Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Martin Van Aken
=dx:Jtf34kNZhzP; > cYeuwXTCPkU;fbfJHSPpUQD&dimension=pe:LAST_12_MONTHS; > LAST_4_QUARTERS&filter=ou:ImspTQPwCqd > > So yes I think you can achieve this, unless I am missing something in your > question. > > regards, > > Lars > > > > > On Fri, Ju

[Dhis2-users] (API) Ordering analytics results

2017-08-10 Thread Martin Van Aken
ot;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://tw

Re: [Dhis2-users] (API) Ordering analytics results

2017-08-11 Thread Martin Van Aken
; On Thu, Aug 10, 2017 at 8:32 PM, Martin Van Aken > 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

[Dhis2-users] DHIS2 to DHIS2 integration cases

2017-08-21 Thread Martin Van Aken
, 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/

Re: [Dhis2-users] DHIS2 to DHIS2 integration cases

2017-08-22 Thread Martin Van Aken
en 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

[Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
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 : vanaken

Re: [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
lso be helpful to figure out what is happening. > > Regards, > > Michael > > On 28 August 2017 at 10:04, Martin Van Aken > wrote: > >> Hi DHIS2 users & developers, >> We have a relatively large instance of DHIS2 (30 000 org units) where we >> have several gr

Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
> 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 lists.launchpad.net> de l

Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
t; University of Oslo > http://www.dhis2.org > > On Mon, Aug 28, 2017 at 10:14 PM, Martin Van Aken > wrote: > >> Hello Joseph, >> Thanks for the feedback. I'll try rh >> >> On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn < >> osbornlegr...@hotmai

Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
> University of Oslo > http://www.dhis2.org > > On Tue, Aug 29, 2017 at 1:09 AM, Martin Van Aken > 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

Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-29 Thread Martin Van Aken
r Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Tue, Aug 29, 2017 at 2:07 AM, Martin Van Aken > 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

Re: [Dhis2-users] [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-29 Thread Martin Van Aken
roved in 224 and going forward... > > Did you try and enable the preheat parameter? preheatCache=true > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Tue, Aug 29, 2017 at 2:00 PM, Martin Van Aken > wrote: > &g

Re: [Dhis2-users] [Dhis2-devs] Interoperability of ODK & DHIS2

2017-08-30 Thread Martin Van Aken
ebook > <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/~

Re: [Dhis2-users] [Dhis2-devs] Interoperability of ODK & DHIS2

2017-09-01 Thread Martin Van Aken
Interesting, thanks! Martin On Fri, Sep 1, 2017 at 10:23 AM, Knut Staring 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 > wrote: > >>

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

2017-09-08 Thread Martin Van Aken
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

[Dhis2-users] Check how many time reports are generated

2017-10-04 Thread Martin Van Aken
ike: http://DHIS2_urL/dhis-web-reporting/generateHtmlReport.action?uid=ThScKdiP4Cp&pe=201708&ou=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 : @m

Re: [Dhis2-users] Check how many time reports are generated

2017-10-04 Thread Martin Van Aken
owing classes: > > DataStatistics.java > DataStatisticsEventType.java > DataStatisticsController.java > GetReportAndParamsAction.java > > > regards, > > Lars > > > > > On Wed, Oct 4, 2017 at 9:16 AM, Martin Van Aken > wrote: > >> Hello DHIS2 community,

Re: [Dhis2-users] Check how many time reports are generated

2017-10-04 Thread Martin Van Aken
k 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 > wrote: > >> Thanks! No luck for me right now but interesting nonetheless. I'll have a >> look at the provided

[Dhis2-users] Import/Export data between similar but distinct systems

2018-01-09 Thread Martin Van Aken
'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 <

[Dhis2-users] New DHIS2 App - Meta Navigator

2018-01-19 Thread Martin Van Aken
ble 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 8

[Dhis2-users] Event Report (Events) - select data items which have no value

2018-02-05 Thread Martin Van Aken
his 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>

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

2018-02-05 Thread Martin Van Aken
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 > wrote: > >> Hi everyone, >> We are interested to ge

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

2018-02-05 Thread Martin Van Aken
> Aaron C. White > 919.522.5585 <(919)%20522-5585> > > On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken > wrote: > >> Would not have though of that approach - your examples uses the d2 JS >> library? Are those "operators" usable in a analytics/events/query

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

2018-02-05 Thread Martin Van Aken
ID: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:0

[Dhis2-users] Problem with the d2:condition function in program operator

2018-02-06 Thread Martin Van Aken
e? 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

Re: [Dhis2-users] Problem with the d2:condition function in program operator

2018-02-07 Thread Martin Van Aken
hem. > > 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 : > > Hello, > I'm trying to create a program indicator which would

Re: [Dhis2-users] [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Martin Van Aken
~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> Lars Helg

Re: [Dhis2-users] [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-14 Thread Martin Van Aken
s with parenthesis outside the > known issue above. > > Markus > > 14. feb. 2018 kl. 08:30 skrev Martin Van Aken : > > Hi everyone. > > Thanks Lars for the answer - we face problems with priorities (hence > needing parenthesis) there too. Glad to know this will be solved, bu

[Dhis2-users] Hiring a DHIS2 Specialist (Belgium)

2018-05-04 Thread Martin Van Aken
o 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.link

[Dhis2-users] Get tracker entity instance id from an event analytics query

2018-05-25 Thread Martin Van Aken
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

[Dhis2-users] Setting default values for some data elements

2018-06-04 Thread Martin Van Aken
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

[Dhis2-users] User manuals translation?

2018-06-12 Thread Martin Van Aken
(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 : va

Re: [Dhis2-users] User manuals translation?

2018-06-13 Thread Martin Van Aken
inly 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 th

[Dhis2-users] Metadata audit for user class

2018-09-19 Thread Martin Van Aken
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

Re: [Dhis2-users] Metadata audit for user class

2018-09-20 Thread Martin Van Aken
the modification is logged or >> not. >> >> Please share your experience with us when done. >> >> Regards >> >> >> On Wed, Sep 19, 2018, 3:30 PM Martin Van Aken >> wrote: >> >>> Hello, >>> Can the Metadata audit feature

[Dhis2-users] Mission: DHIS2 Training specialist in Kyrgystan

2018-10-01 Thread Martin Van Aken
lable 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 Tw