2019-12-09 Reporting SIG Meeting notes

Sharon Beltaine

Cornell University

Sara Colglazier

Mount Holyoke College/Five Colleges

Elizabeth Berney

Duke University

Erin Nettifee

Duke University

Joyce Chapman

Duke University

Karen Newbery

Duke University

Jean Pajerek

Cornell University

Tod Olson

University of Chicago

Claudius Herkt-Januschek

SUB Hamburg

Scott Perry

University of Chicago

Doreen Herold

Lehigh University

Stefan Stadtherr

MPIL Heidelberg

Anne L. Highsmith

Texas A&M

Simona Tabacaru

Texas A&M

Harry Kaplanian

EBSCO

Kevin Walker

The University of Alabama

Ingolf Kuss

hbz

Charlotte Whitt

Index Data

Lina Lakhia

SOAS

Andi Bihler

Munich Technical University Library

Joanne Leary

Cornell University

Uschi Klute

GBV

Michael Patrick

The University of Alabama

Vandana Shah

Cornell University

Nassib Nassar

Index Data

Angela Zoss

Duke University

Veit Köppen

University Magdeburg

Lisa DeCarolis

Smith College/Five Colleges

Linda Miller

Cornell University

Elena O'Malley

Emerson

Matt Harrington

Duke University

Holly Mistlebauer

Cornell University

Jean Pajerek

Cornell University

Nancy Bolduc

Cornell University

Margaret Briand Wolfe

Boston College

Eric Pennington

Texas A&M

Sarah Park

Duke University

Christie Thomas

University of Chicago

Attendance

Sharon

Today's Attendance Taker: Linda Miller

Today's notetaker:  Vandana Shah

Last week's notetaker: Sharon Beltaine

Updates from Various Reporting Related Groups and Efforts

Various

The Reporting SIG is using small work groups to address priorities and complete our work. Each week, we will provide updates to the Reporting SIG from these various reporting-related groups and efforts:

• Community and coordination: opening up a public instance of the LDP, and queries can be tested on it. There are still a few issues under discussion. Angela hopes to have an update soon.

• LDP Data Privacy Working Group: Ingolf flagged personal data from mod-organization-storage, so that Nassib can anonymize those fields. Also, personal data fields in ERM reports were identified. Only one report (REP-158) may contain personal data, but this is currently needed only by Cornell in 2021, so it is not an immediate concern.

• LDP SysOps Working Group

• Software development

  • Here is a summary of changes in the past week:
    
    * Support for historical data has been added.  (It was previously
    disabled in the 0.3 release.)  See Section 6 of the LDP User Guide for
    details.
    
    * A bug has been fixed that caused tables not to be updated when an
    extraction succeeded with zero records.
    
    * Improved handling of cases where data record sizes exceed Redshift
    data type limits.
    
    * The date and approximate time when each table was last updated can now
    be viewed with:
    
         SELECT * FROM sys.loading;
    
    * The databaseUser configuration parameter has been renamed to ldpAdmin,
    and databasePassword has been renamed to ldpAdminPassword.
    
    * The LDP database user can now be specified via a configuration
    parameter, ldpUser.  The default value is ldp.
    
    * A few preliminary notes on Redshift database configuration have been
    added to the LDP Admin Guide.
    
    * A few notes have been added to the LDP Admin Guide on running the data
    loader in production.

New Reporting Slack Channels

Nassib

New Reporting Slack Channels:

#ldp-announce - Announcements of the Library Data Platform project

#ldp-users - Querying and general usage of the Library Data Platform

#ldp-sysadmin - System administration of the Library Data Platform

Connecting to and Testing Queries with the New Public LDP

Angela

Angela will walk us through connecting to and testing our queries with the new Public LDP environment. See the LDP Reference Environment page for more information.

Instructions on connecting are here: FOLIO Reporting Reference Environment

Who is going to WolfCon in January 2020?

All

We'd like to get a sense of how many Reporting SIG members plan to attend our upcoming conference. Please add your name to the second worksheet labeled "Attendees" if you plan to attend the WolfCon January 2020 conference.

• WolfCon 2020 Reporting Topics & Attendees

So far, 4 members plan to attend. Chicago (and others) are still in the process of deciding who will go. It will depend on the draft agenda.

Reporting Prototypes and Queries

All

Let's review our Report Prototype and Query Development Project List

• Report Prototype and Query Development Project List

Meeting Notes: See notes in the list (column "status").

Additional Topics?

All 

Topics for Future Meetings

All

Review and update Topics for Future Reporting SIG Meetings