Extended Attributes (to map IDs)

[Praveen Chandra]

Hi
I'm trying to integrate our product with project server. In this process, I
would be exporting tasks, resources and the assignments to MS Project
Server. I was able to do easily using ProjectCreate interface of PDS. In
Project server the tasks would be broken down further and more analysis
would be done and later at some stage I need to import/sync data
(duration/timelines) back from Project server to our product.

I have done some research and found that both UID/ID of the task in MS
Project server are changing when the project is opened through MS Project
Professional interface and modified. These two attributes(ID/UID) did not
seem to be dependable for mapping with our product' internal IDs, so I
started looking at the custom attributes of the MSP. I suppose these are
reffered as ExtendedAttribute in PDS. Unfortunately I am getting error when
I try to add ExtendedAttribute tag to the XML for ProjectCreate interface in
PDS.

I also need to get these custom attributes when I have to import/read
contents using
ProjectData interface of PDS.

I know one way of doing this is by extending the PDS by directly querying
the sql tables in a COM component. I read articles saying that it is not
best to query the MSP database tables directly. Also the XML schema
definitions for tasks already seem to have all of this information, I just
don't know how to use them.

Can someone please help me on the best/suggested ways to proceed with this??

Thanks in advance,
Praveen