Mydatamart import metadata problem.

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?

You can do similar things from the pivot table module now.

···

On Oct 29, 2014 3:04 AM, rin.channara@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-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

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@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-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hello all,

I try to set up a program in DHIS2 tracker, here’s my methodology, I created a program named “test”. It is a program with single event with registration. I take an attribute called age. And I chose to rename the event date and the date of registration. After that, I chose a data element on m’y program stage. Note that I’ve checked the “Auto-generate event” box. My problem is that when I’m going to record an event in (“individual record / single event with registration”), I chose dates that are different of current date for the envent date and the Enrollment date, but after recording, when I look details of my record, the dates i chose for Enrollment and event are set to the current date. I want to know if it’s my method of setting the program which is not god or if it is a software problem.

Thank’s for helping

···

William N. D. OUANGO

Envoyé depuis Yahoo Mail pour Android

De:“Knut Staring” knutst@gmail.com
Date:mer. j oct. AM à 5:21
Objet:Re: [Dhis2-users] [Dhis2-devs] Mydatamart import metadata problem.

You can do similar things from the pivot table module now.

On Oct 29, 2014 3:04 AM, rin.channara@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-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

I mean that you can use the pivot table to download to Excel

···

On 29 Oct 2014 09:01, rin.channara@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
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@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-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

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@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
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@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-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hi William,
You should know that right now the “incident date” cannot be greater than “enrollment date”.

Also “due date” will always be equal to the “enrollment date”. Except when Using “Multiple event with out registration” then you can specify the due to either start from “enrollment date” or “incident date”.

···

On Wed, Oct 29, 2014 at 10:26 AM, Ouango william williamouango@yahoo.fr wrote:

Hello all,

I try to set up a program in DHIS2 tracker, here’s my methodology, I created a program named “test”. It is a program with single event with registration. I take an attribute called age. And I chose to rename the event date and the date of registration. After that, I chose a data element on m’y program stage. Note that I’ve checked the “Auto-generate event” box. My problem is that when I’m going to record an event in (“individual record / single event with registration”), I chose dates that are different of current date for the envent date and the Enrollment date, but after recording, when I look details of my record, the dates i chose for Enrollment and event are set to the current date. I want to know if it’s my method of setting the program which is not god or if it is a software problem.

Thank’s for helping

William N. D. OUANGO

Envoyé depuis Yahoo Mail pour Android

De:“Knut Staring” knutst@gmail.com
Date:mer. j oct. AM à 5:21
Objet:Re: [Dhis2-users] [Dhis2-devs] Mydatamart import metadata problem.

You can do similar things from the pivot table module now.

On Oct 29, 2014 3:04 AM, rin.channara@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-devs@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


Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *

“You miss 100% of the shots you don’t take.”

Hi Emmanuel,

Tank’s for answering, i understand that enrollment date must be greatest than incident date, my problem Is that when you chose for example enrollment date 02/15/2014 and incident date 07/13/2014 when you save after if you look on detail, the date you have are the current date (10/29/2014) for enrollment and incident date. It’s that my problem. Sorry, i don’t speak english so it’s difficult for me to explain clearly my problem. I think that now it’s more clear

···

On Wed, Oct 29, 2014 at 10:26 AM, Ouango william williamouango@yahoo.fr wrote:

Hello all,

I try to set up a program in DHIS2 tracker, here’s my methodology, I created a program named “test”. It is a program with single event with registration. I take an attribute called age. And I chose to rename the event date and the date of registration. After that, I chose a data element on m’y program stage. Note that I’ve checked the “Auto-generate event” box. My problem is that when I’m going to record an event in (“individual record / single event with registration”), I chose dates that are different of current date for the envent date and the Enrollment date, but after recording, when I look details of my record, the dates i chose for Enrollment and event are set to the current date. I want to know if it’s my method of
setting the program which is not god or if it is a software problem.

Thank’s for helping

William N. D. OUANGO

Envoyé depuis Yahoo Mail pour Android

De:“Knut Staring” knutst@gmail.com
Date:mer. j oct. AM à 5:21
Objet:Re: [Dhis2-users] [Dhis2-devs] Mydatamart import metadata problem.

You can do similar things from the pivot table module now.

On Oct 29, 2014 3:04 AM, rin.channara@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-devs@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


Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *

“You miss 100% of the shots you don’t take.”