Maybe a new problem:
But how do you export the "activity type" for activities I have found the hammock definition under a heading "CON" part of "Constraints" export, but where is the WBS type the Start and finish Milestone types etc

IMPORTING DATA FROM EXCELL

A. CREATING DATA IN MSEXCELL
1.Open a New MsExcell file
2.Create your data where column headers should match the P3 compatible abbreviation (required column headings are ACT-Activity ID, TITLE-Activity Description, OD-Original duration)
3.DO NOT FORMAT THE CELLS of your excel file.
4.Saves your File in a DB4 format.
5.If prompter to save an active sheet only, click YES.
6.If prompted to save in DB4 format only, click YES.
7.CLOSE the file before importing to P3.

B. IMPORTING EXCELL DATA IN P3
1.Create a NEW P3 file
2.To Import including ACTIVITY CODES VALUE, create first the ACTIVITY CODES
3.Go to TOOLS, PROJECT UTILITIES, IMPORT
4.Click ADD, and create a new REPORT
5.Write the correct path of the DB4 file in the Enter path name and Input File cell (ex. File.dbf)
6.Click OK to close and click RUN
7.In the Output Option, point to Save in the ff. look file.
8.Click OK
9.Click CLOSE
10.Click YES, when prompted to Rerun Current Filter.


IMPORTING OR OPENING P3 DATA IN EXCELL

A. CREATING DATA IN P3
1.Create the P3 file
2.Go to TOOLS, PROJECT UTILITIES, EXPORT
3.Click ADD and create a new report file.
4.Click Content tab and insert data in the list box you want to export to EXCELL or click ALL CURRENT to export the entire data of P3 to EXCELL.
5.Click FORMAT tab, and create the DBF path and file name.
6.Click RUN and point to Save to ff: Look File.
7.Click OK to Close

B.INSERTING EXPORTED P3 TO EXCELL
1.Create a NEW file or OPEN an existing File.
2.To insert the P3 file, go to DATA, IMPORT EXTERNAL DATA
3.Click IMPORT DATA
4.Search for the exported P3 file in DBF format and click OK
5.Select a Cell, and click OK

GOOD MORNING MY PROFESSIONAL MEMBER

CAN YOU SEND ME THIS EXEL FILES FOR EXCELL TO P3

REGARDS

M.A. FAROOQI

Ruben,

I don’t have any problem exporting/ importing data from excel in P3v3.1.
Follow this steps and it may help.

1) Open your P3
2) Select Tool-> Project Utilities-> Summarize..
3) On the pop-up Summarize Projects Enter New Project name say: ABCD on Summary Project pull down box
4) Click + on Source projects and select the project you want to summarize
5) Click the Summarize by pull down box and select activity code to the level you want to summarize
6) Set your data date and the rest items that you required and click Summarize button
7) Open the New Project created say : ABCD
8) Select Tool-> Project Utilities-> Export..
9) Select Export File – Dbase – Schedule data or any format that you’re familiar and click Modify
10) Add all the fields you wanted to export
11) Click the Format Tab and Change the Name to new Filename that you wanted (note: dbf extension max of 9 characters only) and make sure the type is [.DBF] –III/IV
12) Add sorting if required
13) Click the Selection Tab if filter or selection is required
14) Click run and select View on Screen
15) The file created with .dbf extension by default is saved to P3OUT folder.
16) Open your Excel program and on Open dialog box change the files of type to dbase files (*.dbf) and look for your exported file
17) Update your data and save it to the same format
18) Import updated database (.dbf) using P3 Tools-> Project Utilities-> Import…

Your files should be updated. Let me know it you require further assistance.

Regards,
Rodel

amir, thx for info.
moral of the story: not all upgrade may be good to us.

Hi Ruben,

I don’t quite understand your query. Do you mean displaying subtotal per floor level in P3v3.1 or import data from a project created into summary using Tools-> Project utilities-> Summarize?

If you only wish to display the summary total on your P3v3.1 you can use Organize and on the Total column select Bottom or Top to display your subtotal. You don’t need to import it from excel because its automatic.

If you required the percentage import from the created Project by P3 Project utilities summarize menu then use import/export facility from Tools-> Project Utilities-> Import… (I assume you are familiar import/export facilities)

Regards,
Rodel

I implied, but didn’t state positively, that there is NO LIMIT to the number of activities if you use DBF files.

hi everybody,
i have XL files can manage and control primavera file. u save alot of time and make ur work life easier .by using them.
if u need it please contact me at my-email Ali.Alrashed@hotmail.com

regards
Ali

if you have access to p3 installation cd
get it
explore
find
utilities folder
open "excel" folder
there are excel interfaces

use it
to get or set to p3 activities or whatever

Hi Benjamin,

You can export any data in 4 format (i.e. - .PRN, .DBF, WK1 & WKS ).
Except .PRN, all three can be open with Excel file.
and you can import any data with DBF, WK1 and WKS format only.

There is one more way to open and modify a p3 project in ms excel , i.e. by Ra->Sample->Excel folder. By this way you can fully access your project in excel , and can do some modification in your project from there.

Thanks,

Prabin Kumar

I prefer DBF format which Excel can open it also.
There is some limitation on WK1 in Excel.

hi,

I do it as below

1. Export a template, select what field you need, to databass, dbf
2. Open that dbf file and fill up the information.
3.Save the file as check the "define"
4.Import the file again.

I think the trick is the define database field of excel.

Hope it’s helpful

Cheers
Fannie