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 » XSLT Help and Discussion » converting flat file to xml via xslt?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Remove leading Zeros from a st... (4)
-> + how to parse a html element fo... (2)
-> + Add namespaces to target messa... (2)
-> + XSLT Transformation - insertin... (3)
-> + Convert binary xml (9)
-> + XSLT Transformation (4)
-> + Generating hyperlinks (3)
-> + XSLT to PDF problem (with JAVA... (2)
-> + how to add onclick_ with try/c... (2)
-> + Keep table in one page. xsl-fo... (4)
-> + Cannot find a matching 2-argum... (3)
-> + Creating one string from a sub... (2)
-> + XSLT: Traversing XML twice for... (6)
-> + Copy element without namespace... (5)
-> + Create dynamic elemant name (2)
-> + XSLT: Traversing XML twice for... (3)
-> + Problem including Javascript (2)
-> + Looping through attributes (4)
-> + Transform values into elements... (4)
-> + Problem with deep node copy an... (2)
-> + Comparing Dates With ASP.NET 2... (3)
-> + Converting tree structure to h... (4)
-> + Attributes to element transfor... (2)
-> + XSLT transformation (2)
-> + XSLT transformation (5)
-> + xsl:character-map not working (2)
-> + Removing duplicates entries. (2)
-> + Image issues. (2)
-> + xsl transformation (4)
-> + XSL Question (5)
-> + how to insert xml file as an n... (2)
-> + Document Function (2)
-> + convert seconds to hh:mm:ss (5)
-> + how to remove attribute while ... (3)
-> + XSL-FO question (2)
-> + EDI 997 creation. (7)
-> + Line break within a tag in XML... (2)
-> + Contact Help Needed (2)
-> + ACK 997 (2)
-> + XSLT to output XML( which conf... (11)
-> + Retrieving all nodes where a c... (6)
-> + Verifying XML and XSD within X... (4)
-> + How to validate date format in... (3)
-> + XSLT question (2)
-> + Muenchian grouping (2)
-> + How to remove specific text en... (8)
-> + If Else Condition along with L... (2)
-> + SAXON Problem (2)
-> + comapring global variable valu... (2)
-> + copying the value of xsl in va... (2)
-> + Urgent:XSLT element value sel... (2)
-> + Ignoring first element using f... (2)
-> + EDI X12 to XML (4)
-> + XSLT FOR-EACH HELP (2)
-> + Sorting Help Needed (3)
-> + XSLT help with linking (2)
-> + selecting data into node set b... (2)
-> + Watch and Variable in Debug no... (4)
-> + Transforming XML to XML - grou... (2)
-> + Saxon 9.0 B support in debug m... (2)
-> + Repeating element question (2)
-> + Newly Purchased Version Not La... (2)
-> + xsl:include not finding file (5)
-> + JAXP and XSLT 2.0 / XPATH 2.0 (2)
-> + ASP:DropDownList trigger in Xs... (2)
-> + Auto-Skip empty values (2)
-> + retrieving a javascript functi... (2)
-> + need help (2)
-> + html tag ignored (2)
-> + Quick reply needed (8)
-> + xslt to remove namespaces but ... (2)
-> - Using a WSDL definition in an ... (1)
-> + XSL logic issue for simple inp... (6)
-> + Regarding XML namespace prefix... (4)
-> + Mapper reoganizes itself. (8)
-> + XSL Substring Removal (2)
-> + Regarding XSLT logic for a sim... (3)
-> + XSLT Transform documentation (2)
-> + XSLT stack trace in case of er... (3)
-> + No New Line (2)
-> - No New Line (1)
-> + howto loop through a sequence (2)
-> + xml and xsl and whitespace in... (2)
-> + XSL Date formatting (4)
-> + XSL to XSL Mapping using custo... (4)
-> + flat xml to nested xml comvers... (4)
-> + Including schema in scenario (2)
-> + DTDs and traversing (2)
-> + Help with transformation (2)
-> + Problem running XSLT against X... (2)
-> + Carriage return in the output (5)
-> + Generating XSLT to match a sch... (3)
-> + WYSIWYG editor (2)
-> + Grouping without For-Each (3)
-> + output XML using XSLT (8)
-> + Help configuring Xalan-j proce... (8)
-> + Convert Existing HTML pages to... (2)
-> + Generating Transformation - XS... (4)
-> + DOCTYPE public and system info... (2)
-> + Using EXSLT str:tokenize funct... (5)
-- Previous [661-680] [681-700] [701-720] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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).

   
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.