SDK
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
Could you please, send me a copy from that SDK.
my email : [email protected]
Could you please, send me a copy from that SDK.
my email : [email protected]
hello everybody!
I'm vey sorry I had mistakenly written my email address. My correct email is [email protected]
please accept my sincere apologies!
Thanks
Cheers!
hello everybody!
I'm vey sorry I had mistakenly written my email address. My correct email is [email protected]
please accept my sincere apologies!
Thanks
Cheers!
Hello everyone!
Can I please also get a copy on SDK files and steps in using it email address is [email protected]
Thanks!
Hello everyone!
Can I please also get a copy on SDK files and steps in using it email address is [email protected]
Thanks!
Hi Jeff,
Could you please send me a copy of your STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION at [email protected]
Thanks,
Ahmed Aziz
Hi Jeff,
Could you please send me a copy of your STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION at [email protected].
Thanks,
Kristian
Hi Guys,
Is there SDK for P6 (latest version 8.2). As far as i know this SDK can only be used up to 6.7..
Dear Jeffeory,
Can you please provide me your SDK tutorial and excel files primavera dictionary.xls and wbs.xls please.
Regards,
Aqeel
A STEP-BY-STEP GUIDE USING SOFTWARE DEVELOPMENT KIT (SDK)
FOR PRIMAVERA VERSION 6.x
SCHEDULE PREPARATION
BY: JEOFFREY B. REYES
Sr.Planning Engineer
BUILDING WORKS /
ROAD & INFRASTRUCTURE
Jubail Industrial City, K.S.A.
04 August 10
This short paper is a simple and easy guide in preparing a program or schedule using
Software Development Kit (SDK). This tutorial assumes that you know the basics of
Primavera 6.x. With this tutorial, even you’re a novice you can prepare the program very
easy. Also, another premise is you have already SDK program installed in your PC.
You can find in this exercise a very simple small project just to give you an overview on how
you can deal with the importing of all data you have in spreadsheet to Primavera 6.x. I
provided a sample of Bill of Quantity (BOQ) and Manpower Tabulation for your resources’
reference.
At the end of this exercise, you will come up with the schedule shown below. Just follow the
step-by-step instructions and you can achieve the same. Goodluck!
To start with, first you have to create a New Project and make its Project ID named “C2” and
Project Name as “SDK Guide for C2 House Model” or any Project Name you like. See
illustration below.
Before you start, take a glance first on the sample Bill of Quantity and Manpower Tabulation
that you will be using as your reference in this exercise.
Step 1. In this exercise you will create Two (2) Work Breakdown Structure (WBS) Names
only, Substructure and Superstructure. But this exercise focused only in Substructure. Open
your Excel file for WBS Macro then click WBS tab to set your WBS Name. Proceed to Step 2.
Step 2. After filling up the WBS Names, WBS Codes and Parent WBS ID’s, Go to Login tab
then Put your USER NAME and PASSWORD. Update Project List and select C2 Project ID then
Set WBS. Open your Primavera P6.x program and check your WBS. If it’s ok, then proceed to
the next step.
Note:
If your Primavera 6.x software is open at the same time with your Excel File Macro, you must
close the Primavera 6.x software first and re-open it to load up what you have done in your
Excel File. Do this to the rest of this exercise everytime you will Set your tasks.
Step 3. Setting up your Activities. Open your Activity 6.x Excel File. Put your USER NAME and
PASSWORD then Update Project List. Select C2 Project. Click Activity Details tab to setup
your Activities. Proceed to the next Step.
Step 4. Setting up your activity details to SUBSTRUCTURE WBS. In doing this, see WBS
column, C2.SUB means C2 is the Parent WBS ID and SUB means your WBS Code and put a
Dot separator. For this sample project, Pick STANDARD for your Calendar and make your
activities all Task Dependent. Activity ID is self explanatory in its nature and the Duration is
just an assumption. After finishing the tasks, Go to Login Tab then Set Activity Details. Again,
Open your Primavera 6.x and check if all activities were there. If OK, then proceed to next
step.
Step 5. Set your Relationships. Click Activity Relationship Tab then type all you see in the
screenshots provided below. For Relationship Type, I used Finish-To-Start only. You can try
also other Relationships and put some lags if you like. After finishing the tasks, Go to Login
Tab then Set Activity Relationship. Again, Open your Primavera 6.x and check if all activities
were there. If OK, then proceed to next step.
Step 6. Setting up your Material Resources. Before you proceed, create a Resource ID C2
first and Resource Name C2 RESOURCES FOR SDK GUIDE (or any Resource Name you like) .
Then, Open your Dictionary 6.x Excel File for Resources Details. Put your USER NAME and
PASSWORD then Update Project List. Select C2 Project. Click Resources tab to setup all your
Resources. Proceed to Step 2.
Step 7. Set your Material Resource Dictionary. Click Resources Tab then copy the listed
sample below. In this exercise, I separated the setting up for Material and Manpower to give
way first to Material Resources Rates and Assignments. After finishing the tasks, Go to Login
Tab then Set Resources. Once again, Open your Primavera 6.x and check if all Resources
were there. You will notice that your reources category is in Labor. Change it to material by
clicking the labor then CTLRL+E to copy Fill Down. If OK, then proceed to next step.
Step 8 . Set your Material Resource Rates. Click on Resource Rates Tab, copy the Resource
ID’s and Description in the sample BOQ provided on the outset of this exercise. Effective
Date and Max Units/Time are just an assumption. You can change as you wish. But to have
the same outcome for this exercise just follow the same. After finishing the tasks, Go to
Login Tab then Set Resource Rates. Once again, Open your Primavera 6.x and check if all
Resource Rates were there. If OK, then proceed to next step.
Step 9. In setting up your Material Resource Assignments, Open your Activity 6.x Excel File.
Put your USER NAME and PASSWORD then Update Project List. Select C2 Project. Click
Resource Assignment Tab to setup your Activities. Proceed to the next Step.
Note:
Resource Assignments for Material and Manpower is located in this Excel File.
Step 10. Set your Material Resource Assignment by clicking the Resource Assignment Tab.
Budgeted Units and Remaining Budgeted Units is just the same for a baseline schedule. See
Budgeted Units on our sample BOQ aforementioned in the beginning of this paper. After
finishing the tasks, Go to Login Tab then Set Resource Assignments. Once again, Open your
Primavera 6.x and check if all Resources were correctly assigned. If OK, then proceed to next
step.
Step 11. Setting up your Manpower Resources. Open your Dictionary 6.x Excel File for
Resources Details. Put your USER NAME and PASSWORD then Update Project List. Select C2
Project. Click Resources tab to setup all your Resources. Same thru with Material, the
procedure is just the same. Proceed to Step 2.
Step 12. Set your Manpower Resource Dictionary. Click Resources Tab then copy the listed
sample below. After finishing the tasks, Go to Login Tab then Set Resources. Once again,
Open your Primavera 6.x and check if all Resources were there. You will notice that your
reources category is in Labor already. If OK, then proceed to next step.
Step 13. Set your Manpower Resource Rates. Click on Resource Rates Tab, copy the
Resource ID’s and Description in the sample BOQ provided on the outset of this exercise.
Effective Date and Max Units/Time are just an assumption. You can change as you wish. But
to have the same outcome for this exercise just follow the same. After finishing the tasks,
Go to Login Tab then Set Resource Rates. Once again, Open your Primavera 6.x and check if
all Resource Rates were there. If OK, then proceed to next step.
Step 14. In setting up your Manpower Resource Assignments, Open your Activity 6.x Excel
File. Put your USER NAME and PASSWORD then Update Project List. Select C2 Project. Click
Resource Assignment Tab to setup your Activities. Proceed to the next Step.
Step 15. Set your Manpower Resource Assignment by clicking the Resource Assignment Tab.
Budgeted Units and Remaining Budgeted Units is just the same for a baseline schedule. See
Budgeted Units on our sample BOQ aforementioned in the beginning of this paper. After
finishing the tasks, Go to Login Tab then Set Resource Assignments. Once again, Open your
Primavera 6.x and check if all Resources were correctly assigned. If OK, then proceed to next
step.
That’s it for Schedule Preparation! Now you have the idea how this macro works for
Primavera 6.x then you can try this as well for updating purposes. I hope that you enjoyed it.
CHEERS!!!
Already forwarded , step by step for your quick reference.
Ameen N. Pasha
First of all logon and open a new project in Primavera, then start using SDK Excel in sequential manner, WBS is part of SDK Excel file.
Please feel for any queries.
Ameen N. Pasha
Jeff,
Im new in this site and at the same time a new planner, i read your comments/post with regards to the application of SDK in Primavera. Can you send me your STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION.
my email add: [email protected]
thank you so much in advance..
Larry
Hi to all,
Im new in this site and Im very enterstied in linking primavera to excel and other format presentation, can any one help me to have a primavera dictionary.xls and wbs.xls pls? Kindly pls email me at [email protected] you so much.
JUn
Hi riad,
sent already.
cheers
Hi jeff,
can u send me STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION
my email id: [email protected]
best regards
here is a link to the latest sdk
http://www.eh.com.au/software.html
Hello Jeff,
Can you please forward the step by step guide for SDK to the following Mail, Thanks so much!
[email protected]
guo
[email protected]
Luca
Jeff,
Can you please forward the step by step guide for SDK to the following Mail id.
[email protected]
Thanks in advance Jeff.
Sundar.
Could you pls forward the following excel files and STEP BY STEP GUIDE USING SDK IN SCHEDULE PREPARATION to my email: [email protected]
1. WBS.xls
2. Activity.xls
3. Dictionary.xls
Thank you in advance
Ahmet
Could you pls forward the following excel files and STEP BY STEP GUIDE USING SDK IN SCHEDULE PREPARATION to my email: [email protected]
1. WBS.xls
2. Activity.xls
3. Dictionary.xls
Thank you in advance
Ahmet
Hi jeff,
can u send me STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION
My email id is [email protected]
i only have activity and dictionary, can any body send me the wbs.xls, please send it to
[email protected]
thanks
Hi Rola & Mike,
I don't know why my thread was locked up though many of our PP members can benefit from some suggestions and queries on the Steps using SDK.
Sorry Rola from using your thread. And sorry guys also because I cannot attend to your queries. Currently, I am still attending to very important matters pertaining to my departure in my next destination. So many problems i have encountered till now and i am using only my mobile in responding to all of you.
What is the ground to lock up anyone's thread?
cheers,
JEFF
Dear,
Did you get the SDK file or not if not yet please put the P6 CD1 in the CD room than you can fine the SDK file thier.
let check if not let me know pls.
cheers,
maqeel
+966599981584
Dear Jeff,
Kindly please send me the SDK file in excel format ?. [email protected]
Thanks in advance,
Weerasak
Hi all,
please how can I get the SDK file, any help!
Faris Aldwiekat
([email protected])
+962777465864
regards
Hi everybody
can anyone send me the SDK file in excel format..i cannot find it in my CD.
my email is [email protected]
Thanks Jeff.
Hi Rola,
Congratulations! You did it. Thank you for giving your spare time with my paper to explore with it and applied it in your scheduling.
Cheers,
JEFF
Sometimes, unknowingly, you were setting the activity twice. Try This....Close your P6 first before importing so that the loading will be more faster. Then Open your P6 to check if your imports loaded up. Then for the next procedure of importing, Close again your P6 then import again another set of activities. For relationship, maybe because you have already a duplicate of activities then correspondingly your relationships were affected.
Delete those activities you have imported then try to import again. Let me know.
Hi Rola,
Delete those activities then import it again. Probably you have two entries or you Set Activity twice.
Cheers,
JEFF
hi every body
when i use the sdk for importing activities it duplicates these activites, one with the id that i inserted anothr with defualt activity stating A10203
when i import relationship it gives error that there is dublicate relationship although there is no duplicates?
what is wrong can any body help?
Hi Duy,
sent already.
Dear Jeff,
Could you pls forward the following excel files to my email: [email protected]
1. WBS
2. Activity
3. Dictionary
Thank you in advance
Br, Duy
your more than welcome....Rola.
Cheers,
JEFF
Thanks jegg
Wonderfull
Thanks
Hi Rola,
I sent you already a copy of STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION. Kindly Check your email.
Cheers,
JEFF
Hi Rola,
Your welcome.
Cheers,
JEFF
Dear Jeff,
thank you so mcuh appreciate your help.
Hi Rola,
WBS File already sent.
Cheers,
JEFF
hi Rola,
were using the same version. ill send you later the file for WBS.
Cheers,
JEFF
hi again
im using P6 v7
hi
thanks, i only have activity and dictionary, can any body send me the wbs.xlsplease send it to
[email protected]
thanks
Hi Rola,
Post your email and I will send you my short paper regarding SDK. Maybe it would help you.
Cheers,
JEFF
Hi Rola,
There are 3 excel files needed to do import/export in SDK.
1. WBS
2. Activity
3. Dictionary
Cheers,
JEFF
Hi Rola,
Do you have a WBS.xls file? This is the macro used to import WBS Codes and WBS Names i have mentioned in my paper.
Cheers,
JEFF