Mark Drilling created TEIIDDES-2182:
---------------------------------------
Summary: 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
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.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)