dataset xml and project vba

[Ed Staffin]

Hi All,
I want to import a list of resources from a database using
an xml web service. I have the service written, but it
exposes the xml produced from a dataset's GetXml method.

ADODB.recordsets don't know how to read this type of xml.
Can anyone share their thoughts on the best way to
translate the xml into something I can use in project vba?
Thanks ... Ed

 

[Rod Gill]

Hi,

If you have Project 2002+ then you can import xml data directly into
Project. See help and the xml file in one of Project's program folders to
get the format required.

Failing that, then another solution is to read the data into an Excel
workbook then use automation from Excel VBA to export it to Project.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Sam Santiago]

It depends where the XML is returned to. Are you invoking your service from
the Project client or from the Project Server? But you could use XSL to
transform your XML data into something more manageable by project VBA. For
example, you could transform the data into a delimited string and then use
the VBA Split command to create a one dimensional array. You could also use
the DOM API to traverse your XML and build an ADODB recordset manually. If
you are invoking the server from the Project client you'll have to ensure
the XML parser is on all desktops.