Forum Sponsor:

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

9 replies [Last post]
Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
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/SDK_Magic_Tool.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 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

Update the SDK Magic Tool    

The second magic tool will be published in the coming few days, The SDK magic tool which was the first one has been updated and I invite all planners who have downloaded it to update their tool from this link

http://www.mediafire.com/file/ougb7bfikqdae9n/SDK_Magic_Tool.xlsm/file

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

The Primavera files <xer> that have been sent, are less than 10 mb.

I hope that it will be more cooperation to publish the software as soon as possible,

Please send any Primavera XER projects that more than 10 mb to the following email address :

ccpmagic@yahoo.com

or

ccpmagic@hotmail.com

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

The Primavera files <xer> that have been sent, are not enough to test the new free software.

I hope that it will be more cooperation to publish the software as soon as possible,

Please send any Primavera XER projects to the following email address :

ccpmagic@yahoo.com

ccpmagic@hotmail.com

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

After the great success of the free magic tool introduced in this subject and is now being used by hundreds of planners, it will be another new tool named the master tool to be used with the XER files.

In order to publish the master tool in the coming few weeks, I need to test it by using XER files that are being prepared by others, so I hope to receive any XER files from version 8 up to version 19 sending to the following email address :

ccpmagic@yahoo.com

ccpmagic@hotmail.com

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

The Magic Tool works very well with the excel versions that open all files in the same instance, but it hasn't been tested with the excel versions that open each file in a separate instance. 

I think there is no direct command in excel that can change these settings easily.

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

I would like to add a remark about the Primavera database hoping this remark can be supported by the Primavera experts.

Use several databases with a small amount of projects instead of a small amount of databases with a big amount of projects.

The tool introduced in this subject works very well under this rule.

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
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 hour 45 min ago. Offline
Joined: 13 Jul 2009
Posts: 2466
Groups: None

SDk can be used 

Mohammed Ali
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 16 Mar 2018
Posts: 22
Groups: None

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