Onboarding Import: Titles: Difference between revisions

From PubGizmo Help
Jump to navigation Jump to search
← Older editNewer edit →

PubGizmoSysop (talk | contribs)

3 user groups
185 edits
VisualWikitext
No edit summary
Claude edit
Line 1: Line 1:
The Titles sheet is straightforward: it's a list of all the Titles you want represented in PubGizmo, so you can store assets, connect them to contracts, authors, licensing organizations, etc.
''Part of the [[Onboarding Import: Introduction|Onboarding Import]] series.''


== Columns ==
The Titles sheet is the foundation of your import. Every edition, contract, and sales record in PubGizmo is tied to a title, so it's important to get this sheet right before working on the others.
# 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 these are consistent through, e.g., if you call it “Science Fiction” for one title, do not call it “SciFi” for another, or you’ll end up with both genres in your list and selectors. ''Tip:'' “Nonfiction” (or “Non-fiction,” or “Non fiction”) remains the most evasive genre in terms of consistency – use whatever you like, but please make sure it’s identical throughout.
== Column Notes ==
# Keywords: enter multiple keywords is each cell, separated by a semicolon (not comma); you can learn more about how keywords help you group and find Titles by theme and content on the [[Keywords|Keywords Wiki page]].
 
# BISAC Codes: enter if you have these (max: 3).
=== Title ===
Enter titles exactly as it appears on the book, including the leading article (''A'', ''An'', ''The''), for example "''A Tidy Armageddon",'' not "''Tidy Armageddon, A''". PubGizmo will parse this as needed for indexing and metadata.
 
All title entries must be unique and appear only once on this sheet – no duplicates.
 
'''MATCH WARNING:''' The title as entered here is the value that 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.
 
=== Subtitle ===
Enter the subtitle here if the title has one. Do not include the subtitle in the '''Title''' column.
 
=== Author Name ===
Enter the primary author's name. '''MATCH WARNING:''' The author name as entered here must be matched exactly on the [[Onboarding Import: Contracts|Contracts]] sheet.
 
=== Genre ===
You can enter multiple genres in a single cell; separate them 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.
 
=== Keywords ===
Enter multiple keywords in a single cell, separated by a '''semicolon''' (not a comma). You can learn more about how keywords help you group and find titles on the [[Keywords]] wiki page.
 
=== BISAC Code Primary, BISAC2, BISAC3 ===
Enter BISAC subject codes if you have them, one code per column, in priority order. Most titles will have one or two; a maximum of three is supported. Leave unused columns blank. BISAC codes are available from the [https://www.bisg.org/bisac-subject-codes Book Industry Study Group (BISG)].
 
=== BISAC Regional Themes ===
Enter the BISAC Regional Theme code if applicable. Regional Themes are a separate BISAC vocabulary used to indicate geographic focus (e.g., a book specifically about or set in a particular region). Separate multiple entries with a '''semicolon'''.
 
=== BISAC Merchandizing Themes ===
Enter the BISAC Merchandizing Theme code(s) 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'''.
 
=== 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. Separate multiple entries with a '''semicolon''' (e.g., ''FLQ;1KBZTP;3MRBF'').

Revision as of 19:20, 4 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's important to get this sheet right before working on the others.

Column Notes

Title

Enter titles exactly as it appears on the book, including the leading article (A, An, The), for example "A Tidy Armageddon", not "Tidy Armageddon, A". PubGizmo will parse this as needed for indexing and metadata.

All title entries must be unique and appear only once on this sheet – no duplicates.

MATCH WARNING: The title as entered here is the value that 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.

Subtitle

Enter the subtitle here if the title has one. Do not include the subtitle in the Title column.

Author Name

Enter the primary author's name. MATCH WARNING: The author name as entered here must be matched exactly on the Contracts sheet.

Genre

You can enter multiple genres in a single cell; separate them 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.

Keywords

Enter multiple keywords in a single cell, separated by a semicolon (not a comma). You can learn more about how keywords help you group and find titles on the Keywords wiki page.

BISAC Code Primary, BISAC2, BISAC3

Enter BISAC subject codes if you have them, one code per column, in priority order. Most titles will have one or two; a maximum of three is supported. Leave unused columns blank. BISAC codes are available from the Book Industry Study Group (BISG).

BISAC Regional Themes

Enter the BISAC Regional Theme code if applicable. Regional Themes are a separate BISAC vocabulary used to indicate geographic focus (e.g., a book specifically about or set in a particular region). Separate multiple entries with a semicolon.

BISAC Merchandizing Themes

Enter the BISAC Merchandizing Theme code(s) 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.

Thema

Thema is an international subject classification scheme used in ONIX metadata. Enter one or more Thema codes if your press uses them. Separate multiple entries with a semicolon (e.g., FLQ;1KBZTP;3MRBF).

Retrieved from "https://pubgizmo.com/wiki/index.php?title=Onboarding_Import:_Titles&oldid=155"