Batch update of project code values

[Jason Leung]

I received an Excel worksheet from our Finance dept to show the Actual cost
and Actual hours for each project generated from SAP.
I set up Ent. Project Text6 to store the Project ID, Ent. Project Cost1 to
capture the actual cost and Ent Project number1 to capture the actual hours.
Are there any VBA codes which I can do a batch update using the Excel
directly or with the data embedded in the VBA codes?

 

[Gord Schmidt]

Hi Jason,

Look into the Project Data Service
(http://msdn.microsoft.com/library/d...n-us/pjsdk/html/pdsAboutThePDSReference.asp);
specifically the ProjectCodeValues and ProjectCodeValuesUpdate methods.

Gord

 

[Jason Leung]

Gord, thanks very much for your information. I followed your link and did
some reading, I found the closest thing to what I need is probably using the
EnterpriseFieldUpdate Method. It has an XML sample but I never used XML
before so I really do not know how to start. I gone through quite a few pages
and these pages all asumming the reader already had some experience with XML
and they only show the methods but no procedure.
What I need to do perhaps is quite simple, I have 2 columns of data, I just
want to match the first column with Enterprise project text1 and replace the
Enterprise project number1 with the column 2 value. If Enterprise Project
text1 is empty, go to next project.
I hope you can show me the procedure on how to use the XML to kick start me.
Regards

 

[Gord Schmidt]

Hi Jason,

XML isn't a programming language, it is just a structure used to store and
pass data around. In this case, it is the structure used by PDS (Project Data
Service).

If you want to know how to get started, you should check out the follow
articles:
http://www.microsoft.com/downloads/...A3-F612-4DA2-ACB8-FDA8F850D645&DisplayLang=en

Gord

 

[Jason Leung]

Hi Gord, thanks for your quick response. I did not realize I am entering a
new arena with XML. Your link helped me to locate Building and Hosting PDS
Web Applications for Project Server 2003. It has some procedures to install
sample applications and Web services and it looks like this is exactly what I
need to get started.
Regards