XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » WSCC to KML transform help
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> + Generating XML files accesing ... (6)
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> + mySQL DB Connection 2 (10)
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> + Automation using Visual Studio (7)
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Doug LundinSubject: WSCC to KML transform help
Author: Doug Lundin
Date: 10 Mar 2008 09:02 AM
Hello,

I am exploring the use of Web Service Call (.WSCC) in Stylus and trying to establish a proof-of-concept.

I'm not strong in XSLT, not sure this approach is possible or even a good idea and appreciate any thoughts.

Goal: Start from a Web Service Call, extract data and transform into XML that can be fed into Google Earth (.KML).

Thanks in advance
Doug


FILE: TAP_refuel_getRefuelView1.wscc
------------------------------------
<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<types:getRefuelView1 xmlns:types="/model/common/types/">
<types:msnId>1</types:msnId>
<types:trackStart></types:trackStart>
<types:trackEnd/>
</types:getRefuelView1>
</SOAP-ENV:Body>
<stylus:stylus_studio xmlns:stylus="http://www.stylusstudio.com"><scenarios><scenario default="yes" name="Scenario1" processortype="Apache Axis 1.1" transport="http"><property name="ProxyServerBypass" value=""/><property name="_stylus_soapaction" value="/model/common/getRefuelView1"/><property name="ProxyUser" value=""/><property name="_stylus_endpoint" value="http://localhost:8988/EJB-TAP_refuel-Model-context-root/TAPService"/><property name="_stylus_soapclient" value="Apache Axis 1.1"/><property name="_stylus_operation" value="getRefuelView1"/><property name="ProxyPassword" value=""/><property name="ProxyServer" value=""/><property name="_stylus_wsdlurl" value="http://localhost:8988/EJB-TAP_refuel-Model-context-root/TAPService?WSDL"/></scenario></scenarios></stylus:stylus_studio></SOAP-ENV:Envelope>

FILE: Output of (TAP_refuel_getRefuelView1.wscc)
------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing"><env:Header/><env:Body><ns0:getRefuelView1Response xmlns:ns0="/model/common/types/"><ns6:result xsi:type="ns1:RefuelViewSDO" xmlns:ns1="/model/common/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns6="/model/common/types/"><ns1:MsnId>1</ns1:MsnId><ns1:LnoId>87998</ns1:LnoId><ns1:AcId>B-52</ns1:AcId><ns1:TankerId>KC-747</ns1:TankerId><ns1:TrackStart>8</ns1:TrackStart><ns1:TrackEnd>9</ns1:TrackEnd><ns1:Lat>12.34567</ns1:Lat><ns1:Lon>21.76543</ns1:Lon></ns6:result></ns0:getRefuelView1Response></env:Body></env:Envelope>

File: TAP_refuel_getRefuelView1.xsl
-----------------------------------
<?xml version='1.0' ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<kml>
<Document>
<Style id="default">
<IconStyle>
<Icon>
<href>root://icons/palette-4.png</href>
<y>128</y>
<w>32</w>
<h>32</h>
</Icon>
</IconStyle>
<LabelStyle>
<scale>0.7</scale>
</LabelStyle>
<LineStyle>
<color>19010000</color>
<width>0.5</width>
</LineStyle>
<PolyStyle>
<color>b03f85cd</color>
</PolyStyle>
</Style>
<xsl:apply-templates/>
</Document>
</kml>
</xsl:template>
<xsl:template match="ns4:result">
<Folder>
<name>
<xsl:value-of select="@name"/>
</name>
<xsl:for-each select="row">
<Placemark>
<LookAt>
<altitude>0</altitude>
<range>900</range>
<tilt>3.888617968917447e-011</tilt>
<heading>-12.05772031636419</heading>
</LookAt>
<styleUrl>#default</styleUrl>
<Point>
<coordinates>,</coordinates>
</Point>
</Placemark>
</xsl:for-each>
</Folder>
</xsl:template>
</xsl:stylesheet><!-- Stylus Studio meta-information - (c) 2004-2007. Progress Software Corporation. All rights reserved.

<metaInformation>
<scenarios>
<scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" url="ws:///c:\WSI_Demo\kml\Misc Stylus\TAP_refuel_getRefuelView1.wscc" htmlbaseurl="" outputurl="" processortype="saxon8" useresolver="yes" profilemode="0"
profiledepth="" profilelength="" urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" validateoutput="no"
validator="internal" customvalidator="">
<advancedProp name="sInitialMode" value=""/>
<advancedProp name="bXsltOneIsOkay" value="true"/>
<advancedProp name="bSchemaAware" value="true"/>
<advancedProp name="bXml11" value="false"/>
<advancedProp name="iValidation" value="0"/>
<advancedProp name="bExtensions" value="true"/>
<advancedProp name="iWhitespace" value="0"/>
<advancedProp name="sInitialTemplate" value=""/>
<advancedProp name="bTinyTree" value="true"/>
<advancedProp name="bWarnings" value="true"/>
<advancedProp name="bUseDTD" value="false"/>
<advancedProp name="iErrorHandling" value="fatal"/>
</scenario>
</scenarios>
<MapperMetaTag>
<MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no">
<SourceSchema srcSchemaPath="ws:///c:\WSI_Demo\kml\Misc Stylus\TAP_refuel_getRefuelView1.wscc" srcSchemaRoot="env:Envelope" AssociatedInstance="" loaderFunction="document" loaderFunctionUsesURI="no"/>
</MapperInfo>
<MapperBlockPosition>
<template match="/">
<block path="kml/Document/xsl:apply-templates" x="381" y="36"/>
</template>
<template match="sheet">
<block path="Folder/name/xsl:value-of" x="436" y="37"/>
<block path="Folder/xsl:for-each" x="393" y="80"/>
<block path="Folder/xsl:for-each/Placemark/name/xsl:value-of" x="341" y="85"/>
<block path="Folder/xsl:for-each/Placemark/description/xsl:value-of" x="301" y="85"/>
<block path="Folder/xsl:for-each/Placemark/LookAt/longitude/xsl:value-of" x="261" y="85"/>
<block path="Folder/xsl:for-each/Placemark/LookAt/latitude/xsl:value-of" x="221" y="85"/>
<block path="Folder/xsl:for-each/Placemark/Point/coordinates/xsl:value-of" x="181" y="85"/>
<block path="Folder/xsl:for-each/Placemark/Point/coordinates/xsl:value-of[1]" x="141" y="85"/>
</template>
<template match="ns4:result">
<block path="Folder/name/xsl:value-of" x="203" y="153"/>
<block path="Folder/xsl:for-each" x="353" y="151"/>
</template>
</MapperBlockPosition>
<TemplateContext></TemplateContext>
<MapperFilter side="source"></MapperFilter>
</MapperMetaTag>
</metaInformation>
-->

Desired output format:
-----------------------------------
<?xml version="1.0"?>
<kml xmlns="http://earth.google.com/kml/2.1">
<Document><Style id="default"><IconStyle><Icon><href>root://icons/palette-4.png</href><y>128</y><w>32</w><h>32</h></Icon></IconStyle><LabelStyle><scale>0.7</scale></LabelStyle><LineStyle><color>19010000</color><width>0.5</width></LineStyle><PolyStyle><color>b03f85cd</color></PolyStyle></Style>
<Folder><name>Aruba</name><Placemark><name>Rooi Afó </name><description>Hidrográfico </description><LookAt><longitude>-70</longitude><latitude>12.5333333</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70,12.5333333</coordinates></Point></Placemark><Placemark><name>Ceru Alejandro </name><description>Orográfico </description><LookAt><longitude>-69.9333333</longitude><latitude>12.45</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.9333333,12.45</coordinates></Point></Placemark><Placemark><name>Alto Vista </name><description>Orográfico </description><LookAt><longitude>-70.0166667</longitude><latitude>12.5666667</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70.0166667,12.5666667</coordinates></Point></Placemark><Placemark><name>Ceru Alto Vista </name><description>Orográfico </description><LookAt><longitude>-70.0166667</longitude><latitude>12.5666667</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70.0166667,12.5666667</coordinates></Point></Placemark><Placemark><name>Anaubi </name><description>Orográfico </description><LookAt><longitude>-70.0333333</longitude><latitude>12.6</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70.0333333,12.6</coordinates></Point></Placemark><Placemark><name>Andicouri </name><description>Hidrográfico </description><LookAt><longitude>-69.95</longitude><latitude>12.5333333</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.95,12.5333333</coordinates></Point></Placemark><Placemark><name>Andicouri Baai </name><description>Hidrográfico </description><LookAt><longitude>-69.95</longitude><latitude>12.5333333</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.95,12.5333333</coordinates></Point></Placemark><Placemark><name>Andicuri </name><description>Hidrográfico </description><LookAt><longitude>-69.95</longitude><latitude>12.5333333</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.95,12.5333333</coordinates></Point></Placemark><Placemark><name>Angochi </name><description>Lugar poblado </description><LookAt><longitude>-69.95</longitude><latitude>12.5166667</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.95,12.5166667</coordinates></Point></Placemark><Placemark><name>+++ Arashi +++</name><description>Hidrográfico </description><LookAt><longitude>-70.05</longitude><latitude>12.6</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70.05,12.6</coordinates></Point></Placemark><Placemark><name>Arasji </name><description>Hidrográfico </description><LookAt><longitude>-70.05</longitude><latitude>12.6</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70.05,12.6</coordinates></Point></Placemark><Placemark><name>Arasji </name><description>Lugar poblado </description><LookAt><longitude>-70.0666667</longitude><latitude>12.6166667</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-70.0666667,12.6166667</coordinates></Point></Placemark><Placemark><name>Arikok </name><description>Orográfico </description><LookAt><longitude>-69.9333333</longitude><latitude>12.5166667</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.9333333,12.5166667</coordinates></Point></Placemark><Placemark><name>Aruba </name><description>Orográfico </description><LookAt><longitude>-69.9666667</longitude><latitude>12.5</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.9666667,12.5</coordinates></Point></Placemark><Placemark><name>Rooi Awa Marga </name><description>Hidrográfico </description><LookAt><longitude>-69.95</longitude><latitude>12.5333333</latitude><altitude>0</altitude><range>900</range><tilt>3.888617968917447e-011</tilt><heading>-12.05772031636419</heading></LookAt><styleUrl>#default</styleUrl><Point><coordinates>-69.95,12.5333333</coordinates></Point></Placemark></Folder>
</Document>
</kml>
Postnext
Doug LundinSubject: WSCC to KML transform help
Author: Doug Lundin
Date: 10 Mar 2008 11:58 AM
I guess my biggest challenge is how to extract the Namespace references out of the WSCC.
Postnext
Ivan PedruzziSubject: WSCC to KML transform help
Author: Ivan Pedruzzi
Date: 10 Mar 2008 04:38 PM
Hi Doug,

We have few questions about the message response and the XSLT you have posted.

Could you please contact us at stylus-field-report@progress.com?

Thanks
Ivan Pedruzzi
Stylus Studio Team
Postnext
Doug LundinSubject: WSCC to KML transform help
Author: Doug Lundin
Date: 12 Mar 2008 07:38 AM
Ivan,
Thanks for the response but I've figured it out. I'd be happy to share my solution if you are interested.
Doug
Posttop
Ivan PedruzziSubject: WSCC to KML transform help
Author: Ivan Pedruzzi
Date: 12 Mar 2008 10:51 AM
Doug,

My suggestion would be to move to XQuery.

You will be able to invoke the service and generate the result in a single step.

Have a look to the attached file.

Hope this helps
Ivan


DocumentInvoke.xquery
   
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.