How to feed directly the quantities of a Resources in the spreadsheet of Primavera P-6

Friends any help will be highly appriciated

Hi,

You can install SDK and use the excel sheets given by Primavera to input the data in the database. Once y ou are done installing SDK you can update the post and i will email the files to you :)

Regards

Amit

Dear Amit

Would you mind telling me how I can install SDK?

Thanx - Tanveer

Hi,

You can use CD1 in your Primavera Set for installing SDK. Choose option "modify" when installing Primavera and then you can choose SDK as an option to install.

Regards

Amit

Dear Amit

when i try to modify my program. The following error message i got

Bad public user name or password. Database Server Error: Login failed for user 'pubuser'.
Cannot open database "pmsdk$primavera" requested by the login. The login failed.;

Can you please  help me in configuring pmsdk.. i followed the same steps as been stated by you. i.e.

I Choose option "modify" when installing Primavera and then i  choose SDK as an option to install.

Regards

Faisal Hashmi

Hi,

The default password for username:"pubuser" is "pubuser" without quotes. It should work with that.

Regards

Amit

Hai Sayed

For configuring SDK Type the Database Name as pmdb$primavera not(pmsdk$primavera)

Regards

Anbin

Thanks Anbin & Amit

I think I have successfully configured the PMSDK database.

When I  login to Primavera using PMSDK database the screen is same

as that of PMDB database. ( Is it configured correctly??)

Yes Amit what next I have to do to feed the quantity using spreadsheet of Primavera.

Regards

Faisal Hashmi

Faisal..

if u have same resources and different quantities, add up quantities for same, make new activity, change type to LEVEL OF EFFORT for that activity. link that activity SS with first activity & FF with last activity for a specific WBS. add resources in that activity. go to resources assignment. copy and paste to excel.

Usman

Faisal..

if u have same resources and different quantities, add up quantities for same, make new activity, change type to LEVEL OF EFFORT for that activity. link that activity SS with first activity & FF with last activity for a specific WBS. add resources in that activity. go to resources assignment. copy and paste to excel.

Usman

Hi Syed,

Glad to know you were able to configure SDK. When you login to Primavera using PMSDK, u will get the same data as PMDB. The schema for PMSDK is different cause SDK contains calculated fileds like "Total Float" which are not present in default database PMDB. They are calculated by everytime you press F9.

You need to use the following excel sheets to connect to your database and do the editing. The sheets are more or less self explanatory, you can use the "?" symbol on the top for help.

Note- Since you will be editing data at the database level directly, i would advise that you make a backup before using these sheets.

Please send me you email address, so that i can forward you the files.

Regards

Amit

Thanks, you can mail me at 

sayyad.faisal@gmail.com

Hi Syed,

I have emailed the files to you. You can use your primavera login id and password to connect to the database, provided the user has SDK access.

1) Dictionary6x - is used to edit Global data eg. Adding resources, calendars etc to database.

2) Activity6x - is used to edit Project data eg. Assigning resources to activities, editing units etc.

Please use the following worflow for inputting data.

Use respective "Get" button to retrieve data from database>> Edit the data (use "?" button on top for help) >> Once data has been entered >> Use "Set" button to send the data back into the database

Important Note - Once you have used the "Set" button to send data into the database and after that you decide to enter/edit more data, Use "Get" command again to refresh the new data from database otherwise there will be duplication of data. Always "Get" Data again after using the "Set" command.

Try using the sheets on a dummy project till you are not confident enough to work on a live project.

Regards

Amit

Hi,Amit,

I will be highly appreciated if send me the same SDK

my email

ayman_eleish@hotmail.com

you do not need sdk to do this 

follow your steps 1 & 2

assign the resource to one activity with the budget untis in it 

you will use this as your template in excel to import the budgeted units back into p6

now export to excel

export the activities as well as the resource and resource assignments 

when exporting modify the items in the export and make sure to export the

activity id, resource id and budgeted units

when you export the file to excel there will be 2 tabs

one tab is the activity information and the other tab is the resource informaiton 

the tab labeled as TASK is the activity information and the one labled as TASKRSRC is the resource tab 

go to the TASK tab and copy the activity id to the TASKRSRC you should be pasting into row 4 of the TASKRSRC tab

now copy the resource name down from row 2 to the other rows

now you can populate the budgted units just like you wanted to do

save the file and import just the resource assignments back into p6 you wil be prompted for what you want to import

the key here is exporting a template so that you can populate it quickly