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:
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.
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.
Mapping Types
There are several things you can map as seen below:
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.
info
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.
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.
Example Mapping
This section will show an example mapping from Exchange to a CMIS Repository for email archiving.
Calculated Fields
Calculated fields allow you to hard code values, such as the example above, or use functions like the example below.
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:
Click on the export icon with the down arrow on it.
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:
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