Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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]
miles goodchild
User offline. Last seen 7 years 2 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

Replies

Zoltan Palffy
User offline. Last seen 8 weeks 3 hours 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

Robert Bell
User offline. Last seen 6 years 25 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.

Zoltan Palffy
User offline. Last seen 8 weeks 3 hours 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 

Robert Bell
User offline. Last seen 6 years 25 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

Mike Testro
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4420

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 years 25 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.

Zoltan Palffy
User offline. Last seen 8 weeks 3 hours 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.

Robert Bell
User offline. Last seen 6 years 25 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

Mike Testro
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4420

Hi Robert

Can you copy - paste it back again?

Best regards

Mike Testro

miles goodchild
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 19 Dec 2016
Posts: 11
Groups: None

thanks :)

Robert Bell
User offline. Last seen 6 years 25 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