Skip to content

Instantly share code, notes, and snippets.

Jane Sandberg sandbergja

  • Linn-Benton Community College
Block or report user

Report or block sandbergja

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@sandbergja
sandbergja / install_evergreen.yml
Created Feb 27, 2019
i18n install_evergreen.yml
View install_evergreen.yml
---
#ansible-playbook /mnt/evergreen/playbooks/restart_app_services.yml --private-key /home/user/.ssh/id_rsa -vvvv -e "hosts=192.168.12.49"
- hosts: '{{hosts}}'
connection: local
remote_user: user
become_method: sudo
vars_files:
- varsfile.yml
tasks:
View can_i_service is a rails app that uses the hyrax Gem
jane@caracal:~/tmp/can_i_service$ rails c
Running via Spring preloader in process 3063
Loading development environment (Rails 5.1.2)
irb(main):001:0> Hyrax::RepositoryFixityCheckService.fixity_check_everything
NameError: uninitialized constant Hyrax::RepositoryFixityCheckService
from (irb):1
View Add all copies from a certain call number range into a copy bucket
INSERT INTO container.copy_bucket_item (bucket, target_copy)
SELECT 1644, id FROM asset.copy
WHERE NOT deleted AND call_number IN
(SELECT id FROM asset.call_number WHERE label ~ 'RT(4[1-9]|5[0-9]|6[0-7])(\.|\s).*' AND NOT deleted);
@sandbergja
sandbergja / ActiveRecord::RecordNotFound in Hyrax::GenericWorksController#create
Last active May 15, 2017
I get this error any time I try to create a new work as admin. It ends up creating the work despite this error, but never uploads the files that I've selected in the UI.
View ActiveRecord::RecordNotFound in Hyrax::GenericWorksController#create
ActiveRecord::RecordNotFound in Hyrax::GenericWorksController#create
Couldn't find Sipity::Workflow with [WHERE "sipity_workflows"."active" = $1 AND "sipity_workflows"."permission_template_id" IN (SELECT "permission_templates"."id" FROM "permission_templates" WHERE "permission_templates"."admin_set_id" = 'admin_set/default')]
activerecord (5.0.2) lib/active_record/relation/finder_methods.rb:550:in `find_nth!'
activerecord (5.0.2) lib/active_record/relation/finder_methods.rb:129:in `first!'
/home/libwebadmin/.rbenv/versions/2.4.1/lib/ruby/gems/2.4.0/bundler/gems/hyrax-0e6697f40950/app/models/sipity/workflow.rb:34:in `find_active_workflow_for'
/home/libwebadmin/.rbenv/versions/2.4.1/lib/ruby/gems/2.4.0/bundler/gems/hyrax-0e6697f40950/app/models/concerns/hyrax/in_admin_set.rb:10:in `active_workflow'
/home/libwebadmin/.rbenv/versions/2.4.1/lib/ruby/gems/2.4.0/bundler/gems/hyrax-0e6697f40950/app/services/hyrax/workflow/workflow_factory.rb:51:in `create_workflow_entity!'
/home/libwebadmin/.rbenv/versions/2.4.1/l
View desk_payments.adoc

Cash reports

Cash reports are useful for quickly getting information about money that your library has collected from patrons. This can be helpful in a few different scenarios, such as:

  1. Reconciling a cash drawer at the end of the day.

  2. Seeing how popular a specific payment type is (perhaps when evaluating a food-for-fines program).

To use the cash reports,

@sandbergja
sandbergja / Local authorities - 150 without $x or $v
Created Feb 28, 2017
Local authorities - 150 without $x or $v
View Local authorities - 150 without $x or $v
heading | thesaurus
-----------------------------------------------------------------------------------+-----------
150_-_L a abortion z europe | L
150_-_L a absentee fathers | L
150_-_L a abuse of administrative power z united states | L
150_-_L a adopted children z great britain | L
150_-_L a adventure travel z west u s | L
150_-_L a advertising agencies z new york state z new york | L
150_-_L a african american families z virginia z albemarle county | L
150_-_L a african american gay men | L
@sandbergja
sandbergja / Local authorities report - corporate bodies
Last active Feb 27, 2017
Local authorities report - corporate bodies
View Local authorities report - corporate bodies
heading | thesaurus
-----------------------------------------------------------------------------------------------------------------------------------------+-----------
110_-_L a alaska marine highway system | L
110_-_L a america online inc x history | L
110_-_L a american league of professional baseball clubs x history | L
110_-_L a americas test kitchen firm | L
110_-_L a andersonville prison v fiction | L
110_-_L a aol time
View Montly cataloging reports
---monthly: report of items missing 245
SELECT DISTINCT b.id as tcn, ou.name as library, cn.label as call_number, c.barcode, 'Missing 245 (title) field' as issue
FROM biblio.record_entry b
INNER JOIN asset.call_number cn ON cn.record=b.id
INNER JOIN asset.copy c ON c.call_number=cn.id
INNER JOIN actor.org_unit ou on ou.id=c.circ_lib
WHERE b.deleted=FALSE
AND b.marc NOT LIKE '%tag="245%'
AND b.id != -1
ORDER BY library;
@sandbergja
sandbergja / PROCRUN commands
Last active May 19, 2016
PROCRUN commands
View PROCRUN commands
$JAVA_PATH="C:\Program Files\Java\current"
$JAR="C:\jetty\start.jar"
$LOGS="C:\jetty\logs"
$STARTPATH="C:\jetty"
.\SolrService.exe //IS//SolrService --DisplayName="SolrService" --StartMode=java --StopMode=java --Classpath=$JAR --StartPath=$STARTPATH --StopPath=$STARTPATH --JavaHome=$JAVA_PATH --LogPath=$LOGS --LogLevel=Debug --StdOutput=auto --StdError=auto ++JvmOptions=-Xdiag --StartClass=org.eclipse.jetty.start.Main --StopClass=org.eclipse.jetty.start.Main ++JvmOptions=-DSTOP.KEY=[[[[[]]]]] ++JvmOptions=-DSTOP.PORT=8079
@sandbergja
sandbergja / unimported.sql
Created May 16, 2016
Unimported vandelay records
View unimported.sql
SELECT q.id, q.name, COUNT(b.id) AS unloaded
FROM vandelay.queued_bib_record b, vandelay.bib_queue q
WHERE q.id=b.queue AND q.id>1542 AND b.imported_as IS NULL
GROUP BY q.id
ORDER BY unloaded DESC;
You can’t perform that action at this time.