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

teiid designer fails to import excel file

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • None
    • 11.0.1
    • Import/Export
    • None
    • Hide

      file -> import -> teiid connection >> source model
      create new datasource
      driver: file
      location: folder of excel file /home/mechevar/git/jdv-test/assets/excel

      next
      select excel translator

      Data Row number: 2
      Excel file: colors.xlsx
      Header Row number: 1

      next, gave file name, did not uncheck any boxes

      ddl in prompt:
      SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;

      CREATE FOREIGN TABLE Sheet1 (
      ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
      id double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
      color string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
      CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
      ) OPTIONS (NAMEINSOURCE 'Sheet1', "teiid_excel:FILE" 'colors.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');

      afterwards set length property to 255 for color column

      attempt to preview data:

      org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 excel_ds: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID

      Show
      file -> import -> teiid connection >> source model create new datasource driver: file location: folder of excel file /home/mechevar/git/jdv-test/assets/excel next select excel translator Data Row number: 2 Excel file: colors.xlsx Header Row number: 1 next, gave file name, did not uncheck any boxes ddl in prompt: SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel; CREATE FOREIGN TABLE Sheet1 ( ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), id double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), color string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), CONSTRAINT PK0 PRIMARY KEY(ROW_ID) ) OPTIONS (NAMEINSOURCE 'Sheet1', "teiid_excel:FILE" 'colors.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); afterwards set length property to 255 for color column attempt to preview data: org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 excel_ds: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID

      After importing an excel file, attempting to preview the data results in the following error:

      Connector worker process failed for atomic-request=9241FCRcB/yA.0.0.1: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID

        1. colors.xlsx
          5 kB

            blafond Barry LaFond
            mechevarria Michael Echevarria (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: