Writing availability using timescaledata RRS feed

  • 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?

    Friday, June 24, 2011 12:37 PM


  • 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,

    Friday, June 24, 2011 1:00 PM

All replies