dhis2-devs team mailing list archive

[<rin.channara@xxxxxxxxx>]

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
Sent: ‎Wednesday‎, ‎October‎ ‎29‎, ‎2014 ‎12‎:‎21‎ ‎Evening
To: channara rin
Cc: DHIS 2 Developers list, DHIS 2 Users list





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