dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

I mean that you can use the pivot table to download to Excel
On 29 Oct 2014 09:01, <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
>>
>>