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 » Including row nos while converting flat files to Xml
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Conerting Excel to XML (5)
-> + count the number of 1 appearin... (10)
-> + Import validation errors (2)
-> + Custom Validation Saxon (4)
-> + How Can i Check if else condit... (2)
-> + Stylus Studio 2009 Ent still b... (2)
-> + cannot download SS2009 (2)
-> + Use of import-schema wants sch... (4)
-> + Replacement Install Media/Bits (3)
-> + XML to Flat File (5)
-> + Select one of multiple attribu... (13)
-> + Web Service - SOAP Error (3)
-> + I find a BUG in stylus studio ... (8)
-> + Text to XML conversion issue (2)
-> + Fixed width flat files (3)
-> + Stylus Studio Crashes when val... (3)
-> + XSL Changes doesn't reflect in... (2)
-> + Custom Conversion Definition T... (6)
-> + Support for UK EDI Tradacoms ... (2)
-> + How to find and remove all ins... (2)
-> + XML to cobol Sequential file (2)
-> + Pipe delimited flat file conve... (2)
-> + Cannot Function Block > DataDi... (3)
-> + License Authentication failed (2)
-> + Flat File Conversion (3)
-> + Struzzo.exe sing 50% of CPU (2)
-> + Saxon9 Transformation error ha... (2)
-> + com.ddtek.xquery3.XQQueryExcep... (10)
-> + XML attribute name (2)
-> + JAVA and XML (2)
-> + DB Connection Error (3)
-> + Dicstionaty Librarys for other... (2)
-> + Passing parameters (3)
-> + Xmlconverter does not work (2)
-> + non-printing characters in Fil... (3)
-> - Including row nos while conve... (5)
-> ->Including row nos while ...
-> ->Including row nos while ...
-> ->Including row nos while ...
-> ->Including row nos while ...
-> + Getting Evaluation Copy except... (2)
-> + SS 2008 R2 Bug? (4)
-> + Java Heap Space (2)
-> + generate report from .xsl file... (3)
-> + Can't encode 0x4 in text (3)
-> + Recognize Japanese Characters (2)
-> + converting .xsl to xml using c... (2)
-> - Uninstall doesn't clean up reg... (1)
-> + CDISC (5)
-> - creating database from XML sch... (1)
-> + error: side-by-side configurat... (3)
-> - How to convert pdf into rdf fo... (1)
-> + Apache FOP (5)
-> + XPath Query Editor 'Buggy' (3)
-> - Feature request (1)
-> + XML Convertors (2)
-> + XMLConverters version 3.2.0.0 ... (2)
-> + JVM/stylus studio abort on sav... (3)
-> + using oasis catalog in pipelin... (6)
-> + Another whitespace issue with ... (2)
-> + saxon 9.1.0.2 (2)
-> + xslt change namespace (4)
-> - xslt change namespace (1)
-> + HL7 Conversion (3)
-> + mixed content mapping (2)
-> + HL7 to XML to HL7 (5)
-> + newest version of Saxon SA? (3)
-> + ORM / ORU Seqments (7)
-> + XSLT is causing Java.lang OutO... (3)
-> + Create POJOs from EDI (4)
-> - Embedded message (1)
-> + How to create Documentation fo... (2)
-> + xslt transformation (2)
-> - remove BOM (1)
-> + Changing data as it goes into... (5)
-> + How to (graphically) map one X... (2)
-> + Stylus Studio 2008 Release 2 -... (2)
-> + keyboard shortcuts to switch b... (2)
-> + Help with getting Output XML f... (8)
-> + Document created from schema (2)
-> + XSD Validation error (2)
-> + Set the value of an attribute ... (2)
-> + Saving as XML, Source Data Typ... (2)
-> + Own templates in file/new (4)
-> + Does Stylus Studio support the... (2)
-> - How to transform XML file to T... (1)
-> + Extract XML file from a HTML s... (2)
-> + Crashing, high cpu usage, larg... (6)
-> + Creating an xml document based... (2)
-> + Problem with restriction (2)
-> + EDI Invalid date time error (2)
-> + How to Compose a Web Service C... (5)
-> + Java Complie errors with XML C... (2)
-> + Creating xml file from CSV uss... (4)
-> + XML Converters (6)
-> + schema validation (15)
-> - 9/30 Customer Showcase Webinar... (1)
-> + ETL (2)
-> + xsd:sequence question (3)
-> + contains an invalid path (5)
-> - Custom converter to map flat f... (1)
-> + validating a 4.01 transitional... (2)
-> + Cannot Use Stylus Studio On Mu... (5)
-> + Missing DB to XML option (2)
-- Previous [901-920] [921-940] [941-960] 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
Venkat RaghupatSubject: Including row nos while converting flat files to Xml
Author: Venkat Raghupat
Date: 31 Oct 2008 12:19 PM
Hi,

I am new to Stylus studio and learning its features. I am trying to convert a flat file into Xml. Is there anyway , I can include Rownos that are being displayed into an attribute?
For ex.) <Root>
<Row RowNo = 1>
...
...
</Row>
<Row RowNo=2>
...
...
</Row>
Postnext
Ivan PedruzziSubject: Including row nos while converting flat files to Xml
Author: Ivan Pedruzzi
Date: 03 Nov 2008 04:44 PM

With the built-in CSV converter you can set the option "number" to yes

converter:CSV:first=yes:number=yes?file:///c:/Program Files/DataDirect Integration Suite 2008/XML Converters for Java/examples/one.csv

<table>
<row row="1">
<make column="0">BMW</make>
<model column="1">R1150RS</model>
<year column="2">2004</year>
<mileage column="3">14274</mileage>
</row>
...


Ivan Pedruzzi
Stylus Studio Team
Postnext
Venkat RaghupatSubject: Including row nos while converting flat files to Xml
Author: Venkat Raghupat
Date: 10 Nov 2008 05:13 AM
Thanks.

While it works for built in Converter, I get the following exception with the custom converter:

[DDTek.XmlConverter.ConverterArgumentException] = {"Unable to determine the converter class name from converter:D:\\RVR\\Electronic\\StylusConverters\\BoltonTest.conv:number=yes"}

Is there any way we can overcome this error and get rownumbers for the rows as an attribute.

Regards
Venkat
Postnext
Venkat RaghupatSubject: Including row nos while converting flat files to Xml
Author: Venkat Raghupat
Date: 10 Nov 2008 09:35 AM
Thanks.

While it works for built in Converter, I get the following exception with the custom converter:

[DDTek.XmlConverter.ConverterArgumentException] = {"Unable to determine the converter class name from converter:D:\\RVR\\Electronic\\StylusConverters\\BoltonTest.conv:number=yes"}

Is there any way we can overcome this error and get rownumbers for the rows as an attribute.

Regards
Venkat
Posttop
Tony LavinioSubject: Including row nos while converting flat files to Xml
Author: Tony Lavinio
Date: 10 Nov 2008 09:58 AM
At this point, the only way would be to add the row numbers by
post-processing with XSLT or XQuery.

Since you can use the .conv URI as input to either, it shouldn't
be too difficult...

Hope this helps.
   
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.