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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
gaston zajdmanSubject: How to add a value when converting a csv file to xml
Author: gaston zajdman
Date: 26 Feb 2013 03:49 PM
Hi, I'm converting a csv file to xml, this file has many solutions, for each solution I need to add at the beginning <statement> and at the end </statement>, below is an example, can someone guide me on how to do this?

<statement>
<statement_type>Symptom</statement_type>
<statement_distribution>External</statement_distribution>
<content_type>HTML with Autolink</content_type>
<summary>mchui061902b - symptom 1</summary>
<detail></detail>
</statement>

Thanks in advance

Postnext
Ivan PedruzziSubject: How to add a value when converting a csv file to xml
Author: Ivan Pedruzzi
Date: 26 Feb 2013 03:56 PM

Which Stylus Studio version are you running?

Can you post a sample of your CSV file?

Ivan Pedruzzi
Stylus Studio Team

Postnext
gaston zajdmanSubject: How to add a value when converting a csv file to xml
Author: gaston zajdman
Date: 26 Feb 2013 04:04 PM
X15


UnknownFiletogenerateXML_STYLUS.csv

Postnext
Ivan PedruzziSubject: How to add a value when converting a csv file to xml
Author: Ivan Pedruzzi
Date: 27 Feb 2013 10:11 AM

- Click File -> Open
- Check "Open using XML Converter"
- Set Property "first" to Yes
- Set Property "row" to statement
- click OK

See screenshot attached.


Ivan Pedruzzi
Stylus Studio Team

Postnext
gaston zajdmanSubject: How to add a value when converting a csv file to xml
Author: gaston zajdman
Date: 27 Feb 2013 10:40 AM
Originally Posted: 27 Feb 2013 10:39 AM
Thanks for the reply but your solution is putting <statement> at the beginning and at the end of the document, I need to have these at the beginning and end of each solution and I have 4 solutions per record, below is an example of what the conversion looks like when I open it in stylus, in my file I have a column for statement at the start and at the end of each solution, the conversion does it but since these columns in my file are blank it alwasy does </statement>, I need to know if it is possible to somehow put <statement> at the beginning of the statement and </statement> at the end of the statement.

<statement/>
<statement_type>Keywords</statement_type>
<statement_distribution>External</statement_distribution>
<content_type>HTML with AutoLinks</content_type>
<summary>Test Keywords1</summary>
<detail/>
<statement/>
<statement/>
<statement_type>Symptom</statement_type>
<statement_distribution>External</statement_distribution>
<content_type>HTML with AutoLinks</content_type>
<summary>.</summary>
<detail>Test Symptom1</detail>
<statement/>

Postnext
Ivan PedruzziSubject: How to add a value when converting a csv file to xml
Author: Ivan Pedruzzi
Date: 27 Feb 2013 11:16 AM

The above solution actually wraps a record (or a line) with the element "statement"

Use the XSLT code attached to split each row in separate statements

Ivan Pedruzzi
Stylus Studio Team


Documentgroup.zip

Postnext
gaston zajdmanSubject: How to add a value when converting a csv file to xml
Author: gaston zajdman
Date: 27 Feb 2013 03:35 PM
again thks a lot for the reply, I'm trying to run your process and I get the attached error, can you take a look at it?


Unknownstyluserror.jpg

Postnext
Ivan PedruzziSubject: How to add a value when converting a csv file to xml
Author: Ivan Pedruzzi
Date: 27 Feb 2013 04:00 PM

It seems like that you have not to set the appropriate Source XML URL in the scenario dialog.

You cannot use a CSV file as input to the stylesheet, you need XML.
You have to use a converter URL which should look like this:

converter:CSV:first=yes:root=statements:row=statement?file:///c:/Users/Gaston/Documents/Consulting/BridgePoint/KB/Group/FiletogenerateXML_STYLUS.csv





Ivan Pedruzzi
Stylus Studio Team

Postnext
gaston zajdmanSubject: How to add a value when converting a csv file to xml
Author: gaston zajdman
Date: 27 Feb 2013 04:37 PM
Thanks a lot now it works!!! here go a couple more questions

my file has a few more fields:
solution_type solution_visibility Title Category

These fields go before all the statements, what needs to be added to your code so that they show up?


Posttop
gaston zajdmanSubject: How to add a value when converting a csv file to xml
Author: gaston zajdman
Date: 27 Feb 2013 05:06 PM
Another question is, is it possible to do two groupings?, if so how do I tell the 'Source XML URL:' to process both?


<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<root>
<xsl:for-each select="flow">
<flow>
<xsl:copy-of select="."/>
<xsl:copy-of select="following-sibling::*[1][local-name()='flow_name']"/>
<xsl:copy-of select="following-sibling::*[2][local-name()='step']"/>
</flow>
</xsl:for-each>
</root>
</xsl:template>
</xsl:stylesheet>

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.