Customer is on 8.2.3.17
We want to use the Data Integration module to export data from a custom table.
By using the DW dialogue for the data source and selecting "Dynamicweb Provider", it immediately crashes while (I assume) scanning the tables. The following message appears:
Exception
Message: Unknown column type used: type 'xml' for column 'OpeningstijdenXml' in table 'bdPoiLocation'.
StackTrace: at Dynamicweb.Data.Providers.SqlColumn..ctor(String name, String columnType, Table table, Int32 limit, Boolean isIdentity, Boolean isPrimaryKey) at Dynamicweb.Data.Providers.SqlProvider.GetOriginalSourceSchema() at Dynamicweb.Data.Providers.DynamicwebProvider.GetOriginalSourceSchema() at Dynamicweb.Data.Providers.DynamicwebProvider.GetSchema() at Dynamicweb.Data.Providers.DynamicwebProvider.GetOptions(String name) at Dynamicweb.Extensibility.Editors.DropDownParameterEditor.Render(ConfigurableAddIn AddIn, String Name, Object Value, Hashtable options, String Label) at Dynamicweb.Extensibility.Editors.DropDownParameterEditor.Render(ConfigurableAddIn AddIn, String Name, Object Value, Hashtable options) at Dynamicweb.Extensibility.AddInConfigurator.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at Dynamicweb.Admin.eComBackend.EcomConfigurableAddin_GetParameters.Page_Load(Object sender, EventArgs e)
Source: Dynamicweb.Data.Providers
No innerexception
Trying to ignore this doesn't help, since in the following steps of the dialogue, it crashes again. It seems that this module isn't prepared for XML columns.
We hope that this can be overcome by a workaround of some kind.
We appreciate any suggestion.
Thanks,
Ton