Creating Assignment - What ASSN_UID??

[Doug]

I am importing data from an external source, and I need to create a new
assignment for an existing task. I am using Proj Pro and Server 2002.

What ASSN_UID do I insert? The next highest ASSN_UID for that project?

I have read "PROJDB.HTM" and studied their example. It appears to me that I
must determine the highest ASSN_UID for that particualar project and
increment it by one. Is that correct?

This trivial task is becoming complex!

 

[Rod Gill]

Hi,

Yes, adding assignments and editing them directly in the database is
difficult. It is even harder when using Project Server because if you don't
sync things up carefully by publishing you can corrupt your projects very
easily. You need copious backups!!

Microsoft recommend that with Project Server you use PDS to modify projects.
This ensures that the database is kept safe. The Project 2002 SDK and MSDN
both have help on using PDS for updating projects via Project Server. If
this type of programming isn't for you then the next safest method is to use
automation directly on projects open in Project Professional. When the
project is saved this also safely updates Project Server.

Updating Project Server databases direct is very dangerous for your
schedules!! It is doable, but complicated to update the project database if
you are not using Project Server as well.