Hi guys. I have a site coming up that plans to have a 6 week menu rotation. Meaning that each day in each week has a different menu, monday-friday, and that it resets after six weeks.
So...
Week 1 - Monday: Menu A
Week 1 - Tuesday : Menu B
Week 1 - Wednesday : Menu C
....
Week 2 - Monday : Menu F
Week 2 - Tuesday : Menu G
Week 2 - Wednesday : Menu H
...
Week 6 - Monday : Menu X
Week 6 - Tuesday : Menu Y
Week 6 - Wednesday : Menu Z
... resets to week 1 ....
Now that I'm fairly sure I've explained adequately, I'll tell you how I'm currently setting it up..
Basically, you define a set of SLU's that apply for each menu. So Menu A might be A - Starters, A - Entrees, A - Drinks, while Menu B would be B - Starts, B - Entrees, B - Bites, B - Cocktails... etc etc.. so they create the menu item, and assign whichever SLU's it needs to be in.
Now that they have the SLU's created and assigned to each menu, and the menus have been assigned a specific week and day, a window task scheduler has been setup which runs every night. Basically, it clears out the Food SLU Group, and then assigns the correct SLU back into the SLU Group. The setup is very, very tedious, although it seems to be quite stable now that it is set up; so long as they don't change their weekly rotation, we won't ever have to change these settings again... they can just change which SLU's the menu items are in.
My question is this.. this seems so inefficient.. anyone have a better way of doing it? One that doesn't require a program that is running with dba authority? Especially the whole dba authority part.. that just seems like we are asking for trouble.
So...
Week 1 - Monday: Menu A
Week 1 - Tuesday : Menu B
Week 1 - Wednesday : Menu C
....
Week 2 - Monday : Menu F
Week 2 - Tuesday : Menu G
Week 2 - Wednesday : Menu H
...
Week 6 - Monday : Menu X
Week 6 - Tuesday : Menu Y
Week 6 - Wednesday : Menu Z
... resets to week 1 ....
Now that I'm fairly sure I've explained adequately, I'll tell you how I'm currently setting it up..
Basically, you define a set of SLU's that apply for each menu. So Menu A might be A - Starters, A - Entrees, A - Drinks, while Menu B would be B - Starts, B - Entrees, B - Bites, B - Cocktails... etc etc.. so they create the menu item, and assign whichever SLU's it needs to be in.
Now that they have the SLU's created and assigned to each menu, and the menus have been assigned a specific week and day, a window task scheduler has been setup which runs every night. Basically, it clears out the Food SLU Group, and then assigns the correct SLU back into the SLU Group. The setup is very, very tedious, although it seems to be quite stable now that it is set up; so long as they don't change their weekly rotation, we won't ever have to change these settings again... they can just change which SLU's the menu items are in.
My question is this.. this seems so inefficient.. anyone have a better way of doing it? One that doesn't require a program that is running with dba authority? Especially the whole dba authority part.. that just seems like we are asking for trouble.