Sql code to update worktime,%completion, finish_date ... with Ms_project 2002

[florent]

Hi,
I'm making my own web project server using a local web site developed on php
linked with SQLEXPRESS which is linked with MS_Project 2002 Standard.

All would work well if i had no issue with my update SQL code.

Is anybody knows the code or some tips to succeed in updating my tasks. I
want to change Work, actual work, remaining work, % completion and actual
finish date.

I update MSP_TASKS, MSP_ASSIGNMENTS with this values and i insert former
ones in EXT_EDIT_REF_DATA but it still doesn't work well. In fact when i
come back into MS_project i have a random worktime, duration, %completion...
on the updated task.

I think that there is something to do with MSP_TIMEPHASED_DATA but i don't
know really how to manage this with all informations it contains.
I think it should work if i delete in it all lines belonging to the task i
want to update.

I'm looking forward to any help.

Thank you and forgive my English if it's not well written (i'm french)

url:http://www.ureader.com/gp/1117-1.aspx

 

[Lars Hammarberg]

(Project 2002... It's been quite a while now, but I'll give it a shot)
If I remember correctly, the EXT_EDIT_REF_DATA takes a string in which the
various fields edited are represented with previous values if modified and
this string is position-based - that is - if you modify the 8th field in the
list, the string looks something like this '1,,,,,,,,oldvalue' (probably
followed with other modified fields in the corresponding position)
You must also set the ext_edited field to '1' in the project table for the
corresponding project.

 

[Rod Gill]

Just a note, Project 2007 onwards no longer allow saving to database, so
your solution has limited life I'm afraid.

One option is to use Project VBA to read progress data from SQL Server. That
would be version independent.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

(Project 2002... It's been quite a while now, but I'll give it a shot)
If I remember correctly, the EXT_EDIT_REF_DATA takes a string in which the
various fields edited are represented with previous values if modified and
this string is position-based - that is - if you modify the 8th field in
the list, the string looks something like this '1,,,,,,,,oldvalue'
(probably followed with other modified fields in the corresponding
position)
You must also set the ext_edited field to '1' in the project table for the
corresponding project.

--

/Lars Hammarberg
www.camako.se
Microsoft Gold Certified Partner





__________ Information from ESET Smart Security, version of virus
signature database 4983 (20100329) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4983 (20100329) __________

The message was checked by ESET Smart Security.

http://www.eset.com