Columbia
Escutcheon Columbia University Libraries Digital Program
Ejournal Specs:  Title Listing
Revised 7/11/2001
          Path: Digital Library Projects  : Metadata  :  Ejournals :  Specs  :  Titles



A. Data Element Definitions

Output Element MMF Data Definition
Canonical Ejournal Citation
"Link" if only 1 URL "<A HREF=" + "'" + Part_Presentation.url + "'" + ">"
"Link" if multiple URLs [see below]
"<A HREF=" + "'" + OrigId +".html" + "'" + ">" [For "OrigId" see below]
"Title"
[UPDATED, 7/2001]

If  Uniform_Title.uniform_title is non-null:
  "<B>"+ Uniform_Title.uniform_title + "</B></A>"

Else:
  "<B>"+ Bib_Item.article + " " + Bib_Item.primary_title + "</B></A>"

And, in Title Listings only, when Other_title.title is non-null, create duplicate citations with "Title" =

   "<B>"+ Other_title.article + " " + Other_title.title + "</B></A>"

"Imprint" Bib_Item.imprint
"SSN" Code.name + ": " + Code.code_number where Code.tag = "022" else No ISSN
"Resolver URL" if only 1 URL; otherwise skip. "<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class='cite11'><i><b>Bookmark as:</b></i> &nbsp; <a href=" + "'" + Part_Presentation.url + "'" + ">" + Part_Presentation.url + "</a></span>"
"CLIO Backlink"
[Revised, 7/29/2001]

"<span class=cite11>&#151; <a href='http://www.columbia.edu/cgi-bin/cul/cliosearch?new+-access+clio+scan+open+TS+" +

[ "Title" element omitting Bib_Item.article, up to first occurring "(", ":" or "."]

" '>Check in CLIO</a></span>"

Example:

Title = "South Atlantic quarterly (Online)"

CLIO Backlink = <span class=cite11>&#151; <a href="http://www.columbia.edu/cgi-bin/cul/cliosearch?new+-access+ +clio+scan+open+TS+South+Atlantic+quarterly">Check in CLIO</a></span>   

Displays as = "— Check in CLIO "


B. Selection & Sorting

  1. Select for output all publishable MMF/CLIO ejournal records

  2. Create normalized versions of "Title" strings for sorting purposes; sort numbers before letters; ignore diacritics in sorting

C. Schematic List Output

<DL>
        <DT>["Link"+ "Title"]["Imprint"]["SSN"]
                 
<BR>Bookmark as: [Link + "Link text"]["CLIO Backlink"]
      
        <DT>["Link"+ "Title"]["Imprint"]["SSN"]
                <BR>Bookmark as: [Link + "Link text"] ["CLIO Backlink"]
        <BR>
        <DT>["Link"+ "Title"]["Imprint"]["SSN"]
              
<BR>Bookmark as: [Link + "Link text"] ["CLIO Backlink"]
     [Etc.]
</DL>


D. Markup Specification

  • <DL><DT>notation is used for the list, as shown in the schematic above
  • <B> is used for the Title Element.
  • <BR><BR>is inserted ahead of each new citation except for the first on a page
  • If "Imprint" or "SSN" element is present (i.e., is non-null), precede with space, em-dash (i.e.,   &#151; ), space; if element is not present, do not insert corresponding em-dash.
  • Insert eye-legible anchor & link for Resolver-Type URL ("Bookmark As")
  • Insert the "CLIO Backlink" element, preceded by an em-dash (&#151;)

E. Page Layout

  • Do not include HTML "HEAD" or "BODY" elements in files published through this process, as they will be inserted as server-side includes into documents already-including these element

  • Enclose content of each page in a single table with the following attributes:

    • ROWS="1"
    • COLS="1"
    • WIDTH="640"
    • BORDER="0"
    • CELLSPACING="0"
    • CELLPADDING="2"
    • CLASS="lmargin10"

e.g.,

<TABLE ROWS="1" COLS="1" WIDTH="640"BORDER="0" CELLSPACING="0" CELLPADDING="2" CLASS="lmargin5">
<TR>
<TD>
[Page content]
</TD>
</TR>
</TABLE>


F. Alphabetic Navigation Bar


  • Create 27 separate 'include' files with custom navigation bars in the /cu/lweb/includes/names, /titles/ and other subdirectories, named as follows:

    /cu/lweb/includes/[subdirectory]/numeric.html
    /cu/lweb/includes/[subdirectory]/alpha_a.html
    /cu/lweb/includes/[subdirectory]/alpha_b.html
    /cu/lweb/includes/[subdirectory]/alpha_c.html
    etc.

  • Default link display: each link-text in the alpha navbar is enclosed within a SPAN element as follows:

    <SPAN CLASS="alphabet">[letter or word]</SPAN>

    The SPAN should appear in place of the HREF tag for that letter.

  • Selected letter or word link display: In the file for entries beginning with a particular letter or with a numeric, use CLASS="alpha_selected" in place of CLASS= "alphabet" for the link corresponding to that file:

    <SPAN CLASS="alpha_selected">[letter or word]</SPAN>

    Also, omit the Link from the 'selected' entry (since the link would be to the same page).

    See mockup of custom alpha navigation file at: http://www.columbia.edu/cu/libraries/inside/working/ejournals/specs/custom_alpha.html

  • In the file for the corresponding ejournal entries, insert as the first and last elements of the file a server-side include reference to the appropriate custom alpha navigation file, e.g.,

    in the file:
    /cu/lweb/data/eresources/ejournals/[subdirectory]/a.html

    insert SSI references at the top and bottom as follows:
    <!--#include virtual="/cu/lweb/includes/[subdirectory]/alpha_a.html" -->

G. Special Processing for Records Having Multiple URLs

Records that meet the requirements for inclusion in this output set having more than one URL (Part_Presentation.url) are handled as exceptions, as follows:

  • As indicated in Section A above, the "Link" element is constructed from the CLIO Record Key (MMF cu001), e.g.,

    <A HREF="detail/clio.ank2942.html">Title</A>

  • The presence of multiple URLs must also trigger the creation a file that includes the corresponding "Detail Record", e.g.,

    /ejournals/names/detail/clio.ank2942.html

  • Specifications for creating "Detail record" record pages are in a separate document.

H.  File Names, Directories, Shells & File Management

  • Output data files for the Title listing in the following subdirectories:

    /cu/lweb/data/eresources/ejournals/titles/
    /cu/lweb/data/eresources/ejournals/titles/detail/

  • Output all entries in which the sort string begins with an alpha character 26 separate files according to the segment of the alphabet included in that file, e.g.,

    a.html
    b.htm
    l
    [etc.]

  • Output all entries in which the sort string begins with a numeric in a single file called:

    numeric.html

  • Output all entries that begin with with other than alphabetic or numeric characters in a single file called:

    other.html

  • If there are letters of the alphabet or numbers (from 0-9) for which there are no corresponding ejournal entries to output, create the appropriately named file but insert the following server side include where the ejournal listing would ordinarily have been inserted:

    <!--#include virtual="/cu/lweb/includes/nohits_gen.html" -->

  • Create corresponding "shell" files for each file output in the data directory in the specified parallel shell directory:

    /cu/lweb/eresources/ejournals/titles/
    /cu/lweb/eresources/ejournals/titles/
    detail/

    [Use of makeshell to be determined.]

  • When publishing new data, delete and remove all files in the production directories, i.e.,

    /cu/lweb/eresources/ejournals/titles/
    /cu/lweb/eresources/ejournals/titles/detail
    /
    and
    /cu/lweb/data/eresources/ejournals/titles/
    /cu/lweb/data/eresources/ejournals/titles/detail/

    EXCEPTION: Do not delete the "index.html" file present in any subdirectory; this file will be created manually (or be a poke-error).

I. Sample Output


J. Revision Log

  • 5/2001:  Added spec to use class "lmargin10" for framing table. (Needs fixing??)
  • 7/11/2001:  Added spec for CLIO Backlink element.

 


Columbia Libraries    Digital Program
Last revision: 02/04/03
© Columbia University Libraries