contrib/equinox.git
13 years agovarious speed improvements to the collectionHQ extract
Galen Charlton [Thu, 27 Sep 2012 21:43:13 +0000 (17:43 -0400)]
various speed improvements to the collectionHQ extract

This is the result of a first pass to remove inefficient
queries on metabib.real_full_rec and auditor.asset_copy_history.

Most of the changes don't affect the output, but there are a
couple exceptions:

- the new version is more likely to pick the first 082$a
  for the class number (which is also more correct)
- the script now bases the "current use count" on the date that
  the item was last transited to the current circ lib, rather than
  the date the circ lib simply changed.

The last change is the most uncertain.  One the one hand, it helps
proof the extract against pruning of the asset.copy auditor table.
On the other hand, if items change their circ library without getting
formally transited (which might be theoretically possible for
some workflows) the current use count *might* be calculated
differently than expected.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
13 years agomodernize the README for database backups
Galen Charlton [Tue, 4 Sep 2012 18:42:23 +0000 (14:42 -0400)]
modernize the README for database backups

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
13 years agodoubled shebang noticed by bshum and gmcharlt -- thanks!
Mike Rylander [Wed, 17 Mar 2010 18:06:15 +0000 (18:06 +0000)]
doubled shebang noticed by bshum and gmcharlt -- thanks!

git-svn-id: svn://svn.open-ils.org/ILS-Contrib@836 6d9bc8c9-1ec2-4278-b937-99fde70a366f

13 years agoadding db backup scripts, and an overview README of how to use them
Mike Rylander [Wed, 17 Mar 2010 17:57:36 +0000 (17:57 +0000)]
adding db backup scripts, and an overview README of how to use them

git-svn-id: svn://svn.open-ils.org/ILS-Contrib@835 6d9bc8c9-1ec2-4278-b937-99fde70a366f

13 years agofix bib query so that each bib is extracted only once
Galen Charlton [Thu, 2 Aug 2012 18:40:05 +0000 (14:40 -0400)]
fix bib query so that each bib is extracted only once

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
13 years agomake sure deleted bibs are excluded
Galen Charlton [Thu, 2 Aug 2012 16:20:57 +0000 (12:20 -0400)]
make sure deleted bibs are excluded

Belt-and-suspenders

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
13 years agoScope collectionHQ extract to org unit + children
Jeff Godin [Thu, 2 Aug 2012 16:01:03 +0000 (12:01 -0400)]
Scope collectionHQ extract to org unit + children

Enable collectionHQ extract functions to scope to a specified org
unit ID and that org unit's children. Specify a default org unit of
1 to closely reproduce previous behavior.

NOTE: Even with an org unit of 1, this work-in-progress changes
previous behavior due to requiring an asset.call_number with
owning_lib in scope. Previously ALL bibs were included.

Signed-off-by: Jeff Godin <jgodin@tadl.org>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
13 years agocollectionHQ data extraction report
Galen Charlton [Wed, 1 Aug 2012 19:21:44 +0000 (15:21 -0400)]
collectionHQ data extraction report

Scripts to produce a report of bibs and items from
an Evergreen database for submission to collectionHQ.

These scripts were sponsored by the King County Library System.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
13 years agoinitial README and license info for ESI's Evergreen contribs
Galen Charlton [Wed, 1 Aug 2012 19:13:23 +0000 (15:13 -0400)]
initial README and license info for ESI's Evergreen contribs

Signed-off-by: Galen Charlton <gmc@esilibrary.com>