T004_CreateDrinkMenuExcell

T004_CreateDrinkMenuExcell_ImportToArmpos ================================
【ArmPos Hospitality Tutorial】課程編號: 92f3f51d-78fb-4f87-b770-3839a40e98d2 ----------- 此講義目錄 : https://aclasarmpos.blogspot.com/p/armpos-internal-tutorial.html 此講義YouTube PlayList : ArmPos Hospitality Tutorial(All) https://youtube.com/playlist?list=PLGa5Tzn6r8qHGqXwzy0_i4JAi21sl37u_ ArmPos Hospitality Tutorial(Internal) https://youtube.com/playlist?list=PLGa5Tzn6r8qHhvRh9-tuS3xpQgwMcz9Kp ArmPos Hospitality Tutorial(Customer) https://youtube.com/playlist?list=PLGa5Tzn6r8qFIcfl2r0Jd2lpnYw_5_ve5 SampleFile : https://drive.google.com/drive/folders/1FQKoWkFSMrNrEMN4Gdv6ECMygtHsgg54?usp=sharing ----------- 講義部落格 : https://aclasarmpos.blogspot.com/ Youtube PlayList : https://www.youtube.com/channel/UCyvy6XeA1tS73JpJtjlaRTQ/playlists ================================ ---------------------------- Internal Training : None Customer Training : None This Tutorial has been updated, please refer to Tutorial 13 ---------------------------- T004_CreateDrinkMenuExcell_ImportToArmpos https://aclasarmpos.blogspot.com/2022/03/t004createdrinkmenuexcellimporttoarmpos.html
================================ 1. Create Drink Menu Excell, Import To Armpos 2. Useful Files - Dat, Bat ================================
================================

1. Create Drink Menu Excell, Import To Armpos

-------------------------------------------------------------------------------------------------------------------------------------------------

Create Drink Menu Excell, Import To Armpos

-------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------

1.1.

This is the factory setting of the "Armpos".

----------------------------------------------

Graphical user interface

Description automatically generated

-------------------------------------------------------------------------------------------------------------------------

1.2.

The following files are the default factory configuration files that affect how the "Armpos' looks like.

I copied the following files to "01_BackUp_ArmPos_FactorySetting" Folder.

----------------------------------------------

C:\Program Files (x86)\CYEcrPC\CYEcr.xml

C:\Program Files (x86)\CYEcrPC\PrinterConfig.xml

-----------

C:\Program Files (x86)\CYEcrPC\Data\CYEcrBackUp.xml

C:\Program Files (x86)\CYEcrPC\Data\GridColumns.xml

C:\Program Files (x86)\CYEcrPC\Data\SecondDisplayGridColumns.xml

C:\Program Files (x86)\CYEcrPC\Data\SMTPS.XML

C:\Program Files (x86)\CYEcrPC\Data\text.txt

-------------------------------------------------------------------------------------------------------------------------

1.3.

Based on our experience, we made the following configurations files for better look.

These files are at "02_BackUp_ArmPos_20220310_Configuration" Folder.

----------------------------------------------

C:\Program Files (x86)\CYEcrPC\CYEcr.xml

C:\Program Files (x86)\CYEcrPC\PrinterConfig.xml

-----------

C:\Program Files (x86)\CYEcrPC\Data\Key\CDKey.txt

C:\Program Files (x86)\CYEcrPC\Data\license\E001.license

C:\Program Files (x86)\CYEcrPC\Data\CYEcr.xml

C:\Program Files (x86)\CYEcrPC\Data\CYEcrBackUp.xml

C:\Program Files (x86)\CYEcrPC\Data\GridColumns.xml

C:\Program Files (x86)\CYEcrPC\Data\SecondDisplayGridColumns.xml

C:\Program Files (x86)\CYEcrPC\Data\SMTPS.XML

C:\Program Files (x86)\CYEcrPC\Data\text.txt

-------------------------------------------------------------------------------------------------------------------------

1.4.

In order to get some pretty configurations.

Copy all files from "02_BackUp_ArmPos_20220310_Configuration"

and then replace to "C:\Program Files (x86)\CYEcrPC\"

------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------

2.1.

Copy the file "20220310_SunnyCafe.dat" and "20211207_BlankMenu.dat" to

C:\Program Files (x86)\CYEcrPC\DBBackup\

-------------------------------------------------------------------------------------------------------------------------

2.2.

Restore "SampleMenuDB".

In my case, I would restore "20220310_SunnyCafe.dat".

-----------

Copy the file "20220310_SunnyCafe.dat" to

C:\Program Files (x86)\CYEcrPC\DBBackup\

-----------

Run

C:\Program Files (x86)\CYEcrPC\DBMaintenance.exe

Enter "UserName, Password"

-----------

Graphical user interface, application

Description automatically generated

----------------------------------------------

Select "Restore" Tab,

In "Choose a backup:", enter the path of your "dat file".

In my case,

C:\Program Files (x86)\CYEcrPC\DBBackup\20220310_SunnyCafe.dat

-----------

Tick "Force Restore", Click "Restore"

-----------

Do you want to start the program now?

-----------

Graphical user interface, text, application

Description automatically generated

Graphical user interface, application

Description automatically generated

------------------------------------------------------------------------------------------------------------------------------------

Export "Category" and "Item"

----------------------------------------------

"Function" --> "Menu Setup"

Press "Ctrl+Alt+E"

--> Click "Category"

--> Export to "SampleCategory.xls"

User "Format1"

----------------------------------------------

"Function" --> "Menu Setup"

Press "Ctrl+Alt+E"

--> Click "Item"

--> Export to "SampleItem.xls"

Use "Format2"

------------------------------------------------------------------------------------------------------------------------------------

"SampleCategory.xls" and "SampleItem.xls"

-------------------------------------------------------------------------------------------------------------------------

4.1.

Modify "SampleCategory.xls"

----------------------------------------------

"Cat_no" column

The "1stRow" of the "Cat_no" column must be "10"

-----------

The "LastRow" of the "Cat_no" column must be "999",

and the value of its "Cat_name1" must be "Default Category".

----------------------------

"Cat_name1" column

The "Cat_name1" is the "CategoryName" which would display on "Category Area"(Bottom Right Area).

The "LastRow" of the "Cat_name1" column must be "Default Category"

-------------------------------------------------------------------------------------------------------------------------

4.2.

Modify "SampleItem.xls"

----------------------------------------------

"Item no" column

The "1stRow" of the "Item no" column must be "1001".

-----------

The "2ndLastRow" of the "Item no" column must be "9998",

and the value of its "Description1" must be "Refund Item",

and the value of its "Category" must be "999".

-----------

The "LastRow" of the "Item no" column must be "9999",

and the value of its "Description1" must be "default item",

and the value of its "Category" must be "999".

-----------

The "Item no" is the combination of the value of "Category" column plus "ItemSerialNumber"

For example, value of "Category" is "10" and the value of "ItemSerialNumber" is "1", then the value of the "Item no" is "1001".

For example, value of "Category" is "11" and the value of "ItemSerialNumber" is "1", then the value of the "Item no" is "1101".

----------------------------

"Description1" column

The "Description1" is the "ItemName" which would display on "Item Area"(Top Right Area).

----------------------------

"Category" column

The value of the "Category" column in "SampleItem.xls" must match the value of the "Cat_name1" column in "SampleCategory.xls".

----------------------------

"ItemGroup" column

The "ItemGroup" column is for "Instruction Item" of the "Self Serve Mobile Order" or "Self Server PosMachine".

If you don't have "Self Serve Mobile Order" or "Self Server PosMachine", and if you only have the "offline Pos Machine", then you don't need to worry about the "ItemGroup". In this case, we usually set the "ItemGroup" to "01".

For example, "Zero Ice, Slight Ice, Half Ice, Regular Ice, More Ice" are "Instruction Items" and their "ItemGroup" are equal to "01" which means "Ice Level".

-----------

Thus, In "ItemGroupSetup" Window,

Code == 01

Item Group Name == Ice Level

Is Single == True

Is Must == True

Min == 0

Max == 0

-----------

"Is Single == True ; Is Single == True" means we must choose only one value.

In this case, we must choose one value from "Zero Ice, Slight Ice, Half Ice, Regular Ice, More Ice".

"Is Single == True ; Is Single == False" means we could chose only one value, but we don't have to provide a value.

In this case, we could chose only one value from "Zero Ice, Slight Ice, Half Ice, Regular Ice, More Ice", but we don't have to provide a value.

----------------------------

"Price, Price1, Price2, Price3" column

"SubDescription, SubDescription1, SubDescription2, SubDescription3" column

If the value of "Multi Price" column is "FALSE", then the value of the "Price" column must match "SubDescription".

If the value of "Multi Price" column is "TRUE", then the value of the "Price, Price1, Price2, Price3" column must match "SubDescription, SubDescription1, SubDescription2, SubDescription3" separately.

----------------------------

"MainPosition, POSPosition" column

The value of "MainPosition, POSPosition" column means the position of the "Item Area"(Top Right Area).

------------------------------------------------------------------------------------------------------------------------------------

Import "Category" and "Item"

-----------

"Function" --> "Menu Setup" --> "Import Data"

--> Click "Category"

--> Import from "SampleCategory.xls"

Use "Format1"

-----------

"Function" --> "Menu Setup" --> "Import Data"

--> Click "Item"

--> Import from "SampleItem.xls"

Use "Format2"

------------------------------------------------------------------------------------------------------------------------------------

Restore "BlankMenu".

In my case, I would restore "20211207_BlankMenu.dat".

-----------

Copy the file "20211207_BlankMenu.dat" to

C:\Program Files (x86)\CYEcrPC\DBBackup\

-----------

Run

C:\Program Files (x86)\CYEcrPC\DBMaintenance.exe

Enter "UserName, Password"

-----------

Graphical user interface, application

Description automatically generated

----------------------------------------------

Select "Restore" Tab,

In "Choose a backup:", enter the path of your "dat file".

In my case,

C:\Program Files (x86)\CYEcrPC\DBBackup\20211207_BlankMenu.dat

-----------

Tick "Force Restore", Click "Restore"

-----------

Do you want to start the program now?

-----------

Graphical user interface, text, application

Description automatically generated

Graphical user interface, application

Description automatically generated

------------------------------------------------------------------------------------------------------------------------------------

Import "Category" and "Item"

-----------

"Function" --> "Menu Setup" --> "Import Data"

--> Click "Category"

--> Import from "SampleCategory.xls"

Use "Format1"

-----------

"Function" --> "Menu Setup" --> "Import Data"

--> Click "Item"

--> Import from "SampleItem.xls"

Use "Format2"

------------------------------------------------------------------------------------------------------------------------------------

Backup Database

In my case, I would back up to "20220317_OgabeeDrinkMenu.dat".

-----------

Run

C:\Program Files (x86)\CYEcrPC\DBMaintenance.exe

Enter "UserName, Password"

-----------

Graphical user interface, application

Description automatically generated

----------------------------------------------

Select "Backup" Tab,

By default, the "Direction" of your "dat file folder" is the following folder.

C:\Program Files (x86)\CYEcrPC\DBBackup

-----------

Check the "Custom file Name"

Enter the file name as the following.

20220317_OgabeeDrinkMenu

-----------

Click "Backup"

-----------

Database backup complete.

-----------

Graphical user interface, application, Word

Description automatically generated

Graphical user interface, application

Description automatically generated

-------------------------------------------------------------------------------------------------------------------------------------------------

2. Useful Files - Dat, Bat

-------------------------------------------------------------------------------------------------------------------------------------------------

Useful Files - Dat, Bat

-------------------------------------------------------------------------------------------------------------------------------------------------

"DatFile" is one kind of "SQLServer" back up file for whole database which including your sales data, menu data, and more.

I would suggest you to create a "DatFile" to backup your data daily or weekly.

I also suggest you to back up your "DatFile" to "Dropbox, GoogleDrive" or to your portable external hard drive.

------------------------------------------------------------------------------------------------------------------------------------

By default, All the "DatFile" was in the following "Directory"

C:\Program Files (x86)\CYEcrPC\DBBackup\

The "FileName" of "DatFile" should be "yyyymmdd_StoreName_Reason".

------------------------------------------------------------------------------------------------------------------------------------

Dat File

-------------------------------------------------------------------------------------------------------------------------

3.1.

DBBackup\20220310_SunnyCafe.dat

This is a sample menu of the Cafe for "Armpos Hospitality".

-------------------------------------------------------------------------------------------------------------------------

3.2.

DBBackup\20211207_BlankMenu.dat

"DatFile" is one kind of "SQLServer" back up file for whole database which including your sales data, menu data, and more.

"DBBackup\20211207_BlankMenu.dat" is the "BlankDatabase" for "Armpos Hospitality"

which means there is no "Category", no "Item", and no "SalesRecord".

----------------------------------------------

"DatFile"是一種"SQLServer"備份檔案，可以備份整個資料庫，包括你的銷售紀錄，菜單，和其他。

"DBBackup\20211207_BlankMenu.dat"是"Armpos Hospitality"的"BlankDatabase"(空白資料庫)

這意思是其沒有"Category"(菜單種類)、沒有"Item"(菜單物件)、沒有"SalesRecord"(銷售紀錄)。

------------------------------------------------------------------------------------------------------------------------------------

BAT File

-------------------------------------------------------------------------------------------------------------------------

4.1.

ArmposHospitality_DeleteCategoryAndItemAndSales.bat

Delete all "Category" and "Item" and "SalesRecords" in "ArmposHospitality".

刪除"ArmposHospitality"裡面所有的"Category"和"Item"和"SalesRecords"。

-------------------------------------------------------------------------------------------------------------------------

4.2.

ArmposHospitality_DeleteSales.bat

Delete all "SalesRecords" in "ArmposHospitality".

刪除"ArmposHospitality"裡面所有的"SalesRecords"(銷售紀錄)

-------------------------------------------------------------------------------------------------------------------------

4.3.

ArmposRetail_DeleteCategoryAndItemAndSales.bat

Delete all "Category" and "Item" and "SalesRecords" in "ArmposRetail".

刪除"ArmposRetail"裡面所有的"Category"和"Item"和"SalesRecords"。

-------------------------------------------------------------------------------------------------------------------------

4.4.

ArmposRetail_DeletePromotion.bat

Delete all "Promotion(Discount)" in "ArmposRetail".

刪除"ArmposRetail"裡面所有的"Promotion(Discount)"(打折優惠)

-------------------------------------------------------------------------------------------------------------------------

4.5.

ArmposRetail_DeleteSales.bat

Delete all "sales records" in "ArmposRetail".

刪除"ArmposRetail"裡面所有的"sales records"(銷售紀錄)

-------------------------------------------------------------------------------------------------------------------------

4.6.

ArmposRetail_SetStockQuantityToZero.bat

Set the "Stock Quantity" to "0" for all "Items" in "ArmposRetail".

把"ArmposRetail"裡面所有的"Items"的"Stock Quantity"都設為"0"。

-------------------------------------------------------------------------------------------------------------------------------------------------

Search This Blog

AClas

T004_CreateDrinkMenuExcell_ImportToArmpos

Comments

Post a Comment

Popular posts from this blog

T010_ArmposRetail_Basic

T001_VMWareWorkStation_CreateNewVM

T003_Install_ArmPosHospitality