P6 Primavera V16.2

How can you make the bars on the Ghant Chart Deeper (More Width) I can get the rows in the columns bigger but not the bars on the Ghant Chart, surely this can be done for large presentations?

Z
Zoltan Palffy 👤 Member for 16 years 10 months

Tahir 

is it a ms sql database

give me your email adress and I will email instructions

1) Backup your P6 database

a) Log as SA into your Servername in SQL Server Management Studio

b) Expand database folder

c) Select your database --> Right-click on your database --> Tasks --> Backup

d) Choose your database, backup type, backup component and destination in General page

e) Click OK

2) Add the users manually in your new SQL Server

a) Expand Security Folder --> Right-click on Logins folder --> New Login

b) Add a new user pubuser in General page

c) Choose SQL Server Authentication

d) Type and confirm a password for pubuser

e) Uncheck Enforce password policy

f) Uncheck Enforce password expiration

g) Uncheck User must change password at next login

h) Click OK

i) Expand Security Folder --> Right-click on Logins folder --> New Login

j) Add a new user privuser in General page

k) Choose SQL Server Authentication

l) Type and confirm a password for privuser

m) Uncheck Enforce password policy

n) Uncheck Enforce password expiration

o) Uncheck User must change password at next login

p) Click OK

 

3) Restore your P6 database in your new SQL Server

a) Log as SA into your Servername in SQL Server Management Studio

b) Right-click on databases folder --> Restore a Database

c) Type the name of the database that you want to import in textbox To Database

d) Select From device --> Click on ellipsis button --> Add --> Browse your backup file

e) Check Restore checkbox of your backup.

4) As SA in SQL Server Management Studio, run sync script for all users

a) Run the following queries to resync the public (ex: pubuser) and privileged users (ex: privuser):

exec sp_change_users_login 'Update_One','pubuser','pubuser'

exec sp_change_users_login 'Update_One','privuser','privuser'

 

 
T
Tahir Nizam 👤 Member for 20 years 7 months

Good day All,

I want to transfer P6 database from one laptop to another new laptop, both are standalone installations. Exporting xer would take time and effort in recreating the WBS & OBS structures alongwith other settings.  Its SQL db

Any Idea ?

S
Santosh Bhat 👤 Member for 21 years 1 month

Robert, Primavera bar styles are essentially thin or thinner. It doesn't have much flexibility in presentation. I've actually used the product that I've developed Turbo-Chart to be abel to produce Gantt style charts from P6 data, and you can effectively set bars to be as thick as you like. It does require some creativity and discipline in applying codes/UDF values into P6 however, its explained here:  https://www.turbo-chart.com/turbo-chart-gantt-charts/

Z
Zoltan Palffy 👤 Member for 16 years 10 months

right click in the bar area and select bars 

got to the Bar Style and select the widest bar

Z
Zhang Haixiang 👤 Member for 21 years 1 month

I think it is not possible to set bar height in P6.

the workaround is to use 2 bars for each activity

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts