| Version 1 (modified by , 14 years ago) (diff) |
|---|
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
