TimeSheet Lines TASK_UID != Assignment TASK_UID

E

Esfer

Hi!!

I posted here some days ago about this problem but I haven't found a
solution yet...

So I've been looking for any clues and I realized that sometimes, TASK_UID
field in TimeSheet Lines table is different from TASK_UID field in
Assignments table (for the same task and assignment of course).

When I search that task in Task table I can find it with the TASK_UID from
Assignments table but the TimeSheet Lines table TASK_UID doesn't exist...

Does anybody knows if this is normal?
 
R

Rod Gill

When a user creates a timesheet, project copies all Task data into the
timesheet tables. The idea is that if a PM deletes a task, the timesheet
data stays pointing to a valid task in the timesheets table. The
TimesheetLine table holds TaskNameUID which is a GUID that points to the
Timesheet Task table. The Assignment UID field points to the Assignment
table. So, if a task gets a new GUID or is deleted etc. the Guids will be
different.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
E

Esfer

Thanks for your reply.

I can't find TaskNameUID column at MSP_TIMESHEET_LINES :cool:.

Where should it be??

Thanks!!
 
R

Rod Gill

I just got that name from the schema in the Project SDK, so it should be
there! This is Project 2007? If not I'm not sure what the problem is because
I haven't played with timesheet data in 2003 version.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
E

Esfer

Uhmmmm I'm using Project 2007 on fact :cool:.

I've tried to look inside data at DataSet when I ask for it with PSI but I
can't find it anyway :-(.

Where is it suposed to be?
 
R

Rod Gill

Hi,

I think you need to read the schema for the reporting db that comes with the
Project SDK. You should only be reading timesheet data from the reporting db
as the schema for the other dbs may change with any hotfix or SP.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assignment assignment to resource 0
Reocrds in timesheet lines table without records in tasks table 7
web assignments without task uid? 3
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Recovering corrupted mpp while preserving TASK_UIDs 5
Inserting a Linked Project via direct database manipulation. 0
Resource Code while looking at Assignment Data? 0
update submitted for old task 0

Top