Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Extracting course materials per semester, per course; z00r / z13u

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    We are trying to extract course reading materials per semester, per course, via SQL. It looks like CNO data isn't added to ABC50 z00R records even though I ran manage_07 and manage_40 on selected records (10496573 Women behind bars, 668507 Les liaisons dangereuses) in ABC50. In the z108 documentation, it says:

    The Reading List document record is a BIB record (in the Course Reading library)

    Note that the Z108 course records are held in the ADM library, while the reading list
    is held in the Course Reading library. The relation between the ADM library and the
    Course Reading library is set in ./alephe/tab/library_relation table.

    Looking at library_relation, i see that although we have lines like ADM ABC30 ABC50 for each of our ADMs, we don't have any lines with CRS defined in column 1. Could that be part of the problem? If we add CRS lines at this point, what are the implications?

    Resolution:
    Certainly the abc50 Z00r record is not going to have any CNO fields. It's the abc30 z00r which would have these fields.

    I see that you have had the necessary CRS lines in library_relation for at least several months. But I find that there is no abc30 z00r table.

    To get the abc30 titles by Period/Course, you could (1) use the abc30 z13/z13u *instead* of the z00r or (2) create the z00r.

    1. z13/z13u

    You could include the course number/title/instructor and period in the z13u by adding these to abc30 tab22:

    USER-DEF-1 1 CNO-10
    USER-DEF-2 1 CNO-6

    (I see that tab_expand already has the necessary "CREATE-Z13 expand_doc_course".)

    Then run p_manage_07 for the z13.

    Then you could query it with this SQL:

    select Z13U_USER_DEFINED_1, z13_title from z13u, z13 where z13_rec_key = z13u_rec_key and Z13U_USER_DEFINED_1 like '%Fall%' order by Z13U_USER_DEFINED_1, z13_title;


    2. z00r

    a. You would need to define the z00r in the abc30 file_list (which it is not at this point) and then do util a/17/1 (in abc30) to create it.

    b. In the abc30 tab100, change "CREATE-Z00R=N" to "CREATE-Z00R=Y".

    c. Add this line to tab_expand:

    Z00R expand_doc_course

    d. Run p_manage_07 for abc30 for the z00r.

    • Article last edited: 10/8/2013