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 associated with data that has been captured. Are you concerned because periods exist with future dates? 2. The data is stored in the datavalue table if you are capturing aggregated data. You mention data loss? Has data been captured and you have verified that the data actually is stored in the datavalue table and then afterwards the data disappears when you do analysis? Or does it appear as if the data is physically captured but then never gets stored in the datavalue table? 3. The periodtypeid of 292091 is really odd - is it a custom period that you inserted into the period table yourself?
I would suggest (based on the limited knowledge of what is going on at your site) that you follow the whole process and verify each step: Verify the data is captured correctly and completely and saved. Then verify that that specific piece of data exists in the datavalue table with the right dataelement, period and org unit. If the data gets lost between the data entry and the datavalue table, then there is a problem with the completion of the data capture transaction. If data does land up in the datavalue table, but subsequently disappears, then there might be a batch job running that "cleans out" your datavalue table, but that is most unlikely. If you can't see your data on the reporting side even though the data exists in the datavalue table, then the issue is with the reporting side where you need to specify the correct dataelements, periods and org units to see the data. And this is as much input as I can give with the information you have provided. Regards Regards Ant Snyman On 23 August 2015 at 18:36, gerald thomas <gerald17...@gmail.com> wrote: > 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 | 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-us...@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-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- *Ant Snyman* *Cell: 0824910449* *Landline: 028 2713242* Health Information Systems Program - SA -- *This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclai...@hisp.org <disclai...@hisp.org> and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
