Excel file to sambapos

[QMcKay]

The same topic linked above contains a post by Emre on how to Export to YAML using Reports > Data Exports feature …

@emre

This Data Export template should work.

[DataExport:0]
@{REPORT MENU ITEM DETAILS:M.Id::|}
{REPORT MENU ITEM DETAILS:M.Name,M.GroupCode,M.Barcode,M.Tag:M.Id == $1:
- Name\: {0}
  GroupCode\: {1}
  Barcode\: {2}
  Tag\: {3}
}
{REPORT PORTION DETAILS:P.Name,P.Price:P.MenuItemId == $1:
  - Name\: {0}
    Price\: {1}:
  Portions\: {0}}
{REPORT MENU ITEM TAG DETAILS:T.Name,T.Value:M.Id==$1:
  - Name\: {0}
    Value\: {1}:
  Tags\: {0}}

Here is an alternate method to Export/Import Products and Menus directly from/to the Database Tables, using SSMS…

How to export and import Menus from one Database to Another

I was using SQL Express 2014 and Microsoft SQL Server Management Studio 2014 for this. I will show you how to use Microsoft SQL Server Management Studio to Export your Menu and Products into a SQL Script so you can use Database Tools to import your entire Menu if you ever need to rebuild your database for some reason or you want to use a non production computer to build a menu and then import it to your production system. For whatever reason this may be useful to you here is a simp…