How do I find items with duplicate barcodes?

Applies to

• Report Designer
• WorldShare Reports

Answer

This is only for those who have Report Designer as part of their subscription to WMS. You can tell if you have this aspect, as you will see Report Launch Pad when you select Reports under the Analytics tab.

This report can be used in several ways by adjusting the query filters and result objects.

To locate the OCLC numbers of items that have duplicate Item Barcodes do the following:

1. Select Analytics Reports > Report Launch pad.
2. Select Application > Web Intelligence at top of screen.
3. Select the New icon from the tool bar.
4. Select Universe > Ok > LHR Item detail > OK.
5. Open Title folder > select OCLC number > drag into the Results Object box.
6. Select Title and drag into the Results Object box
7. Select Author name  and it drag into the Results Object box
8. Select LHR Item details folder  > LHR Item barcode.
9. Select LHR Item details folder  > select LHR Item call number  and drag into the Results Object box ,in the order you want them to appear.
10. Then add Query Filter  > Measures > LHR Item Count > drag into Query filters  box> select  Greater than > type 1./li>
11. Then select > LHR Item details folder  > LHR Item barcode > drag into Query filters box > select  Not equal to > type N/A.
12. Select >  Run query to see preview of results /select refresh if you alter the report objects  or query filter settings.
13. Then  select Save as >  Items with Duplicate barcodes > in your  web intelligence folder for your branch.
14. You can then export this Report to excel or a PDF if you wish.
     

To locate  duplicate Item Barcodes appearing on different bib Records do the following:

1. Select > Analytics > Reports > Report Launch pad.
2. Select > Application > Web Intelligence at top of screen.
3. Select > New icon  from the tool bar.
4. Select > Universe > Ok > LHR Item detail > OK
5. Select > LHR Item details folder  > LHR Item barcode > drag into top box.
6. Select > Measures folder  > LHR Item count > drag into the Results object box
7. Then add Query Filter  > Measures > LHR Item Count > drag into Query filters > select  Greater than > type 1.    
8. Select >  Run query to see preview of results /select refresh if you alter the report objects  or query filter settings.
9. Then  select Save as > Items with Duplicate barcodes appearing on different Bib records> in your  web intelligence folder for your branch.
10. You can then export this Report to Excel or a PDF if you wish.
11. Once you have your list of Barcodes, you will then need to search for these in Circulation, to locate these items with identical barcodes and alter one. 

Page ID