Oracle Primavera - PM6 Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Thu, 2004-03-11 02:54 Permalink RE: Exporting time based periodic data to Excel Thanks Mr.Tamas Sipos It is working very much.. Regards, Harish Member for 21 years 7 months Member for 21 years 8 months Submitted by Tamas Sipos on Tue, 2004-03-09 10:56 Permalink RE: Exporting time based periodic data to Excel I forgot to log in... :( I posted this one below. Regards Tamas Member for 16 years 9 months Member for 16 years 9 months Submitted by PPAdmin on Tue, 2004-03-09 10:53 Permalink RE: Exporting time based periodic data to Excel Harish, Try this, but I have a sense that you dont need THIS solution. 1. Open your project, 2. Click on Activities bitbtn on the places-bar on the left, 3. Click on Activity Usage Profile tool on the upper Toolbar, 4. Select Show usage for All activities radio-button, 5. Select Tools // Report Wizard... from the main menu, 6. Select Use Current Screen radio-button, click Next, 7. Turn on Time Distributed Data check-box and then Select Resources from the list, click Next, 9. Click Fields... button and select required fields from Available Options, click OK, click Next, 10. Select Timescale, Time interval fields with the buttons, and other options with checkboxes below, click Next, 11. Group and sort in the next screen, 12. Filter in the next screen, 13. Change column sizes or Autosize if its ok for you, click Next, 14. Title your report, click Next, 15. Run your new report with Run Report... button, 16. Send report to an ASCII Text File by selecting ASCII Text File radio-button, (browse target folder and type filename with the ... button next to Output file input-box.), click OK, 17. Click Next to save your new report, 18. Click Finish, 19. Browse your saved text file in Excel, select All files from File type listbox 20. Check Comma check-box to separate fields. Best regards, Tamas Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Tue, 2004-03-09 09:40 Permalink RE: Exporting time based periodic data to Excel Hi, Can somebody help me out?? Regards, harish Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Mon, 2004-03-08 09:01 Permalink RE: Exporting time based periodic data to Excel Dear Tamas Sipos, I tried the Import / Export, but I couldnt get periodic data, means loading of cost or resources. Regards, Harish Member for 21 years 7 months Member for 21 years 8 months Submitted by Tamas Sipos on Wed, 2004-03-03 09:25 Permalink RE: Exporting time based periodic data to Excel Support \ Utilities \ ImportExport Member for 21 years 7 months Member for 21 years 8 months Submitted by Tamas Sipos on Wed, 2004-03-03 09:24 Permalink RE: Exporting time based periodic data to Excel Hello! There is a folder named Support on the P3E CD #2. In this folder you can find SDK Samples and Utilities. So in the SupportUtilitiesImportExport folder you can find the "magical" Import/Export utility. This is a self explaining tool, so have a nice exporting. Regards Tamas Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Wed, 2004-03-03 04:26 Permalink RE: Exporting time based periodic data to Excel Hi, Actually I need to prepare a Progress S-curve from the periodic data in Excel. Harish Member for 16 years 9 months Member for 16 years 9 months Submitted by PPAdmin on Wed, 2004-03-03 04:20 Permalink RE: Exporting time based periodic data to Excel GOOD DAY Actually ..u dont need to transfer data to excel anymore only u can export to p3 or ms project and then u can start from there to the excel... but y ???? they r both a data base now.... i think so... Log in or register to post comments
Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Thu, 2004-03-11 02:54 Permalink RE: Exporting time based periodic data to Excel Thanks Mr.Tamas Sipos It is working very much.. Regards, Harish
Member for 21 years 7 months Member for 21 years 8 months Submitted by Tamas Sipos on Tue, 2004-03-09 10:56 Permalink RE: Exporting time based periodic data to Excel I forgot to log in... :( I posted this one below. Regards Tamas
Member for 16 years 9 months Member for 16 years 9 months Submitted by PPAdmin on Tue, 2004-03-09 10:53 Permalink RE: Exporting time based periodic data to Excel Harish, Try this, but I have a sense that you dont need THIS solution. 1. Open your project, 2. Click on Activities bitbtn on the places-bar on the left, 3. Click on Activity Usage Profile tool on the upper Toolbar, 4. Select Show usage for All activities radio-button, 5. Select Tools // Report Wizard... from the main menu, 6. Select Use Current Screen radio-button, click Next, 7. Turn on Time Distributed Data check-box and then Select Resources from the list, click Next, 9. Click Fields... button and select required fields from Available Options, click OK, click Next, 10. Select Timescale, Time interval fields with the buttons, and other options with checkboxes below, click Next, 11. Group and sort in the next screen, 12. Filter in the next screen, 13. Change column sizes or Autosize if its ok for you, click Next, 14. Title your report, click Next, 15. Run your new report with Run Report... button, 16. Send report to an ASCII Text File by selecting ASCII Text File radio-button, (browse target folder and type filename with the ... button next to Output file input-box.), click OK, 17. Click Next to save your new report, 18. Click Finish, 19. Browse your saved text file in Excel, select All files from File type listbox 20. Check Comma check-box to separate fields. Best regards, Tamas
Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Tue, 2004-03-09 09:40 Permalink RE: Exporting time based periodic data to Excel Hi, Can somebody help me out?? Regards, harish
Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Mon, 2004-03-08 09:01 Permalink RE: Exporting time based periodic data to Excel Dear Tamas Sipos, I tried the Import / Export, but I couldnt get periodic data, means loading of cost or resources. Regards, Harish
Member for 21 years 7 months Member for 21 years 8 months Submitted by Tamas Sipos on Wed, 2004-03-03 09:25 Permalink RE: Exporting time based periodic data to Excel Support \ Utilities \ ImportExport
Member for 21 years 7 months Member for 21 years 8 months Submitted by Tamas Sipos on Wed, 2004-03-03 09:24 Permalink RE: Exporting time based periodic data to Excel Hello! There is a folder named Support on the P3E CD #2. In this folder you can find SDK Samples and Utilities. So in the SupportUtilitiesImportExport folder you can find the "magical" Import/Export utility. This is a self explaining tool, so have a nice exporting. Regards Tamas
Member for 22 years 3 months Member for 22 years 3 months Submitted by T M Harish on Wed, 2004-03-03 04:26 Permalink RE: Exporting time based periodic data to Excel Hi, Actually I need to prepare a Progress S-curve from the periodic data in Excel. Harish
Member for 16 years 9 months Member for 16 years 9 months Submitted by PPAdmin on Wed, 2004-03-03 04:20 Permalink RE: Exporting time based periodic data to Excel GOOD DAY Actually ..u dont need to transfer data to excel anymore only u can export to p3 or ms project and then u can start from there to the excel... but y ???? they r both a data base now.... i think so...
Member for
22 years 3 monthsRE: Exporting time based periodic data to Excel
Thanks Mr.Tamas Sipos
It is working very much..
Regards,
Harish
Member for
21 years 7 monthsRE: Exporting time based periodic data to Excel
I forgot to log in... :(
I posted this one below.
Regards
Tamas
Member for
16 years 9 monthsRE: Exporting time based periodic data to Excel
Harish,
Try this, but I have a sense that you dont need THIS solution.
1. Open your project,
2. Click on Activities bitbtn on the places-bar on the left,
3. Click on Activity Usage Profile tool on the upper Toolbar,
4. Select Show usage for All activities radio-button,
5. Select Tools // Report Wizard... from the main menu,
6. Select Use Current Screen radio-button, click Next,
7. Turn on Time Distributed Data check-box and then
Select Resources from the list, click Next,
9. Click Fields... button and select required fields from Available Options, click OK, click Next,
10. Select Timescale, Time interval fields with the buttons,
and other options with checkboxes below, click Next,
11. Group and sort in the next screen,
12. Filter in the next screen,
13. Change column sizes or Autosize if its ok for you, click Next,
14. Title your report, click Next,
15. Run your new report with Run Report... button,
16. Send report to an ASCII Text File by selecting ASCII Text File radio-button,
(browse target folder and type filename with
the ... button next to Output file input-box.), click OK,
17. Click Next to save your new report,
18. Click Finish,
19. Browse your saved text file in Excel, select All files from File type listbox
20. Check Comma check-box to separate fields.
Best regards,
Tamas
Member for
22 years 3 monthsRE: Exporting time based periodic data to Excel
Hi,
Can somebody help me out??
Regards,
harish
Member for
22 years 3 monthsRE: Exporting time based periodic data to Excel
Dear Tamas Sipos,
I tried the Import / Export, but I couldnt get periodic data, means loading of cost or resources.
Regards,
Harish
Member for
21 years 7 monthsRE: Exporting time based periodic data to Excel
Support \ Utilities \ ImportExport
Member for
21 years 7 monthsRE: Exporting time based periodic data to Excel
Hello!
There is a folder named Support on the P3E CD #2. In this folder you can find SDK Samples and Utilities.
So in the SupportUtilitiesImportExport folder you can find the "magical" Import/Export utility.
This is a self explaining tool, so have a nice exporting.
Regards
Tamas
Member for
22 years 3 monthsRE: Exporting time based periodic data to Excel
Hi,
Actually I need to prepare a Progress S-curve from the periodic data in Excel.
Harish
Member for
16 years 9 monthsRE: Exporting time based periodic data to Excel
GOOD DAY
Actually ..u dont need to transfer data to excel anymore
only u can export to p3 or ms project and then u can start from there to the excel...
but y ????
they r both a data base now....
i think so...