← Back to team overview

dhis2-devs team mailing list archive

Re: Batch lock exceptions

 

One more supporter of the blueprint!

 

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

Regards,

Dapo Adejumo

+2348033683677

Skype : dapojorge

 

From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail.com@xxxxxxxxxxxxxxxxxxx] 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@xxxxxxxxx <mailto:mortenoh@xxxxxxxxx> > 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@xxxxxxxxx <mailto:jason.p.pickering@xxxxxxxxx> > 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@xxxxxxxxx <mailto:jason.p.pickering@xxxxxxxxx> > 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. 

 

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@xxxxxxxxx <mailto:abhijeet.7777@xxxxxxxxx> > wrote:

hi

selecting multiple period at a time is a good idea..

 

On Thu, Jun 28, 2012 at 6:21 PM, Olav <op.registrering@xxxxxx <mailto:op.registrering@xxxxxx> > 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@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
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@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp





 

-- 

Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx <mailto:jason.p.pickering@xxxxxxxxx> 
tel:+46764147049 <tel:%2B46764147049> 





 

-- 

Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx <mailto:jason.p.pickering@xxxxxxxxx> 
tel:+46764147049 <tel:%2B46764147049> 


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

 





 

-- 

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


References