Hi Cenk,
It looks like you are facing the same problem we are in Mozambique. Please see https://bugs.launchpad.net/dhis2/+bug/1268787 If it’s just for demo propose you can always use postgresql instead of h2 default database. You will need to install postgresql on demonstration computers, and all you need is a restore from central server database; If these are final installations to use in production environment be aware that you may need bidirectional data transmission, and on that case you can’t simply replace live databases with a dump from central server. Regards, Paulo Grácio From: Dhis2-devs [mailto:dhis2-devs-bounces+pgracio=criticalsoftware....@lists.launchpad.net] On Behalf Of D. Cenk Erdil Sent: segunda-feira, 13 de Janeiro de 2014 20:09 To: Knut Staring Cc: DHIS 2 developers Subject: Re: [Dhis2-devs] [Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13 Hi Knut, (I work with Sharada) We host server instances for in-country teams, but we need several off-line copies for demonstration and training. Also, the possibility to enter data while offline, and sync it with the server would be nice, as most our facilities do not have internet. Thus, the need to move data between server and live editions. In response to your recommendation, we might try dumping data from postgres and putting it in h2 (unless you've meant something else). I've done some googling and it looks like there are several methods to do that. Since we are time-constrained this week (our M&E staff are traveling in-country for demo/training of a shiny instance of brand new DHIS 2.13 with all its bells and whistles), I wanted to get your feedback on what would be the easiest way to move data from 2.13 server to live edition. Any feedback is greatly appreciated. Thanks. -- -Cenk. On Sat, Jan 11, 2014 at 4:31 AM, Knut Staring <knu...@gmail.com> wrote: Hi Sharada, What exactly is your use case - you want to work with the same data offline on multiple computers? You did an export + import? Could you perhaps just do a db dump and clone the database? Knut On Fri, Jan 10, 2014 at 11:27 PM, Sharada Acharya <sa3...@columbia.edu> wrote: Hi Knut, After generating the Analytics table, we could see the data in the Pivot Tables and Data set reports. Now, we have created a new DHIS live instance (2.13), in which we imported the data from the another DHIS instance (in which Pivot tables, reports woroked). But in this DHIS instance, we are still not able to see the data after generating Analytics tables. We verified that the data is present in the data set. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1267561 Title: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13 Status in DHIS 2: New Bug description: Hello, We have upgraded one of our DHIS server instances from 2.4 to 2.13 last month. Upon user feedback, we have come to realize that the three modules have issues working on data that exist in the system. In particular: 1) Data Set Reports 2) Pivot Tables 3) Data Visualizer With the data set reports, the system generates a report with blank values in the 2.13 vs. a complete report in 2.4 (see attached screenshots). With Pivot Tables and Data Visualizer, the front-end gives "no values found" error, while we see the Tomcat log references some missing relationships in the postgres database (see attached catalina.out). This behavior is consistent with two separate DHIS instances (with two different countries), both upgraded from 2.4 to 2.13. It also behaves similarly on a DHIS Live (2.13) instance which was setup on a local machine and data was imported from a server instance for the same country. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1267561/+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 -- Knut Staring Dept. of Informatics, University of Oslo +4791880522 <tel:%2B4791880522> http://dhis2.org _______________________________________________ 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
