Caution: This should only be attempted by the Idealpos support team
-written by Gerry
We had a site where when they created a new Table Map 2, the 'Table Status' key (seven coloured boxes, and seven definitions) was missing. Here's what the Table Status key should look like:
If there is still a key in one of the other tables, you can copy it into this table using a POSCommand like this:
*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) select 2 ,[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline] from TableMapSetups where Caption IN ('Bill Printed','Reserved','To Clean','Ordered','Seated','Served','Ready');*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) select 2 ,[Type],[Index]+21,[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline] from TableMapSetups where code=1 and y2=250
The above will work, with some modification, where there is still another Table Map with the key. However, the Table Map that still included the key was deleted. So the key had to be exported from a demo database and then imported into the live database. Here's the POSCommand that was written that uses the exported data:
*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,3,'','',13080,250,240,250,12566463,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,4,'','',13080,250,600,250,4408267,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,5,'','',13080,250,960,250,13673284,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,6,'','',13080,250,1320,250,4895815,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,7,'','',13080,250,1680,250,14379700,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,8,'','',13080,250,2040,250,2934739,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,15,'','',13080,250,2400,250,2849390,'MS Sans Serif',8,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,16,'','Ready',13560,705,240,345,0,'Calibri',14,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,9,'','Seated',13560,780,600,345,0,'Calibri',14,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,10,'','Ordered',13560,975,960,345,0,'Calibri',14,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,11,'','Served',13560,750,1320,270,0,'Arial',12,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,12,'','Bill Printed',13560,1125,1680,270,0,'Arial',12,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,13,'','To Clean',13560,945,2040,270,0,'Arial',12,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0);*SQL*INSERT INTO [dbo].[TableMapSetups] ([Code],[Type],[Index],[Name],[Caption],[X1],[X2],[Y1],[Y2],[Colour],[FontName],[FontSize],[FontBold],[FontItalic],[FontUnderline],[Seats],[Status],[Amount],[GuestsSaved],[Shape],[StartTime],[FoodTime],[DefaultCovers],[UserDefinedText],[SentOnline]) VALUES (2,1,14,'','Reserved',13560,1005,2400,270,0,'Arial',12,0,0,0,0,0,0.00,0,0,NULL,NULL,0,NULL,0)