special character on resource name

P

pietro.gottardi

Hi, I would like to use [ and , for the resource name.
When I synchronise AD in project server 2007 the [ is change in { and
the , in ;
Do anyone know why?
In wss 3.0 sites (not the project server site) there are not problem.

thanks
 
J

Jonathan Sofer

Project Server has many special character restrictions and specifically the
AD synch has been tweaked to fix the issue users were experiencing with []
and , where by the synch job would fail. What they did was write some code
that would do a replace of [] with {} and replace , with ;

I always recommend not to use any special characters in resource names,
custom names and values or project names as this can cause the analysis
services/cubes to hiccup.

I am sure you don't like my answer but it is what it is.

Sorry, Jonathan
 
G

Gary L. Chefetz [MVP]

Pietro:

The answer to this specific question is that the "," (comma) is the list
separator character in SQL server, which would cause the system to see the
string "Gottardi, Pietro" as two resources, Gottardi and Pietro. To prevent
this, the system switches the characters for you. As Jonathan recommends, do
not use non-alpha-numeric characters in Project Names, Resource Names and
Task Names, to avoid any problems. You can safely use the underscore
character. Others may or may not cause problems, but why take the chance?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
R

rossi324

Pietro:

The answer to this specific question is that the "," (comma) is the list
separatorcharacterin SQLserver, which would cause the system to see the
string "Gottardi, Pietro" as two resources, Gottardi and Pietro. To prevent
this, the system switches the characters for you. As Jonathan recommends, do
not use non-alpha-numeric characters inProjectNames, Resource Names and
Task Names, to avoid any problems. You can safely use the underscorecharacter. Others may or may not cause problems, but why take the chance?

--

Gary L. Chefetz, MVP
MSProjectExperts
ForProjectServerConsulting:http://www.msprojectexperts.com
ForProjectServerFAQS:http://www.projectserverexperts.com


Hi, I would like to use [ and , for the resource name.
When I synchronise AD inprojectserver2007 the [ is change in { and
the , in ;
Do anyone know why?
In wss 3.0 sites (not theprojectserversite) there are not problem.
Click to expand...
Click to expand...
Thank you to all for the good explanation but I have an other
question: Why if I add a user in a sharepoint site (not created by
project server) I can see comma and [ ] ?
Maybe the problem is only with the cube creation!

---Others may or may not cause problems, but why take the chance?
Unfortunately the name of user-account, in AD, is write with comma
etc..etc to prevent a problem of the same first name end surname

Thanks
 
Top