Re: [Dhis2-devs] Script issue related to unexpected (injected) character

2018-08-03 Thread Greg Rowles
connectionTimeout="2" >URIEncoding="UTF-8" > /> > > > On Aug 3, 2018, at 8:13 AM, Greg Rowles wrote: > > Hi Devs > > We're encountering an unusual issue when transferring DHIS2 WAR files from > one server to another; s

[Dhis2-devs] Script issue related to unexpected (injected) character

2018-08-03 Thread Greg Rowles
Hi Devs We're encountering an unusual issue when transferring DHIS2 WAR files from one server to another; something causes [dashboard.js] to inject a special character preventing the loading of dashboard content. Any thoughts? [image: image.png] Kind Regards, Greg -- *Health Information

Re: [Dhis2-devs] SCORE CARD 2.4 BETA 1.4

2018-05-31 Thread Greg Rowles
Hi Stanley Does your widget use scripts that reference dhis2-cdn.org? I've noticed the domain no longer works (this might affect embedded charts+tables); If this is the case I suggest you change that link to point to a local DHIS2 version of that file, e.g. in my case

Re: [Dhis2-devs] dhis2-cdn.org script resource query

2018-05-30 Thread Greg Rowles
For the record it seem dhis2-cdn.org is not working at all. I've just discovered an app that previously worked fine is also experiencing issues referencing files on that domain... On Wed, May 30, 2018 at 7:45 AM, Greg Rowles wrote: > Thanks Pooben, got it to work... > > On Wed, May

Re: [Dhis2-devs] dhis2-cdn.org script resource query

2018-05-29 Thread Greg Rowles
e visualizer app. > > Kind regards > Pooben > > On Wed, May 30, 2018 at 7:26 AM, Greg Rowles > wrote: > >> Hi Devs >> >> We've embedded a chart using v2.28 but embedded script resource [// >> dhis2-cdn.org/v228/plugin/chart.js] is giving us error 522

[Dhis2-devs] dhis2-cdn.org script resource query

2018-05-29 Thread Greg Rowles
Hi Devs We've embedded a chart using v2.28 but embedded script resource [// dhis2-cdn.org/v228/plugin/chart.js] is giving us error 522 (origin connection timeout). I've noticed a hosting error to this path. Any suggestions or workarounds? Kind Regards, Greg -- *Health Information Systems

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.28 is out

2017-10-12 Thread Greg Rowles
Thank you team! Some great enhancements, especially on pivot tables. Who can provide input on the chosen regression methods now used in visualizer? On Thu, Oct 12, 2017 at 9:59 AM, riddy ndoma wrote: > Great! > ThanksTeam! > > 2017-10-11 20:14 GMT+01:00 Kamugunga Adolphe

[Dhis2-devs] Slack

2017-03-06 Thread Greg Rowles
Hi Devs I'm stuck with Slack, unable to retrieve forgotten password or access a dhis2 email acc with my name. Can anyone help? Greg ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe :

Re: [Dhis2-devs] User role to grant access to custom app

2017-03-01 Thread Greg Rowles
Thanks Pooben! Sorted On Wed, Mar 1, 2017 at 8:26 PM, Greg Rowles <greg.row...@gmail.com> wrote: > Hi Devs > > Anyone know of a user-role-authority for allowing users access to my > custom app? > > > > On Wed, Mar 1, 2017 at 1:42 PM, Greg Rowles <greg.row.

[Dhis2-devs] User role to grant access to custom app

2017-03-01 Thread Greg Rowles
Hi Devs Is there a user-role (missing perhaps) for users with limited access to see new apps in the application-drawer? I'm having no luck... Greg -- *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - * Mobile :073 246 2992 Landline: 021 851 2216 Skype:

[Dhis2-devs] Blocked by CORS policy but CORS list loaded

2017-02-22 Thread Greg Rowles
Dear Dev-Community Is anyone aware of configuration settings in DHIS2 or tomcat that would disallow API requests to DHIS when CORS whitelist items are loaded correctly? Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - -

[Dhis2-devs] Any Known CORS issues with 2.20 build 16795

2017-02-21 Thread Greg Rowles
Hi Devs Please advise. I'm migrating my web app to a remote server (previously it was running inside webapps folder on the same server as my dhis2 instance). I've configured my CORS whitelist correctly but i'm unable to access the APIs successfully. I've tried two methods: [image: Inline image

Re: [Dhis2-devs] Javascript cross domain access to DHIS2

2017-02-02 Thread Greg Rowles
Hi James DHIS does allow cross domain access. A few things you need to preconfigure include: 1. CORS white list (under settings / access), add your webpage URL/domain to this list 2. ensure you are querying DHIS2 on the same HTTP or HTTPS protocol as your webpage (avoid using different protocols

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.25 is released

2016-10-13 Thread Greg Rowles
Thank you Lars and Dev team! Fantastic news! Looking forward to the new features! On Thu, Oct 13, 2016 at 1:55 PM, Asif wrote: > Congrats Lars and the Dev team. This release comes out with some really > good stuff. Look forward to upgrading to this version soon. > >

Re: [Dhis2-devs] DHIS 2.24 migrated from HTTP to HTTPS (pivot table error)

2016-10-11 Thread Greg Rowles
onnector is setup >> properly to look something like >> >> >> > scheme="https" address="127.0.0.1" >>connectionTimeout="2" >>URIEncoding="UTF-8" >>redirectPort="8443" /> >>

Re: [Dhis2-devs] DHIS 2.24 migrated from HTTP to HTTPS (pivot table error)

2016-10-11 Thread Greg Rowles
Hi Jan, JSON file attached... Regards, Greg On Tue, Oct 11, 2016 at 1:42 PM, Jan Henrik Øverland <j...@dhis2.org> wrote: > Hi Greg, > > What do you get here: https://sanac.hisp.org/staging/api/system/info.json > -> contextPath ? > > On 11 October 2016 at 1

[Dhis2-devs] DHIS 2.24 migrated from HTTP to HTTPS (pivot table error)

2016-10-11 Thread Greg Rowles
Hi Devs We moved our DHIS2 to an HTTPS domain but we're unable to view pivot tables (pls see attached console errors). Any suggestions? Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - * Mobile :+27 73

Re: [Dhis2-devs] CORS: accessing HTTP from HTTPS

2016-09-29 Thread Greg Rowles
:38 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Maybe http://my-dhis2-analytics-call.json/?etc needs to be > https://my-dhis2-analytics-call.json/?etc ? > > On Thu, Sep 29, 2016 at 1:09 PM, Greg Rowles <greg.row...@gmail.com> > wrote: > >> Hi De

[Dhis2-devs] CORS: accessing HTTP from HTTPS

2016-09-29 Thread Greg Rowles
Hi Devs Sorry, I'm running into all kinds of issues with CORS today: Mixed Content: The page at 'https://my-source-page.html' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint ' http://my-dhis2-analytics-call.json?etc'. This request has been blocked; the content must be

[Dhis2-devs] Mutiple items in CORS whitelist (v2.24)

2016-09-29 Thread Greg Rowles
Hi Devs I'm testing API calls to a server from two different source locations (dev & staging instances) but i'm unable to load the correct values (under Access settings > CORS whitelist) for these calls to work from both locations. What are the limitations for CORS whitelist items? I've tried

Re: [Dhis2-devs] play.dhis2.org/demo: admin password not 'district' ?

2016-05-18 Thread Greg Rowles
gt; Regards, > Erling > > On Wed, May 18, 2016 at 9:19 AM, Greg Rowles <greg.row...@gmail.com> > wrote: > >> Hi Devs >> >> Any advice? I'm unable to login with admin and district... (have tried >> Chrome, Firefox, Safari and Opera so it's probably not my brow

[Dhis2-devs] play.dhis2.org/demo: admin password not 'district' ?

2016-05-18 Thread Greg Rowles
Hi Devs Any advice? I'm unable to login with admin and district... (have tried Chrome, Firefox, Safari and Opera so it's probably not my browser...) Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - * Mobile

Re: [Dhis2-devs] WebAPI: Calculating indicator SUM/AVG for Quarters in a previous year

2016-05-09 Thread Greg Rowles
Sorry, I should have been clearer. I mean to collapse the period dimension and calculate the average or sum depending on the indicator type... On Mon, May 9, 2016 at 1:49 PM, Greg Rowles <greg.row...@gmail.com> wrote: > Dear Devs > > Is there a way to call the analytics API so tha

[Dhis2-devs] WebAPI: Calculating indicator SUM/AVG for Quarters in a previous year

2016-05-09 Thread Greg Rowles
Dear Devs Is there a way to call the analytics API so that it calculates an indicator value for 2 quarters in a previous year? E.g. I want the average indicator score for an indicator but from Q2 + Q3 of 2015 and not the individual quarterly values but the combined average for that period

Re: [Dhis2-devs] Health Indexes: limited to a single "indicator weight" value

2016-04-15 Thread Greg Rowles
rote: > Hi Greg, > > unfortunately we do not have this kind of feature on the road map per now. > > regards, > > Lars > > On Wed, Feb 10, 2016 at 7:51 AM, Greg Rowles <greg.row...@gmail.com> > wrote: > >> Hi Devs >> >> >> >> Are we any clos

Re: [Dhis2-devs] Incorporating complex formulas into indicators and validations

2016-03-21 Thread Greg Rowles
Hi Laura It sounds like you need an ETL developer to write custom scripts. We were required to do similar aggregations for our MomConnect project in South Africa. At the end of the day (with guidance from Jason Pickering) we wrote a single (complex) script which was saved as a postgreSQL function

[Dhis2-devs] DHIS2 to Shape File (Export)

2016-03-19 Thread Greg Rowles
Dear Devs Is anyone aware of export functionality allowing the generation of a shape file from DHIS2 coordinate data? If not - is there any viability in getting a scholar involved in GSoC to develop this type of functionality? Portable data is a security risk but luckily none of us are potential

[Dhis2-devs] Fwd: Analytics API including numerator + denominator values

2016-02-18 Thread Greg Rowles
Hi All Are my mails not getting through or am i asking the wrong questions? Greg -- Forwarded message -- From: Greg Rowles <greg.row...@gmail.com> Date: Wed, Feb 17, 2016 at 9:06 AM Subject: Re: Analytics API including numerator + denominator values To: Morten Olav Hansen

[Dhis2-devs] Health Indexes: limited to a single "indicator weight" value

2016-02-09 Thread Greg Rowles
Hi Devs Are we any closer to implementing custom attribute values for indicator + group pairings? We want to develop health index calculators at the indicator-group membership level which requires us to define a "weight" value for this pair combination. This seems the logical place to assign an

[Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
Hi Devs Our analytics process is failing with the following error: [image: Inline image 1] Any suggestions? This is a production DHIS2 instance which hasn't refreshed analytics for 4 days. Please help... Kind Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - -

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
ps. 9295515 was the periodid (record) we deleted. The other duplicate periodid was 9295516... On Fri, Feb 5, 2016 at 2:19 PM, Greg Rowles <greg.row...@gmail.com> wrote: > We're running 2.19 but i found the duplicate. We had 2 period rows with > the exact same values. I delet

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
1:21 PM, "Greg Rowles" <greg.row...@gmail.com> wrote: > >> ps. 9295515 was the periodid (record) we deleted. The other duplicate >> periodid was 9295516... >> >> On Fri, Feb 5, 2016 at 2:19 PM, Greg Rowles <greg.row...@gmail.com> >> wrote: >

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
Helge Øverland <l...@dhis2.org> wrote: > Hi Greg, which DHIS 2 version / build is it? > > Lars > > On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles <greg.row...@gmail.com> wrote: > >> Hi Devs >> >> Our analytics process is failing with the followin

Re: [Dhis2-devs] [Dhis2-users] New DHIS 2 developer joins HISP US

2015-11-19 Thread Greg Rowles
Welcome Ken! Best, Greg On Fri, Nov 20, 2015 at 4:05 AM, Morten Olav Hansen wrote: > Welcome Ken! > > -- > Morten > > On Fri, Nov 20, 2015 at 4:52 AM, Pepe Ken Mvulu > wrote: > >> Welcome Ken ! >> >> Thank you >> >> Pepe Ken Mvulu >> >> 2015-11-19

[Dhis2-devs] Cannot Run HTML reports under 2.21 (revision 20884)

2015-11-10 Thread Greg Rowles
Hi Devs Standard Reports bug. Users cannot run HTML reports. "dhis-web-reporting/getReportParams.action" jumps to "api/reports/REPORT_UID/data.pdf" and no longer executing "generateHtmlReport.action"... Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- -

Re: [Dhis2-devs] Getting timeliness rates?

2015-11-04 Thread Greg Rowles
t;> >> >> >> >> *From:* Dhis2-devs [mailto:dhis2-devs-bounces+imeasangansi= >> gmail@lists.launchpad.net] *On Behalf Of *Greg Rowles >> *Sent:* Wednesday, November 4, 2015 9:10 AM >> *To:* Olav Poppe >> *Cc:* Jens Johan Kaasbøll; dhis2-devs@lists.launchp

Re: [Dhis2-devs] Getting timeliness rates?

2015-11-04 Thread Greg Rowles
Hi All We are relying more and more on these DQ metrics in South Africa (for providing feedback to health on policy adherence). Having access to DQ data under analytics is super important for us too! But I know this is a massive piece of work so we are waiting patiently :) On Wed, Nov 4, 2015

[Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
Hi Devs Is there an API call to add missing period records? E.g. we have no yearly (periodtypeid: 8) records in an instance which has restricted access. Only API calls are supported... Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - -

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
Regards, > Jason > > > On Mon, Sep 28, 2015 at 2:10 PM, Greg Rowles <greg.row...@gmail.com> > wrote: > >> Hi Devs >> >> Is there an API call to add missing period records? E.g. we have no >> yearly (periodtypeid: 8) records in an instance which has restr

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
1 month'::interval - '1 > day'::interval)::date as startdate from > (SELECT * FROM generate_series('2015-01-01'::date,'2015-12-31'::date, '1 > month') as startdate) as foo > > > > On Mon, Sep 28, 2015 at 2:43 PM, Greg Rowles <greg.row...@gmail.com> > wrote:

[Dhis2-devs] Analytics API: Dimensions cannot be specified more than once

2015-09-04 Thread Greg Rowles
Hi Devs We're working on a report that accepts multiple (indicator) dx parameter values. From this list we're trying to build an API call that includes numerator + denominator formula UIDs so that we also display numerator and denominator totals in the report. Example parameter for 3 indicator

Re: [Dhis2-devs] Analytics API: Dimensions cannot be specified more than once

2015-09-04 Thread Greg Rowles
ponse should tell you which dimensions are duplicated. > > regards, > > Lars > > > On Fri, Sep 4, 2015 at 3:25 PM, Greg Rowles <greg.row...@gmail.com> wrote: > >> Hi Devs >> >> We're working on a report that accepts multiple (indicator) dx paramete

[Dhis2-devs] CORS VS Service Layer Access

2015-09-01 Thread Greg Rowles
Hi Devs Does anyone know if there are plans or even if its possible to support service layer access requests from external applications? E.g. pulling a custom HTML report from the Sierra Leone instance from my web application (similar to CORS but more like cross origin service sharing). I'm sure

Re: [Dhis2-devs] Webapi result with orgunit type along with orgunit

2015-08-25 Thread Greg Rowles
Hi Barath You need to implement UID alignment/standardization across these instances for all common resources. Not sure if you can access data without using CORS/White-Listing (which then requires user credentials). When you figure this out please share. We have a similar solution in mind here in

Re: [Dhis2-devs] [Dhis2-dev] Support for Audit-Trail for Tracker Datavalues ?

2015-07-29 Thread Greg Rowles
Hi Harsh If you're wanting to look for planned functionality - you can register and search launchpad for DHIS2 blueprints here: https://blueprints.launchpad.net/dhis2 Regards, Greg On Wed, Jul 29, 2015 at 9:30 AM, Harsh Atal harsh.a...@gmail.com wrote: Hi We want to see the audit trail of

Re: [Dhis2-devs] DHIS2 Docs

2015-07-28 Thread Greg Rowles
comments and I'll get back to you when I can. On 28 Jul 2015 10:02 am, Greg Rowles greg.row...@gmail.com wrote: Hi All These are the concepts we've been thinking about: DocumentSet, DocumentSetLevel, Document. [DocumentSet] would similar to data sets in that they are cyclical. They may

Re: [Dhis2-devs] DHIS2 Docs

2015-07-28 Thread Greg Rowles
, this is just an idea that Lars and I have been chatting about. I'll bring it up during the expert academy to get wider inputs Regards calle On 27 July 2015 at 12:33, Greg Rowles greg.row...@gmail.com wrote: Hi Devs I heard there is talk for supporting document storage as part of DHIS2

[Dhis2-devs] DHIS2 Docs

2015-07-27 Thread Greg Rowles
Hi Devs I heard there is talk for supporting document storage as part of DHIS2 but I don't find any plans on launchpad. Can anyone confirm? Kind Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *

[Dhis2-devs] DHIS2 Numerator + Denominators

2015-07-17 Thread Greg Rowles
Hi Devs I know v2.20 had plans for exposing numerator and denominator values and that this will probably be moved to a later version but is there an easy way to extract these values from within the database using custom views? Can one not 'freeze' the analytics process and draw out temporary

Re: [Dhis2-devs-core] google summary

2015-07-11 Thread Greg Rowles
Congratulations Lars and the DHIS2 team! Just wondering if and when the google project begins - is there any possibility that some of us could be exposed to or participate in those developments? Greg On Tue, Jul 7, 2015 at 3:14 PM, Halvdan Grelland halvda...@gmail.com wrote: Very cool!

[Dhis2-devs] WebAPI Issue with 'aggregationType=STDDEV'

2015-07-03 Thread Greg Rowles
Hi Devs I've started work on Z-Score reports but I'm having to use a javascript function to calculate standard deviation. I think we have a bug or user-error with the aggregationType=STDDEV implementation or I'm not using it correctly because I expect only 1 stDev value per dx based on the

[Dhis2-devs] Analytics API: ORDER BY [CASE]

2015-07-03 Thread Greg Rowles
Hi Devs I'm trying to figure out how the API manages the output sequence of data values. I can tell that it must use ORDER BY [CASE] for dx values (according to the querystring sequence) but there is no obvious sequencing of ou values. Without understanding the underlying components - is it

Re: [Dhis2-devs] Analytics API: ORDER BY [CASE]

2015-07-03 Thread Greg Rowles
... On Fri, Jul 3, 2015 at 1:43 PM, Greg Rowles greg.row...@gmail.com wrote: Hi Devs I'm trying to figure out how the API manages the output sequence of data values. I can tell that it must use ORDER BY [CASE] for dx values (according to the querystring sequence) but there is no obvious

[Dhis2-devs] Including Numerator + Denominator values in WebAPI outputs: 2.20

2015-06-23 Thread Greg Rowles
Hi Devs I came across the following blue-print: https://blueprints.launchpad.net/dhis2/+spec/analytics-numerator-denominator targeted for 2.20 Does anyone know if this has been done for the snapshot version or will be made part of 2.20 final? Thanks, Greg -- *Health Information Systems

[Dhis2-devs] DHIS2 Standard Reports: API ~ CORS

2015-06-08 Thread Greg Rowles
Hi Devs Is there any way to access a standard HTML report using some type of cross origin handler? Accessing a report over API (e.g. ...api/reports/AbCdEfGH123/data.html) only presents the custom code which is obviously handled better by generateHtmlReport.action. Is there perhaps an alternative

[Dhis2-devs] CORS: JSONP code sample

2015-06-03 Thread Greg Rowles
Hi Devs I'm testing JSONP capabilities against version 2.19 but struggling a little to be honest. Does anyone have a code sample that works against the demo instance or similar? Thank you, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - -

Re: [Dhis2-devs] displayProperty NAME vs SHORTNAME in API

2015-03-31 Thread Greg Rowles
Done: https://blueprints.launchpad.net/dhis2/+spec/expanding-api-displayproperty On Tue, Mar 31, 2015 at 4:57 PM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Greg, yes we can add this long-term, feel free to write a blueprint. regards, Lars On Thu, Mar 26, 2015 at 10:00 PM, Greg

[Dhis2-devs] displayProperty NAME vs SHORTNAME in API

2015-03-26 Thread Greg Rowles
Hi Devs Is there a chance the webAPI can support multiple parameters for 'displayProperty' on different objects? e.g. displayProperty=ou:NAME;de:SHORTNAME; We have terribly long data element and indicator names that are better suited as shortnames on reports but the ripple effect is our facility

Re: [Dhis2-devs] webAPI JSON: (hierarchyMeta=true) outputs in Event Report VS Pivot Reports

2015-03-24 Thread Greg Rowles
: Data are all missing. Greg On Tue, Mar 24, 2015 at 10:23 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Devs We've picked up an inconsistency between Event aggregate analytics (API) and the regular aggregated analytics (API). JSON output for the latter (when requesting 'hierarchyMeta

[Dhis2-devs] webAPI JSON: (hierarchyMeta=true) outputs in Event Report VS Pivot Reports

2015-03-24 Thread Greg Rowles
Hi Devs We've picked up an inconsistency between Event aggregate analytics (API) and the regular aggregated analytics (API). JSON output for the latter (when requesting 'hierarchyMeta=truedisplayProperty=NAME') includes metaData.ouNameHierarchy but not for the event aggregate analytics API call.

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-19 Thread Greg Rowles
collection. I'm trying to split ouNameHierarchy into its different parent values for use in a custom report. Regards, Greg -- Original message-- *From: *Mark Polak *Date: *Wed, 18 Mar 2015 22:44 *To: *Greg Rowles; *Cc: *DHIS 2 developers; *Subject:*Re: [Dhis2-devs] api

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-19 Thread Greg Rowles
19, 2015 at 9:19 AM, Knut Staring knu...@gmail.com wrote: How much data would it be if you took everything? On 19 Mar 2015 08:14, Greg Rowles greg.row...@gmail.com wrote: Hi Mark My JSON request: api/analytics.json?dimension=pe:LAST_3_MONTHSdimension=dx:trqWVUf9e6D;lPVvmrINVHS

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-19 Thread Greg Rowles
+47 970 36 752 On 19 Mar 2015, at 07:49, Greg Rowles greg.row...@gmail.com wrote: Thanks Jason, I'll do some testing. I know offhand of a viewClass parameter but it may not be applicable to this object, will see... Best, Greg On Thu, Mar 19, 2015 at 7:46 AM, Jason Pickering

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-19 Thread Greg Rowles
19, 2015 8:14 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Mark My JSON request: api/analytics.json?dimension=pe:LAST_3_MONTHSdimension=dx:trqWVUf9e6D;lPVvmrINVHS;eDktBD88IULdimension=ou:LEVEL-3;JLA7wl59oN3hierarchyMeta=truedisplayProperty=NAMEshowHierarchy=true The objective

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-19 Thread Greg Rowles
=false On Thu, Mar 19, 2015 at 12:45 PM, Greg Rowles greg.row...@gmail.com wrote: Not sure if this will become an app or not, too early to tell. I think Jason's json URL will definitely work! Thanks guys! On Thu, Mar 19, 2015 at 11:52 AM, Mark Polak mar...@ifi.uio.no wrote: Yes exactly

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-19 Thread Greg Rowles
...@ifi.uio.no +47 970 36 752 On 19 Mar 2015, at 10:47, Jason Pickering jason.p.picker...@gmail.com wrote: Does this not provide what you need? https://apps.dhis2.org/demo/api/metaData.json?assumeTrue=falseorganisationUnitLevels=true Regards, Jason On Thu, Mar 19, 2015 at 9:27 AM, Greg Rowles

[Dhis2-devs] Assistance required debugging HTML report

2015-03-19 Thread Greg Rowles
Hi Devs Does anyone have time to test an HTML report with me on the demo site? I will give you a nice bottle of red wine next time you visit Cape Town... Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *

Re: [Dhis2-devs] Testing modified JSON inside of Pivot Tables

2015-03-18 Thread Greg Rowles
is that the JSON analytics request only contains the data source for the pivot, not the layout of it. What you can do is to simply paste the URL into a web browser or use curl to test it, and see how your changes affects output. best regards, Lars On Tue, Mar 17, 2015 at 12:10 PM, Greg Rowles

Re: [Dhis2-devs] Testing modified JSON inside of Pivot Tables

2015-03-18 Thread Greg Rowles
Of course I forgot to mention the drill-through filter on OU-level or parent ouUID... On Wed, Mar 18, 2015 at 1:26 PM, Greg Rowles greg.row...@gmail.com wrote: Hi Jan + Lars We're doing rapid reports development and most of our specifications appear to be in a pivot table layout. To answer

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-18 Thread greg . rowles
-- Original message--From: Mark PolakDate: Wed, 18 Mar 2015 22:44To: Greg Rowles;Cc: DHIS 2 developers;Subject:Re: [Dhis2-devs] api/organisationUnitLevels Hey Greg, Unfortunately i don’t think sorting through the api is available “yet”. What are you using it for? Kind regards, Mark Polakmark

Re: [Dhis2-devs] api/organisationUnitLevels

2015-03-18 Thread greg . rowles
 ouNameHierarchy into its different parent values for use in a custom report.  Regards, Greg -- Original message--From: Mark PolakDate: Wed, 18 Mar 2015 22:44To: Greg Rowles;Cc: DHIS 2 developers;Subject:Re: [Dhis2-devs] api/organisationUnitLevels Hey Greg, Unfortunately i don’t think

[Dhis2-devs] displayProperty SHORTNAME: not cascading to ouNameHierarchy brach

2015-03-18 Thread Greg Rowles
Hi Devs When outputting data to JSON using SHORTNAME, the ouNameHierarchy is always defaulting to LONG NAME making quick lookups impossible... Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *

[Dhis2-devs] api/organisationUnitLevels

2015-03-18 Thread Greg Rowles
Hi Devs Is it possible to have the organisationUnitLevels stack outputted in the sequence the hierarchy is arranged? E.g. it appears to be sorted by name value with 'National' always appearing down the list (it should be 1st)... Best, Greg -- *Health Information Systems Program - South Africa*

[Dhis2-devs] Testing modified JSON inside of Pivot Tables

2015-03-17 Thread Greg Rowles
Hi Devs Is there any way or planned functionality for testing JSON urls inside of pivot tables? E.g. I set up a pivot table then download the JSON data source but then want to test a modified version of that JSON string inside the current session... is that possible or do-able...? Greg --

[Dhis2-devs] Executing [Schedule automated aggregation] only working for [Last month]

2015-02-25 Thread Greg Rowles
Hi Devs We've noticed our Aggregation-Queries are only loading values for the last month regardless of the selected time frame. Is there a known bug or known cause for this problem? Perhaps its a data-quality issue (we're still refining our data quality kinks, i.e. there may be

Re: [Dhis2-devs] [openXdata-dev] Re: Nice videos on the OXD site

2015-02-24 Thread Greg Rowles
Has anyone used OpenXdata with DHIS2 yet? On Mon, Dec 13, 2010 at 11:20 AM, Knut Staring knu...@gmail.com wrote: Thanks a lot Raghu, Wink seems very straightforward and useful! Knut On Mon, Dec 13, 2010 at 6:56 AM, Raghu Mittal raghu.mit...@gmail.com wrote: Hi We generally use Wink for

Re: [Dhis2-devs] Mission Impossible: DHIS2 report data to CSV with cross-domain API calls

2015-02-19 Thread Greg Rowles
the targets need to go into attribute tables . On Thu, Feb 19, 2015 at 8:51 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Everyone We're producing DHIS2 (HTML) reports for our MomConnect project and have started the process of measuring performance. We are assessing actual VS targets

[Dhis2-devs] Mission Impossible: DHIS2 report data to CSV with cross-domain API calls

2015-02-18 Thread Greg Rowles
Hi Everyone We're producing DHIS2 (HTML) reports for our MomConnect project and have started the process of measuring performance. We are assessing actual VS targets. In our case actual represents program-stage counts (from our DHIS2 instance) while our target values are pulled from a different

Re: [Dhis2-devs] [Bug 1402244] [NEW] event report/visulizer: option set sort order not respocted

2015-01-27 Thread Greg Rowles
be fixed, but please write a new bug report as it's an unrelated issue. On Thu, Jan 22, 2015 at 3:21 PM, Greg Rowles greg.row...@gmail.com wrote: Hi OIav/Devs Is this bug related to my observation: I cannot get event (aggregate) analytics to sort my data by column [OU] alphabetically ASC

Re: [Dhis2-devs] [Bug 1402244] [NEW] event report/visulizer: option set sort order not respocted

2015-01-27 Thread Greg Rowles
Sorry - pls ignore - I see included the wrong parameters for OUlevels... On Tue, Jan 27, 2015 at 11:46 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Olav, Jan and Others I think I've replicated this bug on the Sierra Leone (demo) instance: https://apps.dhis2.org/demo/api/analytics/events

[Dhis2-devs] Fwd: [Bug 1402244] [NEW] event report/visulizer: option set sort order not respocted

2015-01-22 Thread Greg Rowles
Hi OIav/Devs Is this bug related to my observation: I cannot get event (aggregate) analytics to sort my data by column [OU] alphabetically ASC. Right now data is displayed with no apparent display order... Regards, Greg -- Forwarded message -- From: Olav P

Re: [Dhis2-devs] Last hibernate sequence value

2015-01-16 Thread Greg Rowles
, 2015 at 8:35 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Devs Is there an easy way to expose the last hibernate sequence value through the web API? Greg -- *Health Information Systems Program - South Africa

Re: [Dhis2-devs] Last hibernate sequence value

2015-01-16 Thread Greg Rowles
Let me not forget to mention that this type of work would be preparatory and not after roll out... On Fri, Jan 16, 2015 at 11:20 AM, Greg Rowles greg.row...@gmail.com wrote: Thanks Bob, Jason Others I agree and understand but we have a DHIS2 implementors who prefer to work directly inside

Re: [Dhis2-devs] Last hibernate sequence value

2015-01-16 Thread Greg Rowles
things in Excel and then using the Metadata import instead (so you don't have to worry about the internal database IDs) On Fri, Jan 16, 2015 at 9:25 AM, Greg Rowles greg.row...@gmail.com wrote: Let me not forget to mention that this type of work would be preparatory and not after roll out

[Dhis2-devs] Last hibernate sequence value

2015-01-15 Thread Greg Rowles
Hi Devs Is there an easy way to expose the last hibernate sequence value through the web API? Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - * Mobile :073 246 2992 Landline: 021 554 3130 Fax:

[Dhis2-devs] Using NVD3: Converting DHIS2 dates to Unix Time Stamp format

2015-01-13 Thread Greg Rowles
Hi Devs I'm trying to set up a line chart using NVD3 (similar to example http://nvd3.org/examples/cumulativeLine.html) which requires JSON date values in the Unix Time Stamp format. Has anyone solved this date format issue before? Source data coming from DHIS2 is returned as 2012-06-27 00:00: 00

Re: [Dhis2-devs] Using NVD3: Converting DHIS2 dates to Unix Time Stamp format

2015-01-13 Thread Greg Rowles
Easy solution there! Thanks Morten! On Tue, Jan 13, 2015 at 11:54 AM, Morten Olav Hansen morte...@gmail.com wrote: Try with new Date(2012-06-27 00:00:00).getTime() On Tue Jan 13 2015 at 4:53:12 PM Greg Rowles greg.row...@gmail.com wrote: Hi Devs I'm trying to set up a line chart using

[Dhis2-devs] Expanding Display Columns under [Data element management]

2015-01-12 Thread Greg Rowles
Hi Devs We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was

Re: [Dhis2-devs] Expanding Display Columns under [Data element management]

2015-01-12 Thread Greg Rowles
On Mon, Jan 12, 2015 at 10:28 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Lars It's a little tedious to cycle through each record without seeing who created it in a single overview/grid but hopefully that upgrade will make it easier! Thanks, Greg On Mon, Jan 12, 2015 at 11:24 AM

Re: [Dhis2-devs] Expanding Display Columns under [Data element management]

2015-01-12 Thread Greg Rowles
are actually rewriting all of the meta-data screens but in the short term I think we can add this to the details dialog? (Click on the row and then show details). Does that work? Lars On Mon, Jan 12, 2015 at 10:08 AM, Greg Rowles greg.row...@gmail.com wrote: Hi Devs We have multiple

Re: [Dhis2-devs] Expanding Display Columns under [Data element management]

2015-01-12 Thread Greg Rowles
that the actual designer/creator of a data element or indicator - whether a person or a team - might not be the person who adds it to the system). Regards Calle On 12 January 2015 at 11:08, Greg Rowles greg.row...@gmail.com wrote: Hi Devs We have multiple users are working intensely on a new database

Re: [Dhis2-devs] WebAPI getting all orgunits with hierarchy info

2014-12-15 Thread Greg Rowles
Hi Simen We had a similar discussion in South Africa a few hours ago. If you have your top level orgunit UID (e.g. 'JLA7wl59oN3') you can drill using API calls such as: api/organisationUnits?filter=level:eq:2filter=parent.id:eq:JLA7wl59oN3 If you don't know your top level UID:

Re: [Dhis2-devs] Managing metadata in a distributed setting

2014-12-10 Thread Greg Rowles
Hi Bob This is an interesting challenge. I can think of different methods to address the current alignment problem but you obviously have a long term (master/meta) data management strategy to resolve. Is your current data warehouse/dashboard instance purely a consolidator of edge-system data

[Dhis2-devs] Calling Stored Procedures inside DHIS2 SQL Views

2014-12-09 Thread greg . rowles
Hi Devs  I've heard rumours of this functionality being discussed at your meeting in Jhb. Is there any further information? Kind regards, Greg ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net

[Dhis2-devs] webAPI Handler for DHIS2

2014-12-05 Thread Greg Rowles
Hi Devs Can anyone elaborate on the tools or systems used to present DHIS2 data through the webAPI? I'm trying to understand how DHIS2's database interacts with the webAPI to present output data. Is there a plugin/converter installed alongside DHIS2 that runs in the background or is that built

Re: [Dhis2-devs] webAPI Handler for DHIS2

2014-12-05 Thread Greg Rowles
. Best regards, Lars Best regards, Lars 2014-12-05 11:35 GMT+01:00 Greg Rowles greg.row...@gmail.com: Hi Devs Can anyone elaborate on the tools or systems used to present DHIS2 data through the webAPI? I'm trying to understand how DHIS2's database interacts with the webAPI to present output

[Dhis2-devs] Search Apps Feature

2014-12-03 Thread Greg Rowles
Hi Devs Is it possible to make the search-apps function also include a search into the children or grand-children of menu-shortcuts? Thanks, Greg -- *Health Information Systems Programme* *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - * Mobile :073 246 2992

[Dhis2-devs] Freestyling Charts in DHIS2 with custom views

2014-12-01 Thread Greg Rowles
Hi Guys Can anyone point me to code samples / documentation on how to build custom charts with code libraries in DHIS2? We need to do some complex queries that include a) date-difference calculations, b) running (raw data) totals, and c) run-time ratios (% of total)... Regards, Greg --

Re: [Dhis2-devs] Completeness and timeliness

2014-11-19 Thread greg . rowles
Hi Devs  This will definitely come up in SA's future rollouts too! Over the past few years the DOH in SA has placed major emphasis on data quality improvement. What we did to monitor this was generate a Data Quality data mart (along with standardized DQ elements and DQ indicators). DQ

Re: [Dhis2-devs] [Dhis2-users] Upload Image on Data entry form

2014-11-18 Thread Greg Rowles
Hi Devs Please also let us know when/how/if this functionality can be implemented outside of the data entry form? E.g. we have a MFL (in our data dictionary) - uploading photographs would be ideal for the MFL component... Many thanks, Greg On Tue, Nov 18, 2014 at 3:01 PM, Pamod Amarakoon

  1   2   >