1. Home
  2. /
  3. V12 Documentation
  4. /
  5. Standard Operating Procedures
  6. /
  7. ONIX AIDA

ONIX AIDA

Purpose

This procedure describes the handling of the incoming ONIX Rel.3.0 data to create or update product data in IP1 via AIDA platform.

Process

The ONIX feed is received from the Presses (Trading Partners) into Iptor iSeries AIDAHUB. The program Iptor Exchange (AIDA) assigns the feed a ‘Batch Id’, which is the value of the ‘sentdatetime’ segment in the feed with a three-character identifier for the press. It then maps the feed into files where each record contains the information about a single value and the File/Field/ISBN in IP1 to be updated. The mapping is controlled by translation tables which specify the translation from an ONIX value to an IP1 value.

The resulting file is sent to the customer where it is used to update the IP1 database.  A report is produced for each feed listing any problems in the mapping including suggestions as to how to correct the problem by updating ONIXAIDA control records. When the ONIXAIDA control records have been updated in IP1, the batch can be reprocessed. This sends

  • the ONIXAIDA records to AIDA to refresh the translation tables
  • the batch id to be reprocessed. The reprocessing is done over a copy of the ONIX data which is kept within AIDA

The reprocessing is repeated until there are no issues with the batch. When processing is finished an email will be sent to email addresses as specified in control records with message of completion or further action required.

ONIX AIDA process flow

Scope

Included The setup within IP1 to manage the incoming ONIX AIDA feed and the procedures to review/manage errors and control records for re-processing as required for a successful update of ONIX data.

Monitoring of ONIX AIDA Hub.

Prerequisites/setup

IP1 Business rules For a complete list of ONIX AIDA control records that must be maintained for this process please refer to the control files for ONIXAIDA application on IP1. Business rules for ONIX AIDA import must be setup with support from Iptor IP1 consultants. It is critical to understand the setting of control files and how it works. Control files must be setup correctly for the system to operate as intended. Any changes to the control files setup should be addressed cautiously and in consultation with Iptor IP1 consultants.
ONIX Mapping ONIX feed from the presses is mapped to the IP1 files by Iptor Exchange (AIDA). The configuration for this mapping comes from the control files application ONIXAIDA in IP1. For details of the mapping please see ONIX Mapping and Control records document.
Work with Active jobs Add the background job in IP1 system for the incoming ONIX feed from AIDA Hub.

Procedure

It is your responsibility to ensure that you understand this procedure before performing the following tasks.

Note Deviations from this procedure should be covered by procedures written by your company. Before performing any tasks please ensure all the business rules are set-up accordingly.

ONIX management

EDI ONIX queue management This allows you to start and stop the ONIX queue i.e. the background job that manages the incoming data from AIDA Hub and outgoing data from IP1 to AIDA Hub.

  1. Expand Other options > Data Interfaces > ONIX – AIDA > EDI Options and double-click EDI ONIX Queue Management. BNEDM010 EDI ONIX Queue Processor Manager panel appears.
  2. Activate the queue by entering 1 against the Activate the processor field.
ONIX item file list This is a list of files that needs to be maintained for incoming OINX data. Each file would have a list of fields with validations and whether the field is mandatory or not. The list would normally be maintained by Iptor consultants.

  1. Expand Other options > Data Interfaces > ONIX – AIDA > ONIX Management and double-click ONIX Item File List. ONI120 ONIX Import File list panel appears.

  1. Use Option 5=Details to view the field details i.e. validation details and if its mandatory.

Option Description
Import validation This lets you specify the field validation rule i.e. validation control record or validation program with the following flag: 

U = only import if item is new

N = do not import

Y = always import

U = import it and let the user review it (flag for user review)
Selc/unselec mandatory Allows you to flag/unflag a field as mandatory
  1. Maintain the files using as required.
Work with ONIX import batches This is a batch inquiry program that is used to identify and review the batches with the errors to take appropriate actions as required.

  1. Expand Other options > Data Interfaces > ONIX – AIDA > ONIX Management and double-click Work with ONIX Import Batches. ONI020 ONIX Interface – Batch panel appears.

Initially the active batches (i.e. batches with errors) for all channels (presses) will display.

    1. You can use Function F10=All to see all batches. Batches with status ‘C’ is completed batches, status ‘D’ are batches with errors, but it can be ignored.
Option Description
Detail Lists the Batch Id, Sender, File name, Status, Message and details for AIDA lookup.
Item  Use this option to see all the individual items in the batch.
Err summary Error summary is currently not being used; instead, emails are issued to the nominated users if there are any errors.
Reprocess This will re-initiate the reprocessing of the batch. When all the issues are fixed (usually involves the update of ONIX AIDA control records) use this option to send the ONIX AIDA control records to AIDA with the request to re-process the batch.
Close Closes the batch after error review without processing i.e. to be ignored. Status would change to ‘D’.
  1. Select the batch you want to inquire on with Option 2= Item to see all the items for that batch.

From this panel, you can see if the errors are mapping errors, validation errors or errors for user review using Function 10=Map err/Val err/Usr rvw.

Option Description
List all Displays all the fields for the selected item.
Item inq Allows item master inquiry.
Item mnt Allows you to maintain the item master file to fix the data so it can go through in the next batch without any error.
  1. Use Option 2=List all to see all the fields that came through for the selected item.

  1. Use Option Detail to review the error; for user review errors, you can take the action to either accept it for processing or reje.
Monitoring ONIX AIDA Hub Web client is available for Iptor Exchange administration & monitoring incoming ONIX files.

The URL for the Hub is https://aidahub.tech.iptor.com/aidawebclient/. You need to be setup as a user to gain access. Restrictions are placed on users so a non-administrator user can only access specific companies, business partners and events.

  1. Click on the above URL.
  2. Login with your credentials.

Each line represents an ONIX file coming in.

Column Ref 1 holds the file name. 

Column Ref 2 is the Batch ID assigned by AIDA; it also shows the number of items in the batch. If a file is too large it can be split be into 2 batches.

Status 1 & 2 indicates if it was translated without any errors and pushed into IP1 system.

Note: You can right click on any of the lines and view the XML message.

ONIX reports

Publisher/imprint relationships Publisher name and imprint name from the ONIX feed determine the item levels. This report lists the item levels for the publisher and imprint relationship.
Collections/series relationships This reports on the relationship between the incoming collections and the series.
Print Friendly, PDF & Email