Admin

If there are too many to delete and/or time consuming, send a help request to SpringShare.

In you help request include the site number which is 256. Ask for all zero count assets to be deleted expcept the  A-Z assets.

Merging Duplicate Assets   

documentation https://ask.springshare.com/libguides/faq/1241

      This document includes the downloadable template sending the assets to SpringShare

Procedure for creating a Duplicate Assess List 

 Make sure all you zero count assets have been deleted by you or SpringShare

1. Download from the Assets screen 

• Libguides > Content > Assets
• Select the Asset Type (easier to work with one type at a time)
• Select "Export all Records and choose CSV format
• The CVS file will open in an EXCEl sheet, Always save as a CVS file.

Sort the File

1. Delete columns labeled  Type, Description, Subject, and Update
2. Do a custom sort  by URL - This will put duplicate URLs together

Finding the duplicate assets from the huge spreadsheet file

From the Home Ribbon

• Select condional formatting
• Select Highlighting Cell rules
• Select Duplicate Values
• Select cell highlighting - I usual do "Light Red Fill"
• Sort file by higlighted cells
  • Sort by URL and Cell Fill
• Delete all the non-higlighted asset records - The Highlighted record are at the bottom of the fileFormat all cell
• Format all cells to text - I f you two assets alike, you can just copy and paste into the template bu if you have more than two duplicates of the same assets you will use the "TEXTJOIN: FUNCTION"
• When you  send the temmplate to SpringShare, also request that they delete the zero count assets that the merge will create.

Check for Accessiblity

Add  the WAVE extention from Chrome

https://chrome.google.com/webstore/detail/wave-evaluation-tool/jbbplnpkjmmeebjpijfedlgcdilocofh?hl=en-US 

Checking for Broken Links

SpringShare has a link checker but it is hit and miss. It is located under Tools on the admin bar.

• Run CheckLinker
• Export to Execl
• In an empty cell of the record row put in this formula  =HYPERLINK(D2,D20
• Then use the Fill Hander to copy down the column

What if you can’t find the fill handle in Excel?

Don’t worry if the fill handle is not working in your Excel workbooks. There is an option to enable it (although it is enabled by default, it may happen that you disable it by mistake).

Here is how to enable the fill handle in Excel:

1. Go to File –> Options.
2. Select Advanced from the left pane in the dialogue box.
3. In the Editing Options section, ensure that you have the Enable fill handle and cell drag-and-drop option checked.
4. Click OK.

• After you get active hyperlinks, you can click on them to if the links are really broken
• Highlight the broken links
• To find the pages that links are on, use the Assets module and put the links in the filter to find the guide.