TVirtualTable loading metadata from xml

jbakuwel · Post by **jbakuwel** » Tue 24 Aug 2010 09:42

Hi,

I'm trying to load http://www.andrewpatton.com/countrylist.xml into a TVirtualTable but nothing seems to happen? I would expect the "Load from file" function (using a XML file) to load the metadata and the data.

Am I wrong assuming that?

I also tried to explicitly add Col0 - Col13 and then load the XML file, which effectively removed the explicitly defined columns.

Please advise.

kind regards,
Jan

cosxp · Post by **cosxp** » Wed 25 Aug 2010 18:30

You should create dummy field and data value and
save it as virtualtable.savetoXML('temp.xml') and see the
actual xml format inside if you want to load xml data created
from other source not using virtualtable.

AlexP · Post by **AlexP** » Mon 30 Aug 2010 12:14

To load file into the VirtualTable, a file should be in an XML document in ADO-compatible format or in virtual table data format.

I couldn't load the file that your specified, but I think that its format is not supported.

99Percent · Post by **99Percent** » Mon 13 Sep 2010 00:28

Where can we find info on the XML ADO-Compatible format? I tried a google search but it led me nowhere.

Dimon · Post by **Dimon** » Mon 13 Sep 2010 13:57

View the following links:
http://archive.devx.com/whitepapers/mic ... mlmag8.asp
http://schemas.stylusstudio.com/msoffic ... index.html