search

HeardLibrary / vandycite

0 stars 0 forks source link

Go through Charlotte's Excel sheet and find out why the red ones didn't get uploaded #72

Closed baskaufs closed 2 years ago

baskaufs commented 2 years ago

Spreadsheet is https://github.com/HeardLibrary/vandycite/blob/master/divinity_law/DOI%20Faculty%20Chapters.xlsx

baskaufs commented 2 years ago

Started working on this by looking for books where all of the chapters of the books were by the book author. The books involved were here. However, when I ran the script to get the data from Crossref, only one of the books wasn't already in Wikidata. Another of the DOIs listed was not actually for the book, but for an author list. See the errors list for details.

Ran Vanderbot for the one remaining book and created Q111724597.

baskaufs commented 2 years ago

Went back through the spreadsheet again, this time looking for book chapters where the authors of the various chapters were different from each other and from the book editor. Those chapters are in the file doi_faculty_chapters_to_add_2022-04-25.csv. However, prior to trying to write those chapters, I checked the notes column to look for DOIs that were available for the containing books. Those containing book DOIs were transferred to containing_books_2022-04-25.csv, and I then tried to create them with the script before doing the chapters. Two of the containing book DOIs were already in Wikidata: 10.4135/9781608712427 and 10.4324/9781315243191 and two were book chapters and therefore dropped at this stage.

After uploading the containing books, I went back and created the book chapters. The following were already in Wikidata:

The book chapters that were uploaded are in articles_2022-04-26_book_chapters.csv