Re: [Dhis2-users] trunk version of pivot table service

2013-03-06 Thread Lars Helge Øverland 
Hi easy, you can now find user interface for analytics table generation in
reporting module. Make sure your user has the all or data mart admin
authority.

Lars



On Tue, Mar 5, 2013 at 11:57 AM, easy lin...@126.com wrote:

 thanks


 At 2013-03-05 14:34:53,Lars Helge Øverland larshe...@gmail.com wrote:

 Hi easy, this stuff is very much under development, you need to first
 generate the analytics tables, I will finalize the user interface for that
 during the day and let you know.

 regards,

 Lars

 On Tue, Mar 5, 2013 at 4:00 AM, easy lin...@126.com wrote:

 hi,all,
   I got this error:

 * INFO  2013-03-05 10:53:18,796 Query failed, likely because the
 requested analytics table d
 oes not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-45])
 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
 SQL grammar [select
 de,Monthly, sum(value) as value from analytics_2012 where de in
 ('fbfJHSPpUQD' ) and Monthly
  in ('201212', '201211', '201210', '201209', '201208', '201207',
 '201206', '201205', '201204
 ', '201203' ) and uidlevel1 in ('ImspTQPwCqd' ) group by de,Monthly];
 nested exception is or
 g.postgresql.util.PSQLException: error:  relation analytics_2012
 doesn't exist position：45
 at
 org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(S
 QLErrorCodeSQLExceptionTranslator.java:233)
 at
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
 (AbstractFallbackSQLExceptionTranslator.java:72)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
 at
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
 at
 org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499)
 at
 org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAna
 lyticsManager.java:151)
 at sun.reflect.GeneratedMethodAccessor624.invoke(Unknown Source)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java
 :43)
 at java.lang.reflect.Method.invoke(Method.java:601)
 at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.
 java:317)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Refl
 ectiveMethodInvocation.java:183)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMe
 thodInvocation.java:150)
 at
 org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecuti
 onInterceptor.java:83)
 at
 java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
 at java.util.concurrent.FutureTask.run(FutureTask.java:166)
 at java.lang.Thread.run(Thread.java:722)
 Caused by: org.postgresql.util.PSQLException: ERROR: relation
 analytics_2012 doesn't exist position：45
 at
 org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.j
 ava:2103)
 at
 org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:18
 36)
 at
 org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
 at
 org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5
 12)
 at
 org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Stateme
 nt.java:374)
 at
 org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.j
 ava:254)
 at
 com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35
 )
 at
 org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(
 JdbcTemplate.java:441)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
 ... 13 more




 --
 此致

easy

 莫愁前路无知己，天下谁人不识君。



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





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

[Dhis2-users] GIS Module not Rendering

2013-03-06 Thread Daniel Bridges 
We are looking to upgrade to 2.11 when it comes out so have been playing 
around with the latest snapshot, unfortunately it doesn't seem to render 
in FF (v19) and am getting the following error:


[16:40:14.425] TypeError: mapfish.GeoStat is undefined @ 
http://apps.dhis2.org/dev/dhis-web-mapping/app/scripts/core.js:323


Same page works fine in Chrome.

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

[Dhis2-users] Large volume user management

2013-03-06 Thread Alvin Marcelo 
Dear all,

We're deploying DHIS2 nationally in the Philippines and I am hitting some
problems which you may help with:

We have this org unit structure - national - regional - provincial -
municipality/city. These org units will be encoded centrally.

My problem is assigning user accounts for the municipalities. Here is the
approach I plan to take:

1. Create a national administrator. He creates on sub-admin per region. (n
= 20 regions)

2. The regional sub-admins create provincial sub-admins. (n = 80 provinces)

3. The provincial sub-admins create the municipality end users (one per
municipality). (n = 3100 municipalities)

Do you suggest a devolved system for user creation as above or just to
manage this centrally?

I am expecting a lot of municipality end users forgetting their password.
How should we manage this? (There is no Forgot password function in DHIS2
right now)...

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