Skip to Content
Author's profile photo Former Member

Excel Upload/XML File Input for BO with Header Level and Item Level Elements

Requirement:

To upload excel data to a BO having header level and item level elements.

Main BO.PNG

Assumptions:

Generally requirements come in which Data is to be uploaded to a Standard BO (Eg: Sales Order, Purchase Order etc). But I am using a custom BO which contains HEADER LEVEL ELEMENTS and ITEM LEVEL ELEMENTS. The concept is same for both Standard and Custom BO. The BO am using is shown above.

Process:

  1. It is not possible to upload excel for a BO (MAIN BO) containing a header level and item level elements. So we are going to create a Custom BO (Secondary BO) with the same fields as the Main BO and all the elements will be put in the same level.Secondary BO.png
  2. Now the concept is to create a SERVICE INTEGRATION for the secondary BO (i.e upload excel for the secondary BO) and a code must be written in EVENT-BEFORE-SAVE of the secondary BO which will enter the data in the Main BO.

I am using SERIAL_NO as ALTERNATIVE KEY, since SO_ID will contain duplicates for secondary BO when we make entry for each item level elements as shown below.

Excel Upload.png

   3. In the EVENT-BEFORE-SAVE of the Secondary BO we will write the following code. Comments are also provided.

Event Before Save 1.png

Continue……

Event Before Save 2.png

   4. After making a file input through Application User Management -> File Input, we can see the data entered in both the BOs i.e. MAIN BO and Secondary BO.

Secondary BO entry.png

Data entry in Secondary BO.

Main BO entry.png

Data entry in MAIN BO.

THANK YOU

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Please Guys let me know if there is any alternative way to enter data to a BO with header level and item level elements through excel upload . Thank You