BioOne Complete

Overview:

BioOne Complete is a collection of eBooks and eJournals. We maintain this with OCLC records. A KBART file can be found here:

http://www.bioone.org/action/institutionAdmin?page=sfxreport&iuid=1965 (login is required and details are available in the elecres file).

Monthly, the KBART file is to be compared against the KBART uploaded to the sqlite database

Z:\GenLoad\BioOne

As rows in the KBART file there become replaced, be sure to add a date value to the field RowReplaced. Rows with RowReplaced NULL should be understood to be current.

Bib values should be added to the table biooneIDtoBib as new titles are cataloged or cataloging changes.

Queries:

update tempKBART

set date_last_issue_online = '9999-12-31'

where date_last_issue_online is null OR date_last_issue_online = '';

--test for lost data

select a.title_id, a.publication_title, b.title_id, b.publication_title

,*

from bioonekbart a

left join tempKBART b on b.publication_type = 'Serial' and a.title_id = b.title_id and a.date_first_issue_online = b.date_first_issue_online and a.date_last_issue_online = b.date_last_issue_online and a.title_url = b.title_url

where 1=1

and a.publication_type = 'Serial'

--and b.title_id is null

--test for new data

select a.title_id, a.publication_title, b.title_id, b.publication_title

,*

from tempKbart a

left join bioonekbart b on b.publication_type = 'Serial' and a.title_id = b.title_id and a.date_first_issue_online = b.date_first_issue_online and a.date_last_issue_online = b.date_last_issue_online and a.title_url = b.title_url

where 1=1

and a.publication_type = 'Serial'

and b.title_id is null