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.

Import Excel, not taking in the Original Duration...

2 replies [Last post]
Mon, 2009-05-11 09:40
Tim Breeding
User offline. Last seen 14 years 40 weeks ago. Offline
Joined: 11 May 2009
Posts: 19
Groups: Petro-Chem / Oil & Gas
So I’m trying to import data into P6 via excel, but it’s not taking in the Original Duration correctly. It’s putting the budgeted units in place, so I end up with 1 unit/time. (ie... 64hrs & 64 budgeted labor units).

I’ve used this template plenty of times on other systems and it works. This is a fresh install, so are there some settings or something I should be concerned about. I compared my preferences side by side to the other systems and made sure they were the same.

Also, to troubleshoot, I deleted all of the BLU’s in the excel file and left the OD in there. It then put the OD’s in place of the BLU’s. So who knows? I’m assuming I’m missing some setting somewhere.

Any clues?
Top

Replies

Tue, 2009-05-12 01:03
#1
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Tim,

You need to cite an example in order to easily understand what you need.

Anyway, the default of duration type is "Fixed Duration & Units’ whenever you create a new a project. This is only applicable when you create or add new activities.

Regards.

Top
Mon, 2009-05-11 15:17
#2
Tim Breeding
User offline. Last seen 14 years 40 weeks ago. Offline
Joined: 11 May 2009
Posts: 19
Groups: Petro-Chem / Oil & Gas
OK, so no one replied and I figured it out on my own.

Just in case anyone cares, You have to go to the Defaults tab for the given project you are importing to and change the Duration Type to ’Fixed Duration & Units.’

Top