Exporting outside P3, is better using the dbf format, also if you will organize your data with excel.
Exporting in wk1 you can find with big surprise that all the data were not exported successfully.
There is a limitation in 1024 rows (including one heading row).
Exporting with ODBC is great for small schedule, or you can encore in an out of time message.
More over I had always problems with the P3 ODBC, as look like P3 is not able to replicate completely the its own databases. Having problem after to link the tables.
Primavera has also nice tools like RA engine and Report maker or writer that may be another solution.
IMHO one of the major drawbacks of P3 is the quality of presentation of reports available. The reason people export data to Excel is to provide the presentation that is common place these days. The actual data is no different, but the presentation of the data is always a useful means toward acceptance.
There are several methods of exporting data to Excel (or Access), from within P3 you can export info to Excel readable files (Lotus) or export to DBF files that can be read by Access.
Easiest method is to copy & paste directly.
There are some reports which provide output to Excel which can be then used for further processing (Tools, Tabular Reports, Resouce, Loading) gives the distribution of Quantity over time (there is an equivalent one for cost)but with large numbers (I think the field limit is 10 characters) I have noticed some inaccuracies in the transfer.
HTH
Member for
22 years 11 months
Member for23 years
Submitted by Steven Oliver on Wed, 2004-10-27 12:01
IMHO one of the major drawbacks of P3 is the quality of presentation of reports available. The reason people export data to Excel is to provide the presentation that is common place these days. The actual data is no different, but the presentation of the data is always a useful means toward acceptance.
There are several methods of exporting data to Excel (or Access), from within P3 you can export info to Excel readable files (Lotus) or export to DBF files that can be read by Access.
Easiest method is to copy & paste directly.
There are some reports which provide output to Excel which can be then used for further processing (Tools, Tabular Reports, Resouce, Loading) gives the distribution of Quantity over time (there is an equivalent one for cost)
Member for
22 years 6 monthsRE: P3 to Excel Template Reports
Gary,
I would suggest that you get to grips with the standard graphic reports in P3 first.
Once you know the graphic reports, you can start to create custom reports and pull it into Excel.
Regards
Erik
Member for
22 years 3 monthsRE: P3 to Excel Template Reports
Exporting outside P3, is better using the dbf format, also if you will organize your data with excel.
Exporting in wk1 you can find with big surprise that all the data were not exported successfully.
There is a limitation in 1024 rows (including one heading row).
Exporting with ODBC is great for small schedule, or you can encore in an out of time message.
More over I had always problems with the P3 ODBC, as look like P3 is not able to replicate completely the its own databases. Having problem after to link the tables.
Primavera has also nice tools like RA engine and Report maker or writer that may be another solution.
Member for
22 years 8 monthsRE: P3 to Excel Template Reports
Hi
I did found P3 can produce some very useful report like
S-Curve with EV
Resource Histogram in $ & Hrs
for the basic operation of Project
Alex :)
Member for
22 years 11 monthsRE: P3 to Excel Template Reports
Gary,
IMHO one of the major drawbacks of P3 is the quality of presentation of reports available. The reason people export data to Excel is to provide the presentation that is common place these days. The actual data is no different, but the presentation of the data is always a useful means toward acceptance.
There are several methods of exporting data to Excel (or Access), from within P3 you can export info to Excel readable files (Lotus) or export to DBF files that can be read by Access.
Easiest method is to copy & paste directly.
There are some reports which provide output to Excel which can be then used for further processing (Tools, Tabular Reports, Resouce, Loading) gives the distribution of Quantity over time (there is an equivalent one for cost)but with large numbers (I think the field limit is 10 characters) I have noticed some inaccuracies in the transfer.
HTH
Member for
22 years 11 monthsRE: P3 to Excel Template Reports
Gary,
IMHO one of the major drawbacks of P3 is the quality of presentation of reports available. The reason people export data to Excel is to provide the presentation that is common place these days. The actual data is no different, but the presentation of the data is always a useful means toward acceptance.
There are several methods of exporting data to Excel (or Access), from within P3 you can export info to Excel readable files (Lotus) or export to DBF files that can be read by Access.
Easiest method is to copy & paste directly.
There are some reports which provide output to Excel which can be then used for further processing (Tools, Tabular Reports, Resouce, Loading) gives the distribution of Quantity over time (there is an equivalent one for cost)
HTH