https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 --- Comment #2 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 180249 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180249&action=edit Bug 39518: Add DBIC file -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 --- Comment #4 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 180251 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180251&action=edit Bug 39518: Update object methods and unit tests -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180249|0 |1 is obsolete| | --- Comment #7 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 180278 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180278&action=edit Bug 39518: Add DBIC file -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180251|0 |1 is obsolete| | --- Comment #9 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 180280 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180280&action=edit Bug 39518: Update object methods and unit tests Test plan: Test plan: This test plan involves running a cronjob, not sure how easy this is in the sandboxes 1) In system preferences, click Search and then select the Acquisitions option from the left hand menu 2) Enable MarcOrderingAutomation 3) Paste the following into MarcFieldsToOrder price: 975$p quantity: 975$q budget_code: 975$h 4) Paste the following into MarcItemFieldsToOrder homebranch: 949$a holdingbranch: 949$b itype: 949$y nonpublic_note: 949$x public_note: 949$z loc: 949$c ccode: 949$8 notforloan: 949$7 uri: 949$u copyno: 949$t price: 949$g replacementprice: 949$v itemcallnumber: 949$o quantity: 949$k budget_code: 949$l Now save the sysprefs 5) In the administration homepage, under Acquisition parameters there should now be a link called "MARC order accounts" 6) Click on this and click the New account button 7) Choose a vendor and a budget 8) Enter a description and make sure you don't set a value in the 'Basket name field' input 9) Enter the following in download directory - "/var/lib/koha/kohadev/tmp/koha_kohadev_upload" 10) Select any record matching settings you want (not important for the test plan, this uses the same code as the marc file staging that already exists in Koha) 11) Check Yes under Check for embedded item record data 12) Click submit 13) We now need to upload a MARC file into the directory that we put in the account. The easiest way to do this is through the marc staging tool 14) Navigate to Cataloging > Stage MARC records for import 15) Upload the file attached to this bug using the Choose file button 16) Click Upload file. 17) Leave the page without completing the new form that appears, we don't want to stage this file. The file we uploaded is now in the directory ready for the cronjob to process as if it had been transferred via SFTP. 18) In the CLI run, perl misc/cronjobs/marc_ordering_process.pl -v -c 19) The logging should show that the file has been processed for that account 20) Navigate to Acquisitions 21) Search for the Vendor that you put in the MARC ordering account 22) There should now be a basket titled: 'This is a basket' 23) In the ordering account, set the 'Basket name field' to be 975$a 24) Repeat steps 14 -22, the basket should now be called "This is a basket" which has been pulled from the file -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180278|0 |1 is obsolete| | --- Comment #12 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 180287 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180287&action=edit Bug 39518: Add DBIC file -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180280|0 |1 is obsolete| | --- Comment #14 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 180289 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180289&action=edit Bug 39518: Update object methods and unit tests Test plan: Test plan: This test plan involves running a cronjob, not sure how easy this is in the sandboxes 1) In system preferences, click Search and then select the Acquisitions option from the left hand menu 2) Enable MarcOrderingAutomation 3) Paste the following into MarcFieldsToOrder price: 975$p quantity: 975$q budget_code: 975$h 4) Paste the following into MarcItemFieldsToOrder homebranch: 949$a holdingbranch: 949$b itype: 949$y nonpublic_note: 949$x public_note: 949$z loc: 949$c ccode: 949$8 notforloan: 949$7 uri: 949$u copyno: 949$t price: 949$g replacementprice: 949$v itemcallnumber: 949$o quantity: 949$k budget_code: 949$l Now save the sysprefs 5) In the administration homepage, under Acquisition parameters there should now be a link called "MARC order accounts" 6) Click on this and click the New account button 7) Choose a vendor and a budget 8) Enter a description and make sure you don't set a value in the 'Basket name field' input 9) Enter the following in download directory - "/var/lib/koha/kohadev/tmp/koha_kohadev_upload" 10) Select any record matching settings you want (not important for the test plan, this uses the same code as the marc file staging that already exists in Koha) 11) Check Yes under Check for embedded item record data 12) Click submit 13) We now need to upload a MARC file into the directory that we put in the account. The easiest way to do this is through the marc staging tool 14) Navigate to Cataloging > Stage MARC records for import 15) Upload the file attached to this bug using the Choose file button 16) Click Upload file. 17) Leave the page without completing the new form that appears, we don't want to stage this file. The file we uploaded is now in the directory ready for the cronjob to process as if it had been transferred via SFTP. 18) In the CLI run, perl misc/cronjobs/marc_ordering_process.pl -v -c 19) The logging should show that the file has been processed for that account 20) Navigate to Acquisitions 21) Search for the Vendor that you put in the MARC ordering account 22) There should now be a basket titled: '{random_hash}_orderstest.marcxml' 23) In the ordering account, set the 'Basket name field' to be 975$a 24) Repeat steps 14 -22, the basket should now be called "This is the basket name" which has been pulled from the file Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180286|0 |1 is obsolete| | --- Comment #16 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 180293 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180293&action=edit Bug 39518: Add a new column basket_name_field Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180288|0 |1 is obsolete| | --- Comment #18 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 180295 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180295&action=edit Bug 39518: Add new field to the UI Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180290|0 |1 is obsolete| | --- Comment #20 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 180297 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180297&action=edit Bug 39518: (follow-up) Add clarifying text to basket name field Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |34355 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34355 [Bug 34355] Automated MARC record ordering process -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Thomas Klausner <domm@plix.at> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Thomas Klausner <domm@plix.at> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180294|0 |1 is obsolete| | --- Comment #23 from Thomas Klausner <domm@plix.at> --- Created attachment 180554 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180554&action=edit Bug 39518: Add DBIC file Signed-off-by: Nick Clemens <nick@bywatersolutions.com> Signed-off-by: Thomas Klausner <domm@plix.at> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Thomas Klausner <domm@plix.at> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #180296|0 |1 is obsolete| | --- Comment #25 from Thomas Klausner <domm@plix.at> --- Created attachment 180556 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=180556&action=edit Bug 39518: Update object methods and unit tests Test plan: Test plan: This test plan involves running a cronjob, not sure how easy this is in the sandboxes 1) In system preferences, click Search and then select the Acquisitions option from the left hand menu 2) Enable MarcOrderingAutomation 3) Paste the following into MarcFieldsToOrder price: 975$p quantity: 975$q budget_code: 975$h 4) Paste the following into MarcItemFieldsToOrder homebranch: 949$a holdingbranch: 949$b itype: 949$y nonpublic_note: 949$x public_note: 949$z loc: 949$c ccode: 949$8 notforloan: 949$7 uri: 949$u copyno: 949$t price: 949$g replacementprice: 949$v itemcallnumber: 949$o quantity: 949$k budget_code: 949$l Now save the sysprefs 5) In the administration homepage, under Acquisition parameters there should now be a link called "MARC order accounts" 6) Click on this and click the New account button 7) Choose a vendor and a budget 8) Enter a description and make sure you don't set a value in the 'Basket name field' input 9) Enter the following in download directory - "/var/lib/koha/kohadev/tmp/koha_kohadev_upload" 10) Select any record matching settings you want (not important for the test plan, this uses the same code as the marc file staging that already exists in Koha) 11) Check Yes under Check for embedded item record data 12) Click submit 13) We now need to upload a MARC file into the directory that we put in the account. The easiest way to do this is through the marc staging tool 14) Navigate to Cataloging > Stage MARC records for import 15) Upload the file attached to this bug using the Choose file button 16) Click Upload file. 17) Leave the page without completing the new form that appears, we don't want to stage this file. The file we uploaded is now in the directory ready for the cronjob to process as if it had been transferred via SFTP. 18) In the CLI run, perl misc/cronjobs/marc_ordering_process.pl -v -c 19) The logging should show that the file has been processed for that account 20) Navigate to Acquisitions 21) Search for the Vendor that you put in the MARC ordering account 22) There should now be a basket titled: '{random_hash}_orderstest.marcxml' 23) In the ordering account, set the 'Basket name field' to be 975$a 24) Repeat steps 14 -22, the basket should now be called "This is the basket name" which has been pulled from the file Signed-off-by: Nick Clemens <nick@bywatersolutions.com> Signed-off-by: Thomas Klausner <domm@plix.at> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 --- Comment #27 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Please always mark the DBIC update with [DO NOT PUSH] - harder to miss that way. RM wants to regenerate to avoid trouble with the checksums. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 --- Comment #28 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Pushed for 25.05! Well done everyone, thank you! -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Text to go in the| |**Summary:** release notes| |Some vendors | |include the intended basket | |name in the MARC file, but | |Koha previously ignored | |this information. | | | |**Enhancement:** | |You can | |now configure a MARC order | |account to read a specified | |field in the MARC file and | |use its value as the basket | |name. | | | |**Impact:** | |Improves automation and | |vendor integration by | |reducing the need for | |manual basket naming during | |order import. CC| |martin.renvoize@openfifth.c | |o.uk -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39518 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=41029 -- You are receiving this mail because: You are watching all bug changes.