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 » CSV, TXT to XML and into Excel
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Specifying EDI Delimiters (2)
-> + Defining 'connection string' f... (9)
-> + Help Programatically Convertin... (2)
-> + Using adapter URL in pipeline. (7)
-> + How to enable EDI functionalit... (2)
-> + Unable to open file with '%2F'... (2)
-> + How to create a dependency gra... (2)
-> + If block (2)
-> + Mapping multiple files within ... (7)
-> + StylusStudio vs Altova vs BizT... (4)
-> + Command line execution (7)
-> + CSS and Styling in X15 (2)
-> + Ignores debug breakpoints in X... (5)
-> + 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)
-> + 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)
-> + Associate XML with Schema (3)
-> + JVM not found in stylus studio... (2)
-> + Change newline to Linux (on Wi... (4)
-> + Indent XML Tags only partially... (2)
-> + dealing with invalid character... (2)
-> + Unable to call Webservice thro... (2)
-> + XML to CSV Video create csv te... (5)
-> + Try to test this product, (2)
-> + How to migrate license? (3)
-> - kepp your settings on X15 upda... (1)
-> + No Topic (2)
-> + XSD validation scalability iss... (2)
-> + Installing documentation in ai... (4)
-> + Stylus Studio is currently una... (2)
-> + Change from SS Pro 2011 to SS ... (2)
-> + Problem with pipeline function... (2)
-> + Min and Max Occurs for Choices... (2)
-> + XSLT without Preview window ou... (3)
-> + How to achieve this transforma... (2)
-> + Licence Authentication Failed (2)
-> - using Oracle V2 for validation... (1)
-> + Steps needed to execute standa... (2)
-> + xsi:noNamespaceSchemaLocation ... (8)
-> + Using Saxon 9.4 and integrated... (4)
-> + "net XML Parser (5)
-> + How to undo in Stylus Studio X... (2)
-> + .RENAME section not loaded cor... (3)
-> + Stylus StudioŽ X14 Release 2 X... (2)
-> + The JVM initialization failed ... (2)
-> + XML schema to XML does not wor... (4)
-> + missing ExtraLines (3)
-> + EDI validation tool (2)
-> + Registering Custom Tool from c... (5)
-> + Setting Default XML Validation... (2)
-> + Project Directory in Custom Do... (3)
-> + Problem with Saxon 9.4.0.4 AVT... (5)
-> + XML To HL7 (3)
-> + Siblings not repeating when mi... (7)
-> + Nesting of records from fixed ... (5)
-> + Licensing (3)
-> + CSV set up to support predefin... (10)
-> + Scripting conversion (2)
-> + Edi/Euritmo automatic conversi... (4)
-> + Have new stylesheet automatica... (3)
-> + Text file to CSV to xml (9)
-> + EDIFACT to XML (4)
-> + About Stylus Studio... dialog ... (5)
-> + Set Stylus as default editor f... (3)
-> + CSV to XML (11)
-> + Indent XML tags no longer work... (9)
-> + XSL code completion moe like o... (3)
-> + xsl:fo - unable to use any fon... (5)
-> + Bug when calling a ms script f... (13)
-> - url schema (1)
-> + Quickbooks invoice to XML (4)
-> + X14 locks up, Unresponsive (4)
-> + Fields missing from middle of ... (2)
-> + Cannot install trial (2)
-> + Text File with Page breaks - H... (8)
-> + Complex transactional CSV mapp... (2)
-> + XML Report (2)
-> - Create an XML feed for videos (1)
-> + word doc (2)
-> + Saving to a UNC path (7)
-> + sharing violation (3)
-> + Convert XML to XML (6)
-- Previous [181-200] [201-220] [221-240] 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
Tim KehringSubject: CSV, TXT to XML and into Excel
Author: Tim Kehring
Date: 27 Oct 2005 03:13 PM
I'm new to XML and Stylus Studio. (Just what you wanted to hear). I'm trying to solve a problem we have with data from different analytical instruments. Most formats are csv, txt, xls, and doc. We want to convert all file types to xml and then map data files to Excel for formatting and calculations. Attached are some example files


Documentxmltest.txt
example txt

Unknown1.25mg_m3DMMP100mg_m3TEPinCHCl3_1.txt
another txt

UnknownC110170_1.csv
csv example
Postnext
(Deleted User) Subject: CSV, TXT to XML and into Excel
Author: (Deleted User)
Date: 27 Oct 2005 03:40 PM
This is how you can use Stylus Studio:

1. For simple non-xml formats you can use build-in adapters.
Just select your CSV or TXT file in "File Open" dialog box
Check "Convert to XML using adapter" checkbox and click
"Open" button. Select converter you want to use in the
"Select XML Converter" dialog box and click "Ok".

2. If there is no build-in adapter available select
"File"->"New"->"Convert to XML" menu item to create your
own adapter. The only remark is : I am not sure MS Word format
is publicly available. You will probably have to store your
Word documents in some publicly available format.

3. For any relational data sources you can use
"File"->"New"->"DB to XML Data Source" Stylus Studio do not
have native support for Excel, but if you have Excel ODBC data
source you will be able to use Excel.

4. All your XML files will probably have to be converted/merged
using XSLT or XQuery. You'll have to write proper XSLT or
XQuery to do this job.

5. The results can be saved into Excel using DB to XML data
source linked to ODBC Excel data source. Look at the step (3).


6. The process can be aotomated using Stylus Java API. This API is
available only if you have ENTERPRICE edition of Stylus Studio.
You can find example of it's usage under Examples/Adapters/*
(demo.java, several data files and adapters and demo.bat
to build and run it).

Hope this will help
Postnext
Tim KehringSubject: CSV, TXT to XML and into Excel
Author: Tim Kehring
Date: 28 Oct 2005 08:40 AM
Can we take these one at a time. I get number 1 and have converted a csv file to xml. What I want to do now it get the schema for this converted csv file mapped into Excel. I understand the basics of creating an xsl file. My understanding is I would be mapping the converted csv file to another file (target), but in my case the target file does not exist. So I followed the instructions on adding a root element and child elements for my target file and created links berwenn the source and taget document and saved the xsl file.

Assuming all of this is correct, what do I do next to map the the data into Excel?
Posttop
(Deleted User) Subject: CSV, TXT to XML and into Excel
Author: (Deleted User)
Date: 28 Oct 2005 02:54 PM
There is no need to create target file for mapping.
It is ok just to have destination schema (.xsd) file.

Do you know that you can open CSV or tab-separated file directly
in Excel? If there is no need to create .xls file, just to be able
to open results in Excel propably you can consider writing transformation into CSV or tab-separated file ...
   
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.