Writing availability using timescaledata

Question

I know how I can export resource availability from MSP into Excel using the timescaledata functionality.

Can I do the inverse, i.e. importing availability from Excel into MSP? The idea is to import on a month-by-month basis the availability of a resource (e.g. 1.1.2011 - 31.1.2011 20 days, 1.2.2011 - 28.2.2011 10 days etc.

Here's my first attempt R.TimeScaleData("01.01.2011", "31.01.2011", Type:=pjResourceTimescaledWorkAvailability, TimescaleUnit:=pjTimescaleMonths) = 20. However, I get an "invalid use of property" error message. Any ideas?

Answer 1

Hi Martin,

This is specific to Project Customization, please post it on the Forum : http://social.microsoft.com/Forums/en-US/project2010custprog/threads

 

---

Sapna S

Answer 2

Hi,

I'm afraid remaining availability is "read only" as it is calculate by Project.

For customers who asked me this, my recommendation is to giavailabilty, but to give a flat availability but to add a task with timescaled work for the resource which is the complement of the avilability.

Hope this helps,

Answer 3

Hi Jan, thanks for your reply. I found and implemented a solution in the meantime, will post it in the customization forum, as Sapna recommended.