Link to home
Start Free TrialLog in
Avatar of ChrisClement
ChrisClement

asked on

Updating Project 2003 with Project Server 2003 PDS

I am writing a c# app that will update a project based on a SQL trigger.  My problem is that it does not seem that PDS has UpdateProject or UpdateTask methods.   I can create/delete project and tasks but I cannot up date them using PDS.   How do you update Project and Task data for Project 2003 using PDS?

Thanks.
Avatar of Bembi
Bembi
Flag of Germany image

Have a look here, where you should find everything about PDS
http://support.microsoft.com/kb/823530/en-us
Avatar of ChrisClement
ChrisClement

ASKER

Thanks, but it doesn't really answer my question.  I need to be able to update project info and tasks from PDS, but I am not finding methods to do this.  So is there no way to update project and tasks using PDS?
SOLUTION
Avatar of Bembi
Bembi
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
PDS sucks for the reasons you've noted.  

I use VBA in Project Professional.  It takes some getting into but you can open projects, add tasks, basically do anything you want, from within the VBA environment.  This approach also has the advantage that you do all the security authentication when you connect to Project Server using the fat client.  More advanced is the ability to create user-forms that open from toolbar buttons so that the user gets indications of what's happening, progress bars, etc.

Although you'll have to add an ADO reference first, you can also connect to SQL databases and read and write data from/to SQL databases using the VBA language.
MSProjectGeek,

You can do all that in C# as well.  I didn't get into the whole story about what we are having to try to do as I was hoping for a simple answer (that evidently doesn't exist).  What we have to do is essentially save any changes that are made in Project to a second database server (oracle).  The requirements we have state that we have to do this in realtime and we cannot use replication (political reasons).   So using the PDS with its autopublish functionality was the chosen method to do this.  Obviously wasn't made for this, but we are trying to pound that square peg into the round hole anyway.    

If you have any alternative methods of accomplishing this....I'm all ears.  :-)

Chris
Bembi,

Thanks for the info.  Regarding workaround #2, I read in a whitepaper on MSDN that manipulating the data directly could cause corruption.  MS BS?

Thanks.

Chris
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Aight, Geek.  I'll go and try to digest all this and post more questions if I get stuck.  Thanks to both you and Bembi for the help.  I'm going to split the points between you.

Talk to you soon (probably REAL soon). :-)
I just re-read you comments.

I have working examples of integrating Project Professional 2003 (connected to Project Server 2003) with remote databases.  This functionality includes.

- Reading an import file from a SQL table and creating new Projects on the server that are created from Enterprise templates
- Automatic assignments made from the names provided in the SQL table
- User forms showing progress bars as the queue is imported - the forms test the group membership of the logged on resource - if the resource is not a member of the Admin group, they don't get to run the form - this actually calls a PDS command and parses the returned XML code
- error trapping and application of business rules
- Changes in the Project database trigger messages to remote systems to update data
- SQL sprocs that act on the Project Server database for unavailable functions and reporting

In other words, I can make Project Pro do what you want.
Thanks, sounds like there is a price tag at the end though.   :-)    Unfortunately, this project is for the government and not to say they are ultra-cheap...but they're not going to buy any third party products (hint: ultra-cheap).  

Cheap old Government eh? I don't work for free but my rates are reasonable - if this is something I can do in a hour then that can be free within the spirit of Experts Exchange.  From what you've said it is very likely more complicated than that.  If you're willing to share the requirements with me in more detail then I can obviously give you a better idea of how I would approach it and give a guestimate of time.  Email me at Ted@Portfoliopm.com if you are interested.