Re: [Dhis2-users] Apk for Android apps

2015-09-07 Thread Lars Helge Øverland
Hi Nick,

sorry we will try to communicate this better. You can for now find the APK
at the github pages:

https://github.com/dhis2/dhis2-android-trackercapture/releases
https://github.com/dhis2/dhis2-android-eventcapture/releases
https://github.com/dhis2/dhis2-android-datacapture/releases


regards,

Lars


On Sun, Sep 6, 2015 at 3:35 AM, Shurajit Dutta 
wrote:

> Hi everyone.
>
> I was wondering if there was someplace I could access the apk files for
> the android apps?
>
> I will be going to Myanmar where a number of the devices do not have
> google play pre installed, and would like to do a little testing while
> there.
>
> Thanks
> Nick
>
> ___
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.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


Re: [Dhis2-users] Data Loss

2015-09-07 Thread gerald thomas
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  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 | 

Re: [Dhis2-users] Apk for Android apps

2015-09-07 Thread Shurajit Dutta
No problem Lars. Thanks for this info very helpful!
On Sep 7, 2015 3:29 PM, "Lars Helge Øverland"  wrote:

> Hi Nick,
>
> sorry we will try to communicate this better. You can for now find the APK
> at the github pages:
>
> https://github.com/dhis2/dhis2-android-trackercapture/releases
> https://github.com/dhis2/dhis2-android-eventcapture/releases
> https://github.com/dhis2/dhis2-android-datacapture/releases
>
>
> regards,
>
> Lars
>
>
> On Sun, Sep 6, 2015 at 3:35 AM, Shurajit Dutta 
> wrote:
>
>> Hi everyone.
>>
>> I was wondering if there was someplace I could access the apk files for
>> the android apps?
>>
>> I will be going to Myanmar where a number of the devices do not have
>> google play pre installed, and would like to do a little testing while
>> there.
>>
>> Thanks
>> Nick
>>
>> ___
>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.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


Re: [Dhis2-users] [Dhis2-devs] Can tracker aggregation function aggregate the tracked data on specified period

2015-09-07 Thread Uddin Fatema
Hi Chuong,

Step of aggregation rule to aggregate the tracked data is bellow.
1. Create  data element for legacy aggregated data.
2. Create dataset and here you can assign the time period, Do you want  to
aggregate your tracked data  monthly, quarterly or yearly?
3. Assign dataset in organization unite
4. Now go to Program/ attribute module-> Aggregation query builder->Add new
5. Now synchronize your tracked data with aggregated data set.
 After completed your query creation
6. Apps-> Individual record ->Manual Aggregation-> select your aggregated
dataset and select organization unite -> select period and click on
aggregate and save

7. You can see your data in Apps-> data entry-> select organization unite->
select dataset and period.

Tracked data will aggregated as per your requirements.

Thanks

Fatema


On Fri, Sep 4, 2015 at 11:22 AM, Thái Chương 
wrote:

> Hi all,
> I have an issue on implementing DHIS2 with legacy tracked entities data.
> My data tracked the entity on Aug 2nd 2014, means over a year.
>
> I'm going to build an aggregation rule to aggregate the tracked data for
> other level of data use. But could not see the option to specify the time
> period which match to my events data imported.
>
> Is there any way to work in my case?
>
> Thank you very much and best regards,
>
> --
> THAI Chuong
> YM/Skype : thaichuong159
> Phone: (+84) 918776134
>
> ___
> 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
>
>


-- 
Regards,
*Fatema Uddin*

Technical Advisor (HIS)-Support to the Health Sector Program II
Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
German House
House 10/A-2, Road 90
Gulshan 2, Dhaka 1212, Bangladesh

T  +880 9666701000
F  +880 28823099
M +880 19 6206 4721
I   www.giz.de

___
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
Hello Gerald
Have you checked the sharing settings of those data elements? Ir your users are 
not allowed to use those data elements the system will allow the data entry 
storing the information offline.
Regards,
JM

El 07/09/2015, a las 02:51, gerald thomas  escribió:

> 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  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  

Re: [Dhis2-users] Data Loss

2015-09-07 Thread gerald thomas
Dear All,
Any help with reference to the information i had provided? Please help
me with ever necessary so that we could fixed this issue.

Ola & Knut,
If i want to remove all limitations (minimum and maximum) per data
elements; what the procedures?
Secondly, how can i disable dataset locked permanently? Because even
when we unlock dataset; it is still saying dataset is lock.

Thanks in advance for your cooperation.

On 9/7/15, gerald thomas  wrote:
> 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  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 |