Import Only Resource Names & Resource I.D.

Thank you Zoltan for your recommendation, it is really appreciated.

Dear VIKAS KULKARNI

This ٍSDK magic tool can do the job and you can use it on excel from 2007 till 2019 but it must be 32 bit

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

This file has the required settings:

http://www.mediafire.com/file/p8qgz8cu0yx2tu0/SDK_Settings.xlsx/file

This video illustrates how to export resources:

https://youtu.be/_BIYWKN6DMg

If you need to export resources and roles only the RSC magic tool is a special tool for this purpose, this is the download link:

http://www.mediafire.com/file/amyxfol2iawi65x/RSC_Magic_Tool.xlsm/file

It can be used only on excel 2007 and 2010 and this video illustrates how you can use it:

https://www.youtube.com/watch?v=6zFMpHmiEXc&feature=youtu.be

Both tools are free.

as you see in your example at the top of the column resource name DOES NOT have an ASTERICKS *

however, the Resource Type does have an Astericks * ANY COLUMN HEADING WITH AN ASTERICKS * IN NOT IMPORTABLE.

in other works the resource must already be in the resource dictionary then the budgeted, actual and forecated information can be updted.

The only way to work around this was to use SDK that came with P6 (SDK stands for software development Kit)

and there are spreadhseets that can be use dto import the dictionaries of resources, activity codes and cost accounts things you typically can not do. This can only be used in a 32 byte environment.

The only acception now is to use Modhammads magic tool to do this. If you have a version of excel 2010 or less it should work.

as you see in your example at the top of the column resource name DOES NOT have an ASTERICKS *

however, the Resource Type does have an Astericks * ANY COLUMN HEADING WITH AN ASTERICKS * IN NOT IMPORTABLE.

in other works the resource must already be in the resource dictionary then the budgeted, actual and forecated information can be updted.

The only way to work around this was to use SDK that came with P6 (SDK stands for software development Kit)

and there are spreadhseets that can be use dto import the dictionaries of resources, activity codes and cost accounts things you typically can not do. This can only be used in a 32 byte environment.

The only acception now is to use Modhammads magic tool to do this. If you have a version of excel 2010 or less it should work.

While I do not use P6 transferring of fields I do frequently within my software.  Resource creation requires more than ID and name fields, if you do not transfer all required fields you might get nothing, better let P6 figure it out for you. One that is missing is resource calendar; others that might be missing will depend on your software.  If the calendar is missing in your database you must either define it or transfer prior to transfer the resources, same goes with other transfers.

Be remided that some transfers can supersede previous data, say you transfer a calendar that exists in your database some unintended changes might happen, that can be a huge problem with other projects using same calendar code. Because of this it might be convenient to add some prefix to the field codes prior to transfer.

P6 Professional Importing and Exporting Guide

Good Luck

If you have Excel 2007 or 2010, Please confirm.