[Koha] Technical help with Frameworks

Fri May 30 05:44:08 NZST 2014

As a test, I exported a format, edited one field (changed the name
slightly) and uploaded it.  This time it worked.
I suspect they've tightened up the import process - so that if you have a
missmatch between fields and subfields (easy enough to do if you delete a
field and miss deleting one of  the subfields) it won't import.

A more helpful error message would be useful (a failed on line number
message would be better than nothing)

To preserve your sanity, don't delete the fields and subfields (as irksome
as it is to see all the extraneous fields in there).
Stick to editing the visibility column and you'll have less chance of a
failed import.
Now I'll go back and do just that to the format I was trying to edit
yesterday. With luck I won't waste another afternoon.

Yes, I know you SQL wizards can do all this stuff magically in the
background.  But we lowly librarian types are safer not sticking our
fingers into the machinery. It will take me as long to write up a document
explaining to the IT wizard what needs to be done, as to do it myself.
Provided I don't do anything else silly that breaks the import.

On Thu, May 29, 2014 at 3:17 PM, Alexander Tim <TAlexander at triley.co.uk>
wrote:

> 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-bounces at 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.bays at 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 at 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) 7774 995297 (mobile)
> > +44 (0) 800 756 6384 (fax)
> > skype: ian.bays
> > email: ian.bays at ptfs-europe.com
> >
> >
> >
> > _______________________________________________
> > Koha mailing list http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> --
> Elaine Bradtke
> Data Wrangler
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at 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.
>
>
>

-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)