ubuntu: how to zip files created on a specific month
I've got a couple of gigabytes of files created daily by my Asterisk Server. This files are created on every call (asterisk […]
Category: it
ubuntu: clean full boot partition
If the your boot partition if full you won't be able to update, upgrade or install new packages (apt-get upgrade/update/install). You will […]
pfsense: cron to reset states
I will do a daily Reset States because I have an asterisk server with remote users, and I think there may be […]
openbravo: custom changes
Keep track of the custom changes that can be lost when rebuilding: ADD DB Column c_order.po_refernce_no ADD DB Column c_order.tracking_number Display Logic […]
postgresql: update column from another table's column
UPDATE c_order SET po_refernce_no = (SELECT po_refernce_no FROM "Import" WHERE c_order_id = c_order.c_order_id), tracking_number = (SELECT tracking_number FROM "Import" WHERE c_order_id = […]
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 […]