Skip to content
ProjectControls.com
Oracle Primavera - PM6

Database Cleanse - Is it possible to change Baseline Global Calendars to Project Calendars

In the Open Standard
J OBrienMember for 8 years 4 months
Created
11
8
0

Hi All,

I'm the P6 administrator for a large portfolio of projects that I've inherited and am in the process of cleansing the database, starting with global calendars. I have numerous calendars assigned to historical and current projects (both of which can't be deleted) that all have multiple baselines assigned i.e. post weekly status updates.

For situations where there are only a smaller number of projects utilising a global calendar that I want to delete, I can create a new project calendar (based on the existing global calendar), open the relevant projects and replace the global calendar with the new project calendar and then delete the global calendar when complete. Easy in a simple situation like that.

My question is: Is there any way to replace a global calendar with a project calender where it is assigned to multiple projects and baselines without opening the projects or removing the baselines? I have been told that it is possible in the back end of the database but I can't find any information about that online and I don't know if that functionality exists in the update baseline option.

Any help would be greatly appreciated.

Cheers

 

Save Follow Follow forum Report
Reply New topic

11 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    #1

    The quick answer is NO.If you

    The quick answer is NO.

    If you can run a query from the P6 Database (SQL or Oracle) on the tables CALENDAR and TASK, using a one-to-many relationship query, filter on table CALENDAR, field CLNDR_TYPE = CA_Base. This will show the number of projects using the Global Calendar (Baseline, Project, etc.). Run a summary query on the field PROJ_ID to get the number of projects for each Global calendar that you need to create and assign to a project.

    You can create a backup copy of the database and perform a manual update by:
    If you possess a strong background in the P6 database, you can manually add a calendar, edit the field PROJ_ID, assign it to PROD_ID, and change the CLNDR_TYPE to CA_Project in the CALENDAR table. Afterward, replace the CLNDR_ID in the TASK table for all tasks corresponding to each PROJ_ID with the newly created CLNDR_ID in the CALENDAR table.

    Note:
    BEWARE - If you do not have a good knowledge of the database, your data may become corrupt, and ORACLE does not support direct edits to the P6 Database.

    Report
  2. 0
    David Kelly ·
    #2

    We do this sort of stuff

    We do this sort of stuff quite regularly. But only by writing a Java program that uses the API, or you get into the mess that Rodel describes. Calendars are hard to play with, even through the API.
    Report
  3. 0
    J OBrien ·
    #3

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  4. 0
    J OBrien ·
    #4

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  5. 0
    J OBrien ·
    #5

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  6. 0
    J OBrien ·
    #6

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  7. 0
    J OBrien ·
    #7

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  8. 0
    J OBrien ·
    #8

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  9. 0
    J OBrien ·
    #9

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  10. 0
    J OBrien ·
    #10

    Hi Rodel,Thanks for your

    Hi Rodel,

    Thanks for your response. I don't have enough experience with that process you've described but I'll pass that information on to our database manager to see what they can do. Thanks

    Report
  11. 0
    J OBrien ·
    #11

    Hi David,Thanks for your

    Hi David,

    Thanks for your response. 

    Regards

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?