I am trying to import a local xml file (see below) from a SharePoint 2010 list. When I select a node (m:property) as root, I got the "No columns defined error". It does not allow me to add d:name. Does anyone know what this means and if there is any workaround? I am not familiar with xml. It seems m: and d: means name space. Thanks

I have seen that error too while working on demo couple weeks back, I failed to capture the steps then. I can not seem to recreate it with JBDS 7.1.1.GA + Designer 8.3.2 or latest Designer with your XML now. Can you go over the steps exactly that can recreate issue? Also which version of Windows and JDK you are running under?

This importer is designed to help construct a viable SQL statement containing an XMLTABLE() function call that will return relational table data. The requirement is that at least ONE column must be defined/mapped to an XML/schema element. The validation kicks in once you start editing, so setting the ROOT will end up with an ERROR since no columns are defined.

Simple double click one or more elements (i.e. d:Photo, d:Name, d:Title, etc...) will create corresponding Column entries and they will show up in the Generated SQL Statement.

Barry, what I encountered was, the XML was there but, you could not select element, or right click on the element root to set as root. I know this does not happen all the time, but in certain scenario it does happen. Next time I am sure to capture the details