Windows LiveWindows Live™
 
 
Paul's profilePaul Galvin's SharePoint...BlogListsSkyDrive Tools Help

Blog
    October 11

    Employee Training Schedule and Materials Template -- Decrement bug in the template

    The client noticed a bug today with the above mentioned template. 

    Course managers create courses.  When creating a course, the manager specifies maximum number of available seats.

    The template provides for self-service enrollment.  I enroll and a workflow attached to the registration list decrements the "available seats" associated with that course.

    Individuals may also unregister from a course.  The bug lies here.  Unregistering from a course does not increment the available seats counter.  As a result, available seats is not accurate.  This bug is compounded by the fact that when available seats decrements to zero, no more self-service registration is allowed.

    Fortunately, Microsoft provides the workflow for this process.  Even better, it's a straight-forward workflow created via SharePoint Designer.

    Follow these high level steps to fix it:

    1. Fire up SDP.
    2. Access the site based off the training template.
    3. Access "Attendee unregistration" workflow.
    4. Insert these steps (I made them the first two steps):
      1. Calculate Courses:Filled Seats minus 1 (Output to Variable:calc)
      2. (then) Update item in Courses

    Click Finish and you're done.

    Screen shots:


    SharePoint Designer:

    image

    Finished workflow:

    image

    Calculate drill-down:

    image

    Update item in Courses:

    image

    4:31 PM | Blog it | SharePoint

    Comments (2)

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up
    arun singhwrote:
    Hi Paul,
    Template: Employee Training Scheduling & Materials
    I want to add one more custom column in the course(training) list i.e Businees unit dropdown column,but i tried lot to insert column but in vain. Again i  tried through XSLT in SPD but no use, i am getting error.  It's very mandatory for me to use one more column in that list(NewForm.aspx of Cource list).
    Please tell me, how can i overcome this problem.
     
    Thanks in advance
    arun
    Dec. 6
    Picture of Anonymous
    Mark wrote:
    Paul,
     
    We're having a discussion about this template over on the SharePoint University forums. Could you check in to the forum and help clarify some things for us.
     
     
     
    Oct. 17

    Trackbacks

    The trackback URL for this entry is:
    http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!226.trak
    Weblogs that reference this entry
    • None