quick question about copy and paste

11 replies [Last post]
miles goodchild
User offline. Last seen 43 weeks 1 day 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 7 hours 54 min ago. Offline
Joined: 13 Jul 2009
Posts: 1498

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

Robert Bell
User offline. Last seen 4 hours 6 min ago. Offline
Joined: 8 Jun 2016
Posts: 46
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 7 hours 54 min ago. Offline
Joined: 13 Jul 2009
Posts: 1498

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 4 hours 6 min ago. Offline
Joined: 8 Jun 2016
Posts: 46
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 9 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4277

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 4 hours 6 min ago. Offline
Joined: 8 Jun 2016
Posts: 46
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 7 hours 54 min ago. Offline
Joined: 13 Jul 2009
Posts: 1498

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 4 hours 6 min ago. Offline
Joined: 8 Jun 2016
Posts: 46
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 9 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4277

Hi Robert

Can you copy - paste it back again?

Best regards

Mike Testro

miles goodchild
User offline. Last seen 43 weeks 1 day ago. Offline
Joined: 19 Dec 2016
Posts: 6
Groups: None

thanks :)

Robert Bell
User offline. Last seen 4 hours 6 min ago. Offline
Joined: 8 Jun 2016
Posts: 46
Groups: None

Hi Miles,

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

Rob