Problem importing web services from wsdl to classes in VBA

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

poul

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

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.

I appreciate any help with this issue, since I need to be able to use the web services in VBA.

Thanks!

Poul

smiconrad

I have the same problem. But I found that there are bugs in some of the WSDL files.

For instance to get dictionary-service.wsdl to import in the Webservices Toolkit I had to change:

<wsdl:import namespace="http://www.alfresco.org/model/content/1.0" location="types.xsd" />

to:

<wsdl:import namespace="http://www.alfresco.org/ws/model/content/1.0" location="types.xsd" />

I also had to add <wsdl:import namespace="http://www.alfresco.org/ws/model/content/1.0" location="types.xsd" /> 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:

<element name="update">
            <complexType>
               <sequence>
                  <element name="statements" type="cml:CML"/>
               </sequence>
            </complexType>
         </element>

to:

<element name="update">
            <complexType>
               <sequence>
                  <element name="statements" type="xsd:string"/>
               </sequence>
            </complexType>
         </element>

will work. I can't figure out what's wrong with the CML type.

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.

Thanks!
–
Conrad