Skip to content

Create Data Mappings

Mappings represent the data link from an area in Business Central to a document library and the metadata. It is possible to create only one mapping per area. The definition of a mapping is done via the document type definition.

Create field data mapping

The following steps need to be completed to create a data mapping.

  1. Navigate through the DMS by Simova - Administrator role center.
  2. Click on Mapping in the ribbon bar and execute the action Data Mapping.
  3. Execute the action New in the ribbon bar.
  4. Specify the data mapping code by entering a code in the Code field.
  5. Specify the data mapping description by entering a description in the Description field.
  6. Specify the target table in the Target Table field which is the initial table.
  7. Specify the target field in the Target Field field which is the link field in the initial table.
  8. Specify the type in the Type field to connect the source and target fields together.
  9. Specify the source table in the Source Table field.
  10. Specify the source field in the Source Field field which connects the target field.
  11. A new line can be created if filters are to be applied. The type FILTER or CONST can be used. The filter value is specified in the Field Filter field. The filter is applied based on the Source Table and Source Field.
  12. A new line should be created and the checkbox New Table needs to be activated if you want to proceed to another table. The previous Source Table is the new Target Table in the new row.
  13. A final line needs to be created with the type RETURN in the Type field. These final line returns the value of the Source Field.

Create function data mapping

The following steps need to be completed to create a data mapping.

  1. Navigate through the DMS by Simova - Administrator role center.
  2. Click on Mapping in the ribbon bar and execute the action Data Mapping.
  3. Execute the action New in the ribbon bar.
  4. Specify the mapping code by entering a code in the Code field.
  5. Specify the mapping description by entering a description in the Description field.
  6. Select a document library code in the Document Library Code field to link the mapping with a document library.
  7. Specify the table by entering or selection of a table ID/Name in the Table field.
  8. Specify the page by entering or selection of a page ID/Name in the Page Card field.
  9. Specify the list by entering or selection of a list ID/Name in the Page List field.
  10. Add the Source field and Metadata Display Name mapping in the register Field Mapping. A field from the defined Business Central table is selected as the Source Field. The appropriate metadata from the DMS setup is selected as the Metadata Display Name.
  11. Activates the checkbox Include in Query for the source field to be used for the query. These are usually sequence number fields in the table.
  12. Execute the action Set Document Type in the ribbon bar.
  13. The Unique Document Type checkbox has to be activated if there is only one document type in the defined table. In case there are several document types in the table the mapping need to be defined by a Table Field and the specific Value. In most cases, there is a document type field that can be used to select the matching value for the document type.
  14. The creation of the mapping is completed.

Assign data mapping

There may be document types in Business Central that are archived in the business process execution. An alternative mapping needs to be set up in the original document type mapping to create a matching to the archived document type. The following steps need to be completed to set a alternative mapping on the original document type mapping.

  1. Navigate through the DMS by Simova - Administrator role center.
  2. Click on Mapping in the ribbon bar and execute the action Mappings.
  3. Click on the mapping Code that should be configured with the alternative mapping.
  4. Select a mapping code in the Alternative Mapping Code field to link a original mapping with antoher mapping.

Warning

It is important that all mappings are created first. The alternative mapping setup for archived areas should only then be carried out.