Re: [Koha] Continued issues with frameworks
I believe I had misinterpreted the error message I was getting from the framework test. I have done as you describe and it all seems happy now. Oddly pointing the Koha to MARC mapping for homebranch and holdingbranch to a null value allows the tests to pass. Not sure if this is strictly a bug but found it interesting behaviour. Is there anywhere that has a description/documentation of the tabs? Thanks for your help thus far. I am glad I am finally making some progress with Koha! Tim From: Bernardo Gonzalez Kriegel [mailto:bgkrie...@gmail.com] Sent: 10 June 2014 20:31 To: Alexander Tim Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Continued issues with frameworks Hi Tim, why are 952 subfields on tab '-1'? They must be on tab '10'. On default framework all are on tab '10' except 952$6 and 952$9 (they are on tab '-1') Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.commailto:bgkrie...@gmail.com On Tue, Jun 10, 2014 at 10:14 AM, Alexander Tim talexan...@triley.co.ukmailto:talexan...@triley.co.uk wrote: So I am still struggling after what seemed like some success with frameworks. I cannot seem to clear warnings for homebranch and holdingbranch not being mapped and with the correct authorised value. I have the following lines in my XML file: tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength 952,a,Permanent location,Permanent Location,0,0,items.homebranch,-1,branches,#,#,0,-5,TIM2,#,#,#, 952,b,Current location,Current Location,0,0,items.holdingbranch,-1,branches,#,#,0,-5,TIM2,#,#,#, [The above is a csv extract] This to me shows that items.homebranch and items.holdingbranch are assigned to tag 952 subfields a and b respectively. They are on tab -1, so as to comply with the requirement to have itemnum subfield set to -1 and to have all item fields on the same tab and tag. They also have an authorised_value of branches. I can see that they are mapped under Koha - MARC mapping but still this issue persists. I also have a library created. I previously thought I have fixed it but for the life of me cannot replicate it. Have I totally got the wrong end of the stick here? These are the last two errors I have and would be grateful to have this fixed. Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Continued issues with frameworks
So I am still struggling after what seemed like some success with frameworks. I cannot seem to clear warnings for homebranch and holdingbranch not being mapped and with the correct authorised value. I have the following lines in my XML file: tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength 952,a,Permanent location,Permanent Location,0,0,items.homebranch,-1,branches,#,#,0,-5,TIM2,#,#,#, 952,b,Current location,Current Location,0,0,items.holdingbranch,-1,branches,#,#,0,-5,TIM2,#,#,#, [The above is a csv extract] This to me shows that items.homebranch and items.holdingbranch are assigned to tag 952 subfields a and b respectively. They are on tab -1, so as to comply with the requirement to have itemnum subfield set to -1 and to have all item fields on the same tab and tag. They also have an authorised_value of branches. I can see that they are mapped under Koha - MARC mapping but still this issue persists. I also have a library created. I previously thought I have fixed it but for the life of me cannot replicate it. Have I totally got the wrong end of the stick here? These are the last two errors I have and would be grateful to have this fixed. Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] MARC Framework test errors
So I managed to get round the issues I was having importing a cut down framework. I have now managed to import the attached framework by using an SQL script pointed out by Bernardo Gonzalez Kriegel. I was then able to export to XML and edit in Excel and then re-import with changes to hidden fields for a few MARC numbers so that they disaply a box. I am now running the framework test and I get teh following results: MARC bibliographic framework test TestResult itemnum The field itemnum MUST be mapped The corresponding subfield MUST be in with -1 (ignore) tab item fields ALL items fields MUST : be mapped to the same tag, and they must all be in the 10 (items) tab OK Only 1 MARC tag mapped to items OK biblioitems.itemtype defined homebranch NOT mapped the items.homebranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have Authorized value set to branches holdingbranch NOT mappedthe items.holdingbranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have Authorized value set to branches OK at least 1 item type defined OK at least 1 library defined biblio and biblionumber The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield, OK no NULL value in frameworkcode OK all subfields for each tag are in the same tab (or ignored) OK all authority types used in the frameworks are defined TOTAL You have 5 error(s) in your MARC configuration. Please fix them before using Koha Looking at the errors it is complaining about I already have those values configured on the XML file, or at least as far as I can work out. I fully admit that the Hidden column seems a touch voodoo to me. I would be grateful of any thoughts as I am thinking that any items I create using this framework I have created will not function correctly. Thanks in advance Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Technical help with Frameworks
Well I found this error in /var/log/koha/library/intranet-error.log: [Wed May 28 10:51:48 2014] [error] [client 10.168.3.45] [Wed May 28 10:51:48 2014] import_export_framework.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/ImportExportFramework.pm line 284., referer: http://10.168.50.99:8080/cgi-bin/koha/admin/biblio_framework.pl This error does not always correspond with when I am trying to import a framework though. Am I barking up the wrong tree looking at this? Or have I missed a special syntax for the CSV to import? -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Elaine Bradtke Sent: 29 May 2014 00:15 To: Ian Bays Cc: koha Subject: Re: [Koha] Technical help with Frameworks Theoretically, you can edit the visibility offline in the spreadsheet. Column M in the MARC subfield structure sheet. Easier to do than individually in Koha itself. However, I've tried .ods, and I've tried xls and all I get are import errors. I have edited frameworks this way before 3.14. I'd be interested to know if anyone has edited a framework exported from 3.14 and had it import successfully. Has something changed in the import / export process that is causing it to fail? All I want to do is set up a very simple framework to use with an in-house template that doesn't take me a day's work to hide and unhide all the subfields one at a time. On Wed, May 28, 2014 at 5:43 PM, Ian Bays ian.b...@ptfs-europe.com wrote: Hi Tim, We find that the safest way of trimming frameworks to a more minimalist set is to hide the subfields. This can be quite laborious through the staff interface as you have to select each subfield and look in Advanced constraints then Visibility. If you have access at the sql level you can probably set the field hidden in table marc_subfield_structure to value -6 for those tags you do not want to appear (within your chosen framework). You might also want to change the tab for display to all be the same (eg 0) if you only have 18 tags. That just makes it clearer on the screen. Not every field has or needs to have a koha to marc mapping, but a few of the koha fields must be mapped to marc subfields. The Administration tool MARC bibliographic framework test and other tools in the same area should help fine tune it. We try to avoid removing fields (tags) and subfields from frameworks as you could lose bibliographic data if you switch between frameworks while editing and save the record. It depends what your longer-term plans might be for use of the system as to whether this might be a consideration. If you stray too far from the MARC standard tags you may find that searching for records becomes unreliable as the search indexes are fed from the fields and subfields according to the MARC21 (or UNIMARC) standard. Good luck. Ian On 28/05/2014 15:09, Alexander Tim wrote: Not sure if this is the correct list to email but if not hoping someone can send me in the right direction! So, I am not a Librarian but work as a sys admin for my company. We have a small Company Library that is used to publish various technical publications for our users to look through. We are looking to move to Koha but I find I am struggling with the initial steps of trimming down the MARC Framework. The list of fields I have been passed by our Librarian is for only 18 or so fields. I am therefore finding cutting down the default framework very laborious. I have looked to Import a cut down version of the framework, from an amended export to CSV, but this fails with Error Importing the Framework. I was then hoping that there is something on the SQL side I could do to amend the framework but this has not exactly yielded any useful results. Is there anywhere I can check for an error on the framework import? If not is there any guidance on cutting a framework down to just the required fields? I am also concerned that not every field we have in the proposed framework would have a corresponding Koha to MARC mapping. Would this be required or are these there for simplicity rather than a necessity? Regards Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Ian Bays Director of Projects, PTFS Europe Limited Content Management and Library Solutions +44 (0) 800 756 6803 (phone) +44 (0
[Koha] Technical help with Frameworks
Not sure if this is the correct list to email but if not hoping someone can send me in the right direction! So, I am not a Librarian but work as a sys admin for my company. We have a small Company Library that is used to publish various technical publications for our users to look through. We are looking to move to Koha but I find I am struggling with the initial steps of trimming down the MARC Framework. The list of fields I have been passed by our Librarian is for only 18 or so fields. I am therefore finding cutting down the default framework very laborious. I have looked to Import a cut down version of the framework, from an amended export to CSV, but this fails with Error Importing the Framework. I was then hoping that there is something on the SQL side I could do to amend the framework but this has not exactly yielded any useful results. Is there anywhere I can check for an error on the framework import? If not is there any guidance on cutting a framework down to just the required fields? I am also concerned that not every field we have in the proposed framework would have a corresponding Koha to MARC mapping. Would this be required or are these there for simplicity rather than a necessity? Regards Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha