Onboarding Import: Titles - Revision history

PubGizmoSysop: /* Column F — Description */

2026-06-05T17:56:11Z

Column F — Description

← Older revision		Revision as of 13:56, 5 June 2026
Line 25:		Line 25:

	=== Column F — Description ===		=== Column F — Description ===
	Enter the title's description, blurb, or back-cover copy. ~~Plain~~ text ~~is preferred;~~ basic HTML tags (e.g., ''<nowiki><i></nowiki>'', ''<nowiki><b></nowiki>'') ~~are accepted~~ if needed for italics or emphasis within the text.		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 ===		=== Column G — BISAC Code Primary ===

PubGizmoSysop: Claude re-edit

2026-06-05T17:47:02Z

Claude re-edit

← Older revision		Revision as of 13:47, 5 June 2026
Line 1:		Line 1:
	''Part of the [[Onboarding Import: Introduction\|Onboarding Import]] series.''		''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's important to get this sheet right before working on the others.		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.

	== ~~Column Notes~~ ==		== Columns ==

	=== Title ===		=== Column A — 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~~.		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.

	~~All~~ title ~~entries~~ must be ~~unique~~ and ~~appear~~ only ~~once on this sheet – no duplicates~~.		<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.

	'''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.		=== Column B — Subtitle ===

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

	=== ~~Author Name~~ ===		=== Column C — Imprint ===
	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~~.		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.

	=== Genre ===		=== Column D — Genre ===
	~~You can enter~~ multiple genres ~~in a single cell; separate them~~ with a '''semicolon''' (not a comma).		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.		''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 ===		=== Column E — 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.		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. Plain text is preferred; basic HTML tags (e.g., ''<nowiki><i></nowiki>'', ''<nowiki><b></nowiki>'') are accepted 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.

	=== ~~BISAC Code Primary, BISAC2,~~ BISAC3 ===		=== Column I — 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)]~~.		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.

	=== BISAC Regional Themes ===		=== Column J — 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'''.		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''.

	=== BISAC Merchandizing Themes ===		=== Column K — 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'''.		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''.

	=== Thema ===		=== 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~~. Separate multiple entries with~~ a '''semicolon''' (e.~~g.,~~ ''FLQ;1KBZTP;3MRBF'').		[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''.

PubGizmoSysop: Claude edit

2026-06-04T23:20:28Z

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 ===

PubGizmoSysop at 19:36, 28 August 2025

2025-08-28T19:36:41Z

← Older revision		Revision as of 15:36, 28 August 2025
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.

			== Columns ==
	# 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.		# 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.		# 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.
	# 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]].		# 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).		# BISAC Codes: enter if you have these (max: 3).

PubGizmoSysop: 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..."

2025-08-28T19:33:41Z

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..."

New page

# 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.
# 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).