I need to import data from a number of XML documents, I looked through the SF namespaces for a function to do this but didn't find anything. I want to makes sure I am not missing it before I do it by hand like I used to do with a reader. Essentially I am looking for VFP's 'cursortoxml'. Do you have something like that I have missed?

Keith Chisarik

You can only read the XML file if it was written to the file using the business object's table.  When the table writes it's data to disk, there is an overload that allows you to tell it that you want to write the schema to file as well.  If you write the schema, then you can read the file and schema back in.

You can get it to work...I have done this on a number of occasions.  First, look at the ReadXmlSchema method on the DataTable.  Second, reverse engineer the WriteXml on the DataTable which has support for the schema.

Microsoft XSD Inference 1.0

The Microsoft XSD Inference utility is used to create an XML Schema definition language (XSD) schema from an XML instance document. When provided with wellformed XML file, the utility generates an XSD that can be used to validate that XML file. You can also refine the XSD generated by providing the tool more wellformed XML files. The download contains the core library, simple command line utility and the source code.



Package is attached