Printing from Apple OS: font size too small

Had a patron trying to print out a document in 12 point font, but printout was way too small, it turns out SCALE was less than 100% so it was shrinking everything.






Click on PAGE SETUP button, bottom left.


Make sure SCALE is 100%

SQL to Query Duplicate Titles from different locations

In an Innovative Interfaces OPAC, here is discussion on getting duplicates:

Aim to get duplicate titles from one specific record load rather than all duplicates in the database, I begin with a nested subquery that limits the selection to bib records that were created on a specific date. You will need to change the date to the date of your problem record load.

Since it is E-books that you are concerned about, I have limited the selection based on material type code (Bcode2). You'll need to change that to a correct E-book code for your system.

Rather than limit by item location code, I chose to limit by bib location. You'll need to change that too.

I included a match on ISBN. Where there are multiple ISBNs in a single record, there will be multiple references in the output, one for each Title/ISBN pair. I have been warned in the past that the phrase_entry view may not persist or may change. There are other ways of getting to the ISBN which may be safer in the long run.

-- =========================================================================

-- Duplicate E-book titles from specified load date

-- Brent Searle. Langara College. 2015-03-04

-- =========================================================================

SELECT

   bib.title                                     AS "Title",

   phrase.index_entry                            AS "ISBN",

   COUNT(*)                                      AS "Count"

FROM

   sierra_view.bib_view AS bib

JOIN

   sierra_view.bib_record_location               AS bibloc

ON

   bibloc.bib_record_id = bib.id

JOIN

   sierra_view.phrase_entry                      AS phrase

ON

   phrase.record_id = bib.id

WHERE

   bib.title IN

   (

     SELECT

       title

     FROM

       sierra_view.bib_view

     WHERE

       DATE(record_creation_date_gmt) = '2015-01-23'-- Date of E-book load

   )

   AND

   bib.bcode2 = 'd'                                -- E-book

   AND

   bibloc.location_code = 'le'                     -- Langara Electronic Resource

   AND

   phrase.index_tag = 'i'                          -- Standard Number Index

GROUP BY 1,2

HAVING COUNT(*) > 1                               -- Include only duplicates

ORDER BY 1,2

;

This may be not at all what you were looking for but I hope it helps some.

--

Brent Searle

Outlook autocomplete file (.nk2)

Have a patron getting new computer, want to move autocomplete file (thing that gives you email address after 2-3 letters) to different PC:  (Windows Windows 7 and Vista)


On your old computer:

• Go to drive:\user\AppData\Local\Microsoft\Outlook.
  

1. Right-click profile name.nk2, and then click Copy.
   
   
2. On the computer where you want to populate the AutoComplete list:
   
   • Windows 7 and Windows Vista     Right-click anywhere in drive:\user\AppData\Local\Microsoft\Outlook and then click Paste to save profile name.nk2.
     
3. If the Outlook user profile name is different on the computer where you are moving the .nk2 file, you must rename the file with the Outlook user profile name that is being used on the new computer, after you copy the file to the correct folder. For example, if you move Kim Akers.nk2 from the original computer with an Outlook user profile name of Kim Akers, and you copy the Kim Akers.nk2 file to the new computer, you must rename the file with the Outlook profile name that is being used on the new computer.
   
4. When prompted about replacing the existing file, click Yes.
   
5. Open Outlook to view the changes to the AutoComplete list.
   

MS Office.com

Sierra client not running

If the III Sierra client does not open, this was one fix:

> One person was using Sierra this morning with no problems. He closed

> out of Sierra and then couldn't get back in. The icon shows up on the

> navigation bar but nothing happens. I've tried uninstalling and

> installing it several times, restarting the computer, cleared the

> jarcache, but nothing is working. He's on Windows 7 and nothing on his

> computer has changed since this morning.

When the icon appears in the taskbar, but the client won't load, I've had good luck with deleting this file:

%USERPROFILE%\AppData\Local\Temp\SierraDesktopApp.obj

(Where %USERPROFILE% is current user's profile directory, usually under c:\Users\)

On stations where it's become a recurring issue, I change the shortcut to point at a batch file that deletes that file first and then launches the client.

HTH,

David

--

David Jones

Library Systems Manager

University Library

Santa Clara University

500 El Camino Real

Santa Clara CA 95053-05

SQL for holds in ILS

From Sierra Listserv,  post by Andrew Hollingsworth

To get the equivalent you'd need to join at least 8 views. I was working on something similar last year and will include what I had. You'll need to possibly edit it for volumes. I also left out the patron email in the query I used because our var view is just too large. You might have to include a CASE statement for the email. 

Select Distinct

  h.placed_gmt,

  h.expires_gmt,

  prfn.last_name,

  prfn.first_name,

  prfn.middle_name,

  p.record_num,

  prp.phone_number,

  b.title,

  i.call_number_norm,

  h.location_code,

  h.pickup_location_code,

  h.status

From

  sierra_view.hold h Inner Join

  sierra_view.patron_view p On h.patron_record_id = p.id Inner Join

  sierra_view.patron_record_fullname prfn On prfn.patron_record_id = p.id

  Inner Join

  sierra_view.patron_record_phone prp On prfn.patron_record_id =

    prp.patron_record_id Inner Join

  sierra_view.bib_view b On h.record_id = b.id Inner Join

  sierra_view.bib_record_item_record_link birl On b.id = birl.bib_record_id

  Inner Join

  sierra_view.item_record_property i On birl.item_record_id = i.item_record_id