using mydatamart in Ubuntu environment

Support - Assistance technique
1

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on this computer. Can someone help me through the process if that is possible?

Thanks

···

–

Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare

Republic of Liberia
+231-886-847-915
skype: mambu9

2

Sorry. MyDatamart is an EXE file which will only run on windows. I guess you could use a virtual machine, but it definitely will not work on Ubuntu.

Regards,

Jason

···

On Tue, Feb 19, 2013 at 12:59 PM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on this computer. Can someone help me through the process if that is possible?

Thanks

Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare

Republic of Liberia
+231-886-847-915
skype: mambu9

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

3

MyDataMart.exe is a Windows exe file.
In order to run this on Linux or Mac, you’ll need to install Windows. This can be easily done using VirtualBox (free software) which sets up a virtual machine. You install Windows (I use a stripped down WindowsXP called “TinyXP” which works fine) on the VM and run MyDataMart under Windows.

I’ve done this on both Mac and Linux and it works well.

In order to use some of the advanced spreadsheet export options, you’ll need to also install Microsoft Excel under Windows since OpenOffice/LibreOffice don’t support some of the odder Microsoft tricks.

MyDataMart makes a sql .dmart file which you can move to your Linux file system. I usually just access this directly with something like sqlite.

I’ve done this on both Mac and Ubuntu and works well.

.Mark

···

On Tue, Feb 19, 2013 at 2:59 AM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on this computer. Can someone help me through the process if that is possible?

Thanks

Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare

Republic of Liberia
+231-886-847-915
skype: mambu9

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

–
Mark Spohr, MD
mhspohr@gmail.com
+1 530 554 2230

4

You can actually run a linux mydatamart binary on ubuntu though I’ve not even done that myself for a while as the purpose of the program is to provide a way of working with your data and MS Excel (for which you really require windoze). The mydatamart binary will also run on linux under wine, but again fairly pointless without excel.

I agree with Mark … virtualbox is probably the best solution for running excel on linux. And run mydatamart on the same box.

Bob

···

On Tue, Feb 19, 2013 at 2:59 AM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on this computer. Can someone help me through the process if that is possible?

Thanks

Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare

Republic of Liberia
+231-886-847-915
skype: mambu9

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

–
Mark Spohr, MD
mhspohr@gmail.com
+1 530 554 2230

5

For the future… I have been working a bit with LibreOffice pivot tables lately, they are more flexible now than under OO and has a capacity per spreadsheet of 1 mill records. It would be interesting to see how a myDatamart + LibreOffice pivot table setup on Ubuntu could have worked out.

···

On Tue, Feb 19, 2013 at 2:59 AM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on this computer. Can someone help me through the process if that is possible?

Thanks

Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare

Republic of Liberia
+231-886-847-915
skype: mambu9

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

–
Mark Spohr, MD
mhspohr@gmail.com
+1 530 554 2230

6

That’s interesting. At the time, OOo was seen as just not being capable of handling the size of pivot we were talking about. These loads are not really what spreadsheets were designed for. So I’m very interested to hear things are looking a bit better with libreOffice.

···

On Tue, Feb 19, 2013 at 2:59 AM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on this computer. Can someone help me through the process if that is possible?

Thanks

Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare

Republic of Liberia
+231-886-847-915
skype: mambu9

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

–
Mark Spohr, MD
mhspohr@gmail.com
+1 530 554 2230

7

Stephen -

   You could try downloading and installing the Ubuntu package 'wine'.
It is a windows emulator that can run many native windows
executables. It may not work however, and is certainly not
supported...

   -David

···

On Tue, Feb 19, 2013 at 5:59 AM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on
this computer. Can someone help me through the process if that is possible?

Thanks

--
__________________________________
Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare
Republic of Liberia
+231-886-847-915
skype: mambu9

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

8

It does work (mydatamart.exe does run) but doesn't help you much in
terms of dealing with excel. So virtualbox (or similar) is the only
approach I have found useful.

···

On 20 February 2013 00:29, Dave Trombley <dave.trombley@gmail.com> wrote:

Stephen -

   You could try downloading and installing the Ubuntu package 'wine'.
It is a windows emulator that can run many native windows
executables. It may not work however, and is certainly not
supported...

   -David

On Tue, Feb 19, 2013 at 5:59 AM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on
this computer. Can someone help me through the process if that is possible?

Thanks

--
__________________________________
Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare
Republic of Liberia
+231-886-847-915
skype: mambu9

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

9

Virtual Box, VMPlayer etc. is the best option.

Far from a recommendation, but something worth a try would be to run excel in wine as well.
Somewhat of an old discussion is here: http://ubuntuforums.org/showthread.php?t=1169627

But the info page from wine says its Silver: http://appdb.winehq.org/objectManager.php?sClass=application&iId=11

···

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

On 20 February 2013 01:29, Dave Trombley dave.trombley@gmail.com wrote:

Stephen -

You could try downloading and installing the Ubuntu package ‘wine’.

It is a windows emulator that can run many native windows

executables. It may not work however, and is certainly not

supported…

-David

On Tue, Feb 19, 2013 at 5:59 AM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart on

this computer. Can someone help me through the process if that is possible?

Thanks

–

Stephen M. Gbanyan, Jr.

Assistant Director

Health Management Information System

Ministry of Health and Social Welfare

Republic of Liberia

+231-886-847-915

skype: mambu9

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

10

Virtual Box, VMPlayer etc. is the best option.

Far from a recommendation, but something worth a try would be to run excel
in wine as well.
Somewhat of an old discussion is here:
[ubuntu] Excel with Wine ?
But the info page from wine says its Silver:
WineHQ - Microsoft Excel

I have had this working reasonably well in the past. Basics worked
quite ok. But I never plucked up the courage to try and get an odbc
driver running under that environment :frowning:

I am much more interested in Lars' recent experience with LibreOffice.
Which for one thing should be able to use a jdbc driver.

···

On 20 February 2013 11:39, Saptarshi Purkayastha <sunbiz@gmail.com> wrote:

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

On 20 February 2013 01:29, Dave Trombley <dave.trombley@gmail.com> wrote:

Stephen -

   You could try downloading and installing the Ubuntu package 'wine'.
It is a windows emulator that can run many native windows
executables. It may not work however, and is certainly not
supported...

   -David

On Tue, Feb 19, 2013 at 5:59 AM, Stephen Gbanyan <mambu9@gmail.com> wrote:
> Hi All,
>
> I have installed Ubuntu 12.04 on my laptop and I want to use mydatamart
> on
> this computer. Can someone help me through the process if that is
> possible?
>
> Thanks
>
> --
> __________________________________
> Stephen M. Gbanyan, Jr.
> Assistant Director
> Health Management Information System
> Ministry of Health and Social Welfare
> Republic of Liberia
> +231-886-847-915
> skype: mambu9
>
> _______________________________________________
> Mailing list: DHIS 2 Users in Launchpad
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : DHIS 2 Users in Launchpad
> More help : ListHelp - Launchpad Help
>

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help