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 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Andreas PolzSubject: converting flat file to xml via xslt?
Author: Andreas Polz
Date: 11 Oct 2001 08:17 AM
Hello eŽbody!

for a specific project i would like to use xslt to import data from flat files (not html but delimited or fixed length records) to xml. do you see a chance here?

furthermore the customer would like to be able to edit/create the specific xslt templates by using a wizard - i see that stylus can do that for html input files, but is that also possible for flat files?

tnx in advance
Andreas Polz

Postnext
Minollo I.Subject: Re: converting flat file to xml via xslt?
Author: Minollo I.
Date: 11 Oct 2001 09:44 AM
At the best of my knowledge there is no "standard" to convert a flat file
into XML; while there is (XHTML) for HTML. That's why Stylus Studio has a
wizard to convert HTML into XML.

That said, another thing that I would try if I were you is the "XML from
ADO" wizard in Stylus; I'm pretty sure that there is a way to convince ADO
to use a flat file as a "tabular" source of data; once that's done, ADO
will convert it to XML for you.

Hope this helps,
Minollo

Postnext
(Deleted User) Subject: Re: converting flat file to xml via xslt?
Author: (Deleted User)
Date: 11 Oct 2001 09:59 AM
At 09.51 11/10/2001 -0400, you wrote:
>From: Carlo Innocenti
>
>At the best of my knowledge there is no "standard" to convert a flat file
>into XML; while there is (XHTML) for HTML. That's why Stylus Studio has a
>wizard to convert HTML into XML.
>
>That said, another thing that I would try if I were you is the "XML from
>ADO" wizard in Stylus; I'm pretty sure that there is a way to convince ADO
>to use a flat file as a "tabular" source of data; once that's done, ADO
>will convert it to XML for you.

Another possibility is to use the XConnect package that is available when
you buy the entire XML suite (XIS 3.5), that has GUI tools specifically
designed to convert data (flat files, Excel spreadsheets, COBOL data files,
etc..) into XML.

Alberto

Postnext
Christopher ParkersonSubject: RE: converting flat file to xml via xslt?
Author: Christopher Parkerson
Date: 11 Oct 2001 10:46 AM
We actually license our XConnects technology from a company called Data
Junction. You can actually download a fully-functional 30-day
evaluation copy from their website at http://www.datajunction.com. It
handles over 100 different formats and is relatively inexpensive (less
than $1000) for a single-user license.

Hope this helps,
Chris

---------------------------------------
Chris Parkerson
Product Manager
eXcelon Corporation
Burlington, MA
(781) 674-5393
http://www.exceloncorp.com
---------------------------------------


-----Original Message-----
From: stylus-studio-xslt Listmanager [mailto:listmanager]
Sent: Thursday, October 11, 2001 10:06 AM
To: Recipients of 'stylus-studio-xslt' suppressed
Subject: Re: converting flat file to xml via xslt?

From: Alberto Massari

At 09.51 11/10/2001 -0400, you wrote:
>From: Carlo Innocenti
>
>At the best of my knowledge there is no "standard" to convert a flat
file
>into XML; while there is (XHTML) for HTML. That's why Stylus Studio has
a
>wizard to convert HTML into XML.
>
>That said, another thing that I would try if I were you is the "XML
from
>ADO" wizard in Stylus; I'm pretty sure that there is a way to convince
ADO
>to use a flat file as a "tabular" source of data; once that's done, ADO
>will convert it to XML for you.

Another possibility is to use the XConnect package that is available
when
you buy the entire XML suite (XIS 3.5), that has GUI tools specifically
designed to convert data (flat files, Excel spreadsheets, COBOL data
files,
etc..) into XML.

Alberto



To reply: mailto:stylus-studio-xslt.3910@edn.exceloncorp.com
To start a new topic: mailto:stylus-studio-xslt@edn.exceloncorp.com
To login: http://edn.exceloncorp.com/~SSDN

Postnext
Andreas PolzSubject: RE: converting flat file to xml via xslt?
Author: Andreas Polz
Date: 11 Oct 2001 01:41 PM
thanx alot to all, this really helped me forward.

Andreas Polz
Infonova Server Technology

Posttop
Albert WallaceSubject: converting flat file to xml via xslt?
Author: Albert Wallace
Date: 01 Feb 2002 12:16 PM
I have been doing EDI file conversions/transformations from flat file to xml for the last couple of months.
I have found the process to be three steps using three different tools:
1. Data junction content extractor tool is used to produce an 'extract' of the flat file that you want to convert. This produces a .djp file.
2. Next, try using the Data junction map designer tool to map your extract file (produced from 1 above). This process produces an XML extract of the map and a spec file with an extension of .djs.
3. Finally, using Stylus Studio you can map your XML from step 2 to your final XML.

I have had success with this technique for flat-file to XML and vice versa (although the technique is slightly easier and has fewer steps).

 
Topic Page 1 2 3 4 5 6 7 8 9 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.