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

[Hinds, Ms. Angela (CAR)]

Thanks Jason,
I had some problems with doing the views via DHIS 2 so eventually did it 
externally.  I will re-visit it though. Much appreciate your assistance.
Regards,
Angela

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Thursday, November 24, 2016 6:25 AM
To: Hinds, Ms. Angela (CAR) <hinds...@carpha.org>
Cc: DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list 
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] [Dhis2-devs] No totals visible in the pivot table

Hi Angela,
You should created SQL views via the DHIS2 application. Go to Data 
Administration -> SQL Views and create your view there.See 
here<https://ci.dhis2.org/docs/master/en/user/html/dataAdmin_sqlView.html#d0e19320>
 for details. When the analytics process runs, it needs to drop certain 
resource tables. If these tables are linked to a view in the database, then the 
process fails.

If you must have views directly on the database (and not created through 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) 
<hinds...@carpha.org<mailto:hinds...@carpha.org>> wrote:
Thanks everyone for the response. When I run the analytics it gives me the 
following below, which is related to a view I created in PgAdmin. Is the only 
option to move the view, run the analytics then add the view again?

Regards,
Angela

Error
Process failed: StatementCallback; uncategorized SQLException for SQL [drop 
table _dateperiodstructure;]; SQL state [2BP01]; error code [0]; ERROR: cannot 
drop table _dateperiodstructure because other objects depend on it Detail: view 
"DHIS2MasterViewXtra" depends on table _dateperiodstructure
Hint: Use DROP ... CASCADE to drop the dependent objects too.; nested exception 
is org.postgresql.util.PSQLException: ERROR: cannot drop table 
_dateperiodstructure because other objects depend on it Detail: view 
"DHIS2MasterViewXtra" depends on table _dateperiodstructure Hint: Use DROP ... 
CASCADE to drop the dependent objects too.


-Original Message-
From: Dan Cocos [mailto:dco...@gmail.com<mailto:dco...@gmail.com>]
Sent: Wednesday, November 23, 2016 12:18 PM
To: Hinds, Ms. Angela (CAR) <hinds...@carpha.org<mailto:hinds...@carpha.org>>
Cc: DHIS Users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>; DHIS 
2 Developers list 
<dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] No totals visible in the pivot table

You have to run Analytics for the Pivot Tables to update Apps —> Reports —> 
Analytics


Dan Cocos
Principal, BAO Systems
dco...@baosystems.com<mailto:dco...@baosystems.com> | http://www.baosystems.com 
|  2900 K Street, Suite 404, Washington D.C. 20007

> On Nov 23, 2016, at 11:15 AM, Hinds, Ms. Angela (CAR) 
> <hinds...@carpha.org<mailto:hinds...@carpha.org>> wrote:
>
> 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 using the details option.
>
> Any ideas as to the reason for this?
>
> Regards,
>
> Angela
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : 
> dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jason P. Pickering
email: jason.p.picker...@gmail.com<mailto:jason.p.picker...@gmail.com>
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 using the details option.

Any ideas as to the reason for this?

Regards,

Angela


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] SQL view question

[Hinds, Ms. Angela (CAR)]

Thank you very much everyone, for your guidance.  I don't have a copy of the 
database locally.  That actually is a good idea and I will do that.  If I have 
any problems, I'll email.

Regards,

Angela

Get Outlook for iOS<https://aka.ms/o0ukef>




On Thu, Aug 25, 2016 at 8:13 AM -0400, "David Muturi" 
<dnmut...@gmail.com<mailto:dnmut...@gmail.com>> wrote:

Hi Angela,
Its usually easier to write the queries using a copy of the database stored 
locally and using the database access tools described above, test them before 
copying them over to the SQL VIEW for front end access using dhis2, one is able 
to easily troubleshoot any errors in the scripts and fix than when using sql 
view directly.
rgds
David

2016-08-25 14:53 GMT+03:00 David Muturi 
<dnmut...@gmail.com<mailto:dnmut...@gmail.com>>:
Hi Angela,
You will need to access the database, ideally having a local copy on your 
laptop and using GUI tools i.e. Pgadmin, Navicat for PostgresSQl or other tools 
will allow you to access the backend. From there the names for the tables can 
serve as a guide e.g. datalement for dataelements, dataset for datasets, e.t.c 
For data, DHIS2 uses the "long and skinny" or EAV model so 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) 
<hinds...@carpha.org<mailto:hinds...@carpha.org>>:
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.api how do I get a list of the relevant reference names 
to use for the particular dataset

Regards,

Thank you.



___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] SQL view question

[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.api how do I get a list of the relevant reference names 
to use for the particular dataset

Regards,

Thank you.


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Looking for a DHIS 2 Developer

[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 States President's Emergency 
Plan for AIDS Relief) HIV indicators.


Regards,



Angela Hinds

Senior Technical Officer

Health Information, Communicable Diseases and Emergency Response

Surveillance, Disease Prevention & Control



Caribbean Public Health Agency (CARPHA)

16-18 Jamaica Boulevard

Federation Park, Port of Spain

Trinidad and Tobago



Tel (868) 622 4261 Ext 40223

Fax (868) 622 2792

email:hinds...@carpha.org

www.carpha.org



___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Creating a patient dataset

[Hinds, Ms. Angela (CAR)]

Dear Adedayo,

Thank you very much for the information. I have only used aggregate type thus 
far and did not realize the wider use of the Tracker/Person Program.
We are monitoring the introduction of Chikungunya into the region by keeping a 
database of the patients, their medical history and 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 Elements may be divided into two categories from my experience. 
There are the patient data elements which appear on the Tracker/Person Programs 
and Program Stages that you create. These data elements may be elements of a 
program stage. For example, for a Child at birth on ANC program, you may want 
Was NVP given at birth, OPV, Measles and the likes as Data Elements for the 
Program/Program Stages involved to be a patient data element. This is why they 
will not show under data sets when you select patient as Domain Type.

The second category of the Data Elements for use with the Tracker are the 
Aggregate Domain Type Data Elements. This can be created as aggregate domain 
type data element but as‎signed to a Data Set which you can now link to your 
Aggregate Query Builder under you Tracker/Individual Records Module in the 
DHIS2 to run an aggregate query while selecting the Dataset that you want to 
run this query with and then selecting the type of Tracker Element e.g Number 
of Visits under the radio buttons and the Tracker Data Element such as the 
Number of OPV given etc.

Please may I also ask what you want to achieve exactly.

And I hope this helps.

Regards,

Adedayo
Sent from my BlackBerry 10 smartphone.
From: Hinds, Ms. Angela (CAR)
Sent: Tuesday, 3 June 2014 16:05
To: DHIS 2 Users list
Subject: Re: [Dhis2-users] Creating a patient dataset


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 some guidance as to how to proceed.

Thank you,

Angela Hinds
CARPHA (formerly CAREC)


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Creating a patient dataset

[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 some guidance as to how to proceed.

Thank you,

Angela Hinds
CARPHA (formerly CAREC)
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Documentation for release 2.13

[Hinds, Ms. Angela (CAR)]

Hi Jason

No problem, I understood.  Thank you very much,

Angela

From: Jason Pickering jason.p.picker...@gmail.com
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] Documentation for release 2.13

Apologies for the typos!

However, in this case, there has been
little change since 2.13, so the current documentation is still valid
for 2.13 in this case.



On 4/26/14, Jason Pickering jason.p.picker...@gmail.com wrote:
 Hi Angela,
 We currently do not keep previous versions of the documentation, but
 they can be regenerated from the documentation source code. We should
 certainly do a better job of clearly marking the versions and what is
 appropriate to each release. However, in this case, there has been
 little chance since 2.13, so the current documentation is still valid
 for 2.13.

 http://www.dhis2.org/doc/snapshot/en/user/html/ch21s02.html#importCSVdata

 Regards,
 Jason



 On Sat, Apr 26, 2014 at 7:43 PM, Hinds, Ms. Angela (CAR)
 hinds...@carpha.org wrote:

 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
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp




--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+260974901293

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Dataset report error

[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 to execute the operation. Usually, no data is lost and 
you can continue working by going back to the previous page

Any ideas?

Angela

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp