[
https://issues.jboss.org/browse/TEIIDDES-2182?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2182:
----------------------------------------
If you look at the attached DDL file which Mark created via the Teiid Importer .... the
DDL contains OPTIONS() which include *teiid_excel:CELL_NUMBER* for columns and
*teiid_excel:FILE* and *teiid_excel:FIRST_DATA_ROW_NUMBER* for the table. There is no
*SET NAMESPACE* statement.
{code}
CREATE FOREIGN TABLE Sheet1 (
ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like',
"teiid_excel:CELL_NUMBER" 'ROW_ID'),
FirstName string OPTIONS (SEARCHABLE 'Unsearchable',
"teiid_excel:CELL_NUMBER" '1'),
LastName string OPTIONS (SEARCHABLE 'Unsearchable',
"teiid_excel:CELL_NUMBER" '2'),
Age double OPTIONS (SEARCHABLE 'Unsearchable',
"teiid_excel:CELL_NUMBER" '3'),
CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
) OPTIONS ("teiid_excel:FILE" 'names.xlsx',
"teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
{code}
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)