Go Back > Forum > Baan SIGs > ION

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 14th July 2017, 11:37
bansaanu bansaanu is offline
Join Date: Mar 2010
Posts: 70
bansaanu is on a distinguished road
Baan: BaaN IV and ERP - DB: Oracle - OS: Unix and Window
XML File Parsing


I have following structure of the xml file:

<?xml version="1.0" encoding="UTF-8"?>
<SyncMaterialIssue1 xmlns="" xmlns:xsd="" xmlns:xsi="" releaseID="2" xsi:schemaLocation="">
            <ActionExpression actionCode="Change" />
         <ProductionOrderNumber variationID="25">MN0000001</ProductionOrderNumber>

I want to read this file so that it reads all production orders and lines under each one of them. I have following code to read the same:

long ret_val,ret_val2, ret_val3, savepono, ret
domain    tcmcs.str50    savepdno,saveitem,saveqnty

ret_val =  xmlFindFirst  ("ProductionOrderNumber", i.request)
ret_val2 =  xmlGetDataElement(ret_val, "ProductionOrderNumber",savepdno)

ret_val3 = xmlGetRightSibling(ret_val)

select Max(ticst001.pono):savepono
from ticst001
where ticst001._index1 = {:savepdno}

while ret_val3 <> 0
ret_val2 =  xmlGetDataElement(ret_val, "Item",saveitem)
ret_val2 =  xmlGetDataElement(ret_val, "Quantity",saveqnty)
savepono = savepono + 10"ticst001")
dal.set.field("ticst001.pdno", savepdno)
dal.set.field("ticst001.pono", savepono)
dal.set.field("ticst001.sitm", saveitem)
dal.set.field("ticst001.ques", val(saveqnty))
dal.set.field("ticst001.opno", 10)
ret ="ticst001")

if ret = 0 then
ret_val3 = xmlGetRightSibling(ret_val3)
But system is not reading ProductionOrderNumber element at all. Also, can you please verify if rest of the other code is fine as well? Can you please suggest if you find any issue?


Last edited by bhushanchanda : 17th July 2017 at 10:25. Reason: added code tags
Reply With Quote

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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Return value -2 on mmtmalone Tools Development 2 8th January 2014 22:03
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 09:22
Problems reading XML file. baanware Tools Development 4 2nd November 2004 12:37
Redirect Print to xml file prajesh Tools Administration & Installation 5 8th July 2002 15:56

All times are GMT +2. The time now is 11:16.

©2001-2018 - -