Bulk Loading: General Instructions (LTS Procedure #46)
Scope: This procedure provides instructions for running automated import, export, cleanup, reporting and various related jobs using shell scripts and other tools created by the Library Systems Office. The list of jobs includes the frequency of the work, the list of people responsible for performing this work, as well as the function of each job. In addition, this procedure includes guidelines for scheduling batch routines.
Contact: Gary Branch
Unit: Database Management Services
Date last updated: 08/07/09
Date of next review: July 2010
Caution: For large jobs, see Scheduling.
1. Using a secure shell FTP client, logon to Library45.
- Host Name: library45.library.cornell.edu
- Userid: your nedid
- Password: ******
2. The prompt should be,"library45: /users/net id =>." Then type "sudo su – ctsbulk" and press enter. You will be prompted for your password again. After entering your password again issue the command for the job you wish to run. Jobs are listed in the the Bulk Loads List.
- Let this process run until finished. At that time the UNIX command prompt will be displayed and mail will have been sent to the appropriate people, including Library Systems staff. If the subject line of the SUMMARY mail file contains RC=0, then all is well. Any other RC means a potential problem.
- Bulk loading tips:
- Vendors aren't always case-consistent with their file names. If the FTP fails, try using lower- instead of upper-case in the file name, or vice versa.
- To view the basic CTSBULK command line(s) associated with a given command entry, type <command> <enter>.
- Example: To view the command lines associated with the general command "vendor_load", type: vendor_load <enter>.
- To stop a process before it has run to completion (for instance, if you discover you've misnamed an extract file), type: <control> c.
- Logout of the UNIX session, by typing: exit
- If you have any problems or questions, please contact Library Systems via CTSBULK-L.