I am having trouble getting an xml import to work in Dev6.

I have a test db with the field "Company", and an xml file (attached) using the xslt file (also attached). I have gone through it, using an xslt that works for a different application and source, but I can't get it to actually import the record.

Any hints or suggestions would be appreciated.

It appears the attachment went missing so I re attached it 09 May 2004

TroubleXML.zip

After some experimentation it appears that the trouble lies with the the first line of the source file, specifically this:

 xmlns="http://www.quask.com/quaskformserver/quaskformdata"  

If I get rid of this then I can make the import work, also changing this line in the xslt:



 

  <COL><DATA><xsl:value-of select="field[10]"/></DATA></COL> 

But I don't understand why the xmlns statement messes things up. (?)

Since this is how I will receive the files via email, does anyone have a suggestion on how to overcome this in an automated fashion?