Skip to main content

Aleph@UF: Create a Spreadsheet from Print-08

Cataloging procedures and policies

Create a Spreadsheet from Print-08

Create a spreadsheet from Print-08

 

Copy system numbers from Excel to Notepad

Save with lowercase name (dashes are okay)

Run Macro Express: Cataloging -> other -> prep_sysnums_only -> (choose BIB, etc)

Log onto Aleph Staff Menu for Report: https://reptsusopac.flvc.org/cgi-bin/afv

  • Step 1:         Logon with Aleph user name/password
  • Step 2:         Upload (bottom of page)
  • Choose: alephe/scratch
  • Browse to file -> Upload

Open Aleph Report -> Cataloging

  • Under Services -> Retrieve Catalog Records -> Print Catalog Records… (print-08)
  • Copy file name from Staff Menu into form
  • Give file a new name (add “-out” to end)
  • Choose columns for result and Submit
  • Open Task Manager -> File List
  • Move finished report to local computer from remote server using up arrow

Use Windows Explorer to retrieve file

Local Disk (C) -> AL500_SBUFREPT -> Catalog -> files -> UXU01 -> print

Open file in Notepad

  • Remove first two lines:
    • ## - XML_XSL
    • <?xml version=”1.0”?>
  • Save file with .xml extension

Open Excel and “open” the .xml file

  • Rename column headers and remove extraneous columns
  • Use: Data -> Text to columns … to break out merged information
  • Copy all rows but headers into new Excel spreadsheet if desired
  • Be sure to format columns as Text to keep lead zeros on System #s
University of Florida Home Page

This page uses Google Analytics - (Google Privacy Policy)

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.