<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>This is both a library MARC structure issue and a Koha data structure issue:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m a bit confused about the normal practice concerning a numbered series of books information (e.g. Babysitter’s Club)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I pretty well completed the transition from Follett to Koha 3.4 on Ubuntu and am ready to begin the new school year on August 15. I discovered the problem that the imported data from Follett regarding series information were different from standard info on a Z3950 search.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The default Books, Booklets, Workbooks framework does not have the 490 as default but has 440, with a lock on subfield a. I kept my Follett data into 440, but am not able to edit the existing biblios in that framework, tab 4. (I have not set up any authorities). <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Newly catalogued books (only about 20) imported from a Z3950 search import the series info into 490. The biblio editing tab 4 displays it fine. Since they were brought in using the existing Book framework, the serial field and seriestitle in the biblio field remains blank.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Puzzled, I discovered that 440 is now obsolete in the US. In the existing Follett to Koha migrations that were documented, this issue had not been brought up before.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So I have changed the framework for 490 to now appear by default (setting to the advanced constraints “hidden” to 0).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve mapped MARC to Koha to 490 for serial info.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Getting this string <datafield tag="440" ind1=" " ind2="0"> to read <datafield tag="490" ind1=" " ind2="1”> is just a minor SQL Update Replace() query in the marcxml field in the biblioitems table. Getting the content of the now 490a subfield and 490v subfield (the only 440/490 fields in use) into the serial and seriestitle fields is still a problem. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Am I on the right track? Do I have to change anything in the marc field of the biblioitems table?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for the help.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Marion<o:p></o:p></p><p class=MsoNormal>Visitation Inter-Parish School<o:p></o:p></p><p class=MsoNormal>Vienna, MO<o:p></o:p></p></div></body></html>