Onboarding Import: Titles: Difference between revisions
Created page with "# Title: you get to decide on the convention for the first article (A, An, The) when entering a title, by placing it at the beginning (e.g., ''A Tidy Armageddon'') or at the end (e.g., ''Tidy Armageddon, A'') – just be consistent. All title entries must be unique. # Genre: you can enter multiple genres in each cell; please separate them with a semicolon (not comma). ''Important:'' since PubGizmo will add any genres(s) you input to your master value list, ensure that th..." |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
''Part of the [[Onboarding Import: Introduction|Onboarding Import]] series.'' | |||
# | |||
The Titles sheet is the foundation of your import. Every edition, contract, and sales record in PubGizmo is tied to a title, so it is important to get this sheet right before working on the others. | |||
== Columns == | |||
=== Column A — Title === | |||
Enter the title of the work in its natural reading order (e.g., ''A Tidy Armageddon''). PubGizmo parses leading articles (''A'', ''An'', ''The'') automatically for sorting purposes, so you do not need to move the article to the end. All title entries must be unique. | |||
<span style="color: #E6A817;">'''Match Warning'''</span> — The title as entered here must be matched exactly on the [[Onboarding Import: Editions|Editions]] and [[Onboarding Import: Contracts|Contracts]] sheets. When entering a title on those sheets, use only the title — do not include the subtitle. | |||
=== Column B — Subtitle === | |||
Enter the subtitle here if the title has one. Do not include the subtitle in the '''Title''' column. | |||
=== Column C — Imprint === | |||
Enter the imprint under which this title was published, if your press uses imprints. If your press publishes all titles under the same imprint or press name, you may leave this blank or enter your press name consistently throughout. | |||
=== Column D — Genre === | |||
Enter the genre or genres for this title. Separate multiple genres with a '''semicolon''' (not a comma). | |||
''Important:'' PubGizmo will add any genre(s) you enter to your master genre value list. Be consistent — if you call it "Science Fiction" for one title, do not call it "SciFi" for another, or you will end up with both in your selector list. "Nonfiction" (or "Non-fiction" or "Non fiction") is the most common consistency trap — pick one form and use it throughout. | |||
=== Column E — Keywords === | |||
Enter keywords for this title, separated by a '''semicolon''' (not a comma). You can learn more about how keywords help you group and find titles by theme and content on the [[Keywords]] wiki page. | |||
=== Column F — Description === | |||
Enter the title's description, blurb, or back-cover copy. Embedded formatting from pasted text will be lost, but you can employ basic HTML tags (e.g., ''<nowiki><i></nowiki>'', ''<nowiki><b></nowiki>'') if needed for italics or emphasis within the text. | |||
=== Column G — BISAC Code Primary === | |||
Enter the primary BISAC subject code for this title, if you have one. BISAC codes are available from the [https://www.bisg.org/bisac-subject-codes Book Industry Study Group (BISG)]. Example: ''FIC028070''. | |||
=== Column H — BISAC2 === | |||
Enter a second BISAC subject code if the title warrants additional classification. Leave blank if one code is sufficient. | |||
=== Column I — BISAC3 === | |||
Enter a third BISAC subject code if applicable. A maximum of three BISAC codes are supported across Columns G, H, and I. Leave blank if not needed. | |||
=== Column J — BISAC Regional Themes === | |||
Enter a BISAC Regional Theme code if applicable. Regional Themes are a separate BISAC vocabulary indicating geographic focus — for example, a book specifically about or set in a particular region. Separate multiple entries with a '''semicolon'''. Example: ''4.0.2.1.0.0.0''. | |||
=== Column K — BISAC Merchandizing Themes === | |||
Enter one or more BISAC Merchandizing Theme codes if applicable. These are used by retailers to place titles into promotional or display categories beyond the primary subject classification. Separate multiple entries with a '''semicolon'''. Example: ''ET034''. | |||
=== Column L — Thema === | |||
[https://www.editeur.org/151/Thema/ Thema] is an international subject classification scheme used in ONIX metadata. Enter one or more Thema codes if your press uses them, separated by a '''semicolon'''. Example: ''FLQ;1KBZTP;3MRBF''. | |||
Latest revision as of 13:56, 5 June 2026
Part of the Onboarding Import series.
The Titles sheet is the foundation of your import. Every edition, contract, and sales record in PubGizmo is tied to a title, so it is important to get this sheet right before working on the others.
Columns
Column A — Title
Enter the title of the work in its natural reading order (e.g., A Tidy Armageddon). PubGizmo parses leading articles (A, An, The) automatically for sorting purposes, so you do not need to move the article to the end. All title entries must be unique.
Match Warning — The title as entered here must be matched exactly on the Editions and Contracts sheets. When entering a title on those sheets, use only the title — do not include the subtitle.
Column B — Subtitle
Enter the subtitle here if the title has one. Do not include the subtitle in the Title column.
Column C — Imprint
Enter the imprint under which this title was published, if your press uses imprints. If your press publishes all titles under the same imprint or press name, you may leave this blank or enter your press name consistently throughout.
Column D — Genre
Enter the genre or genres for this title. Separate multiple genres with a semicolon (not a comma).
Important: PubGizmo will add any genre(s) you enter to your master genre value list. Be consistent — if you call it "Science Fiction" for one title, do not call it "SciFi" for another, or you will end up with both in your selector list. "Nonfiction" (or "Non-fiction" or "Non fiction") is the most common consistency trap — pick one form and use it throughout.
Column E — Keywords
Enter keywords for this title, separated by a semicolon (not a comma). You can learn more about how keywords help you group and find titles by theme and content on the Keywords wiki page.
Column F — Description
Enter the title's description, blurb, or back-cover copy. Embedded formatting from pasted text will be lost, but you can employ basic HTML tags (e.g., <i>, <b>) if needed for italics or emphasis within the text.
Column G — BISAC Code Primary
Enter the primary BISAC subject code for this title, if you have one. BISAC codes are available from the Book Industry Study Group (BISG). Example: FIC028070.
Column H — BISAC2
Enter a second BISAC subject code if the title warrants additional classification. Leave blank if one code is sufficient.
Column I — BISAC3
Enter a third BISAC subject code if applicable. A maximum of three BISAC codes are supported across Columns G, H, and I. Leave blank if not needed.
Column J — BISAC Regional Themes
Enter a BISAC Regional Theme code if applicable. Regional Themes are a separate BISAC vocabulary indicating geographic focus — for example, a book specifically about or set in a particular region. Separate multiple entries with a semicolon. Example: 4.0.2.1.0.0.0.
Column K — BISAC Merchandizing Themes
Enter one or more BISAC Merchandizing Theme codes if applicable. These are used by retailers to place titles into promotional or display categories beyond the primary subject classification. Separate multiple entries with a semicolon. Example: ET034.
Column L — Thema
Thema is an international subject classification scheme used in ONIX metadata. Enter one or more Thema codes if your press uses them, separated by a semicolon. Example: FLQ;1KBZTP;3MRBF.