The 'accounts' and 'institutions' sections of the SIP Server configuration should be able to be moved into the Koha Staff Client.. this would help librarians understand what settings are in place and allow them to make small changes to those configurations as required.
Created attachment 172530 [details] SIPconfig.xml into DB schema Hi all I've started looking into this. @Kyle @Nick, can I ask a few minutes of your time to briefly look at this schema before I fully commit to it. I aimed to catch and accommodate all possible configurations values from SIPconfig.xml. Thank you.
Created attachment 172584 [details] SIPconfig.xml into DB schema sip_institution should be a 1 to 1 with sip_policy, even though SIPconfig.xml technically allows for multiple policies per institution, the template SIPconfig.xml only has one policy per institution and as I understand it the SIP code logic expects only one policy per institution. This being the case, and policies not relating to anything else, there's no reason to have a separate table for policies specifically and these columns can be merged into sip_institutions instead. Thoughts?
(In reply to Pedro Amorim from comment #2) > Created attachment 172584 [details] > SIPconfig.xml into DB schema > > sip_institution should be a 1 to 1 with sip_policy, even though > SIPconfig.xml technically allows for multiple policies per institution, the > template SIPconfig.xml only has one policy per institution and as I > understand it the SIP code logic expects only one policy per institution. > This being the case, and policies not relating to anything else, there's no > reason to have a separate table for policies specifically and these columns > can be merged into sip_institutions instead. Thoughts? I agree with everything you wrote. I do note the image has institutions and accounts being one to one, but they should be one to many.
(In reply to Kyle M Hall (khall) from comment #3) > I do note the image has institutions and > accounts being one to one, but they should be one to many. 100%. Tyvm.