Laurentian University Acquisitions

Getting data from previous system

Some scripts were created in Java to extract the old data from the flat files, create java objects with the data, and then output them in either tab delimited plain text, or in sql statements. Java objects make it easily extendable if one wished to export the data into another format.

These can be found at

After getting this data, I loaded it into the test server under a schema called luacqdata

Importing data into Art's Spreadsheets

To import the data from the database into Art's spreadsheet (found at, I just created a monster of a query that produced all the information in the order required to import directly into the masterlist spreadsheet. This query can be found at

The query imports data from a certain year, and to change the year, you just need to change the years at the end:

ord."FISCAL_CYCLE" = '2003' AND li."FISCAL_CYCLE" = '2003'

Vendors and funds were a lot simpler to get. The sql queries for those are in the file

Importing data into Evergreen's acquisitions schema

In progress...

  • All purchase orders, and po notes have been loaded
  • All vendors have been loaded
  • All funds, funding source, funding source credits, fund allocations have been loaded
  • A sample of 50 line items, line item details, fund debits were added successfully
  • All line items are in the process of being added. This is proving troublesome:
    • Some lineitems have barcodes, some don't
    • Some lineitems have call numbers, some don't
    • Some have neither
    • Cannot get marc data / other pertinent info for certain items

All sql queries used and notes are in the files "acq" and "acqcookbook" available in These are still very messy, and will be cleaned up when the process is finished.

Last modified 13 years ago Last modified on Jul 21, 2009, 3:28:50 PM