Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Activity ID in Project Online

In the Open Standard
Alex LyaschenkoMember for 15 years 2 months
Created
6
4
0

Hi,

We are developing a solution when enterprise schedules could be reported via backend from Primavera and Project Online (Enterprise Master Schedule). Our solution already works with P6 schedules and we need to add all schedules from Project Online. We can't find a solution for one critical issue's and I need support from this forum.

Milestone's slippage (from last month) calculated based on Schedule ID and Milestone ID by comparing two datasets (from  previous and current month).

Schedule ID and Milestone ID must be: 

a) user defined; 

b) unique per schedule;

c) not blank;

We aleady have a set of Governence Control Reports  (via Tableau) and able to see what has been changed since last month (new/removed schedules, new/deleted milestones, ID changed (calculated absed on UID), milestones renamed, baseline removed, etc)

Primavera has Activity ID and Project IDs which met these criteria but I can't find out what I can use on PoL.

Activity ID - not stable - changesd if new activity added;

Activity UID - not user defined; (if a user delete milestone by mistake and created it again it would be new UID and slippage could not be calculated;)

WBS could be user defined, unique and not blank but only if WBS Code definition setup.

Is it possible to configure permissions to have WBS always defined (Now users and change WBS Prefix and mask)? 

or is it any other options avaliable?

For user developers can't find Activity UID and WBS code at backend but I am assuming it just thier knowledge of Project Online backend. Please support with this as well ifyou know any secrets :)

Thanks in advance 

 

 

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    Activity ID NEVER

    Activity ID NEVER changes 

    Key

    Name

    Type

    Description

    Default

    PK

    acct_id

       integer

            FK to ACCOUNT table - identifies cost account for activity

     

    give me your email address I have the schema

    Report
  2. 0
    Alex Lyaschenko ·
    #2

    Sent

    Sent
    Report
  3. 0
    Zoltan Palffy ·
    #3

    sent to where ?

    sent to where ?

    Report
  4. 0
    Alex Lyaschenko ·
    #4

    Privet message via Planning

    Privet message via Planning Plannet... 

    Report
  5. 0
    Zoltan Palffy ·
    #5

    I checked and I do not see

    I checked and I do not see it 

    Report
  6. 0
    Tom Boyle ·
    #6

    Alex, I'm not on Project

    Alex,

     

    I'm not on Project Online, but based on MSP desktop I would be skeptical of the stability of WBS.  You can force it to be unique and non-blank, but it's hard to inhibit the user from completely re-organizing and re-numbering (in MSP).  I've also been frustrated using activity UID as a comparison key in the past - contractor would routinely delete and replace hundreds of records tasks at a time just as part of routine progress updates.  Still, on the desktop version I think that's what we are stuck with.  Microsoft's own Compare Projects tool, which is pretty slick, relies on it.

     

    There don't seem to be many knowledgeable POL users here on PP.  Have you inquired on Technet?  https://social.technet.microsoft.com/Forums/projectserver/en-US/home?forum=projectonline

    Good luck, tom

    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?