I think Frank already answer the question. If you combine the planning (P3) skill with Database skill (VB). U can then automate progress updating processes and reporting porcesses. Especially if you have ten of thousands of activity update each month and your engineers refuse to use P3 as a tool to update.
However, having said that, you need a lot more other skills to become a good planner, the automation only allows the planner to do better thing rather then data entry.
Things like schedule analysis.
Regards
Alex
Member for
24 years 6 months
Member for24 years6 months
Submitted by Frank Borcherdt on Mon, 2005-05-30 05:53
Knowing VB or VBA will allow you to use the P3 object model (Ra) to automate updating and reporting from P3.
If you use the ODBC drivers then you can link the data files to MS Access/Excel and VBA is the underlying macro language...again to automate P3 processing/reporting.
ODBC drivers can also be used by Crystal Reports or any other ODBC compliant reporting tool to produce reports that include data from multiple systems (say P3 and our accounting system) provided you do a little upfront data analysis and structure the codes in both systems to be common (this provide the linkage you will need) and this normally requires someone with a software background.
Does not improve you knowledge of P3 but allows you to add value to the outputs over and above what is possible from P3 alone.
Member for
20 years 7 monthsRE: No Subject Specified
Thankyou all of you for your valuable inputs.
Cheers
Sunil
Member for
22 years 8 monthsRE: No Subject Specified
Sunil
I think Frank already answer the question. If you combine the planning (P3) skill with Database skill (VB). U can then automate progress updating processes and reporting porcesses. Especially if you have ten of thousands of activity update each month and your engineers refuse to use P3 as a tool to update.
However, having said that, you need a lot more other skills to become a good planner, the automation only allows the planner to do better thing rather then data entry.
Things like schedule analysis.
Regards
Alex
Member for
24 years 6 monthsRE: No Subject Specified
Sunil,
Knowing VB or VBA will allow you to use the P3 object model (Ra) to automate updating and reporting from P3.
If you use the ODBC drivers then you can link the data files to MS Access/Excel and VBA is the underlying macro language...again to automate P3 processing/reporting.
ODBC drivers can also be used by Crystal Reports or any other ODBC compliant reporting tool to produce reports that include data from multiple systems (say P3 and our accounting system) provided you do a little upfront data analysis and structure the codes in both systems to be common (this provide the linkage you will need) and this normally requires someone with a software background.
Does not improve you knowledge of P3 but allows you to add value to the outputs over and above what is possible from P3 alone.
Member for
20 years 7 monthsRE: No Subject Specified
Sukumar,
Its to integrate P3 and Access.
Alex
Do you mean to say that knowing VB really helps in your P3. Could you add more on this if you have some personnel experiences.
Cheers
Sunil
Member for
20 years 8 monthsRE: No Subject Specified
Hi guys,
What the discussion about? Is it planning programmer vs software programmer.
The topic is not very clear.
Regards.
Member for
22 years 8 monthsRE: No Subject Specified
Sunil
Software programmer
Alex