another special characters question. (slight twist)

[bikerjohn]

Project server 2007.
I have a field in a sharepoint list that I am trying to map to a custom
field in Project. My question is, If I map the sharepoint field to a custom
field using an using an outline code, will using a - as a seperator charactor
cause any problems in the database? the sharepoint field looks like:
IT12345.IT-Customer Service
I made a look up table using the IT12345 as the top level, the IT as the 2nd
level and the customer service as the 3rd level using the . as the 1st
seperator and a - as the 2nd seperator.

2nd part of the question. My ultimate goal is to have a script that keeps
the resource pool and the sharepoint list in synch. Although I am not looking
for details at the moment, I am wondering if it would be much extra work to
make the script smart enough to see IT12345.IT-Customer Service and write it
correctly to the above outline code?

 

[Gary L. Chefetz]

John:

You should be OK using the code mask as specified. I'm not at all certain
what you're asking in the second part of the post. Maybe you could re-ask
that if nobody else jumps in.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Jonathan Sofer [MVP]]

It sounds like you want to update the lookup table in Project Server 2007
using PSI (Project Server Interface) calls. The lookup table is used in an
enterprise resource custom field, correct?

It is feasible but what I would be most concerned about is the logic that
you follow in order to update the lookup table. The reason is you need to
know whether a value is new or updated. If you are updating a value, if you
delete and re-create a the value in the lookup table, it will lose all
associates with any existing resources. However, if you update a value in
place, it will remain associated to all existing resources.

So the way you update the lookup table value could produce dramatically
different results depending on how you do it.

Jonathan Sofer