[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2182) Issues with Excel import

Issues with Excel import ------------------------ Key: TEIIDDES-2182 URL: https://issues.jboss.org/browse/TEIIDDES-2182 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 8.5 Reporter: Mark Drilling Assignee: Mark Drilling Fix For: 8.5, 8.3.4 Attachments: excelSheet.ddl See comment on this community thread - https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable There are a couple of issues with this scenario in Designer: 1) {code} org.eclipse.core.runtime.CoreException: An exception occurred while performing an operation at org.teiid.designer.ui.util.ErrorHandler.toCoreException(ErrorHandler.java:68) at org.teiid.designer.ui.util.ErrorHandler.toExceptionDialog(ErrorHandler.java:115) at org.teiid.designer.teiidimporter.ui.wizard.TeiidImportManager.saveUsingDdlDiffReport(TeiidImportManager.java:818) at org.teiid.designer.teiidimporter.ui.wizard.TeiidImportWizard.finish(TeiidImportWizard.java:197) at org.teiid.designer.ui.common.wizard.AbstractWizard.performFinish(AbstractWizard.java:356) at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827) at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432) {code} This is a bug with the array init on line 791 of TeiidImportManager 2) The "CELL_NUMBER" issue is due to Designer not processing the extension properties for excel properly. The incoming namespace on the DDL options (teiid_excel) does not match it's MED namespace in Designer (excel). Need to resolve this disconnect.