Install Quasar 2.2.0 on Ubuntu 12.04 (Precise)

This post explains how to install Quasar 2.2.0 on Ubuntu 12.04. Quasar is the best linux medium to large size business accounting program in my opinion. You can visit there website ate http://www.linuxcanada.com

download quasar single form
ftp://linuxcanada.com/pub/Quasar/2.2.0/binaries/

And you'll need libicu44
http://packages.ubuntu.com/oneiric/libicu44

I'd also suggest that you install postgresql before you install quasar-single so that you get the Postgresql-9.1 instead of 8.4 which it will want to install.

sudo apt-get install postgresql postgresql-contrib polymer qt3-qtconfig


Then install the rest of the packages. What I do more times is just download all of the above into one directory and install everything in that directory. Lets say for instance you'd download everything to ~/Downloads/Quasar/ You would then do the fallowing.

cd ~/Downloads/Quasar/
dpkg -i *
apt-get install -f


To make Quasar and other Qt3 apps look good open qtconfig and make the fallowing changes

Appearance > GUI Style > Polymer
Fonts > Family > Sans Serif
Fonts > Point Size > 9
you might also what to alter the color skeme a bit
Appearance > Tune Palette



I may post later on how to set up Postgresql further so that you can access it via pgadmin and remote computers. But just to run Quasar that is not needed.

Many times you'll notice you can't print from Quasar. To fix it run
sudo ln -s /var/run/cups/printcap /etc/printcap

Make Quasar Case insensitive (Postgresql)

This is based on ubuntu, debian etc and postgresql 9.1.3. should work with other versions too.You'll need to have postgresql-contrib installed for this to workfirst run on your quasar database

CREATE EXTENSION citext;

then run this on your quasar database.

ALTER TABLE gltx_item ALTER "number" TYPE citext;
ALTER TABLE item_plu ALTER "number" TYPE citext;
ALTER TABLE item_num ALTER "number" TYPE citext;
ALTER TABLE account ALTER "name" TYPE citext;
ALTER TABLE account ALTER "number" TYPE citext;
ALTER TABLE account_type ALTER "name" TYPE citext;
ALTER TABLE adjust_reason ALTER "name" TYPE citext;
ALTER TABLE adjust_reason ALTER "number" TYPE citext;
ALTER TABLE charge ALTER "name" TYPE citext;
ALTER TABLE cheque ALTER "name" TYPE citext;
ALTER TABLE cin_item ALTER "number" TYPE citext;
ALTER TABLE cin_return ALTER "number" TYPE citext;
ALTER TABLE cinr_item ALTER "number" TYPE citext;
ALTER TABLE consign_in ALTER "number" TYPE citext;
ALTER TABLE consign_out ALTER "number" TYPE citext;
ALTER TABLE cout_item ALTER "number" TYPE citext;
ALTER TABLE cout_return ALTER "number" TYPE citext;
ALTER TABLE coutr_item ALTER "number" TYPE citext;
ALTER TABLE customer ALTER "name" TYPE citext;
ALTER TABLE customer ALTER "number" TYPE citext;
ALTER TABLE customer_refs ALTER "ref_name" TYPE citext;
ALTER TABLE customer_type ALTER "name" TYPE citext;
ALTER TABLE dept ALTER "name" TYPE citext;
ALTER TABLE dept ALTER "number" TYPE citext;
ALTER TABLE discount ALTER "name" TYPE citext;
ALTER TABLE employee ALTER "name" TYPE citext;
ALTER TABLE employee ALTER "number" TYPE citext;
ALTER TABLE expense ALTER "name" TYPE citext;
ALTER TABLE expense ALTER "number" TYPE citext;
ALTER TABLE extra_values ALTER "data_value" TYPE citext;
ALTER TABLE gltx ALTER "number" TYPE citext;
ALTER TABLE gltx_refs ALTER "ref_name" TYPE citext;
ALTER TABLE gltx_refs ALTER "ref_data" TYPE citext;
ALTER TABLE groups ALTER "name" TYPE citext;
ALTER TABLE i_s_extra ALTER "extra_name" TYPE citext;
ALTER TABLE i_s_extra ALTER "extra_value" TYPE citext;
ALTER TABLE item_build ALTER "number" TYPE citext;
ALTER TABLE location ALTER "name" TYPE citext;
ALTER TABLE pat_group ALTER "name" TYPE citext;
ALTER TABLE pat_group ALTER "number" TYPE citext;
ALTER TABLE porder ALTER "number" TYPE citext;
ALTER TABLE porder_item ALTER "number" TYPE citext;
ALTER TABLE price_batch_item ALTER "number" TYPE citext;
ALTER TABLE price_zone ALTER "name" TYPE citext;
ALTER TABLE price_zone ALTER "number" TYPE citext;
ALTER TABLE promo_batch ALTER "number" TYPE citext;
ALTER TABLE promo_batch_item ALTER "number" TYPE citext;
ALTER TABLE quote_item ALTER "number" TYPE citext;
ALTER TABLE slip_item ALTER "number" TYPE citext;
ALTER TABLE sorder_item ALTER "number" TYPE citext;
ALTER TABLE station ALTER "name" TYPE citext;
ALTER TABLE station ALTER "number" TYPE citext;
ALTER TABLE store ALTER "name" TYPE citext;
ALTER TABLE store ALTER "number" TYPE citext;
ALTER TABLE subdept ALTER "name" TYPE citext;
ALTER TABLE subdept ALTER "number" TYPE citext;
ALTER TABLE tax ALTER "name" TYPE citext;
ALTER TABLE tax ALTER "number" TYPE citext;
ALTER TABLE tender ALTER "name" TYPE citext;
ALTER TABLE term ALTER "name" TYPE citext;
ALTER TABLE vendor ALTER "name" TYPE citext;
ALTER TABLE vendor ALTER "number" TYPE citext;