Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Activity ID in Project Online

6 replies [Last post]
Alex Lyaschenko
User offline. Last seen 1 week 3 days ago. Offline
Joined: 15 Aug 2011
Posts: 9
Groups: None

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 

 

 

Replies

Tom Boyle
User offline. Last seen 9 hours 50 min ago. Offline
Joined: 28 Nov 2006
Posts: 294
Groups: None

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

Zoltan Palffy
User offline. Last seen 18 hours 20 min ago. Offline
Joined: 13 Jul 2009
Posts: 2813
Groups: None

I checked and I do not see it 

Alex Lyaschenko
User offline. Last seen 1 week 3 days ago. Offline
Joined: 15 Aug 2011
Posts: 9
Groups: None

Privet message via Planning Plannet... 

Zoltan Palffy
User offline. Last seen 18 hours 20 min ago. Offline
Joined: 13 Jul 2009
Posts: 2813
Groups: None

sent to where ?

Alex Lyaschenko
User offline. Last seen 1 week 3 days ago. Offline
Joined: 15 Aug 2011
Posts: 9
Groups: None
Sent
Zoltan Palffy
User offline. Last seen 18 hours 20 min ago. Offline
Joined: 13 Jul 2009
Posts: 2813
Groups: None

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