Storing task values in custom table on save

[yashr]

I need some help with creating customized project guide. I am new to MS
project.

We are using project 2003/SQlServer and Project Server.
We have a template with some customized task fields.
When the user goes to save this project, we want to insert selected tasks
based on the id in the customized field into a custom table with
unique_id(sequence gen) along with some task information in addition to MS
Project saving its data to the database as usual.

Do I have to write a VBA to do the above? Any advice on where to start, how
to approach this and/or how to go about doing this is appreciated.

Ex:Template:
Task_name Custom
Task 1 100
Task 2 210
Task 3 300
Task 4 300

Custom Table :

Project_id Unique_id Task_name
101 1 Task1
101 2 Task 3
101 3 Task 4

In this case I need to save the tasks with 100 and 300 to a custom table.

Thanks -

 

[Earl Lewis]

yashr,

My recommendation would be that you look into doing this via triggers in SQL server. You predefine the appropriate custom table structure in your current project server database or another database on the same SQL server as your project database. Then you write triggers on appropriate tables that fire upon insert or update and copies the required data into your custom table.

If you do it on the SQL server you don't have to worry about any VBA coding on the client side - SQL server takes care of it for you.

Earl
I need some help with creating customized project guide. I am new to MS
project.

We are using project 2003/SQlServer and Project Server.
We have a template with some customized task fields.
When the user goes to save this project, we want to insert selected tasks
based on the id in the customized field into a custom table with
unique_id(sequence gen) along with some task information in addition to MS
Project saving its data to the database as usual.

Do I have to write a VBA to do the above? Any advice on where to start, how
to approach this and/or how to go about doing this is appreciated.

Ex:Template:
Task_name Custom
Task 1 100
Task 2 210
Task 3 300
Task 4 300

Custom Table :

Project_id Unique_id Task_name
101 1 Task1
101 2 Task 3
101 3 Task 4

In this case I need to save the tasks with 100 and 300 to a custom table.

Thanks -