Mundo EPM - Allan Rocha - www.bhs.com.br

Prezados,

Estou mudando meu blog de endereço e me unindo ao André Xavier, sócio e amigo há muitos anos, para tornar essa fonte de conhecimento mais forte e atualizada.

Basta acessar http://www.mundoepm.com.br , dar o “subscribe” e se manter atualizado sobre os acontecimentos do Mundo EPM!!!

Então, nos vemos no novo blog!

Grande abraço e obrigado!

Foi anunciado recentemente pela Microsoft que o Microsoft SharePoint Designer 2007 está disponível gratuitamente a partir de 31/03/2009.

Download: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42 

Para usuários e administradores do EPM 2007 é uma mão na roda quando é necessário criar dashboards ou personalizar os espaços de trabalho com o lyout da empresa ou pequenas customizações.

E já que a ferramenta agora é grátis, não custa nada aprender a mexer um pouquinho, né?
Vai aí um Webcast para começar:

------------------------------------------------------------------------------------------------------
RSUG - SharePoint Designer 2007 - Live Webinar Invitation
Saturday, April 11, 2009 from 6:30 PM - 7:40 PM (GMT+0300)
http://rsugspd.eventbrite.com/ 
------------------------------------------------------------------------------------------------------

ESSE POST NÃO É COMERCIAL!!!!!!

Quem já trabalha com o Project Professional ou Project Server 2007 sabe muito bem o motivo desse post… De forma sucinta: suprir algumas necessidades básicas de um gerente de projetos ou administrador que tem como ferramenta a solução EPM da Microsoft. :)

Com esse intuito que grande parte dos produtos abaixo foram elaboradoes e desenvolvidos. Então, para não privá-los de saber da existência dos mesmos! Podem conferir aqui (http://www.bhs.com.br/consultoria/)!!!

Abraço!!!!

Seguindo a linha do Bruno Velaz,  vou referenciar um post que vi no blog dele, que por sinal, é MUITO LEGAL!!!!

Estou publicando, pois muita gente deve ter esta dúvida, parabéns Bruno e Maurício.

---------------------------------------------------------------------------------------------------------------------------

“Estou publicando pois muita gente deve ter esta dúvida, parabéns Maurício.

Méritos de : Maurício Ricardo Zagato - NET Serviços de Comunicação S/A.

---------------------------------------------------------------------------------------------------------------------------

Você pode ter um atendimento Online no seu site, pelo msn, de graça, veja os procedimentos:

1. vc pode usar sua conta no Hotmail, ou criar uma nova conta exclusivamente para esta finalidade: http://login.live.com/

1.1 Se vc desejar criar uma conta com seu próprio email, sem ser do Hotmail, como seuNome@suaEmpresa.com.br , use este link

1.2 Após criada sua conta (live ID) vc precisa autorizar a exibição do seu status no site, faça isto aqui: http://settings.messenger.live.com/applications/websettings.aspx

Marque a opção "Permitir que as pessoas vejam o seu status do Messenger em sites e enviem mensagens para você" e salve no topo da página.

Assim que salvar a autorização no link acima, vc precisará copiar os códigos HTML que esta mesma págira irá mostrar, clicando no menu à esquerda: Criar HTML

Vc verá 3 opções de atendimento:

• Janela Mensagens Instantâneas
• Botão
• Ícone de status

Vc conseguirá instalar tanto a Janela como o ícone em seu site, o botão não.

Selecione a opção que desejar e copie o código HTML mais abaixo.

No seu site, insira este código em alguma caixa de código HTML (aquelas de fundo amarelo), e nas propriedades da caixa HTML, mas a opção "Overflow" como "visible".

Oculte o modo de edição e já verá o seu status no msn, salve e pronto.

Se quiser mudar a fonte ou o texto da opção ícone, use o código abaixo, mas mude os seus dados, onde vc vê: "sdfs7s7fa868", coloque o seu próprio código.

http://settings.messenger.live.com/Conversation/IMMe.aspx?invitee=9867669593b066aa@apps.messenger.live.com&mkt=pt-br

No caso do Share Point, colar o endereço acima conforme figura abaixo:

“

Realmente muito legal!!!!

Muito interessante!!! Se você está querendo aprender alguns truques e dicas sobre o Project 2007, vai aí uma lista com vários vídeos mostrando como operar a ferramenta… Estão em inglês mas tá mamão com açúcar!

Project 2007 Demos - http://office.microsoft.com/en-us/project/CH100740881033.aspx

Uma coisa muito importante que não havia sido dita por mim sobre o “Cumulative Update for December 2008” é que se você estiver rodando MOSS e instalar o CU December 2008 ele gera um erro na busca que vai entupir seu Event Viewer!!!

Então, se você usa MOSS e está com “Cumulative Update for December 2008” corra e instale o pacote de Fevereiro 2009!!!!

Description of the Windows SharePoint Services 3.0 cumulative update package: February 24, 2009
http://support.microsoft.com/kb/961755

Description of the SharePoint Server 2007 cumulative update package (MOSS server-package): February 24, 2009
http://support.microsoft.com/kb/961756

Importante: A atualização para o Project 2007 client não está disponível junto com os arquivos do servidor! Você deverá instalar um a um… :(

These KB Articles list the fixes included in the Individual Cumulative Update Package for Project Server and Project 2007:

Description of the Project Server 2007 hotfix package : February 24, 2009
http://support.microsoft.com/kb/968271

Description of the Project 2007 hotfix package (Project.msp): February 24, 2009
http://support.microsoft.com/kb/966308

Note:  KB Articles may not be released at the time of the CU release but we should see then publically available within a week or two of the CU release.

Microsoft EPM (Enterprise Project Management) Solution Support and Reference Links:

1) Office Project Server 2007 - TechNet
http://technet2.microsoft.com/Office/en-us/library/ec990b7c-ec98-4d6d-b1a1-081a67fd66cc1033.mspx?mfr=true

2) Microsoft Office Project Server 2007 – Product Information
http://office.microsoft.com/en-us/projectserver/FX100739841033.aspx

3) Microsoft Office Project 2007 – Product Information
http://office.microsoft.com/en-us/project/FX100487771033.aspx

4) The Microsoft Office Enterprise Project Management (EPM) Solution – Product Information
http://office.microsoft.com/en-us/epmsolution/FX101935291033.aspx

5) Project Server Experts
http://www.projectserverexperts.com/default.aspx

6) Project Developer Portal
http://msdn2.microsoft.com/en-us/office/aa905469.aspx

7) Project Server Discussions Group
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.project.server

8) Microsoft Office Project Portfolio Server 2007 – Product Information
http://office.microsoft.com/en-us/portfolioserver/FX101674151033.aspx

9) Windows SharePoint Services 3.0 Technical Library
http://go.microsoft.com/fwlink/?LinkId=81199

10) Project Portfolio Server 2007 Document: Deployment Guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=8977c122-a64f-4c4e-a78b-0ea8e150fe3a&DisplayLang=en

11) Microsoft Team Project Blog
http://blogs.msdn.com/project/

Downloadable books for Office Project Server 2007
Office Project Server technical library

Planning and architecture for Office Project Server (Download)
Designed to lead a team through the steps of planning a new solution based on Office Project Server 2007.
http://go.microsoft.com/fwlink/?LinkId=79598

Deployment for Office Project Server (Download)
Covers installing and configuring Office Project Server in a new deployment. June 2007
http://go.microsoft.com/fwlink/?LinkId=79599

Migration for Office Project Server (Download)
Covers migrating data from previous versions to Office Project Server 2007. June 2007
http://go.microsoft.com/fwlink/?LinkId=85679

Planning and architecture for Office Project Server 2007 (Download)
The content in this planning guide is designed to lead a team through the steps of planning and deploying a new solution based on Office Project Server 2007. March 2007
http://go.microsoft.com/fwlink/?LinkID=92795

What's new in Office Project 2007 (Download)
This article examines what is new in Microsoft Office Project Server 2007, Project Web Access 2007, and Microsoft Office Project Professional 2007. June 2007
http://go.microsoft.com/fwlink/?LinkID=93713

Technical Reference for Office Project Server 2007 (Download)
Covers technical reference information for Office Project Server 2007. June 2007
http://go.microsoft.com/fwlink/?LinkId=93742

Cube Building Service in Office Project Server 2007 (Download)
Covers instructions for configuring, managing, and troubleshooting the Cube Building Service in Office Project Server 2007. June 2007
http://go.microsoft.com/fwlink/?LinkId=93743

Understanding and Using the Queuing system in Office Project Server 2007 (Download)
Covers instructions for understanding and using the Queuing system in Office Project Server 2007. June 2007
http://go.microsoft.com/fwlink/?LinkId=93744

Downloadable books for Office SharePoint Server 2007
Office SharePoint Server technical library

Planning and architecture for Office SharePoint Server, part 1 (Download)
Covers topics such as planning sites, planning for certain features such as forms and search, and planning for managing documents and records. March 15, 2007
http://go.microsoft.com/fwlink/?LinkID=79552

Planning and architecture for Office SharePoint Server, part 2 (Download)
Covers topics such as determining hardware and software requirements, capacity planning, and planning for security. March 15, 2007
http://go.microsoft.com/fwlink/?LinkID=85548

Deployment for Office SharePoint Server (Download)
Covers installing and configuring Office SharePoint Server in a new deployment. June 2007
http://go.microsoft.com/fwlink/?LinkID=79589

Upgrading to Office SharePoint Server (Download)
Covers upgrading to Office SharePoint Server. March 15, 2007
http://go.microsoft.com/fwlink/?LinkId=85556

Web Publishing and Planning Guide with Microsoft Office SharePoint Server (Download)
Covers features you can use to implement the structure, navigation, and appearance of Web sites and to control how your sites are authored, approved, and published. May 2007
http://go.microsoft.com/fwlink/?LinkId=92330

Getting Started with Office SharePoint Server 2007 (Download)
Covers basic information about the capabilities of and requirements for Microsoft Office SharePoint Server 2007 May 2007
http://go.microsoft.com/fwlink/?LinkID=91741

Records Management Guide for Microsoft Office SharePoint Server 2007 (Download)
Covers general records management planning considerations and guidelines for configuring Microsoft Office SharePoint Server 2007. May 2007
http://go.microsoft.com/fwlink/?LinkId=92720

Planning an Extranet Environment for Office SharePoint Server (Download)
Covers planning recommendations for deploying Microsoft Office SharePoint Server 2007 in an extranet environment. June 2007
http://go.microsoft.com/fwlink/?LinkId=93372

MOSS Document Management (Download)
Covers document management features that you can use to control the lifecycles of documents in your organization. June 2007
http://go.microsoft.com/fwlink/?LinkID=92638

Office SharePoint Server Security (Download)
Describes how security is implemented in Microsoft Office SharePoint Server 2007. June 2007
http://go.microsoft.com/fwlink/?LinkID=94375

Description of the Windows SharePoint Services 3.0 cumulative update package: February 24, 2009

http://support.microsoft.com/kb/961755

Description of the SharePoint Server 2007 cumulative update package (MOSS server-package): February 24, 2009

http://support.microsoft.com/kb/961756

Note:  The Project 2007 client patch is not included in the Server Rollup Packages so you will need to deploy the individual client patch.

These KB Articles list the fixes included in the Individual Cumulative Update Package for Project Server and Project 2007:

Description of the Project Server 2007 hotfix package : February 24, 2009

http://support.microsoft.com/kb/968271

Description of the Project 2007 hotfix package (Project.msp): February 24, 2009
http://support.microsoft.com/kb/966308

Downloads:

Project Professional
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=966308&kbln=en-us

Project server
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968271&kbln=en-us

MOSS
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=961756&kbln=en-us

WSS (O único com informação e realmente disponível ao público)
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=961755&kbln=en-us

Um dos achados mais úteis dos últimos tempos!!!

Quais campos personalizados vão e quais não vão para o Cubo Olap do Project Server 2007?

http://msdn.microsoft.com/en-us/library/ms447495.aspx

Link para download:
http://code.msdn.microsoft.com/PS2007Rename/Release/ProjectReleases.aspx?ReleaseId=2028

Background Information

There are numerous times when project managers or administrators need to edit project-level custom fields for multiple projects. Using Project Web Access you must edit one project at a time, however it is possible to edit multiple projects in a datasheet type view within the Microsoft Project client.

Resolution

1. Logon to Project Web Access using credentials that allow you to open and save the projects you want to edit

2. Make sure that the Project client is closed

3. Navigate to the Project Center page and select the header row for projects that you want to edit using any standard multi-select technique

4. Click the Edit button on the toolbar

5. The system opensthe Project client and opens the projects in a temporary Master Project

6. Insert the custom fields you want to edit in a task view such as the Gantt chart, or apply a view which already contains these fields

7. Without expanding the inserted projects, make your required edits to the project custom field values

8. Save changes to all files, discard the master project

9. Choose to check-in the projects as you require

Note: You can also build the temporary master project by inserting the projects using the Insert menu in Project.

-----------------------------------------

Resolução:

1. Logue no Project Web Access com uma credencial que possa abrir e salvar projetos.
2. Feche o Project Professional
3. Vá para a Central de Projetos
   1. Selecione várias linhas (vários projetos)
4. Clique em “Editar”
5. O Project Server abrirá um projeto master com todos os seus projetos como subprojetos.
6. Edite os campos sem expandir as tarefas sumárias.
7. Salve tudo exceto o Projeto Master Temporário.

Será necessário re-publicar os projetos!

1. Service Pack 1
   1. Windows SharePoint Services 3.0 Service Pack 1 (SP1)
   2. The 2007 Microsoft Office Servers Service Pack 1 (SP1)
   3. Microsoft Office Project 2007 Service Pack 1 (SP1)
2. Infrastructure Updates
   1. Infrastructure Update for Project 2007 (KB951547)
   2. Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)
   3. Infrastructure Update for Microsoft Office Servers (KB951297)
3. August Cumulative Updates(unzip the file with the KB# in the filename)
   1. Microsoft Office Project 2007 – Office KB956060
   2. Microsoft Project Server 2007 – Office KB956061
   3. Windows Sharepoint Services 3.0 – WSS KB956057
   4. Microsoft Office SharePoint Server 2007 – MOSS KB956056
4. SQL Server 2005
   1. Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
   2. Microsoft SQL Server 2005 Service Pack 2
   3. DSO
      1. SQL Server Native Client (sqlncli.msi)
      2. Microsoft SQL Server 2005 Management Objects Collection (SQLServer2005_XMO.msi)
      3. Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi).

Se já teve esse erro e não soube o que fazer vai aí a solução:

1. Run the .MSI from a command line with the following command:
   ”msiexec /I SharePointRS.msi SKIPCA=1“
2. Run the rscustomaction.exe file manually from a command line by running this
   command:
   ”%TEMP%\rscustomaction.exe –I”
3. It could be in a different directory underneath %TEMP% though as on
   Fredericks machine it was in the %TEMP%\2 directory.

1. Execute o .MSI usando linha de comando:
   ”msiexec /I SharePointRS.msi SKIPCA=1“
2. Depois execute o rscustomaction.exe manualmente usando o seguinte comando:
   ”%TEMP%\rscustomaction.exe –I”
3. Na maioria das vezes fica uma pasta acima do “%TEMP%”.

Para que seu cubo continue processando será necessário instalar os arquivos de DSO e para nao ter erro, instale o Management Studio!!!

DSO:

Link para download: http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

• Click the X86 Package for the Microsoft SQL Server Native Client (sqlncli.msi).
• Click the X86 Package for the Microsoft SQL Server 2005 Management Objects Collection (SQLServer2005_XMO.msi).
• Click the X86 Package for the Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi).

Link: http://www.msprojectconference.com/index.htm 

Key Conference Highlights:

• Over 80+ educational sessions in multiple tracks
• Special guest keynote speakers
• 40,000 sq foot exhibit hall filled with Microsoft Partners and Solution Providers
• Many great networking opportunities with other Project Professionals

Já se deparou com essa “zica”? E nada você tenha feito funcionou? Problema resolvido!!!! :D

Os passos são os seguintes:

1. Levando em conta que você já tenha feito todos os passos para configurar a segurança do serviço, e que ao tentar duplicar ou atualizar um arquivo excel você recebeu essa mensagem.
2. Abra seu excel
   1. Dê um “Refresh All”
      1. 
   2. Abra as conexões e exporte para sua biblioteca do Sharepoint
      1.  
3. Feche seu arquivo excel.
4. Abra seu arquivo ODC.
   1. praticamente repita os passos anteriores…. :S
   2. Ele tem que estar dentro de uma biblioteca do Sharepoint.
   3. Dê um “Refresh All”
      1. 
   4. Exporte o arquivo:
      1. 
   5. Salve na sua biblioteca do Sharepoint(no mesmo lugar de antes!)
   6. Abra seu arquivo excel,
      1. aponte navamente para o arquivo,
      2. marque a caixa “Always use connection file”
      3. clique em ok.
   7. salve o arquivo e pronto!

See you!!!! :D

Caso precise aumentar o timeout do banco de dados do Project Server 2007:

• SetDatabaseTimeout(DatabaseTimeoutType.Core, timeout);
• GetDatabaseTimeout(DatabaseTimeoutType.Core);

Link para download:

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

Excelente conteúdos para download sobre Office Project Server 2007:

Downloadable content for Office Project Server 2007

Updated: 2007-12-20

Some of the content in the Microsoft Office Project Server 2007 technical library is available in downloadable and printable form as Microsoft Office Word documents (.doc files). The content in these books is a copy of selected content in the Office Project Server technical library (http://go.microsoft.com/fwlink/?LinkId=84740) as of the date listed for each book. For the most current content, see the technical library on the Web.

Planning

Operations

http://technet.microsoft.com/en-us/library/cc721700.aspx
Updated: 2008-07-15

This article describes how to optimize custom reporting solutions built for the Reporting Database (RDB) of Microsoft Office Project Server 2007. If you are interested in building custom views or applying custom indexes on any views in the RDB, read this article for some helper stored procedures that can be used in conjunction with your solutions.

If you are not already familiar with the general mechanics of the RDB, see these background articles:

• Reporting and the RDS: (http://go.microsoft.com/fwlink/?LinkId=123365)

• Project Server Report Pack: (http://go.microsoft.com/fwlink/?LinkId=123367)

• 

• 

• 

• 

Passo a passo de como instalar o SSRS com o mode integrado do SharePoint.

Página: http://technet.microsoft.com/en-us/library/cc262438.aspx

Download direto: Configuration Guide for SharePoint Integration Mode

Se você se deparou com esse erra abaixo quando implementou o Reporting Services with Sharepoint Integrade Mode:

Reporting Services Error

• An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
  • Error executing child request for /ReportServer/Pages/ReportViewer.aspx.
    • The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found

SQL Server Reporting Services

Apenas adicione as tags abaixo no web.config do Report Server:

<appSettings>
       <remove key="ReportViewerMessages" />
</appSettings>

Excelente!!!! :D

Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=7d243a2c-90b7-425d-b586-c48a0c3bebbb&DisplayLang=en 

Quer usar efeito de MAC no seu SharePoint? ;)

Project Description

ShUIE is an addition to Microsoft SharePoint that allows a developer to inject JavaScript and CSS fragments depending on the context of the page being displayed. JavaScript and CSS injected can be optionally minified, and jQuery is included to increase functionality.

great!!!