Difference between revisions of "Publisher talk:DAW"

From ISFDB
Jump to navigation Jump to search
Line 174: Line 174:
 
* #1262, 0-7564-0146-1 at $6.99 - ''The Riven Shield'' by Michelle West - Added reprint
 
* #1262, 0-7564-0146-1 at $6.99 - ''The Riven Shield'' by Michelle West - Added reprint
 
* #1291, 0-7564-0191-7 at $6.99 - ''Conqueror Fantastic'' by Pamela Sargent (ed) - Add "(ed)" - contributor role
 
* #1291, 0-7564-0191-7 at $6.99 - ''Conqueror Fantastic'' by Pamela Sargent (ed) - Add "(ed)" - contributor role
 +
* #1320, 0-7564-0246-8 at $25.95 - ''Sanctuary'' by Mercedes Lackey - swapped rows so that the hardcover retail edition is before the book club edition.
 
* #1321, 0-7564-0281-6 at $6.99 - ''Renaissance Faire'' by Andre Norton (ed); Jean Rabe (ed) - moved this title from "Unknown Logo #" to 1321 as a "best guess".  There was a hole in the logo #s at 1321 and this title fits into that spot based on its publication date.  There may be some shuffling of titles in this area in as publications get verified because things like #1330 were mis-printed with #1326, etc.
 
* #1321, 0-7564-0281-6 at $6.99 - ''Renaissance Faire'' by Andre Norton (ed); Jean Rabe (ed) - moved this title from "Unknown Logo #" to 1321 as a "best guess".  There was a hole in the logo #s at 1321 and this title fits into that spot based on its publication date.  There may be some shuffling of titles in this area in as publications get verified because things like #1330 were mis-printed with #1326, etc.

Revision as of 14:33, 18 April 2007

Significant DAW List Revisions

  • Filled in the Binding column based on those titles that noted the binding using "(Pb)", "(Hc)", etc. in the title and removed the binding indicators from the titles. --Marc Kupper 01:27, 4 Nov 2006 (CST)

Archive

To keep the size of this page manageable discussions get archived from time to time.

DAW List restructuring

With the latest additions to the DAW list it’s now 771K bytes and I need to put some effort into slimming down. Before doing that I should note the spreadsheet has two columns that are not shown on the web page. These are the page count and a “notes” field.

My thoughts on slimming down are:

  1. Keep the basic table layout the same but break into one page per year (32 pages). This would get the individual page size to a manageable level but the tables still present a lot of data.
  2. Remove some columns and instead work on actively linking them to ISFDB where you can see the details. I’ve already started on the link to ISFDB with the authors and am doing a pass to fill in the titles/publications. I believe the following columns can be dropped:
  • Pub Date (this is computed from First-pub)
  • Series – this is mostly junk
  • Genre
  • Copy
  • Artist
  • Verified (color coding should be enough)

I would much prefer the second option and also ideas for other columns that could get dropped. Marc Kupper 19:26, 24 Dec 2006 (CST)

This is such a massive undertaking that I really hesitate to comment since I am probably failing to grasp some implications of the two options. With that caveat, I am thinking that ideally the whole thing would be broken up by year, driven by the ISFDB -- with the exeption of a few data elements that the ISFDB doesn't capture -- and regenerated nightly.
I have been thinking of ways I could implement this as I don’t want to suck too much bandwidth away from Al. One of the projects on my queue is I want to run a copy of the ISFDB database so I can play with some queries that the public UI does not offer such as converting an author+title to a title_id and converting an ISBN to a pub_tag plus to play with ways to have ISBDB build the DAW list. Before starting on that project though I have two DAW list related projects I want to get out of the way.
  1. Finish merging my old DAW list into the ISFDB list. The intent of this merge is to focus my attention on discrepancies, such as that $233.58 price you saw, and to research/resolve each one. I have about 5000 rows of DAW publication data and have been going through this vs. the DAW list a field at a time. When I hit the copyright field I realized I’d be better off filling this in from other sources and over the past couple of weeks had been doing exactly that for all of the titles in the list. Now that copyright is out of the way I can get back to the data diff/merge.
  2. Do a pass to verify the publication dates, particularly for publications released after 2001. In this period DAW was doing a lot of first pub as a hardcover and a year later a pb with a new pub-date. For many listings the DAW list has the same date for the hc and pb release and so it’s a matter of looking up the pb date and fixing the list. Marc Kupper 23:38, 24 Dec 2006 (CST)

Miscellaneous DAW List Updates and Corrections

Miscellaneous updates Marc Kupper (talk) 05:08, 7 Feb 2007 (CST)

  • The Printing column was renamed to "Pr." and the table now uses one row per printing rather than combining all of the printings at a single ISBN/price on a single line. This will make verification more reliable plus gets around the issue of the 1st printing sharing a row with later printings and the "Pub Date" would be inaccurate. As a result about 30 rows were added to the table that are duplicates of the previous row except for the printing # is changing.
  • #33, UY1169, No ISBN at $1.25 - Transit to Scorpio by Alan Burt Akers - The Logo # was dropped per physical verification.
  • #49, UY1191, No ISBN at $1.25 - The Suns of Scorpio by Alan Burt Akers - The Logo # was dropped per physical verification.
  • #111, UQ1121, No ISBN at $0.95 - The Paradise Game by Brian M. Stableford - corrected the first printing date from July-1974 to June-1974
  • #716, UE2372, 0-88677-372-5 at $3.99 - Godslayer by Mickey Zucker Reichert - binding corrected from tp to pb
  • #1283, 0-7564-0256-5 at $15.95 - The Collected Short Fiction of C.J. Cherryh by C. J. Cherryh - reprint pub-date corrected from 2004-02 to 2005-02

Physical verification

  • #66, UY1178, No ISBN at $1.25 - Pandora's Planet by Christopher Anvil
  • #111, UQ1121, No ISBN at $0.95 - The Paradise Game by Brian M. Stableford
  • #289, UW1377, 0-87997-377-3 at $1.50 - The City of the Sun by Brian M. Stableford
  • #393, UJ1549, 0-87997-549-0 at $1.95 - The Year's Best Horror Stories: Series VIII by Karl Edward Wagner (ed)
  • #777, UE2347, 0-88677-347-4 at $4.50 - The Master of Chaos by Terry A. Adams
  • #1010, 0-88677-673-2 at $5.50 - The Eye of the Daemon by Camille Bacon-Smith

Miscellaneous updates Marc Kupper (talk) 20:01, 12 Feb 2007 (CST)

  • #36, UE1906, 0-87997-906-2 (11th) at $2.50 - Darkover Landfall by Marion Zimmer Bradley - Added/verified printing
  • #36, UE1906, 0-87997-906-2 (11th) at $2.50 - Darkover Landfall by Marion Zimmer Bradley - physical verification
  • #36, UE2234, 0-88677-234-6 (19th) at $5.99 - Darkover Landfall by Marion Zimmer Bradley - Changed spine from UE to ISBN3
  • #36, UE2234, 0-88677-234-6 at $3.99 - Darkover Landfall by Marion Zimmer Bradley - pub has UE2234 code, was marked "None" and is ISBN3, nor ISBN
  • #191, UE2308, 0-88677-308-3 (17th) at $5.99 - The Shattered Chain by Marion Zimmer Bradley - physical verification
  • #191, UJ1327, 0-87997-327-7 at $1.95 - The Shattered Chain by Marion Zimmer Bradley - Add printing
  • #388, UE1540, 0-87997-540-7 at $2.25 - Two to Conquer by Marion Zimmer Bradley - Add printings
  • #600, UE1962, 0-87997-962-3 at $3.50 - City of Sorcery by Marion Zimmer Bradley - ISBN to ISBN2, add printings
  • #642, UE2075, 0-88677-075-0 at $2.95 - Warrior Woman by Marion Zimmer Bradley - ISBN to ISBN2
  • #707, 0-7564-0043-0 at $7.99 - In Conquest Born (15th Anniversary Edition) by C. S. Friedman - This seems to be a reissue with new content as the page count went from 511 to 560
  • #806, 0-7564-0305-7 at $15.00 - Sunrunner's Fire by Melanie Rawn - Physical verification
  • #864, UE2527, 0-88677-527-2 at $5.99 - Black Sun Rising by C. S. Friedman - physical verification
  • #864, UE2527, 0-88677-527-2 at $6.99 - Black Sun Rising by C. S. Friedman - physical verification
  • #891, UE2534, 0-88677-534-5 at $20.00 - Winds of Change by Mercedes Lackey - physical verification
  • #929, 0-88677-593-0 at $None - Darkover by Marion Zimmer Bradley (ed) - Add hc book club edition
  • #1018, 0-88677-689-9 at $21.95 - Inheritor by C. J. Cherryh - physical verification
  • #1024, 0-88677-705-4 at $21.95 - Exile's Song by Marion Zimmer Bradley - physical verification
  • #1070, 0-7564-0458-4 at $9.99 - A Thousand Words for Stranger by Julie E. Czerneda - correct title case
  • #1070, 0-7564-0458-4 at $9.99 - A Thousand Words For Stranger by Julie E. Czerneda - Reprint at $9.99 (DAW's highest pb price to date)
  • #1078, 0-88677-770-4 at $23.95 - Prince of Dogs by Kate Elliott - physical verification
  • #1099, UE2802, 0-88677-802-6 at $24.95 - Owlsight by Mercedes Lackey; Larry Dixon - physical verification
  • #1109, 0-88677-810-7 at $24.95 - Traitor's Sun by Marion Zimmer Bradley - physical verification
  • #1113, UE2826, 0-88677-826-3 at $23.95 - Guardian of the Balance by Irene Radford - physical verification
  • #1120, UE2833, 0-88677-833-6 at $24.95 - The Black Swan by Mercedes Lackey - physical verification
  • #1129, UE2849, 0-88677-849-2 at $24.95 - Mountain of Black Glass by Tad Williams - physical verification
  • #1145, UE2874, 0-88677-874-3 at $23.95 - Guardian of the Trust by Irene Radford - physical verification
  • #1183, UE2994, 0-88677-994-4 at $23.95 - Guardian of the Vision by Irene Radford - physical verification
  • #1195, 0-7564-0005-8 at $23.95 - The Prince of Shadow by Curt Benjamin - physical verification
  • #1203, 0-7564-0020-1 (1st) at $7.99 - Defender by C. J. Cherryh - Corrected printing from "1st pb" to just "1st"
  • #1222, 0-7564-0070-8 at $24.95 - Fantasy: DAW 30th Anniversary by Elizabeth R. Wollheim (ed); Sheila E. Gilbert (ed) - physical verification
  • #1227, 0-7564-0083-X at $23.95 - Sorcery Rising by Jude Fisher - physical verification
  • #1251, 0-7564-0078-3 at $24.95 - Guardian of the Promise by Irene Radford - physical verification
  • #1260, 0-7564-0145-3 at $23.95 - Wild Magic by Jude Fisher - physical verification
  • #1263, 0-7564-0147-X at $6.99 - Space, Inc. by Julie E. Czerneda - Physical verification
  • #1271, 0-7564-0206-9 at $24.95 - Exile's Valor by Mercedes Lackey - physical verification
  • #1283, 0-7564-0256-5 at $15.95 - The Collected Short Fiction of C.J. Cherryh by C. J. Cherryh - Physical verification
  • #1297, 0-7564-0220-4 (2nd) at $6.99 - Grasp the Stars by Jennifer Wingert - Add row for 2nd printing and physical verification
  • #1306, 0-7564-0161-5 at $24.95 - Phoenix and Ashes by Mercedes Lackey - physical verification
  • #1327, 0-7564-0260-3 at $24.95 - Migration by Julie E. Czerneda - physical verification
  • #1327, 0-7564-0346-4 at $7.50 - Migration by Julie E. Czerneda - Corrected printing date
  • #1345, 0-7564-0310-3 at $7.50 - Time After Time by Denise Little (ed) - Physical verification
  • #1347, 0-7564-0282-4 at $6.99 - The Radioactive Redhead by John Zakour; Lawrence Ganem - Physical verification
  • #1350, 0-7564-0382-0 (1st) at $7.99 - The Skewed Throne by Joshua Palmatier - Physical verification
  • #1355, 0-7564-0408-8 (1st) at $7.99 - Pretender by C. J. Cherryh - Physical verification
  • #1358, 0-7564-0309-X at $7.50 - Novel Ideas-Fantasy by Brian M. Thomsen (ed); Martin H. Greenberg (ed) - Physical verification
  • #1359, 0-7564-0172-0 at $25.95 - Karavans by Jennifer Roberson - Physical verification
  • #1362, 0-7564-0345-6 at $24.95 - Regeneration by Julie E. Czerneda - Physical verification
  • #1363, 0-7564-0412-6 at $7.99 - The Four Forges by Jenna Rhodes - First pb reprint
  • #1365, 0-7564-0415-0 at $7.99 - Smoke and Ashes by Tanya Huff - First pb reprint
  • #1368, 0-7564-0339-1 at $15.00 - The Mirror Prince by Violette Malan - physical verification
  • #1368, 0-7564-0423-1 at $7.99 - The Mirror Prince by Violette Malan - First pb reprint
  • #1371, 0-7564-0422-3 at $7.99 - Inda by Sherwood Smith - First pb reprint
  • #1373, 0-7564-0388-X (1st) at $7.99 - The Blood Books, Volume Two by Tanya Huff - Physical verification
  • #1376, 0-7564-0392-8 (1st) at $7.99 - The Blood Books, Volume Three by Tanya Huff - Corrected spine code from None to Price, Physical verification
  • #1380, 0-7564-0352-9 (1st) at $15.00 - The Book of Ler by M. A. Foster - Physical verification
  • #1381, 0-7564-0381-2 (1st) at $7.99 - Furry Fantastic by Jean Rabe (ed); Brian M. Thomsen (ed) - Physical verification
  • #1384, 0-7564-0356-1 (1st) at $15.00 - The Transformer Trilogy by M. A. Foster - Physical verification
  • #1390, 0-7564-0405-3 at $7.99 - Time Twisters by Jean Rabe (ed); Martin H. Greenberg (ed) - assigned logo #
  • #1391, 0-7564-0414-2 (1st) at $25.95 - Deliverer by C. J. Cherryh - Physical verification
  • #1391, 0-7564-0414-2 at $25.95 - Deliverer by C. J. Cherryh - physical verification
  • #1394, 0-7564-0432-0 (1st) at $25.95 - Feast of Souls by C. S. Friedman - Physical verification
  • #None, UE1501, 0-87997-501-6 (1st) at $2.25 - Ghost Dance by John Norman - filled in 1st printing date, and printing #s based on AbeBooks listings
  • #None, UT1073, No ISBN (1st) at $0.75 - Galaxy of the Lost by Gregory Kern - filled in 1st printing date based on AbeBooks listings
  • #????, 0-7564-0281-6 at $6.99 - Renaissance Faire by Andre Norton (ed); Jean Rabe (ed) - link to ISFDB
  • Moved February-2007 publications from "upcoming" to normal part of the list

Miscellaneous updates Marc Kupper (talk) 12:30, 19 Feb 2007 (CST)

  • #702, UE2378, 0-88677-378-4 (18th) at $6.99 - Arrows of the Queen by Mercedes Lackey - Added reprint at $6.99
  • #1074, UE2782, 0-88677-782-8 at $7.99 - The Dreaming Tree by C. J. Cherryh - correct published date to "n.d." as it's a later printing
  • #1146, UE2877, 0-88677-877-8 (2nd) at $7.99 - The Morgaine Saga by C. J. Cherryh - Added/verified 2nd printing
  • #1255, 0-7564-0135-6 (1st) at $24.95 - The War of the Flowers by Tad Williams - Amazon Look Inside verification
  • #1255, 0-7564-0181-X (5th) at $7.99 - The War of the Flowers by Tad Williams - Physical verification
  • #1255, 0-7564-0181-X at $8.99 - The War of the Flowers by Tad Williams - Added reprint at $8.99 (Amazon)
  • #1263, 0-7564-0147-X (2nd) at $6.99 - Space, Inc. by Julie E. Czerneda - Added and Physical verification of the 2nd printing
  • #1269, 0-7564-0160-7 at $7.99 - At the Edge of Space by C. J. Cherryh - Added omnibus titles
  • #1278, 0-7564-0167-4 at $7.99 - A World Divided by Marion Zimmer Bradley - Added omnibus titles
  • #1305, 0-7564-0224-7 at $7.99 - Darkover: First Contact by Marion Zimmer Bradley - Added omnibus titles
  • #1312, 0-7564-0250-6 at $7.99 - To Save a World by Marion Zimmer Bradley - Added omnibus titles
  • #1316, 0-7564-0293-X at $14.00 - Tales of Taormin by Cheryl J. Franklin - Added omnibus titles
  • #1352, 0-7564-0406-1 at $7.99 - Crown of Stars by Kate Elliott - Corrected Logo # (was "???")
  • #1359, 0-7564-0409-6 at $7.99 - Karavans by Jennifer Roberson - Moved this new pb printing (reprint of hc) from "upcoming" into the main list
  • #1380, 0-7564-0352-9 (1st) at $15.00 - The Book of the Ler by M. A. Foster - Added omnibus titles
  • #1384, 0-7564-0356-1 (1st) at $15.00 - The Transformer Trilogy by M. A. Foster - Added omnibus titles
  • #1388, 0-7564-0398-7 (1st) at $7.99 - Cosmic Cocktails by Denise Little (ed) - physical verification
  • #1394, 0-7564-0432-0 (1st) at $25.95 - Feast of Souls by C. S. Friedman - corrected first-pub date
  • #Upcoming, 0-7564-0444-4 at $7.99 - Chanur's Endgame by C. J. Cherryh - Added omnibus titles
  • The author field for the yellow comment rows used to link to http://www.isfdb.org/cgi-bin/ea.cgi? but now just show a plain hyphen as there is no author name.
  • #1352, 0-7564-0406-1 at $7.99 - Crown of Stars by Kate Elliott - Corrected the logo # for the reprint from ???? to 1352.
  • Broke the DAW list out into sub-pages with 100 titles per page

Miscellaneous updates (pending)

  • Added Published dates for the early books on ISFDB:DAW/Titles - In the main spreadsheet there are rows that are not real publications to deal with this as these early books did not state First Printed dates but later printings did.
  • Mark as verified on ISFDB:DAW/Titles titles where a later edition, but not the first, had been verified. In most cases the 1st printing was verified but there are a few where I only a later printing was verified and these were not marked as verified at the title level. The idea is to make it easy to spot those titles that don't have a single printing that has been verified. Note that many, if not all, titles in the list have been checked via cover images.
  • Corrected the dates for many paperback reprints. They had been listed with the same first printing date as the hardcover edition but were always printed about a year later.
  • #608, UE1983, 0-87997-983-6 (1st) at $2.95 - Countdown to Midnight: Twelve Great Stories About Nuclear War by H. Bruce Franklin (ed) - Added subtitle
  • #689, UE2374, 0-88677-374-1 (20th) at $6.99 - Tailchaser's Song by Tad Williams - deleted duplicate
  • #861, UE2516, 0-88677-516-7 (12th) at $6.99 - Winds of Fate by Mercedes Lackey - Added reprint
  • #891, UE2563, 0-88677-563-9 (10th) at $6.99 - Winds of Change by Mercedes Lackey - Added reprint
  • #921, UE2612, 0-88677-612-0 (11th) at $6.99 - Winds of Fury by Mercedes Lackey - Added reprint
  • #1090, UE2844, 0-88677-844-1 (5th) at $7.99 - River of Blue Fire by Tad Williams - Added reprint
  • #1090, UE2844, 0-88677-844-1 at $8.99 - River of Blue Fire by Tad Williams - Added reprint
  • #1129, UE2906, 0-88677-906-5 at $8.99 - Mountain of Black Glass by Tad Williams - Added reprint
  • #1181, 0-7564-0030-9 at $8.99 - Sea of Silver Light by Tad Williams - Added reprint
  • #1189, 0-7564-0034-1 (1st) at $24.95 - The Fall of Neskaya by Marion Zimmer Bradley; Deborah J. Ross - physical verification
  • #1189, 0-7564-0053-8 (1st) at $6.99 - The Fall of Neskaya by Marion Zimmer Bradley; Deborah J. Ross - Added reprint and physical verification
  • #1257, 0-7564-0149-6 (1st) at $24.95 - Zandru's Forge by Marion Zimmer Bradley; Deborah J. Ross - physical verification
  • #1262, 0-7564-0146-1 at $6.99 - The Riven Shield by Michelle West - Added reprint
  • #1291, 0-7564-0191-7 at $6.99 - Conqueror Fantastic by Pamela Sargent (ed) - Add "(ed)" - contributor role
  • #1320, 0-7564-0246-8 at $25.95 - Sanctuary by Mercedes Lackey - swapped rows so that the hardcover retail edition is before the book club edition.
  • #1321, 0-7564-0281-6 at $6.99 - Renaissance Faire by Andre Norton (ed); Jean Rabe (ed) - moved this title from "Unknown Logo #" to 1321 as a "best guess". There was a hole in the logo #s at 1321 and this title fits into that spot based on its publication date. There may be some shuffling of titles in this area in as publications get verified because things like #1330 were mis-printed with #1326, etc.