dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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@xxxxxxxxx
tel:+260968395190