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.

Switching off auto numbering of tasks

8 replies [Last post]
Thu, 2008-04-10 09:30
Steve Lindsay
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 28 Jun 2006
Posts: 8
Groups: Petro-Chem / Oil & Gas
I’m currently merging schedules from various subcontractors in to one Primavera P3.1 integrated schedule.

The main subcontractor has resubmitted his MS Project schedule and has added 50+ tasks. As projects is want to do it has automatically renumbered everything in a nice 1 to 500 sequence.

By choice it is 10+ years since I have used MS Projects in anger but if I recall correctly you could switch auto numbering off. (I know you can stop it renumbering when you sort, but this does not stop the adding/deleting renumbering)

Anyone have an idea? as I do not want to have to manually renumber in P3 every time I receive an update.

Cheers,
Steve.

Edit: I’m using MS Projects 2003 and subcontractor is using MS Projects 2007
Top

Replies

Thu, 2008-04-10 11:28
#1
L.E.N. Lewis
User offline. Last seen 2 years 1 week ago. Offline
Joined: 2 Aug 2007
Posts: 47
Groups: None
One other thing: using the UniqueID means that you don’t have to worry about the Predecessor/Successor numbers -- which is why you rejected the use of the Number fields. "Unique ID Predecessor" and "Unique ID Successor" will meet your requirements.
Top
Thu, 2008-04-10 11:20
#2
L.E.N. Lewis
User offline. Last seen 2 years 1 week ago. Offline
Joined: 2 Aug 2007
Posts: 47
Groups: None
The ID number is derived and dynamic.

You don’t have to display it (but why would you want to do that) by clicking on View | Table:XXXXX | More tables... selecting the appropriate table and then deleting it from the columns displayed.

If you want to work with a number that is unchanged then display "Unique ID". It is *generally* constant and is unchanged if you drag-and-drop tasks as you move them around in the schedule. If, however, you choose to cut-and-paste as you move them then the paste operation will, unsurprisingly, create a new Unique ID for the task.

Since your main complaint seems to be the renumbering when somebody added tasks, why don’t you just use one of the many Number fields. You would be able to control exactly what numbers are used and what the mean instead of trying to impose your order on something that is, by definition, not supposed to be anything other than dynamic.

Finally, since you are merging everything into a P3.1 schedule, I really don’t see why you’ve even raised the issue. Your project is clearly big enough for you to either purchase a P3.1 license for the contractor or to insist that the contractor use P3.1 if he is to continue participating in the project because, quite frankly, if this is your greatest concern on your project then you clearly have a project that is humming along *exceptionally* smoothly -- be thankful for your project blessing.
Top
Thu, 2008-04-10 11:15
#3
Steve Lindsay
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 28 Jun 2006
Posts: 8
Groups: Petro-Chem / Oil & Gas
Unfortunately not, I had considered this but it doesn’t help with predessessor and successors.

Regards,
Steve.
Top
Thu, 2008-04-10 10:46
#4
Darren Kosa
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Apologies, headed into a bit of a rabbit hole. :)

However, I believe it will still be the same as the scenario you mentioned... they are automatically calculated by MS Project.

I presume using a custom number field and cutting and pasting from the Task ID is out of the question?

Regards,

Darren
Top
Thu, 2008-04-10 10:23
#5
Steve Lindsay
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 28 Jun 2006
Posts: 8
Groups: Petro-Chem / Oil & Gas
Thanks again for your response, but I don’t mean the outline number.

I mean task ID the first column on the left when you open MSP.


Below from MSP Help:

ID fields
Show All
Hide All
The ID field contains the identifier number that Microsoft Office Project automatically assigns to each task or resource as you add them to the project. The ID indicates the position of a task with respect to the other tasks or a resource in relation to other resources.

There are several categories of ID fields. Learn more about field categories.

Data Type Integer (integer field: A type of field whose content is a whole number. Examples include the ID and Unique ID fields.)

ID (task field)

Entry Type Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated As you create tasks, Project automatically assigns the next number in the sequence of tasks as listed. This becomes the task ID.

Best Uses Use the ID field in a task view when you want to display or filter the task ID.

Example If you have three tasks entered in sequence, their task IDs are 1, 2, and 3. If you insert a new task between task 2 and task 3, the inserted task becomes task 3, and the previous task 3 becomes task 4.

Remarks When you insert, move, or delete a task, Project automatically updates the ID numbers so that the ID numbers always reflect the current task order. After deleting or moving tasks, if you want to return tasks to their original order, use the Unique ID field instead of the ID field.


I’m now searching for "choice of calculation settings"

Cheers,
Steve.
Top
Thu, 2008-04-10 10:13
#6
Darren Kosa
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Ahh, bugger. I was afraid you were going to say that!!

As far as I’m aware you cannot edit / change outline numbers as they are automatically calculated by MS Project.

You can edit / change WBS custom outline codes but these aren’t the ones in the ID column.

I’ll try and do a bit of investigation, but I’m not overly confident you can.

Regards,

Darren
Top
Thu, 2008-04-10 09:52
#7
Steve Lindsay
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 28 Jun 2006
Posts: 8
Groups: Petro-Chem / Oil & Gas
Hi Darren,

No I mean the task ID.

Regards,
Steve.
Top
Thu, 2008-04-10 09:46
#8
Darren Kosa
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Hi Steve,

Do you mean that the outline numbers (WBS code essentially) are showing in the Task Name (Description) column?

If you do then try Tools > Options > View and uncheck the ’Show Outline Number’ box.

This is how you would do it for MS Project 2003 I couldn’t definitively say if it is the same in 2007.

Hopefully this is what you’re after.

Regards,

Darren
Top