Help:How to merge titles

From ISFDB
Jump to navigation Jump to search
This page is a help or manual page for the ISFDB database. It describes standards or methods for entering or maintaining data in the ISFDB database, or otherwise working with the database. Other help pages may be found via the category below. To discuss what should go on this page, use the talk page.

If, after exploring the Help system, you still have a question, please visit the Help desk and let us know. We probably know the answer, but we need your help to know what we left out of the help pages.

If you are new to editing the ISFDB, please see Help:Getting Started.

For more on this and other header templates, see Header templates.


If you see an author (or artist, or editor) has a work listed twice in the ISFDB, then the two works can probably be merged. Here's a checklist to run through before you merge them, followed by instructions on how to merge.

Criteria for merging

If something is a candidate for merging, then the titles should match exactly, and so should the author/editor name, and generally the publication type. For example, if you see two versions of a Robert Sheckley story, "Shape", and "Keep Your Shape", and you happen to know that these are the same story, that's not a candidate for merging. This story was in fact published under both those titles, so that's a variant title. Merging destroys one title record in favour of another, so we only do it when the titles are identical. Similarly, Heinlein's "Successful Operation" was originally published as by "Lyle Monroe", and later republished under Heinlein's own name. These are also variants, despite the title being identical; merges require that the author and title field both match identically. See How to record a pseudonym and How to record a variant title for help on how to deal with those situations.

Records with different types should generally not be merged. For example:

There are also cases where a novel has the same title as a collection, or where two collections with quite different contents have the same title. These also should not be merged.

Merging Artwork

  • Cover art used on different publications should not be merged. If a painting is used for 'Giant Robots', and is also used on the cover of 'Alien Metal Men', then the records should not be merged. The ISFDB is not set up to document this exact relationship at this time. Please record this information in the title and artwork notes or as a variant relationship.
  • Cover art used on the same title, in different publications should be merged. If the same artwork is used on the 1st printing of the HC and the 1st and 2nd printings of the paperback of a title, then the cover art records should be merged. Note that foreign publications of magazines and similar items often subtly changed or re-worked cover art for various reasons. Extra care should be taken when merging cover art of publications where the country is not the same, and a direct 'in hand' comparison is recommended.
  • Cover art, reproduced within another publication as interior art should not be merged. The interior art record should be made a variant child of the original cover art record.
  • Interior artwork in like publications may be merged. If the interior artwork is known or expected to be the same, such as interior artwork maps in a 1st, 2nd, and 3rd printings of a paperback of the same title, then the artwork may be merged. Some care should be exercised to ensure that interior artwork hasn't changed between hardcover and paperback publications of the same title, but most modern HC releases followed by paperback releases are expected to duplicate the interior artwork and may be merged, barring some information indicating that the artwork changed. (Often if there is change from the HC interior artwork, the copyright for the new artwork will match the paperback publication, and not the HC publication year.
  • Interior artwork in different publications should only be merged upon a direct comparison. Sometimes a book may reprint interior artwork from a pulp magazine several decades past. The new book may correctly credit the original artist and the source, but the modern book may omit panels or even entire pages. You should only merge interior artwork that has been subject to re-editing after directly comparing both the subject and scope of the two pieces of art, and you can confirm that they are indeed the same complete work of art.

How to merge titles (advanced search method)

  1. Don't confuse separate publications with separate titles. To be quite sure that a merge is necessary, the most straightforward thing to do is use the "Title Search" section of the Advanced Search screen. Enter the title and author's name and submit the search; the results will list titles, not publications. If you don't see two identical listings here, then there's no merge to do.
  2. If you do see two (or more) identical listings, you can click on the title link in each case to look at the publications for each title. Once you have decided that the titles really do need to be merged, return to the search results page, and check the box on the left of every title that you want to merge. Then click the "Merge Selected Records" button.
  3. A title merge results screen will display, showing you the different records you're merging, and highlighting any differences between them. The screen will display a green background for any fields that were identical across all the records that are being merged. This should always include the title and author. However, perhaps one record showed the story as just "short fiction", which gives a value of "sf" in the title_storylen field, whereas another record showed the story as "ss", for "short story", which is more specific, meaning that it's under 7500 words. In that case, both values will be shown on a red background, and you can choose which value to preserve on the merged record. For the example given, you would want to preserve the "ss", since that's more specific, unless you had some reason to believe it was incorrect or unreliable. Click on the radio button next to the value you want to keep, and then click on the "Complete Merge" button.
  4. This will submit the record. Once a moderator approves it, the merge is complete.

How to merge titles (Find duplicates method)

Instead of using Advanced Search, you can use the "Duplicate Candidates" feature to detect duplicate titles, and merge them. This is particularly useful if you suspect there may be duplicates, but are not sure of the titles, or if there may be multiple duplicates for a single author, as is likely after adding a new collection (or adding contents manually to a collection) when some or all of the contents may well have been published elsewhere.

  1. Go to the main display for the author of the works involved (Summary Bibliography page).
  2. Select the "Dup Candidates" link in the "Editing Tools" section of the left-hand navigation sidebar.
  3. If any exact duplicates (two or more title records with the exact same title) are found, they will be displayed, grouped by title. (if none are found, the message "No dup candidates found." will display.)
  4. In each group, look at the "Year", "Type", and "Authors" columns. If the Types are different, you should probably not merge. If the authors are different, you should not merge, but may want to set up a variant title relationship. (See How to record a variant title.) Different year values may be merged, but further checking is a good idea, see the next step. Watch particularly for type mismatches. For example, if one title is type COLLECTION, but another is SHORTFICTION, this probably means that the collection has a title story, and no merge should be done. A mismatch of COLLECTION vs ANTHOLOGY or NOVEL vs COLLECTION just might mean that the same work has been recorded in two different ways. In such cases a merge might be a good idea, but further checking is needed to determine this (see the next step). If unsure, do not merge.
  5. Each of the titles links to its title record display page. Right-click on the title, and select "open in new window" or "Open in new tab" or whatever similar feature your browser provides. You can then see the full information on that title record and its publications. Compare the two (or more) title records to help determine if the titles should be merged, made variants, or left alone. There may be relevant notes.
  6. Once you have decided that the titles really do need to be merged, return to the Duplication Finder page, and check the box to the left of every title (within the group) that you want to merge. Then click the "Merge Selected Records" button below that group. Each group operates separately.
  7. A title merge results screen will display, showing you the different records you're merging, and highlighting any differences between them. The screen will display a green background for any fields that were identical across all the records that are being merged. This should always include the title and author. (The one exception: if the same set of authors are listed in different order, it is OK to merge. For example, if one title says "Isaac Asimov+Robert Bloch" and the other says "Robert Bloch+Isaac Asimov" a merge is OK. But be very sure that the individual authors are using the identical spellings in such a case.) However, perhaps one record showed the story as just "short fiction", which gives a value of "sf" in the title_storylen field, whereas another record showed the story as "ss", for "short story", which is more specific, meaning that it's under 7500 words. In that case, both values will be shown on a red background, and you can choose which value to preserve on the merged record. For the example given, you would want to preserve the "ss", since that's more specific, unless you had some reason to believe it was incorrect or unreliable. Similarly, one record might give the date as "1989-00-00" and the other as "1989-06-00". (Generally select the more specific one or the earlier one, but checking may be needed. Click on the radio button next to the value you want to keep, and then click on the "Complete Merge" button. This will submit a title merge edit, which will take effect when it is approved by a moderator.
  8. If there were other groups on the Duplication Finder page, click the browser's "Back" button twice to return to that page. Look at the next group, and decide what to do with it. Repeat for every group on the page, merging where appropriate.

You can also use the "Similar Title Mode" on the Duplication Finder. This will find titles that are not identical, but are similar. Generally such titles should not be merged, unless one represents an entry error (be very sure before assuming an entry error. Normally you should check with the actual book or publication, or with another editor who has a copy, before proceeding.) However, if the similar titles represent the same work, a variant title relationship should usually be set up. See How to record a variant title for more information. Note that the titles which the ISFDB software flags as similar are often for clearly different works, be careful and use judgment before acting on any match in "similar title mode".

How to merge titles (Show all Titles method)

Instead of using Advanced Search or Find Duplicates, you can use the "Show All Titles" feature to detect duplicate titles, and merge them. This is particularly useful if one or both of the titles is already listed as a variant title (VT). It also works well if you know the specific title you are looking for, or if the author's bibliography is fairly short.

  1. Go to the main display for the author of the works involved (Summary Bibliography page).
  2. Select the "Show All Titles" link in the "Editing Tools" section of the left-hand navigation sidebar.
  3. The page will display an alphabetical list of all title records for that author. (If there are more than 100, only the first hundred will be displayed. Follow the link [100-199] at the lower left of the page for the next hundred.)
  4. Each of the titles links to its title record display page. Right-click on the title, and select "open in new window" or "Open in new tab" or whatever similar feature your browser provides. You can then see the full information on that title record and its publications. Compare the two (or more) title records to help determine if the titles should be merged, made variants, or left alone. There may be relevant notes.
  5. As discussed above, be careful to be sure that you only merge titles that represent the same text. Title and Author should be identical, and usually type should be identical
  6. If you want to merge 2 or more titles, click the checkboxes to the left of the title you want to merge, and then click "Merge Selected Records".
  7. A title merge results screen will display, showing you the different records you're merging, and highlighting any differences between them. The screen will display a green background for any fields that were identical across all the records that are being merged. This should always include the title and author. However, perhaps one record showed the story as just "short fiction", which gives a value of "sf" in the title_storylen field, whereas another record showed the story as "ss", for "short story", which is more specific, meaning that it's under 7500 words. In that case, both values will be shown on a red background, and you can choose which value to preserve on the merged record. For the example given, you would want to preserve the "ss", since that's more specific, unless you had some reason to believe it was incorrect or unreliable. Click on the radio button next to the value you want to keep, and then click on the "Complete Merge" button.
  8. This will submit the record. Once a moderator approves it, the merge is complete.
Ah, that's better. I'd found the guide for merges a couple of days ago, but hadn't been able to remember how I did it or how to find it again in the wiki. Thanks! Malcolmf 19:21, 27 January 2012 (UTC)

See also

Retrieved from "https://isfdb.org/wiki/index.php?title=Help:How_to_merge_titles&oldid=258001"