 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums iWay Software Product Forum on Focal Point is there any example of using Geocoder or Google Map WS in Service Manager?
Focal Point Forums iWay Software Product Forum on Focal Point is there any example of using Geocoder or Google Map WS in Service Manager? Read-Only TopicGo | Search | Notify | Tools |
| is there any example of using Geocoder or Google Map WS in Service Manager? | Login/Join |
| Silver Member |
Hi all, I am new to iWay DM and SM. Wondering if there is any example or tutorial that I can follow in order to set up RPC, like Geocoder and Google Map WS. The trouble that I have us Web Service adapter always requires the WSDL of the Web service, while both of these services do not have one. Thanks Cokey iWay 5.5, 6.01 Windows all output (Excel, HTML, PDF) iWay 5.5, 6.01 Windows all output (Excel, HTML, PDF) | ||
|
| Member |
Hi, The Google Maps API has a lot of script stuff that can be embeded in HTML, however I'm not that familiar with the DM tools. In iSM you can request a Geocoded XML by sending the address to lookup to the Google Maps services The Google Geocoding Web Service in a HTTP GET request: http://maps.google.com/maps/api/geocode/xml?address='2 Penn Plaza, New York, NY'&sensor=false You simply use the HTTP Agent to send the GET Request with the address to lookup and you can use the response in the rest of your processing. I just completed a small project using iSM 6.0.1 to geocode the customer database. The API also supports other arguments if you need to find an address from a specific location or the location of a device with a location sensor, the other arguments are all listed on the The Google Geocoding Web Service page. Good luck! Newbie, iWay Service Manager 6.0.1 WindowsThis message has been edited. Last edited by: iWay Newbie, -- WebFOCUS 8.2.03 on Linux | |||
|
| Gold member |
I am doing it using SM with a transform to KML like this then the trick is to get the Kml up to Googlemaps or do what i do is use it with google earth witch is a easy task. Just make a file called mymap.kml. If you have google earth installed it will open up and map it. You can expand the kml. lots of reading on the net. IWay SM 5.6, 6.01, 6.1, 6.9, 7.0 EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server | |||
|
| Gold member |
I am doing it using KML. hers is a tranform <?xml version="1.0" encoding="UTF-8"?>
<Project>
<Template>
<TransformTemplate>
<TemplateMetadata>
<Version />
<Title />
<ModifiedDate />
<UniqueID />
</TemplateMetadata>
<CustomerExtensions>
<JDBCConnections />
<ReplaceFunctions />
<Functions />
<NamespaceDeclaration>
<Namespace prefix="" uri="http://earth.google.com/kml/2.0" id="1" />
</NamespaceDeclaration>
<Vars />
<ProcessingInstruction />
</CustomerExtensions>
<Mapping>
<Input format="XML">
<Parameter name="Validate" value="false" />
</Input>
<Output format="XML">
<Parameter name="Declaration" value="true" />
<Parameter name="encoding" value="UTF-8" />
<Parameter name="Indent" value="4" />
<Parameter name="Header" value="" />
<Parameter name="Footer" value="" />
<Parameter name="NullTag" value="true" />
</Output>
<MapStructure>
<Table>
<Rules>
<MapRule output="kml" input="@PARENT()" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" visible="true" path="" />
<MapRule output="Placemark" input="@PARENT()" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" visible="true" path="" />
<MapRule output="name" input="@CONCAT(@CONCAT(PS8/result/LOCATION_TBL/DESCR_0,','),@CONCAT(PS8/result/LOCATION_TBL/ADDRESS1,','),@CONCAT(PS8/result/LOCATION_TBL/CITY,',',PS8/result/LOCATION_TBL/STATE))" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="LookAt" input="@PARENT()" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" visible="true" path="" />
<MapRule output="longitude" input="@TRIM(PS8/result/iway/response/cncresult/result/resultset/row/Y)" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="latitude" input="@TRIM(PS8/result/iway/response/cncresult/result/resultset/row/X)" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="range" input="'3000.000000'" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="tilt" input="'-8.063509252367396e-012'" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="heading" input="'-2.266334953062548e-014'" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="LookAt" input="@ENDPARENT()" mapRuleFixed="0" />
<MapRule output="styleUrl" input="'root://styleMaps#default+nicon=0x307+hicon=0x317'" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="Point" input="@PARENT()" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" visible="true" path="" />
<MapRule output="coordinates" input="@CONCAT(@TRIM(PS8/result/iway/response/cncresult/result/resultset/row/Y),',',@CONCAT(@TRIM(PS8/result/iway/response/cncresult/result/resultset/row/X),',','0'))" mapRuleFixed="0" nsDefault="http://earth.google.com/kml/2.0" />
<MapRule output="Point" input="@ENDPARENT()" mapRuleFixed="0" />
<MapRule output="Placemark" input="@ENDPARENT()" mapRuleFixed="0" />
<MapRule output="kml" input="@ENDPARENT()" mapRuleFixed="0" />
</Rules>
</Table>
</MapStructure>
</Mapping>
</TransformTemplate>
<Type>XML > XML</Type>
<FileSystem />
</Template>
<Inputs>
<TransformationFile encoding="Cp1252">C:\iWay Demos\PeopleSoft\LOCATION_find_response with embedded response.xml</TransformationFile>
<StructureFile encoding="Cp1252" type="xml">C:\iWay Demos\PeopleSoft\LOCATION_find_response with embedded response.xml</StructureFile>
</Inputs>
<Output>
<StructureFile encoding="Cp1252" type="XML">guess.kml</StructureFile>
</Output>
</Project> Now you need to get it up to googlemap (demos are on the net to do this), or use it with google earth witch is what i do. I use this transform to create the kml file then email it the slaes reps. they all hav google earth installed, when they double click on the kml file google earth opens it and maps it. works really good and this way you get around google maps limites on gecodeing request. IWay SM 5.6, 6.01, 6.1, 6.9, 7.0 EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums iWay Software Product Forum on Focal Point is there any example of using Geocoder or Google Map WS in Service Manager?
Focal Point Forums iWay Software Product Forum on Focal Point is there any example of using Geocoder or Google Map WS in Service Manager?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |