Click View App to open your application in the browser.Click the play button ( Run Locally) to start your application.
Excel import xml data excel generates how to#
In this section, you will learn how to do this by following these steps: This can be achieved by using the Mx Model Reflection module. In order to set up import templates for importing data, your application model metadata should be reflected in the client. Set the Return value as follows: if $Unformatted = 'open' then Įlse if $Unformatted = 'processing' then Įlse if $Unformatted = 'complete' then ĥ Using Application Model Metadata in the Client Secure your applications (see How to Create a Secure App)ģ Preparing the Data Structure, GUI & Modulesīefore you can start importing data into your application, you first need to set up the data structure and GUI by following these these steps:Ĭreate an enumeration for the OrderStatus attribute with the values of Open, Processing, and Complete.Ĭonfigure the XLSFile object to inherit from the FileDocument object (for more information, see How to Work with Images & Files).Ĭreate Overview and Detail pages to manage objects of the Customer and Order types.Ĭreate menu items to access the Order and the Customer overview pages.ĭownload the Excel Importer and Mx Model Reflection modules from the Mendix Marketplace (available by clicking the shopping-cart icon in the upper-right side of Studio Pro).Ĭreate menu items for the ExcelImportOverview and the MxObjects_Overview pages (these pages already exist in the _USE_ME folders of the downloaded modules).Ĭonfigure the Administrator user role to have the Configurator module role for the ExcelImporter module, and the ModelAdministrator module role for the Mx Model Reflection module.īecause an enumeration is used for the OrderStatus attribute, you need to create a microflow to determine the enumeration value of the attribute based on the input from the Excel file.Ĭreate the following microflow and name it IVK_ParseStatus.Add Marketplace content to your app (see How to Use Marketplace Content in Studio Pro).Create microflows (see How to Trigger a Microflow From a Menu Item.Create menu items (see How to Set Up the Navigation Structure).Create overview and detail pages (see How to Create Your First Two Overview & Detail Pages).Create domain models (see How to Create a Basic Data Layer).2 Prerequisitesīefore starting this how-to, make sure you know how to do the following: In this how-to, you will set up import templates and import data into your app using this module. In order to save time and effort, this process can be automated using the Excel Importer from the Mendix Marketplace. Adding large amounts of data to your application (for example, reference data or data from an external application) can be very time-consuming.
0 kommentar(er)
