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 (1188)
- Stylus Studio Technical Forum (14588)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (2)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-> + Problem with SAXO processor - ... (5)
-> + PDF Format Help (4)
-> + License check unreliable (2)
-> - XML related issue (1)
-> + Need help regarding pipeline o... (2)
-> + Error converting XML to EDIFAC... (4)
-> + XSLT Profiling for XSLT 1.0 s... (2)
-> + Grouping (2)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (247)
+ XSLT Help and Discussion (7617)
+ XQuery Help and Discussion (1971)
+ 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.