Oracle Primavera - PM6 Member for 23 years 11 months Member for 23 years 11 months Submitted by David Forrest on Wed, 2008-08-06 08:25 Permalink RE: Help for Global change in P6 Did you try edit>replace!! Member for 22 years 4 months Member for 22 years 5 months Submitted by Girish Batolar on Tue, 2008-08-05 10:38 Permalink RE: Help for Global change in P6 Thanks Guys Appericiate all the help. Any way found out how to do it the easiest way in 2 minutes by using global change SubString(Parameter,#,#) function Member for 18 years 9 months Member for 18 years 10 months Submitted by Dieter Wambach on Tue, 2008-08-05 08:00 Permalink RE: Help for Global change in P6 Hi Why dont you simply try: IF: Your condition / filter or leave blank if for all activities Then: "Activity ID" = X (i.e. the character you want to add) & "Activity ID" Dieter Member for 17 years 6 months Member for 17 years 6 months Submitted by Satya Narayana on Tue, 2008-08-05 07:45 Permalink RE: Help for Global change in P6 Export along with the relationships, you will have 2 sets of activities when you import back, delete the first set by fitering/sorting. Hope this works Member for 18 years 6 months Member for 18 years 6 months Submitted by Oliver Melling on Tue, 2008-08-05 06:57 Permalink RE: Help for Global change in P6 Export the project file into excel. Copy the activity id column into column B in a new spreadsheet. In column a put the prefix you want to put in front of your activity id. In colum c type the formula =column a&column b Drag this down so that it is done for every activity. Copy column c and paste special values back into the exported project file. Save it, then import back into primavera. Member for 22 years 4 months Member for 22 years 5 months Submitted by Girish Batolar on Tue, 2008-08-05 06:51 Permalink RE: Help for Global change in P6 Hi Oliver Thanks but this will not work as i have the logic already defined and by what you are telling me will only create new id in primavera. I wanted to know the steps for adding a charecter in fornt of the activity ID using Global change. Can any one give me the steps. Thanks Member for 18 years 6 months Member for 18 years 6 months Submitted by Oliver Melling on Tue, 2008-08-05 04:07 Permalink RE: Help for Global change in P6 Exoprt the project into excel, change the activity id, then import back into primavera. Member for 19 years Member for 19 years Submitted by Ronald Romero on Tue, 2008-08-05 04:04 Permalink RE: Help for Global change in P6 Hi Girish, try to play around with the given Modify Activity IDs example of P6. You can you this function to extract text from you Activity ID which are Substring, Rightstring and Leftstring. Log in or register to post comments
Member for 23 years 11 months Member for 23 years 11 months Submitted by David Forrest on Wed, 2008-08-06 08:25 Permalink RE: Help for Global change in P6 Did you try edit>replace!!
Member for 22 years 4 months Member for 22 years 5 months Submitted by Girish Batolar on Tue, 2008-08-05 10:38 Permalink RE: Help for Global change in P6 Thanks Guys Appericiate all the help. Any way found out how to do it the easiest way in 2 minutes by using global change SubString(Parameter,#,#) function
Member for 18 years 9 months Member for 18 years 10 months Submitted by Dieter Wambach on Tue, 2008-08-05 08:00 Permalink RE: Help for Global change in P6 Hi Why dont you simply try: IF: Your condition / filter or leave blank if for all activities Then: "Activity ID" = X (i.e. the character you want to add) & "Activity ID" Dieter
Member for 17 years 6 months Member for 17 years 6 months Submitted by Satya Narayana on Tue, 2008-08-05 07:45 Permalink RE: Help for Global change in P6 Export along with the relationships, you will have 2 sets of activities when you import back, delete the first set by fitering/sorting. Hope this works
Member for 18 years 6 months Member for 18 years 6 months Submitted by Oliver Melling on Tue, 2008-08-05 06:57 Permalink RE: Help for Global change in P6 Export the project file into excel. Copy the activity id column into column B in a new spreadsheet. In column a put the prefix you want to put in front of your activity id. In colum c type the formula =column a&column b Drag this down so that it is done for every activity. Copy column c and paste special values back into the exported project file. Save it, then import back into primavera.
Member for 22 years 4 months Member for 22 years 5 months Submitted by Girish Batolar on Tue, 2008-08-05 06:51 Permalink RE: Help for Global change in P6 Hi Oliver Thanks but this will not work as i have the logic already defined and by what you are telling me will only create new id in primavera. I wanted to know the steps for adding a charecter in fornt of the activity ID using Global change. Can any one give me the steps. Thanks
Member for 18 years 6 months Member for 18 years 6 months Submitted by Oliver Melling on Tue, 2008-08-05 04:07 Permalink RE: Help for Global change in P6 Exoprt the project into excel, change the activity id, then import back into primavera.
Member for 19 years Member for 19 years Submitted by Ronald Romero on Tue, 2008-08-05 04:04 Permalink RE: Help for Global change in P6 Hi Girish, try to play around with the given Modify Activity IDs example of P6. You can you this function to extract text from you Activity ID which are Substring, Rightstring and Leftstring.
Member for
23 years 11 monthsRE: Help for Global change in P6
Did you try edit>replace!!
Member for
22 years 4 monthsRE: Help for Global change in P6
Thanks Guys
Appericiate all the help. Any way found out how to do it the easiest way in 2 minutes by using global change
SubString(Parameter,#,#) function
Member for
18 years 9 monthsRE: Help for Global change in P6
Hi
Why dont you simply try:
IF: Your condition / filter or leave blank if for all activities
Then: "Activity ID" = X (i.e. the character you want to add) & "Activity ID"
Dieter
Member for
17 years 6 monthsRE: Help for Global change in P6
Export along with the relationships, you will have 2 sets of activities when you import back, delete the first set by fitering/sorting.
Hope this works
Member for
18 years 6 monthsRE: Help for Global change in P6
Export the project file into excel.
Copy the activity id column into column B in a new spreadsheet.
In column a put the prefix you want to put in front of your activity id.
In colum c type the formula =column a&column b
Drag this down so that it is done for every activity.
Copy column c and paste special values back into the exported project file.
Save it, then import back into primavera.
Member for
22 years 4 monthsRE: Help for Global change in P6
Hi Oliver
Thanks but this will not work as i have the logic already defined and by what you are telling me will only create new id in primavera.
I wanted to know the steps for adding a charecter in fornt of the activity ID using Global change.
Can any one give me the steps.
Thanks
Member for
18 years 6 monthsRE: Help for Global change in P6
Exoprt the project into excel, change the activity id, then import back into primavera.
Member for
19 yearsRE: Help for Global change in P6
Hi Girish,
try to play around with the given Modify Activity IDs example of P6. You can you this function to extract text from you Activity ID which are Substring, Rightstring and Leftstring.