Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Library Home
Chatham's COVID-19 informational website
Archives COVID-19 Collection Project
  | | Click to open/download a PDF of Full Library Calendar in a new window2021-22 Calendar




EDS Bibliographic (5 seconds human ; 20-40 min. computer processing time) Illiad Patron (45-60 seconds human processing time)

EDS (weekly) -

  • Koha;
    • export mrc
  • FTP
    • Full
1) Receive Email Attachment
  • Save As [local file]
  • Open IlliadPatronWorkspaceME.xsls 
  • Import into new worksheet
    • Get Data
    • Edit
  • Change format in ID col to TEXT
    • Close & Load
  • Select & Copy up to header
    • Paste into new dated (with today's date) worksheet
    • Activate Macros: Ctrl+PUGS
2) Open IlliadPatronWorkspace.xsls (non-macro page)
  • remove header from template
  • Paste cols from ME-dated into non-ME sheet cols
  • Paste header back in
  • Select and Copy from bottom right, from inside yellow band on the right, up to the top
3) Paste into Notepad
  • Find & Replace [tab] spaces with ###
  • Fix top row to reflect ###
  • Count bottom span of last name - should equal 18 #s
  • Find & Replace double-spaces with single spaces until finished
  • Save as "UserValidation.txt"
4) FTP to /illiad/import
MarcEdit (as needed)  


Perif pages


    Visit us on Instagram    Listen to our playlists on Spotify   Visit us on YouTube Visit us on Twitter

Jennie King Mellon Library | 0 Woodland Road | Pittsburgh, PA 15232 | 412-365-1670 | Maps & Directions | Site map

Chatham Home