Documentation to do a Bookshelf Batch review (from AquaBrowser to Summon)

Download spreadsheet from http://digitalcommons.brockport.edu/cgi/editor.cgi?window=batch_revise&context=bookshelf

Open in Excel, add filter. Filter column C (ext_link) to remove blanks. Visually verify remaining cells to identify anomalies. (Found – 2 cells with bro:000, several more with no leading 000 – filtered out the first 2, and added the leading 000s to the second batch). Insert 2 columns to the right of C, in the first column enter 1 and fill down. In the second column, enter the formula =Concantenate (c,d) and fill down. Copy and Paste Special (values) the results of column E into column C. You should now have the AquaBrowser links with the additional digit “1” as required.  You can now delete the extra columns D & E. In column C, do a find and replace:

http://brockport.aquabrowser.com/?q=bib:

http://brockport.summon.serialssolutions.com/search/document?id=FETCHMERGED-brockport_catalog_BRO

Unfilter, and remove filters. Save in .xls format.

Go to editor and upload spreadsheet. Successful upload will generate:

Note: You have uploaded Summon_Mon_Aug_04_05_04_08_2014.xls. You will receive a confirmation email after the system processes your spreadsheet. The email contains links that allow you to accept or cancel your changes.

It is advisable to upload a small subset first to see if there are any problems, but in the worse case scenario, you can download the previously generated worksheet to restore the site. 

Email to accept changes will be generated after a bit. Review and accept. 

We have received Summon_Mon_Aug_04_05_04_08_2014.xls. Please review the following summary and accept or cancel your revisions.

• Submissions: 344
• Submissions Revised: 340 (98.84%)
• New Submssions: 0 (0.00%)
• Columns Revised: buy_link, identifier, ext_link, publication_date
• Cells Revised: 344 (1.52%)

Note: "Accept Changes" queues all revisions for publication.

ACCEPT CHANGES: http://digitalcommons.brockport.edu/cgi/editor.cgi?window=batch_revise_confirm&context=bookshelf&importq_key=60831&confirm=1

CANCEL CHANGES: http://digitalcommons.brockport.edu/cgi/editor.cgi?window=batch_revise&context=bookshelf&cancel=1

You have successfully made 344 changes in Brockport Bookshelf. Note: these changes will not be live until you update the site.

To preview revisions: click here
To update the site: click here   

Preview, update and you're done! 

Well, after you check the live results. You can always contact support if you run into any problems along the way.