Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 24th June 2017, 00:39
vik.patil vik.patil is offline
Member
 
Join Date: Apr 2008
Posts: 40
vik.patil is on a distinguished road
Baan: ERP LN - DB: MS-SQL - OS: MS-WINDOWS
Update XSLT Mapping for Incoming BOD

Hi All,

We are working on integration of EAM with LN10.5 and facing issues with one of the Incoming BOD(SourceSystemJournal) which is giving error for 2 fields Accounting Entity and Location.

Infor recommend that we need to include these 2 values in inbound BOD using XSLT Mapping. May I know how to use xslt mapping to add these 2 field in incoming BOD so that we will get all BOD's without any error.

Any help appreciated

Regards,

Vikram Patil
Reply With Quote
  #2  
Old 26th June 2017, 12:20
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
You can just do a google search on "How to add elements using XSLT" and you will find many online resources with sample code snippets to do it.

Just edit and use them to add whatever you need.

Here is an example.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 27th June 2017, 05:47
vik.patil vik.patil is offline
Member
 
Join Date: Apr 2008
Posts: 40
vik.patil is on a distinguished road
Baan: ERP LN - DB: MS-SQL - OS: MS-WINDOWS
Thanks Bhushan.

I got information on how to add field using XSLT. Now when I have added code to add new fields which is working fine if source xml doesn't have namespace xmlns="http://schema.infor.com/InforOAGIS/2" in source XML File.
Following is code I am using as XSLT:

xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
<xslutput method="xml" indent="yes"/>

<xsl:template match="@* | node()" name="identity-copy">
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="DataArea/Process">
<xsl:copy>
<xsl:apply-templates select="@* | *"/>
<AccountingEntityID>201</AccountingEntityID>
<LocationID>S_201</LocationID>

</xsl:copy>
</xsl:template>
</xsl:stylesheet>

This code works if Source XML doesn't have xmlns="http://schema.infor.com/InforOAGIS/2" and with this namespace we are not able to add new columns in xml file to pass it to LN.

Please let me know anything missing in XSLT Code

Regards,

Vikram
Reply With Quote
  #4  
Old 27th June 2017, 06:21
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
You will need to bind the custom namespace to a variable and then use it to insert your elements. Check this link
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
  #5  
Old 9th July 2017, 01:07
vik.patil vik.patil is offline
Member
 
Join Date: Apr 2008
Posts: 40
vik.patil is on a distinguished road
Baan: ERP LN - DB: MS-SQL - OS: MS-WINDOWS
Thanks for suggestions. I am able to fix this issues. I have added name space as
xmlns:bod="http://schema.infor.com/InforOAGIS/2" and modified match template as <xsl:template match="//bodataArea/bod:Process">.

Regards,

Vikram
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
tibom1213m000(Detect low level code and loop) Issue mark_h Tools Development 8 3rd December 2012 18:29
update session smusba Tools Development 4 7th March 2009 06:17
Table update problem Debdas Banerjee Tools Development 3 30th October 2003 19:10
Update in update Andron Tools Development 5 26th October 2002 00:47


All times are GMT +2. The time now is 01:56.


©2001-2017 - Baanboard.com - Baanforums.com