]
Ramesh Reddy commented on TEIIDDES-2182:
----------------------------------------
Yep, that is the intent of TEIID-2972 to fix it.
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
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.