Mediaset: Export and Import of Assets Between Two Systems

Mediaset: Export and Import of Assets Between Two Systems

06 November 2020

This paper describes how to export assets from a source system to a destination system, explaining step-by-step how to import all processed assets and associate them to the media files present in the destination system, thus allowing them to be scheduled to go on-air.

For more information, please refer to the attachment.

1. INTRODUCTION
Etere provides broadcasters, media companies, content providers and house productions with an integrated media management system which combines powerful servers with an easy to use user interface. Etere is able to closely interact with other systems present within the global system, allowing to export assets from one system to another, this, including all their data and metadata:

This paper describes how to export assets from a source system to a destination system, explaining step-by-step how to import all processed assets and associate them to the media files present in the destination system, thus allowing them to be scheduled to go on-air.

Proposed Solution
The module used to export and then import assets is the Import/Export module, which can be found in the main Etere Scheduling menu:

The Import/Export module allows performing the importation and exportation of assets and daily schedules in more than 24 fully customizable formats, in this case, the used function will be the XML Assets Full export and import which include the proper asset table and all its related tables, allowing to recreate in the target system the asset in question exactly as it was in the current system; all asset-related data is mainly stored in a single table which is supported by other secondary tables

In the following three sub-chapters, there will be detailed how to accomplish with the requested export-import features.

2.1 EXPORTING ASSETS
The XML Asset Full section allows to export a xml file for each selected asset, containing all its relevant fields (i.e.: ID, code, description, duration, SOM/EOM, smpte metadata, etc), and its name will be assigned in the format etere.asset.ABC.xml, where 'ABC' will be replaced with the code of the relative asset. In order to use this option the following fields must be compiled:
■ Export path: Specify the folder on which the exported xml file(s) will be saved,
■ Select assets to be exported: Search for the assets intended to be exported, available search methods are:
■ Search assets for: It mainly permits to search for either only those assets scheduled on a certain time range, or also for those that have not yet been scheduled,
■ Additional parameters: Set here some filters regarding the production data of the assets to be retrieved,
■ Full text: Carries out the search through all the selected fields of assets present on the entire database,
■ Query Manager: Permits to insert/create custom SQL queries for a more complex but advanced selection of assets,
■ Rules: Allows to narrow the search to either 'expired' or 'not to be broadcasted' assets. When all assets intended to be exported have been retrieved in the bottom part of the search window, just make double-click on them while holding the CTRL key:

Once the export has been configured, it can be started just by pressing the Start button, a xml file will be created for each selected asset within the indicated folder:

NB: In case some problems are encountered during the export process, under the 'errors' tab it will be possible to consult them in order to override them.

2.2 IMPORTING ASSETS
The XML Asset Full section allows to import asset forms (forms containing key asset's information) from xml files located on a certain folder. XML filenames intended to be imported must have the following format etere.asset.ABC.xml, where 'ABC' is the code of the relative asset in question.

This import function will update (if requested) all Series data (i.e.: the FSerie table) and EDL data (i.e.: the Finterruzioni table) of those assets present in the import file which already exists in the Etere database.

In order to use this option the following fields must be compiled:
■ Import path: Specify the folder from which the imported xml file(s) will be retrieved,
■ Path where to move imported files: In case you want xml files to be moved to a certain folder once import is finished, specify it here, otherwise, leave it blank and xml files will remain on its source location,
■ Assets must be unique: If enabled, processing assets with an already existing code will not be imported.
■ Source site number: In case of importing assets from a federated installation, indicate the source site from which assets are being imported.

Once the import has been configured, it can be started just by pressing the FILE Import button, so many asset forms as xml files exists on the selected folder will be created. When the import has finished, it will be possible to display the schedule of the related day to verify and/or approve the import operation.

NB: In case some problems are encountered during the import process, under the 'errors' tab it will be possible to consult them in order to override them.

2.3 Adding Media Files
In order to associate media files to imported assets, launch the Asset Form module from the Etere Scheduling menu:

The Asset Form module allows operators to control and also carry out, various of the most relevant operations comprehended by the Asset Management process. At this point just search for the imported asset by compiling the relevant filters, once found, make right-click on it and select ‘Open’: (In the example above, they have been searched all video clips imported from the Milan station)

Navigate to its Technical data section where media files are associated to assets, make right-click and select the ‘add media’ option:

Insert its source name, the metadevice on which it is stored, the codec with which it is codified, the exact path on which it is present and the filename:

Once all these data have been inserted, click on the ‘OK’ button and save the asset form, the imported asset is now associated to a media file and it’s ready to be scheduled for going on-air:

In order to associate media files to the rest of imported assets just repeat all the instructions provided in this chapter (2.3 Adding Media Files).

Since its beginnings in 1987, Etere has been preparing users to be ready for the future. Etere is a worldwide provider of broadcast and media software solutions backed by its mark of excellence in system design, flexibility and reliability. Engineered in Singapore, the revolutionary concept of Etere Ecosystem promotes real-time collaborations and enhances operational efficiency across the entire enterprise. Etere Ecosystem software solutions including Media Asset Management, Channel-in-a-Box, Newsroom, Ad Insertion, Airsales, Automation, Broadcast Management System, Censorship, HSM Archive, Logging, OTT/VOD Delivery, Radio-Live, Subtitling and Captioning software are built with an integrative Web and Windows architecture that are customisable to fit perfectly in any system. Etere system is developed by 4 different groups in different countries to ensure reliability and quality. Etere delivers on its service excellence commitment with its dedicated team and a 24/7 worldwide support. Its portfolio of digital technologies and market-proven remote/on-site solutions including consultancy, training, installation and demonstrations are ready to run with your business no matter where you are. Etere enhances your adaptability for the future and empowers you with the software tools to drive your business to greater heights. www.etere.com
Etere logo
About Etere
Since its beginnings in 1987, Etere has been preparing users to be ready for the future. Etere is a worldwide provider of broadcast and media software solutions backed by its mark of excellence in system design, flexibility and reliability. Engineered in Singapore, the revolutionary concept of Etere Ecosystem promotes real-time collaborations and enhances operational efficiency across the entire enterprise. Etere Ecosystem software solutions including Media Asset Management, Channel-in-a-Box, Newsroom, Ad Insertion, Airsales, Automation, Broadcast Management System, Censorship, HSM Archive, Logging, OTT/VOD Delivery, Radio-Live, Subtitling and Captioning software are built with an integrative Web and Windows architecture that are customisable to fit perfectly in any system. Etere system is developed by 4 different groups in different countries to ensure reliability and quality. Etere delivers on its service excellence commitment with its dedicated team and a 24/7 worldwide support. Its portfolio of digital technologies and market-proven remote/on-site solutions including consultancy, training, installation and demonstrations are ready to run with your business no matter where you are. Etere enhances your adaptability for the future and empowers you with the software tools to drive your business to greater heights. www.etere.com