2017-10-16 - Reporting SIG Notes
Date
Attendees
- Anne L. Highsmith
- Doreen Herold
- Christine Wise
- Joanne Leary
- Johnmcdonald
- Peter Murray
- Sharon Beltaine
- Former user (Deleted)
Goals
- Sharon Beltaine : Establish connection to Katalin Lovagné Szűcs . Sharon Beltaine and Ingolf Kuss : present Summary of General Report Types and Simplified Data Requirements for FOLIO and MARC Bibliographic Fields Required for Reporting and the Database Sketch Database Sketch to Katalin Lovagné Szűcs . Discuss with Katalin if this will be needed for the development of the Reporting App. Discuss with Katalin, what kind of input from the Reporting SIG the Qulto developers' group needs to develop the Reporting App. Ask Katalin to join the Reporting SIG.
- Charlotte Whitt and Doreen Herold : discussion / chat on Metadata fields - how will we continue with that ? Can we have input from the Metadata SIG to complete our Listing of MARC fields . - (remark from Ingolf Kuss, not discussed in the group) : maybe wait for that until we talked to Katalin.
- Ingolf Kuss : ask Hkaplanian at the FOLIO Information Day in Stuttgart (Oct 17+18), whether the OpenSource solutions, which will be evaluated by the Qulto group from Nov 17 - Jan 18, will include a backend (including a data base) or will only include a frontend.
Discussion items
| Time | Item | Who | Notes |
|---|---|---|---|
| 10 | Introductions for new members John and Sharon | group | |
| 15 | Report from last PC Meeting - FOLIO V1 Dev Milestone plan | Hkaplanian presented an update on the FOLIO Roadmap, also called Milestone Plan. The update is still under work, thus inofficial. The currently official version of the document can be found here . Concerning Reporting, this plan says that
The solution will be "some kind of a data warehousing system" (as we already know). "Strategic Reporting" will be taken care of (=Reporting to external, the public ?). There will be "In-App"-Reporting when live data is needed. The data warehouse concept will also collect data from outside the apps. Concerning the development of a Reporting system, the question is "build one or adapt one ?". Harry (and the team) have decided to review OpenSource options and to adapt a system. | |
| 20 | Continue discussion on collection of MARC Bibliographic Fields required for Reporting and MARC Holdings Fields required for Reporting | group | It is a lot of work for everyone to fill in all the fields that we need. Again, we need all the fields. It may make sense to fill in the form for only the most important fields. We also observed that different consortia, institutions or countries may put the same contents into different places in the MARC record. So, filling out the spreadsheet actually requires knowledge of the local cataloging habits and it must be documented for which country/consortia/institution... this mapping is valid. This does not make the task easier. We could go ahead and form a working group to list the needed MARC fields that but we decided that it makes more sense to talk to Katalin before in order to avoid duplicate work. Sharon has already scheduled a meeting with Katalin (on Thursday, Oct 26th). It was mentioned that a utility to export data (from the apps to a centralized platform) will also be needed elsewhere in the system, not only for reporting. A separate utility would do the export (form MARC to Codex ?). We should be taking part in the discussions about the development of such a utility, giving our requirements. We have to find out where souch a utility will be or is already being developed, maybe the Metadata SIG can help us with that (Charlotte is in the Metadata SIG, Charlotte and Doreen will chat about that). |
| 10 | Outlook | Ingolf will take a day off on Oct 30th. Sharon will chair the Meeting on Oct 30th and from then on will be the Convener of the SIG (Ingolf will stay a member of the SIG). Ingolf will be on the FOLIO Information Day in Stuttgart and will give a report on any new developments he will hear about there the next time in the SIG. Ingolf will report on the Information Day about the works and charges of the Reporting SIG (and other SIGs). The target audience of the information day are "interested decision-makers, practitioners and specialists (developers und system librarians) from the German-speaking library-landscape". There are about 100 registrations. Recently, the Bavarian Library Network, located in southern Germany, expressed interest in FOLIO (the currenty team, OLE-Germany, only comprises the networks hbz and GBV, which represent most libraries in the northern, mid- and mid-western part of Germany). |
Notes
Ingolf reviewed the project roadmap – (FOLIO V1 Dev and Milestone Plan 2) which shows key project milestones and timelines:
https://docs.google.com/spreadsheets/d/15eO29vY2qp-FeUaoA292J-KwDy4c9z8dg-Pfp2fDymw
- One project item listed (scheduled for Nov 2017 – June 2018) is to review open source reporting systems and chose one to adapt to our needs. Q: will the system be serving as a front-end system, or both front-end and database system? Ingolf will talk to Harry Kaplanian about this on Weds at the meeting in Stuttgart.
- We agreed to invite Katalin Szucs (owner of Qulto, a company that provides software and hardware tools for library records and operations) to our SIG meetings.
At the last meeting we were asked to identify MARC fields (Bib and Holdings) that were key to creating the reports needed. Ingolf began spreadsheets for these:
BIB: https://docs.google.com/spreadsheets/d/1vGlqIeBZ0a-l51OrmuzZ3In6atiSarGPXlp5DWGL_2U/edit#gid=0
Holdings: https://docs.google.com/spreadsheets/d/1B4NuALzKuZF014AeZb_92E8y5BFAqSauYHd64o4zLY4/edit#gid=0
- Each needed field is keyed to the report that uses it, via the Report ID. The Report ID found on the Reporting SIG Master Spreadsheet: https://docs.google.com/spreadsheets/d/1svUM74Dkg4KvTXLzKZK_2k_SxeukX-87NnYf8CaTrYQ/edit#gid=312878932
- We need to know how the developers will be using this information and what their timeline is, so we can work toward meeting that deadline
- Ingolf and Sharon will set a meeting with Katalin to establish what their needs are and their timeframe
- SIG members should enter the MARC fields they need for their reports on the sheets Ingolf started (reference: see https://www.loc.gov/marc/ for field definitions) and do this soon so that Katalin can review the list before she joins us
- We need to involve the Metadata SIG in this
- Q: will there be a way to add needed fields after the fact? If not, we need access to the operational system if we find that needed elements are not in the Reporting system
- We need to be able to export the whole record. Peter said there would be a separate utility to enable exporting full records, but not within the Reporting system. Q: where else would this functionality be needed?
- Joanne Leary note taker