Thieme eBooks

Overview:

Thieme (pronounced Tee-muh, it's German), provides eBooks. The updates are sporadic but mostly only annually. To ensure nothing is missed, we just check once per month against the file they make available on their website.

We began tracking Thieme eBooks for regular maintenance in August 2015.

Ticklers

Z:\GenLoad\Thieme\ReadMe.txt

Maintenance:

You can find a spreadsheets to compare the current title list from Thieme against the prior month's. From there, you can do an A-B analysis to see if any of the titles have changed.

"Z:\GenLoad\Thieme\Monthly Audit"

• 1. Download the file available here: Thieme E-Book Library - Link List / Doody Scores

  2. The first you'll notice is whether or not Linklist: date has changed.

• 1. If the dates are the same, it is unlikely that there will be any updates.

  2. In the saved most recent prior link list, do a move or copy to get the link list into the new spreadsheet (right click on the tab):

• 1. Rename the tab, "Prior Link List"

  2. Add a column before column A and name it "Still there"

  3. In the current tab, right click and add two new columns to the left of Column A. Name the newly added column A "Match" and column B, "Lookup".

  4. In cell B10 (second column, the first row below the headings), add this formula: "=F10&K10"

  5. In cell A10 (first column, the first row below the headings), add this formula: "=MATCH(F10&K10,'Prior Link List'!C:C,0)"

  6. Fill the rows down and look for any "#N/A" values in column A (You may need to refill the values down in the "Prior Link List" column C).

  7. Any #N/As indicate new titles and should be cataloged

  8. Go to Prior Link list tab and in cell A10, add this formula, "=ROW()=B10"

  9. Fill down the formula and look for any FALSE values. Any found could indicate the need to withdraw the title. Check access and proceed accordingly.

  10. Once done, save the spreadsheet in the same directory as the prior ones "YYYYMM_Thieme_E-Book_Library_Link_List_en.xlsx"

To check against what is already in the catalog

Steps for maintenance are:

Link List Here: https://www.thieme.de/en/thieme-connect/product-information-13542.htm

1. Search for tkr=(FBoU)Thieme 2015*

2. Save Hols and convert to Bibs list

3. print-03 the ISBNs associated with those titles

4. download and put in a spreadsheet with the LinkList

5. Parse it out by columns so that the ISBN is by itself with bibs...

   1. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D2,"$a",""),"$z",""),"$q"," ")

   2. paste values

   3. split by " " and don't import that junk

6. do a lookup for each ISBN/EISBN to find the associated Bib

• 1. =INDEX('Aleph Bibs'!A:A,IFERROR(MATCH(TRIM(E10),'Aleph Bibs'!F:F,0),MATCH(TRIM(F10),'Aleph Bibs'!F:F,0)))

7. Review titles w/o a found bib

8. Review any bibs without a found title

9. Download the 856 values for the Bibs and add to a new sheet in the workbook

10. text to columns

11. for the URL column, use the following formula to extract just the URL: =SUBSTITUTE(SUBSTITUTE(MID($D2,(FIND(E$1,$D2)+3),IFERROR(FIND("quot;,$D2,(FIND(E$1,$D2)+3))-(FIND(E$1,$D2)+3),LEN($D2)-(FIND(E$1,$D2)+2))),"http://ezproxy.fau.edu/login?url=",""),"pdfreader","reader")

12. On the Linklist page, create a formula to normalize out the pdfreader phrase from the vendor links (to reader): =SUBSTITUTE(J10,"pdfreader","reader")

13. match the URLs from the found bibs on the Linklist page, pull them in and then match them

14. review and update any non-matches or non found Bibs