To all Engineers who use the Primavera's Magic Tools Family

What is the magic tool?

Hi Mohammed,

Thanks for the valuable tools. However, SDK magic tool is not working as it shows error when i opened in first instance. Even after it got opened when i click open table after selecting the list of table from drop down menu the excel file got closed automatically. Is there is any solution to open this file?

Regards,

Murali

Hi Murali,

You should see the last 6 minutes of this video

https://www.youtube.com/watch?v=YjVqyzOCgSE

to know exactly the required settings to use the SDK Magic Tool.

In general you should use Excel 2007 or 2010 where it must be 32 Bit.

The SDK Magic Tool works only with Oracle and SQL database.

Primavera SDK development kit must be installed.

You should create an ODBC connetion for any database you would like to view or modify.

Try to use the second part of the tool and send me any error message as a screen shot to search for a solution.

You can download the 37 Excel files which illustrate exactly how you can use the SDK Magic tool from this link.

http://www.mediafire.com/file/o1g4j8qw7rmk3pg/Primavera_SDK_Samples.zip/file

Most of the files have three sheets:

The first one represents the current status in Primavera.

The second sheet includes the required changes which may be  adding or removing or modifying.

The third sheet makes a comparison to assure that all modifications have be done by the SDK Magic tool as required.

You can also update all tools from these links:

SDK Magic Tool:         

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

XER Magic Tool:        

http://www.mediafire.com/file/xo2ps4q5erc281q/XER_Magic_Tool.xlsm/file

XLS Magic Tool:       

http://www.mediafire.com/file/7ill1qgdz9lwntx/XLS_Magic_Tool.xlsm/file

SQL Magic Tool:     

http://www.mediafire.com/file/9wioa7aby27pcm4/SQL_Magic_Tool.xlsm/file

See these videos:

for SDK

https://www.youtube.com/watch?v=YjVqyzOCgSE

for XER

https://www.youtube.com/watch?v=Wod1gCjoDlw

for XLS

https://www.youtube.com/watch?v=6fx25pT-Hao

for SQL

https://youtu.be/smwQICF536Q