Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
0%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
100%
Focus on process automation/ integrations/ Real time data/ BI analytics
0%
Stick to basics
0%
Total votes: 1

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th September 2022, 16:16
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: Belgium
Posts: 1,219
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 > 10.7 - DB: MS SQL2017 - OS: VM WindowsServer2016
How can I make XML messages readable?

In our ION database I find the table ION_BOD_MESSAGE.
Code:
SELECT top 1000 *
  FROM [Infor_OSTest_ION].[dbo].[ION_BOD_MESSAGE]
  order by C_DATE desc
In it there is a BLOB field C_BOD with a HEX representation of the BOD.
Like C_BOD:
Quote:
Originally Posted by C_BOD
0x785EC5564B73E23810BEEFAFF0FA329789E5F01A42094F1120C435131E
31F3482E2A610BF044963C921C427EFDB66D48583207933D2C45A96CA91F
5FB7BEEE36FEFC9470EB91291D4BD1B5CF1DD7B6980865148B55D7FE36BF
...
5DD9EC66CDD40976DFDCE40BAFACAEF561774AA64AAE14349E0FD5014B05
83C55A6CAD371E8E585739B27204140D7DD7C50F7660F0FEBBF9BFBCEEC7
2A48C0202E5718CAE8F5FB03BD7E94A0C3EF4EEF1F6F76DB36
Now I would like to "grep Trigger *.xml" on the files in this BLOB, but as you can see they are HEX based encode somehow.

In OneView I can see these messages one by one, and in the "grid view" they are shown as a clickable icon where you can read the content. But when exporting to Excel CSV that column is not in the CSV.

What is the way to read the XML in the C_BOD field?
__________________
Also read Luke 24:4-8

Last edited by OmeLuuk : 8th September 2022 at 17:07. Reason: Add the SQL for the table...
Reply With Quote
  #2  
Old 8th September 2022, 16:24
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: Belgium
Posts: 1,219
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 > 10.7 - DB: MS SQL2017 - OS: VM WindowsServer2016
Fyi

The "Trigger" I would like to grep upon is added in the BOD/BDE with this On.Get.Hook:
Code:
long    info(PSMAXSIZE)
domain  tcpath2         trigger_nmp
e = pstat(pid, trigger_nmp, info)               | process name
o.trigger_id = str.join$("/", trigger_nmp, __OBJECT__, main.table$,
			 __FILE__, __FUNCTION__, __LINE__)
return (0)
Or in an Extension I use:
Code:
function extern long before.open.object.set()
{	| hook code
        long    info(PSMAXSIZE)
        domain  tcpath2         trigger_nmp
        e = pstat(pid, trigger_nmp, info)               | process name
        trigger_id = str.join$("/", trigger_nmp, __OBJECT__, main.table$)
	return (0)
}
Code:
trigger_id=(not isspace(trigger_id)?trigger_id&"/":"(Yet) Unknown/")&__OBJECT__
XMLPSTR(trigger_id, "datrg100.trig")    | ln.trigger
where the XMLPSTR is a define that puts a string in the output with the fieldlabels of the mentioned tablefield.

So the grep would give insight which triggerpoints did actually make the BOD.
__________________
Also read Luke 24:4-8
Reply With Quote
Sponsored Links
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Generic solution for writing XML files from Baan en@frrom Tools Development 1 11th April 2011 10:53
Problem with multiple XML documents.... BaaNovva Open World, Portal & Decision Manager 0 11th February 2008 12:12
make dbs.log readable norwim Code & Utilities 0 5th July 2005 12:49
How to make BW error messages disappear? Caner.B Tools Development 4 25th June 2002 18:29


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


©2001-2022 - Baanboard.com - Baanforums.com