Skip to content

Instantly share code, notes, and snippets.

Avatar

Simon Bowie SimonXIX

View GitHub Profile
@SimonXIX
SimonXIX / filter_and_save_to_new_workbook.bas
Last active Feb 18, 2021
Excel macro to filter a column and save filtered data to a new Excel file for each unique value
View filter_and_save_to_new_workbook.bas
Option Explicit
Sub filter()
Application.ScreenUpdating = False
Dim x As Range
Dim rng As Range
Dim rng1 As Range
Dim last As Long
Dim sht As String
Dim newBook As Excel.Workbook
@SimonXIX
SimonXIX / eprints_rest.php
Created Jul 26, 2019
Testing the EPrints RESTful API for Users
View eprints_rest.php
<?php
# @name: eprints_rest.php
# @version: 0.1
# @creation_date: 2019-07-22
# @license: The MIT License <https://opensource.org/licenses/MIT>
# @author: Simon Bowie <sb174@soas.ac.uk>
# @purpose: Testing the EPrints RESTful API
?>
<?php
@SimonXIX
SimonXIX / crossref_doi_checker.php
Last active Dec 3, 2018
Script to check a text file of DOIs (one per line with Unix EOLs) against the Crossref API
View crossref_doi_checker.php
<?php
# @name: crossref_doi_checker.php
# @version: 0.1
# @license: The MIT License (MIT) <https://mit-license.org/>
# @purpose: Checks a single text file of DOIs (one per line with Unix EOLs) against the Crossref API.
# Run as 'php crossref_doi_checker.php '$doi_file'' e.g. 'php crossref_doi_checker.php doi_file.txt'
# @author: Simon Bowie <simonxix@riseup.net>
# @acknowledgements:
# https://github.com/CrossRef/rest-api-doc
?>
@SimonXIX
SimonXIX / renew_items.php
Last active Oct 8, 2018
Script to renew checked-out items on the Open Library Environment ILS. Just for personal use.
View renew_items.php
<?php
# @name: renew_items.php
# @version: 0.3
# @creation_date: 2017-07-27
# @license: GNU General Public License version 3 (GPLv3) <https://www.gnu.org/licenses/gpl-3.0.en.html>
# @author: Simon Barron <sb174@soas.ac.uk>
# @purpose: Renew items for a user in OLE
?>
<?php
View keybase.md

Keybase proof

I hereby claim:

  • I am SimonXIX on github.
  • I am simonxix (https://keybase.io/simonxix) on keybase.
  • I have a public key whose fingerprint is E15F 30BB 89BE D472 22AB 631B 88AF ABD4 68C5 F7F5

To claim this, I am signing this object:

@SimonXIX
SimonXIX / new_books.php
Last active Oct 9, 2021
Script to display new books information direct from Ex Libris Alma Analytics. This is an early prototype for a web-displayable automated new books list.
View new_books.php
<?php
# @name: new_books.php
# @version: 0.2
# @license: GNU General Public License version 3 (GPLv3) <https://www.gnu.org/licenses/gpl-3.0.en.html>
# @purpose: Compile and display new books information for Imperial College Library
# @author: Simon Barron <s.barron@imperial.ac.uk>
# @acknowledgements: Based on a process by Ryan Edwards available at https://github.com/reedwards/automated-new-books-list
?>
<?php
@SimonXIX
SimonXIX / reading_lists.php
Last active May 15, 2017
Script to display real-time reading lists information from Ex Libris Alma / Leganto. This was a proof-of-concept of API integration for the Imperial College Business School's eventual integration with WordPress.
View reading_lists.php
<?php
# @name: reading_lists.php
# @version: 0.1
# @license: GNU General Public License version 3 (GPLv3) <https://www.gnu.org/licenses/gpl-3.0.en.html>
# @purpose: Display real-time reading lists information for Imperial College Library
# @author: Simon Barron <s.barron@imperial.ac.uk>
# @acknowledgements: Based on a script by Chris Keene available at https://gist.github.com/chriskeene
?>
<html>
<head>
@SimonXIX
SimonXIX / item_checker.php
Last active May 15, 2017
Script to display real-time availability of items in Ex Libris Alma. This was used as a proof-of-concept for a webpage to check the availability of borrowable laptops in LapSafe self-service laptop lockers. N.b.: only works on bibs with a single item record.
View item_checker.php
<?php
# @name: item_checker.php
# @version: 0.3
# @license: GNU General Public License version 3 (GPLv3) <https://www.gnu.org/licenses/gpl-3.0.en.html>
# @purpose: Display real-time availability information for laptops for loan at Imperial College London Library
# @author: Simon Barron <s.barron@imperial.ac.uk>
# @acknowledgements: Based on a script by Chris Keene available at https://gist.github.com/chriskeene
?>
<html>
<head>