New Titles and Editions
You can import titles and editions in a single file or separately. If creating titles and editions separately, the title record must be imported before the edition record.
Every title requires a title (name of the title) and a title code. If the import file does not specify a title code the software will look for a title that is an exact match to the title. If a match is found it will use that code. If a match is not found it will create a new title code. If the title is not specified (and no match is found with an existing title code) that record will not be imported and an error will be logged.
Every edition requires an ISBN and a title code (or title). If an ISBN is not specified when creating an edition (or importing edition related fields) that record will not be imported and an invalid error will be logged. If an edition title is not specified the software will use the name of the title for that edition. If the title code or title is not specified that record will not be imported and an invalid error will be logged.
|1||T200||Blue River||978-10000-202-01||Blue River||Paperback||Valid|
The table above shows a sample import file. The status column shows whether the record is valid or invalid. If invalid it will not be imported.
- Row 2 is missing an edition title. The software will use the title; Blue River, as the edition title.
- Row 3 is invalid because no ISBN was specified. Every edition (product) must have a unique ISBN.
- Row 4 is invalid because no title code or title was specified. Every edition must be linked to a title code or a title.
- Row 5 is valid if the title record was previously created. The title field will use the title linked to title code T200. The edition title field will also use the title linked to title code T200.
Update Edition Information
If you want to update existing editions with new information the import file must contain the ISBN for that edition. If the ISBN is missing the record will not be imported and an invalid error will be logged. A title code/title reference is not required to update an existing edition.