Import dependency information?

[dgmoore]

I need to import into a Project file dependency information that is
maintained in an external database. The Project table that stores
pred-succ info, msp_links, is not directly accessible via ADO or
through the UI.

As far as I can tell, the only way to populate data to msp_links is to
physically link each pair of tasks, which can be done programmatically
via LinkTasksEdit. Physically linking from Task I to Task J writes a
record to msp_links, setting link_pred_uid and link_succ_uid
appropriately.

Can anybody suggest an alternative way of getting this information into
msp_links?

Thanks
Dave

 

[Rod Gill]

There are only two ways, both will require you export the data in your db to
a csv or xls file if direct reading is not possible:
1) Use automation in Project to add the references then re-save
2) Directly add records to the MSP_Links table CAREFULLY following all
details in the pjdb.htm file (in one of Project's program folders).

Both methods will also require that the Task ids in your db match the Ids
currently in your project file.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com