Re: [Dhis2-users] Data Loss

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,

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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 &

Re: [Dhis2-users] Data Loss

Hi Gerald Did you check that there is not data missing for Oct, Nov, Dec 2014 for the same districts? I think we had a suspicion some time back that there was maybe a problem with the client PC date settings. So they thought they were entering for Oct 2014 but in fact it was Oct 2015. Hence it

Re: [Dhis2-users] Data Loss

Dear Bob, It is good to here from you once more. We had tried that the last time but the situation is still the same. We had investigated the time of those data entry clerks' PCs and some of them had no issue with their time but it keeps happening. How can we stop it or fix the issue? On

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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:

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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 jmalcanta...@gmail.com wrote: Hello Gerald What was the result of the datavalue query? You should also check the sharing

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

Hi Gerald, Could you please just clarify what exactly your question is? 1. You have provided a list from you period table. When data is captured or imported into DHIS2 and a period does not exist, then an entry is created in the period table. The period table does not contain data, only periods

Re: [Dhis2-users] Data Loss

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

Re: [Dhis2-users] Data Loss

I think it is the same problem I faced previously and I would like to share my experience. What I found was that the aggregation level of each data element was higher the organization unit level of data entry. So we chose the lowest organization unit level at aggregation level of each data