Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

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.

Activity ID Number Renumbering

2 replies [Last post]
Muhammad Saqib
User offline. Last seen 2 days 19 hours ago. Offline
Joined: 25 Oct 2018
Posts: 35
Groups: None

Dear All,

I have completed the schedule and i have added so many additional activities who has differenet Activity number. 

Started with A1000 and Ends with A11506 etc.

Now i want to Renumber the Activity ID with same activities sequence displayed. I followed this Youtube method (https://www.youtube.com/watch?v=S1ynA1wRwuc) and it works on small project but not in my current project. I mean it renumbered the ID but sequence is wrong. Activities ID is spreading in all other categories.

 

Replies

Santosh Bhat
User offline. Last seen 1 hour 26 min ago. Offline
Joined: 15 Apr 2005
Posts: 212

You can use XLS IMPORT to populate a Text User Defined Field with the new ID's you want to use, then run a Global Change to replace the ID's with the values in the UDF. Just make sure all the UDF values are unique.

Zoltan Palffy
User offline. Last seen 16 hours 19 sec ago. Offline
Joined: 13 Jul 2009
Posts: 2402
Groups: None

you will lhave to add the sequence into consideration in the global change