[Dhis2-devs] Pivot Table Not Loading

2015-11-28 Thread gerald thomas
Dear All, We updated our instance in Sierra Leone from 2.18 to 2.19 and finally to 2.20. The job was successfully completed with everything working as it should when it was on the 2.19 war file. But on the 2.20 war file the pivot table is not working. Please find the attached file showing where is

[Dhis2-devs] DHIS Server - Setting up a scheduled event data check and update

2015-11-28 Thread James Chang
Hi, In DHIS Server, we are trying to create a scheduled task that checks events and update some data in events. We like to avoid using database scheduler (like pgadmin III PgAgent) That leaves us (We think) with: - cron job with shell script using database sql comments (in file) - cron job

Re: [Dhis2-devs] Pivot Table Not Loading

2015-11-28 Thread gerald thomas
Dear All, Please any help my Data not displaying in Pivot tables it keeps showing "initializing". On 11/28/15, gerald thomas wrote: > Dear All, > We updated our instance in Sierra Leone from 2.18 to 2.19 and finally > to 2.20. The job was successfully completed with everything working as > it sho

Re: [Dhis2-devs] Pivot Table Not Loading

2015-11-28 Thread knutst
Hi Gerald, we would need to see error messages the comsole of your browser as well as in the Tomcat log. Did you run the database update scripts? Regards, KnutSent from my Samsung Galaxy smartphone. Original message From: gerald thomas Date: 2015/11/29

Re: [Dhis2-devs] DHIS Server - Setting up a scheduled event data check and update

2015-11-28 Thread Pierre Dane
hi james, you can call Postgres functions from sqlviews (from data administration) , and the functions can do updates as well as return data. the views can also be parameterized and called through the API . On Sunday, 29 November 2015, James Chang wrote: > Hi, > > In DHIS Server, we are trying t

Re: [Dhis2-devs] DHIS Server - Setting up a scheduled event data check and update

2015-11-28 Thread Pierre Dane
so I suggest using cron with curl to call the sqlview On Sunday, 29 November 2015, James Chang wrote: > Hi, > > In DHIS Server, we are trying to create a scheduled task that checks > events and update some data in events. > > We like to avoid using database scheduler (like pgadmin III PgAgent) >