dhis2-devs team mailing list archive

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

Hi Busoye,
I think the problem is that these periods have not been generated yet. In
the past, we have generated them using SQL. Something like


INSERT INTO period
SELECT nextval('hibernate_sequence'::regclass) as periodid ,
(SELECT periodtypeid from periodtype where name = 'Monthly')  periodtypeid,
 (startdate + '1 year'::interval)::date as startdate,
 (enddate + '1 year'::interval)::date as enddate
 from period
 where periodtypeid = (SELECT periodtypeid from periodtype where name =
'Monthly')
 and startdate >= '2013-01-01' and enddate <='2013-12-31'

This is a really basic statement, and would not check for things like
periods which already exist so you might need to tweak it a bit.

There should really be a method to pre-generate future periods, but I am
not sure this exists.

Regards,
Jason




On Sun, Sep 29, 2013 at 5:20 PM, Adebusoye Anifalaje <busoye@xxxxxxxx>wrote:

> Just an update
>
> I have added 2014 monthly data to the Period table. I still can't see the
> periods in the data entry screen (see file attached) but when I use the
> "Get pdf for Data Entry" function in the data set module, I can see the
> future periods displayed (see attached).
>
> Any insight would be much appreciated.
>
> Many thanks.
>
> Regards,
> Busoye
>
>
> On 29 Sep 2013, at 09:17, Adebusoye Anifalaje <busoye@xxxxxxxx> wrote:
>
> Hi all,
>
> Can anyone help with getting around entering monthly data for future
> periods beyond what is available by default?
>
> I have a use case where users need to enter data for months in 2014 (these
> are advance monthly payments) but currently the future periods allowed do
> not extend beyond December 2013. The "Next Year" function does not make a
> difference here.
>
> It is critical that the data is entered monthly rather than yearly. It is
> also important that users can enter data in (theoretically) unlimited
> periods in the future if the case arises that payment is made up until tim
> "t".
>
> Thaks
>
> Busoye
>
> DHIS2.12
> Build: 11285
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>