Welcome to Planning Planet, checkout the Guild of Project Controls Knowledge CAR

quick question about copy and paste

11 replies [Last post]
miles goodchild
User offline. Last seen 13 weeks 21 hours ago. Offline
Joined: 19 Dec 2016
Posts: 6
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

Replies

Zoltan Palffy
User offline. Last seen 1 day 23 hours ago. Offline
Joined: 13 Jul 2009
Posts: 1148

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

Robert Bell
User offline. Last seen 6 days 18 hours ago. Offline
Joined: 8 Jun 2016
Posts: 31
Groups: None

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

Zoltan Palffy
User offline. Last seen 1 day 23 hours ago. Offline
Joined: 13 Jul 2009
Posts: 1148

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 

Robert Bell
User offline. Last seen 6 days 18 hours ago. Offline
Joined: 8 Jun 2016
Posts: 31
Groups: None

Hi Mike,

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

Rob

Mike Testro
User offline. Last seen 1 day 19 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4208

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 

Robert Bell
User offline. Last seen 6 days 18 hours ago. Offline
Joined: 8 Jun 2016
Posts: 31
Groups: None

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

Zoltan Palffy
User offline. Last seen 1 day 23 hours ago. Offline
Joined: 13 Jul 2009
Posts: 1148

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

Robert Bell
User offline. Last seen 6 days 18 hours ago. Offline
Joined: 8 Jun 2016
Posts: 31
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

Mike Testro
User offline. Last seen 1 day 19 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4208

Hi Robert

Can you copy - paste it back again?

Best regards

Mike Testro

miles goodchild
User offline. Last seen 13 weeks 21 hours ago. Offline
Joined: 19 Dec 2016
Posts: 6
Groups: None

thanks :)

Robert Bell
User offline. Last seen 6 days 18 hours ago. Offline
Joined: 8 Jun 2016
Posts: 31
Groups: None

Hi Miles,

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

Rob