|
|
| (2 intermediate revisions by one other user not shown) |
| Line 4: |
Line 4: |
| |- | | |- |
| !Application: | | !Application: |
| |name of topic | | |Shelving list in Call number order |
| |} | | |} |
| </div> | | </div> |
| Line 15: |
Line 15: |
| </div> | | </div> |
| </div> | | </div> |
| ==Goal==
| |
| Create a list of books in call number order for shelf reading
| |
|
| |
| ==Prerequisites and preparations==
| |
| Bulk Edit and Excel
| |
|
| |
| ==Procedure 1==
| |
| Explain the outcome of this procedure. In the table below, list each high-level step which will be documented in detail below the table.
| |
| {| class="wikitable" style="width:100%;"
| |
| ! style="vertical-align:middle;text-align:center;width:80px;" |Step
| |
| !What to do
| |
| !Notes
| |
| |-
| |
| | style="vertical-align:middle;text-align:center;width:80px;" |1
| |
| |Query search in Bulk Edit
| |
| |
| |
| |-
| |
| | style="vertical-align:middle;text-align:center;width:80px;" |2
| |
| |Download report in a .csv
| |
| |
| |
| |-
| |
| | style="vertical-align:middle;text-align:center;width:80px;" |3
| |
| |Sort by Effective Shelving Order, look for major errors and correct the Effective Sorting column
| |
| |
| |
| |}
| |
|
| |
| ===Step-by-step instructions===
| |
|
| |
| #'''Using Bulk Edit, choose the second tab which is a query. Choose items. Start your query with "Item Effective call number...Starts with.....A". (Example) Add "Item Effective Location Name ....equals....Bookstacks". If the Item Effective Location Name is small enough, you can search by this query only. Large collections of 5000 can take a while.'''
| |
| #Check the list of column names that you want in your export. Be sure to use the first Call number in the list since this refers to the holdings Call number and is where I have found issues. Item HRID, Title, Barcode, Item Level Call Number Type, Status, Volume, and Copy number.
| |
| ##'''Export your list to the download location'''
| |
| #'''Once you have a csv in Excel, you can eliminate the columns that you won't need. I would keep Item HRID for updating your inventory later. Sort by the Excel csv by the column labeled "Effective Shelving Order" Look at the very top of the file for mistakes or at the very bottom in the first Call number column where you will find items out of order or with blank spaces. This is usually due to the wrong "Item Level Call Number Type" or no Call number in the Holdings.'''
| |
| #Next you will need to correct the "Effective Shelving Order" for any item that had mistakes.
| |
| ##PS5 .W34 K2 1994 becomes PS 15 W34 K2 41994 11. PS45 .W34 K2 1994 becomes PS space245space no period W34 K2 space 41994 11 for copy 1, PS567 .W34 K2 1994 becomes PS space 3567 space no period W34space K2space 41994 12 for copy 2, PS7890 W34 K2 1994 becomes PS space no period W34 space K2space 41994 11 if copy 1 The Volume comes before the copy number and is a space V4 space. You will notice that the number 1-4 is placed in front of the number of digits and is determined by how many digits in the first part of the call number. The same with the year although that number is almost always 4.
| |
|
| |
| ==Procedure 2==
| |
| Explain the outcome of this procedure. In the table below, list each high-level step which will be documented in detail below the table.
| |
| {| class="wikitable" style="width:100%;"
| |
| ! style="vertical-align:middle;text-align:center;width:80px;" |Step
| |
| !What to do
| |
| !Notes
| |
| |-
| |
| | style="vertical-align:middle;text-align:center;width:80px;" |1
| |
| |
| |
| |
| |
| |-
| |
| | style="vertical-align:middle;text-align:center;width:80px;" |2
| |
| |
| |
| |
| |
| |-
| |
| | style="vertical-align:middle;text-align:center;width:80px;" |3
| |
| |
| |
| |
| |
| |}
| |
|
| |
| ===Step-by-step instructions===
| |
|
| |
| #'''Do''' step 1
| |
| #'''Do''' step 2
| |
| ##'''Do''' substep 2.1
| |
| #'''Do''' step 3
| |
|
| |
| ==Related pages==
| |
|
| |
| *Link to related page 1
| |
| *Link to related page 2
| |
