Changes

Welcome to code4lib Code4Lib BC! Begun in Summer 2013, this chapter aims to create connections and professional development opportunities for folks from British Columbia and surrounding areas.

Begun If you're interested in Summer 2013hosting, this chapter aims to create connections and professional development opportunities for folks from British Columbia and surrounding areasplease [https://docs.google.com/document/d/1mh8haGBziQHiBkG_0byNgIEPxWIsBjKAXOss0cE9fJs/edit?usp=sharing take a read over our Planner's Guide].

== '''Code4lib Seventh Annual Code4Lib BC Unconference 20162019''' ==

'''[https://www.eventbrite.ca/e/2016-code4libbc-unconference-tickets-26429947685 Registration is now open]Thursday, 28 November and Friday, 29 November''' for Code4Lib BC's fourth annual unconference!

* December 1 This year's Code4Lib BC will be held on the North Shore of Metro Vancouver, and 2, 2016* Dodson Room, Irving Kjointly hosted by West Vancouver Memorial Library and Capilano University. Barber Learning Centre, UBC, The Thursday events will be held at the West Vancouver BC* [https://www.eventbriteMemorial Library.ca/e/2016-code4libbc-unconference-tickets-26429947685 Register now] ($30 for both days)* [https://gooFriday's activities will be held at Capilano University's main campus.gl/forms/YFrcIF4UpQRnj5eD3 Propose a lightning talk or breakout session]

The event will feature lightning talks in the mornings, breakout sessions in the afternoons, with coffee, tea and snacks provided. Lightning talks are brief presentations which are typically 10-15 minutes in length on topics related to library technologies. Breakout sessions are an opportunity to bring participants together in an ad hoc fashion for a short, yet sustained period of problem solving, software development and fun. If there is a neat project you're been working on, a cool new tool you want to show off, or an interesting development in the world of library technology that you want to discuss, Code4Lib BC is a great opportunity to share with the community - [https://goo.gl/forms/YFrcIF4UpQRnj5eD3 let us know about it]!

* '''What's included''': wifi, power, coffee/snacks, lunches, prizes.

* '''What's NOT included/what to bring''': a laptop, lunch (on-campus options [http://www.food.ubc.ca/feed-me/ here] and [http://www.ams.ubc.ca/foodanddrink/ here])dinner, your ideas and enthusiasm.

* '''Hashtag''': [https://twitter.com/search?f=tweets&vertical=default&q=%23c4lbc&src=typd #c4lbc]

* '''Code of Conduct''': As a Code4Lib event, we adhere to the [http://bit.ly/coc4lib Code4Lib Code of Conduct], which seeks to provide a welcoming, harassment-free environment. Need an ear ===Lightning Talk and Breakout Session Ideas=== Is there a neat project you've been working on, handa cool new tool you want to show off, or helpan interesting development in the world of library technology that you want to discuss? C4LBC helpers:  * [https://twitterdocs.google.com/therealarty @therealartyspreadsheets/d/16sFCWjhFYeiaGqU5BrFMEdEQVN7sORthMmnuQsWfVO8/edit?usp=sharing See what was submitted] (she ===Food/her) Transportation=== Do you have dietary restrictions? Let us know when you register. * [https://twitterwestvanlibrary.ca/visit/library/location-hours Bus and parking information for West Vancouver Memorial Library] or [https://g.page/WestVanLibrary?share Google Maps] * [https://www.capilanou.ca/about-capu/get-to-know-us/our-campuses/capu-main-campus/ Directions to Capilano University], [https://www.capilanou.ca/about-capu/get-to-know-us/our-campuses/parking-services/ Parking Services website] or [https://g.page/CapULibrary?share Google Maps] ===Accommodations=== * [https://www.pinnaclepierhotel.comPinnacle Hotel]: Rates start at $229.00/skrrrl @skrrrlnight. * [http://www.lonsdalequayhotel.com Lonsdale Hotel] : Rates start at $159.50/night (henon-refundable) or $206.25/himnight (refundable).

==== Thursday, December Day 1 ==== 

| 9:00 || Welcome & Announcementsand announcements

| 9:15 || Lightning Talkstalks * Icebreaker activity - Kevin Brash* [httphttps://162drive.243google.138.115com/BCPDLc4l.pdf Provincial Digital Library Updateopen?id=1vnMuq1M8cejj9QJHXZoUOm-sdkf_3Cpq Scraping index pages and VuFind implementation] (Daniel Sifton/Caroline Daniels)- Louise Brittain Boisvert* [https://githubdrive.google.com/terrywbrady/UsingAppScript Building Quick and Dirty Library Tools with open?id=1njuxu0CacJmVAq5NMwhdHgV8I--96lBe Blended learning in libraries: Google Apps ScriptIT Support Certificate Program at Surrey Libraries] (Terry Brady) - Erol Olcay* [https://docsdrive.google.com/presentation/d/18oBODopen?id=1ZLYro3HYm-KsRLz6uUoaLuqrsirN2TaK_W7ZgerE6qvB4Bc/edit Makerspaces and the Maker Community in the Lower MainlandGwvJqR1WF5vsGCFkIuA5I4 Implementing an IT service desk!] (Maryann Kempthorne)- Tamarack Hockin / Jason Swan* Web Analytics with Piwik (Jonathan Schatz)[https://drive.google.com/open?id=1MufAHe5_MkWL00VOFQUAXjAUDDWYGP1J Ditch Deep Freeze: Public computer administration for small libraries] - Camille Ginnever

| 10:30 || Coffee breakBreak

| 10:45 || Lightning Talks, cont'd* TechBC Memory Project metadata upgrade talks (Holly Hendrigancontinued)* ElasticSearch API: Using Aggregation Queries to Do Cool Stuff (Schuyler Lindberg)Authorities cleanup - Trevor Smith* [https://cynngcynthiang.wordpress.comca/20162019/1211/0128/code4libbc-presentation-gettingimplementing-thingsvalues-donein-discovering-efficienciespractical-ways/ Implementing values inpractical ways] -workflowCynthia Ng* [https:/ Getting Things Done/drive.google.com/open?id=1t6qvxSigLpvTz-k1mlKVd6Dm4amE6tyJ Tell Your Story: Understanding Ebook creation for 11-14] - Patricia Lesku* [https://drive.google.com/open?id=1CcB77MvBCDTnJVeH2AqhZCIFlRMbyRM1 JavaScript and Analyzing WorkflowCSS elements in circulation notices: A dilettante's perspective] (Cynthia Ng)- Olga Kalachinskaya* Introduction to FOLIO (Andrew Nagy)[https://drive.google.com/open?id=1H0V21mhKmVQJiN2tN9d-McM7h4EEAPh1 Ebook Ordering: How we expanded our collection with intentional ordering] - Michelle Yule

| 1112:30 00 || Lunch (On Your Ownprovided)

| 1:00 || Breakout Sessionssessions * The Lab Learning Space at WVML - Andrea Tartaglio / Patricia Lesku* [https://docs.google.com/presentationdocument/d/1NK7DS1hZ9f-6D1PPr9acZdXwLjLCq76ALdjN-PFxmov8OTgU7aZbgH00Iv0CAuI8quRot47zEEvlwzMErx1J5E/edit#slide?usp=id.p Intro to git/github for librariessharing Implementing values] (Sara Romkey/Mark Jordan/Holly Becker)* PDL technologies up close (Daniel Sifton)- Cynthia Ng

| 2:45 || Breakout Sessions, cont'd* FOLIO workshop sessions (Andrew Nagycontinued)* Digital Collections (Terry Brady)Blended learning in libraries - Erol Olcay* Intranets

| 4:15 00 || Breakout Reportsreports

| 5:00 || Social Event at event* [https://docsgoo.google.com/document/dgl/1quffBt9Lx5ljEoBQc3jSUmzqZ1neV29ncsVzJ5ixDaUmaps/edit (new) Pit Pub6KsoUh8XsAXp6ABm8 mahony | Burrard Landing]* Karaoke!

==== Friday, December Day 2 ==== 

| 9:15 || Lightning Talkstalks* A Coal Miner’s History[https: Mapping Digitized Audio Interviews (Daniel Sifton)//drive.google.com/open?id=1B_BZrrvodFzX59YKsMWI1nnSG9TccGEH Code club for seniors] - Dethe Elza* Introduction to Docker ([https://docs.google.com/presentation/d/1__219rDiKi9R548yzi82eu0pCrhdZtW9JkcQFmDh4KA/edit?usp=sharing A review of open-source ERM options in 2019] - James Fournie)* Makers Making Change (Chad Leaman)[https://drive.google.com/open?id=1ulI2iQiRYr5HJ2esztmF7pUDEukFw0EU_YKB9sl9RgQ Organizing Ideas podcast] - Allison Jones / Karen Ng* DokuWiki - Scott Leslie* [https://docs.google.com/presentation/d/1UCs7FL17EwYZKpYa12W20xrbC2sySZXiCTY0sNqOxNIe/edit MediaConch2PACX-1vS17QDbMx-poI_m8dsoVRoxN-UIUbvzcKTFEruo4ylQmlpRPralHB2SjJhoJ5LnwBUYLCCYJzyGQ9wL/pub?start=false&loop=false&delayms=15000#slide=id.p Fair and FAIR data sharing in the Global South] + [https: A Video Format Validation Tool for Archivematica//public.tableau.com/profile/alicia1500#!/vizhome/Slidescode4lib/RDAMembers?publish=yes Tableau Visualization] (Sarah Romkey)- Alicia Urquidi 

| 10:30 || Coffee breakBreak

| 10:45 || Lightning Talks, cont'd* A Single Page Web App to Inventory 900,000 Books! talks (Terry Bradycontinued)* UX Design of a Research Data Management MicroRefDesk Dashboard for Springshare data -site (Jessica Gallinger)Trevor Smith* Islandora On This Day module (Mark Jordan)[https://drive.google.com/open?id=1ISFhhYZhVzKs17GkEDV_ca-ukymWKlOY Implementing OpenAthens for eResource authentication] - Hillary Webb* [https://drive.google.com/open?id=1kmk1jYzeqIKLkd0PpVars6LUIRdoVOAFLDf40L-hb3s Telling library stories with Tableau] - Tania Alekson* Privacy-protecting technologies - Camille Ginnever

| 1112:30 00 || Lunch (On Your Ownprovided)* Wraps: Chicken Caesar; Hummus and Veggie; Mediterranean Beef and Feta; Italian Milano; California Chicken and Tuna Salad; Egg Salad* Mediterranean Pita Chip Platter 

| 1:00 || Breakout Sessionssessions* Needling The Haystack: An Introduction to SQL and Query Languages (Alex Garnett)Web archiving - Dana McFarland* reSearcher (CUFTS/GODOT) and project sustainabilityProject management - Trevor Smith 

| 2:45 || Breakout Sessions, cont'dsessions (continued)* Using Islandora Establishing a code club for Publishing XML (Michael Joyce)adults/seniors - Dethe Elza* Awesome Excel Tips (Trevor Smith)Who wants to host Code4Lib BC in 2020?

| 4:00 || Breakout Reportsreports

| 45:30 00 || End of DayMeet up at [https://goo.gl/maps/K4xetNSFzyVKB1cv5 Coach House Lounge]

=== Program Sponsors === Alphabetical by presenter/facilitator. ==== Lightning Talks ==== ''Defining Projects using Gherkin Syntax'', Sara Allain, Artefactual* The team at Artefactual has recently started using Gherkin, a human-readable syntax for defining software feature acceptance tests, in select software development projects. In this lightning talk, Sara will show how Gherkin acceptance tests are developed and how they're used by both end-users and developers. ''Building Quick and Dirty Library Tools with Google Apps Script'', Terry Brady, Georgetown University* The ubiquity of Google Drive solves many problems (file sharing, web publishing, bulk editing) that are cumbersome to build in a home-grown application. With a little bit of JavaScript magic, you can build a custom solution on top of the Google Apps your users use every day. See http://georgetown-university-libraries.github.io/#google-sheets for some examples. Google Apps Script is a server-side implementation of JavaScript supporting API calls to Google Services. This presentation will describe the various ways that your custom code can be deployed for a library audience (formula function, embedded in a document, web service, document add-on). ''A Single Page Web App to Inventory 900,000 Books!'', Terry Brady, Georgetown University* After completing a reorganization of our stacks, the Georgetown University Library needs to perform an inventory of 900,000 books within our stacks. This project needs to be completed before migrating our catalog to a new ILS (integrated library system) vendor in 2017.* The Georgetown University Library has developed an application that allows student workers with a barcode scanner and a Chromebook to rapidly move through the stacks and scan each item. The tool queries the ILS database to verify the item's status and location, while allowing the user to verify the Title, Call Number and Volume of each item. The tool will also highlight call number sorting errors with each scan.* This presentation will describe the solution that we have developed and the challenges that were overcome during the project. The code (and a video demonstration of the project) are available at https://github.com/Georgetown-University-Libraries/BarcodeInventory. ''Introduction to Docker'', James Fournie, VCC* Docker is an open-source application container engine that is taking the IT world by storm. James will introduce you to Docker -- what Docker is and isn't and how Docker might help you or your organization write or deploy software. ''TechBC Memory Project metadata upgrade'', Holly Hendrigan* Holly will provide an update to the TechBC Memory Project, her oral history project that has undergone a substantial makeover since last December's Code4Lib. She will tell the story of all the moving parts that came together when the collection migrated to SFU Library's Digital Collections. ''UX Design of a Research Data Management Micro-site'', Jessica Gallinger, SFU* The SFU Library is creating new web content to help researchers manage their data. Receive a whirlwind tour of the UX methods (personas, interviews, prototyping, user testing, etc.) applied to design an effective micro-site around the needs of the end user. A high-fidelity prototype in InVision will be demoed.  ''Islandora On This Day module'', Mark Jordan, SFU ''Makerspaces and the Maker Community in the Lower Mainland'', Maryann Kempthorne ''Makers Making Change'', Chad Leaman, Neil Squire Society* Makers Making Change, a community based initiative that links makers, volunteers with technical skills, with people with disabilities with the goal of making affordable, open source assistive technolgies for those people with disabilities centered around community resources such as 3D printers in libraries and maker spaces. ''ElasticSearch API: Using Aggregation Queries to Do Cool Stuff'', Schuyler Lindberg, UBC ''Getting Things Done: Understanding and Analyzing Workflow'', Cynthia Ng* How does work move through your organization? Does the order make sense? How many times is it passed on? How many people is it handled by? Do all the steps still need to done in the current work environment? This presentation provides some suggestions on methods to understand and analyze workflow using technical services as an example, but which can be applied in other areas. ''MediaConch: A Video Format Validation Tool for Archivematica'', Sarah Romkey, Artefactual* MediaConch is a new tool for validating preservation video files. In this presentation, Sarah will talk about how we're integrating this tool into Archivematica, an open-source digital preservation system, and how Artefactual Systems approached this development project. ''Web Analytics with Piwik'', Jonathan Schatz, BC Libraries Cooperative ''A Coal Miner’s History: Mapping Digitized Audio Interviews'', Daniel Sifton, VIU* Leveraging skills we developed in an earlier mapping project, we're using a rich set data from our Dspace instance to map the spoken word in the form of conversations [both audio and transcripts] about coal mines from the years 1900 – 1945 in and around the city of Nanaimo. ''Provincial Digital Library Update'', Daniel Sifton and Caroline Daniels* A brief overview of strategies, efforts, and technologies regarding the BC Provincial Digital Library. ==== Breakout Sessions ==== ''Intro to git/github for libraries'', Sara Allain and Mark Jordan* A hands-on introduction to git, GitHub, and their potential uses in the library environment. ''Digital Collections'', Terry Brady, Georgetown University* A group discussion. ''reSearcher (CUFTS/GODOT) and project sustainability'', Jeff Davis* SFU has discontinued support for CUFTS/ERM, GODOT, and the CUFTS knowledgebase. This breakout will be a group discussion about what happens next. ''Needling The Haystack: An Introduction to SQL and Query Languages'', Alex Garnett, SFU* Have you ever thought to yourself, "western nations seem powerless to defend against the creeping tide of fascism, but at least I know how to search within a database real well, as if that makes anything OK?"* Good news -- now you can! This workshop will provide an introduction to SQL and related query languages for people who have little to no experience using modern database backends. We'll discuss the differences in difference SQL implementations, how to efficiently retrieve data from already-existing databases that you might encounter in your job, and hopefully demystify some general concepts of querying. If you've ever had a graphical database design course, so much the better; we'll be trying to supplement but not rehash those concepts. Please bring your own laptop. ''Using Islandora for Publishing XML'', Michael Joyce, SFU* Islandora is well known in the library community as a digital repository. At Simon Fraser University we have been experimenting with it as a publishing platform for XML. Instead of simply presenting an XML file in the browser, we transform it to HTML for display. In this breakout session, we will examine the code for two projects: the TechBC Memory Project, a collection of oral histories, and a text transcription of Lyrical Ballads by Wordsworth and Coleridge.

''FOLIO''While Code4Lib BC no longer solicits sponsorship, Andrew Nagy, EBSCO* An introduction we want to [httpsacknowledge the contributions of://www.folio.org/ FOLIO], a project to develop an open source Library Services Platform.

''Provincial Digital * [https://westvanlibrary.ca/ West Vancouver Memorial Library Technologies Up Close'', Daniel Sifton, VIU]* An in depth demo of the harvesting[https:/mapping/ingestion process in both the DPLA technology stack and in SuppleJack (from DigitalNZ) for consideration in a BC-PDL environmentlibrary. Note, attendees will have an opportunity to explore the interfaces where they exist and where possible, but will not be interacting with these platforms at the command levelcapilanou. If you want to do this, however, this session might be a good place to get an understanding of the hidden pieces. To paraphrase Tom Vu, "Come to ca/ Capilano University]* [thishttps://nvdpl.ca/ North Vancouver District Public Library] seminar!"

''Awesome Excel Tips'', Trevor Smith* Want to wrangle your data into submission either for collection management or budgeting? Learn how to use Pivot Tables, VLOOKUPs, advanced queries, or even a dashboard all inside Excelas well as continued administrative and fiscal support from the [https://bc.libraries.coop/ BC Libraries Cooperative].

=== 2019 Organizers ===

* Sara AllainKevin Brash* Jeff DavisMichel Castagné* James FournieGlen Greenly* Tamarack HockinMaryann Kempthorne* Mark JordanPatricia Lesku* Paul JosephJennifer O'Donnell* Cynthia NgFiacre O'Duinn* Andrea Tartaglio