postgresql: restore db from sql
#Upload the backup .sql file to the server #Execute the following command. root@ubuntu:~# psql -Uadempiere idempiere < /opt/idempiere-server/DBImport/DB3.sql
Author: Ricardo Malla
idempiere: configuring webservices
First if services are enabled: http://host:port/osgi/system/console/bundles See Available WebServices http://host:port/ADInterface/services
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 […]
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 […]