dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>


On 8 November 2011 17:17, Kamugunga Adolphe <kaadol@xxxxxxxxx> 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 <mhspohr@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>