There are lots of solutions on removing steps or activity step on your task or activity. If you are familiar with ODBC link to browse your data into databases like MSAccess you can delete the activity steps on TASKPROC table. You can also delete the activity steps on your xer export file and re-import it back to your P3e or P5. Another way is using sql command on your dos prompt. And last is using primavera SK or side kick and other API.
Here are some solution steps that you can use.
Sol 1: Steps using sql command on your dos prompt or window run command line.
1) Open a notepad and copy this command.
delete from taskproc where proj_id = ???
2) ??? is the project id. Replace it with your correct project id. You can find your projects Id when you import your data into excel spreadsheet or you can check it from the xer export file.
3) After replacing the correct project ID ex: 487 then save as test.sql on your drive c:
4) Type this command on window run command line:
osql -U sa -P prima -S localhost\primavera -d pmdb$primavera -i c:\test.sql
Note: you can also copy this command to new Notepad files and save as c:\test.bat
This will create a basic bat file or batch file, then on your run command line type c:\test.bat and click Ok.
If your Primavera is running when you run the command, the change will not reflect immediately. Press F5 to refresh your project and you will see that the steps are all deleted.
Sol 2: Step using xer export file.
1) Export your Project that you want to delete the steps or activity steps into xer file.
2) Open your xer file using WordPad or any text editor that can handle a huge file.
3) Press Ctrl+F to open a find dialog box
4) Type taskproc on the Findwhat textbox then click find next.
5) Your cursor should go to %T TASKPROC
Note: %T is a command on Primavera identifying the line as Table and %R is record or row.
6) Highlight from %T TASKPROC line up to the last %R of step using your mouse pointer and press delete.
7) Save your xer file and import it back to your Primavera and choose create new project.
8) You should have a new project without any activity steps assigned on each activity or task.
Sol 3: Step using ODBC link
1) Open the table TASKPROC from your database
2) Select all records containing project id that you need to delete and press delete.
3) If your primavera project is open when you delete the records from the database press F5 to refresh your project and you will notice that the steps assign previously are all gone.
There is a solution which would not delete the steps, but might help you.
Filter those activities you want to change, then change the %-complete type to duration or units. The steps then will be ignored by %-complete-calculation.
To physically remove the steps I dont know another solution than SQL or the API.
Member for
19 yearsRE: Gloabal Changes - Removing Step Progress
Mark,
There are lots of solutions on removing steps or activity step on your task or activity. If you are familiar with ODBC link to browse your data into databases like MSAccess you can delete the activity steps on TASKPROC table. You can also delete the activity steps on your xer export file and re-import it back to your P3e or P5. Another way is using sql command on your dos prompt. And last is using primavera SK or side kick and other API.
Here are some solution steps that you can use.
Sol 1: Steps using sql command on your dos prompt or window run command line.
1) Open a notepad and copy this command.
delete from taskproc where proj_id = ???
2) ??? is the project id. Replace it with your correct project id. You can find your projects Id when you import your data into excel spreadsheet or you can check it from the xer export file.
3) After replacing the correct project ID ex: 487 then save as test.sql on your drive c:
4) Type this command on window run command line:
osql -U sa -P prima -S localhost\primavera -d pmdb$primavera -i c:\test.sql
Note: you can also copy this command to new Notepad files and save as c:\test.bat
This will create a basic bat file or batch file, then on your run command line type c:\test.bat and click Ok.
If your Primavera is running when you run the command, the change will not reflect immediately. Press F5 to refresh your project and you will see that the steps are all deleted.
Sol 2: Step using xer export file.
1) Export your Project that you want to delete the steps or activity steps into xer file.
2) Open your xer file using WordPad or any text editor that can handle a huge file.
3) Press Ctrl+F to open a find dialog box
4) Type taskproc on the Findwhat textbox then click find next.
5) Your cursor should go to %T TASKPROC
Note: %T is a command on Primavera identifying the line as Table and %R is record or row.
6) Highlight from %T TASKPROC line up to the last %R of step using your mouse pointer and press delete.
7) Save your xer file and import it back to your Primavera and choose create new project.
8) You should have a new project without any activity steps assigned on each activity or task.
Sol 3: Step using ODBC link
1) Open the table TASKPROC from your database
2) Select all records containing project id that you need to delete and press delete.
3) If your primavera project is open when you delete the records from the database press F5 to refresh your project and you will notice that the steps assign previously are all gone.
Hope this help. Happy Planning!!!
Regards,
Rodel
Member for
19 years 2 monthsRE: Gloabal Changes - Removing Step Progress
Hi
You can find the answer here:
http://kpms.com.vn/forum/index.php?topic=25.0
Thanks & regard
Khuong
Member for
18 years 9 monthsRE: Gloabal Changes - Removing Step Progress
Hi Mark
There is a solution which would not delete the steps, but might help you.
Filter those activities you want to change, then change the %-complete type to duration or units. The steps then will be ignored by %-complete-calculation.
To physically remove the steps I dont know another solution than SQL or the API.
Regards
Dieter