Forum Sponsor:

Oracle Construction and Engineering (formerly Primavera) is transforming the world by helping organizations plan, build, and operate critical assets with on-premise and cloud-based project portfolio management solutions.  Learn more about Oracle Construction and Engineering...

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

The shortest way to import and export the Primavera database records

3 replies [Last post]
Mohammed Ali
User offline. Last seen 3 days 5 hours ago. Offline
Joined: 16 Mar 2018
Posts: 16
Groups: None

I would like to share the magic tool that can be used to view, update and delete the Primavera database records.

It can be used with Excel 2007 and 2010 where the other versions haven't been completely tested yet.

The aim of sharing is to help the persons who need a fast way and a powerful tool between Excel and Primavera, on the other hand it will be very grateful and appreciated if you share your comments to improve the magic tool or to fix any errors that may occur.

The download link is  http://www.mediafire.com/file/ougb7bfikqdae9n/PM_Advanced.xlsm/file

How to import data    https://youtu.be/YjVqyzOCgSE

How to export data Project and Dictionary part 1      https://youtu.be/K_kmIBsUxxY

How to export data Project and Dictionary part 2      https://youtu.be/aeP4-QUNW8w

How to export data WBS and Activities part 3           https://youtu.be/lO0HLvHnu1Q     

 

For the same videos in Arabic

How to import data    https://youtu.be/VbAuokYeJWk

How to export data Project and Dictionary part 1     https://youtu.be/OKJRYkNVFr4

How to export data Project and Dictionary part 2     https://youtu.be/_BIYWKN6DMg

How to export data WBS and Activities part 3          https://youtu.be/Ft0RzSSB07M      

Replies

Mohammed Ali
User offline. Last seen 3 days 5 hours ago. Offline
Joined: 16 Mar 2018
Posts: 16
Groups: None

For all persons who would like to use the magic tool, it is strongly recommended to see the whole video before using it to know the required settings because I have received many messages from the persons who started to use the magic tool before applying the required settings.

This is the link of the video that contains the settings in its last 7 minutes

In English        https://youtu.be/YjVqyzOCgSE

In Arabic          https://youtu.be/VbAuokYeJWk

Zoltan Palffy
User offline. Last seen 1 day 15 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2203
Groups: None

SDk can be used 

Mohammed Ali
User offline. Last seen 3 days 5 hours ago. Offline
Joined: 16 Mar 2018
Posts: 16
Groups: None

I would like to add that your Excel version must be 32 bit.