SSDN - Convert flat file with varying record formats

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Jay Lessik

Subject: 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!

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

Minollo I.

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

convert1.swf
convert-to-XML example

Jay Lessik

Subject: 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!

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

David Karr

Subject: 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
>
>

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

David Karr

Subject: 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

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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.