You will see an error 25 when attempting to import a JPEG image (.jpg) into Anko Publishing Manager if the image has been saved with a CMYK format. To successfully import the image re-save the JPEG image file with an RGB format and re-import the image file.
The link above is to a spreadsheet which you should complete ahead of installing your APM. This should give you a good core of title information to get you started and in particular if you are intending to be Onix compliant.
Some notes on the spreadsheet:
Column A - Title ID: This is your own unique identifier for the title/product in question. This may be, for example, the id for the title/product supplied by your distributor or your own internal id.
Column G - Please select from the list in the Publishing Status column in the APM Code Lists Sheet. For the purposes of the APM (and indeed the Onix standard) means …
Column H - Please select from the list in the Product Availability column in the APM Code List Sheets. For the purposes of the APM (and indeed the Onix standard) means …
Column I - Price One Currency: This is the three character currency code for the principal price at which the product will be offered. This is a mandatory field for Onix.
Column J - Price One Country Code: This is the two character country code signifying the country the price refers to.
Column K - Price One Amount: This is the principal price at which the product will be offered. The price in here needs to be without any currency notation and in the form of - eg, 2.00 or 11.00.
Column R - Edition Number: Just the number and please note that the Onix standard requires only that you include an edition number if the edition is greater than one.
Column S - Please select from the list in the Product Form column in the APM Code Lists Sheet. For the purposes of the APM (and indeed the Onix standard) means …
Column T - If the title is part of a series enter a unique identifier for the series. This will allow APM to link all the related titles in the series.
Column W - Enter a unique identifier for the title imprint. This will allow APM to link all the titles associated with an imprint.
Column Y - Publication Date: This should be in the form dd/mm/yyyy or mm/dd/yyyy if you are in the US.
Columns AI to AK: Web URL links that are associated with the title.
Column AL - Description Text 1 Type Code: Please select from the list in the Marketing Description Code column in the APM Code Lists Sheet. Description Text Type code is simply the means of identifying the type of text in the Description Text field (see Description Text below) - eg, Long Description; Short Description etc.
Column AM - Description Text 1: Marketing description text or blurbs. The previous column defines what text should be entered i.e. Long Description, Short Description.
Columns AR and AW - BIC and BISAC subject categories: Depending on whether you are in the UK (BIC) or the US (BISAC) then you will need to have one or other of these. To learn more please go to bisg.org or bic.org.uk.
Column AX - Audience Code: Please select from the list in the Audience Code column in the APM Code Lists Sheet. For the purposes of the APM (and indeed the Onix standard) means …
This spreadsheet links authors to titles. The basic idea is that details for an author/contributor are entered once (see the Contributors Details spreadsheet) and a unique Author ID is assigned. APM then links the Title ID and Author IDs.
Column A - Title ID: To link your author/contributor to the correct title it is important that the title is able to be identified to create the relationship between the two of them.
Column B - Author ID: This is for whatever unique identifier that you wish to use for your primary author/contributor.
Columns D to F - Contributor Role: In relation to a title these are the roles of the particular author/contributor - eg, did they write it etc. Please select from the list in the Contributor Role column in the APM Code Lists Sheet.
This spreadsheet is fairly self explanatory allowing you to enter author/contributor personal details. The Author ID entry must be unique and will be used when linking authors to titles.
It may well be that prior to installing your APM that all your title and other publishing information may well be quite frankly all over the place. Some words documents; the odd Excel spreadsheet? Sound familiar?
Anyway, in the first instance it is important that you are able to get some core title information into your APM as painlessly as possible. Once you have some basic title information then for one thing it makes the addition of any other information so much easier as obviously the title is the hub around which everything else revolves.
The APM or indeed just about any other database works on the basis of relationships to create links between information. For example, an author/contributor is related to the titles to which they have contributed. To create these relationships the APM needs to have one piece of information which is unique to the title or the author/contributor or anything else for that matter (eg Customers; Media Organisations etc.).
So, for any type of related information it is very helpful (and will save a lot of heartache!) if you have a unique identifier for any information that you want to link.
Also, bear in mind that it is very likely that within your organisation you will have a number of different spreadsheets; Access databases; Word documents etc. all with titles and authors spelt and slightly different.And, indeed it is very common for us to see all kinds of information in what should be the title name to indicate for instance if it is a paperback or a 2nd edition.
So, I hope you can see the value of having one field that uniquely identifying which title is being talked about wherever it is!And while you’ve got your head in your hands another thing to think about when preparing your data is that it needs to be broken down into it’s constituent elements. This is the way the Onix standard works and the way that the APM works. Having the entirety of a person’s name and all the elements of the title (i.e prefix; title itself; and sub title) all in the one fields restricts your searching and sorting options. Consequently, you may need to be prepared to break all this information down.