postgresql: remove single quotes after table import.
After several iterations this one worked for me: UPDATE "Import" SET tracking_number = NULL where tracking_number ='';
openbravo: ant smartbuild deleted custom db column
I recently updated the system using the built-in Modules Window on the Admin's Side and encountered an error on the update, so […]
openbravo: not letting add business partner to financial transaction
Went to Openbravo Admin Profile -> Windows, Tabs and Fields -> Financial Account -> Transaction -> Business Partner On Display Logic it […]
erp to webstore integration
Inventory is on iDempiere Script to get inventory on CSV File Script to upload CSV File from iDempiere's server to webstore SSH […]
odoo: super easy installation
From a new Ubuntu Server execute the following commands: # wget -O - https://nightly.odoo.com/odoo.key | apt-key add - # echo "deb […]
idempiere: importing products from csv
Product Import to iDempiere has a whole lot of small details to complete successfully. The manufacturer has to be added by Manufacturer_id
shell scripts
If you want to execute a Shell Script, that connects to another server and executes another script, this is the nomenclature. Make […]
pgsql: pgdump authentication
create .pg_pass file on the root folder of the user that will run the pgsql command for example. /root or /user […]
idempiere: backup the system
Requirements: I need to have a working backup of the complete System, what in case of catastrophe I will be able to […]
synology: restart cron after update
On the Synology version of Linux, you need to restart de Crontab (/etc/crontab/) to be able to apply the changes. To restart […]