Data Mapping with Perfion Actions

Transform, combine and validate your data on its way into or out of the Perfion PIM system

With the Perfion Product Information Management solution you have a single source of truth for product data. Data is modelled and structured in ways that make sense to the specific needs of your organization.

Transform, combine and validate your data on its way into or out of Perfion.But what happens when you need to exchange data with suppliers, partners and customers, and they work with data in different formats and structures?

The answer is Data Mapping.

In its core, Data Mapping is about transforming data from one format to another. Not only from a technical viewpoint (Excel, CSV, XML, SQL), but also from a logical viewpoint (different data models, measures, naming standards, etc).

You can find many dedicated Data Mapping solutions in the market that will integrate with PIM systems and solve this task. But with Perfion PIM, Data Mapping comes as a built-in tool. We call it Perfion Actions.

Perfion Actions

Perfion Actions is a powerful Data Mapping framework, that allows you to create your own Action Maps. An Action Map can consist of several steps performed in sequence:

An Action Map can consist of several steps performed in sequence

Examples

Perfion Actions can solve an endless number of tasks for you. Here are a few examples.

Example 1:
Import data from suppliers

Suppliers might send you data in a variety of different file formats (Excel, CSV, XML) with data structured according to their data models. With Perfion Actions you can import data as you receive it. All you need to do is build an Action Map for each supplier to map supplier formats to your Perfion formats.

Supplier data can be imported as-is with Perfion Actions
Supplier data can be imported as-is with Perfion Actions

Example 2:
Import images from “hotfolder”

Managing images is a big task for many businesses. Perfion Actions can help you do it in clever ways.

We saw earlier that supplier images can be imported with Perfion Actions. But what if your in-house photographers shoot beautiful product images but have no knowledge of Perfion? Perfion Actions can help you by importing images from a “hotfolder”.

All your photographers need to do is name each image with a reference to a product (e.g. [itemnumber]_01.jpg) and save images in your “hotfolder”. Perfion Actions can then “scan” the folder for new images and import these to your products.

Images can be imported from “hotfolders” to products or image libraries with Perfion Actions
Images can be imported from “hotfolders” to products or image libraries with Perfion Actions

Example 3:
Manage translations

If you work with a translation agency to manage translations, Perfion Actions can help you automate the Translation Management process.

Example 4:
Deliver product data to ETIM

Your company may need to deliver data to ETIM (The European Technical Information Model – an open standard for the classification of technical product data). To do that, you must export your data and transform it to the correct data exchange format (BMEcat). With Perfion Actions you can build an Action Map that solves the task. The Action Map must select relevant products and data from your Perfion database, transform data into BMEcat format and upload the file to the classification portal.

Sample XML-file with your data transformed into BMEcat format
Sample XML-file with your data transformed into BMEcat format

Scheduling of Actions

The built-in Perfion Scheduler allows you to specify execution schedules for each Action Map. One Action Map should run every night at 2:00AM, another should run every hour. It’s all up to you.

It is also possible for authorized users to execute Perfion Actions manually from the Perfion application. This is very useful for one-time data manipulation work, or for trying out your actions before scheduling them.