[QTI] Newbie Question

[Harris, B.]

Hi

I've recently joined the list having recently started looking at some QTI based data. A couple of questions if anyone can advise:

1) We tried to use the QTI v2 XSD at http://www.imsglobal.org/xsd/imsqti_v2p0.xsd to create tables in a SQL database using the MS SQLXMLBULKLOAD function. We came across quite a few errors that the SQLXMLBULKLOAD reported - for an example " Schema: relationship expected on 'col'". Is this something that people have come across or should it work (or not work) okay? Is there anything we need to do to the schema to get the SQLXMLBULKLOAD to work? Has anyone managed to create tables of the schema - any pointers as to how?

2) I notice on the http://www.imsglobal.org/question/ page where we downloaded the XSD file from in the 'Version 2.0 -IMS XML Examples and Schemas' section that there are a few xml examples. Does this cover all the 'question' types in the xsd or are there more? Am I right in understanding that the xsd file describes these xml files...and a lot more? Basically, we're trying to deserialise some QTI v2 xml data from a learning environment system (LE) so we can populate another database with it. Our stumbling block is understanding how the xml is structured (which is when we were pointed to the IMS site). We thought about creating tables based upon the XSD (or in a roundabout fashion the xml) so we can deserialise the LE xml. Are we barking up the wrong tree with this. Could anyone provide an easier pointer if there is one? We're very much a newbie at all this so would appreciate some advice.

Many thanks for any advice offered

Kind regards

Bob