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 <orvaq...@gmail.com>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 <stepho...@gmail.com>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 <orvaq...@gmail.com>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, <deemo...@yahoo.com> 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 <stepho...@gmail.com> >>>> Sender: "Dhis2-users" >>>> <dhis2-users-bounces+deemoyes=yahoo....@lists.launchpad.net> >>>> Date: Tue, 14 May 2013 10:22:45 >>>> To: Orvalho Augusto<orvaq...@gmail.com> >>>> Cc: dhis1-users<dhis2-us...@lists.launchpad.net>; DHIS 2 developers< >>>> dhis2-devs@lists.launchpad.net> >>>> Subject: Re: [Dhis2-users] Troubles running datamart >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-us...@lists.launchpad.net >>>> 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.*
_______________________________________________ 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
