Excel I/O import insert extra info.

Created by Cheng Kah Poh, Modified on Fri, 3 Mar, 2023 at 3:49 PM by Cheng Kah Poh

Scenario:


below is OR Standard IO Excel Format


Table 1: 


Table 2:


Question: Hi. Possible to insert a note, or additional reference/remark which by default hv in system but not in I/O Export Excel file. They want to key in excel then import back?



Solution:


1st - From Master Part, we can find there is a Reference 1 field in Others Tab.


in Excel File, Brown Color Table which is Table 1 is equal to Master Part.


therefore, actually we can add column into the Standard IO Excel, in order to request system get the result we want, as long as user fill in the correct column Header, Example: Reference 1 = Ref1


2nd- In Details Part have same feature as well, the Blue Color Table or Table 2 is equal to Details Part, so i added the extra column call referenceno.



After import, and get correct result.


** Learn more about Bank Muamalat IBIZ Bulk Payment

** Learn more about QNE Hybrid Cloud Software

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article