← Back to team overview

dhis2-devs team mailing list archive

Re: Mydatamart import metadata problem.

 

Hi Rin

Work on mydatamart has discontinued since about dhis version 2.14.  The
interfaces and data formats to dhis2 have changed a lot and mydatamart
would have to be completely rewritten to keep up.

Given that users can create datasets using the pivot table module and
download as excel, there is less need for something like mydatamart than
before.

We should remove references to it in our manual which might confuse new
users.

Regards
Bob

On 29 October 2014 06:31, <rin.channara@xxxxxxxxx> wrote:

>  Hi knut,
> yes similar, but it has less functions than in excel and can work offline
> too.
> and has anyone can fix this problem?
>
>
>
>
>
> *From:* Knut Staring <knutst@xxxxxxxxx>
> *Sent:* Wednesday, October 29, 2014 12:21 Evening
> *To:* channara rin <rin.channara@xxxxxxxxx>
> *Cc:* DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>, DHIS 2
> Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
>
> You can do similar things from the pivot table module now.
> On Oct 29, 2014 3:04 AM, <rin.channara@xxxxxxxxx> wrote:
>
>>  Hi all Dev,
>> mydatamart is important to download raw data from DHIS2 for conduce pivot
>> table and can manipulate data for offline.
>> Every I download metadata. it always has error like:
>> Popup message: Problem importing metadata near "case": syntax error
>> or
>> try many time:
>> Popup message: Problem importing metadata cannot start a transaction
>> within a transaction
>>
>> and the status displaying text take long time: importing metadata
>>
>> and console(F2):
>>
>> ----------------------------------------------------------------------------------
>> [Wed Oct 29 10:49:39 +0800 2014] [dhisweb] [debug] 'in loginCallback'
>> [Wed Oct 29 10:49:39 +0800 2014] [dhisweb] [debug] 'login success'
>> [Wed Oct 29 10:49:39 +0800 2014] [main] [debug] 'login status: LSUCCESS'
>> [Wed Oct 29 10:49:39 +0800 2014] [main] [debug] 'dhis(status) = Logged in'
>> [Wed Oct 29 10:49:41 +0800 2014] [main] [debug] 'dhis(status) = No
>> orgunit data - you need to download metadata'
>> [Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'dhis(status) = Logging
>> in to http://localhost:8090/flagship'
>> [Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] '{Using sock656 for
>> localhost:8090} {}'
>> [Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'Persisting url'
>> [Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'Persisting username'
>> [Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] '{Closing socket
>> sock656 (no connection info)}'
>> [Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] 'in loginCallback'
>> [Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] 'login success'
>> [Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'login status: LSUCCESS'
>> [Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'dhis(status) = Logged in'
>> [Wed Oct 29 10:49:45 +0800 2014] [main] [debug] 'dhis(status) = No
>> orgunit data - you need to download metadata'
>> [Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'dhis(status) = Logging
>> in to http://localhost:8090/flagship'
>> [Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] '{Using sock960 for
>> localhost:8090} {}'
>> [Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'Persisting url'
>> [Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'Persisting username'
>> [Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] '{Closing socket
>> sock960 (no connection info)}'
>> [Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] 'in loginCallback'
>> [Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] 'login success'
>> [Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'login status: LSUCCESS'
>> [Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'dhis(status) = Logged in'
>> [Wed Oct 29 10:53:39 +0800 2014] [dhisweb] [debug] 'fetching metadata'
>> [Wed Oct 29 10:53:39 +0800 2014] [dhisweb] [debug] '{Using sock988 for
>> localhost:8090} {}'
>> finally
>> [Wed Oct 29 10:53:39 +0800 2014] [main] [debug] 'dhis(status) =
>> Downloading metadata'
>> [Wed Oct 29 10:53:41 +0800 2014] [dhisweb] [debug] '{final chunk part}'
>> [Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'Metadata download
>> success'
>> [Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'extracting zip'
>> [Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'transforming metadata'
>> [Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'dhis(status) =
>> Transforming metadata'
>> [Wed Oct 29 10:53:41 +0800 2014] [dhisweb] [debug] '{Closing socket
>> sock988 (no connection info)}'
>> [Wed Oct 29 10:53:41 +0800 2014] [dhisweb] [debug] 'Metadata download
>> done: HTTP/1.1 200 OK'
>> [Wed Oct 29 10:53:42 +0800 2014] [main] [debug] 'transform: Done'
>> [Wed Oct 29 10:53:42 +0800 2014] [main] [debug] 'Transform metadata done'
>> [Wed Oct 29 10:53:42 +0800 2014] [main] [debug] 'dhis(status) = Importing
>> metadata'
>> [Wed Oct 29 11:00:09 +0800 2014] [dhisweb] [debug] 'fetching metadata'
>> [Wed Oct 29 11:00:09 +0800 2014] [dhisweb] [debug] '{Using sock1208 for
>> localhost:8090} {}'
>> finally
>> [Wed Oct 29 11:00:09 +0800 2014] [main] [debug] 'dhis(status) =
>> Downloading metadata'
>> [Wed Oct 29 11:00:11 +0800 2014] [dhisweb] [debug] '{final chunk part}'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'Metadata download
>> success'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'extracting zip'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'transforming metadata'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'dhis(status) =
>> Transforming metadata'
>> [Wed Oct 29 11:00:11 +0800 2014] [dhisweb] [debug] '{Closing socket
>> sock1208 (no connection info)}'
>> [Wed Oct 29 11:00:11 +0800 2014] [dhisweb] [debug] 'Metadata download
>> done: HTTP/1.1 200 OK'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'transform: Done'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'Transform metadata done'
>> [Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'dhis(status) = Importing
>> metadata'
>> [Wed Oct 29 11:00:46 +0800 2014] [dhisweb] [debug] 'fetching metadata'
>> [Wed Oct 29 11:00:46 +0800 2014] [dhisweb] [debug] '{Using sock680 for
>> localhost:8090} {}'
>> finally
>> [Wed Oct 29 11:00:46 +0800 2014] [main] [debug] 'dhis(status) =
>> Downloading metadata'
>> [Wed Oct 29 11:00:47 +0800 2014] [dhisweb] [debug] '{final chunk part}'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'Metadata download
>> success'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'extracting zip'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'transforming metadata'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'dhis(status) =
>> Transforming metadata'
>> [Wed Oct 29 11:00:47 +0800 2014] [dhisweb] [debug] '{Closing socket
>> sock680 (no connection info)}'
>> [Wed Oct 29 11:00:47 +0800 2014] [dhisweb] [debug] 'Metadata download
>> done: HTTP/1.1 200 OK'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'transform: Done'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'Transform metadata done'
>> [Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'dhis(status) = Importing
>> metadata'
>> (1.myDataMart) 1 %
>>
>> ----------------------------------------------------------------------------------
>>
>> Can anyone help me?
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

References