Re: [Dhis2-users] How to set up Mydatamart and dhis-live 2.5
Hi Adolphe, If you have an online DHIS 2 server running, there is no need to install DHIS2 live on regional data mangers' laptops for Excel pivots to work. The mydatamart tool can connect to the online server and download the data they want into a local datamart (sql lite database), and then Excel will pull data from the local datamart. For this to work the regional data managers will need an internet connection when downloading data (using mydatamart), and there must be an online server running somewhere that mydatamart can connect to. After the download the user can do offline data analysis in Excel. You can also use mydatamart together with an offline DHIS live install, but this is not recommended if there is already an online server running and the local user has access to internet. With DHIS Live + mydatamart in a completely offline scenario you will then have to maintain the DHIS live database (and datamart) first and make sure that it is updated and has all the data you need (e.g. import from district export files). Then you can use mydatamart to simplify the transfer of data into Excel. The mydatamart tool was first of all built to support users of an online DHIS deployment, to allow them to keep a local updated copy of the data that e.g. can be used to populate Excel pivot tables (and then enable offline data analysis). Ola - -- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway On 8 November 2011 17:17, Kamugunga Adolphe kaa...@gmail.com wrote: Hi all, I am trying to set up dhis-live 2.5 instances to facilitate practices of the regional data managers while at home, any idea on how to use mydatamart to extract data into a excel pivot table? i tried this URL http://127.0.0.1:8080/dhis but in vain, the system pops up a massage of wrong URL. Waiting for hearing from u soon. Adolphe On 8 November 2011 00:18, Mark Spohr mhsp...@gmail.com wrote: We've updated our installation in the Solomons from 2.0.4 to 2.5 without making any database changes and it runs but occasionally crashes. (We also updated Postgres and Apache to latest versions.) I am thinking that there may be some changes to the database structures causing the problem. I would like to compare the 2.0.4 database structures which I have from a pg_dump to the current 2.5 database structures. Anyone know of an easy way to do this or if this information already exists somewhere? Regards, Mark -- Mark Spohr, MD ___ 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 ___ 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] How to set up Mydatamart and dhis-live 2.5
Hi all, I am trying to set up dhis-live 2.5 instances to facilitate practices of the regional data managers while at home, any idea on how to use mydatamart to extract data into a excel pivot table? i tried this URL http://127.0.0.1:8080/dhis but in vain, the system pops up a massage of wrong URL. Waiting for hearing from u soon. Adolphe On 8 November 2011 00:18, Mark Spohr mhsp...@gmail.com wrote: We've updated our installation in the Solomons from 2.0.4 to 2.5 without making any database changes and it runs but occasionally crashes. (We also updated Postgres and Apache to latest versions.) I am thinking that there may be some changes to the database structures causing the problem. I would like to compare the 2.0.4 database structures which I have from a pg_dump to the current 2.5 database structures. Anyone know of an easy way to do this or if this information already exists somewhere? Regards, Mark -- Mark Spohr, MD ___ 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
Re: [Dhis2-users] How to set up Mydatamart and dhis-live 2.5
Try 8082. Or go to dhis-live/conf anses open the file jerry.port in notepad to see or change the port number Regards, Knut (via mobile phone) On Nov 8, 2011 2:20 PM, Kamugunga Adolphe kaa...@gmail.com wrote: Hi all, I am trying to set up dhis-live 2.5 instances to facilitate practices of the regional data managers while at home, any idea on how to use mydatamart to extract data into a excel pivot table? i tried this URL http://127.0.0.1:8080/dhis but in vain, the system pops up a massage of wrong URL. Waiting for hearing from u soon. Adolphe On 8 November 2011 00:18, Mark Spohr mhsp...@gmail.com wrote: We've updated our installation in the Solomons from 2.0.4 to 2.5 without making any database changes and it runs but occasionally crashes. (We also updated Postgres and Apache to latest versions.) I am thinking that there may be some changes to the database structures causing the problem. I would like to compare the 2.0.4 database structures which I have from a pg_dump to the current 2.5 database structures. Anyone know of an easy way to do this or if this information already exists somewhere? Regards, Mark -- Mark Spohr, MD ___ 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 ___ 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