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 (1169)
- Stylus Studio Technical Forum (14440)
-> - xfile Legacy file format suppo... (1)
-> + TPFDF (3)
-> + Help needed with SLSRPT - EDIF... (2)
-> - keeps crashing after I try and... (1)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-> + How to disable checking for up... (2)
-> + XML Publisher requires duplica... (4)
-> + Modifying Field Name in XML (4)
-> + Java Runtime Environmnet Libra... (2)
-> + Passing Parameters and Multipl... (4)
-> + Total Newbie Question... where... (3)
-> + XML Pipeline (2)
-> + Encoding problem in text previ... (5)
-> + New Installation on windows 20... (4)
-> - Exception while calling Java m... (1)
-> + Jars to be included for callin... (2)
-> + SXXP0003: Error reported by XM... (2)
-> + Validation error (5)
-> + Windows 10, latest Java, new t... (2)
-> + using help crashes stylus stud... (3)
-> + Web Service Call error (5)
-> + javax.xml.xquery.XQException: ... (2)
-> + Trang translator is not availa... (2)
-> + Replacement for flat2xml (2)
-> + CONV CSV Display Problem (3)
-> + StylusValidator.exe Command Li... (3)
-> + Cannot run Java built in valid... (2)
-> + Windows 10??? (3)
-> + Stylus Custom XML Conversion (... (8)
-> + X14 enterprise and saxon 9.4.0... (3)
-> + Open an XML document in the XM... (3)
-> + How to generate mapping report... (4)
-> + 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)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (244)
+ XSLT Help and Discussion (7593)
+ XQuery Help and Discussion (1941)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (363)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Rick ScofieldSubject: 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


UnknownUPCOptions.TXT
Inventory FF

UnknownUPCOptions.xml
XML Inventory file

UnknownWebOptions.xls
Final web options file

Postnext
Ivan PedruzziSubject: 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


ImageUPCConv.png


ImageUPC-XSLTMapping.png


DocumentUPC.ZIP

Postnext
Rick ScofieldSubject: 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

Postnext
Rick ScofieldSubject: 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

Posttop
Ivan PedruzziSubject: 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

   
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.