Re: [Dhis2-devs] [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,

Re: [Dhis2-devs] [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 perman

Re: [Dhis2-devs] [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

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-09-06 Thread gerald thomas
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 & Februa

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-25 Thread gerald thomas
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 8/25/15,

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-25 Thread Bob Jolliffe
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-devs] [Dhis2-users] Data Loss

2015-08-24 Thread gerald thomas
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 wrote: > Hello Gerald > What was the result of the datavalue query? > You should also check the sharing settings of the data el

Re: [Dhis2-devs] [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 escribió: > Dear Juan, > Please find the attached updated combo query. > > On 8/24/15, gerald thomas

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-24 Thread gerald thomas
Dear Juan, Please find the attached updated combo query. On 8/24/15, gerald thomas 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 wrote: >> Select "Update category option comb

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-24 Thread gerald thomas
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 wrote: > Select "Update category option combinations" and click on "perform > maintenance". After that finished select from the menu of the left

Re: [Dhis2-devs] [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 escribió: > Dear Juan, > Under Maintenance column i am s

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-24 Thread Juan Manuel Alcantara Acosta
El 24/08/2015, a las 08:00, gerald thomas 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 invi

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-24 Thread gerald thomas
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 sh

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-23 Thread Adedapo Adejumo
Hi Gerald, Did you recently edit the affected data elements? Can you view the data in the data entry screen? If yes - can you also check sharing settings on these data elements? On Sun, Aug 23, 2015 at 9:10 PM, gerald thomas wrote: > Dear All, > Thanks for all your responses. > Please find the a

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-23 Thread Ant Snyman
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 ass

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-23 Thread Elmarie Claasen
Hi Gerald, Are you sure that the user permissions for the capturing role are correct? Do you have the same problem with data loss if you capture with superuser role with ALL permissions allocated? Elmarie On 23 Aug 2015 6:36 PM, "gerald thomas" wrote: > Juan, > Thanks for your response but we a

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-23 Thread gerald thomas
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-devs] [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 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 sta

Re: [Dhis2-devs] [Dhis2-users] Data Loss

2015-08-20 Thread Lwinlwin Aung
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 elemen