Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2182

Issues with Excel import

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.5
    • Fix Version/s: 8.5
    • Component/s: Import/Export
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      The excel ddl is attached. You can just use the DDL importer to reproduce the namespace issue.

      Show
      The excel ddl is attached. You can just use the DDL importer to reproduce the namespace issue.

      Description

      See comment on this community thread -
      https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable

      There are a couple of issues with this scenario in Designer:
      1)

      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)
      

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  mdrillin Mark Drilling
                  Reporter:
                  mdrillin Mark Drilling
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: