Skip to content

Latest commit

 

History

History
155 lines (96 loc) · 8.96 KB

importing-xml-documents.md

File metadata and controls

155 lines (96 loc) · 8.96 KB
Raw
title url category weight tags
Import XML Documents
/howto8/integration/importing-xml-documents/
Integration
3
import
xml
integration

1 Introduction

Mendix is the app platform for the enterprise organization, and in enterprise software, you likely do not work in a green field. In almost every situation, you will need to integrate with existing systems. Mendix supports many ways of integration, but this how-to focuses on how you can import XML documents with Mendix.

This how-to teaches you how to do the following:

  • Prepare the data structure and GUI
  • Add an XML schema
  • Create XML-to-domain mapping

2 Prerequisites

Before you continue, make sure that you know how to create:

3 Preparing the Data Structure and GUI

The XML document used in this how-to contains customers. To be able to see the imported data, you first need to set up the data structure and GUI to maintain the customer data. Then, you need to facilitate the uploading and downloading of XML documents. Finally, you will create the actual import logic and the corresponding import mapping.

To prepare the data structure and the GUI, follow these steps:

  1. Create the following Customer entity in your domain model:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581649.png" class="no-border" >}}

  2. Create the overview and detail pages to manage objects of the Customer type.

  3. Create a menu item to access the customer overview page.

  4. Create an entity called XMLDocument that inherits all the properties from System.FileDocument:

    {{< figure src="/attachments/howto8/integration/export-xml-documents/18581650.png" class="no-border" >}}

  5. Create the overview and detail pages to manage objects of the XMLDocument type.

  6. Create a menu item to access the XML document overview page (for more information, see How to Set Up the Navigation Structure.

4 Adding an XML Schema (XSD)

Whether you plan to import or export documents, working with XML means that your application must contain an XML schema, which is also called an XSD. An XSD describes the possible contents of an XML file. Based on the XSD, your application knows how to read or write an XML file. If you don't have an XSD file, there are some online XSD generators that accept an XML document as input. For this how-to, you can use Customers.xsd.

To add an XML schema (XSD), follow these steps:

  1. Right-click a module in the Project Explorer and select Add Other > XML schema from the menu.

  2. Enter CustomersXSD as the Name and click OK:

    {{< figure src="/attachments/howto8/integration/export-xml-documents/18581696.png" class="no-border" >}}

  3. In the XML Schema editor, click Select and select the XSD file that you downloaded earlier:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581657.png" class="no-border" >}}

  4. Click OK to save the XML schema, which you will be using in the following steps.

5 Create XML-to-Domain Mapping

The XML schema describes what the possible contents of an XML file are, but we need to create an XML-to-domain mapping to define how the data in the XML document is imported into the application.

To create the XML-to-domain mapping, follow these steps:

  1. Right-click a module in the Project Explorer and select Add Other > Import mapping.

  2. Enter ImportCustomersMapping as the Name and click OK. The new mapping will open automatically and the elements will be shown.

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581689.png" class="no-border" >}}

  3. On the Select schema elements dialog box, make sure XML schema is selected as the Schema source, and select CustomerXSD as the schema. Then, click Expand all to see the tree with elements.

  4. Select the following elements: Customer, ID, CompanyName, Address, City, and PostalCode:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581656.png" class="no-border" >}}

  5. Click OK. The first part of the import mapping should look like this:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581655.png" class="no-border" >}}

  6. Open the connector (from the lower-right side of Studio Pro or from the View menu).

  7. Drag the entity Customer from the connector into the place-holder in the mapping editor:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581681.png" class="no-border" >}}

    The Map entity editor for this element will open automatically:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581654.png" class="no-border" >}}

  8. In the Map entity editor, do the following:

    • Select Find an object (by key) for the Method (to be able to search for an object, you need to define one or more keys in the value-to-attribute mappings)
    • Select Create for If no object was found
    • Select attributes for all five value-to-attribute mappings
    • Set CustomerID as the Key

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581653.png" class="no-border" >}}

  9. Click OK to save the mapping.

6 Creating the Import Logic

In this section, you will create the logic to import the customers stored in an XML document in your application.

To create the import logic, follow these steps:

  1. Open the XMLDocument overview page. It should look this, using a default layout:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581648.png" class="no-border" >}}

  2. Right-click the toolbar of the data grid widget and select Add button > Action to add a new action button:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581647.png" class="no-border" >}}

  3. Double-click the new button to open the Edit Action Button editor and do the following:

    1. Change the caption to Import XML Document
    2. For the On click event, select Call a microflow, then click Select for the microflow, create a new microflow, and name it XMLDocument_Import.
    3. Click OK to save the properties.

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581646.png" class="no-border" >}}

  4. Right-click the new Import XML Document button and select Go to on click microflow in the context menu. You should see an empty microflow with XMLDocument as the input parameter:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581669.png" class="no-border" >}}

  5. Open the Toolbox and drag an Import with mapping activity to the line between the start and end event. This inserts a new import XML activity.

  6. Double-click the new activity to open the Import With Mapping dialog box and do the following:

    1. Select the input parameter XMLDocument as the Variable.
    2. Select the previously created XML-to-domain mapping ImportCustomersMapping as the mapping.
    3. Click OK to save the properties.

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581668.png" class="no-border" >}}

    The microflow should look like this:

    {{< figure src="/attachments/howto8/integration/importing-xml-documents/18581667.png" class="no-border" >}}

7 Importing an XML File

To import the XML file, follow these steps:

  1. Deploy the application, upload Customers.xml, and trigger the import microflow.
  2. Open the customer overview page and check if the customer data has been imported into your application.

8 Read More