dhis2-users team mailing list archive

[Orvalho Augusto <orvaquim@xxxxxxxxx>]

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.*
>
>