NWIUG 2003
Exporting and Manipulating Data


List some of the Data - Millennium

  • Always sort your list first!
  • Print up to 30 selected fields
  • In Millennium, the List Records option is more distinct than in text
  • In Millennium, you cannot "limit set" related to criteria
    If you want different lists for videos, books, government documents, etc., sort by Mat Type, ITYPE, or the distinguishing field on your system, then by Call#, Title, or whatever order you want to display your list. Then extract title, author, publisher, etc., and either limit to the record numbers for each subset, or export all the data and break it up in your editor.
  • STEPS
    1. Set printer to email as first step!
    2. Select your list and choose "List Records"
    3. Specify fields to print
    4. Specify the page layout from the same screen including
      • whether variable length fields begin on new lines,
      • number of blank lines between records
      • page heading
    5. Print your list to email
    6. Save your email as a file
    7. Open your file in application of choice and manipulate until it looks like you want!
Process example (Millennium version)