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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext 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

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.