NS LIVE

Release Notes

NorthStar Live Webservices 1.1.3.2 - 10-Sep-2010

• Added default row color setting to Meal and OT lists
• Fix issue in Sales Grid where Labor hours are zero until first guest/sale of the day
• Fix ticket timing grid to expand station name
• Fix HTML HEX color rendering in Meal/OT/Wait/Reservation lists
• Updated Visifire graph controls  

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