Link | Description | ||
---|---|---|---|
provides information about standards and guidelines for queries developed and maintained for the CUL FOLIO SQL Report Directories | |||
How to Document Queries (DRAFT) | instructions for documenting queries on Confluence and GithubSetting Permissions for Schema Tables | ||
instructions for using the local schemas that are available in Metadb and giving users permissions to use a table you have added to a local schema | |||
list of tables that need data types fixed in order to be created by the metadb software running with FOLIO Poppy as a data source | |||
instructions for converting Tableau dashboards that use queries written for LDP into Metadb format | |||
examples and instructions for extracting data fields from JSON data arrays in Metadb | |||
step-by-step instructions for reviewing code for a pull request for FOLIO Analytics | |||
Making a Pull Request for FOLIO Analytics | step-by-step instructions for submitting a pull request for FOLIO Analytics | ||
Subjects and Series changes for Orchid | details on updates in FOLIO Orchid release to instance records for subjects and series to capture changes associated with authority control | ||
Scheduling Automated EXCEL reports with DBeaver EE | step-by-step instructions for scheduling automated EXCEL reports (including daily updates) and sending them to a BOX folder using queries via DBeaver EE | ||
Uploading Tableau Files (dashboards) to the Cornell Tableau Server (IN PROGRESS) | |||
Preparing a Canned Report or Ad Hoc Report for cul-folio-analytics | step-by-step instructions for preparing a canned or ad hoc query to be submitted to cul-folio-analytics | ||
Submitting a Canned Report or Ad Hoc Report to cul-folio-analytics | step-by-step instructions for submitting a canned or ad hoc query to be published on cul-folio-analytics | ||
Editing and Resubmitting a Canned Report or Ad Hoc Report to cul-folio-analytics | step-by-step instructions for editing and resubmitted a canned or ad hoc query to be published on cul-folio-analytics | ||
Using the Local Schemas on the Cornell LDP | Guidelines for using the Local Schemas on the Cornell LDP (Library Data Platform) reporting database | ||
instructions for using advanced features of Cornell's reporting environments, such as importing data into local schemas in the LDP and connecting to the Voyager Historical reporting database | |||
Using the VTEST Voyager Historical Data Snapshot | all about the snapshot of Voyager historical data and getting access to use it | ||
Removing Unpurchased PDA/DDA title counts | Describes how A&P has been removing counts of unpurchased PDA/DDA (Patron Driven Acquisition/Demand Driven Acquisition) titles from annual data collection figures as requested by national definitions. | ||
Capturing Circulation Demographics | description of the workflow for capturing demographic data for circulation | ||
Fiscal Year Updates to Dashboards and Automated Reports | notes on how to update Tableau dashboards and automated reports just before the change to a new fiscal year | ||
Dashboard Permissions | instructions for setting permissions on Tableau dashboards | Circ Snapshot Process | describes process for capturing circ transactions in circ snapshot table for use in specialized reports |