Invoice layout problems


If you have a problem with invoice layouts.

Like the information about the invoice is printed in your PDF, but the layout is missing. Then there’s properly a problem with the combination of your odoo installation and the WKHMTLTOPDF program.

To solve it, do the following:

  • goto settings.
  • parameters.
    • system parameters:

Then add the following key to your system parameters:

report.url with a value of: http://127.0.0.1:8069

 

remarks: The odoo server will send the layout information (which is designed in Qweb) to a module called wkhtmltopdf and odoo will normally get feedback from that module, to build the pdf. Because it cannot established a working connection to wkhtmltopdf, it can only create the invoice only with is own information, and it’s  therefore missing the layout information.

The solution is to provide Odoo with the correct URL, we are overriding the default report.url into the system to use it’s own localhost number (127.0.0.1 followed by the port number odoo is listening on, in this case :8069).

 

Keyboard in the dishwasher


320px-Apple-wireless-keyboard-aluminum-2007

Every computer owner will recognize the problem once in his/her lifetime. Some coffee or worse liquid was spoiled on your keyboard and now it has some strange behavior. Some keys are working, some are not.

Before you throw you keyboard in the garbage and are heading for the store to buy a new one, you can try to do the following:

  • 1. Disconnect the cable or batteries as soon as possible.
  • 2. Put the keyboard in the dishwasher!
  • 3. Let it dry (mine did for more then 1 week).
  • 4. Reconnect the keyboard cable or insert the batteries and enjoy you perfectly cleaned and working keyboard again.

Some tips!

  • First try without using some cleaning soap, only run the dishwasher with warm water (not to hot, because of warping of the plastic housing/keys could occur).
  • If your dishwasher is using a hot dry option, don’t use it, because of deformation of the keyboard housing and/or keys could occur.

Drying the keyboard can take a few days. Mine needed more then one week, before it was working perfectly again.

 

 

Database run full update command.


Database update to the rescue!

Sometimes after installing or removing some modules, there are some warnings in your console output when you run openerp-server.
Also if you have updated some modules from the nightly update, this can be a real time saver.

The following command can help you to make sure that everything is populated right in your database.
But before you do, make sure you have a backup of the database in the rare case something went wrong.

/opt/odoo/odoo/./openerp-server -d odoo -u all

Watch te output carefully when you enter this command. It will tell you some important information if some updates were not able to populate through the database. 

So you want to use Odoo v8?


But how do you install this beast onto your new and fresh Ubuntu 14.04 LTS.

This article will describe the steps to follow to accomplish this.

1. Update to the latest!

First after you have freshly installed your Ubuntu 14.04 LTS server. You have to make sure it’s up to date.

So enter the following commands on the command line:

sudo apt-get update && upgrade -y

2. Install all requirements and „nice to have libraries”

sudo apt-get install git vim python-dev python-nltk build-essential python-setuptools postgresql bzr graphviz ghostscript postgresql-client python-dateutil python-feedparser python-gdata python-ldap python-libxslt1 python-lxml python-mako python-openid python-psycopg2 python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-imaging python-matplotlib python-docutils python-unittest2 python-mock python-jinja2 python-requests python-decorator -y

3. Create Openerp/Odoo user

sudo useradd openerp -m -s /bin/bash

4. Create OpenERP/Odoo User for Postgresql

sudo su postgres
createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt openerp
exit

5. Checkout OpenERP/Odoo from Source Repository

cd /home/openerp
sudo su openerp
git clone -b 8.0 https://github.com/odoo/odoo.git

6. Setup Odoo/OpenERP Configuration Parameters

once checkout is complete, you need to generate configuration file for your OpenERP.

su openerp
cd /home/openerp/odoo
./openerp-server --addons-path=addons -s
hit CTRL-C

This will start openerp server and create a configuration file in your home directory as .openerp_serverrc

sudo mv /home/openerp/.openerp_serverrc /etc/openerp-server.conf

To edit this file and change parameters like db_user, db_passord, admin_password, logfile path

sudo vim /etc/openerp-server.conf

you can set

logfile = /var/log/openerp-server.log

 

7. Making OpenERP/Odoo As A Service

sudo cp /home/openerp/odoo/debian/openerp.init /etc/init.d/openerp
sudo vim /etc/init.d/openerp

change

DAEMON=/usr/bin/openerp-server

to

DAEMON=/home/openerp/odoo/openerp-server

save the file and exit

8. Putting OpenERP/Odoo As A Service

sudo update-rc.d -f openerp start 20 2 3 4 5 

That’s it, just start your openerp server by

sudo service openerp start

9. Command Lessc is missing.

If you encounter some strange behavior after switching templates in het website part of odoo. It’s properly due to the fact that your ubuntu 14.04 LTS didn’t have the lessc command.

Install this by entering the following commands on the command line. This will make sure you will install the latest version of the node-less package on Ubuntu 14.04.

sudo apt-get install npm
sudo npm install -g less

Because the command name of the node.js is nodejs, you have to change the first line of the program to reflect these change.

After installing go to:

/Usr/local/bin/lessc with your favorite text editor and change the first line.

1
2
3
4
5
6
7
8
--- lessc.old   2013-05-21 13:50:00 +0300
+++ lessc   2013-05-21 13:51:00 +0300
@@ -1,4 +1,4 @@
-#!/usr/bin/env node
+#!/usr/bin/env nodejs

var path = require('path'),
fs = require('fs'),

This will install the needed less program globally on your server and Odoo will be able to use it.

Now you ready to go.

Reboot your server and enjoy Odoo v8.!

Zonneboiler controller.


Ik ben van plan om een eigen zonneboiler controller te maken. De reden hiervoor is dat de bestaande controllers niet alles doen, wat ik zou willen. Hierdoor zou het rendement van een gemiddelde zonneboiler nog wat opgeschroefd kunnen worden.  Al een aantal jaren heb ik een grote zonneboiler welke ook mijn huis verwarmt (ook in de winter 🙂 ). En gebruik ik eigenlijk een behoorlijk uitgebreide controller. Echter ik wil meer. Om te bekijken wat ik nou eigenlijk allemaal wil, heb ik het volgende lijstje samengesteld.

  • Collector Temperatuur In meten;
  • Collector Temperatuur Uit meten;
  • Vat temperatuur onder;
  • Vat temperatuur midden;
  • Vat temperatuur boven;
  • Schakelen van de pomp met variable pompsnelheid. (Triac of PWM pomp);
  • Meten van de flow in het solarciruit;
  • Meten van de flow in het afname circuit;
  • Meten van de flow in het CV gedeelte;
  • Schakelen van drieweg klep CV gedeelte;
  • Schakelen van Vloerverwarmings pomp;
  • Schakelen van CV-pomp (onafhankelijk van CV installatie);
  • Temperatuur meten van verswaterstation;
  • Eenvoudige uitlezing via grafisch display;
  • Mogelijkheid tot een satelite display (remote display);
  • Netwerk aansluiting dmv RJ45 connector en/of draadloos (wifi);
  • Logging van alle variabelen over langere periode;
  • Grafieken (via internet server) van meeste variabelen;
  • Dynamische toewijzing van verschillende temperatuur sensoren (dus niet Sensoren ‘omprikken’ maar via de software selecteren welke sensor waar bij hoord;
  • Druk uitlezen van solarcircuit;
  • Druk uitlezen van het vat;
  • Meerdere vaten met Prioriteits instellingen kunnen laden vanuit het solarcircuit;
  • Meerdere vaten laden met behulp van prio-vat;
  • Koelfunctienaliteit;
  • Her-koeling via solarcircuit;
  • Dynamische Pomp/klep sturing op basis van tijd/temperatuur/temperatuurverschil;
  • Pomp/Klep schakeling met externe heatdump;
  • Pomp/Klep schakeling t.b.v. Jacuzzie of zwembad;
  • Licht meting per collectorArray;
  • Kosten/opbrengst zichtbaar;
  • Verschillende ‘heattransfer’ mediums configureerbaar instelbaar;
  • Vorstbescherming van de solarvloeistof;
  • warmtebescherming van de solarvloeistof.

Er zal de komende tijd ongetwijfeld nog wat extra wensen/functies bijkomen. Ik zal ze dmv deze post proberen bij te houden.

In eerste instantie zit ik te denken aan verschillende modules te bouwen, en deze vervolgens met elkaar te laten samenwerken.