LCLS: CAP Manual: Database Management

LOADING LTI AUTHORITY FILES

 

Exporting Records

  

        The report LTI Export will run on Thursday sometime after midnight. 

 

1.     On Thursday, log into Workflows  and right-click on the MARC Export wizard. 

 

2. Select Properties,

 

3. Check settings. They should be as follows:

 

Include 999 holdings tag: Unchecked

Include local & junk tags: Checked

Format of the output file: MARC

Encoding scheme: MARC8

Export all records to one file

View all records

 

Make changes as needed. Click on OK.

 

 

 

 

 

4.     Invoke the MARC Export wizard.

 

5.     Check “Records selected on..." – should be from Thursday sometime after midnight.

 

6. Save exported records: On client.

 

7. File name on client: Use the gadget to select a location on your hard drive for the file.  Name the file using the following naming convention:

                                      SCRANmmddyy.IN

Example:  A file exported on November 27, 2003 would be named SCRAN112703.IN.

 

 

 

 

8.     Click on Export.

 

9.  The export process begins and will take several seconds.  When export is complete, a word processing program on your PC will open with a brief report including number of records exported.  The number should be greater than zero. 

 

 

 Submitting the Records to LTI

 

1.     Open FTP Surfer and connect to LTI. (The address is ftp.librarytech.com. The User Name is SCRAN.)  

 

2.     Click on the Upload icon.  Locate the file on your hard drive and click Open.

 

3.     After transfer is complete, disconnect from FTP Surfer site. 

 

4.     Wait at least 30 minutes before proceeding with the remainder of these instructions.

 

 

 

Retrieving the files from LTI

 

1. Re-connect to the FTP Surfer / LTI .

 

2. Select (highlight) the following six files by pressing CTRL and clicking on the files:

                   SCRANmmddyy.OUT

                   SCRANmmddyy.LCN

                   SCRANmmddyy..LCS

                   SCRANmmddyy.LCJ

                   SCRANmmddyy.ACF

                   SCRANmmddyy.ULH

 

    3. Right-click and select Download.

 

    4. When the download process has finished, disconnect from the FTP Surfer site.

 

    5. Open the ACF file in Excel. Print it out.

 

    6. Open the ULH file in Word.  Print it out. 

 

 

Importing  the Files into Unicorn

 

1.     Open the MarcImport wizard.

 

2.     Under the Import tab, select File Type: MARC.

 

3.     In the “Source” field use the gadget to locate the file on your hard drive. Enter the Destination file name. See the chart below.

 

Important:  Import these files one by one.  The Destination file name must be in CAPs  as indicated in this table:

 

“Source”	“Destination” ALL CAPS	Description
mmddyy.OUT	LTIBIB	“Cleaned- up” records
mmddyy.LCN	LTINAME	New name authority records
mmddyy.LCS	LTISUBJECT	New subject authority records
mmddyy.LCJ	LTIJUV	New juv subject authority records

 

 

4.     Click Import.

 

5.     When asked if the diskette is ready, answer Yes.

 

6.     When asked if there are more files to download, answer No.  A word processing program on your PC will open with a report.

 

7.     Close the word processing program.

 

8.   Repeat steps 2-7 to load the remaining files.

 

 

Loading the records into Unicorn

 

        Four reports are scheduled to run each Thursday night to load the files you just imported:

                    BibloadLTIJUV

                    BibloadLTIBIB

                    BibloadLTINAME

                    BibloadLTISUBJECT

 

If you need to force the loads (e.g.; you are performing these instructions on a day other than Thursday), you should “duplicate” these reports and schedule them “ASAP”.