Project 2007
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html
Posts
Services Infrastructure for Project Server
Windows SharePoint Services Infrastructure for Project Server Microsoft Office Project Server 2007 is now a full member of a Windows SharePoint Services server farm. Each Project Web Access site collection can include subsites and an optional project workspace site for each project. A server farm with one Project Server installation can include multiple Project Web Access applications and Shared Services Providers (SSPs). Project Server can import SharePoint task lists as project proposals. This article describes how Project Server and Windows SharePoint Services work together, as well as some of the ways to use SharePoint data. The article includes the following sections. * Windows SharePoint Services Infrastructure * PSI Methods and Datasets for Project Workspaces * Using SharePoint Data o Resource Name Conflicts o Getting the Site ID for Impersonation o Problems with Importing SharePoint ...
MOSS Architecture and Shared Services
a very good article to understand SSP in MOSS 2007 MOSS SSP Walk through on Configuring SSP in MOSS 2007
Script to get all tables where some particular column present
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%WVIEW_TIMESTAMP%' ORDER BY schema_name, table_name;
Project server 2007 Dec-10 MS CU released
The latest Cumulative Updates (CU) for Project and Project Server 2010 and 2007 have been released. There was a problem found in both the 2007 and 2010 Server Rollup Packages which required a fix and for the patches to be rebuilt Project and Project Server 2007 This include a number of fixes, so Microsoft strongly recommends that you test this in a test environment based on your production environment before putting this fix live in production. The article below provides information on how to deploy the Project Server Cumulative Update. Deploy cumulative updates (Project Server 2007) http://technet.microsoft.com/en-us/library/dd239177.aspx Service Pack 2 for both WSS and Office Servers 2007 are required for this Cumulative Update. The KB articles below provide information on how to download and install SP2 if you have not already done so. o Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2 o http://support....
Format Numbers in VB.net
below is useful link for Number formatting http://msdn.microsoft.com/en-us/library/0c899ak8.aspx
Project Server 2007 Blogs: Application event handeling setting Project level Enterprise custom field
Project Server 2007 Blogs: Application event handeling setting Project level Enterprise custom field
Application event handeling setting Project level Enterprise custom field
Private Sub App_ProjectBeforeSave(ByVal pj As Project, ByVal SaveAsUi As Boolean, Cancel As Boolean) If pj.CurrentView = "Publish Project View" Then 'pj.Tasks.Item(1).Name = "Test View level " 'pj.ProjectStart = Now() 'pj.StatusDate = Now() 'MsgBox ("Inside view published") 'Else Dim x As String 'x = "XYZ" x = ActiveProject.ProjectSummaryTask.GetField(FieldNameToFieldConstant("- Groups", pjTask)) If x = "" Then 'confirm = MsgBox("Please go to Menu-->Project-->Project Information-->select your 'Group'", vbYesNo) confirm = MsgBox("You did not select Group,do you want to select it", vbYesNo) If confirm = 6 Then Cancel = True MsgBox ("Please go to Menu-->Project-->Project Information-->select your ' Group'") Call ActiveProject.ProjectSummaryTask.SetField(FieldNameToFieldConstant(" - Groups", p...
Application Events> using application events requires a few steps. The first step is to create a new class module and declare an object of type Application with events. Creating the class module is done by going to the insert menu and selecting "ClassModule" When you have done this, double click on the class module and declare the object by using the following code: Public WithEvents App As Application After the new object has been declared with events, it appears in the Object drop-down list box in the class module, and you can write event procedures for the new object. (When you select the new object in the Object box, the valid events for that object are listed in the Procedure drop-down list box.) Writing the procedure is similar to writing any macro. The image below shows a simple example using the ProjectBeforeTaskChange event. Note that NewVal holds the value that the user has input. The original value can still be referenced in the standard way (t.Name). The code t...
Project Web Access Capabilities(Project Manager & Team Members)
We can use Office Project Web Access to view, analyze, and report on information as well as create project proposals and activity plans Project Manager: Project managers can perform a variety of tasks with Project Server to manage their projects: · Assign and track tasks . · Perform reporting or status report · Analyze project costs and other variables - . · Manage resource availability - Team members: Manage their tasks - Team members can review the tasks assigned by the project manager, respond to those task assignments, and update their task status. They can create tasks and submit them to the project manager for approval, and team members with the appropriate permissions can delegate tasks to other team members. View tasks and timelines - Project Server enables team members to view tasks in the project timeline in a Gantt chart format and view their tasks in relation to others in ...
Create Team in Project Server 2007
Some time we need to create team for particular project ..it is useful in many ways ;we can assign roles and give access depending on the team..... To create a team first go to server settings on extreme left of Project server home page..click on it and go to Enterprise data and click Enterprise Custom Field Definition ... On Look up Tables For Custom Field define a look up table containing different team names, let say if you want to create 2 teams for time being then give 2 team name on look up table . Now come to Enterprise Custom Field (Here Team Name is already defined custom field .Click on this field and then aim to Custom Attribute field and select Lookup Table and here form lookup table . Now your Team has been defined ..only work is left to assign Resource in a team...click server setting again and then click manage users.. click on the users details which you want to assign in a team ...and go to Team Details field ..select team name in which you want to ass...
MS SQL Server 2005 Set Up
Although its not a big deal to install MS SQL SERVER 2005 ..but here I Published some Step to install SQL Server 2005 alongwith Analysis server and reporting Server database.... Step 1 Sql Server Component update insatll the fallowing component 1-Dot Net framework 2.0 2-Ms sql native Client 3-MS SQL server 2005 set up support file Click Next Step 2 MS SQL Server Installation Wizard Click Next Step 3 System Configuration Check(system is checked for Potential Installation) Fallowing Action is checked 1-IIS Feature requirement 2-Pending Reboot Requirement 3-Performance Monitor Requirement 4-Default Installation Path Permission Requirement 5-IE Requirement 6-COM plus Catalog Requirement 7-ASP.NET Version Registration requirement 8-Min MDAC Version Requirement Status may be either Success or Failure Click Next Step 4 Registration Information Component to Install ...