Timesheets

P

ProjectAnalyst

We have Project Server 2007 without SP1 (I know, working on it).

Users enter time using My Tasks, but then often use the Timesheet feature to
get a report with weekly totals.

However, lately user report that their totals on the timesheet don't match
what they've recorded in My Tasks.

Can anyone give me a hint as to why this would occur? Thanks.
 
A

Astro Boy

We have Project Server 2007 without SP1 (I know, working on it).  

Users enter time using My Tasks, but then often use the Timesheet feature to
get a report with weekly totals.  

However, lately user report that their totals on the timesheet don't match
what they've recorded in My Tasks.  

Can anyone give me a hint as to why this would occur?  Thanks.

Ah, yes, the time entry/task update functionality of MOPS 2007.
Whoever designed this feature/functionality should be forced to use it
on a weekly basis! :)

It sounds like your users are just reviewing the entries which appear
on their timesheets after task updates are submitted. I have found
that to be unreliable - most entries "just auto-magically appear" on
the timesheet, but not all. A few things can be done to do this
better:

1. Use the "Import Tasks" feature on the Timesheet. This will ensure
the entries in the two places match.

2. Better yet, have resources enter time on their timesheet, then use
"Import Timesheet" to move entries to My Tasks, where they can provide
Remaining Work estimates.

3. Best yet (although still far from ideal), go get the "Timesheet
Tied Mode" solution from Microsoft CodePlex (http://www.codeplex.com/
AutoStatusService), install it, and let it automate the transfer of
actuals from Timesheet to My Tasks.

We've found the tied mode to be the way to make the best use of the
deeply flawed Timesheet/My Tasks concept - we've had no problems with
it, in the sense that it works as advertised (caution: Read the
comments on CodePlex; not everyone agrees). It still confuses our
users - they ask (all the time!) "Why do I have to go to the Timesheet
to do time entry, then go to My Tasks to update Remaining Work?", a
question for which I have no good answer.

I hope my diatribe helps a bit. Sorry for the length...
 
J

Jonathan Sofer

Astro Boy,

I read that you successfully installed and operated the "Timesheet Tied
Mode" solution from Microsoft CodePlex. I was wondering if you had any
input as to why I am seeing the following issues.

Before the installing of this solution, the timesheet actuals are editable
with no issues. However, once I install the Timesheet Tied Mode solution,
the actuals no longer take to the timesheets. On the timesheet save, it
hangs for a while and then comes back and clears the changes I tried to make
to the actuals. If I try Save and Submit I get the error: "While
communicating with the Project Server an error occurred. Check connectivity
with your administrator to determine if further action is necessary."

The event viewer shows the following error:

Standard Information:pSI Entry Point:
Project User: EPM2007DEMO\jsofer
Correlation Id: af1dd748-bf6f-47a9-8566-fb1671543296
PWA Site URL: http://epm2007demo/PWA
SSP Name: ProjectServer_SSP
PSError: GeneralActionCanceledByEventHandler (22000)
Action canceled by event handler. Reason: (null).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Maybe I didn't do something right during the install. Let me summarize what
information and credentials I used during the install:

Database Server:
[the name of the database server]
Database Name:
[the name of the reporting database]
Project Server URL:
http://[server name]/pwa
Shared Service Provider:
[I use the name of the Shared Service Provider that I find under SharePoint
3.0 Central Administration for PWA which in my case was ProjectServer_SSP]

During the installation I get prompted for a username and password. I use
the windows administrator account that I used to log onto the server. The
installation then seems to finish successfully.

Any idea what I might be doing wrong or what I might be missing?

Thanks,

Jonathan


We have Project Server 2007 without SP1 (I know, working on it).

Users enter time using My Tasks, but then often use the Timesheet feature
to
get a report with weekly totals.

However, lately user report that their totals on the timesheet don't match
what they've recorded in My Tasks.

Can anyone give me a hint as to why this would occur? Thanks.

Ah, yes, the time entry/task update functionality of MOPS 2007.
Whoever designed this feature/functionality should be forced to use it
on a weekly basis! :)

It sounds like your users are just reviewing the entries which appear
on their timesheets after task updates are submitted. I have found
that to be unreliable - most entries "just auto-magically appear" on
the timesheet, but not all. A few things can be done to do this
better:

1. Use the "Import Tasks" feature on the Timesheet. This will ensure
the entries in the two places match.

2. Better yet, have resources enter time on their timesheet, then use
"Import Timesheet" to move entries to My Tasks, where they can provide
Remaining Work estimates.

3. Best yet (although still far from ideal), go get the "Timesheet
Tied Mode" solution from Microsoft CodePlex (http://www.codeplex.com/
AutoStatusService), install it, and let it automate the transfer of
actuals from Timesheet to My Tasks.

We've found the tied mode to be the way to make the best use of the
deeply flawed Timesheet/My Tasks concept - we've had no problems with
it, in the sense that it works as advertised (caution: Read the
comments on CodePlex; not everyone agrees). It still confuses our
users - they ask (all the time!) "Why do I have to go to the Timesheet
to do time entry, then go to My Tasks to update Remaining Work?", a
question for which I have no good answer.

I hope my diatribe helps a bit. Sorry for the length...
 
A

Astro Boy

Astro Boy,

I read that you successfully installed and operated the "Timesheet Tied
Mode" solution from Microsoft CodePlex.  I was wondering if you had any
input as to why I am seeing the following issues.

Before the installing of this solution, the timesheet actuals are editable
with no issues.  However, once I install the Timesheet Tied Mode solution,
the actuals no longer take to the timesheets.  On the timesheet save, it
hangs for a while and then comes back and clears the changes I tried to make
to the actuals.  If I try Save and Submit I get the error: "While
communicating with the Project Server an error occurred. Check connectivity
with your administrator to determine if further action is necessary."

The event viewer shows the following error:

Standard Information:pSI Entry Point:
Project User: EPM2007DEMO\jsofer
Correlation Id: af1dd748-bf6f-47a9-8566-fb1671543296
PWA Site URL:http://epm2007demo/PWA
SSP Name: ProjectServer_SSP
PSError: GeneralActionCanceledByEventHandler (22000)
Action canceled by event handler. Reason: (null).
For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Maybe I didn't do something right during the install.  Let me summarize what
information and credentials I used during the install:

Database Server:
[the name of the database server]
Database Name:
[the name of the reporting database]
Project Server URL:http://[servername]/pwa
Shared Service Provider:
[I use the name of the Shared Service Provider that I find under SharePoint
3.0 Central Administration for PWA which in my case was ProjectServer_SSP]

During the installation I get prompted for a username and password.  I use
the windows administrator account that I used to log onto the server.  The
installation then seems to finish successfully.

Any idea what I might be doing wrong or what I might be missing?

Thanks,

Jonathan


We have Project Server 2007 without SP1 (I know, working on it).
Users enter time using My Tasks, but then often use the Timesheet feature
to
get a report with weekly totals.
However, lately user report that their totals on the timesheet don't match
what they've recorded in My Tasks.
Can anyone give me a hint as to why this would occur? Thanks.

Ah, yes, the time entry/task update functionality of MOPS 2007.
Whoever designed this feature/functionality should be forced to use it
on a weekly basis! :)

It sounds like your users are just reviewing the entries which appear
on their timesheets after task updates are submitted. I have found
that to be unreliable - most entries "just auto-magically appear" on
the timesheet, but not all. A few things can be done to do this
better:

1. Use the "Import Tasks" feature on the Timesheet. This will ensure
the entries in the two places match.

2. Better yet, have resources enter time on their timesheet, then use
"Import Timesheet" to move entries to My Tasks, where they can provide
Remaining Work estimates.

3. Best yet (although still far from ideal), go get the "Timesheet
Tied Mode" solution from Microsoft CodePlex (http://www.codeplex.com/
AutoStatusService), install it, and let it automate the transfer of
actuals from Timesheet to My Tasks.

We've found the tied mode to be the way to make the best use of the
deeply flawed Timesheet/My Tasks concept - we've had no problems with
it, in the sense that it works as advertised (caution: Read the
comments on CodePlex; not everyone agrees). It still confuses our
users - they ask (all the time!) "Why do I have to go to the Timesheet
to do time entry, then go to My Tasks to update Remaining Work?", a
question for which I have no good answer.

I hope my diatribe helps a bit. Sorry for the length...

Jonathan, I wish I could help you. However, I am merely a PM, one who
had some technical help installing the CodePlex solution. So I really
don't know enough to provide much direction or diagnosis.

I would suggest posting what you're seeing in the CodePlex comments
section - the development team is pretty good about providing answers
and seem to keep up with the traffic on the site. If that doesn't
work, you might comment on Christophe's blog here (http://
blogs.msdn.com/chrisfie/archive/2007/11/16/timesheet-my-tasks-solution-
starter-on-codeplex.aspx), as he also keeps up with traffic and will
answer specific questions.

Good luck!

AB
 
J

Jonathan Sofer

Thanks, I already checked the Issue Tracker and Discussions on CodePlex and
it seems my issue has been run into already but no one has offered any
solutions. I'll try you second suggestion of posting on Christophe's blog
soon if I can't get an answer somewhere else.

Thanks again,

Jonathan

Astro Boy,

I read that you successfully installed and operated the "Timesheet Tied
Mode" solution from Microsoft CodePlex. I was wondering if you had any
input as to why I am seeing the following issues.

Before the installing of this solution, the timesheet actuals are editable
with no issues. However, once I install the Timesheet Tied Mode solution,
the actuals no longer take to the timesheets. On the timesheet save, it
hangs for a while and then comes back and clears the changes I tried to
make
to the actuals. If I try Save and Submit I get the error: "While
communicating with the Project Server an error occurred. Check
connectivity
with your administrator to determine if further action is necessary."

The event viewer shows the following error:

Standard Information:pSI Entry Point:
Project User: EPM2007DEMO\jsofer
Correlation Id: af1dd748-bf6f-47a9-8566-fb1671543296
PWA Site URL:http://epm2007demo/PWA
SSP Name: ProjectServer_SSP
PSError: GeneralActionCanceledByEventHandler (22000)
Action canceled by event handler. Reason: (null).
For more information, see Help and Support Center
athttp://go.microsoft.com/fwlink/events.asp.

Maybe I didn't do something right during the install. Let me summarize
what
information and credentials I used during the install:

Database Server:
[the name of the database server]
Database Name:
[the name of the reporting database]
Project Server URL:http://[servername]/pwa
Shared Service Provider:
[I use the name of the Shared Service Provider that I find under
SharePoint
3.0 Central Administration for PWA which in my case was ProjectServer_SSP]

During the installation I get prompted for a username and password. I use
the windows administrator account that I used to log onto the server. The
installation then seems to finish successfully.

Any idea what I might be doing wrong or what I might be missing?

Thanks,

Jonathan


We have Project Server 2007 without SP1 (I know, working on it).
Users enter time using My Tasks, but then often use the Timesheet
feature
to
get a report with weekly totals.
However, lately user report that their totals on the timesheet don't
match
what they've recorded in My Tasks.
Can anyone give me a hint as to why this would occur? Thanks.

Ah, yes, the time entry/task update functionality of MOPS 2007.
Whoever designed this feature/functionality should be forced to use it
on a weekly basis! :)

It sounds like your users are just reviewing the entries which appear
on their timesheets after task updates are submitted. I have found
that to be unreliable - most entries "just auto-magically appear" on
the timesheet, but not all. A few things can be done to do this
better:

1. Use the "Import Tasks" feature on the Timesheet. This will ensure
the entries in the two places match.

2. Better yet, have resources enter time on their timesheet, then use
"Import Timesheet" to move entries to My Tasks, where they can provide
Remaining Work estimates.

3. Best yet (although still far from ideal), go get the "Timesheet
Tied Mode" solution from Microsoft CodePlex (http://www.codeplex.com/
AutoStatusService), install it, and let it automate the transfer of
actuals from Timesheet to My Tasks.

We've found the tied mode to be the way to make the best use of the
deeply flawed Timesheet/My Tasks concept - we've had no problems with
it, in the sense that it works as advertised (caution: Read the
comments on CodePlex; not everyone agrees). It still confuses our
users - they ask (all the time!) "Why do I have to go to the Timesheet
to do time entry, then go to My Tasks to update Remaining Work?", a
question for which I have no good answer.

I hope my diatribe helps a bit. Sorry for the length...

Jonathan, I wish I could help you. However, I am merely a PM, one who
had some technical help installing the CodePlex solution. So I really
don't know enough to provide much direction or diagnosis.

I would suggest posting what you're seeing in the CodePlex comments
section - the development team is pretty good about providing answers
and seem to keep up with the traffic on the site. If that doesn't
work, you might comment on Christophe's blog here (http://
blogs.msdn.com/chrisfie/archive/2007/11/16/timesheet-my-tasks-solution-
starter-on-codeplex.aspx), as he also keeps up with traffic and will
answer specific questions.

Good luck!

AB
 
J

Jonathan Sofer

FYI, Christophe suggested manually registering the TimesheetEvent.dll in the
GAC (Global Assembly Cache) after running the install file. He thinks there
is something wrong with the install file.

To register, I simply found the TimesheetEvent.dll file under "C:\Program
Files\Microsoft\Timesheet Auto Approval Service" and copied and dropped it
into the "C:\assembly" folder.

After restarting the services, it seemed to work as designed. The default
timer setting for processing these jobs is 60 seconds so you need to wait
that long to see whether the timesheet was imported and submitted
appropriately. You can also validate on the SQL table the state of the
pending jobs.

Jonathan

Astro Boy,

I read that you successfully installed and operated the "Timesheet Tied
Mode" solution from Microsoft CodePlex. I was wondering if you had any
input as to why I am seeing the following issues.

Before the installing of this solution, the timesheet actuals are editable
with no issues. However, once I install the Timesheet Tied Mode solution,
the actuals no longer take to the timesheets. On the timesheet save, it
hangs for a while and then comes back and clears the changes I tried to
make
to the actuals. If I try Save and Submit I get the error: "While
communicating with the Project Server an error occurred. Check
connectivity
with your administrator to determine if further action is necessary."

The event viewer shows the following error:

Standard Information:pSI Entry Point:
Project User: EPM2007DEMO\jsofer
Correlation Id: af1dd748-bf6f-47a9-8566-fb1671543296
PWA Site URL:http://epm2007demo/PWA
SSP Name: ProjectServer_SSP
PSError: GeneralActionCanceledByEventHandler (22000)
Action canceled by event handler. Reason: (null).
For more information, see Help and Support Center
athttp://go.microsoft.com/fwlink/events.asp.

Maybe I didn't do something right during the install. Let me summarize
what
information and credentials I used during the install:

Database Server:
[the name of the database server]
Database Name:
[the name of the reporting database]
Project Server URL:http://[servername]/pwa
Shared Service Provider:
[I use the name of the Shared Service Provider that I find under
SharePoint
3.0 Central Administration for PWA which in my case was ProjectServer_SSP]

During the installation I get prompted for a username and password. I use
the windows administrator account that I used to log onto the server. The
installation then seems to finish successfully.

Any idea what I might be doing wrong or what I might be missing?

Thanks,

Jonathan


We have Project Server 2007 without SP1 (I know, working on it).
Users enter time using My Tasks, but then often use the Timesheet
feature
to
get a report with weekly totals.
However, lately user report that their totals on the timesheet don't
match
what they've recorded in My Tasks.
Can anyone give me a hint as to why this would occur? Thanks.

Ah, yes, the time entry/task update functionality of MOPS 2007.
Whoever designed this feature/functionality should be forced to use it
on a weekly basis! :)

It sounds like your users are just reviewing the entries which appear
on their timesheets after task updates are submitted. I have found
that to be unreliable - most entries "just auto-magically appear" on
the timesheet, but not all. A few things can be done to do this
better:

1. Use the "Import Tasks" feature on the Timesheet. This will ensure
the entries in the two places match.

2. Better yet, have resources enter time on their timesheet, then use
"Import Timesheet" to move entries to My Tasks, where they can provide
Remaining Work estimates.

3. Best yet (although still far from ideal), go get the "Timesheet
Tied Mode" solution from Microsoft CodePlex (http://www.codeplex.com/
AutoStatusService), install it, and let it automate the transfer of
actuals from Timesheet to My Tasks.

We've found the tied mode to be the way to make the best use of the
deeply flawed Timesheet/My Tasks concept - we've had no problems with
it, in the sense that it works as advertised (caution: Read the
comments on CodePlex; not everyone agrees). It still confuses our
users - they ask (all the time!) "Why do I have to go to the Timesheet
to do time entry, then go to My Tasks to update Remaining Work?", a
question for which I have no good answer.

I hope my diatribe helps a bit. Sorry for the length...

Jonathan, I wish I could help you. However, I am merely a PM, one who
had some technical help installing the CodePlex solution. So I really
don't know enough to provide much direction or diagnosis.

I would suggest posting what you're seeing in the CodePlex comments
section - the development team is pretty good about providing answers
and seem to keep up with the traffic on the site. If that doesn't
work, you might comment on Christophe's blog here (http://
blogs.msdn.com/chrisfie/archive/2007/11/16/timesheet-my-tasks-solution-
starter-on-codeplex.aspx), as he also keeps up with traffic and will
answer specific questions.

Good luck!

AB
 
Top