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 http://www.kevinbeswick.com/scripts/biblio/
- FundCycles?.java
- Funds.java
- Orders.java
- Vendors.java
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 http://svn.open-ils.org/trac/ILS-Contrib/browser/conifer/branches/workbooks), 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 http://www.kevinbeswick.com/scripts/biblio/spreadsheet.sql
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 http://www.kevinbeswick.com/scripts/biblio/vendors_funds.sql
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 http://www.kevinbeswick.com/scripts/biblio/ These are still very messy, and will be cleaned up when the process is finished.