[Dhis2-devs] DHIS2 - CSV export via WebAPI EventReports

2015-05-11 Thread Robin Martens
Hi, It is possible via the WebAPI to export a Pivot Table in CSV format like this (in which the uniquecode refers to a defined favorite): /api/reportTables/uniquecode/data.csv Is it also possible to do this for Event Reports? The following command exists but returns an empty csv file: /api/ev

[Dhis2-devs] DHIS2 - Program still appearing for certain user roles

2015-03-28 Thread Robin Martens
Hi all, I have some programs that should only be visible to certain users. When I unselect the other users from the “Assign to user roles” menu via the “Program” module, the program continues to appear for these users in the Event Capture module. The same issue seems to persist on the demo serv

Re: [Dhis2-devs] [Dhis2-users] DHIS2 - Communication error "0" when generating pivot table

2015-03-28 Thread Robin Martens
Hi Jason, That’s what I thought. We’ll have a look at the nginx timeout settings then. Thanks a lot! Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 27 March 2015 11:58 To: Robin Martens Cc: DHIS 2 Users list; DHIS 2 Developers list Subject: Re: [Dhis2-devs] [Dhis2-users

Re: [Dhis2-devs] DHIS2 - Validations on GPS coordinates

2015-03-16 Thread Robin Martens
Hi Jason, Thanks for the detailed reply. It might a useful feature for later if other users see a need. For the moment, we will have a look at the general validation. Regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 16 March 2015 11:53 To: Robin Martens Cc

Re: [Dhis2-devs] DHIS2 - Validations on GPS coordinates

2015-03-16 Thread Robin Martens
:38 To: Robin Martens Cc: DHIS 2 Users list; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Validations on GPS coordinates Hi Robin, No, it is not possible to define specific validation on coordinates except the general validation of latitude and longitude. However, if you look at the latest Event

[Dhis2-devs] DHIS2 - Validations on GPS coordinates

2015-03-16 Thread Robin Martens
Hi all, Does anyone know if it is possible to set validation rules on GPS coordinates in the event capture module? Ideally, coordinates would be within the polygon of the organization unit the event is linked to (a country or district in this case). Else, just min-max values could already work

[Dhis2-devs] DHIS2 - Error message when saving event report as favorite

2015-02-09 Thread Robin Martens
Dear all, We're getting the following error message when trying to save an event report as a favorite (see image below). This is only happening for event reports, all other functionalities (download, generating on screen, etc.) don't have any problems. [cid:f4b2f27a-cb81-4285-9694-e69aa6bbebb

Re: [Dhis2-devs] DHIS2 - Validation rules for event capture - Bug?

2015-01-25 Thread Robin Martens
De : Dhis2-users [dhis2-users-bounces+martens=sher...@lists.launchpad.net] de la part de Robin Martens [mart...@sher.be] Envoyé : dimanche 25 janvier 2015 15:44 À : DHIS 2 Developers list; DHIS 2 Users list Objet : [Dhis2-users] DHIS2 - Validation rules for event capture - Bug? Hi all, Here'

[Dhis2-devs] DHIS2 - Validation rules for event capture - Bug?

2015-01-25 Thread Robin Martens
Hi all, Here's a question (potential bug) on the validation rules for event capture. When setting a validation rule for a program it doesn't seem to do anything when violated. There is no pop-up blocking saving the data when filling in the form and no problem detected the data quality app. I t

Re: [Dhis2-devs] [Dhis2-users] Date category combination

2015-01-23 Thread Robin Martens
Hi all, I want to delete my analytics tables and start all over. The (only?) way to do this is through the Data Admin -> Maintenance app but when clearing the tables nothing happens. All tables still exist in Postgresql and the data remains available in the Pivot tables. We're still in 2.17. I

Re: [Dhis2-devs] Aggreration query for single event without registration

2015-01-22 Thread Robin Martens
Hi Ola, Thanks a lot, that works great! Regards, Robin De : olati...@gmail.com [olati...@gmail.com] de la part de Ola Hodne Titlestad [ol...@ifi.uio.no] Envoyé : jeudi 22 janvier 2015 12:41 À : Robin Martens Cc : dhis2-us...@lists.launchpad.net; dhis2-devs

[Dhis2-devs] Aggreration query for single event without registration

2015-01-21 Thread Robin Martens
Hi all, Is it possible in the Aggregation Query Builder to use the "Number of tracked entities" operator to calculate a number of events, especially when it concerns Single events without registration? I tried it and although it finds the events based on the conditions, it always returns 0 as

[Dhis2-devs] DHIS2 - Custom conditions on the aggregation period when using Aggregation Queries

2015-01-19 Thread Robin Martens
Hi all, An additional question about the Aggregation Query Builder. Currently, the period of aggregation between tracked data elements (TDE) and aggregated data elements (ADE) always has to correspond. E.g. for monthly ADEs, TDE data will be aggregated per month based on the event instance repo

Re: [Dhis2-devs] DHIS2 - Financial year (July) in pivot tables

2015-01-19 Thread Robin Martens
Ok, thanks Lars for the quick reply (as always)! De : Lars Helge Øverland [larshe...@gmail.com] Envoyé : lundi 19 janvier 2015 09:54 À : Robin Martens Cc : dhis2-users; dhis2-devs Objet : Re: [Dhis2-devs] DHIS2 - Financial year (July) in pivot tables Hi Robin

[Dhis2-devs] DHIS2 - Financial year (July) in pivot tables

2015-01-19 Thread Robin Martens
Hi all, It seems that although you can set the data set collection frequency to Financial Year (July), there's no way to report the data in the Pivot table module in this way. When selecting the "Financial Year" option in the Pivot table, it uses the Financial Year (Oct) option. Will this be f

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-23 Thread Robin Martens
the bug on the Demo server (program "test", data element "test") with the same results. Is this a bug? Kind regards, Robin From: Robin Martens Sent: 18 September 2014 13:06 To: 'Abyot Gizaw' Cc: DHIS 2 Developers list Subject: RE: [Dhis2-devs] DHIS2 - Event capture err

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-18 Thread Robin Martens
xpbibx' or uidlevel3 = 'DgPyE1KSE4N' or uidlevel3 = 'wnSidr8A3Pw' or uidlevel3 = 'XmH5uCIONk4' or uidlevel3 = 'yJbg2GIMdnc' or uidlevel3 = 'bcU1Jq7BOKq' or uidlevel3 = 'CeEl2ug1n6w' or uidlevel3 = 'iq4s71gcYF4' or uidlevel3 =

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-18 Thread Robin Martens
Hi devs, Sorry to bother you but it's pretty urgent. Do you have any idea about the error below? Thanks a lot! Robin From: Robin Martens Sent: 17 September 2014 17:06 To: 'Abyot Gizaw' Cc: DHIS 2 Developers list Subject: RE: [Dhis2-devs] DHIS2 - Event capture error I'm

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-17 Thread Robin Martens
ked to the upgrade? I'm in 16431 now. Robin From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 17 September 2014 14:24 To: Robin Martens Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Event capture error You mean you custom form is not shown? If you are using chrome, do

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-17 Thread Robin Martens
On this point, yes! :) From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 17 September 2014 15:24 To: Robin Martens Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Event capture error Ok good. All solved by now then? --- Thank you, Abyot. On Wed, Sep 17, 2014 at 3:15 PM, Robin

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-17 Thread Robin Martens
upgrade). Kind regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 17 September 2014 14:24 To: Robin Martens Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Event capture error You mean you custom form is not shown? If you are using chrome, do you see any log by pressing

Re: [Dhis2-devs] DHIS2 - Event capture error

2014-09-17 Thread Robin Martens
e template. How can this happen? Kind regards, Robin From: Robin Martens Sent: 17 September 2014 13:08 To: DHIS 2 Developers list Subject: DHIS2 - Event capture error Hi all, I upgraded this morning to the last version and had the following error message when trying to save a single eve

[Dhis2-devs] DHIS2 - Event capture error

2014-09-17 Thread Robin Martens
Hi all, I upgraded this morning to the last version and had the following error message when trying to save a single event without registration: "No active event exists for single event no registration program xxx, please check and correct your database". I read in the mailing list this might

Re: [Dhis2-devs] DHIS2 - Caching & testing

2014-09-17 Thread Robin Martens
lto:larshe...@gmail.com] Sent: 17 September 2014 11:38 To: Robin Martens Cc: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching & testing Actually in production, when you do a change to a data set or sections, the form should automatically be re-dow

Re: [Dhis2-devs] DHIS2 - Caching & testing

2014-09-17 Thread Robin Martens
This works great. Thanks, Lars! If it's not yet in there, might be useful to add it to the implementation or user manuals. Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 17 September 2014 11:19 To: Robin Martens Cc: dhis2-us...@lists.launchpad.net; DHIS 2 Developers

[Dhis2-devs] DHIS2 - Caching & testing

2014-09-17 Thread Robin Martens
Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally,

Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug

2014-09-16 Thread Robin Martens
Ps: we're close to our project deadlines now so I just wanted to say I appreciated your fast replies of the last days. Have a good night! Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 16 September 2014 18:35 To: Bob Jolliffe Cc: Robin Martens; dhis2

Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug

2014-09-16 Thread Robin Martens
Damn, I was thinking about upgrading today... Well, good to know for next time! :) From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 16 September 2014 18:35 To: Bob Jolliffe Cc: Robin Martens; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug

Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug

2014-09-16 Thread Robin Martens
ver, I used the PK for catoptcombos instead of the ID which is probably why DHIS2 didn't recognize them as different entries (invalid catoptcombo or something). Now it works fine. Thanks guys! Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 16 September 2014 17:2

Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug

2014-09-16 Thread Robin Martens
importing would be an alternative but is much less user-friendly. Regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 16 September 2014 16:31 To: Lars Helge Øverland Cc: Robin Martens; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] DHIS2 - Import data fro

Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug

2014-09-16 Thread Robin Martens
ptcombo set) I don't have this issue. Regards, Robin From: Olav Poppe [mailto:olav.po...@me.com] Sent: 16 September 2014 15:26 To: Robin Martens Cc: dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug Hi, I see that your log fil

[Dhis2-devs] DHIS2 - Import data from CSV - bug

2014-09-16 Thread Robin Martens
Hi devs, I'm having what seems like a bug with the import module: When importing data from CSV, I get the following error message and the batch doesn't run. However, this only happens when importing a data element over different categoryoptioncombos and only when it is new data, not updates. In

[Dhis2-devs] DHIS2 - Custom categories subaggregated results

2014-09-16 Thread Robin Martens
Hi devs, Just an idea for your feedback. We sometimes have DE with multiple categories where, for indicator calculations, we only need sub-aggregated results. Let me give an example: DE: Workers Categories: Gender (2 options), Sector (10 options) I have my indicator: number of women working in

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens
indicators than others (our project is in forest management). Have a nice day, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 11 September 2014 19:00 To: Robin Martens Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DH

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens
on Pickering [mailto:jason.p.picker...@gmail.com] Sent: 11 September 2014 16:30 To: Robin Martens Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, You lost me. Could you maybe give a somewhat simpler exam

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens
L or zero, but rather not defined (the dimension does not exist). Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 10 September 2014 17:55 To: Robin Martens Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>; dhis2-devs

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens
Thanks a lot, Jason. I'll consider filing a blueprint for this. Regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 10 September 2014 17:55 To: Robin Martens Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs]

[Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-10 Thread Robin Martens
Dear all, I've been testing the indicator calculation algorithm and noticed something particular of which I'm not sure if it's a bug or a deliberate development choice. Indicators are not explicitly defined per category such as data elements but the reporting tools allow a disaggregated indica

Re: [Dhis2-devs] Auto-calculated data in entry forms

2014-09-08 Thread Robin Martens
tion? How would that work? Thanks a lot! Robin From: Pamod Amarakoon [mailto:pam...@gmail.com] Sent: 02 September 2014 06:54 To: Ngoc Thanh Nguyen Cc: dhis2-devs; Robin Martens; DHIS 2 Users list; Jason Pickering Subject: Re: [Dhis2-devs] Auto-calculated data in entry forms Hi, Thanks a lot

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-08 Thread Robin Martens
] Sent: 07 September 2014 16:24 To: Rodolfo Melia Cc: Robin Martens; dhis2-users; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] DHIS2 - Averaging over orgunits Hi there, we will try to get it in for 2.17. One question around the design: We currently have 7 aggregation operators: sum

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-05 Thread Robin Martens
Hi Lars, Thank you. I thought so but couldn't find the reference. In the blueprint it is assigned to release 2.17, is this still being maintained? Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 05 September 2014 18:24 To: Robin Martens Cc: dhis2-users; dhis2

[Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-04 Thread Robin Martens
Hi there, As per the manual, the "average" option when defining data elements aggregates by average over periods but sum over orgunits. This limits severely the reporting possibilities, for instance when calculating the average person age over multiple districts but I can think of many other ex

[Dhis2-devs] DHIS2 - Clone event

2014-09-02 Thread Robin Martens
Hi devs, Would it be possible to include a "Clone event" button in the Event Capture module? As some events might be very similar in overhead data, it might be useful to avoid duplication of work by cloning a previous entry and simply modifying the fields that vary. In my case, this duplicatio

Re: [Dhis2-devs] Auto-calculated data in entry forms

2014-09-02 Thread Robin Martens
Thanks for the input. I'll have a look at jQuery then! Regards, Robin From: Pamod Amarakoon [mailto:pam...@gmail.com] Sent: 02 September 2014 10:54 To: Ngoc Thanh Nguyen Cc: dhis2-devs; Robin Martens; Jason Pickering; DHIS 2 Users list Subject: Re: [Dhis2-devs] Auto-calculated data in

Re: [Dhis2-devs] Auto-calculated data in entry forms

2014-09-01 Thread Robin Martens
dicators in the calculation of other indicators.) Can you confirm? Kind regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 01 September 2014 18:15 To: Robin Martens Cc: Lars Helge Øverland; DHIS 2 Developers list; DHIS 2 Users list Subject: Re: [Dhis2-devs] Auto-calculated data

[Dhis2-devs] Auto-calculated data in entry forms

2014-09-01 Thread Robin Martens
Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actuall

Re: [Dhis2-devs] [Dhis2-users] road map

2014-09-01 Thread Robin Martens
Hi Lars, Thanks for the transparency in the future development of DHIS2. About the "seamless integration of event and routine data", does it mean the aggregation query module will be obsolete and replaced by a new system? If so, what level of complexity will be available for the new query syste

Re: [Dhis2-devs] [Bug 1348566] Re: data element list empty in indicator screen

2014-08-05 Thread Robin Martens
Great, thanks again! -Original Message- From: boun...@canonical.com [mailto:boun...@canonical.com] On Behalf Of Lars Helge Øverland Sent: 05 August 2014 18:09 To: Robin Martens Subject: Re: [Dhis2-devs] [Bug 1348566] Re: data element list empty in indicator screen Hi Robin, yes you

[Dhis2-devs] [Bug 1348566] Re: data element list empty in indicator screen

2014-07-25 Thread Robin Martens
According to the manual of April, the comboid column is not available for CSV import (or at least not mentioned). You mean you can effectively specify the comboid in the CSV? Would the column come right after the "zero is significant" column in the csv? And does the same hold for all other columns

[Dhis2-devs] [Bug 1348566] Re: data element list empty in indicator screen

2014-07-25 Thread Robin Martens
Hi Lars, Thanks, that did the trick, even without restarting tomcat. The problem then seems to be the auto-fill of the categorycomboid column at meta-data import (at least from CSV). -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS

[Dhis2-devs] [Bug 1348566] [NEW] data element list empty in indicator screen

2014-07-25 Thread Robin Martens
Public bug reported: Version: 2.15 Build: 15185 When I want to open my "numerator" or "denominator" screens for indicator definition, the data element list is empty. However, when I use filters to search my data elements, they sometimes work. Below some observations: 1. No problem to retrie

[Dhis2-devs] [Bug 1337490] Re: CSV meta data import does not report correct result

2014-07-21 Thread Robin Martens
I'm having a similar issue, altough not sure if it is 100% the same. My import is complete (all data elements created or updated) but incorrect for domain type and data type. For both, whatever the data in the CSV file, the default values are stored for each data element (aggregate, and number). H

[Dhis2-devs] [Bug 1299444] Re: category combination data elements not storing values generated by aggregate query builder

2014-07-11 Thread Robin Martens
Just checked out the log file. It was an SQL syntax error as I didn't specify a condition (I merely wanted to aggregate all values), which is apparently not possible. I added a != NULL condition and both previewer and aggregator work fine now. Bug and issue solved for me! -- You received this bug

[Dhis2-devs] [Bug 1299444] Re: category combination data elements not storing values generated by aggregate query builder

2014-07-11 Thread Robin Martens
I'm still having the same issue in revision 15185, although it seems the data does exist on aggregate level (data entry and data browser) in the demo database with the same revision. In addition, the manual aggregation previewer does work on the demo version but not on my local database, again bot

[Dhis2-devs] [Bug 1331983] [NEW] orgunit-tree-is-incorrectly-persisted-after-editing-user-V2

2014-06-19 Thread Robin Martens
Public bug reported: I've copied the bug description from bug #891005 from 2011 as I have exactly the same issue. The only way to regain access to the full orgunit tree for the admin seems to be a backup recovery. --- Hi Morten , I have tried to describe steps to reproduce this bug. I think the