*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
-
Created by
Sharon Helen Markus, last updated on Mar 27, 2026
1 minute read
Connect to the CIT patron database
Run the password script
Because the database contains more than 7 million records, and you are downloading the data into Excel, you need to download the data in batches
Run the following scripts in sequence to get the data
Import the data into the local_protected schema in the Metadb database
After you load the first table of data, append the additional datasets to the data in this table so that all the data is in one table in Metadb