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

Submitted by jwobrien on
Oracle Primavera - PM6

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:50
Permalink

Hi David,

Thanks for your response. 

Regards

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:44
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:07
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:06
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:06
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:06
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:05
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:05
Permalink

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

Member for

7 years 5 months
Member for 7 years 5 months
Submitted by jwobrien on Mon, 2023-12-04 21:05
Permalink

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

Member for

9 years 8 months
Member for 9 years 8 months
Submitted by David Kelly on Mon, 2023-12-04 18:47
Permalink

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.

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Mon, 2023-12-04 14:50
Permalink

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.