Just did another import from DHIS 1.4. I keep hoping this is the last one, but we are still making a lot of changes. Anyway, any idea what may be causing this?
Look carefully at the periods and their types. There are multiple year periods, although this should definitely not be the case . It would seem that there needs to be some more structure on this table. I cannot imagine there should be a duplicate startdate and enddate combination, even if there have different periodtypeids? Regards, Jason periodtypeid, periodid, startdate, enddate, periodtype 6;12308;"2009-02-01";"2009-02-28";"Monthly" 6;12309;"2009-03-01";"2009-03-31";"Monthly" 6;12310;"2009-04-01";"2009-04-30";"Monthly" 6;12311;"2009-05-01";"2009-05-31";"Monthly" 6;12312;"2009-06-01";"2009-06-30";"Monthly" 6;12313;"2009-07-01";"2009-07-31";"Monthly" 6;12314;"2009-08-01";"2009-08-31";"Monthly" 6;12315;"2009-09-01";"2009-09-30";"Monthly" 6;12316;"2009-10-01";"2009-10-31";"Monthly" 6;12317;"2009-11-01";"2009-11-30";"Monthly" 6;12318;"2009-12-01";"2009-12-31";"Monthly" 6;12320;"2010-01-01";"2010-01-31";"Monthly" 9;12346;"2009-02-01";"2009-02-28";"Yearly" 9;12347;"2009-03-01";"2009-03-31";"Yearly" 9;12348;"2009-04-01";"2009-04-30";"Yearly" 9;12349;"2009-05-01";"2009-05-31";"Yearly" 9;12350;"2009-06-01";"2009-06-30";"Yearly" 9;12351;"2009-07-01";"2009-07-31";"Yearly" 9;12352;"2009-08-01";"2009-08-31";"Yearly" 9;12353;"2009-09-01";"2009-09-30";"Yearly" 9;12366;"2010-01-01";"2010-12-31";"Yearly" 11;12369;"2009-04-01";"9999-12-31";"OnChange" -- -- Jason P. Pickering email: [email protected] tel:+260968395190 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
