FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!
  1. Andrea Taylor
  2. Sierra/ Millennium/ Encore
  3. Wednesday, June 29 2016, 01:34 PM
  4.  Subscribe via email
Does anyone use the Scheduler in Sierra? If so, what do you use it for? I am trying to compile a list of advantages and compare it to current staff time spent on manually running reports.
Comment
We are currently using Scheduler for a couple different tasks. We have a few create lists for students with fines that get ran every night. These lists then get exported to an FTP server where one of our member academic libraries then pull the files out and update the students account with the financial office. We also have a process in use by two of our libraries where patrons loads happen automatically using scheduler. CSV files get sent to the FTP server and then Scheduler reaches in and pulls the file out and loads them using our desired load table.
  1. Brandon Cole
  2. 1 year ago
We use it to export Marc records from the catalog to send to our discovery layer vendor (EBSCO).

Twice a week scheduler runs a list of new bibliographic records only and exports them directly to EBSCO's FTP server.

Once a month, we replace our entire catalog in the discovery layer (to account for deleted records as well as added ones). Scheduler exports all non-suppressed bib records in the catalog in a series of large lists to a local FTP server, and a staff member combines them into one file and FTP's them to EBSCO. (We've found that FTP'ing the large full-catalog lists directly to EBSCO's FTP server tends to fail due to the nature of EBSCO's process and the size of the files, but at least a staff member doesn't have to manually create and export the lists.)

We have used it for other things in the past (for example, exporting a weekly snapshot of books currently checked out to send to our consortium as part of a collection analysis study).
  1. Carrie Preston
  2. 1 year ago
I use scheduler to send changed bibs to our discovery system daily. We only reload the entire database if we make an index change in the discovery system. I have my scheduler saved search set to only gather records with an update date of "yesterday" - so I'm only sending at most a few thousands of records. We are only ftping them locally, but I've never had a problem.

Scott
  1. Guest
  2. 5 months ago
We just bought scheduler primarily for EDS record loads. We have been doing a complete reload every two weeks so I was trying to replicate the process with Scheduler (I'd be tempted to ask for our money back if the process turned out to still require staff intervention!).

Previously we were having to split the out files into 4 or 5 different lists, and output files. This wasn't due to the size of the list (our largest is set to 1,875,000) but to the previous limit in output file size in Data Exchange. A recent Sierra update (I think it was 2.4) increased this, so now we are running it in 2 list/output files. They average around 1.4 and 2.3 gigs each.

I was having a lot of trouble getting it to work with Scheduler. While it would work going to a local ftp site that I run, the files were not showing up on the EBSCO ftp site. Both EBSCO and iii support were no help, and it definitely doesn't help that the Scheduler email notifications would always say the process completed successfully when they hadn't. Does that happen to everyone else using Scheduler? Seems like I had seen that complaint before?

Anyway I finally thought to try checking the use secure ftp box and that seemed to do the trick! (This was strange because the EBSCO site is not a secure ftp site). So now I've got it set to run weekly and keeping my fingers crossed that it continues to work. I'll still have to check it manually because I can't trust the email notifications. Maybe I can live with that , but I'm going to try to push for a fix cause it seems like a simple thing for them to solve.

shirleybd@appstate.edu
  1. Benjamin Shirley
  2. 5 months ago
hi everyone...i am wondering how to create a saved search that gather records that was updated yesterday. I am planning to use Schedule to run it every day.
  1. Guest
  2. 1 week ago
There are no comments made yet.
Add Comment
Joe Montibello Accepted Answer
0
Votes
Undo
Hi,

We use scheduler for a few different things:

Run a list of items with the "in transit too long" message, but currently have the status '-'. These can then be cleared.

Run a list of patrons whose expiration date has passed.

Run lists of new/updated records and deletes to send to Proquest to update our holdings in Summon.

Run a list of records whose cat date is in the last day or so to output data for our labels process.

It's not always the best way to do things, but these are some examples where we use Scheduler. Hope this helps.

Take care,
Joe M.
Comment
Hey Joe, I'm curious how you all gather your deleted records. I mean if they were deleted you couldn't run a list on them right? Do you use a special suppress code perhaps?

shirleybd@appstate.edu
  1. Benjamin Shirley
  2. 5 months ago
Joe, I am curious whether you can assist me with something (again!) - we're trying to set up Scheduler for our weekly upload to Summon, but of course Summon requires date strings [1] in their filenames (I'm assuming that is what is going wrong with our upload...although it might be something else?). Are you having Scheduler handle the FTPing, as well? If so, would you mind sharing the filename you give to Scheduler? E.g., in our task I have "vassar-catalog-updates.marc" - but (I think) I need it to also have the date string, a la sourceid-catalog-updates-`date +%F-%H-%M-%S`.marc. Weird question, but is it possible to get Scheduler to recognize the date variables and ... fill things in on the fly? ::crosses fingers::

Thank you for ANY information you can provide!



[1] https://knowledge.exlibrisgroup.com/Summon/Product_Documentation/Configuring_The_Summon_Service/Working_with_Local_Collections_in_the_Summon_Service/Getting_Local_Collections_Loaded_into_the_Summon_Index/Summon%3A_Catalog_File_Naming_Conventions

arschlegel@vassar.edu
  1. Arianna Schlegel
  2. 1 month ago
For future reference, it appears that Summon is ingesting our uploads without having the date appended to the filename (i.e., vassar-catalog-updates.marc" - so far, so good! I'm going to keep an eye on things, but for about a week we've been uploading automatically (daily), and as far as I can tell, I've been able to successfully find newly-added items in our Summon instance. I'll update if this changes.

arschlegel@vassar.edu
  1. Arianna Schlegel
  2. 1 month ago
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 1
Donna Spychala Accepted Answer
0
Votes
Undo
I use it for several weekly and monthly lists. I do think it’s a time saver. When I come in on Monday, my data is ready. It doesn’t take time to run them manually,
but when you have 4+ lists that you pull every week, that time adds up. And the yearly reports I schedule to run off hours so that I’m not waiting for them to complete. I use it for:

Weekly

Marcive – we send them new bibs weekly

Novelist – we send updates weekly (I schedule this to run and export)

Pulling items marked withdrawn to suppress

Pulling a withdrawn batch process to mark withdrawn globally



Monthly

Featured lists

Lost and paid accounts to delete

Online reg accounts to cancel if they haven’t activated their card



Yearly (scheduled to run off hours)

Run statistics on all item records

Run statistics on all patron records







So, I do believe using the scheduler saves time!!



Donna






Donna Spychala

Systems Librarian

Toledo Lucas County Public Library

419.418.2249

http://toledolibrary.org/";">Web |
https://www.facebook.com/ToledoLibrary/?fref=ts";">Facebook | http://twitter.com/toledolibrary";">
Twitter














From: Innovative Users Group [mailto:discussions@innovativeusers.org]


Sent: Wednesday, June 29, 2016 10:25 PM

To: Donna Spychala

Subject: [#8815]: New question asked - Sierra Scheduler





















New Question Posted




Andrea Taylor created a new discussion
Sierra Scheduler in Sierra/ Millennium/ Encore

















Hello,

This is a notification to let you know that Andrea Taylor has created new discussion on the site. You may find the snippet of the new discussion below:














Does anyone use the Scheduler in Sierra? If so, what do you use it for? I am trying to compile a list of advantages and compare it to current staff time spent on manually running reports.












http://innovativeusers.org/iug-forum/sierra-millennium-encore/8815-sierra-scheduler.html";">Read
this discussion















This email was sent to you, because you have subscribed to the discussion.

To unsubscribe, please http://innovativeusers.org/iug-forum/sierra-millennium-encore.html?controller=subscription&;task=unsubscribe&data=dHlwZT1zaXRlDQpzaWQ9MTg3DQp1aWQ9MTc4OQ0KdG9rZW49MDVmOGUwM2NkNjllNzNiMzE0YWFhMTEyZDk0ZDVlYzc="">
click here. http://innovativeusers.org/iug-forum/sierra-millennium-encore/profile.html#Subscriptions";">
Manage subscriptions.
Attachments (1)
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 2
Catie Hodges Accepted Answer
0
Votes
Undo
Hi we use the scheduler for most of our weekly and monthly housekeeping tasks. I believe it is a big time saver as the data is being refreshed when the libraries are closed and can be exported when we arrive at work. (we would love to be able to schedule the export as well)
Currently we use the scheduler for:
Portable RFID reader search lists- updated daily
Weekly and monthly lists such as ;
Items with "problem" statuses such as Repair, Damaged, Returned incomplete etc
New members signed up in the last week; libraries check the records to ensure details such as address and emails have been entered correctly
Interstate members due to expire (these members pay a fee to access our collection. We are located near an interstate border and we do have some people from over the border wishing to use our collections).
Items in transit for too long
Items claims returned
List of users with manual blocks or blocks due to long overdues at 1 of our mobile library stops that has poor internet access and staff often have to work offline
and lists of checked out items from our special collections such as book club kits and special needs equipment so coordinators of those areas can monitor them.
We have only been with Sierra for about 6 months so I guess we will also be scheduling our annual clean up lists such as the removal of temporary and long expired members as well.
Comment
Hi Catie, is there a reason why you can't use an Output Delimited Records Task to export your list list data to a local ftp server that staff could grab thier files from?
  1. Guest
  2. 5 months ago
We'd love to be able to schedule the export of the lists but at this stage we don't have access to a local ftp server. We have had a request in for a while to get access to the one owned by council but due to the outsourcing of IT support and a general freeze on non-critical IT change requests (We are hosting the Commonwealth Games in about 6 months), we have been warned not to hold our breath waiting. Even if we do get access, it will be limited access for only a few in library admin.
  1. Guest
  2. 1 month ago
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 3
Catie Hodges Accepted Answer
0
Votes
Undo
Just an addition to my comments above.
We have our system set to look up call numbers for an item from the bib record and only include an item call number in the item record if it is different to the bib (eg a reference copy).
Since an upgrade last July, the scheduler is now no longer able to look up call numbers (even if the login scheduling the task has the look up call numbers setting ticked). So basically now scheduled item lists do not include call numbers which we have found to be a real pain.
The mobile worklists app however does show the call numbers for these lists if the list is imported onto the mobile device via the app.
Patron and bib lists still schedule without issue.

chodges@goldcoast.qld.gov.au
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 4
Ben Daigle Accepted Answer
0
Votes
Undo
Thanks for your message.

I am attending a conference and will be out of the office from Friday, October 6 through Monday, October 9.

For urgent issues, please feel free to call or text me at 614-595-9069, and I will get back to you ASAP. Otherwise, I will respond as quickly as I'm able upon my return on Tuesday, October 10.

Thanks!
Ben



--
Ben Daigle
Associate Director of Consortial Library Systems
The Five Colleges of Ohio
43 Rowland Avenue
Delaware, Ohio 43015
614-595-9069



bldaigle@owu.edu

Comment
There are no comments made yet.
Add Comment
Mary Morgan Accepted Answer
0
Votes
Undo
I would like to know how to use Scheduler for running daily lists for updating Summon as well. I have been working with Sierra/Millenium for a while but I am new to this aspect of it. Any assistance would be appreciated. Thank you.

morganm@gvsu.edu
Comment
There are no comments made yet.
Add Comment
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,pdf,ppt,pptx,doc,docx,xls,xlsx,,txt,rtf,jrxml
• Remove Upload Files (Maximum File Size: 2 MB)
You may insert polls into your post. The poll would then appear in the post.
Vote Options
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.