Updating WBS using append query via ODBC is easy as long as you understand the structure of PMDB database and how it works. It’s sits on PROJWBS table and every WBS has a unique WBS_id. You must aware what the proj_id, obs_id and important fields are the seq_num which is the sorting and appearance of your WBS node tree, proj_node_flag that identify whether it is a project or WBS, wbs_short_name is the numbering, wbs_name is the description and the wbs_parent_id where identify which project node it should be under. The rest are self explanatory.
Should you require any assistance please send me a PP with email address so I can guide you on the right path.
create your wbs in primavera and then use an update query to make them read as you wish. appending is very dodgy if done via the back end as it effectively bypasses primaveras referential integrity rules. dont go there.
Member for
19 yearsRE: My Access Append Quary Update to The Wrong WBS Level?
David,
Updating WBS using append query via ODBC is easy as long as you understand the structure of PMDB database and how it works. It’s sits on PROJWBS table and every WBS has a unique WBS_id. You must aware what the proj_id, obs_id and important fields are the seq_num which is the sorting and appearance of your WBS node tree, proj_node_flag that identify whether it is a project or WBS, wbs_short_name is the numbering, wbs_name is the description and the wbs_parent_id where identify which project node it should be under. The rest are self explanatory.
Should you require any assistance please send me a PP with email address so I can guide you on the right path.
Happy to help,
Rodel
Member for
18 years 3 monthsRE: My Access Append Quary Update to The Wrong WBS Level?
Thanks Kieth,
I did end up building the WBS by hand. Will
try to use your recommendation and use an update
query. I am going to learn this stuff yet.
Thanks Again
David
Member for
21 years 7 monthsRE: My Access Append Quary Update to The Wrong WBS Level?
create your wbs in primavera and then use an update query to make them read as you wish. appending is very dodgy if done via the back end as it effectively bypasses primaveras referential integrity rules. dont go there.