[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1059) RFE for Teiid Designer - add a new importer similar to the Text File importer but for XML Documents
[
https://issues.jboss.org/browse/TEIIDDES-1059?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1059:
----------------------------------------
For the attached medsamp2001.xml file the following SQL should be generated if
"/MedlineCitationSet/MedlineCitation" is entered as the XQuery expression and
pmid, journal and title columns are defined with corresponding PATH values
SELECT
title.pmid AS pmid, title.journal AS journal, title.title AS title
FROM
(EXEC getMeds.getTextFiles('medsamp2011.xml')) AS f,
XMLTABLE('/MedlineCitationSet/MedlineCitation' PASSING
XMLPARSE(DOCUMENT f.file)
COLUMNS pmid biginteger PATH 'PMID', journal string PATH
'Article/Journal/Title', title string PATH 'Article/ArticleTitle') AS
title
RFE for Teiid Designer - add a new importer similar to the Text File
importer but for XML Documents
---------------------------------------------------------------------------------------------------
Key: TEIIDDES-1059
URL: https://issues.jboss.org/browse/TEIIDDES-1059
Project: Teiid Designer
Issue Type: Sub-task
Components: Import/Export
Affects Versions: 7.5
Reporter: Debbie Steigner
Assignee: Barry LaFond
Fix For: 7.6
Attachments: employee_info.xml, medsamp2011.xml,
teiid-flat-file-source-target-page.png, teiid-flat-file-type-selection-page.png,
teiid-xml-data-file-import-settings.png, teiid-xml-data-file-import-source-page.png
Can an Importer similar to the text file importer be added to Teiid Designer. One that
would produce the same results as if it was manually done.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira