July 18, 2016postgresql postgresql: remove single quotes after table import. After several iterations this one worked for me: UPDATE "Import" SET tracking_number = NULL where tracking_number ='';
July 18, 2016July 19, 2016openbravo 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 […]
July 15, 2016July 15, 2016openbravo 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 […]
May 31, 2016August 11, 2016idempiere, prestashop 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 […]
May 31, 2016May 31, 2016openerp/odoo 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 […]
May 30, 2016May 30, 2016idempiere 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
May 30, 2016May 30, 2016shell shell scripts If you want to execute a Shell Script, that connects to another server and executes another script, this is the nomenclature. Make […]
May 27, 2016December 29, 2021postgresql 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 […]
May 27, 2016May 27, 2016idempiere 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 […]
May 25, 2016May 25, 2016synology 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 […]