Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

quick question about copy and paste

11 replies [Last post]
Tue, 2016-12-20 15:43
miles goodchild
User offline. Last seen 6 years 18 weeks ago. Offline
Joined: 19 Dec 2016
Posts: 11
Groups: None

Quick question as I don't have Primavera I can't answer a simple question:  Can you copy and paste a simple table showing the items below out of Primavera and into Excel?

Many thanks

 

A reference (user entered number 1-200)

Name

Start

Finish

Basline Start

Baseline Finish

RAG (user entered - Red, Amber, Green, Complete)

% complete

Status date for the plan

Milestone (is this item a milestone - system generated I assume)

Critical (is this item on the critical path - system generated)

Plan name

Top

Replies

Fri, 2017-01-06 13:14
#1
Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

I am not sure about ASTA but you would have to import the excel file into P6

Top
Fri, 2017-01-06 12:56
#2
Robert Bell
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 49
Groups: None

Is Mike not saying that you can copy paste from excel back into Asta? You can't do this in P6.

Top
Thu, 2016-12-22 13:24
#3
Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Robert you can do this in p6 now except for the RAG set up your columns and select all of your activities right click and select export to excel 

Top
Wed, 2016-12-21 15:56
#4
Robert Bell
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 49
Groups: None

Hi Mike,

Wow I can see how that feature would be VERY useful. P6 needs to gain this function!

Rob

Top
Wed, 2016-12-21 15:37
#5
Mike Testro
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors

Hi Robert. Yes the columns in Asta are a spreadsheet fully compatible with Excel or Lotus. It makes data entry a doddle. A full progress update in seconds. 

Best regards Mike Testro 

Top
Wed, 2016-12-21 15:19
#6
Robert Bell
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 49
Groups: None

Yes exporting is fine. Sorry, I thought Mike was referring purely to copy and paste. I may have been wrong.

Top
Wed, 2016-12-21 13:56
#7
Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

yes set al lthe columsn up as you want them then hghlight all of the activites then right click and select export to excel.

Top
Wed, 2016-12-21 12:17
#8
Robert Bell
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 49
Groups: None

Hi Mike,

Sadly no; the best you can do is to copy a single value into say, the activity name field. You cannot paste information in a table format. Is is possible in ASTA?

Rob

Top
Wed, 2016-12-21 11:38
#9
Mike Testro
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors

Hi Robert

Can you copy - paste it back again?

Best regards

Mike Testro

Top
Tue, 2016-12-20 16:45
#10
miles goodchild
User offline. Last seen 6 years 18 weeks ago. Offline
Joined: 19 Dec 2016
Posts: 11
Groups: None

thanks :)

Top
Tue, 2016-12-20 16:35
#11
Robert Bell
User offline. Last seen 5 years 41 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 49
Groups: None

Hi Miles,

Yes you can copy and paste anything like that from P6 into Excel.

Rob

Top