Merge a section from a Title

With ONIXEDIT, you can copy a section of an existing title and paste it to one or many other titles. In fact, this action is considered as a "merge" function rather than just a simple "copy/paste" because ONIXEDIT analyze the section from the source title. Then, it will add missing items and update existing ones in destination titles.

Here is an example. Suppose that you want to add a new Main Subject from THEMA to all your titles classified as EDUCATION / General (EDU000000) with the BISAC Subject Scheme. You will follow these steps:

1- Open the ONIX file that you want to update and search all your title with a Main Subject EDU000000 using our Search by ONIX tag tool: (See details on Title Search)

2- Create a new ONIX file and add a new title.

3- Add a new Main Subject and follow the instructions in the screen capture below:

As a result, you should get this:

4- Even if the title is not complete, save it. You should now get a window similar to the following:

5- Now, right-click on the new title you just created and select item "Copy section(s)":

You can also use the Copy section(s) item from the Edit menu or Ctrl+Shift+C.

6- A new window will display presenting the list of possible ONIX sections that you can copy. Scroll down the list, check "MainSubject" and click OK:

You now have a copy of the Main Subject section having the Thema subject "Historical romance" in your clipboard.

7- Select all the titles in the first list (CTRL-A) and right click on any selected title. Choose "Merge section(s)":

A confirmation window will pop up and if you click on "Yes", the section in your clipboard will be merged to every selected titles. Here is the result of one of those titles:

As you can see, ONIXEDIT did not remove the original Subjects of your titles. Indeed, it checks if the records in the Main Subject section from your clipboard exist in each title and adds it where it is missing.

To determine if a record exists or not, ONIXEDIT create a key value by concatenation of one or more fields from the copied section. The fields used to create the key depends on the nature of the section copied. For our example, the key was composed of the Scheme Identifier and the Code. Using that technique, ONIXEDIT can identify which record to add and which one to modify. When a key already exist in the destination title, the corresponding item is updated by replacing former values. When a key does not exist, the missing record is added to the section.

ONIXEDIT's "Copy/Merge" function will merge all the missing items in a section. Consequently, you can use it from a copied section having more than just one item.

That new functionality can also be used to make batch updates of existing titles. See section Making batch updates for more details.

The following tables present the Key fields for every ONIX 2.1 sections:


ProductIdentifier
Key:	ProductIDType
	+
	IDTypeName

ProductFormFeature
Key:	ProductFormFeatureType

ContainedItem
Key:	First ProductIdentifier block

Series
Key:	First Title block
	OR
	First SeriesIdentifier block

	SeriesIdentifier
	Key:	SeriesIDType
		+
		IDTypeName

	Title
	Key:	TitleType
		+
		One group below
		#1	TitleText
		#2	TitlePrefix
			+
			TitleWithoutPrefix


Set
Key:	First Title block
	OR
	First ProductIdentifier block

	ProductIdentifier
	Key:	ProductIDType
		+
		IDTypeName

	Title
	Key:	TitleType
		+
		One group below
		#1	TitleText
		#2	TitlePrefix
			+
			TitleWithoutPrefix


Title
Key:	TitleType

WorkIdentifier
Key:	WorkIDType
	+
	IDTypeName

Website
Key:	WebsiteRole

Contributor
Key:	ContributorRole
	+
	One group below
	#1	PersonNameInverted
	#2	PersonName
	#3	NamesBeforeKey
		+
		KeyNames
	#4	CorporateName

	ContributorPersonDate
	Key:	PersonDateRole

	ProfessionalAffiliation
	Key:	Affiliation
		+
		ProfessionalPosition

	Website
	Key:	WebsiteRole


Conference
Key:	ConferenceName
	+
	ConferenceDate

Language
Key:	LanguageRole

Extent
Key:	ExtentType

Illustrations
Key:	IllustrationType

MainSubject
Key:	MainSubjectSchemeIdentifier
	+
	SubjectCode

Subject
Key:	SubjectSchemeIdentifier
	+
	SubjectCode
	+
	SubjectSchemeName (for SchemeIdentifier 24 only)
	OR
	SubjectSchemeName (for SchemeIdentifier 20 only)

Audience
Key:	AudienceCodeType

AudienceRange
Key:	AudienceRangeQualifier

Complexity
Key:	ComplexitySchemeIdentifier

OtherText
Key:	TextTypeCode
	+
	TextFormat
	+
	TextLinkType
	+
	TextAuthor
	+
	TextSourceCorporate
	+
	TextSourceTitle

MediaFile
Key:	MediaFileTypeCode
	+
	MediaFileFormatCode
	+
	MediaFileLinkTypeCode
	+
	DownloadCaption

ProductWebsite
Key:	WebsiteRole

Prize
Key:	PrizeName
	+
	PrizeYear

Imprint
Key:	ImprintName
	+
	NameCodeType
	+
	NameCodeTypeName

Publisher
Key:	PublishingRole
	+
	One group below
	#1	NameCodeType
		+
		NameCodeValue
	#2	PublisherName

	Website
	Key:	WebsiteRole


SalesRights
Key:	SalesRightsType

NotForSale
Key:	RightsCountry
	OR
	RightsTerritory

	ProductIdentifier
	Key:	ProductIDType


SalesRestriction
Key:	SalesRestrictionType

	SalesOutlet
	Key:	SalesOutletName


CopyrightStatement
Key:	CopyrightYear

Measure
Key:	MeasureTypeCode
	+
	MeasureUnitCode

RelatedProduct
Key:	RelationCode

	ProductIdentifier
	Key:	ProductIDType
		+
		IDTypeName


SupplyDetail
Key:	SupplierRole
	+
	SupplierName

	Price
	Key:	PriceTypeCode
		+
		CurrencyCode
		+
		PriceQualifier

		DiscountCoded
		Key:	DiscountCodeType


	Stock
	Key:	LocationName

	SupplierIdentifier
	Key:	SupplierIDType
		+
		IDTypeName

	NewSupplier
	Key:	SupplierName


MarketRepresentation
Key:	AgentName

	MarketDate
	Key:	MarketDateRole

The following tables present the Key fields for every ONIX 3.0 sections:


	ProductIdentifier
	Key:	ProductIDType
		+
		IDTypeName

	Barcode
	Key:	BarcodeType

DescriptiveDetail


	ProductFormFeature
	Key:	ProductFormFeatureType
		+
		ProductFormFeatureDescription language attribute

	Measure
	Key:	MeasureType
		+
		MeasureUnitCode

	EpubUsageConstraint
	Key:	EpubUsageType

		EpubUsageLimit
		Key:	EpubUsageUnit


	ProductClassification
	Key:	ProductClassificationType

	ProductPart
	Key:	First ProductIdentifier block

	Collection
	Key:	CollectionType
		+
		First CollectionIdentifier block

		CollectionIdentifier
		Key:	CollectionIDType
			+
			IDTypeName

		CollectionSequence
		Key:	CollectionSequenceType
			+
			CollectionSequenceTypeName

		TitleDetail
		Key:	TitleType


	TitleDetail
	Key:	TitleType

		TitleElement
		Key:	TitleElementLevel


	Contributor
	Key:	ContributorRole
		+
		One group below
		#1	PersonNameInverted
		#2	PersonName
		#3	NamesBeforeKey
			+
			KeyNames
		#4	CorporateName
		#5	UnnamedPersons
		#6	ISNI (NameIdentifier with type 16)

		NameIdentifier
		Key:	NameIDType
			+
			IDTypeName

		AlternativeName
		Key:	NameType

		ContributorDate
		Key:	ContributorDateRole

		ProfessionalAffiliation
		Key:	Affiliation
			+
			ProfessionalPosition

		BiographicalNote
		Key:	language attribute

		Website
		Key:	WebsiteRole

		ContributorDescription
		Key:	language attribute

		ContributorPlace
		Key:	ContributorPlaceRelator


	ReligiousText
	Key:	No merge - Replace

		Bible


		ReligiousTextFeature
		Key:	ReligiousTextFeatureType
			+
			ReligiousTextFeatureCode


	Event
	Key:	EventName
		+
		EventDate

	Language
	Key:	LanguageRole

	Extent
	Key:	ExtentType
		+
		ExtentUnit

	AncillaryContent
	Key:	AncillaryContentType
		+
		AncillaryContentDescription language attribute

	Subject
	Key:	SubjectSchemeIdentifier
		+
		SubjectSchemeName
		+
		SubjectCode or SubjectHeadingText (if SubjectCode is empty)

		OR

		SubjectSchemeIdentifier=20
		+
		SubjectSchemeName (for SchemeIdentifier 20 only)

	Audience
	Key:	AudienceCodeType

	AudienceRange
	Key:	AudienceRangeQualifier

	Complexity
	Key:	ComplexitySchemeIdentifier

CollateralDetail


	TextContent
	Key:	TextType
		+
		SourceTitle
		+
		TextSourceCorporate
		+
		ALL TextAuthors
		+
		ALL ContentAudience
		+
		Text language attribute

		ContentDate
		Key:	ContentDateRole


	CitedContent
	Key:	CitedContentType

		ContentDate
		Key:	ContentDateRole


	SupportingResource
	Key:	ResourceContentType
		+
		Caption (ResourceFeature/FeatureNote where ResourceFeatureType=02)

		ResourceFeature
		Key:	ResourceFeatureType

		ResourceVersion
		Key:	ResourceForm

			ContentDate
			Key:	ContentDateRole

			ResourceVersionFeature
			Key:	ResourceVersionFeatureType



	Prize
	Key:	PrizeName
		+
		PrizeYear

PublishingDetail


	Imprint
	Key:	First ImprintIdentifier block

		OR

		ImprintName

		ImprintIdentifier
		Key:	ImprintIDType
			+
			IDTypeName


	Publisher
	Key:	PublishingRole

		PublisherIdentifier
		Key:	PublisherIDType
			+
			IDTypeName

		Website
		Key:	WebsiteRole


	PublishingDate
	Key:	PublishingDateRole

	SalesRights
	Key:	SalesRightsType

		SalesRestriction
		Key:	SalesRestrictionType

			SalesOutletIdentifier
			Key:	SalesOutletIDType
				+
				IDTypeName


		ProductIdentifier
		Key:	ProductIDType
			+
			IDTypeName


	SalesRestriction
	Key:	SalesRestrictionType

		SalesOutletIdentifier
		Key:	SalesOutletIDType
			+
			IDTypeName


	CopyrightStatement
	Key:	CopyrightType
		+
		CopyrightYear

RelatedMaterial


	RelatedWork
	Key:	WorkRelationCode

		WorkIdentifier
		Key:	WorkIDType
			+
			IDTypeName


	RelatedProduct
	Key:	ProductRelationCode

		ProductIdentifier
		Key:	ProductIDType
			+
			IDTypeName


ProductionDetail


	ProductionManifest
	Key:	First ProductIdentifier

		BodyManifest-SpecificationFeature
		Key:	SpecificationFeatureType

		BodyManifest-BodyResource
		Key:	ResourceFileLink


ProductSupply

Key:	Market.Territory.CountriesExcluded
	+
	Market.Territory.CountriesIncluded
	+
	Market.Territory.RegionsExcluded
	+
	Market.Territory.RegionsIncluded

	SalesRestriction
	Key:	SalesRestrictionType

		SalesOutletIdentifier
		Key:	SalesOutletIDType
			+
			IDTypeName


	MarketPublishingDetail
	Key:	MarketPublishingStatus

		PublisherRepresentative
		Key:	AgentName

		ProductContact
		Key:	ProductContactRole
			+
			One group below
			#1	ProductContactName
			#2	ContactName

		MarketDate
		Key:	MarketDateRole


	SupplyDetail
	Key:	First Supplier.SupplierRole
		+
		First Supplier.SupplierName

		SupplierIdentifier
		Key:	SupplierIDType
			+
			IDTypeName

		ReturnsConditions
		Key:	ReturnsCodeType

		SupplyDate
		Key:	SupplyDateRole

		Stock
		Key:	LocationName

		NewSupplier
		Key:	One group below
			#1	SupplierName
			#2	SupplierIDType
				+
				IDTypeName

		Price
		Key:	PriceType
			+
			CurrencyCode
			+
			PriceQualifier
			+
			PriceDate Role and Date (if option is activated in the import rules)

			PriceIdentifier
			Key:	PriceIDType
				+
				IDTypeName

			PriceConstraint
			Key:	PriceConstraintType

				PriceConstraintLimit
				Key:	PriceConstraintUnit

			DiscountCoded
			Key:	DiscountCodeType

			Discount
			Key:	DiscountType

			Tax
			Key:	TaxType

			PriceDate
			Key:	PriceDateRole