Need some help

Hi All,

I have started experiencing some problems with using mydatamart. When I reach to the excel and I import one year data I get an error message (error 7) and when I click ok it also tells me problem obtaining data.

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: mambu9the data

Hi Stephen

Can you share some information form the log (press F2 in mydatamart).

What is this error 7 - an excel error? Perhaps also can you provide a
sample of an offending xlsx file.

Regards
Bob

···

On 21 September 2012 11:06, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

I have started experiencing some problems with using mydatamart. When I
reach to the excel and I import one year data I get an error message (error
7) and when I click ok it also tells me problem obtaining data.

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: mambu9the data

_______________________________________________
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

Hi?

I have also obtained the same error during training,but depends on how many bit your Operating system has you can install sqliteodbc_win_32bit.exe or sqliteodbc_win_64bit.exe.for me i installed sqliteodbc_win_32bit.exe cause my operating System has 32bit and the problem resolved.in exel.

— En date de : Ven 21.9.12, Stephen Gbanyan mambu9@gmail.com a écrit :

···

De: Stephen Gbanyan mambu9@gmail.com
Objet: [Dhis2-users] Need some help
À: “dhis2-users” dhis2-users@lists.launchpad.net
Date: Vendredi 21 septembre 2012, 12h06

Hi All,

I have started experiencing some problems with using mydatamart. When I reach to the excel and I import one year data I get an error message (error 7) and when I click ok it also tells me problem obtaining data.

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: mambu9the data

-----La pièce jointe associée suit-----


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

Ah! That does explain it - thanks Venuste (see you next week … ).

The database connection strings which are embedded in the excel files make use of the 32 bit driver. So as Venuste says, install that (regardless of your operating system), not the 64 bit one.

We could make mydatamart a bit smarter in terms of checking to see which odbc drives are installed or not before producing the excel file, but in the meantime stick to the 32 bit driver.

Bob

···

On 21 September 2012 11:32, nsanzumuhire venuste vensanze@yahoo.fr wrote:

Hi?

I have also obtained the same error during training,but depends on how many bit your Operating system has you can install sqliteodbc_win_32bit.exe or sqliteodbc_win_64bit.exe.for me i installed sqliteodbc_win_32bit.exe cause my operating System has 32bit and the problem resolved.in exel.

— En date de : Ven 21.9.12, Stephen Gbanyan mambu9@gmail.com a écrit :

De: Stephen Gbanyan mambu9@gmail.com
Objet: [Dhis2-users] Need some help
À: “dhis2-users” dhis2-users@lists.launchpad.net

Date: Vendredi 21 septembre 2012, 12h06

Hi All,

I have started experiencing some problems with using mydatamart. When I reach to the excel and I import one year data I get an error message (error 7) and when I click ok it also tells me problem obtaining data.

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: mambu9the data

-----La pièce jointe associée suit-----


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