Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 Primavera V16.2

7 replies [Last post]
Robert Corran
User offline. Last seen 18 weeks 1 day ago. Offline
Joined: 6 Dec 2003
Posts: 26
Groups: None

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?

Replies

Zoltan Palffy
User offline. Last seen 1 hour 38 min ago. Offline
Joined: 13 Jul 2009
Posts: 2769
Groups: None

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'

 

 
Tahir Nizam
User offline. Last seen 27 weeks 6 days ago. Offline
Joined: 17 Oct 2005
Posts: 3
Groups: None

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 ?

Robert Corran
User offline. Last seen 18 weeks 1 day ago. Offline
Joined: 6 Dec 2003
Posts: 26
Groups: None

Thank you I will take a look

Santosh Bhat
User offline. Last seen 10 hours 24 min ago. Offline
Joined: 15 Apr 2005
Posts: 281

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/

Zoltan Palffy
User offline. Last seen 1 hour 38 min ago. Offline
Joined: 13 Jul 2009
Posts: 2769
Groups: None

right click in the bar area and select bars 

got to the Bar Style and select the widest bar

Robert Corran
User offline. Last seen 18 weeks 1 day ago. Offline
Joined: 6 Dec 2003
Posts: 26
Groups: None

Surely there must be a way? 

Zhang Haixiang
User offline. Last seen 8 weeks 6 days ago. Offline
Joined: 14 Apr 2005
Posts: 249
Groups: None

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

the workaround is to use 2 bars for each activity