XML to dataset

Classic Servoy
1

Is there a database functions or an easy way to write an XML file to a dataset?
Or has somebody experience with that?

2

What is it that you are trying to do? A dataset is a “flat” table, while a XML file could be deeply nested, so I am not sure I understand how that fits.

3

Actually we are exporting date from a DB table to a XML and later we would like to read that XML data and write it to a dataset.

4

So your XML is “flat” already in that sense… You could have a look at JS Lib and there the XML and XMLList for out-of-the-box XML support. As an alternative you could have a look at our XML plugin. Once you have the data, creating the dataset is easy. The steps are

  1. create empty dataset: databaseManager.createEmptyDataSet( row_count, columnCount/array_with_column_names)
  2. loop over your “rows” and set cell values: dataset.setValue(number row, number col, obj)