Sonny Software

I'm trying to set up an import filter for Columbia University's library. Since their database often includes 505 and 520 fields (chapter titles and book description), this is my preferred library of choice.

I'm not sure if Columbia changed their field formatting or if this is the format for newer titles, but in any case the 505 field now often includes only chapter numbers but not titles. So in the abstract field, I will see: 1. 2. 3. App. etc. The original appears as:

505 00$g1.$tMedia and modernism -- $g2.$tLanguage at the limits : the global
situation of Japanese modernism -- $g3.$t"All forms of poetic literature are
destroyed" : Hagiwara Kyojiro's Shikei senkoku -- $g4.$tFraming modernity in
Hayashi Fumiko's Horoki -- $g5.$tHoroki and the modern girl -- $g6.
$tAnarchism and imperialism : Hagiwara Kyojiro's Danpen and beyond -- $gApp.
$tSelected works of Hagiwara Kyojiro.

How do I edit the settings to include the chapter titles? Thanks in advance.

Hi,

You don't say what the chapter title is in this example. But it looks like they are using numbers after the subfield identifier to put in additional information (e.g. g1, g2, g3). Bookends only works with single-letter subfields (e.g. g), and so it won't import the different subfields you list in this example.

Jon
Sonny Software

Heh, I just improved that filter too since I discovered that they provide this nice additional info.

To get all the additional info you have to enter something like The 505r is for those cases where authors in edited volumes are given, if I remember correctly (I don't have Bookends at hand right now).

When dabbling around with the Columbia University import filter I also tried to assign the 505r field simultaneously to author and abstract - and got Bookends to crash repeatedly when importing an entry (that had about 10 or so entries for 505r, I think).

(I wanted to e-mail both the updated import filter and a crash report to Jon, but time was a bit tight and so far I did not do that – are you going to send the updated filter to Jon? Or should I do so?)

Jon wrote:Hi,

You don't say what the chapter title is in this example. But it looks like they are using numbers after the subfield identifier to put in additional information (e.g. g1, g2, g3). Bookends only works with single-letter subfields (e.g. g), and so it won't import the different subfields you list in this example.

Jon
Sonny Software

You guessed the chapter titles. This is what I was afraid of with this new format put out by Columbia. I'll do some more searches to see if this obtains only for recently published titles (which is what I was entering in the DB). But it looks as though there will be no way apart from cut-n-paste to include chapter titles.

spd, have you tried my suggestion? In my experience it works splendidly? You get the chapter number and and the titles and the authors (if available).

ozean wrote:spd, have you tried my suggestion? In my experience it works splendidly? You get the chapter number and and the titles and the authors (if available).

Didn't this crash BE? I'm also not sure how to modify the import filter; I see the 505 g fields but need to add subfields, which Jon says is impossible.

Thanks.

spd, g is the subfield. You can't have sub-subfields. But looking more closely at you posted text, the subfield is actually t. But I don't think Bookends will collect them all. I think it will stop after the first one.

Jon
Sonny Software

Below you see part of the MARC record output shown when doing a Columbia U search on Michael Burawoy's "Global Ethnography"
All of this info gets imported to my database (into the abstract field) with the modified Columbia U filter. The only change that I made is to enter into the abstract field of the import filter.

g is for the chapter number, t is for the chapter title and r is for the author.

The crash only happened when I additionally entered 505r as a tag for the author field. In this case (I only tried with this book) I got a crash (although the reference was in the database after doing the import, i.e. it crashed after importing – whatever that means).

Try to enter the values given above for the abstract field and enjoy your new and improved import filter

If you improved the filter in any other way, you should probably send it to Jon to include in future distributions (after changing the tags for the abstract field). If not, I guess Jon can enter this stuff himself for the Columbia U filter and include it in the next update. If not: Jon, send me a note and I e-mail the updated filter to you…

Jon wrote:spd, g is the subfield. You can't have sub-subfields. But looking more closely at you posted text, the subfield is actually t. But I don't think Bookends will collect them all. I think it will stop after the first one.

Jon
Sonny Software

From what I recall, using 505g originally allowed my to get all chapter titles included in a bibliographic entry.

Right, the other subfields (ie "t") are new to these Columbia entries (either because I'm searching new titles or because they changed their format). But Ozean claims that it is, in fact, possible to enter subfields by simply adding them to the existing filter. So I'll try that method.

Thanks, again, Jon. BE is great and your level of support is simply amazing. Now that I'm using Mellel for word processing, I couldn't be more pleased.

ozean wrote:Below you see part of the MARC record output shown when doing a Columbia U search on Michael Burawoy's "Global Ethnography"

Code: Select all

505 00$g1.$tIntroduction: Reaching for the Global /$rMichael Burawoy --$gPt. 1.
   $tGlobal Forces.$g2.$tGlobal Discourses of Need: Mythologizing and
   Pathologizing Welfare in Hungary /$rLynne Haney.$g3.$tExcavating
   "Globalization" from Street Level: Homeless Men Recycle Their Pasts /
   $rTeresa Gowan.$g4.$tDegradation without Deskilling: Twenty-Five Years in
   the San Francisco Shipyards /$rJoseph A. Blum --$gPt. 2.$tGlobal
   Connections.$g5.$t"Dirty Nurses" and "Men Who Play": Gender and Class in
   Transnational Migration /$rSheba George.$g6.$tNet-Working for a Living:
   Irish Software Developers in the Global Workplace /$rSean O'Riain.$g7.
   $tTraveling Feminisms: From Embodied Women to Gendered Citizenship /$rMillie
   Thayer --$gPt. 3.$tGlobal Imaginations.$g8.$tCognitive Cartography in a
   European Wasteland: Multinational Capital and Greens Vie for Village
   Allegiance /$rZsuzsa Gille.$g9.$tContesting the Global City: Pittsburgh's
   Public Service Unions Confront a Neoliberal Agenda /$rSteven H. Lopez.
505 80$g10.$tFrom Private Stigma to Global Assembly: Transforming the Terrain
   of Breast Cancer /$rMaren Klawiter.$g11.$tGrounding Globalization /$rMichael
   Burawoy.

All of this info gets imported to my database (into the abstract field) with the modified Columbia U filter. The only change that I made is to enter

Code: Select all

505a,505g,505t,505r

into the abstract field of the import filter.

g is for the chapter number, t is for the chapter title and r is for the author.

The crash only happened when I additionally entered 505r as a tag for the author field. In this case (I only tried with this book) I got a crash (although the reference was in the database after doing the import, i.e. it crashed after importing – whatever that means).

Try to enter the values given above for the abstract field and enjoy your new and improved import filter

If you improved the filter in any other way, you should probably send it to Jon to include in future distributions (after changing the tags for the abstract field). If not, I guess Jon can enter this stuff himself for the Columbia U filter and include it in the next update. If not: Jon, send me a note and I e-mail the updated filter to you…

This is great! Thanks Ozean.