Dale
Mon Nov 22 09:31:15 CST 2004
Steve --
If your Project Server administrator has set permissions to allow you to
publish non-enterprise projects, then yes, the projects will be visible in
PWA and you can see the data in the MSP_WEB_PROJECTS table. However, you
cannot see the projects in the Open from Project Server dialog because you
never SAVED the projects in the Project Server database. You have started
down the wrong path with this tool, my friend. The correct process for
using Project Server is:
1. Open Microsoft Project and log into Project Server with Project Manager
permissions or higher
2. Create a project
3. Click File - Save and save the project in the Project Server database
4. Publish the project using Collaborate - Publish - All Information
If you follow the above steps, you can see the project in both Microsoft
Project and PWA. To correct your problem, I would recommend that you ask
your Project Server administrator to delete any non-enterprise projects from
the Project Server database, and also disallow the permission to publish
non-enterprise projects. Next, I would recommend that you follow these
steps:
1. Open Microsoft Project and log into Project Server with Project Manager
permissions or higher
2. Click Tools - Enterprise Options - Import Project to Enterprise
3. Using the Import Project wizard, locate the first .mpp project and
import it into the Project Server database
4. Pay special attention to the page on matching local resources with
enterprise resources
5. Repeat this process for every .mpp project
To answer your last question, you open the Enterprise Global and Enterprise
Resource Pool by doing the following:
1. Open Microsoft Project and log into Project Server with administrator
permissions
2. Click Tools - Enterprise Options
3. Select either Open Enterprise Global or Open Enterprise Resource Pool
Because of your foundational misunderstandings about Project Server, I would
recommend that you consider purchasing our company's books on Project Server
2003 by clicking the URL in my signature block. Hope this helps.
--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"
"Steve Crago (Hotmail)" <stevecrago@hotmail.com> wrote in message
news:41a15d85@duster.adelaide.on.net...
> Hi Dale,
>
> I was under the impression that by using Collaborate > Publish that they
> were published to the Project Server database.
>
> In fact I can see the project in the MSP_WEB_PROJECTS table. It appears
> that I need to "approve" / "accept" or somehow move them into the
> MSP_PROJECTS table. Do you know how to do this?
>
> Still not sure however why the Global and ResGlobal and other projects in
> the MSP_PROJECTS table are not visible in the "Open from Microsoft Project
> Server" dialog box.
>
> Thanks Steve.
>
>
> "Dale Howard [MVP]" <dale(dot)howard(at)msprojectexperts(dot)com> wrote in
> message news:%23pwBaEE0EHA.4028@TK2MSFTNGP15.phx.gbl...
>> Steve --
>>
>> If you saved the files locally as .mpp files, then they were never saved
>> in the Project Server database, therefore, you cannot open them from the
>> Project Server database. I would suggest that you go look for them on
>> your hard drive or in a network folder somewhere. Hope this helps.
>>
>> --
>> Dale A. Howard [MVP]
>> Enterprise Project Trainer/Consultant
>>
http://www.msprojectexperts.com
>> "We wrote the book on Project Server"
>>
>>
>> "Steve Crago (Hotmail)" <stevecrago@hotmail.com> wrote in message
>> news:41a12974@duster.adelaide.on.net...
>>> Dale,
>>>
>>> The projects were created with Project Professional 2003 and saved
>>> locally as a file. Some time later these were published to Project
>>> Server using Project Professional 2003.
>>>
>>> I can see the Project in Project Web Access > View A Project but I
>>> cannot open the Project in Project Professional 2003. The project is not
>>> visible in the "Open from Microsoft Project Server" dialog box and is
>>> also not visible in the "Import Wizard - Project Definition" dialog box
>>> which is invoked by selecting to "Open from File" > ODBC > Mchine Data
>>> Source.
>>>
>>> How can I open these Projects that have been published to Project
>>> Server?
>>>
>>> Thanks for your help Dale.
>>>
>>>
>>> "Dale Howard [MVP]" <dale(dot)howard(at)msprojectexperts(dot)com> wrote
>>> in message news:ucwlGeczEHA.2540@TK2MSFTNGP09.phx.gbl...
>>>> Steve --
>>>>
>>>> How in the world did you create the projects and publish them in the
>>>> first place? When you created each project and clicked Save the first
>>>> time, you should have seen the Save to Microsoft Project Server dialog.
>>>> Did you?
>>>>
>>>> --
>>>> Dale A. Howard [MVP]
>>>> Enterprise Project Trainer/Consultant
>>>>
http://www.msprojectexperts.com
>>>> "We wrote the book on Project Server"
>>>>
>>>>
>>>> "Steve Crago (Hotmail)" <stevecrago@hotmail.com> wrote in message
>>>> news:419d274c$1@duster.adelaide.on.net...
>>>>> Hi,
>>>>>
>>>>> I have just started a Project Server 2003 installation and have
>>>>> published a couple of Projects to the Project Server. These are
>>>>> visible in Project Web Access. However when I now go into Project
>>>>> Professional 2003 and select File
>>>>> > Open I get the "Open from Microsoft Project Server" dialog box NO
>>>>> > projects
>>>>> are displayed.
>>>>>
>>>>> If I use Collaborate > Project Center in Project Professional 2003
>>>>> then the Projects are displayed.
>>>>>
>>>>> Can someone please tell me how I can get the Project Server projects
>>>>> displayed in the "Open from Microsoft Project Server" dialog box in
>>>>> Project Professional 2003.
>>>>>
>>>>> Thanks Very Much,
>>>>>
>>>>> Steve.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>