Re: [Dhis2-users] [Dhis2-devs] GIS failing to load in 2.25

2016-11-01 Thread Juan Manuel Alcantara Acosta 
Hi Jose
This was probably introduced by formatting the XML. This has not been a problem 
in previous versions.
JM

> El 01/11/2016, a las 07:04, Jose Garcia Muñoz  escribió:
> 
> 
> Great!! we had to remove the '\n' characters and also the white spaces... now 
> it is working! (I pay the beers next time in Oslo).
> 
> Now, how '\n' and '\s' characters could be introduced in our database? It 
> seems that our XMLs files are fine... (I can attach them if you want).
> 
> Thanks guys!
> 
> 
> On Tue, Nov 1, 2016 at 4:00 AM, Jose Garcia Muñoz  > wrote:
> 
> Thanks Lars,
> 
> I definitily will try to remove the '\n'. It is strange because we have '\n' 
> in the coordinates of all org. units. I have checked the XMLs we have used 
> for import, and they seem to be ok. Would it be related to a problem within 
> the import process? It seems that only happens in 2.25...
> 
> On Tue, Nov 1, 2016 at 3:14 AM, Lars Helge Øverland  > wrote:
> Hi Jose,
> 
> seems like you have a linebreak in your geojson, see:
> 
> "\n"
> 
> Likely not behaving well with json parsing. Try removing that.
> 
> 
> Lars
> 
> 
> 
> 
> 
> 
> 
> On Mon, Oct 31, 2016 at 9:36 PM, Jose Garcia Muñoz  > wrote:
> 
> Ok, I see, I think this is because of the blank spaces??
> 
> 
> 
> [{"id":"NC3WdxGafv5","code":"KH","na":"Cambodia","hcd":false,"hcu":true,"le":3,"pg":"/FvUGp8I75zV/aChOCLW4x6p","pi":"aChOCLW4x6p","pn":"Asia
>  and Eastern Europe","ty":2,"co":"\n
> 102.9176,11.6358],[102.3792,13.5749],[102.599,13.6079],[103.1812,14.3275],[104.8073,14.4484],[105.0764,14.2177],[105.2083,14.3495],[105.3621,14.1078],[106.0543,13.932],[106.1751,14.0639],[106.0048,14.3715],[106.5432,14.5967],[106.8563,14.3056],[107.5484,14.7066],[107.3397,14.1243],[107.4715,13.932],[107.6308,13.531],[107.5484,12.3554],[106.4223,11.9709],[106.4608,11.6633],[106.0488,11.7786],[105.818,11.6193],[106.2026,10.7679],[105.7796,11.0205],[105.1039,10.9546],[104.8842,10.5371],[104.4447,10.4218],[104.247,10.5701],[103.6207,10.4932],[103.5163,10.636],[103.7196,10.8667],[103.5548,11.1579],[103.1318,10.8832],[102.956,11.5534],[103.0824,11.7237],[102.8956,11.8281],[102.9176,11.6358
>  "}]
> 
> On Mon, Oct 31, 2016 at 9:02 PM, Bjørn Sandvik  > wrote:
> Hi Jose, 
> 
> Could you send the the results of the geoFeatures query than your GIS app is 
> requesting?
> 
> The coordinate format should be similar to:
> https://play.dhis2.org/demo/api/25/geoFeatures.json?ou=ou:LEVEL-2;ImspTQPwCqd=NAME
>  
> 
> 
> "co": 
> "-11.5914,8.4875],[-11.5906,8.4769],[-11.5898,8.4717],[-11.5882,8.466] ...
> 
> -- 
> Bjørn Sandvik
> GIS developer, DHIS 2
> University of Oslo
> www.dhis2.org 
>  
> 
> 
> On Mon, Oct 31, 2016 at 6:19 PM, Jose Garcia Muñoz  > wrote:
> 
> Thanks for the quick actions Jan, Bjorn,
> 
> Almost there :). Now the GIS is being displayed, but whenver I want to 
> display the bounderies of a country (or bounderies of any level) I'm getting 
> the following error:
> 
> The org. units have been imported from 2.22 to 2.25. It seems that everything 
> is correct in the database... 
> 
> Am I missing something? Any ideas? :)
> 
> Thanks!
> 
> Uncaught Error: Invalid LatLng object: (102.3792,13.5749, 102.9176,11.6358)
> at L.LatLng 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:2:14559 
> )
> at coordsToLatLng 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:18296 
> )
> at Function.coordsToLatLngs 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:18573 
> )
> at Function.coordsToLatLngs 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:18481 
> )
> at Function.geometryToLayer 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:17850 
> )
> at NewClass.addData 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:16349 
> )
> at NewClass.addData 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:16219 
> )
> at NewClass.initialize 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:5:15944 
> )
> at NewClass.initialize 
> (http://localhost:8080/dhis225/dhis-web-mapping/app.js:7:8380 
>

Re: [Dhis2-users] Single or duplicate data elements for mixed period collection?

2016-07-14 Thread Juan Manuel Alcantara Acosta 
Hi Knut
One way to avoid double counting is to make sure both data sets are never 
active in the same org units.
JM


> El 14/07/2016, a las 2:10 p.m., Knut Staring  escribió:
> 
> Hi David,
> 
> I think it will work quite well to just use the same data element in 
> different datasets with different periodicity. The only thing to look out for 
> is to avoid double counting, e.g. watch out for misleading Totals in 
> Analytics.
> 
> Knut
> 
> On Wed, Jul 13, 2016 at 9:23 AM, David Hagan  > wrote:
> Good morning DHIS2 community,
> 
> It's been a while ... changing mail clients meant that forum messages skipped 
> my in-box ... and what do they say ... 'out of sight - out of mind'.
> 
> Anyway, I've rearranged settings and can see the email list is as busy as 
> ever!
> 
> And onto my burning question:
> 
> If we have a mix of organisational units (countries in our case, collecting 
> national data) that:
> some of which have historical monthly data, and some of which only have 
> annual data; and
> going forward, are transitioning to monthly data (but some will be slower and 
> for the next couple of years will only have annual data)
> AND we want to bring this into a single DHIS2 instance, then
> Is the best approach to create a set of duplicate data elements (in different 
> datasets, one set for an annual collection period and one set for a monthly 
> collection period)? or
> Is it possible to use a single data element in two different datasets with 
> different periods set (one monthly and one annual)? ... (I don't see how this 
> would work in practice, but maybe I'm just missing something - I know it is 
> possible to put a DE in more than one dataset, but mixed collection periods 
> for the same data element seems like it will mess up reporting and analytics)
> Any thoughts or guidance or other options from the group appreciated.
> 
> Regards
> 
> David Hagan
> 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.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

___
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] Data Loss

2015-09-07 Thread Juan Manuel Alcantara Acosta 
  |36
>> 2012-11-01 | 2012-11-30 | Konia MCHP  |21
>> 2011-10-01 | 2011-10-31 | Saahun (barri) MCHP | 4
>> 2013-07-01 | 2013-07-31 | Njaluahun CHP   |18
>> 2011-11-01 | 2011-11-30 | Taninahun MCHP  |17
>> 2014-05-01 | 2014-05-31 | Njaluahun CHP   |27
>> 2013-04-01 | 2013-04-30 | Njaluahun CHP   |19
>> 2014-02-01 | 2014-02-28 | Njaluahun CHP   |34
>> 2014-07-01 | 2014-07-31 | Njaluahun CHP   |22
>> 2011-05-01 | 2011-05-31 | Potoru CHC  |26
>> 2012-06-01 | 2012-06-30 | Taninahun MCHP  |24
>> 2011-09-01 | 2011-09-30 | Konia MCHP  |19
>> 2014-10-01 | 2014-10-31 | Taninahun MCHP  |30
>> 2012-08-01 | 2012-08-31 | Bandasuma CHC   |22
>> 2012-09-01 | 2012-09-30 | Njaluahun CHP   |21
>> 2012-07-01 | 2012-07-31 | Potoru CHC  |24
>> 2011-12-01 | 2011-12-31 | Tambeyama MCHP  |15
>> 2012-10-01 | 2012-10-31 | Tambeyama MCHP  |22
>> 2011-04-01 | 2011-04-30 | Potoru CHC  |12
>> 2012-05-01 | 2012-05-31 | Potoru CHC  |24
>> 2014-08-01 | 2014-08-31 | Potoru CHC  |34
>> 2012-12-01 | 2012-12-31 | Taninahun MCHP  |24
>> 2011-07-01 | 2011-07-31 | Bandasuma CHC   |26
>> 2012-12-01 | 2012-12-31 | Tambeyama MCHP  |16
>> 2013-10-01 | 2013-10-31 | Njaluahun CHP   |28
>> 2013-06-01 | 2013-06-30 | Vaama MCHP  |19
>> 2013-05-01 | 2013-05-31 | Potoru CHC  |23
>> 2012-10-01 | 2012-10-31 | Taninahun MCHP  |24
>> 2012-04-01 | 2012-04-30 | Potoru CHC  |26
>> 2011-12-01 | 2011-12-31 | Taninahun MCHP  |21
>> 2014-10-01 | 2014-10-31 | Tambeyama MCHP  |17
>> 2015-03-01 | 2015-03-31 | Potoru CHC  |28
>> 2014-03-01 | 2014-03-31 | Saahun (barri) MCHP |14
>> 2012-06-01 | 2012-06-30 | Tambeyama MCHP  |20
>> 2013-11-01 | 2013-11-30 | Konia MCHP  |20
>> 2012-11-01 | 2012-11-30 | Vaama MCHP  |24
>> (368 rows)
>> 
>> (END)
>> 
>> The query didn't come back with any information about January 2015 for
>> those data elements but there is information for the others on the HF1
>> forms.
>> 
>> QUESTIONS:
>> 1. Is it possible that minimum & maximum values as per data elements
>> is affecting our data?
>> 2. We have a lock period to verify the data entry clerks efficiency;
>> and most of them are saying this situation normally happened after the
>> system had been reopened and they are trying to key in their backlogs.
>> Is it possible that the lock period is the cause of our loss data.
>> 
>> Thanks for your usual cooperation.
>> 
>> 
>> On 8/28/15, Juan Manuel Alcantara Acosta <jmalcanta...@gmail.com> wrote:
>>> Hello Gerald
>>> That looks fine, should return all the org units in your database. I
>>> think
>>> it will be simpler for you to get the UIDs from the API or from the org
>>> unit
>>> administration tools, for example using Organisation unit search, the
>>> results will show the UID in the first column.
>>> Regards,
>>> JM
>>> 
>>> El 27/08/2015, a las 15:58, gerald thomas <gerald17...@gmail.com>
>>> escribió:
>>> 
>>>> Dear Juan,
>>>> Sorry about the confusion with the query;
>>>> 
>>>> To get all the UIDs for organisationunit, i tried this query but it
>>>> didn't
>>>> work:
>>>> 
>>>> SELECT * FROM organisationunit;
>>>> 
>>>> Please am i correct or wrong to run this query?
>>>> 
>>>> On 8/27/15, gerald thomas <gerald17...@gmail.com> wrote:
>>>>> Dear Juan,
>>>>> 
>>>>> If it is, then please view result:
>>>>> 
>>>>> 
>>>>> hmis=# SELECT period.startdate, period.enddate, organisationunit.name,
>>>>> count(datavalue.sourceid) FROM datavalue, period, organisationunit
>>>>> hmis-# WHERE datavalue.periodid = period.periodid AND
>>>>> datavalue.sourceid = organisationunit.organisationunitid
>>>>> hmis-# AND datavalue.dataelementid IN (SELECT dataelementid FROM
>>>>> dataelement WHERE uid IN
>>>>> hmis(#
>>>>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))

Re: [Dhis2-users] Data Loss

2015-08-24 Thread Juan Manuel Alcantara Acosta 

El 24/08/2015, a las 08:00, gerald thomas gerald17...@gmail.com escribió:

 Dear Juan,
 Under Maintenance column i am seeing the following:
 
 Clear analytics tables
 
 Clear data mart
 
 Rebuild data mart index
 
 Clear zero values
 
 Clear data set completeness
 
 Prune periods
 
 Remove expired invitations
 
 Drop SQL views
 
 Create SQL views
 
 Update category option combinations
 
 What should I check for the performance maintenance before doing the
 query again?
 
 On 8/24/15, gerald thomas gerald17...@gmail.com wrote:
 Dear Juan,
 No!!! This is the holistic data from that query. Previously i only had
 the first part of the result. Do you want me to rebuild tables and run
 query again?
 
 On 8/24/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote:
 Hello Gerald
 This looks much different than the fist one you sent me and it's still
 missing a lot of names, did you rebuild resource tables?
 JM
 
 El 24/08/2015, a las 05:44, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 Thanks for your responses.
 Sorry i am only responding now but please find the attached category
 combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote:
 Sorry, I got distracted and hit send before completing the message.
 
 You should limit the query to show the values of the specific data
 elements
 that are giving you trouble, you'll need the uid of each of the data
 element., In case you don't know how to get that information, you can
 use
 the api (your_server_URL/api/dataElements?paging=false) or look at the
 information if each data element in data element management selecting
 show
 details from the contextual menu that appears when clocking on the
 name
 of
 each data element. Then add to the query the list of UIDs just before
 the
 semicolon.
 
 WHERE de.uid IN
 ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
 
 Please excuse me if you already know all of these things, since I don't
 have
 a way to know how much you know about the system and postgres queries I
 rather be detailed on what you have to do than leave you guessing.
 
 In addition to running maintenance to update category option
 combinations
 you should re-generate resource tables, you'll find that in Data
 Administration too.
 
 
 Regards,
 JM
 
 
 
 El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
 jmalcanta...@gmail.com escribió:
 
 Hi Gerald
 I see you are missing a few category option combo names, you should
 run
 the maintenance to Update category option combinations, you'll find
 this
 in Data Administration - maintenance
 I also don't see the option combinations of the data elements you
 highlighted in the excel you sent to the list. Which category
 combination
 are you using with those data elements? Run the query again after
 doing
 the maintenance.
 
 15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, 49yrs
 
 About the out of memory error, I recommend that you use pgAdmin3 and
 try
 to run the query again. You should limit the query to show you the
 data
 
 El 23/08/2015, a las 15:39, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 For the datavalues query; i am getting Out of memory as result.
 Please find the attached result for the combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com
 wrote:
 Hello Gerald
 Does data disappear only from data elements that use the default
 category
 combination?
 Since you are querying your database directly, I'm sending you here
 a
 couple
 of queries you can use to verify the existing values of the database
 and
 the
 category combinations. Check if you have more than one default
 option
 combination.
 
 Regards,
 JM
 
 
 
 
 
 
 El 23/08/2015, a las 11:36, gerald thomas gerald17...@gmail.com
 escribió:
 
 Juan,
 Thanks for your response but we are not using custom forms for data
 entry.
 
 Regards,
 Gerald
 
 On Aug 23, 2015 4:29 PM, Juan Manuel Alcantara Acosta
 jmalcanta...@gmail.com wrote:
 Hello Gerald
 Are you using custom forms for data entry?
 JM
 El 22/08/2015, a las 15:37, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear dhis2-users,
 If someone cannot help me; can anyone explain why am i having data
 for
 October, November, December 2015 on my database?
 
 dhis=# select * from period where startdate  '2015-01-01';
 periodid | periodtypeid | startdate  |  enddate
 --+--++
 1121694 |6 | 2016-01-01 | 2016-12-31
 2058605 |3 | 2015-11-01 | 2015-11-30
 2058606 |3 | 2015-12-01 | 2015-12-31
 2058607 |3 | 2015-10-01 | 2015-10-31
 2058611 |1 | 2015-01-16 | 2015-01-16
 2058619 |1 | 2015-01-26 | 2015-01-26
 2058631 |1 | 2015-01-29 | 2015-01-29
 2058632 |3 | 2015-09-01 | 2015-09-30
 2058656 |3 | 2015-02-01 | 2015-02-28
 2058727 |3 | 2015-06-01 | 2015-06-30
 2058806 |3 | 2015-07-01 | 2015-07-31
 2058811

Re: [Dhis2-users] Data Loss

2015-08-24 Thread Juan Manuel Alcantara Acosta 
Select Update category option combinations and click on  perform 
maintenance. After that finished select from the menu of the left Resource 
Table and click on Generate tables.
Regards,
JM

El 24/08/2015, a las 08:00, gerald thomas gerald17...@gmail.com escribió:

 Dear Juan,
 Under Maintenance column i am seeing the following:
 
 Clear analytics tables
 
 Clear data mart
 
 Rebuild data mart index
 
 Clear zero values
 
 Clear data set completeness
 
 Prune periods
 
 Remove expired invitations
 
 Drop SQL views
 
 Create SQL views
 
 Update category option combinations
 
 What should I check for the performance maintenance before doing the
 query again?
 
 On 8/24/15, gerald thomas gerald17...@gmail.com wrote:
 Dear Juan,
 No!!! This is the holistic data from that query. Previously i only had
 the first part of the result. Do you want me to rebuild tables and run
 query again?
 
 On 8/24/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote:
 Hello Gerald
 This looks much different than the fist one you sent me and it's still
 missing a lot of names, did you rebuild resource tables?
 JM
 
 El 24/08/2015, a las 05:44, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 Thanks for your responses.
 Sorry i am only responding now but please find the attached category
 combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote:
 Sorry, I got distracted and hit send before completing the message.
 
 You should limit the query to show the values of the specific data
 elements
 that are giving you trouble, you'll need the uid of each of the data
 element., In case you don't know how to get that information, you can
 use
 the api (your_server_URL/api/dataElements?paging=false) or look at the
 information if each data element in data element management selecting
 show
 details from the contextual menu that appears when clocking on the
 name
 of
 each data element. Then add to the query the list of UIDs just before
 the
 semicolon.
 
 WHERE de.uid IN
 ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
 
 Please excuse me if you already know all of these things, since I don't
 have
 a way to know how much you know about the system and postgres queries I
 rather be detailed on what you have to do than leave you guessing.
 
 In addition to running maintenance to update category option
 combinations
 you should re-generate resource tables, you'll find that in Data
 Administration too.
 
 
 Regards,
 JM
 
 
 
 El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
 jmalcanta...@gmail.com escribió:
 
 Hi Gerald
 I see you are missing a few category option combo names, you should
 run
 the maintenance to Update category option combinations, you'll find
 this
 in Data Administration - maintenance
 I also don't see the option combinations of the data elements you
 highlighted in the excel you sent to the list. Which category
 combination
 are you using with those data elements? Run the query again after
 doing
 the maintenance.
 
 15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, 49yrs
 
 About the out of memory error, I recommend that you use pgAdmin3 and
 try
 to run the query again. You should limit the query to show you the
 data
 
 El 23/08/2015, a las 15:39, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 For the datavalues query; i am getting Out of memory as result.
 Please find the attached result for the combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com
 wrote:
 Hello Gerald
 Does data disappear only from data elements that use the default
 category
 combination?
 Since you are querying your database directly, I'm sending you here
 a
 couple
 of queries you can use to verify the existing values of the database
 and
 the
 category combinations. Check if you have more than one default
 option
 combination.
 
 Regards,
 JM
 
 
 
 
 
 
 El 23/08/2015, a las 11:36, gerald thomas gerald17...@gmail.com
 escribió:
 
 Juan,
 Thanks for your response but we are not using custom forms for data
 entry.
 
 Regards,
 Gerald
 
 On Aug 23, 2015 4:29 PM, Juan Manuel Alcantara Acosta
 jmalcanta...@gmail.com wrote:
 Hello Gerald
 Are you using custom forms for data entry?
 JM
 El 22/08/2015, a las 15:37, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear dhis2-users,
 If someone cannot help me; can anyone explain why am i having data
 for
 October, November, December 2015 on my database?
 
 dhis=# select * from period where startdate  '2015-01-01';
 periodid | periodtypeid | startdate  |  enddate
 --+--++
 1121694 |6 | 2016-01-01 | 2016-12-31
 2058605 |3 | 2015-11-01 | 2015-11-30
 2058606 |3 | 2015-12-01 | 2015-12-31
 2058607 |3 | 2015-10-01 | 2015-10-31
 2058611 |1 | 2015-01-16 | 2015-01-16
 2058619 |1 | 2015-01-26 | 2015-01-26
 2058631 |1 | 2015-01-29 | 2015-01-29
 2058632 |3

Re: [Dhis2-users] Data Loss

2015-08-24 Thread Juan Manuel Alcantara Acosta 
Hello Gerald
What was the result of the datavalue query?
You should also check the sharing settings of the data elements that are giving 
you trouble.
JM
El 24/08/2015, a las 08:43, gerald thomas gerald17...@gmail.com escribió:

 Dear Juan,
 Please find the attached updated combo query.
 
 On 8/24/15, gerald thomas gerald17...@gmail.com wrote:
 Dear Juan,
 Noted!!! It is now generating resource table and i will keep you
 posted once it had been completed
 
 On 8/24/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote:
 Select Update category option combinations and click on  perform
 maintenance. After that finished select from the menu of the left
 Resource
 Table and click on Generate tables.
 Regards,
 JM
 
 El 24/08/2015, a las 08:00, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 Under Maintenance column i am seeing the following:
 
 Clear analytics tables
 
 Clear data mart
 
 Rebuild data mart index
 
 Clear zero values
 
 Clear data set completeness
 
 Prune periods
 
 Remove expired invitations
 
 Drop SQL views
 
 Create SQL views
 
 Update category option combinations
 
 What should I check for the performance maintenance before doing the
 query again?
 
 On 8/24/15, gerald thomas gerald17...@gmail.com wrote:
 Dear Juan,
 No!!! This is the holistic data from that query. Previously i only had
 the first part of the result. Do you want me to rebuild tables and run
 query again?
 
 On 8/24/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com
 wrote:
 Hello Gerald
 This looks much different than the fist one you sent me and it's still
 missing a lot of names, did you rebuild resource tables?
 JM
 
 El 24/08/2015, a las 05:44, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 Thanks for your responses.
 Sorry i am only responding now but please find the attached category
 combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com
 wrote:
 Sorry, I got distracted and hit send before completing the message.
 
 You should limit the query to show the values of the specific data
 elements
 that are giving you trouble, you'll need the uid of each of the data
 element., In case you don't know how to get that information, you
 can
 use
 the api (your_server_URL/api/dataElements?paging=false) or look at
 the
 information if each data element in data element management
 selecting
 show
 details from the contextual menu that appears when clocking on the
 name
 of
 each data element. Then add to the query the list of UIDs just
 before
 the
 semicolon.
 
 WHERE de.uid IN
 ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
 
 Please excuse me if you already know all of these things, since I
 don't
 have
 a way to know how much you know about the system and postgres
 queries
 I
 rather be detailed on what you have to do than leave you guessing.
 
 In addition to running maintenance to update category option
 combinations
 you should re-generate resource tables, you'll find that in Data
 Administration too.
 
 
 Regards,
 JM
 
 
 
 El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
 jmalcanta...@gmail.com escribió:
 
 Hi Gerald
 I see you are missing a few category option combo names, you should
 run
 the maintenance to Update category option combinations, you'll
 find
 this
 in Data Administration - maintenance
 I also don't see the option combinations of the data elements you
 highlighted in the excel you sent to the list. Which category
 combination
 are you using with those data elements? Run the query again after
 doing
 the maintenance.
 
 15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, 49yrs
 
 About the out of memory error, I recommend that you use pgAdmin3
 and
 try
 to run the query again. You should limit the query to show you the
 data
 
 El 23/08/2015, a las 15:39, gerald thomas gerald17...@gmail.com
 escribió:
 
 Dear Juan,
 For the datavalues query; i am getting Out of memory as result.
 Please find the attached result for the combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com
 wrote:
 Hello Gerald
 Does data disappear only from data elements that use the default
 category
 combination?
 Since you are querying your database directly, I'm sending you
 here
 a
 couple
 of queries you can use to verify the existing values of the
 database
 and
 the
 category combinations. Check if you have more than one default
 option
 combination.
 
 Regards,
 JM
 
 
 
 
 
 
 El 23/08/2015, a las 11:36, gerald thomas gerald17...@gmail.com
 escribió:
 
 Juan,
 Thanks for your response but we are not using custom forms for
 data
 entry.
 
 Regards,
 Gerald
 
 On Aug 23, 2015 4:29 PM, Juan Manuel Alcantara Acosta
 jmalcanta...@gmail.com wrote:
 Hello Gerald
 Are you using custom forms for data entry?
 JM
 El 22/08/2015, a las 15:37, gerald thomas
 gerald17...@gmail.com
 escribió:
 
 Dear dhis2-users,
 If someone cannot help me; can anyone explain why am i having
 data
 for
 October, November, December 2015

Re: [Dhis2-users] Data Loss

2015-08-23 Thread Juan Manuel Alcantara Acosta 
Hello Gerald
Are you using custom forms for data entry?
JM
El 22/08/2015, a las 15:37, gerald thomas gerald17...@gmail.com escribió:

 Dear dhis2-users,
 If someone cannot help me; can anyone explain why am i having data for
 October, November, December 2015 on my database?
 
 dhis=# select * from period where startdate  '2015-01-01';
 periodid | periodtypeid | startdate  |  enddate
 --+--++
  1121694 |6 | 2016-01-01 | 2016-12-31
  2058605 |3 | 2015-11-01 | 2015-11-30
  2058606 |3 | 2015-12-01 | 2015-12-31
  2058607 |3 | 2015-10-01 | 2015-10-31
  2058611 |1 | 2015-01-16 | 2015-01-16
  2058619 |1 | 2015-01-26 | 2015-01-26
  2058631 |1 | 2015-01-29 | 2015-01-29
  2058632 |3 | 2015-09-01 | 2015-09-30
  2058656 |3 | 2015-02-01 | 2015-02-28
  2058727 |3 | 2015-06-01 | 2015-06-30
  2058806 |3 | 2015-07-01 | 2015-07-31
  2058811 |2 | 2015-03-02 | 2015-03-08
  2058812 |3 | 2015-03-01 | 2015-03-31
  2058814 |3 | 2015-05-01 | 2015-05-31
  2065151 |6 | 2020-01-01 | 2020-12-31
  2072304 |3 | 2015-04-01 | 2015-04-30
  2109802 |4 | 2015-04-01 | 2015-06-30
  2115342 |3 | 2015-08-01 | 2015-08-31
  2122928 |   292091 | 2015-03-01 | 2015-04-30
  2129098 |2 | 2015-05-25 | 2015-05-31
  2129099 |1 | 2015-12-31 | 2015-12-31
 Please we need to fix this issue of data loss; can anyone out there help me.
 Please !!!
 
 On 8/20/15, gerald thomas gerald17...@gmail.com wrote:
 Dear All,
 We are having a serious issues on our online server in Sierra Leone.
 Data are normally entered but during analysis these data normally got
 missing. This had been an issue i had raised before but the situation
 is still the same and it is even worst now.
 
 Please this is an urgent technical problem we need to fix for Sierra
 Leone and any help will be appreciated till we overcome this
 situation.
 
 Please help us!
 
 --
 Regards,
 
 Gerald
 
 
 
 -- 
 Regards,
 
 Gerald
 
 ___
 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

___
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] [Dhis2-devs] Meta Data Import Problem When upgrading from Version 2.13 to 2.20

2015-08-20 Thread Juan Manuel Alcantara Acosta 
Hi Mihayo
A copy of the log would be useful to help you but based on the list of 
conflicts shown in the image you included, the ignored org units are missing 
the opening date, check your XML and add a valid date where it's missing, 
here's an example:

organisationUnit xmlns=http://dhis2.org/schema/dxf/2.0; code=OU_222702 
uuid=b1c9eff6-92e0-465b-8e33-71012171eeb2 
lastUpdated=2014-11-25T08:37:53.469+href=https://apps.dhis2.org/dev/api/organisationUnits/ueuQlqb8ccl;
 id=ueuQlqb8ccl level=4 created=2012-02-17T14:54:39.987+ name= 
Panderu MCHP shortName= Panderu MCHP
displayNamePanderu MCHP/displayName
displayShortNamePanderu MCHP/displayShortName
externalAccessfalse/externalAccess
path/ImspTQPwCqd/kJq2mPyFEHo/KIUCimTXf8Q/ueuQlqb8ccl/path
openingDate1993-12-31T23:00:00.000+/openingDate
parent id=KIUCimTXf8Q name=Nongowa code=OU_222690 
created=2012-02-17T14:54:39.987+ 
lastUpdated=2014-11-25T08:37:53.296+href=https://apps.dhis2.org/dev/api/organisationUnits/KIUCimTXf8Q/
/organisationUnit



JM

El 20/08/2015, a las 16:23, Mihayo Mathayo princeh...@gmail.com escribió:

 Hello Team,
  Am having a problem with upgrade of dhis2 instance from version 2.13 to 
 2.20.The issue am facing is on importing meta data where top level,level two 
 and level three  OrganizationUnits are ignored but the lowest level 
 organizations units are imported into version 2.20.
 
 Attached screenshots gives a summary of the problem.
 
 Any help will be highly appreciated.
 
 Best Regards. 
 DHIS_import.PNGDHIS2_Conflict.PNG___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : 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
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Bug when using 'User org unit' Org unit selection mode

2015-04-01 Thread Juan Manuel Alcantara Acosta 
Hi Prosper
I think this happens when the user account doesn’t have an org unit selected 
for Data output and analysis, I looked at the admin account and after selecting 
an org unit and saving the change the error disappeared.
Best regards,
JM

 El 01/04/2015, a las 13:28, Prosper BT ptb3...@gmail.com escribió:
 
 Hi Lars,
 
 Here is a link for the chart I created but may not be available tomorrow 
 since you overwrite the demo server
 
 https://apps.dhis2.org/demo/dhis-web-visualizer/index.html?id=npnDtFiFy7S 
 https://apps.dhis2.org/demo/dhis-web-visualizer/index.html?id=npnDtFiFy7S
 
 Its only yhe user Org unit; the sub-unit and sub-2x unit work well
 
 Regards 
 
 On Wed, Apr 1, 2015 at 2:10 PM, Lars Helge Øverland larshe...@gmail.com 
 mailto:larshe...@gmail.com wrote:
 Hi Prosper,
 
 can you please share the link the favorite on the demo?
 
 (From DV  Share  Favorite link)
 
 regards,
 
 Lars
 
 
 On Wed, Apr 1, 2015 at 11:43 AM, Prosper BT ptb3...@gmail.com 
 mailto:ptb3...@gmail.com wrote:
 Dear Team,
 
 Building charts, tables and GIS for user based on their assigned Orgunit 
 level.
 
 We have used this functional to build shared dashboard and chart/tables/gis 
 would display Orunit name in the header.
 
 With 2.18  on the live demo currently and stable versions, we are not able to 
 see the Orgunit of the user its displays undefined
 
 see below..
 
 Anyone experiencing the same
 
 Regards
 Screen Shot 2015-04-01 at 12.34.48 PM.png
 
 -- 
 Prosper Behumbiize, MPH
 Phone:+256 414 320076
 Cell: +256 772 139037 tel:%2B256%20772%20139037
  +256 752 751776 tel:%2B256%20752%20751776
 
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net 
 mailto:dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp 
 https://help.launchpad.net/ListHelp
 
 
 
 
 
 -- 
 Prosper Behumbiize, MPH
 Phone:+256 414 320076
 Cell: +256 772 139037
  +256 752 751776
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net 
 mailto:dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp 
 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] Generating Monthly Indicators

2015-03-25 Thread Juan Manuel Alcantara Acosta 
Hi Lars
Does this work with atomic indicators?
Best regards,
JM
 El 24/03/2015, a las 1:16, Lars Helge Øverland larshe...@gmail.com escribió:
 
 Hi Baakai,
 
 make sure you set the aggregation operator to average (sum in org unit 
 hierarchy) on the population data elements. Then set annualized to yes for 
 your indicators.
 
 regards,
 
 Lars
 
 
 On Tue, Mar 24, 2015 at 4:49 AM, Baakai Kamoriki btkamor...@gmail.com 
 mailto:btkamor...@gmail.com wrote:
 Dear all,
 
 Can anyone enlightens on how to generate monthly indicators which uses
 yearly population data?
 
 I had been trying to run pivot table on some health indicator for
 Solomon Islands such as watery diarrhoea, ARI to name a few by month
 but the pivot table always say no values.  In fact these data are
 collected on a monthly basis, however our population figures are
 yearly?
 
 Is there a way to do this kind of analysis in DHIS?
 
 We are currently using version 2.18.
 
 Many thanks.
 
 --
 Mrs Baakai Kamoriki
 Chief Medical Statistician
 HIS Unit/ MOH
 Honiara
 Solomon Islands
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net 
 mailto:dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp 
 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

___
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] Tablet recommendations for DHIS2

2015-02-26 Thread Juan Manuel Alcantara Acosta 
Yes, the model that was purchased by PSI Ethiopia is the Samsung galaxy tab 3 
7.0”  3G.
Regards,
JM

 El 26/02/2015, a las 16:23, Nicola Hobby nho...@psi.org escribió:
 
 HI Laura, 
 We developed this article that discusses the various technical spec 
 considerations. Just some things to think about when choosing… I believe our 
 team has been testing Samsung tablets.  
 https://helppsi.zendesk.com/hc/en-us/articles/201147148-Mobiles-and-Tablets-Options
  
 https://helppsi.zendesk.com/hc/en-us/articles/201147148-Mobiles-and-Tablets-Options
 Thanks,
 Nicola 
 -- 
 Nicola Hobby
 MIS Program Manager
 
 Office: +1 (202) 469-6685 tel:%2B1%20%28202%29%20469-6685
 Skype: nicolahobby
 
 Connect with PSI
 Website http://www.psi.org/  |  Blog http://blog.psiimpact.com/  |  
 Twitter https://twitter.com/PSIimpact  |  Facebook 
 https://www.facebook.com/PSIHealthyLives  |  YouTube 
 http://www.youtube.com/user/healthybehaviors
 
 Donate to PSI
 www.psi.org http://www.psi.org/. 94.5 cents of every dollar raised directly 
 supports PSI programs.
 
 
 From: Laura E. Lincks laura.lin...@icap.columbia.edu 
 mailto:laura.lin...@icap.columbia.edu
 Date: Thursday, February 26, 2015 at 5:15 PM
 To: dhis2-users dhis2-users@lists.launchpad.net 
 mailto:dhis2-users@lists.launchpad.net
 Subject: [Dhis2-users] Tablet recommendations for DHIS2
 
 We're purchasing 2 tablets to test data collection in Lesotho. Does anyone 
 have suggestions on what to (or what not to) purchase? We're thinking the 
 Nexus 9... does anyone have experience with that? Thx.
 
 -- 
 Laura E. Lincks 
 Database
 
 ​Manager/​ Developer
 ICAP - Columbia University
 
 
 ___
 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

___
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] Exporting Persons and Programs

2014-01-29 Thread Juan Manuel Alcantara Acosta 
Hello Morten
I teste it with v. 2.13 build 12953 dated 2014-01-26 and it didn't work.

Best regards,
JM




El 22/01/2014, a las 05:31, Morten Olav Hansen morte...@gmail.com escribió:

 I have now backported this to 2.13. Please test it out. I did not backport 
 the UI, so its only available in the web-api (/api/events).
 
 If you are having issues getting the correct format, you can also use 
 .xml/.json
 
 includeChildren for persons might be good to have, but it would require a bit 
 of work.. maybe for 2.15
 
 --
 Morten
 
 
 On Wed, Jan 22, 2014 at 4:39 PM, Morten Olav Hansen morte...@gmail.com 
 wrote:
 Hi,
 
 includeChildren/includeDescendants is only available in 2.14 and newer. I 
 will have a look and see if it can be backported to 2.13.
 
 --
 Morten
 
 
 On Wed, Jan 22, 2014 at 6:23 AM, Juan Manuel Alcantara Acosta 
 jmalcanta...@gmail.com wrote:
 Hi Guys
 I hope you are well.
 
 As you probably know already, we are in the process of moving the data and 
 programs of a few countries that have been working on the development server 
 of PSI to the production server (v. 2.13), this task requires being able to 
 export both persons with the corresponding enrollments to programs and 
 multiple events/stages.
 
 I tried to export events using the API and the systems always returns an 
 empty response. Here's an example of the request I'm using:
 
 curl 
 http://localhost:8080/dhis/api/events?orgUnit=YypjoDjI7ZgincludeChildren=truestartDate=2013-10-01endDate=2013-12-31programStage=wxloTxBJMlq;
  -H Content-Type:application/xml -u [usr]:[pass] -v
 
 No data is returned by the system and I also noticed that even though xml is 
 specified, the empty response is in json { }
 
 What is your recommendation to export and import persons and program 
 enrollments?
 By the way I see I can query the API for persons in one org Unit, that could 
 take a while, it would be great if we could use includeChildren.
 
 curl 
 http://localhost:8080/dhis/api/persons?orgUnit=YypjoDjI7ZgincludeChildren=true;
  -H Content-Type:application/xml -u [usr]:[pass] -v
 
 The same as with events, api/persons returns the answer in json
 
 Best regards,
 JM
 
 

___
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] sort the person attributes (Persons and Programs)

2014-01-22 Thread Juan Manuel Alcantara Acosta 
Hi Jose
I agree, it would be great if we could sort the list of values, configure a 
default option and in the absence of a default show the field empty (null) if 
nothing has been selected. It's confusing for users when they open a profile 
and an option is shown even if the field should be empty.
Best regards,
JM



El 22/01/2014, a las 14:05, Jose Garcia Muñoz josem...@gmail.com escribió:

 
 Dear all,
 
 Could it be possible in some of the next revisions to include the option of 
 sorting the values of a person attribute of the type predefined value? For 
 the users it will be quite useful if they want to introduce some kind of 
 default value.
 
 Thanks
 Jose
 ___
 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


___
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] Tabular report not showing any data

2013-12-03 Thread Juan Manuel Alcantara Acosta 
Hi Everyone
I'm having some problems with the tabular report and I'd like to know if anyone 
else using 2.13 build 12884 or newer is experiencing the same problems. 

1- Case based reports do not show any data, the count of records at the bottom 
right corner indicates a total number of records found and a number of pages 
are generated but no data is shown.
2- Aggregate reports do not show any data at all

Regards,
JM___
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] [Dhis2-devs] Error with Validation Group: DHIS2.12 build 11290

2013-08-28 Thread Juan Manuel Alcantara Acosta 
Did you upgrade from 2.11 to 2.12?
JM

El 28/08/2013, a las 05:42, Adebusoye Anifalaje bus...@hisp.org escribió:

 Dear all,
 
 We receive an error message when trying to add a validation rule to a group. 
 
 I noticed that during start up, there is an error message:
 
 * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table 
 validationrulegroupmembers add constraint 
 fk_validationrulegroupmembers_validatio
 nrulegroupid foreign key (validationgroupid) references validationrulegroup 
 (SchemaUpdate.java [pool-2-thread-1])
 * ERROR 2013-08-28 12:24:32,468 ERROR: constraint 
 fk_validationrulegroupmembers_validationrulegroupid for relation 
 validationrulegroupmembers already exists (SchemaUpdate.java 
 [pool-2-thread-1])
 
 
 The error message during the operation is:
 
 * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column 
 validationgroupid violates not-null constraint
  Detail: Failing row contains (null, null, null, null, null, palidusime, , 
 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5])
 * ERROR 2013-08-28 12:25:53,531 Error while executing action 
 (ExceptionInterceptor.java [http-apr-8080-exec-5])
 org.springframework.dao.DataIntegrityViolationException: could not execute 
 statement; SQL [n/a]; constraint [validationgroupid]; nested exception is 
 org.hibernate.exception.ConstraintViolationException: could not execute 
 statement
 
 Caused by: org.postgresql.util.PSQLException: ERROR: null value in column 
 validationgroupid violates not-null constraint
  Detail: Failing row contains (null, null, null, null, null, palidusime, , 
 2562).
 
 I am using DHIS2.12 build 11290
 
 
 Does anyone know what's happening here?
 
 Thanks
 
 Busoye
 
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : 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
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Error with Validation Group: DHIS2.12 build 11290

2013-08-28 Thread Juan Manuel Alcantara Acosta 
I had the same problem upgrading from 2.11 to 2.12 and found a work around, you 
need to have at least one validation rule group before doing the upgrade.
Regards,
JM

El 28/08/2013, a las 12:13, Adebusoye Anifalaje bus...@hisp.org escribió:

 Hi Juan,
 
 I didn't upgrade from 2:11. The file was converted from DHIS1.4
 
 Busoye
 
 
 On 28 Aug 2013, at 15:15, Juan Manuel Alcantara Acosta 
 jmalcanta...@gmail.com wrote:
 
 Did you upgrade from 2.11 to 2.12?
 JM
 
 El 28/08/2013, a las 05:42, Adebusoye Anifalaje bus...@hisp.org escribió:
 
 Dear all,
 
 We receive an error message when trying to add a validation rule to a 
 group. 
 
 I noticed that during start up, there is an error message:
 
 * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table 
 validationrulegroupmembers add constraint 
 fk_validationrulegroupmembers_validatio
 nrulegroupid foreign key (validationgroupid) references validationrulegroup 
 (SchemaUpdate.java [pool-2-thread-1])
 * ERROR 2013-08-28 12:24:32,468 ERROR: constraint 
 fk_validationrulegroupmembers_validationrulegroupid for relation 
 validationrulegroupmembers already exists (SchemaUpdate.java 
 [pool-2-thread-1])
 
 
 The error message during the operation is:
 
 * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column 
 validationgroupid violates not-null constraint
 Detail: Failing row contains (null, null, null, null, null, palidusime, , 
 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5])
 * ERROR 2013-08-28 12:25:53,531 Error while executing action 
 (ExceptionInterceptor.java [http-apr-8080-exec-5])
 org.springframework.dao.DataIntegrityViolationException: could not execute 
 statement; SQL [n/a]; constraint [validationgroupid]; nested exception is 
 org.hibernate.exception.ConstraintViolationException: could not execute 
 statement
 
 Caused by: org.postgresql.util.PSQLException: ERROR: null value in column 
 validationgroupid violates not-null constraint
 Detail: Failing row contains (null, null, null, null, null, palidusime, , 
 2562).
 
 I am using DHIS2.12 build 11290
 
 
 Does anyone know what's happening here?
 
 Thanks
 
 Busoye
 
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : 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
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Patientdatavalue - value field is short

2013-04-29 Thread Juan Manuel Alcantara Acosta 
Such a fielt could be used to create an event with a SOAP structure.
JM

El 29/04/2013, a las 14:42, Rodolfo Melia rme...@knowming.com escribió:

 We are looking for a field at the encounter time - we wanted to create a 
 massive entry space using a custom form, so the doctor/nurse can write 
 whatever she/he wants, and limit structured information to 5-8 fields using 
 option sets.
 
 
 On Mon, Apr 29, 2013 at 8:34 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote:
 Hi Marko and Rodolfo,
 
 We have a comment field available for the programinstance object. This is for 
 general comments about a person in a program, a bit like a whiteboard that 
 you can always see on top of the data entry form in Person Dashboard. This 
 field is also limited to 255 characters, but we can extend it. We have a 
 patientcomment object that is referenced in programinstance.
 
 Would this meet your needs or you need to have a comment per program stage 
 instance (encounter/visit)?
 
 I guess we could link to a patientcomment from programstageinstance as well, 
 and this way make comments available per stage instance? 
 
 Ola
 
 
 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo
 
 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
 
 
 On 29 April 2013 21:02, Rodolfo Melia rme...@knowming.com wrote:
 Hi - just to echo on Marko's comment: PSI is also considering the use of a 
 large, free text field, for doctor/ nurse to write free text observations 
 that we don't need to quantify, but we want to capture, so DHIS can work as a 
 light electronic health record. We will try Knut's suggestion on the mean 
 time.
 
 
 On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland larshe...@gmail.com 
 wrote:
 Hi Marko,
 
 we could consider it - the only problem is that we have chosen the approach 
 of using one column for all types of values. Most values are short numbers 
 and using text as column type over varchar with fixed length implies a 
 performance penalty. I am not sure how significant that overhead is with 
 latest versions of postgresql/mysql. We could check it out. I guess you could 
 do like Knut suggests for now and change the column type manually.
 
 cheers
 
 Lars
 
 
 
 On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia markodavi...@gmail.com 
 wrote:
 Hi friends, in the table patientdatavalue the field value is varchar(255).
 
 Is possible change this field to a bigger type?
 
 We need insert long descriptions in this field.
 
 Thank you very much.
 
 -- 
 Cordialmente,
 
 
 Ing. Marko David Garcia M.
 Área de Sistemas integrados de Información
 Secretaría de Salud Departamental del Cauca
 
 
 
 ___
 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
 
 
 
 ___
 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
 
 
 
 
 -- 
 Rodolfo Meliá
 Principal
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 
 Note: Please note my new email address, which I will be using for PSI related 
 work: rme...@knowming.com
 
 ___
 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
 
 
 
 
 
 -- 
 Rodolfo Meliá
 Principal
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 
 Note: Please note my new email address, which I will be using for PSI related 
 work: rme...@knowming.com
 ___
 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

___
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] DXF Detailed Metadata Export...

2013-04-08 Thread Juan Manuel Alcantara Acosta 
Hello Everyone
I also tested the metadata export/import and the import consistently fails. The 
best result I was able to get only created part of the data elements and data 
sets.
JM



El 08/04/2013, a las 16:43, Rodolfo Melia rme...@knowming.com escribió:

 Ola - I just tried, but unfortunately I only get the Data Element names, 
 nothing else.
 Is there a switch to get all the properties of the object?
 
 dataElements
 dataElement name=KE - Microlut created=2012-12-11T00:00:00.000+ 
 lastUpdated=2013-03-04T15:55:29.351+href=http://dev.psi-mis.org/api/dataElements/vV5rUtTs2gK;
  id=vV5rUtTs2gK/
 dataElement name=KE - IUCD insertions [Target] 
 created=2013-02-05T12:12:37.937+ 
 lastUpdated=2013-03-07T09:19:22.614+ 
 href=http://dev.psi-mis.org/api/dataElements/Fdb2XIirCaI; id=Fdb2XIirCaI/
 dataElement name=KE - IUCD removals created=2013-02-05T07:35:49.543+ 
 lastUpdated=2013-03-04T15:55:29.324+href=http://dev.psi-mis.org/api/dataElements/QXaKhE3QH4v;
  id=QXaKhE3QH4v/
 dataElement name=KE - Implant insertions 
 created=2012-12-11T00:00:00.000+ 
 lastUpdated=2013-03-04T15:55:29.331+href=http://dev.psi-mis.org/api/dataElements/R6Il27oviAY;
  id=R6Il27oviAY/
 dataElement name=KE - Condoms created=2013-02-05T07:35:49.546+ 
 lastUpdated=2013-03-04T15:55:29.238+href=http://dev.psi-mis.org/api/dataElements/vxwTVldLL3v;
  id=vxwTVldLL3v/
 dataElement name=KE - Injections created=2012-12-11T00:00:00.000+ 
 lastUpdated=2013-03-04T15:55:29.344+href=http://dev.psi-mis.org/api/dataElements/Va0SNBrIArX;
  id=Va0SNBrIArX/
 dataElement name=KE - COC created=2013-02-05T07:35:49.552+ 
 lastUpdated=2013-03-04T15:55:29.231+href=http://dev.psi-mis.org/api/dataElements/lcIUdP3C4vJ;
  id=lcIUdP3C4vJ/
 dataElement name=KE - IUCD insertions 
 created=2013-02-05T07:35:49.557+ 
 lastUpdated=2013-03-04T15:55:29.276+href=http://dev.psi-mis.org/api/dataElements/Ouc8q8P7LuO;
  id=Ouc8q8P7LuO/
 dataElement name=KE - Implant removals 
 created=2012-12-11T00:00:00.000+ 
 lastUpdated=2013-03-04T15:55:29.338+href=http://dev.psi-mis.org/api/dataElements/mvdI2hF1sRI;
  id=mvdI2hF1sRI/
 /dataElements
 dataElementGroupSet/
 /dataElementGroup
 
 
 On Mon, Apr 8, 2013 at 10:27 PM, Rodolfo Melia rme...@knowming.com wrote:
 That sounds like a very good approach - I will try.
 
 
 On Mon, Apr 8, 2013 at 10:22 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote:
 Hi Rodolfo,
 
 You can also use the Web API to get an xml dump of a group of data elements 
 like this:
 http://apps.dhis2.org/demo/api/dataElementGroups/qfxEYY9xAl6.xml
 
 So you could 
 1) put all the data elements you want to move over to another instance into 
 one data element group, 
 2) use the Web-API browser: http://apps.dhis2.org/demo/api/resources , 
 3) click on html link next to DataElementGroups and then look for your group 
 and click on the XML linkto get the XML you need for your data elements. 
 4) That XML can be imported using metadata import on another instance.
 
 Lars just explained that to me today so I have not tested it yet, but it is 
 supposed to work. Lars, or others, please correct me if I am wrong.
 
 Ola
 
 
 
 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo
 
 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
 
 
 On 8 April 2013 22:34, Bob Jolliffe bobjolli...@gmail.com wrote:
 Hi Rodolfo
 
 The old metadata export used a very manually crafted parser for a language 
 called dxf 1.0 which was past its sell-by date and becoming hard to maintain.
 
 The newer metadata export uses dxf 2.0 which is a much more complete 
 reflection of the domain objects but I note it doesn't allow the selection of 
 particular dataelement groups or indicator groups.
 
 We will be working on some functionality to export the selection of all 
 metadata which might be related to a particular group of indicators, but that 
 is coming.
 
 In the meantime if there is particular filtering you want to do of the full 
 metadata dump then share on this list and I (or someone else) can probably 
 help with an xslt transform you could use which would be infinitely beter 
 than editing manually.
 
 If you are wanting to edit then there a number of approaches.  The oxygen xml 
 editor is by far the best in my view but sadly not free.  emacs (nxml mode) 
 works really well even on mac and windows but is not for everybody.  For 
 working with xml from the mac or windows shell, then libxml from 
 http://www.xmlsoft.org/ comes with the handy xmllint tool which can do lots 
 of things, but one of the most useful is to pretty print format the xml.
  
 Bob
 
 
 
 On 8 April 2013 19:20, Rodolfo Melia rme...@knowming.com wrote:
 ... is gone
 
 Hi - 2.10 as well as early development releases of 2.11 had an 'DXF Detailed 
 Metadata Export' option. This function allowed to specify what Data Elements 
 and Indicators to export.

Re: [Dhis2-users] DXF Detailed Metadata Export...

2013-04-08 Thread Juan Manuel Alcantara Acosta 
I did the export using this method and then imported to a local server and it 
all worked, exactly as expected.
Thank you,
JM


El 08/04/2013, a las 17:37, Lars Helge Øverland larshe...@gmail.com escribió:

 
 
 
 On Mon, Apr 8, 2013 at 11:18 PM, Rodolfo Melia rme...@knowming.com wrote:
 Hi Bob - thanks for your detailed explanation. Because we use naming 
 conventions, we wanted to filter on the basis of name. 'WHP - ' is the prefix 
 that we were planning to use to locate quickly what we wanted to export, and 
 just moved into the one that can be exported.
 
 We want/ need to export the following elements:
 1. Data Elements - we can certainly put them in a a group if that speed-up 
 things. This is the critical one.
 2. Category Combos, Categories and associated options. We can certainly 
 rebuild them
 3. Form with sections. That will be nice !
 
 R
 
 
 
 Hi Rodolfo,
 
 thanks for the feedback. The detailed export was removed temporarily due to 
 time pressure - we wanted to get DXF2 in for 2.12 but didn't have time to 
 re-implement detailed export. Will put it back for 2.12.
 
 In the meantime your needs can be covered through the web api like this for 
 data elements (example runs against demo, substitute ART query with WHP -):
 
 http://apps.dhis2.org/demo/api/dataElements/query/ART.xml?viewClass=detailedpaging=falselinks=false
 
 query/criteria: define your query criteria
 viewClass: ask for all details about data elements
 paging: turn off paging
 links: skip links
 
 for category combos:
 
 http://apps.dhis2.org/demo/api/categoryCombos.xml?viewClass=detailedpaging=falselinks=false
 
 for data sets and custom forms:
 
 http://apps.dhis2.org/demo/api/dataSets.xml?viewClass=detailedpaging=falselinks=false
 
 You can then import these files on the other side. 
 
 It's documented here:
 
 http://dhis2.org/doc/snapshot/en/user/html/ch25s04.html
 
 
 regards,
 
 Lars
 
 
  
 

___
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