Exporting time based periodic data to Excel

T
T M Harish 👤 Member for 22 years 10 months
Oracle Primavera - PM6
T
T M Harish 👤 Member for 22 years 10 months
· Permalink

Thanks Mr.Tamas Sipos



It is working very much..



Regards,



Harish


F
Forum Guest 👤 Member for 17 years 4 months
· Permalink

Harish,



Try this, but I have a sense that you don’t 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 it’s 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

T
T M Harish 👤 Member for 22 years 10 months
· Permalink

Dear Tamas Sipos,



I tried the Import / Export, but I couldn’t get periodic data, means loading of cost or resources.



Regards,



Harish

T
Tamas Sipos 👤 Member for 22 years 3 months
· Permalink

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

T
T M Harish 👤 Member for 22 years 10 months
· Permalink

Hi,

Actually I need to prepare a Progress S-curve from the periodic data in Excel.



Harish

F
Forum Guest 👤 Member for 17 years 4 months
· Permalink

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...

Forum Sponsor

Top Posters

sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts