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 positional flat file to xml
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + What Pipeline standard do you ... (4)
-> + How can i increase sylus memor... (2)
-> - Tutorial & Tech support needed (1)
-> + Generate HTML Documentation fr... (3)
-> + Use of saxonsa outside stylus ... (2)
-> + Schema to DTD (6)
-> + Trial version requires interne... (4)
-> - APACHE FOP text box (1)
-> + Cannot create SQL Server datas... (11)
-> + StylusValidator Crashes (2)
-> + XML diff with optimize Change ... (2)
-> + how do I get the .xsl page to ... (3)
-> + Can't Use WYSIWYG from the Fil... (6)
-> + EDI Help (2)
-> + XInclude support (3)
-> + Editor options and customized ... (3)
-> + Licensed version connectes to ... (6)
-> + handling abstract types in the... (5)
-> + XML not validating against its... (4)
-> + SS gets into state where the "... (6)
-> + Download Link from Order email... (2)
-> + Stylus Studio doesn't run (2)
-> + Indent XML Tags uses pretty sh... (2)
-> + Some questions on supported pl... (3)
-> + Apache FOP Border (2)
-> + line numbers, line-wrap.. (11)
-> + Not Able to Load Siebel Web Se... (3)
-> + XSLT node or nodeset as scenar... (4)
-> - tree view parsing error: Expec... (1)
-> + reactivating the license key f... (2)
-> + XSL FO region-body border (2)
-> + WhiteSpace facet default (2)
-> - Web Service Call (1)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-> + EDIFACT to XSD problem (3)
-> + quark xpress tags (2)
-> + Duplicating nodes allows to cr... (2)
-> + Duplicated, unused nodes are r... (3)
-> + Converting to XML from a varie... (5)
-> + xsd:import's with escaped char... (8)
-> + Viewing the FO Sample Applicat... (3)
-> + Stylus Studio - Window tiling (3)
-> + Question about XML->Java Objec... (2)
-> + SVG web-based editor (2)
-> + conversion process for the pdf... (2)
-> + GUI Mapper does not create pro... (4)
-> + JavaScript working inside prev... (4)
-> + Stylus Studio Crashes when I a... (4)
-> + SVG ImageReader for FOP (2)
-> + Web Service Call Using HTTPS (8)
-> + Meditech database (2)
-> + How to connect to Informix (5)
-> + long filenames in Berkeley XML... (3)
-> + Opening multiple documents = m... (3)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> + Cannot connect to SQL server (7)
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> + DB to XML Parameters (2)
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> + How my applications can gener... (11)
-> + CLASSPATH (2)
-> + Fixed order of attributes (2)
-> + merging XML files (13)
-> - The Struzzo.exe hung with no G... (1)
-> + Problem Registering Old Versio... (4)
-> + CHART.XML + CHART.XSL to CHART... (17)
-> + Aplication not loading (6)
-> + Can Stylus Studio be used to s... (2)
-- Previous [1801-1820] [1821-1840] [1841-1860] 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
Firas AraboSubject: convert positional flat file to xml
Author: Firas Arabo
Date: 24 Jul 2006 10:48 AM
Originally Posted: 24 Jul 2006 10:45 AM
I want to be able to convert a positional flat file to xml, the flat file looks something like:

record10000000000000010000000000000000000000000000
record10000000000000020000000000000000
record100000000000000300000000000000000000000000000000000
record100000000000000400000000000000000000
record20000000000000010000000000000000000000000000
record20000000000000020000000000000000
record200000000000000300000000000000000000000000000000000
record200000000000000400000000000000000000

the first 4 lines belong to one data record which goes to 4 tables(1,2,3,4), the second 4 lines belong to the next data record. so basically the flat file contains many customer records, each record is divided into lines, each line represent a row in a table(RDB), a customer record might have multiple rows of the same table, e.g. it might have 3 lines represent table(3).

the generated xml should look something like:

<root>
<record1>
<table1>
<field1postion(1-10)></field1>
.....................
</table1>
<table2></table2>
<table3></table3>
<table4></table4>
</recors1>
<record2>
......
</reocrd2>
</root>

does stylus come with a tool to handle this?

Thanks
Firas
Postnext
Tony LavinioSubject: convert positional flat file to xml
Author: Tony Lavinio
Date: 24 Jul 2006 01:06 PM
The short answer is "yes".

Stylus Studio can convert files where each record is fixed-length and
the fields within are fixed-width, *OR* where each record is variable
length and the individual fields are either fixed- or variable-width.

Tell Stylus Studio that the file is fixed width, but specify a row
delimiter, such as CR,LF.

Then you can use the *pattern matching* feature to select different
layouts based on some distinguishing pattern within the line.
Postnext
Firas AraboSubject: convert positional flat file to xml
Author: Firas Arabo
Date: 24 Jul 2006 02:02 PM
first, is this avialable in stylus professional edition?

and second, would you please give more details, I have tried to use fix width to xml from the wizard but no luck.
Postnext
Tony LavinioSubject: convert positional flat file to xml
Author: Tony Lavinio
Date: 24 Jul 2006 02:34 PM
This is only available in the Enterprise edition.
You can download a free trial from
http://www.stylusstudio.com/xml_download.html

Guessing by your comment, you have an older version of Stylus Studio.
What version do you have? You can install the above side-by-side
with your older version.

The fixed-width wizard is only a small subset, and it is doubtful
it will help you if different rows have fields with different lengths.
And that wizard has been retired as of recent builds.

What you want is Convert-to-XML as shown here:
http://www.stylusstudio.com/convert_to_xml.html
and the documentation is here:
http://www.stylusstudio.com/docs/v2006R3/d_flatfileconversion.html
Postnext
Firas AraboSubject: convert positional flat file to xml
Author: Firas Arabo
Date: 24 Jul 2006 03:16 PM
I have stylus version 6 release 2 prefessional xml edition.
I'll download the Enteriprise, and try to work it out.

Thanks for the links, I am trying to evaluate xml conversion tools and then choose what fit us best.
Postnext
Firas AraboSubject: convert positional flat file to xml
Author: Firas Arabo
Date: 25 Jul 2006 10:56 AM
I read the tutorials and watched the videos before downloading the enteriprise edition, and the version I have has the "convert to xml" tool, I don't know if it is different than the latest version or not though!

so I tried to convert my positional flat file and faced many issues:
1- I chose line oriented region, but I couldn't specify the beginning of the fields. If I choose fixed line width then I can specify the beginning of each field. what is the point of not allowing this feature to the line oriented region?

2- the matching pattern is based on characters, I can match all raws that begins with "record1", but I am looking for a way to match it based on position, let's say position 37-39.

3- is there any mechnasim to make stylus to automatically start a new region of record2 after record1 ends?
Postnext
Tony LavinioSubject: convert positional flat file to xml
Author: Tony Lavinio
Date: 26 Jul 2006 02:59 AM
Originally Posted: 26 Jul 2006 03:00 AM
>I read the tutorials and watched the videos before
>downloading the enteriprise edition, and the version I
>have has the "convert to xml" tool, I don't know if it is
>different than the latest version or not though!

You want build 653c or later.
You can see this in Help -> About.

>so I tried to convert my positional flat file and faced
>many issues:

>1- I chose line oriented region, but I couldn't specify
>the beginning of the fields. If I choose fixed line width
>then I can specify the beginning of each field. what
>is the point of not allowing this feature to the line
>oriented region?

You want the fixed-width region, but after you select it,
you can set your record delimiter (e.g. CR,LF). Then you
will be able to positionally size your fields.

>2- the matching pattern is based on characters, I can
>match all raws that begins with "record1", but I am
>looking for a way to match it based on position, let's say
>position 37-39.

Matching is based on regular expressions. Something
like ^.{36}XXX (untested!) should match XXX in positions
37-39.

>3- is there any mechnasim to make stylus to automatically
>start a new region of record2 after record1 ends?

No.
Postnext
Simon BellSubject: convert positional flat file to xml
Author: Simon Bell
Date: 17 Aug 2006 11:30 AM
Hi,
I'm trying to evaluate Stylus Studio and am having similar issues.
The flat file I'm looking to convert to and from XML is positional.

Meaning that positions 1-3 will contain data which needs to map to a node, then 4-8 will contain data which needs to be mapped to another node. Whilst the file itself is fixed width, 800 characters, I'm not finding the functionality to work with positional files.
Could you help me out?
Thanks
Posttop
Tony LavinioSubject: convert positional flat file to xml
Author: Tony Lavinio
Date: 17 Aug 2006 11:49 AM
Can you supply an example? You can email it to stylus-field-report (at)
progress.com.

But what you are asking seems straight-forward.

Open the file with Convert-to-XML.
Define it as fixed-width.

By right-clicking on the cell that corresponds to the first character
of the new field, you should see a choice that says 'begin field here'.
   
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.