Page Comparison

Release Notes

• Change labor/sales graph time to 12-hour format
• Change formatting in Ticket Timing to allow up to 13 time rows

• Hotfix for NULL job codes
• Increase default sql timeout to 3 minutes

• Initial Release  

•  Updated purge functionality to configurable purge time.

• Fix: Purge not functioning correctly  

•  BUG FIX: OTIS not resetting at specified time.

• Added: Increased border size per Brian

• Added: Client-side logging. Client logs to both client machine and server. Client logs visible through the debug window.  

NorthStar Database Updater 1.0.1.20 - 28-May-2010

Added:

• tblSystemSettings: FilterCompActivityItemCodes

Modified:

•  tblSystemSettings.Value column = nvarchar(max) from nvarchar(255)

• spGetCompActivity: Added item level discount tracking

• spGetWaitList: Changed code to remove seated guests. Added code to handle call aheads  

• Updated Wait List/Reservation functionality to place Call Aheads into Wait List  

• Fixed issue where zero labor hours values from HotSchedules overwrites existing data  

•  NorthStar Data Collector 2.0.2.30
• Deploys NorthStarLive database and Data Collecor service with Uninstall in Control Panel.  

•  Installs Data Collector v2.0.2.29

• Database version 2.0.1.7  

•  Fixed issue where Reservations are not populated to the NorthStarLive! table

• Fixed issue where reservations and wait list records are not cleared from the list properly  

• Added Wait list and Reservation collection from QSR  

•  Added support for tell us about us

• Support for error reporting from client

• Formatting issues in Sales Grid

• Client fixes for stability

• Fixes to minimize flashing in contest module  

•  Added tables/procedures for Tell Us About Us

• Added code to fix tblCheckHeaders.Dicount amount abberation

• Added default value inserts for CheckSalesExcludeNonTaxableItemNumbers, FilterCompActivityDiscountCodes, FilterTakeOutOrdersByCostCenter  

•  Updated Silverlight Client with the following modules:

• Take out # of orders + cost center configuration

• Sales Grid

• Comp Activity

• Fixed issue with sales passing now line

• Added code to handle white paging

• Added fix for clock in/out at same minute  

•  Added tblSpeedOfService.ID

• Added tblSpeedOfService.StationTypeName

• Added spGetCompActivity

• Added spGetTotalSalesGuestsValues

• Added spGetOpenTicketsByCostCenter

• Added spGetSalesGrid

• Remove duplicate punches and punchin/punchout at same time

• Modified Order of script to ensure proper creation against blank database  

• Added discount code, discount name, and discount amount support to tblCheckHeaders. Added new SQL Task Type - QSR Speed Of Service. This version requires the Database updater be run.  

• Added WCF services to support NorthStarLive! Scoreboard v2.0  

•  Added aggregate table for Daily Guest Counts. Aggregation now DataCollector initiated.

• Added aggregate table for Contest results. Aggregation now Data Collector initiated.

• Added index to tblForecastDailySummary

• Added ability to exclude user-specified item values from sales calculations

• Created specific stored procedure for Wait Parties/Open Tables  

• Remove IIS Caching code  

• Bug fix for data purge  

• Fixed bug where corporate HotSchedules data was being continuously downloaded.  

• Updated break list and daily hours code to recalculate more often  

• Moved forecasting code to spProcessCollectedData (called by data collector)  

• Webservice requests are answer from IIS cache when appropriate to lessen number of SQL calls.  

• Added call to spProcessCollectedData  

•  SQL Optimizations

• Added answer tables for OTIS webservices

• Added processing stored procedures to load answer tables  

•  Updated method by which day part sales are returned

• Changed Checks without Bevs to list server name plus comma-delimited table/check#

• Updated webservice to return expected times for kitchen timing  

•  Fix performance issues

• Fix sales amounts going to zero

• Fix shift sales after end of day

• Contest graph abberation

• Changed Checks without Bevs to list server name plus comma-delimited table/check#

• Updated client code to help prevent flashing

• Added Expected times to Kitchen Timing module  

•  SQL Optimizations

• Added code to return table # in checks without bevs

• Added spComputeDailyTicketTimes

• Added code for Kitchen Expected Times  

• Added call to spComputeDailyTicketTimes  

• Fixed HotSchedules parsing bug  

• Added the ability to execute SQL Stored Procedures on the NS Live Database. spComputeDailyChecks  

• SQL Optimizations  

• Fixed issue where data collector stops when SQL Server is stopped.  

•   All modules display "Loading..." and/or are gray until data is loaded.

• Replaced POS Activity module with Checks Without Beverages module

• Fixed issue - Guest Count forecast not loading

• Requires NorthStarLive! Webservices 1.0.2.10  

• Updated webservices to support Checks Without Beverages

• Requires Database Updater 1.0.1.5  

• Added code to support Checks Without Beverages  

• Updates to support WebService 1.0.2.9  

•  Updates database support for Data Collector 2.0.2.17

• Added time punch adjustment support

• Added alpha sort to Station time

• Added day part support to forecasts

• Added support for inclusive tax  

• Added code to report inclusive tax (requires Data Collector 2.0.2.17)

• Added the ability to return sales/guest counts by day part

• Added ability to return inclusive tax

• Kitchen Station List sorted Alphabetically  

•  Added the ability to import time clock adjustments.

• Added the ability to import inclusive tax tags.

• Added the ability to import day part projections from Hot Schedules Web Service.  

• Added training column to tblCheckHeaders  

• Added ability to import projections from SQL database.  

• Added SQL Import Task for Hot Schedules Enterprise Feed.  

• Fixed issue - Files from Archive and Data from Database not being purged nightly.  

•  Added better error trap for issue with invalid time format from POSi xml file.

• Added error logging when File Task Path does not exist.