1 / 22

ALEPH, Sort of

ALEPH, Sort of. Jane Aitkens Associate Systems Librarian McGill University Libraries June 4, 2001 - NAAUG. The Problem. A web user wants to re-sort the records in the brief view by the author column - the results are ???

fawn
Download Presentation

ALEPH, Sort of

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ALEPH, Sort of Jane Aitkens Associate Systems Librarian McGill University Libraries June 4, 2001 - NAAUG

  2. The Problem • A web user wants to re-sort the records in the brief view by the author column - the results are ??? • You do a call number search in the GUI OPAC, select multiple records, and click Brief. The selected records in the Brief View do not remain in call number order.

  3. The Solution • Run p_manage_27 to create a sort index for the fields displayed in the brief list’s columns, so the user’s re-sort request works. • Assign a specific sort to each type of browse search to establish the default sort of the results so call number searches stay in call number order.

  4. Sorting Objectives • To sort the browse (headings) search results appropriately • To re-sort keyword sets appropriately • Both in the Web and the GUI • BIB and AUT searches as well as Course Reserves

  5. Tables/Files Involved • tab_sort • tab01 & tab_filing (maybe) • tab_expand (maybe) • www_tab_short.eng • pc_tab_short.eng • pc_server_defaults • www_server_defaults • www_sort_heading.eng • pc_tab_sear.eng

  6. Which libraries? • in MGU01 for BIB Indexes • in MGU10 etc., for AUT Indexes • in MGU30 for Course Reserves Indexes

  7. pc_tab_short.eng

  8. www_tab_short.eng

  9. tab_sort This table assigns sort numbers to the fields that are used in your brief views.

  10. www_tab_short.eng - Reserves

  11. tab_sort - Reserves

  12. sorting in the authorities libraries • The pc_tab_short for EXU10, EXU11, etc. • L Established Heading 1#### • L See Also Reference 5#### • L Use Codes 008 • A very simple tab_sort: 01 1####

  13. tab_01 and tab_filing ! The tab01 table is used for ! - defining filing procedure for sort keys based on field ! (Z101 table, p_ret_21 (sort of retrieved BIB records)) D PSTS 24 00 0000 PSTS Llocation • Filing procedure 24 in tab_filing: !* Call numbers ! 24 # del_subfield 24 # to_blank &()-[]<>?,./ 24 # lc_call_no

  14. tab_expand • McGill’s 12.3 tab_expand for MGU01: ! SORT-DOC - b_manage_27_a - create sort keys ! update_sort_doc - internal program SORT-DOC expand_doc_bib_loc_usm • throughout , PST could be replaced by LOC, if you are using that. SORT-DOC expand_doc_bib_loc_usm • NOTE: use newer PST or LOC expand for subfield sensitivity (e.g. $h$i but not $k (folio))

  15. p_manage_27 - batch index job • It needs to be re-run if you change tab_sort or a filing routine using by one of your sorted fields. • Creates the oracle table Z101 • McGill’s BIB (4 sort keys, one a PSTS expand) took 7 hours to run (12.3) • Ue_01 updates this index.

  16. Z101- MGU01 - sort keys 1 & 2 02 z101_rec_key \ 03 doc_number ...000951094 03 sort_key .....01 02 z101_data \ 03 alpha ........L 03 text .........1970 02 z101_rec_key \ 03 doc_number ...000951094 03 sort_key .....02 02 z101_data \ 03 alpha ........L 03 text .........schuerger james

  17. Z101 - MGU01 - sort keys 3 & 4 02 z101_rec_key \ 03 doc_number ...000951094 03 sort_key .....03 02 z101_data \ 03 alpha ........L 03 text .........counseling for college choice 02 z101_rec_key \ 03 doc_number ...000951094 03 sort_key .....04 02 z101_data \ 03 alpha ........L 03 text .........lb#2342 s38

  18. www_server_defaults setenv www_sort_field "01---D02---A" setenv www_sort_field_ath "03---A01---D" setenv www_sort_field_aut "03---A01---D" setenv www_sort_field_sub "01---D02---A" setenv www_sort_field_crn "03---A01---D" setenv www_sort_field_cou "03---A01---D" setenv www_sort_field_coi "03---A01---D" setenv www_sort_field_inc "03---A01---D" setenv www_sort_field_ins "03---A01---D" setenv www_sort_field_dep "03---A01---D"

  19. pc_server_defaults setenv pc_sort_field "01 D02 A" setenv pc_sort_field_aut "03 A01 D" setenv pc_sort_field_ath "03 A01 D" setenv pc_sort_field_lca "04 A03 A" setenv pc_sort_field_shl "04 A03 A" setenv pc_sort_field_ttl "02 A01 D" setenv pc_sort_field_srs "03 A01 D" setenv pc_sort_field_trt "03 A01 D" setenv pc_sort_field_awt "03 A01 D" setenv pc_sort_field_pla "02 A01 D" setenv pc_sort_field_all "01 A02 A" setenv pc_sort_field_nam "01 A02 A" setenv pc_sort_field_top "01 A02 A" setenv pc_sort_field_geo "01 A02 A" setenv pc_sort_field_lcn "01 A02 A"

  20. www_sort_heading.eng • Used on the brief record screen (short_include-3), to describe how the keyword set has been (re)sorted: 01---D03---D Year, then Title 01---D02---A Year (latest first), then Author 02---A01---D Author, then Year (latest first) 02---A03---A Author, then Title 03---A01---D Title, then Year (latest first) 04---A02---A Call Number, then Author

  21. pc_tab_sear • On the brief record screen, the Sort button: SO MGU01 L Year 01 SO MGU01 L Call number 04 SO MGU01 L Author 02 SO MGU01 L Title 03 • Different for the authority library: SO MGU10 L Heading 01

  22. In Summary: • Based on your short views, assign sort key numbers • special filing? = tab01 & tab_filing • expanded fields? = tab_expand SORT-DOC • p_manage_27 • assign/describe default sorts, re-sorts • take a vacation before you start into item sorting!

More Related