Simple Reservation Example

Version 4 V4 Tutorial
42

Hello,

  1. I just installed it from here:
    http://sambapos.com/download-sambapos/ - SambaPOS 4.1.82 version
  2. I Down “Download Simple Reservation SQL CE database” from this page. (reservation.sdf)
  3. I made a new DB with the SQLCE40Toolbox.exe wit the the name “reserv”
  4. In Sambapos on Local Settings:
    Data Source=localhost\testsamba2; User Id=sa; Password=XXX; Database=reserv;
    .
    7b50ad7c43ac690a.JPG1899×990 323 KB
  5. The error means that a EntityTypeId column it’s invalid. Should I Delete it from the query, before I create the “reserv” DB ?
  6. Also the SambaModulesTicketModule I think it’s activated on your DB, and not in mine, that’s why I get the exception…
    Thanks.
43

OK. Now please reinstall SambaPOS to migrate database (you downloaded) to latest db version.

44

Ok, you are saying that i need the install the version of samba that support’s that DB on the website.

On the Down page I don’t see the 4.1.9 version, only until 4.1.25

426ad4295e2ca73a.JPG723×163 11.2 KB

45

Well I’m saying reinstall latest SambaPOS. Setup will automatically migrate your database to latest version. When you open a database generated with older SambaPOS versions you need to reinstall SambaPOS to upgrade database to latest.

46

Ok, so I created a new db, “reserv123”.
I Uninstalled sambapos, with “RevoUninstaller” to get everything removed.
I Installed the “latest Sambapos 4.1.82”, and made the path to:

and the error above appears.
You can see the the DB it’s Created:

dbbc9b5850964134.JPG769×362 58 KB

47

I’ve not said uninstall SambaPOS, recreate DB or something else. Why you’re doing these? When you see the EntityId error message, close SambaPOS, double click on SambaPOS setup program, let it setup and start SambaPOS. That’s all.

48

Hello,

OK, Now it’s Working.
Sorry for my bad english and other things.

1 Like
49

No need to be sorry. Your English is better than mine lol.

50

Hello,
NP.
Because when I saw “Please reinstall SambaPOS to migrate database to latest version.” I thought that you need to UNinstall it first, and after install a fresh copy of samba. Now I know why it’s needs REinstalled.
Sorry for that.

1 Like
51

Hello again. So with the help of @emre I finished to add the .sdf file into my DB. And I added the Occupied Button, Now I have other problems:

  1. After I create a reservation, the Check In button does not appear.
  2. If the client calls to cancel his reservation, I don’t have an option to Cancel that, does not disappears from the RESERVATIONS list.
    6a643782d057884c.JPG1398×326 34.6 KB

Any help please ?

52

  1. Check the mappings for the check in button, it is t showing as you havent told it to. Whatever state your ticket is when you have changed it to a reservation needs to be added to the visible and enable parts of the mapping for that button. Do that and it will appear

  2. You need to create a cancel reservation button that is only visible on a ticket with state reservation or reserved (or whatever you called it)
    Setup an update ticket state action to remove the reservation state from the ticket (it will now not show on your reservation screen)

Create a rule to link you cancel reservation button with update ticket state action to remove the reservation state and add close ticket action

When you press cancel reservation the ticket state will update to remove reservation and the ticket will close

53

Hello,

I have the .sdf file installed from @emre, from the top of the page. And from there I started to modify things.
I need to go from there, to set things to work.
Thanks, I will try to use your advice.

54

Use Create Default Buttons maintenance task from Program Settings > Maintenance.

55

Hello,

I did that , NO GO. I think there is a conflict somewhere on my db. With all the things that I modified. (Reserv. db from you, Occupied Button, Cancel Order, Cancel Button for the products).
Now I am REchecking all the steps in “Simple Reservation Example”, and are all in there.
Maybe it’s an issue with the mappings from the check in button:

90bae3dd5a6cc99074649b2b6d1baa612885c3df.JPG991×68 10.8 KB

56

show a reservation ticket so we can see what state its in.

57

show a reservation ticket so we can see what state its in.

HERE @kendash and @emre :

f52e380071dfaea321804a9904c18ef517ce815c.JPG1328×448 45.7 KB

012e6fd0c2a60f5e9c2eb4a16c156a9868e0ab35.JPG1350×706 76 KB

58

Hello,
Maybe a picture is worth a thousand words, here it’s what I get from what are you saying:
a: You need to create a cancel reservation button that is only visible on a ticket with state reservation or reserved (or whatever you called it)

3890a4f71dcef9376f54a3aa8ba69cfed1c91b11.JPG926×540 33.4 KB

b6d747170a31178b3678323fc9f12404e5b61df9.JPG1339×238 28.9 KB

b: Setup an update ticket state action to remove the reservation state from the ticket (it will now not show on your reservation screen)
497ef1837ad21a204e925297a94eb210254c57cc.JPG931×399 26 KB

c: Create a rule to link you cancel reservation button with update ticket state action to remove the reservation state and add close ticket action
d9ea5ec6041ce6a6939465a68b0498ca01a684c9.JPG1342×580 54.1 KB

d:
6e09b48ab1e434b704d611e3d122326bbbb0b3ac.JPG1346×258 26.7 KB

If you have some time, can you please make a print screen, because I don’t know the Samba Software so well, or just upload again my pictures, after you will modify it in paint, if you have time :D.

Thanks

59

lol what I thought. Its not setting the reservation state. Your rule to set reservation state is wrong or missing the state.

60

Hello,

Yes lol … I know that it’s something wrong or missing, that’s why I made those print screens, for you guys, to explain.

Thanks.

61

In your update ticket status reservation action in your rule just type Reservation in the box next to current status

Also in you button mapping type Reservation under Enables States as well

Sorry i couldnt do screenshots i was on my mobile, but it will help you doing it yourself anyway :wink: and were always here to help