Error when trying to import products from one database to another [SQL]

Hi,

Trying to import new products from one branch to the second so they both have the same items. Both are running SQL 2014.
I followed @Jesse guide:

However when running the task it returns this error.


[General Info]

Application: SambaPOS
Version: 5.1.58
Region: en
DB: SQ
Machine: ADMIN-PC
User: Admin
Date: 06/06/2016
Time: 01:04

User Explanation:

Admin said “”

[Exception Info 1]

Top-level Exception
Type: System.Data.SqlClient.SqlException
Message: Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table ‘ScreenMenuItems’ when IDENTITY_INSERT is set to OFF.
Source: .Net SqlClient Data Provider
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext1 c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 executing, Action3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass59.b__58()
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass59.<ExecuteStoreCommand>b__57() at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func1 operation)
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object parameters)
at Samba.Infrastructure.Data.SqlData.EFWorkspace.ExecSql(String sql)
at Samba.Persistance.Data.Executor.ExecSqlCommand(String commandText, Object parameters)
at Samba.Modules.DatabaseModule.Tools.DatabaseTaskManager.ExecuteTask(String taskType, String filePath, String arguments)
at Samba.Modules.DatabaseModule.Tools.DatabaseTaskManager.ExecuteTask(DatabaseTask task, Boolean skipConfirmation)
at Samba.Modules.DatabaseModule.Tools.DatabaseToolsViewModel.OnExecuteDatabaseTask(String obj)
at Microsoft.Practices.Prism.Commands.DelegateCommand`1.<>c__DisplayClass6.<.ctor>b__2(Object o)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parameter)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.System.Windows.Input.ICommand.Execute(Object parameter)
at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
at System.Windows.Controls.Primitives.ButtonBase.OnClick()
at System.Windows.Controls.Button.OnClick()
at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
at System.Windows.Threading.Dispatcher.Run()
at System.Windows.Application.RunDispatcher(Object ignore)
at System.Windows.Application.RunInternal(Window window)
at System.Windows.Application.Run(Window window)
at Samba.Presentation.App.Main()


[Assembly Info]

mscorlib, Version=4.0.0.0
DevExpress.Xpf.LayoutControl.v14.1, Version=14.1.11.0
System.Xml, Version=4.0.0.0
DevExpress.Xpf.Grid.v14.1, Version=14.1.11.0
System, Version=4.0.0.0
DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.11.0
WindowsBase, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Samba.Domain, Version=1.0.0.0
System.Core, Version=4.0.0.0
PresentationFramework, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
System.Runtime.Serialization, Version=4.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
PresentationCore, Version=4.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.11.0
Samba.Services, Version=1.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
System.Windows.Forms, Version=4.0.0.0
System.Drawing, Version=4.0.0.0
Stateless, Version=1.0.0.0
Samba.Persistance, Version=1.0.0.0
PropertyTools, Version=2012.4.14.1
Samba.Localization, Version=1.0.0.0
ReachFramework, Version=4.0.0.0
Samba.Infrastructure.Data, Version=1.0.0.0
EntityFramework, Version=6.0.0.0
FluentValidation, Version=3.4.0.0
Omu.ValueInjecter, Version=2.3.0.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Microsoft.CSharp, Version=4.0.0.0


[System Info]

Operating System
-Microsoft Windows 7 Ultimate
–CodeSet = 1252
–CSDVersion = Service Pack 1
–CurrentTimeZone = 60
–FreePhysicalMemory = 186940
–OSArchitecture = 32-bit
–OSLanguage = 1033
–ServicePackMajorVersion = 1
–ServicePackMinorVersion = 0
–Version = 6.1.7601

Machine
-ADMIN-PC
–Manufacturer = To Be Filled By O.E.M.
–Model = To Be Filled By O.E.M.
–TotalPhysicalMemory = 1062395904
–UserName = Admin-PC\Admin


I checked the script and it seems to be turned on at first then off.

`DELETE FROM [dbo].[ScreenMenus]
GO
SET IDENTITY_INSERT [dbo].[ScreenMenus] ON 

INSERT [dbo].[ScreenMenus] ([Id], [CategoryColumnCount], [CategoryColumnWidthRate], [SelectedCategoryFormat], [SelectedSubCategoryFormat], [Name]) VALUES (1, 2, 45, NULL, NULL, N'Menu')
SET IDENTITY_INSERT [dbo].[ScreenMenus] OFF
SET IDENTITY_INSERT [dbo].[ScreenMenuCategories] ON 

INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (8, N'Appetizers', NULL, 0, 10, 1, 0, 3, 100, N'#FFFF6347', 24, 1, 1, 0, 80, N'#FFFF6347', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\app.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (9, N'Salad', NULL, 0, 20, 1, 0, 3, 100, N'#FF6E8E2C', 24, 1, 1, 0, 80, N'#FF6E8E2C', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\salad.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (10, N'Mains', NULL, 0, 30, 1, 0, 3, 100, N'#FFFFFF00', 24, 1, 1, 0, 80, N'#FFFFFF00', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\mains.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (11, N'Platters', NULL, 0, 50, 1, 0, 3, 100, N'#FF9932CC', 24, 1, 1, 0, 80, N'#FF9932CC', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\platters.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (12, N'Condiments', NULL, 0, 100, 1, 0, 3, 100, N'#FFAA3A37', 24, 1, 1, 0, 80, N'#FFAA3A37', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\cond.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (13, N'Drinks', NULL, 0, 110, 1, 0, 3, 100, N'#FF4BACC6', 24, 1, 1, 0, 80, N'#FF4BACC6', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\drinks.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (14, N'Milkshakes', NULL, 0, 140, 1, 0, 3, 100, N'#FF90EE90', 24, 1, 1, 0, 80, N'#FF90EE90', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\milkf.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (15, N'Steak', NULL, 0, 40, 1, 0, 3, 100, N'#FFC0504D', 24, 1, 1, 0, 80, N'#FFC0504D', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\steak.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (16, N'Burgers', N'Burgers', 0, 60, 1, 0, 3, 100, N'Green', 24, 1, 1, 0, 80, N'#FF008000', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\burgers.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (18, N'Kebabs / Wraps', N'Kebabs / \rWraps', 0, 80, 1, 0, 3, 100, N'#FFFF9B98', 24, 1, 1, 0, 80, N'#FFF48481', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\kebab.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (19, N'Kiddies', NULL, 0, 90, 1, 0, 3, 100, N'#FFCA6919', 24, 1, 1, 0, 80, N'#FFCA6919', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\kids.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (20, N'Desserts', NULL, 0, 130, 1, 0, 3, 100, N'#FF800080', 24, 1, 1, 0, 80, N'#FF800080', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\dess.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (22, N'Sides', NULL, 0, 70, 1, 0, 3, 100, N'#FF4F81BD', 24, 1, 1, 0, 80, N'#FF4F81BD', 26, 75, 1, N'', 0, NULL, NULL, N'C:\Users\Zahid\Desktop\sides.jpg', 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (24, N'Misc', NULL, 0, 160, 1, 0, 3, 100, N'#FFFFA500', 24, 1, 1, 0, 80, N'Orange', 26, 75, 1, N'', 0, NULL, NULL, NULL, 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (25, N'Hot Drinks', NULL, 0, 120, 1, 0, 3, 100, N'#FFFFA500', 24, 1, 1, 0, 80, N'Orange', 26, 75, 1, N'', 0, NULL, NULL, NULL, 45, 0)
INSERT [dbo].[ScreenMenuCategories] ([Id], [Name], [Header], [Appearance], [SortOrder], [ScreenMenuId], [MostUsedItemsCategory], [ColumnCount], [MenuItemButtonHeight], [MenuItemButtonColor], [MenuItemFontSize], [WrapText], [PageCount], [SortAlphabetically], [MainButtonHeight], [MainButtonColor], [MainFontSize], [SubButtonHeight], [SubButtonRows], [SubButtonColorDef], [NumeratorType], [NumeratorValues], [AlphaButtonValues], [ImagePath], [NumberPadPercent], [MaxItems]) VALUES (26, N'Ice Cream', NULL, 0, 150, 1, 0, 3, 100, N'#FFFFA500', 24, 1, 1, 0, 80, N'Orange', 26, 75, 1, N'', 0, NULL, NULL, NULL, 45, 0)
SET IDENTITY_INSERT [dbo].[ScreenMenuCategories] OFF
SET IDENTITY_INSERT [dbo].[ScreenMenuItems] ON `

Any ideas? Thanks

In version 5 there is a better way to export and import products. One second I will get you a link.

Read down further for the Data Export script.

EDIT: I changed the topic to v5 question since this is not a SambaPOS issue and was a community contribution question.

1 Like