Dear Juan,
Furthermore, for another district "Bonthe" with organisation units
(Bendu Cha, BMC, Bum
Dema, Imperi, Jong, Kpanda Kemoh, Kwamabai Krim, Nongoba Bullum,
Sittia, Sogbini, Yawbeko)
From the query again,
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'))
hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit WHERE uid in
('WBbZ4IsR4fJ','KuGGNmQRNRG','ZNSxAuPYkmc','bAfHAdToWpH','JGXzvo6cui0','qgKbTso4uxs','BwLuMFCgNXY','gbBGavOWAOJ','pxCSw2YnJkG','eqvAT82OSZK','Rftqk5lhju2','bSeyZOqAPAo'))
hmis-# GROUP BY period.startdate, period.enddate,
organisationunit.name, datavalue.sourceid;
startdate | enddate | name | count
------------+------------+------+-------
2013-11-01 | 2013-11-30 | BMC | 6
(1 row)
Please help me; i need to know why this is happening. As you can see
we had been loosing data for quit awhile now on those data elements.
On 9/7/15, gerald thomas <gerald17006@gmail.com> wrote:
Dear Juan,
Sorry about the time lapse for this subject but i am currently in the
field trying to understand why we are having the data loss. One of our
district "Pujehun" is currently facing this issue. The data entry
clerk said he had successfully entered information for 2 months:
January & February and partially for March 2015 for one of his
organisation unit "Barri" which has the following sub organisation
units ( Bandasuma CHC, Konia MCHP, Njaluahun CHP, Potoru CHC, Saahun
(barri) MCHP, Tambeyama MCHP, Taninahun MCHP, Vaama MCHP, Waiima
MCHP). Barri and its sub-organisation unit have information for
February and March 2015 as per the following data elements: suspected
malaria; total head counts all services, etc but not January 2015.
Using the query you gave me the last time i discovered the following:
SELECT period.startdate, period.enddate, organisationunit.name,
count(datavalue.sourceid) FROM datavalue, period, organisationunit
WHERE datavalue.periodid = period.periodid AND datavalue.sourceid =
organisationunit.organisationunitid
AND datavalue.dataelementid IN (SELECT dataelementid FROM dataelement
WHERE uid IN
('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit WHERE uid in
('TTcxkf1OGPx','BCnDvAuxUou','r6XG4nxlNxn','BKIrj3yjYJT','bqquAB6z7lS','xZGdhrCZjTn','hOQQ0w4iYio','qHuVAR7RvCa','qHuVAR7RvCa'))
GROUP BY period.startdate, period.enddate, organisationunit.name,
datavalue.sourceid;
startdate | enddate | name | count
------------+------------+---------------------+-------
2014-09-01 | 2014-09-30 | Tambeyama MCHP | 19
2013-02-01 | 2013-02-28 | Konia MCHP | 19
2011-07-01 | 2011-07-31 | Njaluahun CHP | 22
2013-10-01 | 2013-10-31 | Bandasuma CHC | 33
2014-11-01 | 2014-11-30 | Tambeyama MCHP | 20
2011-05-01 | 2011-05-31 | Taninahun MCHP | 21
2011-11-01 | 2011-11-30 | Potoru CHC | 24
2014-01-01 | 2014-01-31 | Saahun (barri) MCHP | 12
2012-09-01 | 2012-09-30 | Bandasuma CHC | 26
2011-08-01 | 2011-08-31 | Konia MCHP | 20
2012-08-01 | 2012-08-31 | Njaluahun CHP | 21
2013-01-01 | 2013-01-31 | Saahun (barri) MCHP | 5
2011-05-01 | 2011-05-31 | Tambeyama MCHP | 14
2014-11-01 | 2014-11-30 | Taninahun MCHP | 28
2013-12-01 | 2013-12-31 | Konia MCHP | 22
2014-09-01 | 2014-09-30 | Taninahun MCHP | 28
2015-02-01 | 2015-02-28 | Saahun (barri) MCHP | 22
2013-05-01 | 2013-05-31 | Taninahun MCHP | 20
2012-10-01 | 2012-10-31 | Potoru CHC | 26
2012-03-01 | 2012-03-31 | Bandasuma CHC | 22
2011-04-01 | 2011-04-30 | Tambeyama MCHP | 13
2012-05-01 | 2012-05-31 | Tambeyama MCHP | 20
2014-08-01 | 2014-08-31 | Tambeyama MCHP | 20
2013-07-01 | 2013-07-31 | Bandasuma CHC | 10
2013-02-01 | 2013-02-28 | Vaama MCHP | 20
2015-03-01 | 2015-03-31 | Taninahun MCHP | 33
2014-07-01 | 2014-07-31 | Bandasuma CHC | 28
2014-05-01 | 2014-05-31 | Bandasuma CHC | 33
2012-07-01 | 2012-07-31 | Tambeyama MCHP | 20
2011-12-01 | 2011-12-31 | Potoru CHC | 25
2013-04-01 | 2013-04-30 | Bandasuma CHC | 22
2012-04-01 | 2012-04-30 | Taninahun MCHP | 26
2014-02-01 | 2014-02-28 | Bandasuma CHC | 30
2012-07-01 | 2012-07-31 | Taninahun MCHP | 23
2014-04-01 | 2014-04-30 | Saahun (barri) MCHP | 22
2012-04-01 | 2012-04-30 | Tambeyama MCHP | 13
2011-06-01 | 2011-06-30 | Njaluahun CHP | 22
2013-12-01 | 2013-12-31 | Vaama MCHP | 28
2014-10-01 | 2014-10-31 | Potoru CHC | 38
2015-03-01 | 2015-03-31 | Tambeyama MCHP | 21
2012-06-01 | 2012-06-30 | Potoru CHC | 24
2011-08-01 | 2011-08-31 | Vaama MCHP | 25
2012-05-01 | 2012-05-31 | Taninahun MCHP | 24
2014-08-01 | 2014-08-31 | Taninahun MCHP | 28
2012-12-01 | 2012-12-31 | Potoru CHC | 25
2013-03-01 | 2013-03-31 | Saahun (barri) MCHP | 5
2011-04-01 | 2011-04-30 | Taninahun MCHP | 16
2013-09-01 | 2013-09-30 | Saahun (barri) MCHP | 16
2013-05-01 | 2013-05-31 | Tambeyama MCHP | 18
2014-10-01 | 2014-10-31 | Konia MCHP | 18
2012-02-01 | 2012-02-29 | Njaluahun CHP | 25
2012-01-01 | 2012-01-31 | Njaluahun CHP | 21
2012-03-01 | 2012-03-31 | Saahun (barri) MCHP | 6
2013-11-01 | 2013-11-30 | Tambeyama MCHP | 20
2011-09-01 | 2011-09-30 | Taninahun MCHP | 22
2012-06-01 | 2012-06-30 | Konia MCHP | 22
2011-10-01 | 2011-10-31 | Njaluahun CHP | 17
2013-07-01 | 2013-07-31 | Saahun (barri) MCHP | 4
2012-12-01 | 2012-12-31 | Konia MCHP | 20
2014-05-01 | 2014-05-31 | Saahun (barri) MCHP | 23
2014-02-01 | 2014-02-28 | Saahun (barri) MCHP | 14
2013-04-01 | 2013-04-30 | Saahun (barri) MCHP | 4
2014-07-01 | 2014-07-31 | Saahun (barri) MCHP | 22
2014-12-01 | 2014-12-31 | Njaluahun CHP | 31
2011-11-01 | 2011-11-30 | Vaama MCHP | 22
2014-04-01 | 2014-04-30 | Bandasuma CHC | 31
2012-10-01 | 2012-10-31 | Konia MCHP | 20
2011-09-01 | 2011-09-30 | Tambeyama MCHP | 19
2013-03-01 | 2013-03-31 | Bandasuma CHC | 24
2014-06-01 | 2014-06-30 | Njaluahun CHP | 31
2013-09-01 | 2013-09-30 | Bandasuma CHC | 29
2013-11-01 | 2013-11-30 | Taninahun MCHP | 29
2011-12-01 | 2011-12-31 | Konia MCHP | 17
2013-10-01 | 2013-10-31 | Saahun (barri) MCHP | 19
2013-06-01 | 2013-06-30 | Tambeyama MCHP | 21
2011-08-01 | 2011-08-31 | Potoru CHC | 24
2012-12-01 | 2012-12-31 | Vaama MCHP | 24
2012-11-01 | 2012-11-30 | Tambeyama MCHP | 18
2012-06-01 | 2012-06-30 | Vaama MCHP | 23
2014-10-01 | 2014-10-31 | Vaama MCHP | 32
2013-12-01 | 2013-12-31 | Potoru CHC | 34
2015-01-01 | 2015-01-31 | Potoru CHC | 8
2014-03-01 | 2014-03-31 | Njaluahun CHP | 34
2014-01-01 | 2014-01-31 | Bandasuma CHC | 33
2011-12-01 | 2011-12-31 | Vaama MCHP | 24
2013-02-01 | 2013-02-28 | Potoru CHC | 24
2013-01-01 | 2013-01-31 | Bandasuma CHC | 24
2012-09-01 | 2012-09-30 | Saahun (barri) MCHP | 5
2012-11-01 | 2012-11-30 | Taninahun MCHP | 25
2011-11-01 | 2011-11-30 | Konia MCHP | 22
2013-06-01 | 2013-06-30 | Taninahun MCHP | 22
2015-02-01 | 2015-02-28 | Bandasuma CHC | 23
2012-10-01 | 2012-10-31 | Vaama MCHP | 25
2012-08-01 | 2012-08-31 | Vaama MCHP | 25
2014-01-01 | 2014-01-31 | Tambeyama MCHP | 14
2013-01-01 | 2013-01-31 | Tambeyama MCHP | 15
2011-05-01 | 2011-05-31 | Saahun (barri) MCHP | 19
2012-02-01 | 2012-02-29 | Potoru CHC | 24
2012-01-01 | 2012-01-31 | Potoru CHC | 24
2011-06-01 | 2011-06-30 | Konia MCHP | 6
2011-10-01 | 2011-10-31 | Potoru CHC | 25
2015-02-01 | 2015-02-28 | Tambeyama MCHP | 16
2014-09-01 | 2014-09-30 | Saahun (barri) MCHP | 16
2014-06-01 | 2014-06-30 | Potoru CHC | 34
2015-02-01 | 2015-02-28 | Taninahun MCHP | 24
2013-06-01 | 2013-06-30 | Bandasuma CHC | 22
2011-07-01 | 2011-07-31 | Vaama MCHP | 25
2014-11-01 | 2014-11-30 | Saahun (barri) MCHP | 21
2014-12-01 | 2014-12-31 | Potoru CHC | 24
2013-01-01 | 2013-01-31 | Taninahun MCHP | 18
2012-11-01 | 2012-11-30 | Bandasuma CHC | 24
2014-01-01 | 2014-01-31 | Taninahun MCHP | 27
2014-04-01 | 2014-04-30 | Tambeyama MCHP | 19
2012-04-01 | 2012-04-30 | Saahun (barri) MCHP | 4
2015-03-01 | 2015-03-31 | Saahun (barri) MCHP | 19
2013-12-01 | 2013-12-31 | Njaluahun CHP | 24
2014-03-01 | 2014-03-31 | Potoru CHC | 46
2011-06-01 | 2011-06-30 | Vaama MCHP | 26
2011-09-01 | 2011-09-30 | Bandasuma CHC | 26
2013-03-01 | 2013-03-31 | Tambeyama MCHP | 21
2013-09-01 | 2013-09-30 | Tambeyama MCHP | 6
2012-08-01 | 2012-08-31 | Konia MCHP | 20
2013-05-01 | 2013-05-31 | Saahun (barri) MCHP | 6
2011-08-01 | 2011-08-31 | Njaluahun CHP | 23
2013-03-01 | 2013-03-31 | Taninahun MCHP | 22
2013-09-01 | 2013-09-30 | Taninahun MCHP | 34
2011-04-01 | 2011-04-30 | Saahun (barri) MCHP | 10
2012-05-01 | 2012-05-31 | Saahun (barri) MCHP | 16
2013-11-01 | 2013-11-30 | Bandasuma CHC | 33
2014-08-01 | 2014-08-31 | Saahun (barri) MCHP | 21
2011-07-01 | 2011-07-31 | Konia MCHP | 15
2013-02-01 | 2013-02-28 | Njaluahun CHP | 18
2012-07-01 | 2012-07-31 | Saahun (barri) MCHP | 5
2014-04-01 | 2014-04-30 | Taninahun MCHP | 22
2015-03-01 | 2015-03-31 | Bandasuma CHC | 30
2014-07-01 | 2014-07-31 | Taninahun MCHP | 29
2014-05-01 | 2014-05-31 | Taninahun MCHP | 33
2013-04-01 | 2013-04-30 | Taninahun MCHP | 16
2012-04-01 | 2012-04-30 | Bandasuma CHC | 24
2014-02-01 | 2014-02-28 | Taninahun MCHP | 21
2014-12-01 | 2014-12-31 | Vaama MCHP | 36
2011-11-01 | 2011-11-30 | Njaluahun CHP | 18
2013-07-01 | 2013-07-31 | Taninahun MCHP | 22
2011-09-01 | 2011-09-30 | Saahun (barri) MCHP | 6
2011-07-01 | 2011-07-31 | Potoru CHC | 23
2013-05-01 | 2013-05-31 | Bandasuma CHC | 24
2012-03-01 | 2012-03-31 | Taninahun MCHP | 28
2014-06-01 | 2014-06-30 | Vaama MCHP | 34
2011-10-01 | 2011-10-31 | Vaama MCHP | 21
2012-03-01 | 2012-03-31 | Tambeyama MCHP | 14
2012-05-01 | 2012-05-31 | Bandasuma CHC | 23
2013-11-01 | 2013-11-30 | Saahun (barri) MCHP | 12
2014-08-01 | 2014-08-31 | Bandasuma CHC | 26
2012-02-01 | 2012-02-29 | Vaama MCHP | 23
2012-01-01 | 2012-01-31 | Vaama MCHP | 24
2014-03-01 | 2014-03-31 | Konia MCHP | 22
2011-04-01 | 2011-04-30 | Bandasuma CHC | 26
2013-07-01 | 2013-07-31 | Tambeyama MCHP | 19
2012-07-01 | 2012-07-31 | Bandasuma CHC | 8
2014-05-01 | 2014-05-31 | Tambeyama MCHP | 21
2014-02-01 | 2014-02-28 | Tambeyama MCHP | 21
2013-04-01 | 2013-04-30 | Tambeyama MCHP | 20
2012-08-01 | 2012-08-31 | Potoru CHC | 26
2014-07-01 | 2014-07-31 | Tambeyama MCHP | 18
2014-06-01 | 2014-06-30 | Konia MCHP | 16
2011-05-01 | 2011-05-31 | Bandasuma CHC | 26
2012-09-01 | 2012-09-30 | Tambeyama MCHP | 19
2011-12-01 | 2011-12-31 | Njaluahun CHP | 17
2012-10-01 | 2012-10-31 | Njaluahun CHP | 22
2014-12-01 | 2014-12-31 | Konia MCHP | 18
2013-10-01 | 2013-10-31 | Taninahun MCHP | 26
2013-10-01 | 2013-10-31 | Tambeyama MCHP | 13
2012-12-01 | 2012-12-31 | Njaluahun CHP | 17
2014-09-01 | 2014-09-30 | Bandasuma CHC | 30
2013-06-01 | 2013-06-30 | Saahun (barri) MCHP | 5
2014-11-01 | 2014-11-30 | Bandasuma CHC | 28
2012-09-01 | 2012-09-30 | Taninahun MCHP | 26
2012-11-01 | 2012-11-30 | Saahun (barri) MCHP | 18
2011-06-01 | 2011-06-30 | Potoru CHC | 12
2014-03-01 | 2014-03-31 | Vaama MCHP | 31
2014-10-01 | 2014-10-31 | Njaluahun CHP | 31
2012-02-01 | 2012-02-29 | Konia MCHP | 21
2012-01-01 | 2012-01-31 | Konia MCHP | 22
2012-06-01 | 2012-06-30 | Njaluahun CHP | 23
2011-10-01 | 2011-10-31 | Konia MCHP | 19
2014-09-01 | 2014-09-30 | Njaluahun CHP | 22
2011-07-01 | 2011-07-31 | Tambeyama MCHP | 17
2012-12-01 | 2012-12-31 | Bandasuma CHC | 25
2014-11-01 | 2014-11-30 | Njaluahun CHP | 31
2014-10-01 | 2014-10-31 | Bandasuma CHC | 29
2012-08-01 | 2012-08-31 | Taninahun MCHP | 24
2012-06-01 | 2012-06-30 | Bandasuma CHC | 26
2013-09-01 | 2013-09-30 | Konia MCHP | 16
2013-07-01 | 2013-07-31 | Potoru CHC | 22
2013-01-01 | 2013-01-31 | Vaama MCHP | 22
2013-03-01 | 2013-03-31 | Konia MCHP | 13
2014-05-01 | 2014-05-31 | Potoru CHC | 35
2014-01-01 | 2014-01-31 | Vaama MCHP | 34
2013-04-01 | 2013-04-30 | Potoru CHC | 24
2014-02-01 | 2014-02-28 | Potoru CHC | 33
2011-12-01 | 2011-12-31 | Bandasuma CHC | 26
2012-08-01 | 2012-08-31 | Tambeyama MCHP | 21
2011-05-01 | 2011-05-31 | Njaluahun CHP | 18
2014-07-01 | 2014-07-31 | Potoru CHC | 36
2012-03-01 | 2012-03-31 | Potoru CHC | 28
2015-02-01 | 2015-02-28 | Vaama MCHP | 33
2012-10-01 | 2012-10-31 | Bandasuma CHC | 26
2014-04-01 | 2014-04-30 | Konia MCHP | 20
2011-07-01 | 2011-07-31 | Taninahun MCHP | 24
2011-04-01 | 2011-04-30 | Njaluahun CHP | 15
2012-05-01 | 2012-05-31 | Njaluahun CHP | 23
2014-08-01 | 2014-08-31 | Njaluahun CHP | 22
2013-02-01 | 2013-02-28 | Saahun (barri) MCHP | 5
2012-07-01 | 2012-07-31 | Njaluahun CHP | 21
2012-09-01 | 2012-09-30 | Potoru CHC | 26
2011-06-01 | 2011-06-30 | Taninahun MCHP | 21
2011-06-01 | 2011-06-30 | Tambeyama MCHP | 20
2012-04-01 | 2012-04-30 | Njaluahun CHP | 21
2015-03-01 | 2015-03-31 | Njaluahun CHP | 31
2013-12-01 | 2013-12-31 | Saahun (barri) MCHP | 10
2015-02-01 | 2015-02-28 | Konia MCHP | 19
2011-11-01 | 2011-11-30 | Bandasuma CHC | 26
2014-04-01 | 2014-04-30 | Vaama MCHP | 30
2014-01-01 | 2014-01-31 | Konia MCHP | 22
2013-10-01 | 2013-10-31 | Potoru CHC | 34
2013-03-01 | 2013-03-31 | Vaama MCHP | 22
2013-09-01 | 2013-09-30 | Vaama MCHP | 31
2013-01-01 | 2013-01-31 | Konia MCHP | 22
2011-08-01 | 2011-08-31 | Saahun (barri) MCHP | 5
2013-05-01 | 2013-05-31 | Njaluahun CHP | 21
2012-01-01 | 2012-01-31 | Tambeyama MCHP | 20
2012-02-01 | 2012-02-29 | Tambeyama MCHP | 16
2013-11-01 | 2013-11-30 | Njaluahun CHP | 35
2015-02-01 | 2015-02-28 | Potoru CHC | 34
2012-03-01 | 2012-03-31 | Vaama MCHP | 23
2014-06-01 | 2014-06-30 | Taninahun MCHP | 28
2011-10-01 | 2011-10-31 | Tambeyama MCHP | 22
2013-02-01 | 2013-02-28 | Bandasuma CHC | 24
2014-07-01 | 2014-07-31 | Vaama MCHP | 32
2014-05-01 | 2014-05-31 | Vaama MCHP | 38
2014-01-01 | 2014-01-31 | Potoru CHC | 42
2013-04-01 | 2013-04-30 | Vaama MCHP | 23
2013-10-01 | 2013-10-31 | Konia MCHP | 22
2014-02-01 | 2014-02-28 | Vaama MCHP | 28
2014-12-01 | 2014-12-31 | Taninahun MCHP | 30
2013-01-01 | 2013-01-31 | Potoru CHC | 24
2013-07-01 | 2013-07-31 | Vaama MCHP | 22
2014-12-01 | 2014-12-31 | Tambeyama MCHP | 17
2013-12-01 | 2013-12-31 | Bandasuma CHC | 33
2011-11-01 | 2011-11-30 | Saahun (barri) MCHP | 5
2011-09-01 | 2011-09-30 | Njaluahun CHP | 21
2011-10-01 | 2011-10-31 | Taninahun MCHP | 17
2014-06-01 | 2014-06-30 | Tambeyama MCHP | 22
2011-08-01 | 2011-08-31 | Bandasuma CHC | 26
2012-09-01 | 2012-09-30 | Konia MCHP | 21
2012-02-01 | 2012-02-29 | Taninahun MCHP | 28
2012-01-01 | 2012-01-31 | Taninahun MCHP | 20
2012-12-01 | 2012-12-31 | Saahun (barri) MCHP | 4
2013-09-01 | 2013-09-30 | Potoru CHC | 38
2013-06-01 | 2013-06-30 | Njaluahun CHP | 22
2013-07-01 | 2013-07-31 | Konia MCHP | 22
2013-03-01 | 2013-03-31 | Potoru CHC | 22
2014-07-01 | 2014-07-31 | Konia MCHP | 20
2014-05-01 | 2014-05-31 | Konia MCHP | 20
2013-04-01 | 2013-04-30 | Konia MCHP | 22
2013-10-01 | 2013-10-31 | Vaama MCHP | 36
2014-02-01 | 2014-02-28 | Konia MCHP | 18
2012-11-01 | 2012-11-30 | Njaluahun CHP | 22
2014-04-01 | 2014-04-30 | Potoru CHC | 38
2014-10-01 | 2014-10-31 | Saahun (barri) MCHP | 22
2012-03-01 | 2012-03-31 | Konia MCHP | 20
2012-06-01 | 2012-06-30 | Saahun (barri) MCHP | 6
2014-03-01 | 2014-03-31 | Tambeyama MCHP | 19
2012-09-01 | 2012-09-30 | Vaama MCHP | 27
2014-03-01 | 2014-03-31 | Taninahun MCHP | 22
2011-12-01 | 2011-12-31 | Saahun (barri) MCHP | 6
2012-10-01 | 2012-10-31 | Saahun (barri) MCHP | 22
2011-05-01 | 2011-05-31 | Vaama MCHP | 26
2014-01-01 | 2014-01-31 | Njaluahun CHP | 29
2013-05-01 | 2013-05-31 | Konia MCHP | 22
2012-08-01 | 2012-08-31 | Saahun (barri) MCHP | 19
2013-01-01 | 2013-01-31 | Njaluahun CHP | 21
2015-03-01 | 2015-03-31 | Konia MCHP | 16
2012-04-01 | 2012-04-30 | Konia MCHP | 21
2013-11-01 | 2013-11-30 | Potoru CHC | 34
2015-02-01 | 2015-02-28 | Njaluahun CHP | 30
2014-11-01 | 2014-11-30 | Vaama MCHP | 33
2011-09-01 | 2011-09-30 | Potoru CHC | 22
2011-07-01 | 2011-07-31 | Saahun (barri) MCHP | 6
2012-07-01 | 2012-07-31 | Konia MCHP | 22
2014-09-01 | 2014-09-30 | Vaama MCHP | 33
2012-05-01 | 2012-05-31 | Konia MCHP | 22
2014-08-01 | 2014-08-31 | Konia MCHP | 16
2014-03-01 | 2014-03-31 | Bandasuma CHC | 33
2011-04-01 | 2011-04-30 | Konia MCHP | 22
2011-06-01 | 2011-06-30 | Saahun (barri) MCHP | 15
2012-11-01 | 2012-11-30 | Potoru CHC | 25
2014-04-01 | 2014-04-30 | Njaluahun CHP | 29
2014-12-01 | 2014-12-31 | Bandasuma CHC | 27
2013-12-01 | 2013-12-31 | Tambeyama MCHP | 15
2013-02-01 | 2013-02-28 | Taninahun MCHP | 20
2015-03-01 | 2015-03-31 | Vaama MCHP | 30
2012-04-01 | 2012-04-30 | Vaama MCHP | 24
2013-05-01 | 2013-05-31 | Vaama MCHP | 22
2013-09-01 | 2013-09-30 | Njaluahun CHP | 30
2013-06-01 | 2013-06-30 | Potoru CHC | 22
2013-03-01 | 2013-03-31 | Njaluahun CHP | 16
2014-06-01 | 2014-06-30 | Bandasuma CHC | 31
2011-05-01 | 2011-05-31 | Konia MCHP | 15
2011-08-01 | 2011-08-31 | Tambeyama MCHP | 20
2012-05-01 | 2012-05-31 | Vaama MCHP | 23
2011-08-01 | 2011-08-31 | Taninahun MCHP | 20
2014-08-01 | 2014-08-31 | Vaama MCHP | 16
2012-02-01 | 2012-02-29 | Bandasuma CHC | 26
2012-01-01 | 2012-01-31 | Bandasuma CHC | 26
2011-04-01 | 2011-04-30 | Vaama MCHP | 23
2011-10-01 | 2011-10-31 | Bandasuma CHC | 25
2012-07-01 | 2012-07-31 | Vaama MCHP | 24
2013-12-01 | 2013-12-31 | Taninahun MCHP | 28
2014-09-01 | 2014-09-30 | Konia MCHP | 18
2013-02-01 | 2013-02-28 | Tambeyama MCHP | 21
2014-11-01 | 2014-11-30 | Konia MCHP | 18
2014-12-01 | 2014-12-31 | Saahun (barri) MCHP | 22
2011-06-01 | 2011-06-30 | Bandasuma CHC | 26
2011-11-01 | 2011-11-30 | Tambeyama MCHP | 10
2014-09-01 | 2014-09-30 | Potoru CHC | 36
2014-06-01 | 2014-06-30 | Saahun (barri) MCHP | 22
2011-09-01 | 2011-09-30 | Vaama MCHP | 24
2014-11-01 | 2014-11-30 | Potoru CHC | 36
2012-01-01 | 2012-01-31 | Saahun (barri) MCHP | 3
2012-02-01 | 2012-02-29 | Saahun (barri) MCHP | 5
2012-03-01 | 2012-03-31 | Njaluahun CHP | 21
2013-11-01 | 2013-11-30 | Vaama MCHP | 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 <jmalcantara1@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 <gerald17006@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 <gerald17006@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'))
hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit WHERE uid in
('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
hmis-# GROUP BY period.startdate, period.enddate,
organisationunit.name, datavalue.sourceid;
startdate | enddate | name | count
-----------+---------+------+-------
(0 rows)
On 8/27/15, gerald thomas <gerald17006@gmail.com> wrote:
Dear Juan,
This means i am going to use the UIDs (those that are loosing data)
in
both part of the query?
Please confirm!!
On 8/27/15, Juan Manuel Alcantara Acosta <jmalcantara1@gmail.com> >>>>>>> wrote:
Hello Gerald
You have to look for the UIDs of the Org Units that are loosing the
data
and
add them just like you did for the data element UIDs, the list of
org
units
you have to replace is ('UID1','UID2','UID3')
Regards,
JM
El 27/08/2015, a las 15:32, gerald thomas <gerald17006@gmail.com> >>>>>>>> escribió:
Dear Juan,
Sorry about the typo in my previous mail.
As per query you sent:
hmis(#
('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit WHERE uid in ('UID1','UID2','UID3'))
hmis-# GROUP BY period.startdate, period.enddate,
organisationunit.name, datavalue.sourceid;
startdate | enddate | name | count
-----------+---------+------+-------
(0 rows)
Please what should i do next?
Thanks in advance for your help.
On 8/27/15, Juan Manuel Alcantara Acosta <jmalcantara1@gmail.com> >>>>>>>>> wrote:
Hello Gerald
I hope you are well.
The result of the query shows that you have data for the data
elements
in
question, now we should filter for the org units that loose the
information
and also check the periods.
Try the following query as a SQL View, just add your own UID list
for
the
org units that apparently loose the data.
SELECT period.startdate, period.enddate, organisationunit.name,
count(datavalue.sourceid) FROM datavalue, period,
organisationunit
WHERE datavalue.periodid = period.periodid AND
datavalue.sourceid
organisationunit.organisationunitid
AND datavalue.dataelementid IN (SELECT dataelementid FROM
dataelement
WHERE
uid IN
('oQstHNsrsJm','wyMiVZXcDp4','q22MFSRWNe8','CzFJu6gOT8a','M24QWMWyKhX','Ch6DcBg6c6o','H5lP3PsNGmn','IYOtI5eARlr','mZNp0D7rBas','HXTw4HhlblV','IGgo6jmjEl7','pzvrFsbY4eA','GNPQd1JagxH','T1R75oOtd58','zVH9yk8sgsG','Lx1eDpyVnnl','bTO0YHKALOJ'))
AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit
WHERE uid in ('UID1','UID2','UID3'))
GROUP BY period.startdate, period.enddate, organisationunit.name,
datavalue.sourceid;
Regards,
JM
El 27/08/2015, a las 02:12, gerald thomas <gerald17006@gmail.com> >>>>>>>>>> escribió:
Dear Juan,
Please help us we are struggling with this issue. Any update on
the
query
result I sent you?
Thanks for your usual cooperation.
Regards,
Gerald
On Aug 25, 2015 6:04 PM, "gerald thomas" <gerald17006@gmail.com> >>>>>>>>>>> wrote:
Dear Juan,
I already sent you the count result; what should i do next?
Thanks in advance for your usual cooperation.
On 8/25/15, Juan Manuel Alcantara Acosta >>>>>>>>>>> <jmalcantara1@gmail.com> >>>>>>>>>>> wrote:
Hi Gerald
I see there is a typo in the query and the closing parentheses
is
missing,
here's the correction:
SELECT COUNT(*) FROM datavalue WHERE dataelementid IN (SELECT
dataelementid FROM dataelement WHERE uid IN
('oQstHNsrsJm','wyMiVZXcDp4','q22MFSRWNe8','CzFJu6gOT8a','M24QWMWyKhX','Ch6DcBg6c6o','H5lP3PsNGmn','IYOtI5eARlr','mZNp0D7rBas','HXTw4HhlblV','IGgo6jmjEl7','pzvrFsbY4eA','GNPQd1JagxH','T1R75oOtd58','zVH9yk8sgsG','Lx1eDpyVnnl','bTO0YHKALOJ'));
This queries can also be used as SQL Views in Data
administration.
Regards,
JM
El 24/08/2015, a las 19:37, gerald thomas >>>>>>>>>>>> <gerald17006@gmail.com> >>>>>>>>>>>> escribió:
Dear Juan,
The dataelement query hanger here:
hmis=#SELECT COUNT(*) FROM datavalue WHERE dataelemendid IN
(SELECT
dataelementid FROM dataelement WHERE uid IN
('oQstHNsrsJm','wyMiVZXcDp4','q22MFSRWNe8','CzFJu6gOT8a','M24QWMWyKhX','Ch6DcBg6c6o','H5lP3PsNGmn','IYOtI5eARlr','mZNp0D7rBas','HXTw4HhlblV','IGgo6jmjEl7','pzvrFsbY4eA','GNPQd1JagxH','T1R75oOtd58','zVH9yk8sgsG','Lx1eDpyVnnl','bTO0YHKALOJ');
hmis(#
On 8/25/15, gerald thomas <gerald17006@gmail.com> wrote:
Dear Juan,
Please find the attached file showing dataelement and UIDs. I
had
already excluded the 17 dataelement which giving these
issues.
Furthermore i will like to bring to your notices that issue
only
occur
on a particular districts (Kailahun, Kenema, Koinadugu,
Western
Area).
I am currently running the dataelement query and i will
update
you
first thing in the morning
On 8/24/15, Juan Manuel Alcantara Acosta >>>>>>>>>>>>>> <jmalcantara1@gmail.com> >>>>>>>>>>>>>> wrote:
Hi Gerald
I can see the UIDs in the file you sent me. Look for the
following
strings:
SW3YgUOEbWh
ZUFq86FDx2d
eTutFs33XIs
HautHb3QIiN
fJXh2KAO50U
RuF2y6PRNFx
jpxNWRzDYCW
OYlcECL1USm
ReCEa4ZIji8
t4ds6TNqajx
Those are the UIDs.
You can use port forwarding with putty to use pgAdmin, look
at
step
7
of
the
following instructions:
https://intranet.cs.hku.hk/csintranet/contents/technical/howto/putty-portforward.jsp
If you have a standard configuration, the port you have to
forward
is
5432
and then you can connect to the database with pgAdmin to
localhost
and
the
same port.
JM
El 24/08/2015, a las 12:34, gerald thomas >>>>>>>>>>>>>>> <gerald17006@gmail.com> >>>>>>>>>>>>>>> escribió:
Dear Juan,
Kindly note i am access the server through ssh by putty and
I
am
doing
psql to database.
Please find the attached file containing some of the
dataelement
within the database. As i said before there is no UID for
them.
On 8/24/15, gerald thomas <gerald17006@gmail.com> wrote:
Dear Juan,
I did but it took me to *****api/resource. Tried to edit
URL
and
use
****api/dataelement nothing comes up.
On 8/24/15, Juan Manuel Alcantara Acosta >>>>>>>>>>>>>>>>> <jmalcantara1@gmail.com> >>>>>>>>>>>>>>>>> wrote:
Hi Gerald
Yes, you can use the following query.
SELECT * FROM dataelement;
That will return all the existing data elements. It's
very
strange
to
see
data elements without UID, this happens only when you
inject
the
data
elements into the database and the UIDs are created when
you
restart
the
system. Did you try to use the API?
JM
El 24/08/2015, a las 11:27, gerald thomas >>>>>>>>>>>>>>>>>> <gerald17006@gmail.com> >>>>>>>>>>>>>>>>>> escribió:
Dear Juan,
i can't find the UID as per your directions. I thought
it
was
automatically generated but it seem not to be the case.
Is there any query to verify the UID of these
dataelements
On 8/24/15, gerald thomas <gerald17006@gmail.com> wrote:
Dear Juan,
My server version Linux dhis 3.13.0-30-generic
#55-Ubuntu
SMP
Fri
Jul
4 21:40:53 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
DHIS2 version
Version:
2.18
Build revision:
Build date:
2015-04-04 09:34
And it is on the cloud.
On 8/24/15, Juan Manuel Alcantara Acosta >>>>>>>>>>>>>>>>>>>> <jmalcantara1@gmail.com> >>>>>>>>>>>>>>>>>>>> wrote:
Sure, here's the query. Don't forget to replace the
list
of
UIDs
with
the
corresponding text from your data elements.
SELECT COUNT(*) FROM datavalue WHERE dataelemendid IN
(SELECT
dataelementid
FROM dataelement WHERE uid IN
('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10',);
Can you tell me more about your server setup?
JM
El 24/08/2015, a las 10:04, gerald thomas >>>>>>>>>>>>>>>>>>>>> <gerald17006@gmail.com> >>>>>>>>>>>>>>>>>>>>> escribió:
Please can you send it again
Regards,
Gerald
On Aug 24, 2015 3:01 PM, "Juan Manuel Alcantara >>>>>>>>>>>>>>>>>>>>>> Acosta" >>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@gmail.com> wrote:
Is this happening too with the last query I sent you?
JM
El 24/08/2015, a las 09:54, gerald thomas >>>>>>>>>>>>>>>>>>>>>> <gerald17006@gmail.com> >>>>>>>>>>>>>>>>>>>>>> escribió:
Dear Juan,
I am still having issues with datavalue query.
Please
can
you
help
me
by checking the query again.
It is still showing "Out of memory"
On 8/24/15, gerald thomas <gerald17006@gmail.com> >>>>>>>>>>>>>>>>>>>>>>> wrote:
Dear Juan,
I am still having issues with datavalue query.
Please
can
you
help
me
by checking the query again.
It is still giving
On 8/24/15, Juan Manuel Alcantara Acosta >>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@gmail.com> >>>>>>>>>>>>>>>>>>>>>>>> wrote:
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 >>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@gmail.com> >>>>>>>>>>>>>>>>>>>>>>>>> escribió:
Dear Juan,
Please find the attached updated combo query.
On 8/24/15, gerald thomas <gerald17006@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 >>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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" >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@gmail.com> wrote:
Hello Gerald
Are you using custom forms for data
entry?
JM
El 22/08/2015, a las 15:37, gerald >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> thomas >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@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 :
ListHelp - Launchpad Help
--
Regards,
Gerald
<Combo_Query result.txt>
--
Regards,
Gerald
<categoryoptioncombon.txt>
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
<New_categoryoptioncombon.txt>
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
<dataelement;.txt>
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
--
Regards,
Gerald
