[teiid-issues] [JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-3599.
---------------------------------
    Fix Version/s: 9.0
                   8.13.2
                       (was: Open To Community)
       Resolution: Done
           Labels: Alpha2  (was: )


The issue only pertains, if the user is using the metadata import feature to read metadata from existing Excel file. With this fix, the user can define a file name pattern instead of absolute name, the translator will select any random Excel file matching the pattern to read metadata from. It will also set the metadata such that the data is read from all the files matching the file pattern.

If you are defining the DDL for the table manually, user already had the choice of specifying the "teiid_excel:FILE" metadata extension property as file pattern to read multiple data files.

Documentation will be at https://teiid.gitbooks.io/documents/content/reference/Microsoft_Excel_Translator.html

> Excel translator and dynamic filenames
> --------------------------------------
>
>                 Key: TEIID-3599
>                 URL: https://issues.jboss.org/browse/TEIID-3599
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Ralph Martin Black
>            Assignee: Ramesh Reddy
>            Priority: Minor
>              Labels: Alpha2
>             Fix For: 9.0, 8.13.2
>
>
> Hi all,
> All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model:
>     ...  
>     <property name="importer.ExcelFileName" value="names.xls"/>  
>     ...  
> Is there any way to specify filenames dynamically at run-time? 
> Best regards
> MB!



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)