The Edition Import Guide

There are a number of different filters which you can apply when importing and exporting, it is useful to read up on these to be sure you have selected the right ones.

The imports can be run in three modes:

Add

This will insert the record to Affino and generate the unique Edition code.

Update

The Update action allows you to replace the information stored against the Edition.

For example: if you wish to add additional topics and texts, you would need to export the Editions first and add them alongside the existing values in the file.

Delete

When you wish to delete records from Affino, you will need to know the batch number which you used to import them. It's useful to save your imports using the batch number as part of the file name for any future deletions or updates as this is a required field on the import screens.

You will need to download a copy of the current import template.

To do this go to the Edition Import screen, click on the blue Help button and download a full sample XLSX file.

Here are the key fields that you'll need to set up in order to run the import:

Action: Select Add to import new editions, Update to modify existing ones and Delete to remove the editions included in the XLSX file.

• Type: Dropdown
• Required: Yes
• Default Value: blank

Document: Click on [Choose File] to search your drives or directories for the XLSX to Upload (file size Limit: 100MB).

• Type: Media Upload
• Required: Yes
• Use the sample file attached

Live: Tick this box to make these Editions Live.

• Type: Checkbox
• Required: No (optional)

Batch Reference: Enter a batch reference. This is your reference so you can delete the batch of Editions or upload more Editions to the batch

• Type: Text

Edition Profile Code( Edition Profile): Set the Edition Profile (for example: Issue, Supplement, Advertisement).

• Required on Add mode

EditionCode: This is the unique code for each edition (appears as PrintProductCode in the edition URL).

• Required on Update mode

Name: The name of this Hard Copy Edition, for example “The Environmentalist May 2020” Issue.

• Required on Add mode

Title: Set a title for this edition (this title will be displayed on the public side. If left empty, the Name will be used).

• Type: text

Header Image - Set a banner image to be used on the Edition detail screen.

• Type: file src

Teaser: Set a Teaser text for this edition (which will be displayed on the Edition listing screen. If empty, the Teaser on the Section will be used).

• Type: text

Thumbnail: Set a thumbnail image to be used on the Edition listing screen.

• Type: file src

Main Image: Set the Main Image for this Edition.

• Type: file src

Main Body: Enter the main text to display within the Text tab on the edition detail screen.

• Type: text

Article Topic - Set the topics used to filter articles for this edition.

• Type: text

Section Code: Set the Edition section where you would like this item to appear.

• Type: integer
• Only allows for one entry

Multi Display Section Code: Set the additional Sections where this Edition should be displayed

• Type: integer
• Allows for more than one entry
• Separate multiple section codes with a pipe ( | ) delimiter

SO (Sort Order): Set the Sort Order for the edition listing screen.

• Type: integer

Security Clearance: Set a Content Security Right with which to restrict viewing access to this Edition.

• Type: text

Screen Name - Enter a unique, SEO-friendly Screen Name for the edition URL.

• Type: text

Year Of Publication: Set the year of publication for this edition.

• Type: Date (format: YYYY)

Product Line Code: Set the Product Line (or Range) this Edition belongs to (a Product Line is a series or range of products on offer by Business Unit).

• Type: integer
• Required on Add mode

Country ISO: Set a country, used to identify a country-specific edition.

• Type: text

Format: Set this edition as a Print and/or Digital version.

• Type: text
• Values: Digital / Digital and Print / Print
• Required on Add mode

Media: Set the PDF for the media item.

• Type: file src

Issue Number - Set the Issue number for this Product.

• Type: integer

Parent Edition Code - Set the Parent Edition if this is a Supplement, Inset etc.

• Type: integer

Subscription Plan Code - Set the Subscription plan that this edition is available to.

• Type: integer

Topics - Set the Topics or Keywords which are to be associated with this Edition.

• Type: text
• Allows for more than one entry
• Separate multiple section codes with a pipe ( | ) delimiter

Pages: Set the number of pages this Edition will have.

• Type: integer

GatefoldYN - Set the Gatefold to the Flatplan.

• Type: Boolean (1 / 0)

PolyWrapYN: Set the Poly-Wrap to the Flatplan.

• Type: Boolean (1 / 0)

CoverWrapYN: Set the Cover-Wrap to the Flatplan.

• Type: Boolean (1 / 0)

Submission Deadline: Add the date for final submission of content

• Type: Date (format: DD-MMM-YYYY)

Sign-Off Date (Final Deadline): Set the Sign-Off Date / Final Deadline for this Edition

• Type: Date (format: DD-MMM-YYYY)

Online Date: Set the date to publish this edition online.

Type: Date (format: DD-MMM-YYYY)

Press Date: Set the date this Edition goes to Press (i.e. to be printed).

• Type: Date (format: DD-MMM-YYYY)

Internal Delivery Date: Set the Internal Delivery date for this Edition.

Type: Date (format: DD-MMM-YYYY).

Circulation Date: Set the circulation date.

• Type: Date (format: DD-MMM-YYYY)
• Required on Add mode

Customer Delivery Date: Set the date the Edition is scheduled to arrive on the Customer's Desk.

• Type: Date (format: DD-MMM-YYYY hh:mm)
• Required on Add mode

CreateContactListYN: Select to create an associated contact list for this edition.

Tye: Boolean (1 / 0)

LiveYN: Select to make this Edition available for selection

• Type: Boolean (1 / 0)

ArchiveYN: Set to archive this edition.

• Type: Boolean (1 / 0)