dhis2-devs team mailing list archive

[Ocaya Stephen <stephocay@xxxxxxxxx>]

To run DataMart Manually (U need to have the Right i guess),
Analytics and Data Mart

   - Analytics and Data Mart  (In version 2.11 Hopefully 2.10 also)

But idealy it should be under Reports then on the left pane, select *Analytics
and Data Mart*

*There, You can select the periods, and other parameters ...*

*The hit Start Export*
On Tue, May 14, 2013 at 10:44 AM, Orvalho Augusto <orvaquim@xxxxxxxxx>wrote:

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


-- 

*You can do anything, but not everything.*