SQLIte | Primavera Scheduling

Feb

P6 Version 20.12 Released

Categories: Activity Relationships, P6 Calendars, P6 Professional, Primavera Resources, Resources, Schedule Options, SQLIte

Tags: dissolve activities, Financial Periods, Primavera P6 Professional, Relationship Lag, schedule options

Comments Off

by Bill Pepoon

Oracle released Version 20.12 of Primavera Professional Project Management in December 2020. If you have not upgraded P6 recently, here are some of the most salient improvements since 2018:

Dissolve Activities With Or Without Lag: You can choose whether or not to retain lag when dissolving activities using the Retain lag setting in the Calculations tab of the User Preferences Dialog. If you choose to retain lag, the lag from the dissolved activity's predecessor relationship will be added to that of its successor relationship and applied to the new relationship. (Version 19.5)

Improvements to Stored Images Functionality: Multiple images can be uploaded at the same time. (Version 19.7)

Project Code Maximum Length Changed: The maximum length for Project Codes in PPM databases is 60 characters. (Version 19.7)

Scheduling and Leveling Options Can Be Exported to and Imported From Primavera XML: When you export projects to Primavera XML format, scheduling and leveling options are included. When importing the Primavera XML file, you can choose whether to import with the Update Existing or Keep Existing import actions against the scheduling and leveling options. (Version 19.8)

Allow or Restrict Access to Resources From Multiple Parent Resources: You can select up to five resources when defining which resources a user can access. The user can access and use the selected resources and all child resources of the selected resources. (Version 19.9)

Choose to Export Primavera XML Files Into a Compressed File: When you export projects in Primavera XML format you can choose to have the files exported to a single compressed file in .zip format. (Version 19.10)

Add Comments About Relationships: Add the Comments column in the Relationships detail window to add extra information about the relationship, for example to explain the need for lag assigned to the relationship or the need for the relationship itself. Relationship comments are plain text and can be up to 250 characters long. This is my favorite new feature. (Version 20.4)

Categorize and Organize Activities and Assignments Using Role Codes: With potentially hundreds of roles being used across an enterprise of projects, role codes provide another method for filtering the roles you need to access quickly, or for grouping, sorting, and filtering roles and role assignments. (Version 20.6)

Improved Control of Options When Scheduling Multiple Projects: In the Scheduling Options dialog box, you can select which of the open projects options will be used when you schedule multiple projects. In the Level Resources dialog box, you can select which of the open projects leveling options will be used when you level multiple projects. You can generate scheduling and leveling log files as HTML files. (Version 20.6)

Fill Down and Fill Across Quickly in the Resource Assignment Spreadsheet: You can fill data on the Resource Assignment Spreadsheet window from shortcut (right click) menu. (Version 20.8)

Fill Down Multiple Cells in the Resource Usage Spreadsheet of the Activities View: You can fill data on the Resource Usage Spreadsheet pane from several cells simultaneously. Select multiple contiguous cells by holding down shift while clicking the first and last cells in the range, then select the rows to copy to using either shift and click (to select contiguous rows) or Ctrl and click (to select separate rows), then right click to select the Fill Down menu item. (Version 20.9)

Financial Period Calendars Allow You to Use Different Financial Periods for Different Projects: You can create multiple financial period calendars with different periods. The different financial period calendars can have different durations as well as different start and end dates to each period. You can create new financial period calendars from scratch or duplicate an existing calendar as the basis for a new financial period calendar. (Version 20.10)

Copy Dates to Other Assignments Using Fill Down in Resource Usage: You can use fill down to populate dates in the Resource Usage Spreadsheet of the Activities window of P6 Professional. Fill down options for start and finish dates are available both in the Activity Resource Assignments section and the spreadsheet columns. (Version 20.10)

Easily See Exact Values for Histogram Bars: You can select to view the values for bars on histograms and stacked histograms in the options for the Activity Usage Profile, Resource Usage Profile, and Tracking View. (Version 20.10)

Categorize and Organize Assignments Using Codes: With potentially many thousands of active resource and role assignments across hundreds of projects, assignment codes provide another method for grouping, sorting, and filtering the assignments you need to access quickly. (Version 20.11)

+ Add a Block or drag an element into the page

Sep

P6 Version 17 Bug and Easy Fix

Categories: Claim Digger, Primavera P6, SQLIte

Comments Off

by Bill Pepoon

Oracle recently released Version 18 of its venerable scheduling program, Primavera P6 Professional Project Management. The latest release is only a mild upgrade from Version 17 but it does fix a problem that has bedeviled many Version 17 users: the inability to copy and paste a project that is not currently open. This error only occurs when using the standalone SQLite database. Specifically a popup message reads “Item Not Found”. If the user clicks “OK” to continue the project is copied but contains no activities.

Oracle acknowledged this bug in Document ID 2338899.1

P6 Professional Patch Set 17.12.1.0 fixes the problem. But users who are not familiar with how to apply a patch can apply a very easy fix. Simply open the project before trying to copy the project. Indeed, both the patch and Version 18 address this bug by opening the project automatically during the copy and paste operation. In effect, users can only copy and paste open projects when using the SQLite database.

Personally, I like to use the SQLite database because it requires no maintenance and can easily be moved to another computer. Moving programs from one computer to another is normally a joyless exercise but not with SQLite. And yes, the database is a program, just like Primavera P6.

I initially resisted using the SQLite database because Oracle had disabled Schedule Comparison (i.e. Claim Digger) when using this standalone database. But eventually Oracle figured out a way to make Schedule Comparison work with SQLite. For anyone who does not need to share a database with other users I highly recommend SQLite.

All posts in SQLIte

P6 Version 20.12 Released

P6 Version 17 Bug and Easy Fix