XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » How to add a value when converting a csv file to xml
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Cursor dissapearing in Text vi... (5)
-> + compile error xquery java styl... (3)
-> + Stylus Studio Setup: Applicati... (10)
-> + Stylus StudioX15 Crashing whe... (4)
-> + Upgrade Stylus 14 to 15 (2)
-> + ACE Broker Download v2.5 (2)
-> + Help creating custom convertor (7)
-> + Problem saving Documentation (5)
-> + Registry keys for Stylus x15 (8)
-> - How to add a value when conver... (10)
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> ->How to add a value when c...
-> + Stylus Studio Pro & Ent X15r1 ... (2)
-> + You need to install Java 2 SDK... (4)
-> - How to disable automatic and m... (1)
-> + Does Stylus Studio / DataDirec... (4)
-> + Stylus Studio fails with 'The ... (12)
-> + Struzzo.exe side by side confi... (7)
-> + unable to use converter (5)
-> + How to enable XSD 1.1 for Saxo... (3)
-> + XSD v.1.1 validation and Xerce... (8)
-> + FATAL ERROR: unsupported XML v... (2)
-> + Java Runtime Environment boot ... (2)
-- Previous [241-260] [261-280] [281-300] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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>

   
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.