# Simple Reservation Example

**URL:** <https://forum.sambapos.com/t/simple-reservation-example/284>\
**Category:** V4 Tutorial\
**Created:** [January 15, 2014, 1:47pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284 "2014-01-15T13:47:35Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\
**Post date:** [November 27, 2014, 2:46pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/22 "2014-11-27T14:46:12Z")

</div>

can i know how to configure no show/cancel reservation button?

and is the date functionality able to be handled?

---

<div class="post-metadata">

**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\
**Post date:** [November 27, 2014, 4:17pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/23 "2014-11-27T16:17:49Z")

</div>

i am trying this for cancelling but its not working

 ![](https://forum.sambapos.com/uploads/default/original/3X/c/2/c2b3ee5645ada2fdfd683b3c64137a91855265ef.png)

---

<div class="post-metadata">

**Author:** ![funhall](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/f/b5e925/32.png) [@funhall](https://forum.sambapos.com/u/funhall)\
**Post date:** [December 2, 2014, 1:08pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/24 "2014-12-02T13:08:36Z")

</div>

Ilike to try and have this Reservation implementet. What do I do with this Zip file?  
Is that so I can choose reservation in the Entity Type name.  
I like to learn this also.

 ![](https://forum.sambapos.com/uploads/default/original/3X/f/0/f0c06c67be7ae21253c8821e4d90971487526db5.png)

---

<div class="post-metadata">

**Author:** ![morshed1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@morshed1](https://forum.sambapos.com/u/morshed1)\
**Post date:** [December 2, 2014, 3:29pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/25 "2014-12-02T15:29:16Z")

</div>

You need to have the Database Tools module in order to import the zip file. Import the file in **training mode**

Warning: Import this file on training mode to ensure it does not break your existing configuration. It replaces some default rules listed here\*\*

Ticket Closing Rule  
Update Available Entity Color  
Ticket Payment Check  
Update Moved Entity Color

> [@How to use Database Tools Module](http://forum.sambapos.com/t/how-to-use-database-tools-module/851):
>
> Database Tools Module is an Add On Module for SambaPOS. You can install it through SambaMarket. When you install Database Tools Module Database Tools link will appear under Management \> Settings section. ##Database Tasks On the main screen you can see Database Tasks screen. You can select an action from the list and click Execute Task to start the task. I’ll give more details about Database Tasks at the end of this tutorial. ##Tools On tools screen there are two use…

---

<div class="post-metadata">

**Author:** ![funhall](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/f/b5e925/32.png) [@funhall](https://forum.sambapos.com/u/funhall)\
**Post date:** [December 3, 2014, 6:57pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/26 "2014-12-03T18:57:17Z")

</div>

Now I can not choose {TICKET STATE:Status} Not equals

 ![](https://forum.sambapos.com/uploads/default/original/3X/d/f/dff395028c6f32579178400602cf597ac2688a3b.png)

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [December 3, 2014, 7:04pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/27 "2014-12-03T19:04:25Z")

</div>

Simply type it in on the left - the pick-list is not all-inclusive; you can use many different parameters (Printer Tags)…

```
{TICKET STATE:Status}

```

![](https://forum.sambapos.com/uploads/default/original/3X/2/8/28cd7c3781a4c348735687a287eed16854fcfdd2.png)

---

<div class="post-metadata">

**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\
**Post date:** [December 23, 2014, 2:45pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/28 "2014-12-23T14:45:42Z")

</div>

can anyone help to correct my rule

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [December 24, 2014, 1:56pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/29 "2014-12-24T13:56:54Z")

</div>

> [@madiha](#):
>
> i am trying this for cancelling but its not working

> [@madiha](#):
>
> can anyone help to correct my rule

@madiha, the statement “not working” is not helpful. In order to troubleshoot the issue, you need to supply more information.

When you are testing rules or actions, your best friend is the Show Message Action. It will reveal the values in tags, states, program settings etc. In most cases, the reason something “doesn’t work” is because the parameter values and/or constraints are not valid for the scenario.

---

<div class="post-metadata">

**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\
**Post date:** [December 24, 2014, 5:15pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/30 "2014-12-24T17:15:32Z")

</div>

hmmm ok in that case i would need to show ticket status…and may i know the syntax for ticket status

---

<div class="post-metadata">

**Author:** ![trentdavis](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/t/f08c70/32.png) [@trentdavis](https://forum.sambapos.com/u/trentdavis)\
**Post date:** [March 23, 2015, 12:45pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/31 "2015-03-23T12:45:46Z")

</div>

Hello,

I’m interested in reservations, however I have an online reservation system. I would like to pull reservations from my online system and import into Sambapos reservations. is this something that you can assist with and what would be the cost?

Thank you!

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [March 23, 2015, 12:55pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/32 "2015-03-23T12:55:30Z")

</div>

The upcoming V5 has powerful features for integration with Web Services.

---

<div class="post-metadata">

**Author:** ![Sothida](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/b9e5f3/32.png) [@Sothida](https://forum.sambapos.com/u/Sothida)\
**Post date:** [March 25, 2015, 9:46am UTC](https://forum.sambapos.com/t/simple-reservation-example/284/33 "2015-03-25T09:46:35Z")

</div>

how soon v5 will release?

---

<div class="post-metadata">

**Author:** ![RickH](https://forum.sambapos.com/user_avatar/forum.sambapos.com/rickh/32/51960_2.png) [@RickH](https://forum.sambapos.com/u/RickH)\
**Post date:** [March 25, 2015, 11:13am UTC](https://forum.sambapos.com/t/simple-reservation-example/284/34 "2015-03-25T11:13:36Z")

</div>

we dont know yet, hopefully soon, its being heavily tested

---

<div class="post-metadata">

**Author:** ![Marian](https://forum.sambapos.com/user_avatar/forum.sambapos.com/marian/32/11477_2.png) [@Marian](https://forum.sambapos.com/u/Marian)\
**Post date:** [May 14, 2015, 9:13am UTC](https://forum.sambapos.com/t/simple-reservation-example/284/35 "2015-05-14T09:13:34Z")

</div>

Hello,

I did all the steps, but in the **Reservation** tab it’s empty, blank.

Thank you,  
Marian

---

<div class="post-metadata">

**Author:** ![Marian](https://forum.sambapos.com/user_avatar/forum.sambapos.com/marian/32/11477_2.png) [@Marian](https://forum.sambapos.com/u/Marian)\
**Post date:** [May 14, 2015, 9:56am UTC](https://forum.sambapos.com/t/simple-reservation-example/284/36 "2015-05-14T09:56:15Z")

</div>

Hi,

Please ignore it, I found why that happened.

The “Status” in “Automation-Rules-Checkin Reservation Ticket-Update Ticket Status” should be “New Orders” not [:New Orders].

Cheer’s

---

<div class="post-metadata">

**Author:** ![Marian](https://forum.sambapos.com/user_avatar/forum.sambapos.com/marian/32/11477_2.png) [@Marian](https://forum.sambapos.com/u/Marian)\
**Post date:** [May 14, 2015, 1:30pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/37 "2015-05-14T13:30:48Z")

</div>

Hi again…

New problems.

1. The **Check-in Button** does not show after I click **Reservation**. It’s redirecting me to the MENU, but only the Change Table, Select Customer, Ticket Bill, Add Ticket And Reservation appears…
2. If I want to set a Reservation for a client, I can, but if I choose a specific table, let’s say B13, it’s not showing in the “All Tables” menu like occupied(reserved).

---

<div class="post-metadata">

**Author:** ![Marian](https://forum.sambapos.com/user_avatar/forum.sambapos.com/marian/32/11477_2.png) [@Marian](https://forum.sambapos.com/u/Marian)\
**Post date:** [May 19, 2015, 8:12pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/38 "2015-05-19T20:12:20Z")

</div>

> [@emre](#):
>
> Download Simple Reservation SQL CE database

Hello.

I have a problem:

1. I converted reservation.sdf file into reserv1.sqlce with Download SQL Server Compact Toolbox.
2. I created a new DB named Reserv1 into SQL and after I run the reserv1.sqlce in a new query. The scipts were working fine, but after I open Samba, I get this error:

![](https://forum.sambapos.com/uploads/default/original/3X/9/3/934ba9d04997324b4b92149f817c28673e69a7de.jpeg)

Any help please ?  
Thanks

---

<div class="post-metadata">

**Author:** ![Marian](https://forum.sambapos.com/user_avatar/forum.sambapos.com/marian/32/11477_2.png) [@Marian](https://forum.sambapos.com/u/Marian)\
**Post date:** [May 19, 2015, 8:17pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/39 "2015-05-19T20:17:57Z")

</div>

> [@Marian](#):
>
> Download Simple Reservation SQL CE database

Hello,

I just did, it’s explained below. I have the .sdf file, but when I run the Sambapos software it I get that error. 🙂

---

<div class="post-metadata">

**Author:** ![Marian](https://forum.sambapos.com/user_avatar/forum.sambapos.com/marian/32/11477_2.png) [@Marian](https://forum.sambapos.com/u/Marian)\
**Post date:** [May 25, 2015, 5:48pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/40 "2015-05-25T17:48:54Z")

</div>

hello,

I tried again, the same problem.

This thing it’s working or ? I see that the the tutorial it’s created in Jan 2014…

thanks.

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [May 25, 2015, 11:02pm UTC](https://forum.sambapos.com/t/simple-reservation-example/284/41 "2015-05-25T23:02:17Z")

</div>

Please reinstall SambaPOS to migrate database to latest version.

[Previous page](https://forum.sambapos.com/t/simple-reservation-example/284.md?page=1)

[Next page](https://forum.sambapos.com/t/simple-reservation-example/284.md?page=3)
