Import excel - P3
In the Open Standard
Benoit GosselinMember for 20 years 3 months
- Created
- 1
- 1
0
I did a cotation using an excel sheet, now that we have the contract, I need to import that sheet in P3.
In my cotation I have these informations:
-Activity number = ACT
-Task description = TITLE
-Ressource (trade) = RES
-Number of ressources = UPT
-Total hours of the task = BQ
-Duration of the task = OD
I want to import the data in P3 (the ressource quantity must driven the OD, and BQ must be fixed). (Ressource qty x OD = BQ ???)
Can you tell me the headers to write in my excel sheet?
In my cotation I have these informations:
-Activity number = ACT
-Task description = TITLE
-Ressource (trade) = RES
-Number of ressources = UPT
-Total hours of the task = BQ
-Duration of the task = OD
I want to import the data in P3 (the ressource quantity must driven the OD, and BQ must be fixed). (Ressource qty x OD = BQ ???)
Can you tell me the headers to write in my excel sheet?
1 reply
Oldest first- 0Nigel Winkley ·Benoit
The simplest way is to start at new project with the correct start date. Add one activity, "Project Start", as a milestone with the correct date. Add the main codes that you are planning to use.
Now export the project including all fields (All Current). Use this as the basis to import your data. This way you have the correct headings at the top of your sheet.
Copy and paste and then import. All you have to do is add the relationships.
Cheers
Nige
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?