Re: [Dhis2-devs] Current Quarter Considered as Last Quarter

2014-11-27 Thread Olav Poppe
Hi, 
I’ve asked about the same thing before, and it is not a bug apparently. I think 
sometime in the middle of the period, «last quarter/half-year» changes meaning 
and becomes «this quarter/half-year». Like you, I find it strange that «last 
period» could ever be a period that is not yet over, so I would love to hear 
the reasoning behind this from the team. The current behaviour is confusing, 
and also makes it very difficult to make dashboards/standard reports that don’t 
include incomplete data half of the time.

Olav



 27. nov. 2014 kl. 06.26 skrev Prosper BT ptb3...@gmail.com:
 
 Dear Team,
 
 I have noticed on several occasions that in analytics, when you specify Last 
 quarter, it bring the current quarter and also last 4 quarters included 
 current quarter.
 
 Was this intended or its bug?
 
 Regards
 
 -- 
 Prosper Behumbiize, MPH
 Phone:+256 414 320076
 Cell: +256 772 139037
  +256 752 751776
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-devs@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp



Videresendt melding:

 Dato: 27. november 2014 kl. 06.26.36 CET
 Fra: Prosper BT ptb3...@gmail.com
 Til: DHIS developers dhis2-devs@lists.launchpad.net
 Emne: [Dhis2-devs] Current Quarter Considered as Last Quarter
 
 Dear Team,
 
 I have noticed on several occasions that in analytics, when you specify Last 
 quarter, it bring the current quarter and also last 4 quarters included 
 current quarter.
 
 Was this intended or its bug?
 
 Regards
 
 -- 
 Prosper Behumbiize, MPH
 Phone:+256 414 320076
 Cell: +256 772 139037
  +256 752 751776
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-devs@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Application not viewing data after analytics

2014-11-27 Thread Isika Oliver
i did this, I am importing data from another instance but nothing shows up
on analytics

On Wed, Nov 26, 2014 at 2:48 PM, Morten Olav Hansen morte...@gmail.com
wrote:

 Did you go to orgunit level and click save? Just a guess..

 --
 Morten

 On Wed, Nov 26, 2014 at 9:41 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 on the same instance i pruned periods and updated combinations, now
 analytics throws an error that a duplicate categorycombination key exists
 and hangs up

 On Wed, Nov 26, 2014 at 2:32 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 Hi alll,
 I created an empty 2.16 database instance
 imported orgunits,dataelements,category options,categories,category
 combinations and datavalues from another 2.16 instance.I ran analytics and
 no data is showing up in reports ,I can see data when i browse using
 datasets, what could be the issue here?

 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





-- 
Yours Truly.
Munyao I. Oliver.
P.o Box 1134,
Kangundo,Kenya.


*When you say I can, and expect success, you fill yourself with
confidence and happiness.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Application not viewing data after analytics

2014-11-27 Thread Morten Olav Hansen
You also ran analytics again after doing this?

--
Morten

On Thu, Nov 27, 2014 at 3:56 PM, Isika Oliver ioliver...@gmail.com wrote:

 i did this, I am importing data from another instance but nothing shows up
 on analytics

 On Wed, Nov 26, 2014 at 2:48 PM, Morten Olav Hansen morte...@gmail.com
 wrote:

 Did you go to orgunit level and click save? Just a guess..

 --
 Morten

 On Wed, Nov 26, 2014 at 9:41 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 on the same instance i pruned periods and updated combinations, now
 analytics throws an error that a duplicate categorycombination key exists
 and hangs up

 On Wed, Nov 26, 2014 at 2:32 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 Hi alll,
 I created an empty 2.16 database instance
 imported orgunits,dataelements,category options,categories,category
 combinations and datavalues from another 2.16 instance.I ran analytics and
 no data is showing up in reports ,I can see data when i browse using
 datasets, what could be the issue here?

 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*


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


[Dhis2-devs] Fwd: Category combination set to default won't let me change it

2014-11-27 Thread Anne Grace
 
 
 Dear All,
 
 I hope you are well.
 
 I am trying to edit a category combination that is set to default…I would 
 like to add a new combination.
 attached is the screenshot.
 
 Thanks,
 
 Anne-grace 
 
 On 25 Nov 2014, at 13:28, Abyot Gizaw aby...@gmail.com wrote:
 
 I see... are you sure any of the data elements listed there are of type 
 date? When defining data elements there is an option to specify value type.
 -
 Thank you,
 Abyot.
 
 (sent from mobile)
 
 On Nov 25, 2014 12:20 PM, Anne Grace missannegr...@gmail.com wrote:
 Dear Abyot,
 
 Thanks for your prompt answer,
 unfortunately i don't have access to date in future,see attached picture.
 Screen Shot 2014-11-25 at 13.05.04.png
 On 25 Nov 2014, at 12:00, Abyot Gizaw aby...@gmail.com wrote:
 
 Hi,
 
 To enable capturing of future dates, go to your Program -- View program 
 stages -- Edit then check Date in future for those data elements you 
 wanted to capture future date.
 
 I am not sure what you mean by to be able to edit some fields names ? 
 
 If you are in default form, field name is data element Form name (if you 
 have set this one) or Name and it is always possible to edit this. If you 
 are in custom form, you can put whatever name you want in your form - both 
 data element Form name and Name have no effect.
 
 
 ---
 Thank you,
 Abyot.
 
 On Tue, Nov 25, 2014 at 10:43 AM, Anne Grace missannegr...@gmail.com 
 wrote:
 Dear Admin,
 
 I am a new devoloper in DHIS.
 I need to make changes on an existing new event form I need to allow
 future dates and years also to be able to edit some fields names .
 
 Please help me out and guide me through.
 
 Thanks
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-devs@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp
 
 
 

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


Re: [Dhis2-devs] Application not viewing data after analytics

2014-11-27 Thread Isika Oliver
Yea I did, was there some relationship missing from my import

On Thu, Nov 27, 2014 at 8:59 AM, Morten Olav Hansen morte...@gmail.com
wrote:

 You also ran analytics again after doing this?

 --
 Morten

 On Thu, Nov 27, 2014 at 3:56 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 i did this, I am importing data from another instance but nothing shows
 up on analytics

 On Wed, Nov 26, 2014 at 2:48 PM, Morten Olav Hansen morte...@gmail.com
 wrote:

 Did you go to orgunit level and click save? Just a guess..

 --
 Morten

 On Wed, Nov 26, 2014 at 9:41 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 on the same instance i pruned periods and updated combinations, now
 analytics throws an error that a duplicate categorycombination key exists
 and hangs up

 On Wed, Nov 26, 2014 at 2:32 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 Hi alll,
 I created an empty 2.16 database instance
 imported orgunits,dataelements,category options,categories,category
 combinations and datavalues from another 2.16 instance.I ran analytics and
 no data is showing up in reports ,I can see data when i browse using
 datasets, what could be the issue here?

 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





-- 
Yours Truly.
Munyao I. Oliver.
P.o Box 1134,
Kangundo,Kenya.


*When you say I can, and expect success, you fill yourself with
confidence and happiness.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Application not viewing data after analytics

2014-11-27 Thread Isika Oliver
I even tried entering data..the values show me that they are registered
but do not show up in the specific data entry sets, reports and analytics

On Thu, Nov 27, 2014 at 10:03 AM, Isika Oliver ioliver...@gmail.com wrote:

 Yea I did, was there some relationship missing from my import

 On Thu, Nov 27, 2014 at 8:59 AM, Morten Olav Hansen morte...@gmail.com
 wrote:

 You also ran analytics again after doing this?

 --
 Morten

 On Thu, Nov 27, 2014 at 3:56 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 i did this, I am importing data from another instance but nothing shows
 up on analytics

 On Wed, Nov 26, 2014 at 2:48 PM, Morten Olav Hansen morte...@gmail.com
 wrote:

 Did you go to orgunit level and click save? Just a guess..

 --
 Morten

 On Wed, Nov 26, 2014 at 9:41 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 on the same instance i pruned periods and updated combinations, now
 analytics throws an error that a duplicate categorycombination key exists
 and hangs up

 On Wed, Nov 26, 2014 at 2:32 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 Hi alll,
 I created an empty 2.16 database instance
 imported orgunits,dataelements,category options,categories,category
 combinations and datavalues from another 2.16 instance.I ran analytics 
 and
 no data is showing up in reports ,I can see data when i browse using
 datasets, what could be the issue here?

 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




-- 
Yours Truly.
Munyao I. Oliver.
P.o Box 1134,
Kangundo,Kenya.


*When you say I can, and expect success, you fill yourself with
confidence and happiness.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Analytics result headers inconsistencies(?)

2014-11-27 Thread Olav Poppe
Hi, 
been looking at the headers part of the analytics results, and I’m a bit 
confused about the name and column properties. Normally, (tableLayout = false), 
the header looks like this:
name: ‘ou’,
column: ‘Organisation Unit’,
etc… So here, the «column» would be the «display name» of that column.


When using tableLayout, it is instead like this:
name: ‘Organisation unit’,
column: ‘organisationunitname’
…
name: ‘201401’,
column: ‘january 2014’

So if you want to present this result and use the headers objects to get the 
name of the columns, you would have to use ‘name’ for the orgunit column, but 
‘column’ for the period columns in order to get nice names.

It could well be that I’m just thinking of the «headers» differently from what 
it is intended to be used for, but I find it a bit confusing that the «human 
readable» description for the different headers are sometimes in the name 
property, and sometimes in the column property - even within the same query.

Olav



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


[Dhis2-devs] [Bug 1378893] Re: Prune period and automated aggregation of tracker data fails in 2.16

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1378893

Title:
  Prune period and automated aggregation of tracker data fails in 2.16

Status in DHIS 2:
  New

Bug description:
  I have upgraded my database to 2.16. Everything is working fine, apart
  from two critical functionalities:

  1. Automated aggregate in Programs / Attributes for tracked instances to 
aggregate data raises the following error:
  at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
  at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:724)
  Caused by: org.postgresql.util.PSQLException: ERROR: null value in column 
periodid violates not-null constraint
Detail: Failing row contains (null, 1, 2013-10-08, 2013-10-08).
  at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
  at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
  at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
  at 
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
  at 
org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
  at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  ... 29 more

  
  So the only way I can aggregate now is through manual aggregation in 
individual records. 

  2. I cannot execute prune periods as the script hangs with 28 more .
   at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
  at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
  at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:724)
  Caused by: java.lang.NullPointerException
  at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)
  at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)
  ... 27 more

  *

  Might someone have figured a way out of this?

  Thanks and looking forward.
  Simon.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1378893/+subscriptions

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


[Dhis2-devs] [Bug 1369619] Re: Visualizer, show values not working when hiding series

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1369619

Title:
  Visualizer, show values not working when hiding series

Status in DHIS 2:
  Confirmed

Bug description:
  In data visualizer, the show values function for displaying numbers
  next to bars does not work properly when you click to hide the series
  (under chart title). The values seem to be placed incorrectly in the
  chart / the values of the hidden bars are not hidden themselves, and
  undefined is sometimes displayed. Steps to reproduce:

  - Create a chart with two data elements as series. Make sure show values is 
on.
  - Click on the first series/data element to hide the series.
  - Watch the values in the chart.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1369619/+subscriptions

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


[Dhis2-devs] [Bug 1371228] Re: For option sets in data entry, provide proper validation messages

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1371228

Title:
  For option sets in data entry, provide proper validation messages

Status in DHIS 2:
  Confirmed

Bug description:
  In data entry for option set fields, if you enter a value which is of
  a different value type than the data element type, a message
  explaining that the data type is wrong is provided. The system should
  rather explain that the value is outside the defined set of options.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1371228/+subscriptions

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


[Dhis2-devs] [Bug 1332829] Re: Approval analytics fails on H2

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1332829

Title:
  Approval analytics fails on H2

Status in DHIS 2:
  New

Bug description:
  
  * ERROR 2014-05-16 14:59:55,504 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-1])
  java.lang.RuntimeException: Exception during execution
at 
org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
at 
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:204)
at 
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:117)
at 
org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:124)
at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
at 
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
  Caused by: java.util.concurrent.ExecutionException: 
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL 
grammar [insert into analytics_temp_2014 
(uidlevel1,uidlevel2,uidlevel3,uidlevel4,uidlevel5,uidlevel6,daily,weekly,monthly,bimonthly,quarterly,sixmonthly,sixmonthlyapril,yearly,financialapril,financialjuly,financialoct,de,co,level,approvallevel,daysxvalue,
 daysno, value) select 
ous.uidlevel1,ous.uidlevel2,ous.uidlevel3,ous.uidlevel4,ous.uidlevel5,ous.uidlevel6,ps.daily,ps.weekly,ps.monthly,ps.bimonthly,ps.quarterly,ps.sixmonthly,ps.sixmonthlyapril,ps.yearly,ps.financialapril,ps.financialjuly,ps.financialoct,de.uid,co.uid,ous.level,(select
 coalesce(min(dal.level),999) from dataapproval da inner join dataapprovallevel 
dal on da.dataapprovallevelid = dal.dataapprovallevelid inner join 
_dataelementstructure des on da.datasetid = des.datasetid and des.dataelementid 
= dv.dataelementid wh
 ere da.periodid = dv.periodid and (ous.idlevel1 = da.organisationunitid or 
ous.idlevel2 = da.organisationunitid or ous.idlevel3 = da.organisationunitid or 
ous.idlevel4 = da.organisationunitid or ous.idlevel5 = da.organisationunitid or 
ous.idlevel6 = da.organisationunitid ) ) as approvallevel,cast(dv.value as 
double) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as 
double) as value from datavalue dv left join _dataelementgroupsetstructure degs 
on dv.dataelementid=degs.dataelementid left join 
_organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid 
left join _categoryoptiongroupsetstructure cogs on 
dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join 
_categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid 
left join _categorystructure acs on 
dv.attributeoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure 
ous on dv.sourceid=ous.organisationunitid left join _periodstructure ps on 
dv.periodid=ps.periodid 
 left join dataelement de on dv.dataelementid=de.dataelementid left join 
categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid 
left join period pe on dv.periodid=pe.periodid where de.valuetype = 'int' and 
de.domaintype = 'aggregate' and pe.startdate = '2014-01-01' and pe.startdate 
= '2014-12-31' and dv.value is not null and dv.value regexp 
'^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 
'average' or de.zeroissignificant = true ) ]; nested exception is 
org.h2.jdbc.JdbcSQLException: Column OUS.IDLEVEL1 not found; SQL statement:
  insert into analytics_temp_2014 
(uidlevel1,uidlevel2,uidlevel3,uidlevel4,uidlevel5,uidlevel6,daily,weekly,monthly,bimonthly,quarterly,sixmonthly,sixmonthlyapril,yearly,financialapril,financialjuly,financialoct,de,co,level,approvallevel,daysxvalue,
 daysno, value) select 
ous.uidlevel1,ous.uidlevel2,ous.uidlevel3,ous.uidlevel4,ous.uidlevel5,ous.uidlevel6,ps.daily,ps.weekly,ps.monthly,ps.bimonthly,ps.quarterly,ps.sixmonthly,ps.sixmonthlyapril,ps.yearly,ps.financialapril,ps.financialjuly,ps.financialoct,de.uid,co.uid,ous.level,(select
 coalesce(min(dal.level),999) from dataapproval da inner join dataapprovallevel 
dal on 

[Dhis2-devs] [Bug 1366655] Re: Email invite saves even if invite cannot be sent

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
 Assignee: (unassigned) = Lars Helge Øverland (larshelge)

** Changed in: dhis2
   Status: Confirmed = Fix Committed

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1366655

Title:
  Email invite saves even if invite cannot be sent

Status in DHIS 2:
  Fix Committed

Bug description:
  Email invite saves even if invite for various reasons cannot be sent.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1366655/+subscriptions

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


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

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1331983

Title:
  orgunit-tree-is-incorrectly-persisted-after-editing-user-V2

Status in DHIS 2:
  New

Bug description:
  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 procedure 
will work, but it took me some time to figure out how to reproduce it!

  1)Login as admin
  2)Add a new user test_user1
  3)Assing Data entry clerk
  4)Assign Badija
  5)Press Add
  6)Add a new user test_user2
  7)Assing Data entry clerk
  8)Assign Badija
  9)Press Add
  10)From the main user screen, edit the test_user1
  11)Press Bo city council, Select in group
  12)Press Save.
  13)Edit the test_user2 .

   The orgunit tree which is displayed is not the full orgunit tree of the 
current user (admin)
   but rather the orgunit tree of test_user1 which had been edited in the 
previous step. It is expected
  that what would be shown would be the full orgunit tree from the admin user

  Extra credit: Edit the orgunits for the admin user by clicking a few which 
are displayed and press Save
  Log off and login again.
  Go to Maintenance-Orgunits. The only orgunits which are displayed are the 
ones which have been assigned with no way to recover the
  full orgunit tree, without direct manipulation of usermemberships by SQL 
(DELETE FROM usermembership where userinfoid = 13;)

  It would be expected that the admin user should always have access to
  the full orgunit tree regardless of what orgunits have been assigned
  to this user (or that the assignment, and hence data entry capability)
  of the admin user should be disallowed (a la DHIS 1.4) or allowed
  regardless of which orgunits have actually been assigned.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1331983/+subscriptions

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


[Dhis2-devs] [Bug 1319120] Re: api dataValueSet error NullPointerException

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1319120

Title:
   api dataValueSet error NullPointerException

Status in DHIS 2:
  New

Bug description:
  The api resource dataValueSet returns an error when the parameter
  dataElementIdScheme=code is passed and a data element doesn't have a
  code.

  To replicate this behavior in http://apps.dhis2.org/demo delete the
  code from the data element OPV0 doses given of the data set Child
  Health (BfMAe6Itzgt) and open the api resource with the following
  link:

  
http://apps.dhis2.org/demo/api/dataSets/BfMAe6Itzgt/dataValueSet?dataElementIdScheme=code

  Tested in DHIS v2.15 build 15033

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1319120/+subscriptions

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


[Dhis2-devs] [Bug 1320838] Re: Deletion requires un-related authorities

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1320838

Title:
  Deletion requires un-related authorities

Status in DHIS 2:
  New

Bug description:
  Certain places in the system it is required to have authorities not
  related to the object one is attempting to delete. E.g. to delete a
  data element group, it is required to have access to updating data
  elements.

  This happens because the deletion handlers are cleaning up
  associations of the object being deleted by updating related objects.
  In the above case, all data element groups which the data element was
  part of must have the data element removed, then be updated.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1320838/+subscriptions

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


[Dhis2-devs] [Bug 1192604] Re: Option set UI not working well with very large option sets

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
   Status: New = Fix Committed

** Changed in: dhis2
 Assignee: Morten Olav Hansen (mortenoh) = Thu Tran (tran-hispvietnam)

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1192604

Title:
  Option set UI not working well with very large option sets

Status in DHIS 2:
  Fix Committed

Bug description:
  The option set user interface is not working well for very large
  option sets. For instance for icd 10 options, which can be up to 14
  000 options, when trying to save the option set, the request might
  time out or be too large for the webserver to accept, leading to the
  option set to drop all options.

  We need to make a user interface which does not require all options to
  be sent to the server.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1192604/+subscriptions

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


[Dhis2-devs] [Bug 1246220] Re: Problem with pivot tables when exporting/importing configs

2014-11-27 Thread Lars Helge Øverland
** Changed in: dhis2
Milestone: 2.16 = 2.18

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1246220

Title:
  Problem with pivot tables when exporting/importing configs

Status in DHIS 2:
  Confirmed

Bug description:
  I found a problem with “pivot table with details “ when importing new
  configurations using dhis 2.13.

  My case: I have configured an pivot table in an 2.13 dhis instance and 
everything is fine. 
  I exported and imported the configuration in another instance (same version), 
the pivot table appears unconfigured. 

  
  DHIS2 Version: 2.13
  Building: 12768

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1246220/+subscriptions

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


Re: [Dhis2-devs] [Bug 1246220] Re: Problem with pivot tables when exporting/importing configs

2014-11-27 Thread Pierre Dane
woo hoo - some action! :)
MOH in Mozambique has vetoed using offline DHIS2 instances on Jorn's advice
so this suddenly became a lot less of an issue for us . but still it's
important when moving pivot tables from dev systems into production.

How long are you going to be in Johannesburg for - both weeks? I'll be
there definitely for the second, maybe the tail end of the first too.

laters


On Thu, Nov 27, 2014 at 12:44 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 ** Changed in: dhis2
 Milestone: 2.16 = 2.18

 --
 You received this bug notification because you are subscribed to the bug
 report.
 https://bugs.launchpad.net/bugs/1246220

 Title:
   Problem with pivot tables when exporting/importing configs

 Status in DHIS 2:
   Confirmed

 Bug description:
   I found a problem with “pivot table with details “ when importing new
   configurations using dhis 2.13.

   My case: I have configured an pivot table in an 2.13 dhis instance and
 everything is fine.
   I exported and imported the configuration in another instance (same
 version), the pivot table appears unconfigured.


   DHIS2 Version: 2.13
   Building: 12768

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/dhis2/+bug/1246220/+subscriptions


-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1246220

Title:
  Problem with pivot tables when exporting/importing configs

Status in DHIS 2:
  Confirmed

Bug description:
  I found a problem with “pivot table with details “ when importing new
  configurations using dhis 2.13.

  My case: I have configured an pivot table in an 2.13 dhis instance and 
everything is fine. 
  I exported and imported the configuration in another instance (same version), 
the pivot table appears unconfigured. 

  
  DHIS2 Version: 2.13
  Building: 12768

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1246220/+subscriptions

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


Re: [Dhis2-devs] [Bug 1246220] Re: Problem with pivot tables when exporting/importing configs

2014-11-27 Thread Martin Brocker
Hey Pierre

I'm not sure if this email was meant to come to me?

Warm Regards,
Martin

On Thu, Nov 27, 2014 at 1:49 PM, Pierre Dane pie...@jembi.org wrote:

 woo hoo - some action! :)
 MOH in Mozambique has vetoed using offline DHIS2 instances on Jorn's advice
 so this suddenly became a lot less of an issue for us . but still it's
 important when moving pivot tables from dev systems into production.

 How long are you going to be in Johannesburg for - both weeks? I'll be
 there definitely for the second, maybe the tail end of the first too.

 laters


 On Thu, Nov 27, 2014 at 12:44 PM, Lars Helge Øverland larshe...@gmail.com
 
 wrote:

  ** Changed in: dhis2
  Milestone: 2.16 = 2.18
 
  --
  You received this bug notification because you are subscribed to the bug
  report.
  https://bugs.launchpad.net/bugs/1246220
 
  Title:
Problem with pivot tables when exporting/importing configs
 
  Status in DHIS 2:
Confirmed
 
  Bug description:
I found a problem with “pivot table with details “ when importing new
configurations using dhis 2.13.
 
My case: I have configured an pivot table in an 2.13 dhis instance and
  everything is fine.
I exported and imported the configuration in another instance (same
  version), the pivot table appears unconfigured.
 
 
DHIS2 Version: 2.13
Building: 12768
 
  To manage notifications about this bug go to:
  https://bugs.launchpad.net/dhis2/+bug/1246220/+subscriptions
 

 --
 You received this bug notification because you are subscribed to the bug
 report.
 https://bugs.launchpad.net/bugs/1246220

 Title:
   Problem with pivot tables when exporting/importing configs

 Status in DHIS 2:
   Confirmed

 Bug description:
   I found a problem with “pivot table with details “ when importing new
   configurations using dhis 2.13.

   My case: I have configured an pivot table in an 2.13 dhis instance and
 everything is fine.
   I exported and imported the configuration in another instance (same
 version), the pivot table appears unconfigured.


   DHIS2 Version: 2.13
   Building: 12768

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/dhis2/+bug/1246220/+subscriptions


-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1246220

Title:
  Problem with pivot tables when exporting/importing configs

Status in DHIS 2:
  Confirmed

Bug description:
  I found a problem with “pivot table with details “ when importing new
  configurations using dhis 2.13.

  My case: I have configured an pivot table in an 2.13 dhis instance and 
everything is fine. 
  I exported and imported the configuration in another instance (same version), 
the pivot table appears unconfigured. 

  
  DHIS2 Version: 2.13
  Building: 12768

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1246220/+subscriptions

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


Re: [Dhis2-devs] Application not viewing data after analytics

2014-11-27 Thread Isika Oliver
The data is visible in the browser but not in analytics

On Thu, Nov 27, 2014 at 10:05 AM, Isika Oliver ioliver...@gmail.com wrote:

 I even tried entering data..the values show me that they are
 registered but do not show up in the specific data entry sets, reports and
 analytics

 On Thu, Nov 27, 2014 at 10:03 AM, Isika Oliver ioliver...@gmail.com
 wrote:

 Yea I did, was there some relationship missing from my import

 On Thu, Nov 27, 2014 at 8:59 AM, Morten Olav Hansen morte...@gmail.com
 wrote:

 You also ran analytics again after doing this?

 --
 Morten

 On Thu, Nov 27, 2014 at 3:56 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 i did this, I am importing data from another instance but nothing shows
 up on analytics

 On Wed, Nov 26, 2014 at 2:48 PM, Morten Olav Hansen morte...@gmail.com
  wrote:

 Did you go to orgunit level and click save? Just a guess..

 --
 Morten

 On Wed, Nov 26, 2014 at 9:41 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 on the same instance i pruned periods and updated combinations, now
 analytics throws an error that a duplicate categorycombination key exists
 and hangs up

 On Wed, Nov 26, 2014 at 2:32 PM, Isika Oliver ioliver...@gmail.com
 wrote:

 Hi alll,
 I created an empty 2.16 database instance
 imported orgunits,dataelements,category options,categories,category
 combinations and datavalues from another 2.16 instance.I ran analytics 
 and
 no data is showing up in reports ,I can see data when i browse using
 datasets, what could be the issue here?

 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*





 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




 --
 Yours Truly.
 Munyao I. Oliver.
 P.o Box 1134,
 Kangundo,Kenya.


 *When you say I can, and expect success, you fill yourself with
 confidence and happiness.*




-- 
Yours Truly.
Munyao I. Oliver.
P.o Box 1134,
Kangundo,Kenya.


*When you say I can, and expect success, you fill yourself with
confidence and happiness.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17603: GIS legend overflow issue fixed.

2014-11-27 Thread noreply

revno: 17603
committer: Jan Henrik Overland janhenrik.overl...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-11-27 13:45:41 +0100
message:
  GIS legend overflow issue fixed.
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js	2014-08-31 15:55:29 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js	2014-11-27 12:45:41 +
@@ -730,7 +730,6 @@
 			// data
 			child = document.createElement(div);
 			child.style.height = 14px;
-			child.style.overflow = hidden;
 			child.title = this.view.columns[0].items[0].name;
 			child.innerHTML = this.view.columns[0].items[0].name;
 			element.appendChild(child);

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


[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17604: GIS legend div issue fixed.

2014-11-27 Thread noreply

revno: 17604
committer: Jan Henrik Overland janhenrik.overl...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-11-27 14:16:06 +0100
message:
  GIS legend div issue fixed.
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js	2014-11-27 12:45:41 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/mapfish/core/GeoStat/all.js	2014-11-27 13:16:06 +
@@ -725,37 +725,28 @@
 		updateLegend: function() {
 			var	element = document.createElement(div),
 child,
-legendNames;
+id,
+name;
 
 			// data
-			child = document.createElement(div);
-			child.style.height = 14px;
-			child.title = this.view.columns[0].items[0].name;
-			child.innerHTML = this.view.columns[0].items[0].name;
-			element.appendChild(child);
-
-			child = document.createElement(div);
-			child.style.clear = left;
-			element.appendChild(child);
+id = this.view.columns[0].items[0].id;
+name = this.view.columns[0].items[0].name;
+			child = document.createElement(div);
+child.style.lineHeight = 14px;
+child.style.paddingBottom = 3px;
+child.innerHTML += this.gis.response.metaData.names[id] || name || id;
+child.innerHTML += br/;
 
 			// period
-			child = document.createElement(div);
-			child.style.height = 14px;
-			child.style.overflow = hidden;
-			child.title = this.view.filters[0].items[0].name;
-			child.innerHTML = this.view.filters[0].items[0].name;
+id = this.view.filters[0].items[0].id;
+name = this.view.filters[0].items[0].name;
+child.innerHTML += this.gis.response.metaData.names[id] || name || id;
 			element.appendChild(child);
 
 			child = document.createElement(div);
 			child.style.clear = left;
 			element.appendChild(child);
 
-			// separator
-			child = document.createElement(div);
-			child.style.width = 1px;
-			child.style.height = 5px;
-			element.appendChild(child);
-
 			// legends
 			if (this.view.legendSet) {
 for (var i = 0; i  this.classification.bins.length; i++) {

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


[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17605: Script

2014-11-27 Thread noreply

revno: 17605
committer: Lars Helge Overland larshe...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-11-27 16:47:19 +0100
message:
  Script
modified:
  resources/sql/div.sql


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'resources/sql/div.sql'
--- resources/sql/div.sql	2014-10-13 10:23:17 +
+++ resources/sql/div.sql	2014-11-27 15:47:19 +
@@ -103,6 +103,13 @@
   where ura.authority = 'ALL'
 );
 
+-- User roles with authority
+
+select ur.userroleid, ur.name
+from userrole ur
+inner join userroleauthorities ura on ur.userroleid=ura.userroleid 
+where ura.authority = 'ALL';
+
 -- Turn longitude/latitude around for organisationunit coordinates (adjust the like clause)
 
 update organisationunit set coordinates=regexp_replace(coordinates,'\[(.+?\..+?),(.+?\..+?)\]','[\2,\1]')

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


Re: [Dhis2-devs] Current Quarter Considered as Last Quarter

2014-11-27 Thread Prosper BT
Exactly Olav,

See this chart on a dashboard
[image: Inline image 1]

On Thu, Nov 27, 2014 at 11:14 AM, Olav Poppe olav.po...@me.com wrote:

 Hi,
 I’ve asked about the same thing before, and it is not a bug apparently. I
 think sometime in the middle of the period, «last quarter/half-year»
 changes meaning and becomes «this quarter/half-year». Like you, I find it
 strange that «last period» could ever be a period that is not yet over, so
 I would love to hear the reasoning behind this from the team. The current
 behaviour is confusing, and also makes it very difficult to make
 dashboards/standard reports that don’t include incomplete data half of the
 time.

 Olav



 27. nov. 2014 kl. 06.26 skrev Prosper BT ptb3...@gmail.com:

 Dear Team,

 I have noticed on several occasions that in analytics, when you specify
 Last quarter, it bring the current quarter and also last 4 quarters
 included current quarter.

 Was this intended or its bug?

 Regards

 --
 Prosper Behumbiize, MPH
 Phone:+256 414 320076
 Cell: +256 772 139037
  +256 752 751776

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




 Videresendt melding:

 Dato: 27. november 2014 kl. 06.26.36 CET

 Fra: Prosper BT ptb3...@gmail.com

 Til: DHIS developers dhis2-devs@lists.launchpad.net

 Emne: [Dhis2-devs] Current Quarter Considered as Last Quarter


 Dear Team,

 I have noticed on several occasions that in analytics, when you specify
 Last quarter, it bring the current quarter and also last 4 quarters
 included current quarter.

 Was this intended or its bug?

 Regards

 --
 Prosper Behumbiize, MPH
 Phone:+256 414 320076
 Cell: +256 772 139037
  +256 752 751776

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




-- 
Prosper Behumbiize, MPH
Phone:+256 414 320076
Cell: +256 772 139037
 +256 752 751776
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Tracker Capture: Program/Program Stage Indicators

2014-11-27 Thread Adebusoye Anifalaje
Hi devs,

I can’t see where program indicators are implemented in the new Tracker Capture 
app. It was great to see that the indicators can now be assigned to a 
particular program stage but when I tested this on the demo I couldn’t see my 
indicator. 



Best regards,

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