Load XML directly to recordset object

[Former Member]

Hello:

Does anyone has sample codes of how to load XML file (may not be SBOBO type schema XML) directly load to recordset objects?? When I do this I encounter two problems:

1. On the trainning document it says with loadXML and SaveXML objects only the XML with SBOBO type schema can be used. So if a XML carrying a random set of data, then I can't use loadXML and SaveXML objects.

2. RecordSet objects seem only interact with data already existed in SBO database. So for me to put it in a recordset object, I will need to create a user-defined table and put XML data in there first, before retrieve it to recordset. Doesn't seems to be a very efficient process.

I am very new at this, so any help will be appreciated it! Thank You!

[Former Member · Accepted solution]

Hello. Thank you for your advices, The XML data, once loaded into SBO addon application or database, needed to be manipulated quiet a bite such as caluclation, additions, concatenations...etc before insert into Business objects. So that's the reason why the data would needed to be pushed into recordset. If there are better ways to do that please let me know, very much appreciated it in advance. Thank You! Again, I am very new at this. So there might be a lot of things I haven't touched yet!

[Former Member · Accepted solution]

Hey Bo,

Ok, this sounds like something that I am doing... But I use XML to mess around with the data and then when I need to push it back into the Business Objects I parse through the XML Data using XPath and only update the data that has been changed or create new objects when needed... I know this really sucks but it is the only way that I have been able to find for doing it... From talking with some of the guys that are working on SAP, they are working on making things work faster and better when dealing with this sort of operation... I hope this helps...

Jeremy Adam

[Former Member]

Why do you want to load the XML data directly into a Business One recordset object?

Recordsets are intended to present tabular data extracted from a database to you. If you want to process an XML file there are other perhaps more appropriate objects such as MSXML that you could use. As recordsets don't offer any extra functionality other than let you read the data I can't understand why you would want to use one at all with XML data.

If you could provide some details on what you are actually trying to achieve at a functional level someone may be able to offer some additional advice.

Regards,

John.

[Former Member]

Can somebody help! Please?

[Former Member]

Hey,

As far as I can tell from my playings, There is NO way to load the data directly in to a recordset... You would have to use the UDT to a UDO then load the UDO...

Sorry,

Jeremy Adam