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
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 (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Jay LessikSubject: Convert flat file with varying record formats
Author: Jay Lessik
Date: 08 Dec 2005 11:04 AM
See my previous post: http://www.stylusstudio.com/SSDN/default.asp?action=9&fid=23&read=4150&FirstTopic=111&LastTopic=210

The new version of Stylus Studio is supposed to support this but I can't seem to figure out how to do it.

Any ideas?

Thanks!

Postnext
Minollo I.Subject: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 11:37 AM
Consider this example (field separators are tabs):
Type1 2005 12 10
Type1 2004 11 23
Type2 SubtypeA Stylus Studio
Type1 2004 12 1
Type2 SubtypeB Microsoft Winword
Type2 SubtypeA Office

See the short attached movie (it's a flash video; you can open it in your web browser) to see what I did; my output is now:

<?xml version="1.0" encoding="utf-8"?>
<root>
<Date>
<year>2005</year>
<month>12</month>
<day>10</day>
</Date>
<Date>
<year>2004</year>
<month>11</month>
<day>23</day>
</Date>
<Product>
<ProductName>Stylus Studio</ProductName>
</Product>
<Date>
<year>2004</year>
<month>12</month>
<day>1</day>
</Date>
<ProductEx>
<Company>Microsoft</Company>
<Product>Winword</Product>
</ProductEx>
<Product>
<ProductName>Office</ProductName>
</Product>
</root>

Is this similar to what you are trying to do?
Minollo

Postnext
Minollo I.Subject: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 11:38 AM
...the video.


Multimediaconvert1.swf
convert-to-XML example

Postnext
Jay LessikSubject: Convert flat file with varying record formats
Author: Jay Lessik
Date: 08 Dec 2005 11:52 AM
Hi Minollo,

Thanks for that! That's very close to what I need to do, so I am encouraged! The only difference would be that the file isn't delimited. So for your example, my file would look like this:

Type120051210______SomeData__
Type120041123______SomeData__
Type2SubtypeAStylusStudiossss
Type120041201______SomeData__
Type2SubtypeBMicrosoftWinword
Type2SubtypeAOffice__________

With the _'s being spaces.

The conditions for the formats are slightly more complicated too. It might be something like:

If it starts with Type1 and the SomeData is "SomeData" or "DataSome" and the month is not "12" then it's Format A.

If it starts with Type 1 and the SomeData is "SomeData" and the month is "12" and the year is "2004" then it's Format B.

Based on what your video showed I think this might be possible, just more complicated, heh ;)

Thanks very much for your help, the video was especially helpful! I'll go investigate further and see what I can figure out!

Thanks!

Postnext
Minollo I.Subject: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 12:40 PM
The field where you enter your matching pattern accept regular expressions; so you can discriminate record types in much more complicated contexts than I did in the video.

Also, Convert-to-XML does allow you to handle records where spaces are used as field separators.

Minollo

Postnext
David KarrSubject: RE: Convert flat file with varying record formats
Author: David Karr
Date: 08 Dec 2005 03:29 PM
What if I needed something like this to be done at runtime (not in SS),
and also to go in both directions, from "encoded" to XML, and back? I
get the feeling that the "XML Adapters" feature (I don't remember if
that's the name) can do something like this.

> -----Original Message-----
> From: stylus-studio-tech Listmanager
> [mailto:stylus-studio-tech.listmanager@stylusstudio.com]
> Sent: Thursday, December 08, 2005 8:40 AM
> Subject: Convert flat file with varying record formats
>
>
> From: Minollo I.
>
> Consider this example (field separators are tabs):
> Type1 2005 12 10
> Type1 2004 11 23
> Type2 SubtypeA Stylus Studio
> Type1 2004 12 1
> Type2 SubtypeB Microsoft Winword
> Type2 SubtypeA Office
>
> See the short attached movie (it's a flash video; you can
> open it in your web browser) to see what I did; my output is now:
>
> <?xml version="1.0" encoding="utf-8"?>
> <root>
> <Date>
> <year>2005</year>
> <month>12</month>
> <day>10</day>
> </Date>
> <Date>
> <year>2004</year>
> <month>11</month>
> <day>23</day>
> </Date>
> <Product>
> <ProductName>Stylus Studio</ProductName>
> </Product>
> <Date>
> <year>2004</year>
> <month>12</month>
> <day>1</day>
> </Date>
> <ProductEx>
> <Company>Microsoft</Company>
> <Product>Winword</Product>
> </ProductEx>
> <Product>
> <ProductName>Office</ProductName>
> </Product>
> </root>
>
> Is this similar to what you are trying to do?
> Minollo
>
>
> --
> To reply: mailto:stylus-studio-tech.12972@stylusstudio.com
> To start a new topic: mailto:stylus-studio-tech@stylusstudio.com
> To login: http://www.stylusstudio.com/SSDN/
> To (un)subscribe:
> mailto:stylus-studio-tech.list-request@stylusstudio.com
>
>

Postnext
Minollo I.Subject: RE: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 04:08 PM
David,
Stylus Studio Deployment Adapters (http://www.stylusstudio.com/deployment/) will let you use the "convert-to-XML" conversions that you create in Stylus Studio through a Java API - or as extended URI resolvers hooked in your Java XSLT or XQuery processor.

You can find more details in http://www.stylusstudio.com/xml_adapters.html, and you can also take a look at the example shipped with Enterprise Edition (<StylusStudioInstallDir>\examples\Adapters). Also, the video tutorial at http://www.stylusstudio.com/videos/deployment1/deployment1.html shows you how Stylus Studio Deployment Adapters can be easily leveraged even on non Windows platforms.

About bi-directional conversions, the Stylus Studio built-in adapters (like EDI, CSV and others), all support bi-directional use. The user-defined ones (the .conv ones, defined using the convert-to-XML UI module in Stylus Studio) only support nonXML-to-XML.

Minollo

Postnext
David KarrSubject: RE: Convert flat file with varying record formats
Author: David Karr
Date: 08 Dec 2005 04:56 PM
Originally Posted: 08 Dec 2005 04:57 PM
I may be missing something, but I interpret this response as a very
convoluted version of "no, you can't do that". I'm talking about a
user-defined non-XML to XML conversion that can be done at runtime, and
can go in both directions. If I understand what you're saying here,
this doesn't provide that capability.

> -----Original Message-----
> From: stylus-studio-tech Listmanager
>
> From: Minollo I.
>
> David,
> Stylus Studio Deployment Adapters ( > href="http://www.stylusstudio.com/deployment/">http://www.styl
> usstudio.com/deployment/
) will let you use the
> "convert-to-XML" conversions that you create in Stylus Studio
> through a Java API - or as extended URI resolvers hooked in
> your Java XSLT or XQuery processor.
>
> You can find more details in > href="http://www.stylusstudio.com/xml_adapters.html,">http://w
ww.stylusstudio.com/xml_adapters.html,
and > you can also take a
look at the example shipped with
> Enterprise Edition
> (<StylusStudioInstallDir>\examples\Adapters). Also, the
> video tutorial at > href="http://www.stylusstudio.com/videos/deployment1/deploymen
> t1.html">http://www.stylusstudio.com/videos/deployment1/deploy
> ment1.html
shows you how Stylus Studio Deployment
> Adapters can be easily leveraged even on non Windows platforms.
>
> About bi-directional conversions, the Stylus Studio built-in
> adapters (like EDI, CSV and others), all support
> bi-directional use. The user-defined ones (the .conv ones,
> defined using the convert-to-XML UI module in Stylus Studio)
> only support nonXML-to-XML.
>
> Minollo

Posttop
Minollo I.Subject: RE: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 05:13 PM
I didn't try to be particularly convoluted, but I guess I succeeded anyway.

Let me try again.

"Can I run a user-defined conversion outside the Stylus Studio UI?"
Yes, you can. You can find references to the Java API that allows you to do that in the previous post.

"Can a user-defined nonXML-to-XML conversion be executed in the other direction, XML-to-nonXML?"
No, it can't. User-defined conversions can only be executed to convert non-XML documents into XML. In contrast, any of the built-in conversions (like EDI - X12/EDIFACT, CSV, ...) can be executed in both directions.

Minollo

   
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.