Skip to end of banner
Go to start of banner

2020-05-11 Reporting SIG Meeting notes

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Date

Attendees

Present?

Name

Organization

Present?

Name

Organization


Sharon BeltaineCornell University
Sara ColglazierMount Holyoke College/Five Colleges

Elizabeth BerneyDuke University
Erin NettifeeDuke University

Joyce ChapmanDuke University
Karen NewberyDuke University

Jean PajerekCornell University
Tod OlsonUniversity of Chicago

Claudius Herkt-JanuschekSUB Hamburg
Scott PerryUniversity of Chicago


Doreen HeroldLehigh University
Stefan StadtherrMPIL Heidelberg

Sarah ParkDuke University
Simona TabacaruTexas A&M

Clint BellangerAuburn University
Kevin WalkerThe University of Alabama

Ingolf Kusshbz
Christie ThomasUniversity of Chicago

Joshua LambertMissouri State

Andi Bihler

Munich Technical University Library

Joanne LearyCornell University
Cheryl MalmborgUniversity of Chicago

Michael PatrickThe University of Alabama
Vandana ShahCornell University

Nassib NassarIndex Data
Angela Zoss

Duke University


Veit KöppenUniversity Magdeburg
Lisa DeCarolisSmith College/Five Colleges

Linda MillerCornell University
Elena O'Malley

Emerson


Matt HarringtonDuke University     Holly MistlebauerCornell University

Cathy TuohyEmmanuel College (FLO)
Nancy BolducCornell University

Shirley MoentnishMissouri State
Eric PenningtonTexas A&M

Stefan DombekLeipzig University
Axel DoerrerUniversity Mainz

Natalya PikulikCornell University
Owen StephensK-Int

Eliana LimaFenway Library Organization



Discussion Items

Item

Who

Notes

Attendance & NotesSharon

Attendance & Notes

  • Today's attendance-taker: Linda Miller
  • Today's note-takers:  Team Leads for project updates
Updates from Various Reporting Related Groups and EffortsCommunity & Coordination, Reporting Subgroup Leads

Project updates

The Reporting SIG is using small working 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. Please include updates on specific JIRA issues for prototype or query development workflow. Do we need to create any additional JIRA tickets?

Community & Coordination: 

  • no meeting this week
  • met with leads of working groups

Development:

  • working on getting Microsoft Access to work for Postgres version of LDP; error on ways tables connect to one another (UUDs are too long for Access to handle); Access only connects tables on integers; Nassib programmed in dummy tables as integer identifiers to make this work ("sk" surrogate key) makes the Access Visual SQL Editor work
  • Access does not connect to RedShift
  • may need to be some parallel work for institutions requiring Access
  • Postgres is less expensive to host than RedShift
  • Many requests for diagrammatic representation of LDP; Schema Spy has visual representation of tables at https://glintcore.net:8443/ldp/schemaspy/public/relationships.html
  • Finalized style of Readmes for LDP Analytics on GitHub; example at: https://github.com/folio-org/ldp-analytics/tree/master/sql/circ_detail

Tools to Consider

  • Dbeaver Enterprise has worked well for Eliana (not free)
  • Metabase (free and not free)
  • LibreOffice Base ? (free)
  • Aqua Data Studio (not free)
  • Crystal Reports (not free)

RA/UM Working Group: 

  • 4 prototypes currently underway


MM Working Group:


RM Working Group: 

ERM Working Group:



Interlibrary (ILL) Loan and Borrow Direct (BD) Integrations UpdateElena, Vandana

We'll discuss options and recommendations for integrating Interlibrary Loan (ILL) into your library system, with a focus on how that impacts developing queries for reports.

  • ReShare presented in Consortia by Kristen Wilson. Currently using NCIP protocol, has potential to be used between FOLIO libraries for intraconsortial borrowing. Plans to have LDP for reporting in the future. It is more designed to be the handshake between systems, rather than extensive reach within FOLIO. Discovery layer independent - currently working with VuFind.


Categorizing Reports in External Statistics, Import/Export, and ConsortiaAll

We'll review reports that have been categorized as External Statistics to move them into existing Reporting Subgroups for development. Import/Export and Consortia Reports also need to be reviewed this way.


  • Recategorize Import and Export REP Issues
  • Recategorize External Statistics REP Issues


Additional Topics?All Schedule "Quick Demo" meeting for Reporting Tools Analysis
Topics for Future MeetingsAll

Review and update Topics for Future Reporting SIG Meetings 


Action items





  • No labels