Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home > SOLAR > Operating > Processing Routine

SOLAR Processing Routine

The processing routine by which bibliographic data is prepared and loaded into SOLAR is currently being "fine-tuned". 

Current Practice for Processing Bibliographic Data
Task Further Explanation Software / Technique
Receive new file via disc, ftp or other means.
Copy file to work area, apply standard name		 Standard name consists of 3-character abbreviation for library followed by date in ymmdd format, e.g. abc21130 for Nov 30, 2002 file from library abc. Normal file handling utilities.
Convert to MARC if necessary   MARCPrep... Tasks... Convert LIF2MARC or LH2MARC
Load File into dbf file. Use standard name with .dbf extension. MARCPrep... File... Create
Analyze file.
  1. Convert to MARC if necessary
  2. Count records, isbns, lccns, etc.
  3. Note placement of local info
  4. Log results to file tracker page. 
 Software will provide all necessary info for most files. MARCPrep... Tasks... Analyze
MARCPrep... View... View MARC (or View LIF 87)
Prep the dbf file
  1. Merge unify item info as needed
  2. Insert encoding level as needed
  3. Move local info to 945 subfields
   MARCPrep... Tasks... Prep
Normalize match and confirm fields: 001, 010, 020, 022, 245, 260_d
  1.   Trim trailing material in 010, 020, 022
  2.   Strip leading blanks from 010
  3.   Strip hyphens from isbn
  4.   Strip hyphens from lccn, insert zeros as needed 
  5.   Put title in upper case
  6.   Strip "c" from date
  7.   Keep only most recent, if multiple dates 
 Normalize fields MARCPrep... Tasks... Normalize
(If not an initial load, export fresh abc library mirror from HDB.  Match incoming file against it by barcode.      
  1. Delete abcymmdd.dbf records that match
  2. Create abckill.dbf file of abc mirror records not in abcymmdd
  3. Create abcymmddadd.dbf
 Match and confirm with filter MARCPrep... Tasks... Match lib mirror
Match abcymmdd.dbf against resource files
  1. Match against hdmirror.dbf to create abcymmddm.dbf
  2. Match against lcward.dbf to create abcymmddw.dbf
  3. Create abcymmddr.dbf file of rejected records
 Match and confirm MARCPrep... Tasks... Match HDB Mirror
MARCPrep... Tasks... Match LCWard
Write abcymmddm.dbf to abcymmddm.mrc, abcymmddw.dbf to abcymmddw.mrc, abcymmddr.dbf to abcymmddr.mrc Write to MARC MARCPrep... File... Export to MARC
Load .mrc files    Through Innovative software
Generate reports
  A. Counts for records...
  1.     in HDB from beginning
  2.     submitted (abcymmdd.dbf)
  3.     killed (abcymmddk.dbf)
  4.     matched on hdb (abcymmddm.dbf)
  5.     matched on lc (abcymmddw.dbf)
  6.     added (abcymmddm.dbf + abcymmddw.dbf)
  7.     rejected (xyzrejct.dbf)
B. Print load summary and error report		   MARCPrep... Tasks... Reports - All