Skip to Content

Background

When you create a custom BO, sometimes you have a need to input huge volume of data in it. Doing this via UI is very cumbersome and sometimes unfeasible.  This document describes how can you enable data input for a custom BO using excel which eases the process to a large extent.

Steps to provide excel data upload

Step 1: Define the structure of BO with one or more alternative keys. Activate the business object. You can also build UI (OWL) on this custom BO to test your functionality at the end. /wp-content/uploads/2016/01/1_871096.png

/wp-content/uploads/2016/01/2_871133.png

Initially there is no data in the BO and hence the OWL is empty. At the end of this document it shall be filled with data.

/wp-content/uploads/2016/01/3_871134.png

Step2: Define a service integration on Custom BO so that it can be accessed by third party (file upload or web service etc)


Right click on BO and select ‘Create Service Integration’.

/wp-content/uploads/2016/01/5_871135.png

Select the message structure: the attributes you want to be part of excel file. Select Mass processing if you want multiple records to be processed. Finish the wizard and activate the PID file created./wp-content/uploads/2016/01/1_871096.png



Step3: Download the .xsd file On Activating the PID file you can download the .XSD file from General tab of PID file view. Download and save .xsd file on your local machine./wp-content/uploads/2016/01/8_871147.png



Step4: Define .xml file with field mapping and provide data for upload.

Open the .xsd file in excel and define mapping for fields and data for fields to be uploaded.


Open the .xsd in excel and enable the ‘Developer’ Menu in excel  (File->Options->Customize ribbon->Developer). Select ‘Source’ under Developer and then XML maps from side car.


/wp-content/uploads/2016/01/9_871151.png


This opens a pop up to add your xsd file. Click add and open the .xsd file from your local machine.


/wp-content/uploads/2016/01/10_871152.png

Map the attributes from .xsd file in excel by dragging and dropping them in columns. There are two sections in side car. Message header and List. From message header just take ‘CreationDateTime’ and drop it in excel column. List is the message structure that you selected when you created PID in SDK.

/wp-content/uploads/2016/01/11_871153.png

/wp-content/uploads/2016/01/12_871154.png

After the attributes are dropped, specify the data in the columns.     /wp-content/uploads/2016/01/13_871156.png    




And click on ‘Export’ in developer menu and save the file as XML file. This XML file will be used for input and to create records of custom BO.



Step5: Upload the .xml file to WebDav.


Login to Business byDesign system as key user and navigate to Application and User Management->File Input.



/wp-content/uploads/2016/01/14_871157.png

Open the view “Unprocessed Files” and add the XML file you want to upload as shown below. Select your service interface created in SDK. After doing this the XML file is uploaded in WebDav folder and can be seen in the view ‘Unprocessed files’.

/wp-content/uploads/2016/01/15_871158.png


/wp-content/uploads/2016/01/16_871159.png



Step6: Create a run to upload the file and trigger service interface to create data in custom BO.


Now the XML file is uploaded and the system should read this file for processing. Define a new run to read this file and execute data processing. Select your Service interface in the new run and activate the run./wp-content/uploads/2016/01/17_871161.png


Schedule the run to run immediately.


/wp-content/uploads/2016/01/18_871162.png


Run has started. Keep monitoring the run status until it is finished. /wp-content/uploads/2016/01/19_871169.png

When the run is finished the XML file from “Unprocessed files” will disappear. /wp-content/uploads/2016/01/20_871170.png



Step 7: Check the UI if the data is created. The data comes up on the UI and hence the upload of XML file worked.


/wp-content/uploads/2016/01/21_871171.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply