Schedule Change Log

Is it possible for MSProject Server 2007 to log schedule changes for 
reporting purposes?  My customer has a requirement in which they want to see 
all additions, deletions, logic changes, and duration changes.  We have a 20k 
line item schedule that changes frequently.  We're currently dumping 
before/after schedules into Excel and using vlookup.  

Thanks!

Sandy
0
Utf
1/13/2010 3:01:01 PM
project.server 1346 articles. 1 followers. Follow

3 Replies
1236 Views

Similar Articles

[PageSpeed] 18

Sandy --

There is no automatic change log available in Project Server 2007, but there 
is a manual method you could use.  Before the PM makes changes to the 
enterprise project, he/she should click File - Save As and save the project 
as an MPP file locally.  He/she should then close this project, reopen the 
enterprise project, make changes, etc.  At the time the PM needs to do the 
change analysis, he/she should open the MPP project and the enterprise 
project, and then use the Compare Project Versions utility, available by 
clicking View - Toolbars - Compare Project Versions.  This tool will allow 
the PM to do the change reporting needed, including new tasks added, tasks 
deleted, logic changes, Duration changes, and many more as well.  Not 
perfect, I realize, but I think this would meet your report needs.  Hope 
this helps.

-- 
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"Sandra" <Sandra@discussions.microsoft.com> wrote in message 
news:8F3963B5-0F03-4058-9E0D-48C3FD1F3594@microsoft.com...
> Is it possible for MSProject Server 2007 to log schedule changes for
> reporting purposes?  My customer has a requirement in which they want to 
> see
> all additions, deletions, logic changes, and duration changes.  We have a 
> 20k
> line item schedule that changes frequently.  We're currently dumping
> before/after schedules into Excel and using vlookup.
>
> Thanks!
>
> Sandy 

0
Dale
1/13/2010 3:38:00 PM
Thanks forthe response Dale.  

I've considered this method but our schedule is 20,000 line items and 160mb 
in size.  We don't have the PC power to run the MSProject Compare feature.  
We've tried to run it on a standalone PC with 4gb RAM but it still dies 
stating "out of memory"

Sandy

"Dale Howard [MVP]" wrote:

> Sandy --
> 
> There is no automatic change log available in Project Server 2007, but there 
> is a manual method you could use.  Before the PM makes changes to the 
> enterprise project, he/she should click File - Save As and save the project 
> as an MPP file locally.  He/she should then close this project, reopen the 
> enterprise project, make changes, etc.  At the time the PM needs to do the 
> change analysis, he/she should open the MPP project and the enterprise 
> project, and then use the Compare Project Versions utility, available by 
> clicking View - Toolbars - Compare Project Versions.  This tool will allow 
> the PM to do the change reporting needed, including new tasks added, tasks 
> deleted, logic changes, Duration changes, and many more as well.  Not 
> perfect, I realize, but I think this would meet your report needs.  Hope 
> this helps.
> 
> -- 
> Dale A. Howard [MVP]
> VP of Educational Services
> msProjectExperts
> http://www.msprojectexperts.com
> http://www.projectserverexperts.com
> "We write the books on Project Server"
> 
> 
> "Sandra" <Sandra@discussions.microsoft.com> wrote in message 
> news:8F3963B5-0F03-4058-9E0D-48C3FD1F3594@microsoft.com...
> > Is it possible for MSProject Server 2007 to log schedule changes for
> > reporting purposes?  My customer has a requirement in which they want to 
> > see
> > all additions, deletions, logic changes, and duration changes.  We have a 
> > 20k
> > line item schedule that changes frequently.  We're currently dumping
> > before/after schedules into Excel and using vlookup.
> >
> > Thanks!
> >
> > Sandy 
> 
> .
> 
0
Utf
1/13/2010 7:16:01 PM
I suspect this is why they pulled the tool from 2010. I also believe the 
problem may be an unhandled VBA memory leak.

-- 
Gary L Chefetz, MVP, MCT, MCITP
msProjectExperts http://www.msprojectexperts.com
FAQs and Reference http://www.projectserverexperts.com
BLOG: http://projectserverhelp.com

"Sandra" <Sandra@discussions.microsoft.com> wrote in message 
news:59036685-D05E-4BFB-BC3A-05382DF9C26E@microsoft.com...
> Thanks forthe response Dale.
>
> I've considered this method but our schedule is 20,000 line items and 
> 160mb
> in size.  We don't have the PC power to run the MSProject Compare feature.
> We've tried to run it on a standalone PC with 4gb RAM but it still dies
> stating "out of memory"
>
> Sandy
>
> "Dale Howard [MVP]" wrote:
>
>> Sandy --
>>
>> There is no automatic change log available in Project Server 2007, but 
>> there
>> is a manual method you could use.  Before the PM makes changes to the
>> enterprise project, he/she should click File - Save As and save the 
>> project
>> as an MPP file locally.  He/she should then close this project, reopen 
>> the
>> enterprise project, make changes, etc.  At the time the PM needs to do 
>> the
>> change analysis, he/she should open the MPP project and the enterprise
>> project, and then use the Compare Project Versions utility, available by
>> clicking View - Toolbars - Compare Project Versions.  This tool will 
>> allow
>> the PM to do the change reporting needed, including new tasks added, 
>> tasks
>> deleted, logic changes, Duration changes, and many more as well.  Not
>> perfect, I realize, but I think this would meet your report needs.  Hope
>> this helps.
>>
>> -- 
>> Dale A. Howard [MVP]
>> VP of Educational Services
>> msProjectExperts
>> http://www.msprojectexperts.com
>> http://www.projectserverexperts.com
>> "We write the books on Project Server"
>>
>>
>> "Sandra" <Sandra@discussions.microsoft.com> wrote in message
>> news:8F3963B5-0F03-4058-9E0D-48C3FD1F3594@microsoft.com...
>> > Is it possible for MSProject Server 2007 to log schedule changes for
>> > reporting purposes?  My customer has a requirement in which they want 
>> > to
>> > see
>> > all additions, deletions, logic changes, and duration changes.  We have 
>> > a
>> > 20k
>> > line item schedule that changes frequently.  We're currently dumping
>> > before/after schedules into Excel and using vlookup.
>> >
>> > Thanks!
>> >
>> > Sandy
>>
>> .
>> 
0
Gary
1/13/2010 9:41:06 PM
Reply:

Similar Artilces:

Changing & Saving Fonts
When I change the default font in a new Excel Worksheet I seem to have to change it inn each cel individually. How can I do this more efficiently. To create a workbook and a woksheet template Open a new workbook. Customize fonts as you wish through Format>Style>Normal>Modify File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLS...

How to fill down without changing the format?
Does anyone know how to fill a cell's formula/value down without changing the format (color, font, etc.)? -- _________________________________________ Todd Bennett Mechanical Designer Celerity Group, Inc. 9660 SW Herman Rd Tualatin, OR 97062 Phone: 888-724-3221 E-mail: tbennett@celerity.net Just drag it down. "T Bennett" <tbennett@celerity.net> wrote in message news:big7g7$8skmo$1@ID-183945.news.uni-berlin.de... > Does anyone know how to fill a cell's formula/value down without changing > the format (color, font, etc.)? > > -- > __________________...

Changing font in Textbox
I have a multiline textbox where I am trying to align text. How can I change the font to something like Courrier New so that I have equi-spaced letters and my text lines up ? Thanks, Ike Create the Font you need and call the SetFont(...) API for the edit control (textbox) "Ike" <rxv@hotmail.com> wrote in message news:2rNQc.13064$Jp6.4650@newsread3.news.atl.earthlink.net... > I have a multiline textbox where I am trying to align text. How can I change > the font to something like Courrier New so that I have equi-spaced letters > and my text lines up ? Thanks, Ike ...

Open read only but update when changes are made / refresh
Hi, If anyone can point in the right direction to answering this question, I would be very thankful. I was wondering if it's possible to lock an excel file and have other people open a read-only copy but have them recieve notifications when the locked file is updated. Is this possible? If you need any clarification, please ask. -Watson ...

making changes to read only
I have been sent a document which is on excel and is a read only file. Is there any way I can make changes to this file as every time I try it will not let me make the changes. Save it with a new name. Work with the renamed copy. "borderknight" wrote: > I have been sent a document which is on excel and is a read only file. Is > there any way I can make changes to this file as every time I try it will not > let me make the changes. ...

Changing font size in a property page dialog template
I need to programatically change size of property page dialog. It would be nice if the reason was that I am trying to do something for visually impaired users, but no... I am dealing with some devices that lie about their screen resolution. I can do that reasonably easily for dialogs by overriding DoModal or Create and modifying (substituting a modified) template by changing font size there, but I am stumped by CPropertyPage. None of the "obvious" overrides are called. Anyone can help? The other way would be to re-scale everything at OnSize (maybe OnInitDialog), but this is clumsy...

Format changing unexpectedly
I have some spreadsheets that are protected and I don't have the password to unprotect. The spreadsheets are all in 2007 and I'm using WinXp. The problem that I have encountered is that number formats periodically change from number (0 decimals) to a date format. The numbers are unusable by parts of the program, summing the numbers and counting each item. I have tried to run a macro to programically correct the format, but that hasn't worked. I suspect that 2007 prevents changing a protected spreadsheet, using that method. Any suggestions on how to get back to a...

how do I change the format of a template in excel ??
i need to change some of the pre-set options in a cash flow template. I can't seem to unlock the description or the formula to cells... Most of the Templates have sheet protection enabled but not passworded. Tools>Protection>Unprotect Sheet should do the trick. If not, kindly provide a URL to the template so we can have a look. Gord Dibben MS Excel MVP On Mon, 4 Sep 2006 08:32:02 -0700, bigdaddy <bigdaddy@discussions.microsoft.com> wrote: >i need to change some of the pre-set options in a cash flow template. I >can't seem to unlock the description or the f...

I cannot change the date format to English canada
Hi- if you'd like to change the format of one cell, select the cell and reformat it. After selecting the cell, go tot he format menu, choose the first option: cells. From the pop-up form, goto the Number tab (should be the first one)- in the category section- choose date, in the locale section choose English(Canada)- then choose the format in the Type section. choose OK. It should work. If this is not what you ment, please let me know. Also, indicate what you've tried and why it hasn't worked- Good Luck! pim -- Pim ---------------------------------------------------------...

Changing initials for invoices!
is it possible to have a user automatically issues invoice with different initials than 'INV'?? while others issue normal invoices beginning with 'INV' Thanks in advance Fadi Tawakol Ms.Dynamics GP 9.0 Automatically based on user ID? Not without a customization. However, with one click, the user can switch to a different Invoice Type ID, which can then pull the numbering from the Invoice Setup for that Invoice Type. (This is assuming SOP is used for invoicing.) -- Victoria Yudin Dynamics GP MVP Flexible Solutions - home of GP Reports http://www.flex-solutions.com/gpr...

Outlook Identity Files Changing PCs
How do you copy the old PCs identity files to the new one? Just copying doesn't work at all. If you're really talking about Outlook (which doesn't use "identities"), then look here for all the information you need on backup and restoration of Outlook data: http://www.slipstick.com/config/backup.htm If you're talking about Outlook Express, which is not supported in this forum, you can find the help you need at this OE website: http://insideOE.tomsterdam.com -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- pleas...

Change the PO Print out
Can some one please let me know where I should place this variable: PurchaseOrder.Supplier.AccountNumber in the PO.xml file I woud like to be able to print the Acount # in the PO Thank you ...

IF statement to change font?
Is there an IF statement or other way to change the appearance of data? I would like the font color to change if an output goes over a said amount. As an example if we had an hours total out put and wanted it to change to red when over 40. Thanks in advance, Louis You can use conditional formatting to do this: Assume the cell of interest is cell A1 If you're using Excel 2007 Select cell A1 Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format Enter this formula in the box below: =AND(COUNT(A1),A1>40) ...

Outlook 2003 constantly asking for change password
Hi, I have this problem here. We have Exchange 2003 and Windows XP as the environment. Office 2003 is the client that we are using. The problem: When this computer is another domain than the exchange server the Outlook constantly is asking this user to change his password. It says that your account is expired. This account is not expired and is not logged out or something like that. Even if the user changes the password, this happens again. There is forest trust between these domains both ways. Can anyone please help me on this problem. Tia, Mac are they connecting through a firewall?...

Chart formate changing when saved
I have over ten different charts that I copy into a report out workbook at then end of each month. The normal stuff Date, goal, actual. the data format is set for % so the the 0.15 will show up on the chart as 15% when I save it. When my boss opens the chart it show up as 0.15 again. How do I make it keep the format I created it in?? The Date does the same thing but only on some of the charts. Starts as a date (month-yr) then it changes to 12345 general number. If you're copying the charts into a report, I would suggest copying the charts as pictures to insure nothing cha...

Change store limits in Exchange 2003 SP2
Can you link me to a page that tells how to increase Store Size from 18GB to larger once SP2 is installed? Thanks, Cindy Also, online concierge does not work with IE7.0 not very happy about that. http://www.microsoft.com/technet/prodtechnol/exchange/guides/E2k3TechRef/6c4ce7bb-5289-4221-a87c-b9c78ab7c09c.mspx -- Bharat Suneja MCSE, MCT www.zenprise.com blog: www.suneja.com/blog ----------------------------------------- "Cindy" <Cindy@discussions.microsoft.com> wrote in message news:A227D22F-EFFA-4688-B57E-1631A99FD721@microsoft.com... > Can you link me to a page th...

Find value in another column, change Interior.colorIndex
First post didn't work. I apologize if this is a duplicate. Hello there, I wrote the following code to find a value in column B if the cell in columnS has an Interior.color.Index = 44, transfer the color to the cell with same value in B. (calcLastRow declared already) Dim ColumnB As Range, SrcChk1 As Range Dim DestChk1 As String Dim DestChk2 As String Set ColumnB = Range("B14", "B" & calcLastRow) Range("N14").Select With ColumnB Do DestChk1 = (ActiveCell.Offset(0, 5).Interior.ColorIndex...

E2K Log files not flushing
I have three E2K servers that the transaction log files are not deleting after a full backup. We use Backupexec 9.1 but I have also tried using NTBACKUP, both unsucessful. These servers were recently patched with the Exchange Roll up - KB870540. I have two E2K servers that are clearing the log files but the do not have the roll up installed and are running BackupExec 8.6. Anyone any ideas? CJ. Have you made sure that a) you are backing up the entire Storage Group? and b) none of the mailbox stores are dismounted? Either of the above scenarios will cause the log files to not be purged. ...

How to change the values in xml for picklist
Under the accounts, I got a field country picklist and a state/province picklist. I wanted to have the country picklist onchange the state/province list will reveal the releveant states options. How am I going to that in xml? Which file should I change to alow the customization to work? Any solutions? Will the changes be brought forward throught migration? What are the consequences of the changes? Thanks for the help The solution provided will greatly benfiance all. Not in a supported way. However, Javascript does ive you the option to do this type of manipulation. You would proba...

Purge System Jobs log
Can anyone tell me if there is a way to purge the System Jobs log? There are thousands of (now) useless messages telling me that jobs completed successfully. Thanks Buckeye, Are you referring to the Workflow logs? If so I am having the same problem with CRM 3.0. There is a SQL script in the Optimizing CRM 3.0 document which is supposed to clear these logs but when I try to run it I just get errors. I have run SQL scripts from this document before but this one does not work. The Optimizing CRM 3.0 clearly states that if we don't clear out our logs it can impact performance. Hopef...

"Cannot change part of merged cell"
Need help! I have created a pivot table in Excel and now trying to add another field that appears in the field list. When I drag it over the pivot table to drop it, I get this error: "cannot change part of merged cell", I did not receive this error message for the other fields that I had selected. Please help. Thanks in advance. ExcelHelpNeeded Wrote: > Need help! > > I have created a pivot table in Excel and now trying to add another > field > that appears in the field list. When I drag it over the pivot table to > drop > it, I get this error: "...

Problem Changing Data Source In Pivot Table
Hello all. I have a workbook with multiple pivot tables pulling from a odbc datasource. The database has been moved to a new server and I a finding that even when I update the SQL with the new location in an one query, it tells me it cannot graphically represent the SQL an cannot pull the table. I am unsure as to whether or not I am mis-typin something (although not really sure how i could do that) or if i a missing some other place i need to update the link. Also, is there way to do it for all of the pivot tables at once? I have Excel 2000. Thank you!!! An example of the sql as it is (scr...

I can not change the scale settings on a scatter plot.
Making me completely crazy as all the online help assumes this works. -- Mom Hi, Your a little lite on detail here. Do you know how to change the scale values? Are you having problems displaying the format dialog? What things have you already tried? Cheers Andy Mom wrote: > Making me completely crazy as all the online help assumes this works. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info Also, does it work on the Y axis and not the X? Make sure it's an XY Scatter chart and not a Line chart. Can you format other features of the chart? If not, make sure the ...

Change measurements for columns etc
Hi Can I change the measurements to cm or inch when I format columns. Thanks, Mon Excel 2002 "MonB" wrote: > Hi Can I change the measurements to cm or inch when I format columns. Thanks, > Mon No, you cannot not best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MonB" <MonB@discussions.microsoft.com> wrote in message news:500EDD94-AFA5-4B39-90DE-75BD6935D947@microsoft.com... > Hi Can I change the measurements to cm or inch when I format columns. > Thanks, > Mon Columns("A").Columnwidth = 13 will...

how to change cut/copy/paste shortcuts back to ctrl + x/c/v
Hello, I don't know how to change back this shortcuts to ctrl +X/C/V Now the copy/paste/cut is done with ctr + insert , shift + insert, and shift+del. Thanks in advance opetran Hold down the Alt key and then press + on the numeric keypad to display the Customize Keyboard dialog and in turn press each of those key combinations and use the Remove button to remove whatever association has been assigned to them in place of the default. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid pr...