Export customers details name phone etc to excel

[Memo]

The database the tool is connecting to doesn’t appear to have the EntityTypes table.

Is the terminal you’re running it on setup to connect to SambaPOS?

[mohammed9q9]

Yes i am running on the same terminal as the SambaPOS.

[mohammed9q9]

The terminal has two entity types
Customers
TABLES

[Jesse]

Can you show the title bar of sambapos so we can see what version

[mohammed9q9]

[Jesse]

That is not the title bar. I mean top of the window shows the version

[mohammed9q9]

i am sorry, i couldnt find any versions indicated anywhere else

Once logged in this is the menu, no version indicated anywhere

[JTRTech]

He means when ypu double click samba logo to take out of full screen, the window title bar where minimise and close are on normal apps.

[mohammed9q9]

sambapos 5.2.18

[Memo]

It appears that table doesn’t exist in the database specified in the connection string.

I’ll spin up a VM later and install 5.2.18 and take a look at the schema and will go from there.

[Jesse]

You are on a very old version of sambapos. It’s likely that table didn’t exist.

[Memo]

Fresh 5.2.18 install and it’s working fine. My guess is the db name specified in the connection string isn’t pointing to a SambaPOS db for whatever reason.

[wattoo.biz]

This report will help you.

[Report:1,1,1]
Name,Phone,Address
{REPORT ENTITY DETAILS: 
  E.Name,
  EC.Phone,
  EC.Address,
:(ET=Customers)
:"{0}","{1}","{2}"}