| smower |
| Newbie |
|
|
|
|
| None Specified |
|
| Thursday, April 16, 2009 |
| Thursday, September 17, 2020 2:49:59 AM |
5
[0.03% of all post / 0.00 posts per day] |
|
Thank you Vlad,
Sorry for my ignorance but I can't see any other position function option. I am using Mapforce 2008 Enterprise Edition version 2008 release 2 sp 2. Can you give me step by step instructions how to get these other non legacy functions?
Thanks!
Shawn
|
Thank you Vlad,
Question: 1
The reason it is difficult for me is that the position function on mine does not show the node option on the left side, it only shows the result on the right side and so every time I try to connect a node to it from the left xml it doesn't stick or connect. How do I fix this?
Question: 2
Also, the other question I was wondering is how to tie the title to the position in case the export items come out in a different order or they add fields that shift the position of the other fields down. I am hoping to make it as dynamic as possible so that it won't break if the data changes order.
Thanks,
Shawn
|
Hello,
I have some FileMaker XML that needs to be transformed into another xml via XSLT 1. The problem I have is that the field names are all listed in a metadata tag at the top and all the data is listed in a result set with rows, columns and data. The Field names in the metadata at the top correspond to the order of the columns and data down in the repeating resultset at the bottom. I have spent hours trying to figure out how to map this in MapForce and I can't figure it out. It seems like I need to find a way to map the metadata field names to the resultset row column and data and then I would have names that I could match up to the xml it needs to be transformed into. I imagine I need to do some filters and position but when I play with the position element it seems like it is only 1 way, so I can't figure out how to map this. Is there anyway you could give me a map force example how to map these so that I don't get so many duplicate rows?
FileMkaer XML looks like this:
<?xml version="1.0" encoding="UTF-8"?>
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.filemaker.com/fmpxmlresult C:\DOCUME~1\Administrator\Desktop\export.xsd">
<ERRORCODE>0</ERRORCODE>
<PRODUCT BUILD="06-11-2010" NAME="FileMaker" VERSION="ProAdvanced 11.0v2"/>
<DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="My News.fp7" RECORDS="3" TIMEFORMAT="h:mm:ss a"/>
<METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="News Channel::ID" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="News Channel::Name" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="News Channel::Description" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="News Channel::Link" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="News Channel::Updated" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Author::Name" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Author::Email" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ID" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Link" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Updated" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Contents" TYPE="TEXT"/>
</METADATA>
<RESULTSET FOUND="3">
<ROW MODID="2" RECORDID="1">
<COL>
<DATA>Feed 1</DATA>
</COL>
<COL>
<DATA>First Feed</DATA>
</COL>
<COL>
<DATA>A sample feed</DATA>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA>John Doe</DATA>
</COL>
<COL>
<DATA>john.doe@sample.com</DATA>
</COL>
<COL>
<DATA>Entry 1</DATA>
</COL>
<COL>
<DATA>First Entry</DATA>
</COL>
<COL>
<DATA>First Entry Link</DATA>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA>First Entry Contents</DATA>
</COL>
</ROW>
<ROW MODID="3" RECORDID="2">
<COL>
<DATA>Feed 1</DATA>
</COL>
<COL>
<DATA>First Feed</DATA>
</COL>
<COL>
<DATA>A sample feed</DATA>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA>John Doe</DATA>
</COL>
<COL>
<DATA>john.doe@sample.com</DATA>
</COL>
<COL>
<DATA>Piece of News 2</DATA>
</COL>
<COL>
<DATA>Second Entry</DATA>
</COL>
<COL>
<DATA>Second Entry Link</DATA>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA>Second Entry Contents</DATA>
</COL>
</ROW>
<ROW MODID="4" RECORDID="3">
<COL>
<DATA>Feed 1</DATA>
</COL>
<COL>
<DATA>First Feed</DATA>
</COL>
<COL>
<DATA>A sample feed</DATA>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA>John Doe</DATA>
</COL>
<COL>
<DATA>john.doe@sample.com</DATA>
</COL>
<COL>
<DATA>Piece of News 3</DATA>
</COL>
<COL>
<DATA>Third Entry</DATA>
</COL>
<COL>
<DATA>Third Entry Link</DATA>
</COL>
<COL>
<DATA/>
</COL>
<COL>
<DATA>Third Entry Contents</DATA>
</COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>
and I need to transform it into XML that looks like this:
<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.w3.org/2005/Atom C:\DOCUME~1\Administrator\Desktop\SAMPLE~1.XSD">
<title>Example Feed</title>
<subtitle>Insert witty or insightful remark here</subtitle>
<link href="http://example.org/"/>
<updated>2003-12-13T18:30:02Z</updated>
<author>
<name>John Doe</name>
<email>johndoe@example.com</email>
</author>
<id>urn:uuid:60a76c80-d399-11d9-b91C-0003939e0af6</id>
<entry>
<title>Atom-Powered Robots Run Amok</title>
<link href="http://example.org/2003/12/13/atom03"/>
<id>urn:uuid:1225c695-cfb8-4ebb-aaaa-80da344efa6a</id>
<updated>2003-12-13T18:30:02Z</updated>
<summary>Some text.</summary>
</entry>
<title>Example Feed</title>
<subtitle>Insert witty or insightful remark here</subtitle>
<link href="http://example.org/"/>
<updated>2003-12-13T18:30:02Z</updated>
<author>
<name>John Doe3</name>
<email>johndoe@example.com</email>
</author>
<id>urn:uuid:60a76c80-d399-11d9-b91C-0003939e0af6</id>
<entry>
<title>Atom-Powered Robots Run Amok</title>
<link href="http://example.org/2003/12/13/atom03"/>
<id>urn:uuid:1225c695-cfb8-4ebb-aaaa-80da344efa6a</id>
<updated>2003-12-13T18:30:02Z</updated>
<summary>Some text.</summary>
</entry>
<title>Example Feed</title>
<subtitle>Insert witty or insightful remark here</subtitle>
<link href="http://example.org/"/>
<updated>2003-12-13T18:30:02Z</updated>
<author>
<name>John Doe3</name>
<email>johndoe@example.com</email>
</author>
<id>urn:uuid:60a76c80-d399-11d9-b91C-0003939e0af6</id>
<entry>
<title>Atom-Powered Robots Run Amok</title>
<link href="http://example.org/2003/12/13/atom03"/>
<id>urn:uuid:1225c695-cfb8-4ebb-aaaa-80da344efa6a</id>
<updated>2003-12-13T18:30:02Z</updated>
<summary>Some text.</summary>
</entry>
</feed>
Thanks in Advance!
Shawn
|
Newbie question. I have been experimenting with Exchange 2007 Web Services and trying to use them with Altova XMLSpy.
With XMLSPY I have been selecting "open url" from the file menu and then I enter either:
https://remote.mydomain.com/EWS/Services.wsdl or
https://remote.mydomain.com/EWS/Exchange.asmx
and then XMLSPY asks me for the password and then it opens up the WSDL.
That is the process I use for opening most web services with XMLSPY.
On the Schema/WSDL graphical tab, nothing is shown on the Services section, it just only populates the port types and bindings. The problem with this is then when I try to chose "Create New Soap Request" from the SOAP menu, nothing happens, but on other web services I get to pick the call I went to execute or test.
Does anyone know why this problem occurs or how to solve it?
The next thing I tried to do was generate a new xml document and pasted an xml soap request into it like this:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types">
<soap:Body>
<FindItem xmlns="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types" Traversal="Shallow">
<ItemShape>
<t:BaseShape>IdOnly</t:BaseShape>
</ItemShape>
<ParentFolderIds>
<t:DistinguishedFolderId Id="inbox"/>
</ParentFolderIds>
</FindItem>
</soap:Body>
</soap:Envelope>
and then I went to the SOAP menu and chose "Change SOAP request parameters" and it game me a dialogue box asking for "Connection Endpoint" and "SOAPAction".
On the "Connection Endpoint" I entered: https://remote.competitiveedgeproducts.com/EWS/Exchange.asmx
and on the "SOAPAction" I entered: FindItem and hit OK and I get the following error:
HTTP: error: could not POST file '/EWS/Exchange.asmx' on server 'remote.mydomain.com' (500)
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<soap:Fault>
<faultcode>soap:Client</faultcode>
<faultstring>Server did not recognize the value of HTTP Header SOAPAction: FindItem.</faultstring>
<detail/>
</soap:Fault>
</soap:Body>
</soap:Envelope>
I then tried changing the "SOAPAction" to http://schemas.microsoft.com/exchange/services/2006/messages/FindItem and resubmit but then it basically gave me this error "Server was unable to process request. ---> Input message does not conform to Simple SOAP Binding Profile Version 1.0. Requirement R1012: A MESSAGE MUST serialize the envelope using either UTF-8 or UTF-16 character encoding"
Other programs sometimes require headers to submit. Does Altova XML Spy allow you to enter headers anywhere?
Does anyone know what I need to put in or do differently to get this to work?
Thanks in advance!
|
Newbie question. I have been experimenting with Exchange 2007 Web Services and trying to use them with Altova XMLSpy.
With XMLSPY I have been selecting "open url" from the file menu and then I enter either:
https://remote.mydomain.com/EWS/Services.wsdl or
https://remote.mydomain.com/EWS/Exchange.asmx
and then XMLSPY asks me for the password and then it opens up the WSDL.
That is the process I use for opening most web services with XMLSPY.
On the Schema/WSDL graphical tab, nothing is shown on the Services section, it just only populates the port types and bindings. The problem with this is then when I try to chose "Create New Soap Request" from the SOAP menu, nothing happens, but on other web services I get to pick the call I went to execute or test.
Does anyone know why this problem occurs or how to solve it?
The next thing I tried to do was generate a new xml document and pasted an xml soap request into it like this:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types">
<soap:Body>
<FindItem xmlns="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types" Traversal="Shallow">
<ItemShape>
<t:BaseShape>IdOnly</t:BaseShape>
</ItemShape>
<ParentFolderIds>
<t:DistinguishedFolderId Id="inbox"/>
</ParentFolderIds>
</FindItem>
</soap:Body>
</soap:Envelope>
and then I went to the SOAP menu and chose "Change SOAP request parameters" and it game me a dialogue box asking for "Connection Endpoint" and "SOAPAction".
On the "Connection Endpoint" I entered: https://remote.competitiveedgeproducts.com/EWS/Exchange.asmx
and on the "SOAPAction" I entered: FindItem and hit OK and I get the following error:
HTTP: error: could not POST file '/EWS/Exchange.asmx' on server 'remote.mydomain.com' (500)
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<soap:Fault>
<faultcode>soap:Client</faultcode>
<faultstring>Server did not recognize the value of HTTP Header SOAPAction: FindItem.</faultstring>
<detail/>
</soap:Fault>
</soap:Body>
</soap:Envelope>
I then tried changing the "SOAPAction" to http://schemas.microsoft.com/exchange/services/2006/messages/FindItem and resubmit but then it basically gave me this error "Server was unable to process request. ---> Input message does not conform to Simple SOAP Binding Profile Version 1.0. Requirement R1012: A MESSAGE MUST serialize the envelope using either UTF-8 or UTF-16 character encoding"
Does anyone know what I need to put in or do differently to get this to work?
Thanks in advance!
|
|
