Junk character '#' comes in Project description and WBS description...

[Former Member]

Dear all,

When we transfer and release the project from C-projects module to PS,

then sometime, a junk character like "#" gets appended to the Project &

WBS description, when we retrive the Project in CJ20N. This junk

character creates a lot of problems in the reports, specially, when it

is exported to excel. due to this, all columns gets shifted in the

excel. After a lot of simulation, we found that if we unintentionally

give some spaces in the c-project description, then the junk character

gets appended to the PS description. What is the remedy ?? what should

be done to avoid this ???

Can any of you advise on this?

Thanks,

Kumar

[Former Member]

thanks

[Former Member]

Dear Kumar;

This was also happening to me while uploading Project and WBS from Excel file.

Remedy: for Description Column, copy and paste it on a sperate excel sheet, and apply Trim fromula to erase extra spaces in the begining and end of field.

Now save that 2nd sheet with only description column as text TAB format from excel. and close the file.

Now open that text tab file in excel and copy and p[aste this description column to original Upload file.

This will resolve your issue.

[Former Member]

Hi

Thanks for your reply.

But what about which we have already uploaded ?

One more thing I want to know....

Do u upload to Cprojects or PS.

If it is to cprojects please let me know the procedure to upload.

Thanks,

Kumar

[Former Member]

Hi;

for already uploaded description, you can run the upload program, but just for Description filed.

You will be having two fileds, Project ID, and Project Description.

It can easily be created through LSMW.

For testing Purpose if you are not sure try it in your Dev or QA server for few projects.