Updates to Projects from PWA

[Angie R]

Hello,

I have created a few custom fields (just regular ones not custom outline
codes). I have some executives that like to update those fields from PWA
instead of Project Professional because it is easier. When they update those
fields, the project itself is updated, but the changes are not getting to the
SQL Database. The only way I can get those changes to update is to open the
project and publish all information from Project Professional. Someone
please help!

 

[Angie R]

I found the view populator tool on Microsoft's site which kind of fixes my
issue. Does anyone know if that tool can be automated?

 

[Rolly Perreaux]

I found the view populator tool on Microsoft's site which kind of fixes my
issue. Does anyone know if that tool can be automated?

Hi Angie,

When you say automated, are you referring to a batch or script file to
be run every day or week? If so, View Populator tool won't do this this
for you as you need to authenticate against the Project Server.

However, if you know a few things about the project you want to publish
you might be able to configure a script to create the XML file you'll
need to copy to the ViewDrop shared folder.

For example,
Here's the XML file for a sample project I just published using View
Populator.

- <ViewsDropData>
- <ProjectData>
- <EntProjectName>
- <![CDATA[ Integration with Accounting.Published ]]>
</EntProjectName>
<EntProjectID>4</EntProjectID>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<ProjectID>101</ProjectID>
<BasePath>projectserver</BasePath>
<TimeStamp>2005-07-18T04:30:28</TimeStamp>
</ViewsDropData

Nothing really earth shattering here that you couldn't create a script
to copy the XML file to the ViewDrop shared folder where the View
Processing component is located. Once in the shared folder the
Notification Service takes over and processes the XML file.

Remember that you'll need to have read/write permission to the shared
folder to copy the file.

Please note that this method is NOT supported by Microsoft.


You also might try contacting Microsoft Consulting Services as they
might have a command line tool that might do this for you.

Good Luck

--
Rolly Perreaux
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com