Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
Exporting custom lookup attribute to MSP
Question asked by
on Mar 10, 2009
on Nov 5, 2010 by Rajani
Show 0 Likes
Could you please share detail on how custom lookup attributes can be exported to MSP? Thx
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 3 comments
(Required, will not be published)
Mar 29, 2009 1:02 AM
You need to insert a row into the MSPField table in the database with the following column values: PRID: A unique IDPRNAME: lowercase name of your custom attributeMSPNAME: Custom column in MSP that you want to hold this value (e.g. Text1, Text2, Flag1, Flag2, etc)PRTYPE: The type of field you are exporting: 1= project 2=resource 3=task 4=assignment 5=team PRFLAGS: Indicates whether you want this to be Import only (1) Export only (2) or Import and Export (3). For example, if you set this to 2 (Export only) then the value will be sent to MSP, but changes the user makes to this value in MSP will not be saved back to Clarity. Note that this will only export and import the value of the lookup--it will not export a drop down list to MSP with all of the possible lookup values. If you want to provide your MSP users with the dropdown so they know what values to choose from, what you can do is deploy a standard Global.mpt file to your users that has this drop down defined in it. For example, if you define in the MSPFIELDs table that you are going to export your custom lookup to Text 20, then you can create a drop down on the Text20 field in MSP with the same values as the lookup in Clarity, then save these changes to your Global.mpt, and distribute this to your users. All new MSP files will then get this dropdown in them by default. However, if the values of the drop down will be changing often, this might not be a good solution. Also, project plans that have already been created will not get the dropdown (although the users could import it from Global.mpt). Message Edited by pdjohnson on 03-29-2009 01:02 AM [left]
Show 2 Likes
Mar 31, 2009 3:25 PM
Thanks for your response and Before posting to forum I did try as you mentioned above on how custom attributes to be added to MSPFIELDS table. I couldn't see the internal lookup values being brought to Microsoft Project with Clarity R12 version.
Show 0 Likes
Nov 5, 2010 8:22 PM
I have similar requirement. Have you figured out how to use lookup values in MSP?
Show 0 Likes
Retrieving data ...
file_canRead, file_exist always return false
How To: Upgrade DevTest 9.5.1 to 10.3
Spectrum Integration with Tivoli Enterprise Console
PM Self Certification question
Validate 2 fields