Covert local userdefined fields to Enteprise ones

[Hadi]

Hello Experts,
i have some local userdefined fields that i like to make enterprise
userdefined fields. i am an administrator and have access to all of the
enterprise fields. i can probably copy and paste from one to another. but
am sure there is a slick way of doing it using a macro or something like that

help is always appreciated

 

[John]

Hello Experts,
i have some local userdefined fields that i like to make enterprise
userdefined fields. i am an administrator and have access to all of the
enterprise fields. i can probably copy and paste from one to another. but
am sure there is a slick way of doing it using a macro or something like that

help is always appreciated

Hadi,
If there aren't very many (let's say 10 to 15), I'd go ahead with the
copy and paste. If there are more than just a few a simple macro could
be written but in order to write the code it would be helpful to know
which fields need to be translated.

John
Project MVP

 

[Hadi]

John,
you are right, i have less than 10 fields to do but the problem is am
dealing with about 35 files and about 16,000 lines to copy and paste. as far
as the macro, can you give me something as an example and i can change the
fields as i like. also, some of these fields are outlinecodes that need to
go to Enterprise outlinecode, can i still use the same code?

 

[John]

John,
you are right, i have less than 10 fields to do but the problem is am
dealing with about 35 files and about 16,000 lines to copy and paste. as far
as the macro, can you give me something as an example and i can change the
fields as i like. also, some of these fields are outlinecodes that need to
go to Enterprise outlinecode, can i still use the same code?

Hadi,
If the user defined fields are task based the following code should
work. Note, you will need to have a separate line of code for each field
you want to transpose.

Sub Transpose_Fields()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.EnterpriseText1 = t.Text1
t.EnterpriseOutlineCode1 = t.OutlineCode1
End If
Next t
End Sub

John
Project MVP

 

[Hadi]

John,
thanks for the code. i have one question, for the enterpriseoutlinecode1,
if i open the enterprise global template, there is enterprisetaskoutlinecode1
and enterpriseprojectoutlinecode1. i need the enteprisetask not
enterpriseproject. however, when i run the code you gave me with
enterpriseoutlinecode1, i get an error message saying "Enterprise Outline
Code" is not defined. what is the correct syntax for the Enterprise Task
Outline codes??

 

[John]

John,
thanks for the code. i have one question, for the enterpriseoutlinecode1,
if i open the enterprise global template, there is enterprisetaskoutlinecode1
and enterpriseprojectoutlinecode1. i need the enteprisetask not
enterpriseproject. however, when i run the code you gave me with
enterpriseoutlinecode1, i get an error message saying "Enterprise Outline
Code" is not defined. what is the correct syntax for the Enterprise Task
Outline codes??

Hadi,
The macro I gave you IS for task enterprise outline code. If you are
getting an error I suspect that perhaps the outline codes you have are
either defined for a resource object or are in fact defined at the
project level.

John
Project MVP

 

[Hadi]

John,
so what can i do to fix it?


I am sorry but what do you mean by "

 

[John]

John,
so what can i do to fix it?


I am sorry but what do you mean by "

Hadi,
Well, if the outline codes are at the resource or project level, then
the macro needs to be changed accordingly. In other words, "fixing" it
depends on what you have and what you want.

And what is the context of your last sentence (i.e. "I am sorry but what
do you mean by "")?

John
Project MVP

 

[Hadi]

John,
the way i define my outline codes is as follow

in MS Project i go to tools --> Enterprise Options --> then Open Enterprise
Global. i get a blank project then i go to tools --> customize -->
Enterprise Fields.

i then click on the custom outline codes. there, i have 3 radio buttons
(task, resource, project). i go there and define the "enteprise task outline
codes"

i hope i am making myself clear.

 

[John]

John,
the way i define my outline codes is as follow

in MS Project i go to tools --> Enterprise Options --> then Open Enterprise
Global. i get a blank project then i go to tools --> customize -->
Enterprise Fields.

i then click on the custom outline codes. there, i have 3 radio buttons
(task, resource, project). i go there and define the "enteprise task outline
codes"

i hope i am making myself clear.

Hadi,
That seems pretty clear, but unfortunately I've helped about as much as
I can. I do not use Project Server and therefore don't have an
enterprise global. Try posting on the server newsgroup:
microsoft.public.project.server
The MVPs who respond there are fully conversant in the Server version.

Sorry I couldn't help more.
John
Project MVP