locked
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

Answers

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

    • Proposed as answer by Ismet Kocaman Tuesday, June 28, 2011 8:33 AM
    • Marked as answer by MikeGlen Wednesday, June 29, 2011 9:06 PM
    Friday, June 24, 2011 1:00 PM

All replies

  • 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
    Friday, June 24, 2011 12:45 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,

    • Proposed as answer by Ismet Kocaman Tuesday, June 28, 2011 8:33 AM
    • Marked as answer by MikeGlen Wednesday, June 29, 2011 9:06 PM
    Friday, June 24, 2011 1:00 PM
  • 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.
    • Marked as answer by MikeGlen Wednesday, June 29, 2011 9:06 PM
    • Unmarked as answer by MikeGlen Wednesday, June 29, 2011 9:06 PM
    Wednesday, June 29, 2011 7:04 PM