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: jason.p.pickering@gmail.com
tel:+260968395190