<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Problem importing web services from wsdl to classes in VBA in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/problem-importing-web-services-from-wsdl-to-classes-in-vba/m-p/42773#M23135</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm using Alfresco 1.3 with Tomcat, and I'm trying to build an interface to Alfresco using web services. I'm having problems importing some of the web services into Micorsoft VBA Editor using the MS Web Service References Kit (downloaded from microsoft.com). Some web serivces are working fine while others can't be found by the tool when I give it the wsdl URL. The services that aren't working are authoring-service.wsdl, content-service.wsdl, and repository-service.wsdl.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The above services can be imported when I use C# in Visual Studio 2005 but I get errors when I try to compile and run the project. I also did some looking around and I think it may be a problem with cml.xsd. I looked into the file but couldn't find what the problem may be.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I appreciate any help with this issue, since I need to be able to use the web services in VBA.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Poul&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 15 Oct 2006 19:59:46 GMT</pubDate>
    <dc:creator>poul</dc:creator>
    <dc:date>2006-10-15T19:59:46Z</dc:date>
    <item>
      <title>Problem importing web services from wsdl to classes in VBA</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/problem-importing-web-services-from-wsdl-to-classes-in-vba/m-p/42773#M23135</link>
      <description>Hello,I'm using Alfresco 1.3 with Tomcat, and I'm trying to build an interface to Alfresco using web services. I'm having problems importing some of the web services into Micorsoft VBA Editor using the MS Web Service References Kit (downloaded from microsoft.com). Some web serivces are working fine</description>
      <pubDate>Sun, 15 Oct 2006 19:59:46 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/problem-importing-web-services-from-wsdl-to-classes-in-vba/m-p/42773#M23135</guid>
      <dc:creator>poul</dc:creator>
      <dc:date>2006-10-15T19:59:46Z</dc:date>
    </item>
    <item>
      <title>Re: Problem importing web services from wsdl to classes in VBA</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/problem-importing-web-services-from-wsdl-to-classes-in-vba/m-p/42774#M23136</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I have the same problem. But I found that there are bugs in some of the WSDL files.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;For instance to get dictionary-service.wsdl to import in the Webservices Toolkit I had to change:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;&amp;lt;wsdl:import namespace="&lt;A href="http://www.alfresco.org/model/content/1.0" rel="nofollow noopener noreferrer"&gt;http://www.alfresco.org/model/content/1.0&lt;/A&gt;" location="types.xsd" /&amp;gt;&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt;to:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;&amp;lt;wsdl:import namespace="&lt;A href="http://www.alfresco.org/" rel="nofollow noopener noreferrer"&gt;http://www.alfresco.org/&lt;/A&gt;&lt;STRONG&gt;ws&lt;/STRONG&gt;/model/content/1.0" location="types.xsd" /&amp;gt;&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt;I also had to add &lt;/SPAN&gt;&lt;STRONG&gt;&amp;lt;wsdl:import namespace="&lt;A href="http://www.alfresco.org/ws/model/content/1.0" rel="nofollow noopener noreferrer"&gt;http://www.alfresco.org/ws/model/content/1.0&lt;/A&gt;" location="types.xsd" /&amp;gt;&lt;/STRONG&gt;&lt;SPAN&gt; to repository-service.xml to get the Webservices Toolkit import accepted. But then upon adding repository-service.wsdl to my VBA project I get an error. So I found that if I change the type of the statements element from cml:CML to let's say xsd:string, then the import works. In other words changing:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;&amp;lt;element name="update"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;complexType&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;sequence&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;element name="statements" type="&lt;STRONG&gt;cml:CML&lt;/STRONG&gt;"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/sequence&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/complexType&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/element&amp;gt;&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt;to:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;&amp;lt;element name="update"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;complexType&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;sequence&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;element name="statements" type="&lt;STRONG&gt;xsd:string&lt;/STRONG&gt;"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/sequence&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/complexType&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/element&amp;gt;&lt;/BLOCKQUOTE&gt;&lt;SPAN&gt;will work. I can't figure out what's wrong with the CML type.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Any help is appreciated since my project is at a stand still because of this issue and I've been struggling with it for a long time now.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks!&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;–&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Conrad&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 17 Oct 2006 15:28:28 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/problem-importing-web-services-from-wsdl-to-classes-in-vba/m-p/42774#M23136</guid>
      <dc:creator>smiconrad</dc:creator>
      <dc:date>2006-10-17T15:28:28Z</dc:date>
    </item>
  </channel>
</rss>

