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 » Convert tab delimited to XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Unresponsive - Custom XML Conv... (2)
-> - Need Help defining Flat File w... (1)
-> + XML to Database (6)
-> + XSD path when associating to a... (3)
-> - Auto EDI File Translation (1)
-> + Need help parsing EDI and crea... (2)
-> + Bug in generating Xml from Dtd (7)
-> + Stylus Studio 15, install erro... (4)
-> + How to create UML from XSD (2)
-> + Java configuration (4)
-> + embedding/starting X15 dircet ... (2)
-> + Stylus X15 R2 environment crip... (5)
-> + Output Method TEXT does not wo... (6)
-> + CONV loses its format on re-op... (5)
-> - Trouble Converting 846 EDI Fil... (1)
-> + XML Catalog support - DITA (2)
-> + non-persistent VDI, App-V Lice... (2)
-> + Can we READ XLS file and Conve... (8)
-> + Mapping XML to XML (3)
-> + SS X15 - Getting Error with 45... (2)
-> + Optimal for DB to XML? (2)
-> + Issues exporting SQL Server ->... (2)
-> + need additinal field in XML (2)
-> + blinking (3)
-> + HELP ANYONE PLEASE (3)
-> + xi:include including include s... (2)
-> + Validating an XML file against... (2)
-> + XML to EDI Telco D.0 field len... (2)
-> + Converting EDIFACT to XML in c... (3)
-> + XSLT Transformation fails with... (4)
-> + StylusStudio X15 R2 java Auto ... (6)
-> + StylusStudio X15 Review - firs... (2)
-> + Stylus Studio X15 stuck on pro... (11)
-> + Error handling in Coverter fil... (2)
-> + RESTful Web Services in Stylus... (3)
-> + How to produce a human-readabl... (3)
-> + EDI 945 to AX (2)
-> + Help x15 failing install (5)
-> + XSD 1.0/1.1 schema validation ... (3)
-> + Java Runtime Environment 8.0 (3)
-> + Web Service Call to Oracle OSM... (2)
-> + Telco EDI to XML output on opt... (12)
-> + Authentication failed (2)
-> + no declaration found for eleme... (2)
-> + Component installation failed (5)
-> - Component installation failed (1)
-> - AUP to expire (1)
-> + Disable Automatic Updates in S... (2)
-> + Windows 7 64 bit compatibility (2)
-> + EDI 8.1 to 10.6 (2)
-> - Conerting EDI 8.1 to EDI 10.6 ... (1)
-> + Debugging with Java built-in p... (3)
-> + Moving Stylus Studio (2)
-> + When using an xsl:import file,... (3)
-> + Generate XSD file from XML fil... (2)
-> + Custom XML Conversion (2)
-> + Create XML from XSD schema fil... (4)
-> + Slimed by Microsoft Word 2010 (6)
-> + XML to EDI (Telco D.0) convers... (3)
-> + XML Pipeline Troubleshooting (10)
-> + Allow negative values in Telco... (7)
-> + Unable to add new arguments to... (2)
-> + Validating XML Document (4)
-> + Debugging with X15 and MSXML p... (2)
-> + Parameter values (5)
-> + Limit on size of schema/instan... (4)
-> + Enterprise 12r1-The decompress... (5)
-> + Lost my copy - how do I renew? (2)
-> + Add Arguments to JVM does not ... (10)
-> + Page-position='last' not inple... (3)
-> + Decode the base 64 encrypted f... (2)
-> + XALAN Processor (4)
-> + How to create an XSD for flat ... (4)
-> + xslt saxon processor failure (3)
-> + Variables window Context path ... (4)
-> + XLS Formatting Objects Preview... (7)
-> + German DTA File (2)
-> + EDI to XML and LX segment (2)
-> - The element with name "F0101Z2... (1)
-> + How to insert the current date... (3)
-> + XSD - XML Sample (4)
-> + XSD to XML (3)
-> + Java extension functions, Xala... (2)
-> + XML with XSD to PDF (7)
-> + mapped network drives not show... (5)
-> + WCF Message size (2)
-> + Re-imaged desktop/laptop lost ... (4)
-> + Relative path in Stylus Studio (2)
-> + & and & in web service cal... (8)
-> + Which JRE do I need now? (3)
-> + Line Delimitted File Conversio... (4)
-> + Generating EDI Data from XML w... (2)
-> + Generating an XML file using C... (2)
-> - Generating an XML file from (1)
-> + output document cannot be pars... (10)
-> + convert RELAX NG to xsd (2)
-> + Intended Use of a .sef File (3)
-> + Skipping invalid records on SQ... (5)
-> + EDI XML Converters Inserting "... (2)
-> + Trying to use EDI to XSD docum... (5)
-- Previous [121-140] [141-160] [161-180] 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
Richard PottsSubject: Convert tab delimited to XML
Author: Richard Potts
Date: 31 Jan 2006 10:39 AM
I've got some data in an Excel file that I wish to convert to xml, so I've been trying to use the Convert to XML tool.

In MS-Excel, I export the data as tab delimited and import into Stylus studio. Result: The post code and telecom fields do not get populated. - (I think this is due to the fact that there some blank fields in the data – I think this may be a bug. Or is there one of the 'properties' settings I need to set for such a situation.?

Not giving up I tried to export the data from Excel in CSV file format. This time Stylus studio seemed to do as I expected, i.e. correctly identified postcode and telecom fields. However some of the fields contain commas within them so this has confused the parser and thinks there is more fields than there actually is.

Without modifying my data, can you suggest a way I can import the data into Stylus studio to maintain the data in the correct fields.

Your help would be much appreciated.

I attach some sample data



System details:

Stylus studio 6 xml professional build (287n)
1.5.0_02-b09 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

Windows 2000
Excel 2000 SP3


Unknowndealers.xls
Original Excel File

Unknowndealers-tab.txt
Dealers tab del file

Unknowndealers-csv.csv
dealers csv file

Unknowndealers-csv.conv
conv file

Unknowndealers-tab.conv
tab conv file
Postnext
Tony LavinioSubject: Convert tab delimited to XML
Author: Tony Lavinio
Date: 31 Jan 2006 12:58 PM
You may use the tab-delimited format.

Open it in Convert-to-XML, and change the following two properties and
you should be pleased with the results:

1. Collapse Consecutive Delimiters: false
2. Element Name Source: From First Row

What is happening is that by default, consecutive delimiters are
removed, but that is messing up your columns. So changing that
property makes things align.

The second property change lets you get the first names right from
your input file.
Postnext
Richard PottsSubject: Convert tab delimited to XML
Author: Richard Potts
Date: 01 Feb 2006 06:24 AM
Originally Posted: 01 Feb 2006 06:25 AM
Hi Tony,

Thanks for the advice but still having problems.

What I'm doing:
1) File | New | Convert to XML
2) I select the file dealers-tab.txt
3) I leave the default settings for 'encoding' and 'general layout'
4) File loads
5) I set 'Element Name Source' property to 'From First Row' - change is immediatley reflected on screen.
6) I set 'Collapse Consecutive Separators' to 'false' - No change on screen detected.

If I then click somewhere else on the file area of the screen 'Collapse Consecutive Separators' automatically changes back to 'true'. ?? - thought this was a file property rather than a field/column property.

So basically struggling in getting 'Collapse Consecutive Separators' to be set to 'false' as you suggested.

User error?

I attach the resulting conv file.



UnknownTony.conv
Postnext
Tony LavinioSubject: Convert tab delimited to XML
Author: Tony Lavinio
Date: 01 Feb 2006 09:16 AM
Try the attached; you're right, for some reason the value didn't
stick in your copy. I tested here, and it works fine. Here is
the fixed .conv file.
If this works okay, we'll see what we can do to figure out why the
value in your copy isn't sticking.


DocumentTony(1).conv
Postnext
Richard PottsSubject: Convert tab delimited to XML
Author: Richard Potts
Date: 02 Feb 2006 04:38 AM
Tony,

Thanks for your help. Your conv file works fine for me.

Postnext
Richard PottsSubject: Convert tab delimited to XML
Author: Richard Potts
Date: 02 Feb 2006 05:59 AM
I spoke too soon. I've now got a new Problem with same converter:

Now that the text is aligned in the correct columns (using your conv file). I modified the conv file so that it adds the tag names I require and changed the fields to attributes.

I also want every field to appear in the output xml even if the field is empty. Hence I've set the "Omit from Output" property to "Never". I run the "Preview Result" and the output appears in the preview window as I expect it. Ie. Empty fields appear.

If I then go to File|Open select my tab delimited file and click the "Convert to XML using adapter", select the conv file I've just made. The empty fields do NOT appear in the output!??

I attach my new conv file.


Unknowndealers.conv
Posttop
Tony LavinioSubject: Convert tab delimited to XML
Author: Tony Lavinio
Date: 03 Feb 2006 12:21 AM
A couple of minor points:

Looking at your data, the input Encoding is windows-1252, not utf-8.
That will make the ß (sharp-S) look right.

Also, the delimiter Pairs should be '"','"' not blank, since Excel
will still wrap fields with embedded commas with double-quotes.

And a slightly bigger one.

You've discovered a bug. The code that emits attributes will never
generate them if they are empty. That will be fixed in our next
release of 2006, the 501i patch. How serious is getting those empty
attributes for you? Can we help with a work-around in the meantime?
   
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.