View source

From ISFDB

You do not have permission to do that, for the following reason:

The action you have requested is limited to users in one of the groups user, Write.

You can view and copy the source of this page:

First 500 identified thus: 

 select p.pub_id , p.pub_isbn
 from pubs p
 where p.pub_pages is NULL
 and p.pub_isbn is not null
 and length(p.pub_isbn) = 13
 order by 2

This is to keep it to a manageable number, there are several thousand ISBN-10s. [[User:BLongley|BLongley]] 11:05, 27 June 2012 (UTC)

: Added Revised search to exclude '#', ebooks and audio books. 

 select p.pub_id , p.pub_isbn
 from pubs p
 where p.pub_pages is NULL
 and p.pub_isbn is not null
 and p.pub_isbn not like '#%'
 and p.pub_ptype != 'ebook'
 and p.pub_ptype not like 'audio%'
 and length(p.pub_isbn) = 13
 order by 2

[[User:BLongley|BLongley]] 12:03, 28 June 2012 (UTC)

== First batch completed ==

I finished that batch. No particular rush for the next batch though, I was taking a break from assigning languages to books from International publishers known to Wikipedia. I'm at least half-way through that project, and am going to go back to it for a bit. I may also deal with these B & N identifiers being stuck in the ISBN field. 

Along the way, I've been adding other data I found in the OCLC records that we didn't have included, then "WorldCat/OCLC Verifying" those books. For those publications where there is no OCLC record should I mark them as "N/A"? It seems there might be some value in doing so, but on the other hand it's always possible that WorldCat would add a record for such books at a later time. [[User:Chavey|Chavey]] 15:54, 29 June 2012 (UTC)

: I'd be reluctant to mark as "N/A": just because some of the details may be found under another OCLC record that doesn't use the same ISBN (I've seen people link to the relevant OCLC record where an ISBN link isn't enough). But I'm not an OCLC expert by any means. [[User:BLongley|BLongley]] 19:31, 29 June 2012 (UTC)
::Since OCLC records are the results of cataloging entries at member libraries, it is always possible for a library to acquire and add a record to Worldcat for any publication at any time, so I would be reluctant to mark a pub N/A on the Worldcat row. A note 'No matching OCLC record found as of <date>' could be added if you like, but even that I would only do after searching on both title and ISBN, at least. Some OCLC records fail to list the ISBN at all, and some list variant ISBNs (for library bindings, often). -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 02:35, 13 July 2012 (UTC)

Return to ISFDB talk:Page Count Clean Up.

Retrieved from "http://www.isfdb.org/wiki/index.php/ISFDB_talk:Page_Count_Clean_Up"

View source

From ISFDB

Views

Personal tools

Navigation

Search

Toolbox