Share via


How to: Use SEPA XML Schemas to Prepare Data Exchange

To enable import/export of data in a SEPA bank file through the Data Exchange Framework or through an XMLport, you can use the related SEPA XML schema to define which data elements you want to exchange with Microsoft Dynamics NAV. You perform this work in the SEPA Schema Viewer window by loading the SEPA XML schema file, selecting the relevant data elements, and then initializing either a data exchange setup record or an XMLport.

When you have defined which data elements to include based on the SEPA XML schema, you can use the Generate XMLport action to create the XMLport object for import into the Object Designer.

Note

You mainly create XMLports to enable export of data to SEPA bank files.

In addition, you can use the Generate Data Exchange Setup action to initialize a data exchange setup based on the selected data elements, which you then complete in the Data Exchange Framework. This creates a record in the Posting Exchange Definition window where you continue by defining which elements in the SEPA file map to which fields in Microsoft Dynamics NAV. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.

Note

You mainly use the Data Exchange Framework to enable import of data from SEPA bank files.

This topic contains the following procedures:

  • To load a SEPA schema file

  • To select or clear nodes in a SEPA XML schema

  • To generate a data exchange setup that is based on a SEPA XML schema

  • To generate an XMLport for the SEPA bank file that is based on a SEPA XML schema

  • To import an XMLport into the Object Designer

To load a SEPA schema file

  1. Make sure that the relevant XML schema file (with extension .xsd) is available.

  2. In the Search box, enter XML Schemas, and then choose the related link.

  3. On the Home tab, in the New group, choose New.

  4. Fill the fields as described in the following table.

    Field Description

    Code

    Specify a code to identify the XML schema.

    Description

    Specify a description of the XML schema.

    The Target Namespace field specifies any namespace in the XML schema file that has been loaded for the line.

  5. On the Home tab, in the Process group, choose Load Schema, and then select the XML schema file.

    When the file is loaded, the rest of the fields on the line are filled with information from the file, and the Schema is Loaded check box is selected.

To select or clear nodes in a SEPA XML schema

  1. In the Search box, enter SEPA Schema Viewer, and then choose the related link.

  2. Fill the fields on the header as described in the following table.

    Field Description

    XML Schema Code

    Specify the XML schema file that you loaded in step 5 in the “To load the XML schema file” section.

    New XMLport No.

    Specify the number of the XMLport that is created from this SEPA schema when you choose the Generate XMLport action.

    The lines are now filled with nodes representing all elements in the XML schema. Nodes for elements that are mandatory according to the XML schema are selected by default.

  3. On the first line, in the Node Name column, expand the Document node, and then gradually expand underlying nodes that you want to review.

    Alternatively, right-click on a node and then choose Expand All.

  4. On the Home tab, in the View group, choose either of the following actions to change which nodes are displayed.

    Action Description

    Show All

    All nodes are shown.

    Hide Non-Mandatory

    Only nodes representing elements that are required according to the SEPA XML schema are shown. These nodes are typically indicated by a 1 in the MinOccurs field.

    Choose Show All to reverse the view.

    Hide Non-Selected

    Only nodes where the Selected check box is selected are shown.

    Choose Show All to reverse the view.

  5. On the Home tab, in the Manage group, choose Edit.

  6. In the Selected check box, specify for each node if you want the element to be supported in the data exchange setup for the related SEPA bank file.

    Note

    When you select a mandatory child node, all parent nodes above it are also selected.

  7. Choose the Select All Mandatory Elements action to reselect all nodes that represent elements that are mandatory according to the XML schema.

  8. Choose the Deselect All action to clear all selections.

    The Choice field specifies that the node has two or more sibling nodes that function as options.

To generate a data exchange setup that is based on a SEPA XML schema

  1. In the Search box, enter XML Schemas, and then choose the related link.

  2. Select the relevant SEPA XML schema, and then on the on the Home tab, in the Process group, choose Open SEPA Schema Viewer.

  3. Make sure the relevant nodes are selected. For more information, see the “To select or clear nodes in the SEPA XML schema” section.

  4. In the SEPA Schema Viewer window, on the Home tab, in the Process group, choose Generate Data Exchange Setup.

A data exchange setup records is created in the Posting Exchange Definition window, which you can complete by specifying which elements in the SEPA bank file map to which fields in Microsoft Dynamics NAV. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.

To generate an XMLport that is based on a SEPA XML schema

  1. In the Search box, enter XML Schemas, and then choose the related link.

  2. Select the relevant SEPA XML schema, and then on the on the Home tab, in the Process group, choose Open SEPA Schema Viewer.

  3. In the New XMLport No. field, specify the number that the new XMLport object will be given when it is generated.

  4. Make sure the relevant nodes are selected. For more information, see the “To select or clear nodes in the SEPA XML schema” section.

  5. On the Home tab, in the Process group, choose Generate XMLport, and then save the object as a .txt file in an appropriate location.

To import an XMLport into the Object Designer

  1. Open Microsoft Dynamics NAV Development Environment.

  2. In the Object Designer, choose XMLport.

  3. Choose File, and then choose Import.

  4. Select the XMLport object that you saved as a .txt file in the “To generate an XMLport for the SEPA bank file that is based on the SEPA XML schema“ section, and then choose Open.

See Also

Tasks

How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework

Other Resources

XML Schemas
SEPA Schema Viewer
How to: Export Payments to a Bank File
How to: Import Bank Statements
Collect Payments with SEPA Direct Debit
Designing XMLports