I mean that you can use the pivot table to download to Excel On 29 Oct 2014 09:01, <rin.chann...@gmail.com> 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 <knu...@gmail.com> > *Sent:* Wednesday, October 29, 2014 12:21 Evening > *To:* channara rin <rin.chann...@gmail.com> > *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>, DHIS 2 > Users list <dhis2-users@lists.launchpad.net> > > You can do similar things from the pivot table module now. > On Oct 29, 2014 3:04 AM, <rin.chann...@gmail.com> 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-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> 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
