dhis2-users team mailing list archive

[deemoyes@xxxxxxxxx]

To run the datamart manually, you go to Services, Reports and to the left you see Datamart for version 2.10 or Analytic Datamart for version 2.11.

Click on it, and make the fields as you desire then period and run

Dayo
Sent from my BlackBerry® smartphone from Etisalat. Enjoy high speed mobile broadband on our easyblaze and plans for BlackBerry. Visit www.etisalat.com.ng for details.

-----Original Message-----
From: Orvalho Augusto <orvaquim@xxxxxxxxx>
Date: Tue, 14 May 2013 09:44:10 
To: Ocaya Stephen<stephocay@xxxxxxxxx>
Cc: Dayo Adeyomoye<deemoyes@xxxxxxxxx>; Dhis2-users<dhis2-users-bounces+deemoyes=yahoo.com@xxxxxxxxxxxxxxxxxxx>; dhis1-users<dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers<dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Troubles running datamart

Thank you!

The dataset report does not bring any data that I see on dataentry. For
other reports the fields are numeric.

For the datamart. Pardon my ignorance. How do I run it mannualy?

Orvalho


On Tue, May 14, 2013 at 9:36 AM, Ocaya Stephen <stephocay@xxxxxxxxx> wrote:

> What are the properties of the Fields for the Data Elements used for
> reporting?
>
> Could you try manually generating the datamart and send us the complete
> LOG from where the error start upto where you can see Caused by: ....
>
> That kind of gives a clear picture of what is causing the problem
> Waiting ...
>
>
>
>
> On Tue, May 14, 2013 at 10:33 AM, Orvalho Augusto <orvaquim@xxxxxxxxx>wrote:
>
>> Dears!
>>
>> Thank you for the answers.
>>
>> I have no text on value field according to this
>>
>> dhis2=# select * from datavalue where value is NULL;
>>  dataelementid | periodid | sourceid | categoryoptioncomboid | value |
>> storedby | lastupdated | comment | followup
>>
>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+----------
>> (0 rows)
>>
>> dhis2=# select * from datavalue where trim(value) = '';
>>  dataelementid | periodid | sourceid | categoryoptioncomboid | value |
>> storedby | lastupdated | comment | followup
>>
>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+----------
>> (0 rows)
>>
>> dhis2=# select * from datavalue where trim(value) ~ '[A-Za-z]';
>>  dataelementid | periodid | sourceid | categoryoptioncomboid | value |
>> storedby | lastupdated | comment | followup
>>
>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+----------
>> (0 rows)
>>
>> dhis2=# select * from datavalue where trim(value) !~ '[0-9]';
>>  dataelementid | periodid | sourceid | categoryoptioncomboid | value |
>> storedby | lastupdated | comment | followup
>>
>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+----------
>> (0 rows)
>>
>> Orvalho
>>
>>
>>
>> On Tue, May 14, 2013 at 9:30 AM, <deemoyes@xxxxxxxxx> wrote:
>>
>>> I think the value type for the data elements are not properly set
>>> because if you set the value to be α number and an integer and also specify
>>> to or not to allow zeros plus your validation rules then I don't think you
>>> would these issues.
>>>
>>> The values are probably set to be text or so.
>>> Sent from my BlackBerry(R) smartphone from Etisalat. Enjoy high speed
>>> mobile broadband on our easyblaze and plans for BlackBerry. Visit
>>> www.etisalat.com.ng for details.
>>>
>>> -----Original Message-----
>>> From: Ocaya Stephen <stephocay@xxxxxxxxx>
>>> Sender: "Dhis2-users"
>>>         <dhis2-users-bounces+deemoyes=yahoo.com@xxxxxxxxxxxxxxxxxxx>
>>> Date: Tue, 14 May 2013 10:22:45
>>> To: Orvalho Augusto<orvaquim@xxxxxxxxx>
>>> Cc: dhis1-users<dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers<
>>> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>> Subject: Re: [Dhis2-users] Troubles running datamart
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
>
> *You can do anything, but not everything.*
>
>