[
https://issues.jboss.org/browse/TEIIDDES-2182?page=com.atlassian.jira.plu...
]
Ramesh Reddy commented on TEIIDDES-2182:
----------------------------------------
Where is FILE coming from? What I am saying is if DDL OPTION used a namespace and it is
not defined in the DDL that is an error. It should have been. When the namespace
definition is defined, you can match up designer side with the name you have configured in
the MED, so the URI needs to match in this case
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.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)