Skip to main content

Job Mappings

Before you start, be sure you are familiar with Creating Jobs and Discovery. Both are integral to mapping.

In this tutorial we will explain how mapping works in Simflofy. Where you can create your map types, aspects, fields and calculated fields. How to update mappings in mass using Mapping Templates. How to export and import mappings. And complex scenarios such as mapping type hierarchies

Creating Mappings

Simflofy Mapping gives you the ability to map your content types and metadata from one system to another. There are two places in Simflofy where you can set up mappings:
Reusable Mappings
Job Mappings Tab

Reusable Mappings

From the Integration menu on the left-hand side of the Admin Page:

Select Job Mappings

The Job Mappings menu item lets you create reusable mappings that you can then add to a job. This is especially useful when you have a lot of jobs with the same mappings. This way, you can edit one Job Mapping, and it will then be updated for all jobs that use that mapping. You can also download the JSON representation of the mapping to use for mappings import on another system.

Job Mappings

Mappings Tab

The Mappings tab in a job is great when you need a one-off mapping that other jobs won't use or if your mapping only applies to one job.

Job Mapping

Mapping Types

There are several things you can map as seen below:

Mapping Types

Field Mappings allow you to map metadata fields from the source to the target. The names and data types can change from the source to the target by setting the Target type.

mytype.docTitle --> title

Aspect Mappings allow you to map aspects for output systems that support them. Some systems, like OpenText Content Management System call these Categories. Aspects represent a collection of metadata field. You can typically have more than one aspect on a document.

Type Mappings allow you to map the source type to a target type. These do not have to be the same name.

document --> newtype

Calculated Fields allow you to set constant values by surrounding them in single quotes (') or using the Simflofy Expressions Language.


Calculated fields are processed before tasks and field/aspect mappings. If you wish to further use the product of a calculated field for you will need to create a separate mapping using the calculated fields output as the source.

Discovery Within Mappings

Mappings make heavy use of discovery information. Discovery allows you to pick your types and fields from dropdown lists instead of typing them out. It also knows the data types of each field. This allows for a much faster and less error-prone method of mapping types, aspects, and fields.

Mapping SourceMapping Source Data TypeCompleted Mapping

Audit Mappings

Audit mappings allow you to add field names and values to the Simflofy audit. These can later be used to create reports for analytics and/or validation. By default, Simflofy selects normal file system attributes to audit. These include file id, file name, created/modified dates, and author. A red eye is not being audited. Green is being audited. Simply clicking on the eye will change it to being audited or not.

Audit All MappingsMapping Actions

Example Mapping

This section will show an example mapping from Exchange to a CMIS Repository for email archiving.

Mapping Example

Calculated Fields

Calculated fields allow you to hard code values, such as the example above, or use functions like the example below.

Calculated Fields

If you find the function calls getting too complex, we strongly suggest using a Job Task instead. Calculated fields are designed to be simple. Complex examples that have multiple levels of function calls are prone to error and tasks are designed for complex logic, unlike calculated fields.

Importing and Exporting Mappings

To export a mapping, go to the Job Mapping page, and you'll see these action options:

Mapping Actions

Click on the export icon with the down arrow on it.

Export Mapping

Click Export Mappings to save the mappings as a json file.

To import mappings go to the Mappings tab in the integration job and click on the green Import button as below:

Import Mappings

You can import multiple mappings into the same job. Just click on the Import button and cut and paste the JSON from the export into the text area provided.

Additional Resources

Properties File Discovery

If you every have the situation where Discovery can't automatically find your fields, but you know they will be there, then you can create your own mappings with a properties file.
Properties File Discovery Instructions

Simflofy Expression Language

Simflofy uses a version of the JEval project to handle expressions. Expressions can be used in many places in Simflofy.
Simflofy Expression Language Overview

Related Articles:
Simflofy's Content Service Connection
Discovery Schema Instances
Integration Jobs Overview
Integration Tutorials