SSDN - Transform FF into XML w/ new content added

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

Rick Scofield

Subject: Transform FF into XML w/ new content added
Author: Rick Scofield
Date: 10 Mar 2006 03:03 PM

Hello, I'm new to StylusStudio but have worked with other mapping tools like Altovia and Contivo.

Does anyone provide any help on how to get started transforming an FF as input into file that has additional content. For example I have a FF (attached) 'UPCOptions.txt' that provides inventory availability. I need to create an output file that looks like (attached) 'WebOptions.xls'

So for each style (loop), for each color (loop) and write to new file with added text elements. The transformation path would be something like UPCOptions.txt -->UPCOptions.xml --> WebOptions.xls

Thanks for any help

UPCOptions.TXT
Inventory FF

UPCOptions.xml
XML Inventory file

WebOptions.xls
Final web options file

Ivan Pedruzzi

Subject: Transform FF into XML w/ new content added
Author: Ivan Pedruzzi
Date: 10 Mar 2006 05:36 PM

Hi Rick

UPOptions.txt -> UPOptions.xml

- Create a new Convert to XML document (File -> New -> COnvert To XML)

- Select UPOptions.txt as input file select "fixed width" as general layout

- After the file is loaded right click on the first
row on the B letter and click "Begin Field in This Column";
do the same for all required fields.
See the attached screenshot UPCConv.png

Once the converter is created it can be used as input of XSLT transformation.
I created one for you to play, please copy UPC.conv to
c:\Program Files\Stylus Studio 2006 Release XML Enterprise Edition\Adapter

To generate the final result do the following

- save WebOptions.xls as CSV (Comma Separated Values) using Microsoft Excel and named it WebOptions.csv

- Create a new XLT Mapper
- set as source adapter:/UPC.conv
- set as target c:\Temp\UPC\WebOptions.csv
- click on the ... in the toolbar and set the output URL to
adapter:CSV:newline=crlf:encoding=utf-8:sep=,:first=yes:escape=\:quotes='":number=no?file:///c:/Temp/UPC/WebOptions-out.csv

then you can start to map from left to right; the information that are not coming from UPOptions.txt need to be coded in XSLT

I attached a full project, you just need to unzip the archive in C:\TEMP.

for more information see the Video Tutorials
http://www.stylusstudio.com/xml_videos.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

UPCConv.png

UPC-XSLTMapping.png

UPC.ZIP

Rick Scofield

Subject: Transform FF into XML w/ new content added
Author: Rick Scofield
Date: 11 Mar 2006 10:06 AM

Thank you Ivan for the prompt response. This is just what I needed to get going!

THX

Rick Scofield

Subject: Transform FF into XML w/ new content added
Author: Rick Scofield
Date: 11 Mar 2006 10:26 AM

Ivan, sorry one other question please...how did you come up with the output URL: adapter:CSV:newline=crlf:encoding=utf-8:sep=,:first=yes:escape=\:quotes='":number=no?file:///c:/Temp/UPC/WebOptions-out.csv

Ivan Pedruzzi

Subject: Transform FF into XML w/ new content added
Author: Ivan Pedruzzi
Date: 11 Mar 2006 07:48 PM

I just used the Save File Dialog; I clicked "conver from XML using adapter" then picked the CSV adapter.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

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.