View source | Discuss this page | Page history | Printable version   

OpenbravoPOS FAQ/it

Contents

Questioni Generali

Openbravo POS supporta interfacce web?

Openbravo POS is a desktop application because:

  1. Openbravo POS has to deal with POS hardware: receipt printers, customer displays and other devices. It is more easy to deal with them as a desktop application.
  2. The user interface is oriented to touch screens and Openbravo POS needs very sophisticated user controls that HTML cannot provide.

Che tipo di periferiche supporta Openbravo POS ?

These are the peripherals that Openbravo POS supports:

Openbravo POS è eseguibile su Windows CE?

It is not possible to run Openbravo POS on Windows CE or to port Openbravo POS to Windows CE. However, the requirements of Openbravo POS are very low and you can cut costs using low processors like VIA processors and Linux operating system.

Dove posso recuperare il codice sorgente di Openbravo POS?

Openbravo POS source code it is available from Openbravo Subversion server, there are instructions on how to setup a Subversion client to access to it. To get written access please contact collaborate@openbravo.com.

Posso eseguire Openbravo POS usando una risoluzione di 800x600?

The preferred resolution for Openbravo POS is 1024x768. But with some configuration changes you can make Openbravo POS work in 800x600.

In the resources panel edit the resource Ticket.Buttons and modify the value of the property cat-height to 150.

And in the configuration panel modify the value of the property Screen to fullscreen.

Restart the application and you will see the sales panel and most functions to fit properly in your 800x600 monitor. Only few panels does not fit properly in 800x600.

Any particular combination of peripherals that you would recommend?

Can Openbravo POS run with OpenJDK?

No, Openbravo POS does not run with OpenSDK that is actually the Java framework installed by default in some Linux distributions like Ubuntu. You have to use Sun's Java 2 Platform Standard Edition 6.0 or higher.

If OpenJDK is installed, Openbravo POS throws the following exception:

net.sf.jasperreports.engine.JRException: 
javax.imageio.IIOException: Invalid argument to native writeImage

To fix this install Sun's Java 2 Platform Standard Edition 6.0 or higher. In Ubuntu this can be done executing.

$ sudo apt-get install sun-java6-bin sun-java6-jre
$ sudo update-java-alternatives -s java-6-sun

If you want to maintain OpenJDK installed in your machine it may be necessary to specify to Openbravo POS the path where the Sun's Java 2 Platform Standard Edition resides. For example if it resides in /usr/lib/jvm/java-6-sun you can include the following two lines in start.sh:

JAVA_HOME=/usr/lib/jvm/java-6-sun
PATH=/usr/lib/jvm/java-6-sun/bin:$PATH

Dialogs sometimes does not show all images and the right window boundary is off the screen

Java does not work properly under Linux with Compiz activated. To fix this one solution is just to disable Compiz. For example in Unbuntu go to System / Preferences / Appearance, and in the tab Visual Effects select None. The other solution is to set the environment variable AWT_TOOLKIT to MToolkit before starting Openbravo POS. You can do this adding to /home/username/.bashrc the line.

export AWT_TOOLKIT=MToolkit

Sometimes appear strange images in text boxes

Java does not work properly under Windows Vista with Aero activated. To fix this just turn off Aero effects.

Software configuration

How Openbravo POS decides which language to use for the user interface?

By default Openbravo POS takes the language to use from the operating system. But you can also change then language in the configuration panel of Openbravo POS. In this panel you can also change the properties related to the format of numeric values, currencies and dates.

How can I change the receipts printed to include my logo and other details

Openbravo receipts are fully configurable and is based on templates, you can change these templates in the resources panel. Log in as administrator and go to Administration / Maintenance / Resources. Here edit the record Printer.Ticket that contains the template of the receipt that is printed after a sale operation is closed. There are other templates in this panel for other moments of the operation of Openbravo POS you are also free to modify.

How can I modify the reports and create new ones

Openbravo POS 2.10 and later versions provide an structure for reports that makes it easier to modify and create new reports. There is a tutorial here Openbravo POS Reports and Charts Tutorial

How can I manage the taxes depending on the customer

Taxes architecture in Openbravo POS is very similar to Openbravo ERP and you can set a different taxes schema depending on the customer. This is explained in detail here Openbravo POS Taxes Management.

How can I give a discount in Openbravo POS?

There are many ways to do it. For example:

In addition to this, you could as well provide discount on individual items directly by selecting the item on the sales panel and then clicking on the pencil icon, modifying the price and hitting Enter. But this would not show as "DISCOUNT" on the receipt and hence your customer would not even know that you have given him a discount.

How can I work with the restaurant module

To work with the restaurant module to be able to show the tables layout and the reservations panel. Go to the configuration panel and in the option Tickets, select restaurant.

Openbravo POS cannot print reports under Linux

Openbravo POS shows a message Error printing report, See the console for details when trying to print a report because of the java platform bug http://bugs.sun.com/view_bug.do?bug_id=6633656. You can have it work by specifying the Orientation in every printer in CUPS. Depending on your system go to System -> Printing and for each printer select the Job Options tab and specify Orientation to whatever else instead of Automatic Rotation.

Openbravo POS can't find database driver in Linux

You might get this error when starting up Openbravo POS: "Danger: Cannot connect to database. Database driver not found."

This is because the path for the JDK is not specified. For example, if your JDK resides in /opt, you can include the following two lines (adjust as necessary) in start.sh:

export JAVA_HOME=/opt/jdk1.6.0_07
export PATH=/opt/jdk1.6.0_07/bin:$PATH

or (Ubuntu 8.10) [Log in as -root- to edit start.sh file]

JAVA_HOME=/usr/lib/jvm/java-6-sun
PATH=/usr/lib/jvm/java-6-sun/bin:$PATH

Openbravo POS does not start, it shows the message could not find the main class

Openbravo POS 2.30 needs java 1.6 o greater version, if you have installed java 1.5 or a previous version this message appears when trying to execute Openbravo POS. To know what version is the default version of java in your system open a console and type java -version.

To fix this problem remove any previous version of java and install java 1.6 or a greater java version.

How can I reset / remove data in Openbravo POS

If you have been testing and configuring Openbravo POS and you want to remove all the receipts you created but maintaining the master data: Products, categories, ... Execute the following SQL commands:

DELETE FROM TICKETLINES;
DELETE FROM TAXLINES;
DELETE FROM TICKETS;
DELETE FROM PAYMENTS;
DELETE FROM RECEIPTS;
DELETE FROM SHAREDTICKETS;
DELETE FROM STOCKDIARY;
DELETE FROM CLOSEDCASH;
UPDATE STOCKCURRENT SET UNITS = 0;

If you want also reset the receipt number counters, execute for HSQLDB and PostgreSQL:

ALTER SEQUENCE TICKETSNUM RESTART WITH 1;
ALTER SEQUENCE TICKETSNUM_REFUND RESTART WITH 1;
ALTER SEQUENCE TICKETSNUM_PAYMENT RESTART WITH 1;

for MySQL:

UPDATE TICKETSNUM SET ID = 1;
UPDATE TICKETSNUM_REFUND SET ID = 1;
UPDATE TICKETSNUM_PAYMENT SET ID = 1;

for Oracle:

DROP SEQUENCE TICKETSNUM;
CREATE SEQUENCE TICKETSNUM START WITH 1;
DROP SEQUENCE TICKETSNUM_REFUND;
CREATE SEQUENCE TICKETSNUM_REFUND START WITH 1;
DROP SEQUENCE TICKETSNUM_PAYMENT;
CREATE SEQUENCE TICKETSNUM_PAYMENT START WITH 1;

for Derby:

DELETE FROM TICKETSNUM;
ALTER TABLE TICKETSNUM ALTER COLUMN ID RESTART WITH 0;
INSERT INTO TICKETSNUM VALUES (DEFAULT);
DELETE FROM TICKETSNUM_REFUND;
ALTER TABLE TICKETSNUM_REFUND ALTER COLUMN ID RESTART WITH 0;
INSERT INTO TICKETSNUM_REFUND VALUES (DEFAULT);
DELETE FROM TICKETSNUM_PAYMENT;
ALTER TABLE TICKETSNUM_PAYMENT ALTER COLUMN ID RESTART WITH 0;
INSERT INTO TICKETSNUM_PAYMENT VALUES (DEFAULT);

If you want also delete products and categories, execute:

DELETE FROM STOCKCURRENT;
DELETE FROM PRODUCTS_COM;
DELETE FROM PRODUCTS_CAT;
DELETE FROM PRODUCTS;
DELETE FROM CATEGORIES;

If you want also delete customers, execute:

DELETE FROM CUSTOMERS;

If you forgot the administrator password and you cannot login as administrator, to reset the administrator password, execute the following SQL sentence:

UPDATE PEOPLE SET APPPASSWORD = NULL WHERE NAME = 'Admin';

To execute the previous SQL commands use the SQL client tool you prefer for the database engine you use. One tool that fits for all the database engines supported by Openbravo POS is Squirrel SQL.

Right-to-left language support (Arabic and Hebrew)

How do I write Arabic product names and other items using OpenBravo and MySQL

Arabic characters may appear garbled once saved into the database if the proper settings are not used.

on MYSQL make sure that your database/tables and varchar fields are set to eithere: UTF8 OR CP1256 codpages.

on OpenBravo make sure you set append the JDBC URL with : ?characterEncoding=utf8 i.e.: jdbc:mysql://localhost:3306/MyDBPROD?characterEncoding=utf8


Hardware configuration

What are the parameters used by Openbravo POS to communicate to a serial printer

The serial parameters used by Openbravo POS to connect to serial receipt printers and customer displays are:

How to install a receipt printer that has a USB connector

Openbravo POS supports ESC/POS receipt printers that connects directly to a serial or parallel port, but there is not included in Openbravo POS support for USB ports.

However there are two methods that allow to use the ESC/POS protocol with an USB port in Openbravo POS. The two methods described here refers only to Windows operating systems:

Share the printer

NET USE LTP1: /DELETE 
NET USE LTP1: \\COMPUTER NAME\PRINTER /PERSISTENT:YES 
   System Error 67 Network Name Not Found.

Install a serial emulation driver

Several USB receipt printers has a driver that creates a virtual serial port connected to the receipt printer. After installed this driver you only have to configure Openbravo POS to use the receipt printer as if was connected to a regular serial port.

For example for the USB Epson TM T88IV there is a serial emulation driver that can be downloaded from here http://www.posguys.com/download/TM-T88IV/TMCOMUSB130a.exe .

How to install a receipt printer and a cash drawer that have a javapos driver

This small guide has been copied from a forum message for an USB Star receipt printer.

set STARHOME=libstar 
set CP=%CP%;%STARHOME%/jcl.jar 
set CP=%CP%;%STARHOME%/jpos191-controls.jar 
set CP=%CP%;%STARHOME%/stario.jar 
set CP=%CP%;%STARHOME%/starjavapos.jar 
set CP=%CP%;%STARHOME%/xercesimpl.jar 
set CP=%CP%;%STARHOME%/xml-apis.jar  
-Djpos.config.populatorFile="%USERPROFILE%/jpos.xml"
-Xms32m -Xmx512m 

Retrieved from "http://wiki.openbravo.com/wiki/OpenbravoPOS_FAQ/it"

This page has been accessed 34,263 times. This page was last modified on 21 October 2009, at 13:32. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.