XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + How to add page number in to v... (2)
-> + XSL Grouping (7)
-> + Repeat images using FOR EACH l... (7)
-> + How to get File name (2)
-> + image and text on the same lin... (2)
-> + Create XSLT stylesheets for us... (2)
-> + Merge Multiple Files While Che... (2)
-> + xslt 3 level or multi level gr... (6)
-> + How to create xsl which will c... (2)
-> + xsl:variable and Result Tree F... (7)
-> - XSL-FO fo:table continued from... (1)
-> + XSLT Java issue (2)
-> + problem with hyperlink (4)
-> + substring-after function probl... (4)
-> + Xalan Processing (3)
-> + Memory utilization high with m... (2)
-> + check all parent node groups s... (2)
-> - CSV DOC to XML CONVERSION (11)
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> ->CSV DOC to XML CONVERSION
-> + XSLT: Ordered List (based on r... (4)
-> + XSLT Mapping - Issue (4)
-> + XSL following-sibling, how to ... (5)
-> + need xslt elements help (2)
-> + Dynamic generation of URL in X... (2)
-> + List Created from Section Navi... (2)
-> + xslt elements help (2)
-> + Map field if source is not nul... (3)
-> + XSLT group and sort whith gene... (4)
-> + Nested XML value (2)
-> + Specifying condition with coun... (4)
-> + xsl:function using found in er... (4)
-> + How to remove an unwanted spac... (2)
-> + Question about variable substi... (2)
-> + XSL for Comparing nodes and di... (4)
-> + External lookup list (8)
-> + XSL HTML output now needs to b... (2)
-> + Adding a new sub element to th... (4)
-> + How do I get rid of 'Tip' node... (9)
-> + Trying to dynamically create n... (2)
-> + Display XML link, using XSLT a... (9)
-> + calling templates based on ord... (2)
-> + How to add internal links usin... (4)
-> + How to call user defined java ... (3)
-> + XSLT and WebApps past and futu... (3)
-> + passing condition through java... (3)
-> + Apllying a template from withi... (4)
-> + Getting xsl element in javascr... (3)
-> + The document() function inside... (3)
-> + Footnote text move to para (2)
-> + XSL: multiple element come to ... (3)
-> + How to use following-sibling &... (2)
-> + How to use FOP 0.95 with Stylu... (4)
-> + Error during creating PDF from... (2)
-> + Help creating a comma delimite... (4)
-> + Selective Add using XSLT recur... (3)
-> + Help: convert without parent e... (2)
-> - Correct my substring function ... (1)
-> + Old xsl into reports (4)
-> + How to save xslt converted fil... (3)
-> + How to find non tagging text? (5)
-> + Help: Hex entity to Character... (6)
-> + EDI QUOTES MESSAGE NEED TO REP... (2)
-> + How to convert in multi level ... (4)
-> + Need some help with a styleshe... (3)
-> - Conditional Formattinf Formula... (1)
-> + Creating HTML Unordered LIsts.... (2)
-> + xslt params uknown number of i... (2)
-> + How to use fonts other than ba... (2)
-> - Converting existing HTML into ... (1)
-> + Help to tune up this XSLT (2)
-> + XSLT - is only converting the ... (2)
-> + XSLT Editor tab (4)
-> + Convert multiple files from XM... (2)
-> + how to use in select expressi... (2)
-> + Help needed in XSL transformat... (2)
-> + How to add a string with math ... (5)
-> + How to add a string with math ... (6)
-> - br element (1)
-> + Stylesheet directed terminatio... (2)
-> + Who can help me whit sum funct... (2)
-> + XSLT Works in Stylus Studio, n... (3)
-> - Filter by Attribute (1)
-> + Display x number of items whic... (6)
-> + MultiColumn Reporting (3)
-> + cant get namespace declaration... (3)
-> + Performance xsl:for each and n... (3)
-> + How to assign value to a XSLT ... (3)
-> + Select element value based on ... (2)
-> + Version 10 of Saxon? (8)
-> + How to get the value of a node... (5)
-> + Display Xpath using (4)
-> + XSLT to report (2)
-> + xslt help for a noobie (2)
-> + XSL-FO XML to PDF with XSLT (3)
-> + Using XSLT to transform XML to... (4)
-> + XSLT to sort a list alphabetic... (4)
-> + How to Get Colum Values based ... (2)
-> + non persisting predicate filte... (5)
-> + HTML to XSLT (2)
-> + extra carriage returns in "csv... (2)
-> + extra carriage returns in "csv... (3)
-- Previous [301-320] [321-340] [341-360] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
George PeterSubject: CSV DOC to XML CONVERSION
Author: George Peter
Date: 01 Jul 2009 09:53 AM
Hi I am now testing the trial version and I am trying to convert a .doc file into the standard Medline XML (pubmed). Is it possible to generate the xml automatically? Also, how can I map a csv to the standart pubmed xml?


EXAMPLE
I need to generate something like this:

<ref-list>
<ref id="R1"><label>1</label><nlm-citation citation-type="journal"><person-group person-group-type="author"><name><surname>Oosterlinck
</surname><given-names>O</given-names></name><name><surname>van der Meijden</surname><given-names>A</given-names></name></person-group>
<source>Guidelines on TaT1 (Non-muscle invasive) Bladder Cancer. European Association of Urology Guidelines</source><year>2007</year><fpage>1</fpage>
<lpage>17</lpage></nlm-citation></ref> </ref-list>

Postnext
(Deleted User) Subject: CSV DOC to XML CONVERSION
Author: (Deleted User)
Date: 07 Jul 2009 04:59 AM
Hi George,
usually when converting from CSV to XML you use the XML Converter functionality of Stylus Studio, then design an XSLT stylesheet using Mapper to build the desired output structure.
For instance, create a new XSLT stylesheet, go to the Mapper tab, click on the "Add source document" button, select the CSV file in the Open File Dialog, check the "Open with XML Converter" check box and press OK; in the following dialog select the Comma Separated Values entry on the left and press OK.
In Mapper click on the "Set Target Document" button and select either the PubMed schema or an XML instance of such a schema.
Now you are ready to connect the element on the left schema to the ones on the right.

If the CSV data is stored inside a Word document, you will have to extract it to a separate file, e.g. by running another XSLT stylesheet against an XML version of the document

Hope this helps,
Alberto

Postnext
George PeterSubject: CSV DOC to XML CONVERSION
Author: George Peter
Date: 08 Jul 2009 06:36 AM
Hi Alberto

Thank you very munch for your feed back. I did everything you suggested and now I have the desired structure. The question is now how can I actually import the values from the csv over this structure in order to generate the complete xml with values.

Postnext
(Deleted User) Subject: CSV DOC to XML CONVERSION
Author: (Deleted User)
Date: 08 Jul 2009 08:41 AM
Hi George,
could you attach an example of the data, and what you wrote? I don't understand what you mean by "importing the values from csv over this structure".

Alberto

Postnext
George PeterSubject: CSV DOC to XML CONVERSION
Author: George Peter
Date: 10 Jul 2009 06:16 AM
Hi Alberto,
Sorry for not beeing so clear the first time
I need a csv like the one I attached to go into this kind of structure. It doesn't need to be a csv it can be also a flat file (.txt or .doc).



<ref-list>
<ref id="R1"><label>1</label><nlm-citation citation-type="journal"><person-group person-group-type="author"><name><surname>Oosterlinck
</surname><given-names>O</given-names></name><name><surname>van der Meijden</surname><given-names>A</given-names></name></person-group>
<source>Guidelines on TaT1 (Non-muscle invasive) Bladder Cancer. European Association of Urology Guidelines</source><year>2007</year><fpage>1</fpage>
<lpage>17</lpage></nlm-citation></ref>
<ref id="R2"><label>2</label><nlm-citation citation-type="journal"><person-group person-group-type="author"><name><surname>Loidl</surname><given-names>
W</given-names></name><name><surname>Schmidbauer</surname><given-names>J</given-names></name><name><surname>Susani</surname><given-names>M</given-names>
</name></person-group><article-title>Flexible Cystoscopy assisted by Hexaminolevulinate Induced Fluorescence: A New Approach for Bladder Cancer Detection
and Surveillance?</article-title><source>Eur Urol</source><year>2005</year><volume>47</volume><fpage>323</fpage><lpage>326</lpage></nlm-citation></ref>
<ref-list>


DocumentBook2.csv


Document2.doc
this is how we recieve the references

Postnext
(Deleted User) Subject: CSV DOC to XML CONVERSION
Author: (Deleted User)
Date: 10 Jul 2009 06:50 AM
Hi George,
in the attached picture you can see how I mapped the CSV structure to the XML structure you provided. To run them, just place the other files in the same directory and run the stylesheet.

Hope this helps,
Alberto


Imagemapper(2).JPG
Screenshot of XSLT Mapper

Unknownref-list.xsl
XSLT stylesheet

Unknownref-list.xml
XML structure

UnknownBook2(1).csv
CSV source

Postnext
George PeterSubject: CSV DOC to XML CONVERSION
Author: George Peter
Date: 10 Jul 2009 09:40 AM
Hi Alberto,

Thank you so much. This is almost what i needed. I think my problem was that the csv file was not in the same folder as the xsl and the xml.

Two more questions please:

1. How can we make the tag <ref id="1"> </ref> auto increment for all the iterations?
i.e. <ref id="1"> </ref>
<ref id="2"> </ref> and so on
2. How can we write automatically inside a tag?
i.e <nlm-citation citation-type="journal"> </nlm-citation> - this can be wither journal, either book
<person-group person-group-type="author"> </person-group> - this is unchangeble


Thank you
George

Postnext
(Deleted User) Subject: CSV DOC to XML CONVERSION
Author: (Deleted User)
Date: 10 Jul 2009 09:55 AM
Hi George,
to specify a fixed value for an element, you right click in the target schema node and select Set Text Value.
For the "id" attribute of the "ref" element you should enter {position()} so that the current row number is entered; for "person-group-type" you enter author. For the "citation-type", you will have to come up with some code to decide whether the issue is a journal or a book...

Alberto

Postnext
George PeterSubject: CSV DOC to XML CONVERSION
Author: George Peter
Date: 10 Jul 2009 10:49 AM
Hi Alberto
I took your advice but it does not write inside the begining tag
i.e <ref id="1"> . It writes between the tags i.e: <ref> aaaa</ref>.
Is there something I am missing?

10x
George

Postnext
(Deleted User) Subject: CSV DOC to XML CONVERSION
Author: (Deleted User)
Date: 10 Jul 2009 12:13 PM
Hi George,
you must have invoked the Set Text Value on the "ref" element instead of its "id" attribute.

Alberto

Posttop
George PeterSubject: CSV DOC to XML CONVERSION
Author: George Peter
Date: 13 Jul 2009 08:31 AM
Hi Alberto,
Thank you so much. You were right . I did not have an id attribute. Now it is working perfect. Once again thank you so much for all the help.

Best regards,
George

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.