Re: [Dhis2-users] [Dhis2-devs] No totals visible in the pivot table

2016-11-24 Thread Hinds, Ms. Angela (CAR)
rough the DHIS2 SQL View functionality) you need to be sure they do not reference resource tables, or alternatively, encapsulate the view in a PLPSQL function, so that they are not seen by the database. Regards, Jason On Thu, Nov 24, 2016 at 11:20 AM, Hinds, Ms. Angela (CAR) mailto:hinds...@c

Re: [Dhis2-users] [Dhis2-devs] No totals visible in the pivot table

2016-11-24 Thread Hinds, Ms. Angela (CAR)
ependent objects too. -Original Message- From: Dan Cocos [mailto:dco...@gmail.com] Sent: Wednesday, November 23, 2016 12:18 PM To: Hinds, Ms. Angela (CAR) Cc: DHIS Users ; DHIS 2 Developers list Subject: Re: [Dhis2-devs] No totals visible in the pivot table You have to run Analytics for the Pi

Re: [Dhis2-users] No totals visible in the pivot table

2016-11-23 Thread Hinds, Ms. Angela (CAR)
Hi Folks, I recently imported records using a csv file into DHIS 2. I can see the data in the data entry screen and using the browser option but nothing when I use the pivot table tool. It is aggregate data and I have not set up indicators as yet so I am just running straightforward tables us

Re: [Dhis2-users] SQL view question

2016-08-26 Thread Hinds, Ms. Angela (CAR)
o the dataelement,Source(orgunit),category (i.e. meta data) are stored together with the data in the datavalues table. In case of any question regarding writing sql queries please free to get in touch with me. rgds David 2016-08-25 14:21 GMT+03:00 Hinds, Ms. Angela (CAR) mailto:hinds...@carpha.or

Re: [Dhis2-users] SQL view question

2016-08-25 Thread Hinds, Ms. Angela (CAR)
Hi I have not used the SQL view before and after perusing the documentation, I am still not clear on 1. Which name references are to be used in the SQL statement for the elements and table? My current element names and short names used by the forms have spaces 2. Using the web.ap

[Dhis2-users] Looking for a DHIS 2 Developer

2016-02-24 Thread Hinds, Ms. Angela (CAR)
Dear Colleagues, I am looking for a DHIS 2 Developer available from March and willing to work on the development of some forms and reports from a distance. I would also like to communicate with anyone who is using DHIS 2 for the collection of information for the generation of PEPFAR (United S

Re: [Dhis2-users] Creating a patient dataset

2014-06-04 Thread Hinds, Ms. Angela (CAR)
various lab tests and results. Will try it now. Many thanks. Regards, Angela From: Deemoyes [mailto:deemo...@yahoo.com] Sent: Tuesday, June 03, 2014 1:17 PM To: Hinds, Ms. Angela (CAR); DHIS 2 Users list Subject: Re: [Dhis2-users] Creating a patient dataset Dear Ms. Angela, Patient Data

Re: [Dhis2-users] Creating a patient dataset

2014-06-03 Thread Hinds, Ms. Angela (CAR)
Hi, I would like to create a patient dataset of lab results. I have created the elements using 'Domain type' as 'Patient' as opposed to 'Aggregate' However when I try to add the elements to a dataset they are not visible. If I change them to 'Domain type' : Aggregate, they are visible. I need

Re: [Dhis2-users] Documentation for release 2.13

2014-04-27 Thread Hinds, Ms. Angela (CAR)
Hi Jason No problem, I understood. Thank you very much, Angela From: Jason Pickering Sent: 26 April 2014 10:52 To: Hinds, Ms. Angela (CAR) Cc: Muhire Andrew; Lars Helge Ă˜verland; DHIS 2 Developers list; DHIS 2 Users list Subject: Re: [Dhis2-users

[Dhis2-users] Documentation for release 2.13

2014-04-26 Thread Hinds, Ms. Angela (CAR)
I would like to do an import from CSV file. Can you please point me to the 2.13 documentation on this as I am only finding 2.15 release documentation Thank you Angela Hinds CARPHA (formerly CAREC) ___ Mailing list: https://launchpad.net/~dhis2-users P

[Dhis2-users] Dataset report error

2013-06-18 Thread Hinds, Ms. Angela (CAR)
Hello All Our system was recently upgraded to DHIS 2.12. All seems well except that when we try to run a dataset report. If the chosen period has no data, the report is displayed (with blanks as it should). If the period has data the following message is displayed:- Sorry The system failed