An instructive example using an interactive table

  1. Data transcribed and maintained by Librarian in a Word Table or any spreadsheet (Excel, Google Sheets, etc.) and exported to a CSV data file.
  2. Data file uploaded by Webmaster to TablePress (a Word Press plugin). This step could even be automated if a cloud-based spreadsheet like Google Sheets is used for data uptake and maintenance.
  3. Table (or new one) is instantly displayed on the HSRP > Library webpage!
  4. Time to complete tasks 2+3 is <5 minutes.
  5. Cost, nil!
  6. The resulting online table will be “responsive” which is to say it adapts to small screens, e.g. on your tablet or telefonino.
  7. A database system as such would be overkill for our purposes, given the small data file size and its lack of complexity.
  8. I strongly advise against developing and maintaining a catalogue of scores using a library system, least of all one as arcane as Librarika. Nobody wants the trouble of feeding and watering such a system. It is inappropriate to the scope of our dataset and the needs of our audience.
  9. Amongst the advantages of the approach I illustrate below is separation of the tasks of (1) assembling and managing the data, and (2) making it visible to our members online in something as intuitive to use as a moderately intelligent interactive table. The latter task (2) really is trivial; the former (1) is demanding and time-consuming, but it is here that HSRP should put its time and effort.
  10. Transcribing our current library data into a familiar spreadsheet, rigorously formatting its content against a set of well-formulated standards, is a tedious business, to be sure, but it only needs doing once! Thereafter, incorporating new items would simply involve the Librarian entering them into the spreadsheet and forwarding a copy to the Webmaster. This is well within the abilities of present and future HSRP members.

I invite you to play with the following prototype!

  1. Start by filtering out a few columns you might not want to see by clicking on the Column Visibility button
  2. Try clicking off some of the data fields, e.g. Key, Format, Pages, Place, Series Editor, Contributor; then click somewhere on the table itself
  3. Try clicking on one of the output buttons: e.g. Excel
  4. Try Sorting on a column by clicking its title, e.g. Composer
  5. Try a Search on any term, e.g. Flowers. Yes, someone really did compose a collection of 25 musical pieces descriptive of angiosperm species, L’Amarante, La Tulipe, La Jacinte, La Violette, etc.!
  6. Try Searching items for SAT recorders
  7. Try Searching with H4 to locate works in 4 parts by composers whose family names commence with H
  8. You deserve a pastis, after that workout!

KeyFormatComposerTitleMediaOriginal DatePublication DatePages (score)PublisherPlaceArchiveInstrumentationNotesEditorSeries EditorContributor
XFLQFIE5score & partsBaines, Francis AthelstanQuartet for RecordersPalisander196011SchottLondonB6AATT
JKR9HQ3FscorePlayford, JohnDances from Playford University of Georgia Musicum Collegium Recorder Ensemble.1651194918SchottLondonP3Meech, Michael
C56GJ29LscoreVariousDeutsche Meister des Barocks [German Masters of the Baroque Era]17–18th century195523SchottMainzH3 H4Hillemann, Willi
GHKNKLTHscore (photocopy)Giovane da Nola, Joan Domenico delFive Carnival Songs of the Sixteenth CenturyOpia154119566Associated Music PublishersNew YorkV3SSA SST SAA SATThese are canzoni villanesche (Neapolitan love songs) rather than (Florentine) canti carnascialeschi (Forentine carnival songs)Davenport, LaNue
M88ABF9Qscore & partsFricker, Peter RacineSuite for Three RecordersOpia19567Schott, for Society of Recorder PlayersLondonF3AAT
CDNE4VUTscore & partsHindemith, PaulTrio for Recorders From the Plöner Musiktag. Edition for recorders in C and FHidehiro Nakamura193219528SchottLondonH3SATBergmann, Walter
IVQCJVPYscoreTraditionalYugoslav Folkdances for Recorder Trio195624SchottLondonA3Allen, W. Stannard (Wiliam Stannard)
IYSZ3ILDscoreMonteverdi, ClaudioAngelus ad pastores ait. Christmas Motet for Three Voiceshere158219362SchottLondonM3Fellerer, K. Gustav (Karl Gustav)
596N5C3HscoreSmith, Roy HeatonSerenade Op. 35 for Recorder TrioAndré Le Gall19557SchottLondonS3SAT
8WZDXJY8scoreMeech, MichaelTwo Pieces19498SchottM4SSTT
36PUC8Z7scoreVariousSuite of Five Pieces from The Compleat Flute Master170019484Schott, for Society of Recorder PlayersLondonD2Dolmetsch, Carl Frederick; Hunt, Edgar Hubert
X2SH2YQCscoreHolborne, AntonyTwo fantasias for three recorders from The Cittharn SchooleFlautadors159719485SchottLondonH3Dart, Robert Thurston
VGSAXE4DscoreStaeps, Hans UlrichReihe kleiner Duette für zwei Altoblockflöten [A series of short duets for two alto recorders]André Le Gall1950SchottLondonS2AA
NHGGMUHYscoreVariousSchool Flute Tunes194064Allan & Co.MelbourneA4AAT ATT AATB AATT Hall, Anthony
FJNHJWTUscore & partsTelemann, Georg PhilippDrei Sonaten für Drei Altblockflöten [Three sonatas for three alto recorders]1738–1742198839AmadeusWinterthurT3AAAMichel, Winfried; Paüler, Berhard
QGVWDV9KscoreQuantz, Johann JoachimSechs Duette für Zwei Altblockflöten [Six duets for two alto recorders]. Vol. 1Kan Saito1759198223AmadeusWinterthurQ2AAPaüler, Berhard
YDQYG23BscoreQuantz, Johann JoachimSechs Duette für Zwei Altblockflöten [Six duets for two alto recorders]. Vol. 2Kan Saito1759198224AmadeusWinterthurQ2AAPaüler, Berhard
H7EBW3C9score Delavigne, PhilibertLes Fleurs [The Flowers]. Pièces pour les Musettes ou Vielles, avec accompagnement de Viol ou de Flûte op. 4Le Berger Fortune18th century197616AmadeusWinterthurD2AA ATKolneder, Walter
RMAPDTF7scoreDelavigne, PhilibertLes Fleurs [The Flowers]. Pièces pour les Musettes ou Vielles, avec accompagnement de Viol ou de Flûte op. 4Le Berger Fortune18th century197615AmadeusWinterthurD2AA ATKolneder, Walter

Tools I used (all free- or donation-ware)

  • CSVEdit, to create the data upload file. Excel, Google Sheets, your favourite word processor or even Notepad would do just as well!
  • Wikipedia, to check composer & editor details, etc.
  • WordPress, the open-source content management system used on the server that hosts my website & the HSRP site
  • TablePress (a WordPress plugin), to upload the data file to my website & configure the online table’s layout, appearance & behaviour.
  • TablePress Extensions: Responsive Tables, DataTableButtons.
  • Google Chrome (internet browser).

 

 

Cite this article as: Lander, Nicholas S. 1996–2022. Recorder Home Page: HSRP Library Catalogue Prototype. Last accessed 3 October 2022. https://www.recorderhomepage.net/hsrp-library-catalogue-prototype/