Skip to content
ProjectControls.com
Oracle Primavera - PM6

My Access Append Quary Update to The Wrong WBS Level?

In the Open Standard
David SmithMember for 19 years 2 months
Created
3
2
0
Can anyone help me out or send me in the right direction?

I am teaching myself access and am using it to help me build a schedule in Primavera V5. Everything was working great until I got to the WBS. I built the first 3 levels by hand but I want to append the 4th with access (over 2500 work order #’s). The WBS structure is like this; Unit-Building-Equipment, I want to append Workorder # to the end (Equipment) but when I run the quary it puts the Workorder # at the Building Level.
Unit
Unit-Building
Unit-Building-Equipment
Unit-Building-WorkOrder #

I have moved the Workorder #’s in the right place by hand but I will be adding more Workorder #’s and it would be much easier if I could append them to the Equipment level when the quary is run.

If anyone knows how to use Access with ODBC connection to update Primavera, I sure could use some help. I can provide the quary details if anyone can help.

Thanks In Advance
David
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Keith Marsden ·
    #1
    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. don’t go there.
    Report
  2. 0
    David Smith ·
    #2
    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
    Report
  3. 0
    Rodel Marasigan ·
    #3
    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
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?