Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Gloabal Changes - Removing Step Progress

3 replies [Last post]
Mark Porter
User offline. Last seen 7 weeks 3 days ago. Offline
Joined: 8 Aug 2007
Posts: 55
Groups: None
Hi All,

Does anyone have any idea how I could structure a global change that would remove step progress from any activities?
I am using steps to update the schedules physical % complete and would like to clear this field so that I can take a clean copy of the project.

Replies

Rodel Marasigan
User offline. Last seen 18 hours 52 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
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
Khuong Do
User offline. Last seen 16 years 29 weeks ago. Offline
Joined: 1 Sep 2006
Posts: 38
Groups: None
Hi
You can find the answer here:
http://kpms.com.vn/forum/index.php?topic=25.0

Thanks & regard
Khuong
Dieter Wambach
User offline. Last seen 6 years 49 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
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 don’t know another solution than SQL or the API.
Regards
Dieter