Re: [Dhis2-users] Web portal not working - domain http://dhis2-cdn.org/ down

2018-10-01 Thread Wilson, Randy
d Floor, George Padmore Road, Kilimani| P.O. Box 21936 >> - 00505| Nairobi | Kenya >> >> T: +254 020 3995000 | M: +254 727 389 149| sok...@dndi.org | skype: >> dndi_seth.okeyo >> >> *Best Science for the Most Neglected* | www.dndi.org >> >>

[Dhis2-users] Web portal not working - domain http://dhis2-cdn.org/ down

2018-09-29 Thread Wilson, Randy
I'm trying to embed a pivot table in a web page without success. It appears that http://dhis2-cdn.org/ is offline. Is the feature of embedding objects in web pages no longer supported? I'm using dhis2 v 2.29. Thanks, -- *Randy Wilson* *Team Leader: **Knowledge Management, Data Use and Research

Re: [Dhis2-users] DHIS-2 demo portal not working

2018-09-20 Thread Wilson, Randy
| Data Management Officer >> >> Drugs for Neglected Diseases initiative – Africa Regional Office >> >> Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani| P.O. Box 21936 >> - 00505| Nairobi | Kenya >> >> T: +254 020 3995000 | M: +254 727 389 149| sok

[Dhis2-users] DHIS-2 demo portal not working

2018-09-20 Thread Wilson, Randy
Hi all, It seems the demo portal on DHIS2.org is not working - no data appears. Has this been abandoned? If not you should probably check the API settings and probably update the graphic with the new 2.30 graphic objects. -- *Randy Wilson* *Team Leader: **Knowledge Management, Data Use and Rese

[Dhis2-users] Issue with visualiser, map, pivot table rights on cloned objects

2017-09-05 Thread Wilson, Randy
Hi all, I have written an R script to clone a dashboard and all the objects on it for each district in the country. This runs fine - adding records in all of the tables that are related to the objects - and when I open the objects with my username, the cloned objects work fine. However when I lo

Re: [Dhis2-users] Saving favorites with User Orgunit

2017-08-15 Thread Wilson, Randy
known workaround as far as I know at this point. > > Regards, > Jason > > > On Mon, Aug 14, 2017 at 2:57 PM, Wilson, Randy wrote: > >> We've been trying to configure some standard dashboards for users in each >> of the 30 districts but have come to realize that

[Dhis2-users] Saving favorites with User Orgunit

2017-08-14 Thread Wilson, Randy
We've been trying to configure some standard dashboards for users in each of the 30 districts but have come to realize that the user orgunit that can be saved for the favorite refers to the orgunits that data entry staff are assigned for visualization, not the orgunits they are assigned for data en

[Dhis2-users] Upgrade to version 2.24 not altering tables correctly

2017-01-31 Thread Wilson, Randy
We've just upgraded from 2.23 to 2.24 and the upgrade notes state that : - Version 2.24 sets all "uid", "created" and "lastupdated" columns for metadata tables as not nullable. As a result it is recommended to first run version 2.23 on your database before running version 2.24 to allow n

[Dhis2-users] AttributeOptioncombo field in datavalue table

2017-01-03 Thread Wilson, Randy
Is there any documentation available on how to populate the attributeoptioncomboid in the data values table through the data entry screens? We would like to use it to store source of funding as the categoryoptioncombo is already being used for another purpose. We're using version 2.24. -- *Rand

[Dhis2-users] Can you filter a JasperReport on a custom parameter through the API

2016-11-25 Thread Wilson, Randy
I have created a JasperReport that pulls data from several tables to print a lab request id (userinfo - for contact information, phone number of data manager, tracked entity info, as well lab request info from a program stage). I'd like to be able to print the data for a single lab request using a

Re: [Dhis2-users] Fwd: changing organisation unit coordinates in DHIS-2.23

2016-09-21 Thread Wilson, Randy
> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Thu, Sep 22, 2016 at 4:04 AM, Bob Jolliffe >> wrote: >> >>> >>> -- Forwarded message -- >>> From: Wilson, Randy

[Dhis2-users] changing organisation unit coordinates in DHIS-2.23

2016-09-16 Thread Wilson, Randy
It seems that the option to move health facilities in the GIS module has been removed - probably a good thing, since people inadvertantly move them around inaccurately. However, it seems that the GPS coordinates no longer appear in the Organisation Unit maintenance app. Is there any way to make s

[Dhis2-users] Help configuring Postgres 9.5 and Java Opts for DHIS-2 2.23

2016-06-16 Thread Wilson, Randy
Hi all, I have an Intel Core i7 Windows 10 64bit computer with 16 Gig of RAM and can't seem to configure it to run analytics correctly. I ran analytics just fine on the same computer with the same DHIS-2 instance using 2.21 and postgres 9.4 - it took just over 1 hour to run. Now it seems to hang

[Dhis2-users] Updating Chart and Pivot table favorites after upgrade from 2.19 to 2.21

2016-05-05 Thread Wilson, Randy
We've created a lot of chart and pivot table objects in our disease surveillance and data warehouse instances of DHIS-2 that we have arranged on dashboards. It seems that after the upgrade of the system, something has changed in the favorites tables and they no longer display in the dashboards (th

Re: [Dhis2-users] Exporting data through SQL View

2016-04-04 Thread Wilson, Randy
m using SSH to connect to the remote server and > would like to ask you where should be located the postgres config file for > me to make some change on the size of the query limitation? > > Best Regards. > > On Mon, Apr 4, 2016 at 3:32 PM, Wilson, Randy wrote: > >> Hi Tan

Re: [Dhis2-users] Exporting data through SQL View

2016-04-04 Thread Wilson, Randy
sample > script and customizing with the dataset name, I am facing another issue > with a timed out connection due to a busy server. I cannot output any > result yet. Do you know if it is a server memory issue? > > Best Regards. > > Tantely. > > On Sat, Apr 2, 2016 at 8:39 AM, Wilson

Re: [Dhis2-users] Exporting data through SQL View

2016-04-01 Thread Wilson, Randy
Hi Tantely, Here is a sample query that will give you what I think you want: select dv.sourceid as organisationunitid, ou.name, ou.code as facilitycode, de.name, 'Vaccination' as datasetname, pe.startdate, pe.enddate, coc.categoryoptioncomboname, dv.value from datavalue dv inner join org

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-02-02 Thread Wilson, Randy
kettle and be pain > resistant to a certain degree :-) > > I'd be interested to hear from other experiences ... > > Have a nice sunday, > > Uwe > > --- > > Am 29.01.2016 um 17:31 schrieb Wilson, Randy: > > Not here unfortunately...just doin

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-01-29 Thread Wilson, Randy
Not here unfortunately...just doing csv imports from DHS Excel files. Would be useful for our data warehouse. Randy On Jan 29, 2016 2:59 PM, "Olav Poppe" wrote: > Hi all, > I wanted to hear if anyone has any experience with the DHS API ( > http://api.dhsprogram.com/#/index.html), and using it to

Re: [Dhis2-users] Serious problem with duplicate records in Individual records/tracker

2015-10-15 Thread Wilson, Randy
ffe > wrote: > >> If you experience reasonably high latency (slow response times) it seems >> quite likely you might well get duplicates. Probably related to >> >> https://bugs.launchpad.net/dhis2/+bug/1498505 >> >> On 9 October 2015 at 15:40, Wilson, Randy wr

Re: [Dhis2-users] Easy way to import indicators into new database

2015-10-12 Thread Wilson, Randy
Hi Arthur, If you haven't done this already, attached is an excel template that you can use to transform your indicator list into fields that can be imported into the DHIS-2 indicator table. I've left a couple of sample rows for you to see what the content should be like. Note that after you ha

Re: [Dhis2-users] Serious problem with duplicate records in Individual records/tracker

2015-10-09 Thread Wilson, Randy
Regards > Ant > > On 9 October 2015 at 10:22, Wilson, Randy wrote: > >> Hi all, >> >> We have an big issue with several of Rwanda's event reporting systems >> that have been set up using Tracker/Individual records. For some reason, >> users are able to

[Dhis2-users] Serious problem with duplicate records in Individual records/tracker

2015-10-09 Thread Wilson, Randy
Hi all, We have an big issue with several of Rwanda's event reporting systems that have been set up using Tracker/Individual records. For some reason, users are able to create duplicate records in the system through normal data entry. It seems to happen when they enter a value for an attribute a

[Dhis2-users] How to pull data from a remote xml data source (dhis2 web API) into JasperReports

2015-08-31 Thread Wilson, Randy
I've been struggling to get data from the web API into JasperStudio to create standard iReports. I've created a new datasource of type: XML document (remote) I can pull data from sites that don't need authentication into the iReport, such as this rss feed from bbc: http://feeds.bbci.co.uk/news/rs

[Dhis2-users] Can we select a date range through the Web API

2015-08-25 Thread Wilson, Randy
Hi All, We're trying to synch facility data between DHIS-2 and a new Provider Registry linked to iHRIS using the API. I've created a SQL view that works nicely to pull all of the data and I am able to filter for exact matches (e.g.). (I can't seem to get the FRED API to work in version 2.20). h

[Dhis2-users] Issue with tracker data aggregation in event visualizer and event reports

2015-06-05 Thread Wilson, Randy
We have been using the tracker module (multiple events with registration) to store imported quarterly data reported by Community Health Workers through rapidSMS. These CHWs are registered - and linked to the Health Centers that supervise them - then each quarter new datavalues are added counting t

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Wilson, Randy
gt; >>>>>>> I just had a quick look at the tracker app on one of the Rwanda >>>>>>> dhis2 instances (it is running 2.17 built on 2015-01-21 02:05 - >>>>>>> strange I don't see the build revision) >>>>>>> >>>&

Re: [Dhis2-users] Problem with tracker module

2015-03-17 Thread Wilson, Randy
yot. > > (sent from mobile) > On Mar 17, 2015 3:15 PM, "Wilson, Randy" wrote: > >> We're setting up a tracker module to capture data from individual >> community health workers using Multiple events with registration. >> >> We have the program an

Re: [Dhis2-users] Problem with tracker module

2015-03-17 Thread Wilson, Randy
you using the individual records module? > > Can you try tracker capture app? > > - > Thank you, > Abyot. > > (sent from mobile) > On Mar 17, 2015 3:15 PM, "Wilson, Randy" wrote: > >> We're setting up a tracker module to capture data from

Re: [Dhis2-users] Problem with tracker module

2015-03-17 Thread Wilson, Randy
No. Just the standard section form. We're trying in version 2.17 because this has always worked before. Randy On Tue, Mar 17, 2015 at 4:19 PM, Adebusoye Anifalaje wrote: > Hi Randy, > > Are you using a custom form by any chance? > > Busoye > > On 17 Mar 2015, at 1

[Dhis2-users] Problem with tracker module

2015-03-17 Thread Wilson, Randy
We're setting up a tracker module to capture data from individual community health workers using Multiple events with registration. We have the program and stage as well as attributes and data elements - using 3 different instances of DHIS-2. When we try to create a new instance we fill in the fo

[Dhis2-users] DHIS-2 2.15 bug on reporting rate dataset selector in pivot table and visualiser

2014-08-07 Thread Wilson, Randy
Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I've cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used t

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-05 Thread Wilson, Randy
ate2ISOweek(week.starts),0,8)) >>> >>> sql<-paste0("INSERT INTO periods >>> (periodid,periodtypeid,startdate,enddate) >>> VALUES(nextval('hibernate_sequence'::regclass),2,","'",as.Date(week.starts),"','",as.

[Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-04 Thread Wilson, Randy
Hi all, I thought I saw a posting on inserting periods into the DHIS-2 for earlier periods in time, but can't seem to find it any longer. I need ISO weekly periods going back to 2011. I also notice that there are some instances where there are 53 ISO weeks in a year, but that does not appear to b

[Dhis2-users] Issues importing large CSV file into DHIS-2 2.16

2014-08-04 Thread Wilson, Randy
Hi all, I have a csv file that has 608,000 records that I'm trying to import into DHIS-2. When I select the options and begin the upload the system seems to go into a loop, importing 10 or 11% and then starting again at zero. Does anyone know the number of records that the import CSV tool will a

[Dhis2-users] Problems running analytics on individual records version 2.15

2014-07-05 Thread Wilson, Randy
I have upgraded my 2.14 database using a (slightly edited script) and upgraded to 2.15 build revision 15163. I can now see all of my patient tracker data - using single event without registration. However when I run analytics in order to create event reports, it fails: 2014-07-05 08:16:24Process

Re: [Dhis2-users] What's the good browser for DHIS2?

2014-05-22 Thread Wilson,Randy
We are using Chrome mostly and have noticed that if you are using an earlier version some things don't display. For example in the GIS module users of the earlier version did not see the menu option: "Legend". As soon as we upgraded it reappeared... might be a problem of cache. Randy From: D

Re: [Dhis2-users] Creation of bulk user.

2014-05-08 Thread Wilson,Randy
Hi Hannan, I think you should try Kenneth’s java application. We created 40,000 users (community health workers with their phone numbers and orgunit link) and assigned them all passwords using the app. I think Kenneth has put in a User interface that lets you specify the server address, DHIS-

[Dhis2-users] Analytics tables - only data elements - where are indicators?

2014-04-10 Thread Wilson,Randy
I'm trying to pull some data from the analytics tables rather than using the datamart tables. Unlike aggregatedindicatorvalue table from the datamart it seems like the indicators are not pre-calculated in the analytics tables. Is that right? If that is the case are the indicators calculated o

Re: [Dhis2-users] Inactive Organisation Unit

2014-04-04 Thread Wilson,Randy
Hi Marcos, There are a couple of options, but I'm not sure how they interact with different DHIS-2 functions. 1. You can set the closed date = I think that is used when a facility closes but you want to keep all of the historical records. In theory, if a facility is closed you should n

Re: [Dhis2-users] Indicator

2014-03-31 Thread Wilson,Randy
Actually we need to create an indicator that sums the data over the last 3 months and divides by 3 - e.g. average monthly consumption for the past 3 months. Similarly we will need a function to average the number of cases of epidemic prone disease over the past 6 months and then check to see of

Re: [Dhis2-users] Can't add organisation unit levels in 2.14 build 13820

2014-03-19 Thread Wilson,Randy
Thanks Ola, That makes sense. I added a facility at each level and was able to see the levels. Randy From: olati...@gmail.com [mailto:olati...@gmail.com] On Behalf Of Ola Hodne Titlestad Sent: Tuesday, March 18, 2014 9:41 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re

[Dhis2-users] Can't add organisation unit levels in 2.14 build 13820

2014-03-18 Thread Wilson,Randy
I think other have seen this issue. I'm setting up a new database and the option to Add New is missing from the Organisation Unit levels screen. I downloaded the latest stable build tonight. [cid:image001.png@01CF42F0.2776E000] Any suggestions? Randy Wilson <>__

Re: [Dhis2-users] Issue importing CSV with categoryoptioncombos

2014-02-19 Thread Wilson,Randy
oncomboname. I'll try the new detailed metadata export features. Maybe that will help. Randy From: Bob Jolliffe [mailto:bobjolli...@gmail.com] Sent: Tuesday, February 18, 2014 8:58 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Issue importing CSV with cate

[Dhis2-users] Issue importing CSV with categoryoptioncombos

2014-02-18 Thread Wilson,Randy
I'm moving data between instances of DHIS-2 (from the HMIS to the Data Warehouse with a subset of data elements). Since the dataelementids and orgunitides are not always the same in the two systems, I'm using the code fields for those. I've set up a query to provide the data I need with one ex

[Dhis2-users] Issue importing CSV with categoryoptioncombos

2014-02-18 Thread Wilson,Randy
I'm moving data between instances of DHIS-2 (from the HMIS to the Data Warehouse with a subset of data elements). Since the dataelementids and orgunitides are not always the same in the two systems, I'm using the code fields for those. I've set up a query to provide the data I need with one ex

[Dhis2-users] Problem with strange characters appearing in tracker module text fields

2014-01-31 Thread Wilson,Randy
Hi all, Some of the data entry clerks have been entering strange data in some of the text fields of the tracker module in our Death Audit forms. I think it is due to the character sets on their keyboards. As a result we have fields like: bebe%20murorunkwere%20donatha%20gakuru This causes the

Re: [Dhis2-users] Problems importing csv datavalues into 2.14

2014-01-24 Thread Wilson,Randy
Helge Øverland [mailto:larshe...@gmail.com] Sent: Friday, January 24, 2014 2:44 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Problems importing csv datavalues into 2.14 Hi Randy, can you please post the relevant part of the tomcat log. Internal data

[Dhis2-users] Problems importing csv datavalues into 2.14

2014-01-24 Thread Wilson,Randy
Hi all, I'm trying to import a csv file in the following format: "dataelement","period","orgunit","categoryoptioncombo","value" "TN10","201311","1","Default","5" "TN10","201312","1","Default","0" "TN10","201311","2","Default","3" "TN10","201312","2","Default","5" Etc... I after uploading th

Re: [Dhis2-users] pivottable download issue - loses orgunit hierarchy

2014-01-07 Thread Wilson,Randy
Thanks Lars. This is a great new feature in the web pivot table module for 2.13! Randy From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: Tuesday, January 07, 2014 2:02 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] pivottable download issue

[Dhis2-users] pivottable download issue - loses orgunit hierarchy

2014-01-07 Thread Wilson,Randy
Apologies if this has been reported before, but I can't seem to download the orgunit hierarchy displayed in the pivot tables when I download to Excel. See the attached that displays the pivot table view, and just below the format of the Excel download file. Is there some way to send each level

[Dhis2-users] Anyone used DHIS-2 mobile to initiate mobile money payments?

2013-12-18 Thread Wilson,Randy
In Rwanda we are exploring the possibility of paying community health workers incentive payments (PBF) via Mobile Money for effectively tracking pregnant women using the RapidSMS system. For example those who reported an average of 7 or more pregnancy-related messages per pregnant woman reporte

Re: [Dhis2-users] Problem with export of Event data

2013-11-21 Thread Wilson,Randy
...@gmail.com] Sent: Thursday, November 21, 2013 10:25 AM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Problem with export of Event data Hi Randy, I haven't seen that issue before. I will have a look at it, I think it might be related to patientdatavalue using

[Dhis2-users] Problem with export of Event data

2013-11-20 Thread Wilson,Randy
We have several forms for neonatal, child and maternal death audits that are using the Single Event without registration module. When I try to Export the data from the Import-Export menu I get an error regardless of which data set. It appears to be a problem with the date parameter in the SQL q

Re: [Dhis2-users] Custom Form Dataset

2013-11-14 Thread Wilson,Randy
49 AM To: Wilson,Randy Cc: DHIS 2 developers; dhis1-users Subject: Re: [Dhis2-users] Custom Form Dataset Hi @Randy, The problem is not the javascript code since it works well. The problem is that in place to record in the database since all people are dataelements although others derive t

Re: [Dhis2-users] Custom Form Dataset

2013-11-13 Thread Wilson,Randy
Hi Riddy, You can probably achieve the same result by creating indicators and including them in your custom form. We do the same thing in Rwanda, but apply standard percentage constants for children under 1 year (3.83%), women of reproductive age (26.3%), etc... If your Javascript function has

Re: [Dhis2-users] [Dhis2-devs] ireport deprecated

2013-11-07 Thread Wilson,Randy
is the same. Jasper studio is just another design tool for the format. Also, there is nothing stopping you from using iReport even though they will not put more features into it. Lars On Wed, Nov 6, 2013 at 7:42 AM, Wilson,Randy mailto:rwil...@msh.org>> wrote: Hi Lars, Does Jaspersoft St

Re: [Dhis2-users] ireport deprecated

2013-11-05 Thread Wilson,Randy
Hi Lars, Does Jaspersoft Studio produce the .jrxml files that can be incorporated into DHIS-2 or do you have to do some work on your end before we can use it? I'm organizing an advanced training in iReport for Rwanda data managers and need to know if I can switch to Studio before the training.

[Dhis2-users] How to restrict iReport orgunit parameter selection to district level (level 3)

2013-11-01 Thread Wilson,Randy
We have developed some rather complex SQL queries that feed into iReports to display the top 10 causes of OPD visits, hospitalization and deaths by district by quarter. I have successfully integrated the parameters for period and for organization_name, but the data are only grouped by district,

Re: [Dhis2-users] using a CSV file for visualization

2013-10-10 Thread Wilson,Randy
Hi Alison, In Rwanda we're doing quite a bit by importing external data into a DHIS-2 instance that we call the "Data warehouse". Often this comes in as CSV files that we import into a temporary table we've created in the DHIS and then we create a SQL script to import it into the datavalues ta

Re: [Dhis2-users] How to change data elemenent category combos after creating data set

2013-10-07 Thread Wilson,Randy
Thanks Lars. I will try this. I didn't see the update category option before. Randy From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: Monday, October 07, 2013 2:02 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] How to change data elem

[Dhis2-users] How to change data elemenent category combos after creating data set

2013-10-07 Thread Wilson,Randy
I'm not sure if others have had this issue, but I've created a data element category combo to track funding by donor. Unfortunately I left one of the donors out of the list. Now when I try to add it in by updating the data element categories it doesn't appear. I've cleared cache, regenerated

[Dhis2-users] running iReports on Android tablet

2013-09-18 Thread Wilson,Randy
We're starting to use Android tablets for data collection in Rwanda (through DHIS-2) and Limesurvey (another open source survey questionnaire tool). However with DHIS-2 I can't seem to preview any of the standard reports developed with iReports. The system sends the report as a PDF download in

[Dhis2-users] Standard iReports cache problem

2013-09-13 Thread Wilson,Randy
We're using a lot of new iReports in the Standard reports and they seem to be working well, but there seems to be a serious caching problem. I have a report listing health facilities that I ran this morning, now I've added 10 more facilities and they don't appear in the list Though they do

Re: [Dhis2-users] How to insert the populations health facility

2013-09-13 Thread Wilson,Randy
nth only, but an average is ok if you are looking at a period longer than a month." From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: Friday, September 13, 2013 12:02 PM To: riddy ndoma Cc: Wilson,Randy; dhis1-users Subject: Re: [Dhis2-users] How to insert the populations health

Re: [Dhis2-users] How to insert the populations health facility

2013-09-10 Thread Wilson,Randy
Hi Riddy, There are a couple of steps to this process depending upon the data you have available and the approach that you use for calculating the different denominators. 1. Decide whether you will only store total catchment population for each facility and then use national level perce

Re: [Dhis2-users] SQL View Permissions

2013-09-06 Thread Wilson,Randy
I believe those table are blocked to prevent non-system administrators from viewing user data. If you have Pgadmin access or have installed PHPpgadmin on the server, you can run the queries there. SQL views in DHIS-2 are also problematic especially if you refer to any of the resource tables be

[Dhis2-users] Problem running JDBC data source iReport

2013-08-30 Thread Wilson,Randy
We've had to make a special query to retrieve text fields from a dataset developed in the aggregate data module. It runs fine in iReport, but when I try to run it as a standard report within DHIS-2 it get the following error. Does anyone have experience with this. Do I need to change my settin

Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module

2013-08-29 Thread Wilson,Randy
idea. Thanks, Randy From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: Thursday, August 29, 2013 12:01 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module Hi Randy, On Thu, A

[Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module

2013-08-29 Thread Wilson,Randy
I think I may have seen something related to this before but can't seem to get it to work. When I want to select all of the districts from the orgunit hierarchy for a pivot table, I can select any that are visible, but the remaining districts in Western province are not visible (off the screen)

Re: [Dhis2-users] Deleting old data elements

2013-08-28 Thread Wilson,Randy
Busoye is right. You need to make sure that the data elements are deleted from all the tables where they may appear (below is a list of most of them): Dataelementaggregationlevels Dataelementaggributevalues dataelementgroupmembers dataelementoperand datasetmembers datavalue datavalue_audit datav

Re: [Dhis2-users] Where are custom dataelement/indicator attributes stored

2013-08-27 Thread Wilson,Randy
Hansen Cc: Wilson,Randy; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Where are custom dataelement/indicator attributes stored Hi Randy, its interesting to hear that you are using DHIS 2 for data dictionary purposes. The tables related to data element attributes are: attribute (you

[Dhis2-users] Where are custom dataelement/indicator attributes stored

2013-08-26 Thread Wilson,Randy
We're trying to extend our dataelement and indicator attributes with some custom attributes so that we can store our entire metadata dictionary for Rwanda. I have created the new fields and they display correctly, but I can't find the table where the attributes and their values are stored. We

Re: [Dhis2-users] [Dhis2-devs] DHIS 2 GUI in French

2013-08-21 Thread Wilson,Randy
Hi John, You also may need to clear your cache Or try to use a Chrome Incognito window. Randy From: Dhis2-users [mailto:dhis2-users-bounces+rwilson=msh@lists.launchpad.net] On Behalf Of Dan Cocos Sent: Wednesday, August 21, 2013 5:53 PM To: John Ojo Cc: dhis1-users; DHIS developers Su

[Dhis2-users] Problem with data aggregation levels for population data

2013-08-08 Thread Wilson,Randy
We're having trouble with population data aggregation in DHIS-2 version 2.12. Our organizational unit hierarchy is the following: National - no pop data entered Provincial - no pop data entered District - pop data exists (selected as an aggregation level) Sub-district - no pop data entered Secto

Re: [Dhis2-users] Problems with Individual Records / Single Events / Events Anonymous after migrating from version 2.11 to 2.12.

2013-08-05 Thread Wilson,Randy
Hi Jose, I had the same problem as your image of problem 2. When adding a new entry, the fields did not appear. The happened any time I changed the individual records data set by adding or subtracting data elements. I was able to resolve it by restarting the DHIS-2 instance. In the log we s

[Dhis2-users] Has anyone developed a TB-MDR patient tracker module for DHIS-2

2013-07-31 Thread Wilson,Randy
Hi all, We’ve been asked to advise on software that the national level TB program can use to track TB multi-drug resistant patients. They are not collecting a lot of data, but want nominative lists to better follow outcomes. Has anyone done something of this sort using DHIS-2 patient tracker m

Re: [Dhis2-users] Any suggestions for partner reporting in DHIS-2?

2013-07-30 Thread Wilson,Randy
datavalue.periodtypeid= 4 and aggregateddatavalue.dataelementid in (SELECT dataelementid FROM public._dataelementgroupsetstructure where thematic_area='MARPS'); ALTER TABLE _view_healthfacilityhierarchy OWNER TO dhis; Do you have any other suggestions? Randy From: Lars Helge Øverland [mailto:la

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-28 Thread Wilson,Randy
Hi all, Here is the standard hibernate file that works for me on a Windows localhost instance of DHIS-2. You should only have to change the varibles in bold. hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect hibernate.connection.driver_class = org.postgresql.Driver hibernate.connection

Re: [Dhis2-users] What causes data entry fields to go missing in the form?

2013-07-26 Thread Wilson,Randy
Hi Knut, I had a similar problem… when I changed form types from custom to section. In the end I had to create a new dataset and it worked ok. Randy From: Dhis2-users [mailto:dhis2-users-bounces+rwilson=msh@lists.launchpad.net] On Behalf Of Knut Staring Sent: Friday, July 26, 2013 1:35 P

Re: [Dhis2-users] DHIS-2 version 2.12 - bug with saving indicators without denominators

2013-07-12 Thread Wilson,Randy
[mailto:morte...@gmail.com] Sent: Friday, July 12, 2013 4:53 AM To: Adebusoye Anifalaje Cc: Wilson,Randy; dhis2-users@lists.launchpad.net; DHIS 2 developers (dhis2-d...@lists.launchpad.net) Subject: Re: [Dhis2-users] DHIS-2 version 2.12 - bug with saving indicators without denominators Hi Randy Just

[Dhis2-users] DHIS-2 version 2.12 - bug with saving indicators without denominators

2013-07-11 Thread Wilson,Randy
We've just upgraded all of our instances to 2.12 and it seems that none of the indicators of type number (i.e. with a denominator of one) are not calculating correctly. When I try to edit the numerators, I see that the expressions are well formed and can save the denominator, but when I try to

Re: [Dhis2-users] Define week start day for Weekly periods

2013-06-29 Thread Wilson,Randy
Hi Johannes, I'm not sure how DHIS-2 automatically creates the entries in the period table, but once they are created would one of the following options work? · Pre-fill the period tables with weekly records for several years forward, then hack the period table to reset the start/end d

Re: [Dhis2-users] DHIS version 2.12 is released

2013-05-31 Thread Wilson,Randy
Just checked out the new data visualizer... great to be able to select category option combinations now! It seems that none of my favorites from version 2.11 work. Error message when I load them is: "No filter dimensions specified". We have created many charts for various dashboards. Is there

Re: [Dhis2-users] Cumulative numbers in DHIS2

2013-05-16 Thread Wilson,Randy
Hi Jim, This is very similar to the data element that many countries use for family planning users at the end of the month and you are right it is a bit of a pain that DHIS-2 doesn’t support this sort of analysis right out of the box. We have health facilities report this cumulative indicator

[Dhis2-users] unable to update data visualizer favorites in DHIS-2 version 2.10

2013-04-20 Thread Wilson,Randy
Perhaps this has been fixed in 2.11, but I can't seem to create or update visualizer favorites to add to the dashboard anymore in our version 2.10 build 9057 on our production server. I've created several dozen charts that work fine, but can't seem to do anything new. After saving I get the me

Re: [Dhis2-users] Any suggestions for partner reporting in DHIS-2?

2013-03-28 Thread Wilson,Randy
rsday, March 28, 2013 7:51 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Any suggestions for partner reporting in DHIS-2? Hi Randy, on this issue there are lots of opinions - my recommendation would be to stick to the aggregate part of the system and leave ou

Re: [Dhis2-users] OptionSet and Yes-only Data Elements on Aggregated

2013-03-28 Thread Wilson,Randy
nship between a partner (or source) table and the organisationunit table and make that part of datavalue table. Randy From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: Wednesday, March 27, 2013 10:43 PM To: Ola Hodne Titlestad Cc: Wilson,Randy; dhis2-users@lists.launchpad.net; James

Re: [Dhis2-users] OptionSet and Yes-only Data Elements on Aggregated

2013-03-27 Thread Wilson,Randy
We've been working some more with the patient records module as well and have discovered that the category combinations don't render either. For example we have data we're collecting on number of VCT tests by different at risks groups (MARPS). I was trying to set up a data entry form with cate

Re: [Dhis2-users] Population Definition

2013-03-26 Thread Wilson,Randy
In Rwanda, we have tried to keep things simple by entering only total population figures for province, district, sector and health facility levels for each year. We have then created indicators for each of the major target population groups by using census breakdowns and multiplying the total p

[Dhis2-users] Any suggestions for partner reporting in DHIS-2?

2013-03-26 Thread Wilson,Randy
Hi all, Our HIV team works with civil society organizations and local partners to track a very simple list of services provided to persons living with HIV/Aids. The data elements themselves are all numeric so it would be easy to do in a regular data set, except that partners don't fit well in t

[Dhis2-users] Version 2.11 can't get datamart to start

2013-03-24 Thread Wilson,Randy
Hi all, I've just loaded version 2.11 - I like some of the new features, but I can't seem to get the datamart process to start. I ran resource tables and have scheduled the daily process to the level I want. But from within the Reports menu when I try to run for the last year I see a progress

Re: [Dhis2-users] Data Entry Form

2013-03-24 Thread Wilson,Randy
Hi Adedayo, Sounds like it might be a cache problem. Have you tried to run the data entry form in Chrome's incognito or Mozilla private browsing windows? If that works then you should clear the browser cache as well as the cache under Data administration in DHIS2. Randy From: dhis2-users-bo

Re: [Dhis2-users] Exporting DHIS Tracker data

2013-03-04 Thread Wilson,Randy
Hi David, You might be able to create a view of the tracker data that you can use for analysis. I've done something similar in Rwanda for an infant death audit form that we've developed using the individual records module. I'm not using program stages - just single event without registration.

Re: [Dhis2-users] Optimal settings for JAVA_OPTS on a 4 gig Windows 7 computer?

2013-02-23 Thread Wilson,Randy
Thanks Saptarshi. These settings worked like a charm. I guess I still need to add some more memory if I want to update our big dataset frequently. Randy From: Saptarshi Purkayastha [mailto:sun...@gmail.com] Sent: Saturday, February 23, 2013 3:23 AM To: Wilson,Randy Cc: dhis2-users

Re: [Dhis2-users] Optimal settings for JAVA_OPTS on a 4 gig Windows 7 computer?

2013-02-22 Thread Wilson,Randy
Knut Staring [mailto:knu...@gmail.com] Sent: Saturday, February 23, 2013 2:46 AM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Optimal settings for JAVA_OPTS on a 4 gig Windows 7 computer? Hi Randy, This is proobably not the solution, but just yesterday I had a pr

[Dhis2-users] Optimal settings for JAVA_OPTS on a 4 gig Windows 7 computer?

2013-02-22 Thread Wilson,Randy
Does anyone have suggestions for the optimal settings for JAVA_OPTS on a 4 gig Windows 7 64 bit OS? My computer hangs every time I try to run the DATAMART process. Current settings are: SET JAVA_OPTS=-Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m Randy Wilson _

Re: [Dhis2-users] Example of iReport based on custom query on DHIS-2 demo site?

2013-02-18 Thread Wilson,Randy
hanks, Randy From: Olav Poppe [mailto:olav.po...@me.com] Sent: Friday, February 15, 2013 9:49 AM To: Wilson,Randy Cc: DHIS Users Subject: Re: [Dhis2-users] Example of iReport based on custom query on DHIS-2 demo site? Hi, below is an example of an ireport using custom SQL, with report parameters

[Dhis2-users] Example of iReport based on custom query on DHIS-2 demo site?

2013-02-14 Thread Wilson,Randy
We've been trying to publish iReports in our DHIS-2 instance using custom queries and parameters, but continue to receive errors. I was hoping to see some examples on the demo site, but they are all based on report tables. Could someone put some examples of iReports based on custom postgres que

Re: [Dhis2-users] User accounts import

2013-01-21 Thread Wilson,Randy
Attached are some instructions and a template file that you can use to collect the data in excel - I would test on a local copy of the database before using on the production server. Randy From: dhis2-users-bounces+rwilson=msh@lists.launchpad.net [mailto:dhis2-users-bounces+rwilson=msh

  1   2   >