Patron email via SQL - Innovative ILS

This only returns records if email exists:  (From Sierra Listserv, David Noe)

SELECT svv.field_content,

svn.last_name,

svn.first_name

FROM sierra_view.patron_record svp

LEFT JOIN sierra_view.record_metadata svm ON svp.id=svm.id

LEFT JOIN  sierra_view.varfield svv

ON  svp.record_id = svv.record_id

LEFT JOIN sierra_view.patron_record_fullname svn ON  svp.record_id = svn.patron_record_id

WHERE svm.record_type_code='p'

AND svv.varfield_type_code = 'z';

-----------------------------------

This returns all patrons, even if email is blank:


In our system, the patron's email is in varfield z.  This can be joined to the patron view. Here's an example where we're looking for patrons with incorrectly formatted email addresses:

SELECT
  v.home_library_code AS "home_agency",
  'p' || v.record_num ||'a' AS "patron_no",
  n.first_name,
  n.last_name,
  RTRIM (e.field_content) AS "email"

FROM
   sierra_view.patron_record p
  JOIN sierra_view.patron_view v ON p.id = v.id
  JOIN sierra_view.patron_record_fullname n ON p.id = n.patron_record_id
  LEFT JOIN sierra_view.varfield e ON e.record_id = p.id AND e.varfield_type_code = 'z'

Gerri Moeller

SQL to get list of patrons who have records checked out

From Sierra listserv, Pam Childers

SELECT
  p.record_num          AS "patron_record",
  max(n.last_name)      AS "last_name",
  max(n.first_name)     AS "first_name",
  p.checkout_count           AS "checkout_count",
  substring(p.barcode,7,7)             AS "iwu_id",
  s.content             AS "email_address"
FROM sierra_view.patron_view p
 JOIN sierra_view.patron_record_fullname n
     ON n.patron_record_id = p.id
 JOIN sierra_view.subfield_view s         
    ON s.record_num = p.record_num
WHERE
  p.ptype_code = 0
  AND s.field_type_code = 'z'
  AND s.record_type_code = 'p'
  AND p.expiration_date_gmt > current_date
  AND p.checkout_count > 0
GROUP BY p.record_num, last_name, first_name, p.barcode, s.content, p.checkout_count ORDER BY last_name, first_name

Apple Wifi signal tools

From   OsxDaily

Wi-Fi Diagnostics is an incredibly useful utility to troubleshoot and optimize any wireless network and the signal strength of computers that are connecting to it. This utility first came bundled in Mac OS X Lion and works with all wireless routers and not only the Apple branded ones, meaning you can improve the performance of just about any wifi network by using it and making some adjustments along the way. It’s easy to use and we’ll walk you through the process of getting the best wireless signal using the app, but first we have to uncover the tool itself.

The Wi-Fi Diagnostics app is buried within Mac OS X 10.7 & OS X 10.8, here’s how to access it:

• From the OS X desktop, hit Command+Shift+G and enter the following path:
/System/Library/CoreServices/
• Sort alphabetically and find “Wi-Fi Diagnostics”, if you plan to use the app even somewhat frequently it’s recommended to drag Wi-Fi Diagnostics into Launchpad for easy access

With Wi-Fi Diagnostics now in the easier to access Launchpad… open Wi-Fi Diagnostics.app, then:

• For OS X Lion users, check the radiobox next to “Monitor wireless performance” then click on the “Continue” button
• For OS X Mountain Lion (and later) users, pull down the “View” menu and choose “Performance”, or just hit Command+5

Why Apple changed the process between OS X 10.7 and 10.8 is a mystery, but the feature remains in the newest versions of Mac OS X regardless.

Digital signatures in Adobe PDF

Using Acrobat Reader:

Sign a document (Reader 10.1.3)

In Reader 10.1.3, you can type your name, draw your signature, or place an image of your signature on a document. You can also add text, such as your name, company, title, or the date. When your document is complete, the signature becomes part of the PDF.

1. Open the PDF you want to sign.
2. Click the Sign icon in the toolbar to open the Sign pane.
   

   If the Sign icon is not in the toolbar, right-click the toolbar, and choose File > Add Text or Signature.
3. To add text, such as your name, company, or title, click Add Text in the I Need To Sign panel. Click in the document where you want to add the text, and type.
   
   

   Add Text option lets you add your name, company, or date to the PDF.
4. In the Sign pane, click Place Signature.
   

http://help.adobe.com/en_US/reader/using/WS82af097c4236e2eb3543853d130e391c674-8000.html

Excel Power Map add-in

Directions:


Microsoft Power Map for Excel 2013 is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways.

With Power Map, you can plot geographic and temporal data on a 3-D globe, show it over time, and create visual tours you can share with other people.

• Map data    Plot more than a million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel.

• Discover insights    Gain new understandings by viewing your data in geographic space and seeing time-stamped data change over time.
• Share stories    Capture screenshots and build cinematic, guided video tours you can share broadly, engaging audiences like never before. 

You’ll find the Map button in the Tours group on the Insert tab of the Excel ribbon, as shown in this picture.

Download:
http://www.microsoft.com/en-us/download/details.aspx?id=38395