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
Donald NorrisSubject: Convert .CSV file to XML
Author: Donald Norris
Date: 26 Sep 2006 02:30 AM
Originally Posted: 26 Sep 2006 02:31 AM
SS2007 does not seem to know how to handle if a data record in a .CSV file is empty. I use a tab(09) to separate fields. If a data record has 2 tabs together SS2007 does not correctly intrepret this as an empty field. As a result all fields after this are off by one.

Thanks, Don

Postnext
Tony LavinioSubject: Convert .CSV file to XML
Author: Tony Lavinio
Date: 28 Sep 2006 01:46 AM
Make sure the setting for 'collapse consecutive delimiters' is
set to 'no'.

Otherwise, if you email a test case to stylus-field-report@progress.com
or attach it to a message here we'll take a look.

Postnext
Donald NorrisSubject: Convert .CSV file to XML
Author: Donald Norris
Date: 28 Sep 2006 09:52 AM
Where exactly is that parameter?

Postnext
Tony LavinioSubject: Convert .CSV file to XML
Author: Tony Lavinio
Date: 29 Sep 2006 12:24 AM
Are you using Convert-to-XML, or are you using the
File|Open adapter:CSV?filename URL mechanism?

Postnext
Donald NorrisSubject: Convert .CSV file to XML
Author: Donald Norris
Date: 29 Sep 2006 11:02 AM
I am using Convert to XML.

Posttop
Tony LavinioSubject: Convert .CSV file to XML
Author: Tony Lavinio
Date: 29 Sep 2006 11:44 PM
Find the property under Region Type called
"Collapse Consecutive Delimiters" and make
sure it is set to 'false'.

If that doesn't help, can you send a copy of
the .conv file and the source file to
stylus-field-report (at) progress.com, and we'll
take a look at it?

 
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.