Batch lock exceptions

Support - Assistance technique
1

Hi,
just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

2

hi

selecting multiple period at a time is a good idea…

···

On Thu, Jun 28, 2012 at 6:21 PM, Olav op.registrering@me.com wrote:

Hi,

just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

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

–
Regards,

Abhijeet

3

Managed to find this rather old message and had a question.

I need to generate a large number of lock exceptions, and using the UI has a couple of issues.

  1. I need to select certain children of a given parent, which actually are assigned to the data set. However, when I select the top level node, I can filter on OU group, but cannot filter on the actual data set assignment itself. I only see data sets which belong to the top level node, rather than ALL possible datasets which I may need to generate lock exceptions for.

  2. I looked in the docs, but did not see any way to use the API to generate these lock exceptions in bulk. Is there a way to do this? Seems that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action to do this, but with several tens of thousand lock exceptions which needs to be generated, this does not seem particular efficient.

I suppose the alternative is to use inject the SQL into “lockexception”, but maybe there is an easier way?
Regards,

Jason

···

On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . abhijeet.7777@gmail.com wrote:

hi

selecting multiple period at a time is a good idea…

On Thu, Jun 28, 2012 at 6:21 PM, Olav op.registrering@me.com wrote:

Hi,

just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

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

–
Regards,

Abhijeet

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

4

Also, while I am at it, I wonder why we need the “lockexceptionid” at all on the lockexception table? Isn’t organisationunitid/periodid/datasetid enough as a primary key? What is the need for this integer primary key?

Regards,

Jason

···

On Wed, Jul 1, 2015 at 8:30 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Managed to find this rather old message and had a question.

I need to generate a large number of lock exceptions, and using the UI has a couple of issues.

  1. I need to select certain children of a given parent, which actually are assigned to the data set. However, when I select the top level node, I can filter on OU group, but cannot filter on the actual data set assignment itself. I only see data sets which belong to the top level node, rather than ALL possible datasets which I may need to generate lock exceptions for.
  1. I looked in the docs, but did not see any way to use the API to generate these lock exceptions in bulk. Is there a way to do this? Seems that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action to do this, but with several tens of thousand lock exceptions which needs to be generated, this does not seem particular efficient.

I suppose the alternative is to use inject the SQL into “lockexception”, but maybe there is an easier way?
Regards,

Jason

–

On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . abhijeet.7777@gmail.com wrote:

hi

selecting multiple period at a time is a good idea…

On Thu, Jun 28, 2012 at 6:21 PM, Olav op.registrering@me.com wrote:

Hi,

just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

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

–
Regards,

Abhijeet

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

5

Jason

Create a blueprint for lock exception API, and I will have a look at it… can’t promise it for 2.20 though.

I agree it might be better to have it as a composite key, but these have a tendency to create havoc with our generic importer, so lets convert it to a idObject and keep it as it is for now.

···

On Wed, Jul 1, 2015 at 1:39 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Also, while I am at it, I wonder why we need the “lockexceptionid” at all on the lockexception table? Isn’t organisationunitid/periodid/datasetid enough as a primary key? What is the need for this integer primary key?

Regards,

Jason

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

–
Morten

On Wed, Jul 1, 2015 at 8:30 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Managed to find this rather old message and had a question.

I need to generate a large number of lock exceptions, and using the UI has a couple of issues.

  1. I need to select certain children of a given parent, which actually are assigned to the data set. However, when I select the top level node, I can filter on OU group, but cannot filter on the actual data set assignment itself. I only see data sets which belong to the top level node, rather than ALL possible datasets which I may need to generate lock exceptions for.
  1. I looked in the docs, but did not see any way to use the API to generate these lock exceptions in bulk. Is there a way to do this? Seems that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action to do this, but with several tens of thousand lock exceptions which needs to be generated, this does not seem particular efficient.

I suppose the alternative is to use inject the SQL into “lockexception”, but maybe there is an easier way?
Regards,

Jason

–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . abhijeet.7777@gmail.com wrote:

hi

selecting multiple period at a time is a good idea…

On Thu, Jun 28, 2012 at 6:21 PM, Olav op.registrering@me.com wrote:

Hi,

just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

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

–
Regards,

Abhijeet

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

6

Thanks Morten. Have created the blueprint here

https://blueprints.launchpad.net/dhis2/+spec/lock-exceptions-api

Regards,

Jason

···

On Wed, Jul 1, 2015 at 9:29 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Jason

Create a blueprint for lock exception API, and I will have a look at it… can’t promise it for 2.20 though.

I agree it might be better to have it as a composite key, but these have a tendency to create havoc with our generic importer, so lets convert it to a idObject and keep it as it is for now.

–

–
Morten

On Wed, Jul 1, 2015 at 1:39 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Also, while I am at it, I wonder why we need the “lockexceptionid” at all on the lockexception table? Isn’t organisationunitid/periodid/datasetid enough as a primary key? What is the need for this integer primary key?

Regards,

Jason

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

On Wed, Jul 1, 2015 at 8:30 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Managed to find this rather old message and had a question.

I need to generate a large number of lock exceptions, and using the UI has a couple of issues.

  1. I need to select certain children of a given parent, which actually are assigned to the data set. However, when I select the top level node, I can filter on OU group, but cannot filter on the actual data set assignment itself. I only see data sets which belong to the top level node, rather than ALL possible datasets which I may need to generate lock exceptions for.
  1. I looked in the docs, but did not see any way to use the API to generate these lock exceptions in bulk. Is there a way to do this? Seems that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action to do this, but with several tens of thousand lock exceptions which needs to be generated, this does not seem particular efficient.

I suppose the alternative is to use inject the SQL into “lockexception”, but maybe there is an easier way?
Regards,

Jason

–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . abhijeet.7777@gmail.com wrote:

hi

selecting multiple period at a time is a good idea…

On Thu, Jun 28, 2012 at 6:21 PM, Olav op.registrering@me.com wrote:

Hi,

just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

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

–
Regards,

Abhijeet

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

7

One more supporter of the blueprint!

………………………………………

Regards,

Dapo Adejumo

+2348033683677

Skype : dapojorge

···

From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail.com@lists.launchpad.net] On Behalf Of Jason Pickering
Sent: 1 July, 2015 8:53 AM
To: Morten Olav Hansen
Cc: dhis2-devs
Subject: Re: [Dhis2-devs] Batch lock exceptions

Thanks Morten. Have created the blueprint here

https://blueprints.launchpad.net/dhis2/+spec/lock-exceptions-api

Regards,

Jason

On Wed, Jul 1, 2015 at 9:29 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Jason

Create a blueprint for lock exception API, and I will have a look at it… can’t promise it for 2.20 though.

I agree it might be better to have it as a composite key, but these have a tendency to create havoc with our generic importer, so lets convert it to a idObject and keep it as it is for now.

–
Morten

On Wed, Jul 1, 2015 at 1:39 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Also, while I am at it, I wonder why we need the “lockexceptionid” at all on the lockexception table? Isn’t organisationunitid/periodid/datasetid enough as a primary key? What is the need for this integer primary key?

Regards,

Jason

On Wed, Jul 1, 2015 at 8:30 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Managed to find this rather old message and had a question.

I need to generate a large number of lock exceptions, and using the UI has a couple of issues.

  1. I need to select certain children of a given parent, which actually are assigned to the data set. However, when I select the top level node, I can filter on OU group, but cannot filter on the actual data set assignment itself. I only see data sets which belong to the top level node, rather than ALL possible datasets which I may need to generate lock exceptions for.
  1. I looked in the docs, but did not see any way to use the API to generate these lock exceptions in bulk. Is there a way to do this? Seems that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action to do this, but with several tens of thousand lock exceptions which needs to be generated, this does not seem particular efficient.

I suppose the alternative is to use inject the SQL into “lockexception”, but maybe there is an easier way?
Regards,

Jason

On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . abhijeet.7777@gmail.com wrote:

hi

selecting multiple period at a time is a good idea…

On Thu, Jun 28, 2012 at 6:21 PM, Olav op.registrering@me.com wrote:

Hi,
just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work.

What if you first select period type, then one or more datasets, and finally one or more periods?

Olav

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

–
Regards,

  • Abhijeet*

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049