[solved] XML import to Lianja table

[barrymavin]

Hi Georg

Use xml_decode_file()
See doc: https://www.lianja.com/doc/index.php/XML_DECODE_FILE()

olddate = set("DATE")
set date german
drop table btest if exists
create table if not exists btest (datum date, vtext varchar) 
use btest
orows = xml_decode_file("unbennant1.xml", "ooo_sheet", "ooo_row")
foreach orows as orow
    insert into btest (datum, vtext) values(ctod(orow.column_1), strconv(orow.column_2))
endfor
set date &olddate
use btest
list datum, etos(vtext)