Table named &entry that cannot be overwritten?

[TEC]

When I import a project in PS. I open the project later and I recieve the
message that there is a table named &Entry that cannot be overwritten. I
don't have a table in the Enterprise global named that. All that is in the
global is the standard tables that it came with. I have to rename the table
in order for it to let me open the project And then I end up with 2 tables
one called entry and the other called whatever I renamed it to. What is the
difference between the entry table and the enterprise entry table. How I get
a project plan into PS is I create it and then I go to import it to
enterprise. I don't add any tables or anything. I don't add the resources
until it is in PS. Am I adding the projects to PS in a wrong manner.

 

[Reid McTaggart]

This is common. "&" is Microsoft's way of notating which (if any) letter of
the table name is the keyboard shortcut. So, &Entry denotes the entry table,
which doees exist in your Enterprise Global.

The file you are importing also has a table named Entry. Project Server
will not permit two tables with the same name, so it insists you rename the
one on your imported project. Essentially, PS helps you create a custom
table.

The same thing can happen with an enterprise project in which someone
modifies the Entry table and saves the project. On the next open, PS will
insist on a new name for the table. The most common mode is that a user adds
or deletes a column from the Gantt view, which is driven by the Entry table.

When it happens to me, I just add a one (1) to the end of the name. Later,
I can clean up the tables and views at my leisure.

-Reid

 

[TEC]

how do you mean clean up the views? What I would like to do is just be able
to import the project into PS and not have to worry about getting prompted
for this. Can I delete the entry table from the global template to fix this?
How exactly do you clean this up later because I dont' want a table named
entry and then on named entry1

 

[Reid McTaggart]

You can rename a view by going to View, More Views, then select the view and
click Edit. There, you can change the name. Same approach for Tables: View,
Tables, More Tables.

You could rename the Entry table in your Enterprise Global. Then, the
projects you import would come in with a custom (non-enterprise) table called
Entry that would not conflict with Enterprise Global. since the Entry table
usually is used to drive the Gantt Chart view, you likely would need to
rename the Gantt Chart in Enterprise Global as well to avoid a similar
conflict.

In my opinion, this is not generally a good practice from an Enterprise
Project Management perspective, but if it's what you want to do, you can do
it.

-Reid

 

[TEC]

So in the end do you usually end up with having a table called entry and a
table called entry1. Is that how you leave yours. I tried renaming the table
that was in my project before importing it to PS but it still came up and
asked me this. And it also asked about replacing filters. Another install of
PS I did before I don't ever remeber this happening and I am not doing
anything different this time.

 

[Gary L. Chefetz [MVP]]

TEC:

See the following FAQ for an explanation and a cure:

http://www.projectserverexperts.com/Shared Documents/cantoverwriteobject.htm

 

[Anonymous]

Hi Gary,

This URL is inaccessible. Could you please somehowprovide the details on
this website. I am facing the same problem and wants to know the resolution.

Thanks
Rajesh

 

[Gary L. Chefetz [MVP]]

Try the URL again.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project