User Tools

Site Tools


cat:pre-cats_adding_brief_title_records_to_the_pines_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
cat:pre-cats_adding_brief_title_records_to_the_pines_database [2019/08/27 07:04]
ehardy [Transferring precat items to a matching bibliographic record]
cat:pre-cats_adding_brief_title_records_to_the_pines_database [2019/08/28 14:34] (current)
ehardy [Miscellaneous reminders]
Line 26: Line 26:
  
   * MS Excel excludes initial zeros and spaces. Any scanned barcode that might have an initial zero(s) or space(s), either correctly or incorrectly,​ won’t have it in the Excel report. Check the tabular view of your precat report for any barcodes you cannot find in the database. Even in tabular view, initial spaces can be difficult to ascertain. Copying the entire cell usually picks up all spaces.\\   * MS Excel excludes initial zeros and spaces. Any scanned barcode that might have an initial zero(s) or space(s), either correctly or incorrectly,​ won’t have it in the Excel report. Check the tabular view of your precat report for any barcodes you cannot find in the database. Even in tabular view, initial spaces can be difficult to ascertain. Copying the entire cell usually picks up all spaces.\\
 +
 +  * MSExcel also limits the number of numbers that can be displayed correctly in a cell. You may see numbers stored as, for example, 9.6E+10 or 3.1E+26. These can be converted to numbers, however some may not convert correctly. 3.1E+26 converts to 310190058185431000000000000 when in reality it is 310190058185431019005818722. You can check the tabular view for any of these.\\
  
   * If a barcode is scanned incorrectly when creating a precat, the item will remain on a patron record when the actual item is returned. A common mis-scanning is extra spaces before or after the number. Catalogers should refer any suspicious barcode found on the report for an overdue or lost item to circulation staff for resolution. Then the precat should be sent back to cataloging for bibliographic resolution, once it has been removed from the patron record.\\   * If a barcode is scanned incorrectly when creating a precat, the item will remain on a patron record when the actual item is returned. A common mis-scanning is extra spaces before or after the number. Catalogers should refer any suspicious barcode found on the report for an overdue or lost item to circulation staff for resolution. Then the precat should be sent back to cataloging for bibliographic resolution, once it has been removed from the patron record.\\
cat/pre-cats_adding_brief_title_records_to_the_pines_database.txt · Last modified: 2019/08/28 14:34 by ehardy