Is there a way to print the import map assignments?

[kza40381]

Once you have assigned your field names, is there a way to print what you
have assigned?

 

[John]

Once you have assigned your field names, is there a way to print what you
have assigned?

kza40381,
None that I know of although it may exist somewhere in Project's
database. One "simple" thing you can do is to get a screen shot when you
make the map assignments and then print that out.

John
Project MVP

 

[JackD]

Once you have assigned your field names, is there a way to print what you
have assigned?

I don't have project 2002 around to check, but something like this should
work for Proj 2002 and later:

Sub fieldTitles()
Dim myFieldType As String
For i = 1 To 20
myFieldType = "pjCustomTaskText"
MsgBox CustomFieldGetName(FieldNameToFieldConstant(myFieldType & i, pjTask))
'CustomFieldGetName (myFieldType)
Next i
End Sub

You can put it in the middle of a loop which prints things out.

I'll see if I can get some tested working code on Monday.

-Jack Dahlgren

 

[John]

I don't have project 2002 around to check, but something like this should
work for Proj 2002 and later:

Sub fieldTitles()
Dim myFieldType As String
For i = 1 To 20
myFieldType = "pjCustomTaskText"
MsgBox CustomFieldGetName(FieldNameToFieldConstant(myFieldType & i, pjTask))
'CustomFieldGetName (myFieldType)
Next i
End Sub

You can put it in the middle of a loop which prints things out.

I'll see if I can get some tested working code on Monday.

-Jack Dahlgren

Jack,
If I read the post correctly I think the user wants to print out the
import mapping, not the custom field names....but then again, I could be
wrong.

John

 

[JD]

Hmmm... Maybe you are right...
Ctrl + Printscreen then paste into a document?

-Jack Dahlgren

 

[John]

Hmmm... Maybe you are right...
Ctrl + Printscreen then paste into a document?

-Jack Dahlgren

Jack,
Yeah, that's what I said in my reply and it's the only "simple" approach
I could think of.

John

 

[kza40381]

Good morning Gentlemen...my apologies for not replying sooner, as I was out
of the office. I was hoping to be able to print out or export the field
assignments from my import from excel once the map has been created. As an
example,
Excel Name vs. MS Project Field Name
Study_Id = Text 1
Study_Phase = Text 2
Concept_Protocol_Approved = Start 1, etc.

Thank you all for your help on this.

 

[Rob Schneider]

I don't have project 2002 around to check, but something like this should
work for Proj 2002 and later:

Sub fieldTitles()
Dim myFieldType As String
For i = 1 To 20
myFieldType = "pjCustomTaskText"
MsgBox CustomFieldGetName(FieldNameToFieldConstant(myFieldType & i, pjTask))
'CustomFieldGetName (myFieldType)
Next i
End Sub

You can put it in the middle of a loop which prints things out.

I'll see if I can get some tested working code on Monday.

-Jack Dahlgren

Jack,

Did you ever make the code for this? I'd find it extremely useful...

 

[kza40381]

Thank you all for your work on this. And, am happy Rob, that you would find
it helpful. I've been wanting it for a long time.

 

[JD]

Rob,

No, I didn't. After the original poster said he was looking for something
different I gave up. Remind me again next week and I'll see if I can put it
together.

-Jack