Import Timesheet With Deleted Values

L

Laith

Hi There,

I have an issue where I try to import a timesheet to "My Tasks" after
deleting a value from a cell in the Timesheet grid, the problem is that
Project Server doesn't recognize the changes (that came from deleting old
values "i.e. not replacing it with a zero or anything), while if you
overwrite the "empty" cell with zero (0) the calculations are performed with
no issues.... anyone has the same issues.. any ideas on how to fix it??

For example:
1- Enter Actual Work for Task A on Monday 8 Hrs
2- Save Timesheet
3- Import Timesheet from My Tasks ----> up to here everything is normal
4- Go Back to the Timesheet
5- Delete the 8 Hrs
6- Save the Timesheet
7- Import the Timesheet from My Tasks ---> the calculations is wrong
"Remaining Work will be [Orginal Remaining Work] + [the deleted value of 8
Hrs]!!!!! , also the actual hours reads 8 not 0.
 
L

Laith

Thanks Gary,

I've kind of figured out this workaround (as you can see from the body of my
question) I hoped that there were some kind of a "fix".. I guess I'll wiat
and see if it is fixed in SP2 :).

Cheers,
Laith


Gary L. Chefetz said:
Liath:

Type zero in the cell rather than trying to delete the value.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Laith said:
Hi There,

I have an issue where I try to import a timesheet to "My Tasks" after
deleting a value from a cell in the Timesheet grid, the problem is that
Project Server doesn't recognize the changes (that came from deleting old
values "i.e. not replacing it with a zero or anything), while if you
overwrite the "empty" cell with zero (0) the calculations are performed
with
no issues.... anyone has the same issues.. any ideas on how to fix it??

For example:
1- Enter Actual Work for Task A on Monday 8 Hrs
2- Save Timesheet
3- Import Timesheet from My Tasks ----> up to here everything is normal
4- Go Back to the Timesheet
5- Delete the 8 Hrs
6- Save the Timesheet
7- Import the Timesheet from My Tasks ---> the calculations is wrong
"Remaining Work will be [Orginal Remaining Work] + [the deleted value of 8
Hrs]!!!!! , also the actual hours reads 8 not 0.
Click to expand...
Click to expand...
 
L

Laith

Thanks Gary...

Gary L. Chefetz said:
Yes, and I was confirming your suspicions.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Laith said:
Thanks Gary,

I've kind of figured out this workaround (as you can see from the body of
my
question) I hoped that there were some kind of a "fix".. I guess I'll wiat
and see if it is fixed in SP2 :).

Cheers,
Laith


Gary L. Chefetz said:
Liath:

Type zero in the cell rather than trying to delete the value.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Hi There,

I have an issue where I try to import a timesheet to "My Tasks" after
deleting a value from a cell in the Timesheet grid, the problem is that
Project Server doesn't recognize the changes (that came from deleting
old
values "i.e. not replacing it with a zero or anything), while if you
overwrite the "empty" cell with zero (0) the calculations are performed
with
no issues.... anyone has the same issues.. any ideas on how to fix it??

For example:
1- Enter Actual Work for Task A on Monday 8 Hrs
2- Save Timesheet
3- Import Timesheet from My Tasks ----> up to here everything is normal
4- Go Back to the Timesheet
5- Delete the 8 Hrs
6- Save the Timesheet
7- Import the Timesheet from My Tasks ---> the calculations is wrong
"Remaining Work will be [Orginal Remaining Work] + [the deleted value
of 8
Hrs]!!!!! , also the actual hours reads 8 not 0.
Click to expand...
Click to expand...
Click to expand...
 

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

Problem submitting some tasks timesheet actual work to project 0
Reporting services: info about "Import Timesheet"? 3
Task updates don't show correct % completion on Server 1
Different values 0
Project Server 2010 - Issues with Timesheet 0
Actual Work & OT Work changes in My Timesheet 0
What is up with inactive resources??????!!!!!! 2
Actuals Not Posting Correctly / Being Changed 0

Top