iDempiere

iDempiere: Add All Roles to Admin

Posted on

It’s a pain to add all the roles to the Admin Role (I had to re-create this role because I messed up the original role and had to hack my way back to the system). The role is divided in several tables. ad_window_access ad_process_access ad_form_access ad_workflow_access ad_task_access ad_document_action_access ad_infowindows_access To recreate all the Roles I […]

iDempiere

iDempiere: Cleaning Demo Data

Posted on

The following tables use space on my database and for the use I have for the system I will not use them (I don’t need accounting because I use another system for this). So I’ll delete them. “adempiere”.”m_product_acct” 5904 kB 2344 kB 8248 kB “adempiere”.”m_cost” 4520 kB 3568 kB 8088 kB “adempiere”.”m_product_po” 4696 kB 3192 […]

PostgreSQL

PostgreSQL: Find biggest tables on your database

Posted on

Excecute the following command on phpPgAdmin on the SQL Tab.   SELECT table_name, pg_size_pretty(table_size) AS table_size, pg_size_pretty(indexes_size) AS indexes_size, pg_size_pretty(total_size) AS total_size FROM ( SELECT table_name, pg_table_size(table_name) AS table_size, pg_indexes_size(table_name) AS indexes_size, pg_total_relation_size(table_name) AS total_size FROM ( SELECT (‘”‘ || table_schema || ‘”.”‘ || table_name || ‘”‘) AS table_name FROM information_schema.tables ) AS all_tables ORDER […]

Ubuntu

Ubuntu: Clean full Boot Partition

Posted on

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 get an error while trying to do this, the next step is to check if this is in fact happening. You’ll get something like: root@aizary:~# df -h Filesystem Size Used Avail Use% Mounted […]

PFSense

PfSense: Cron to Reset States

Posted on

I will do a daily Reset States because I have an asterisk server with remote users, and I think there may be some problems if their IP Changes. (I think buy am not sure). So I installed the Cron Package, and the just execute… pfctl -F state    

OpenBravo

OpenBravo: Custom Changes

Posted on

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 for Business Partner on Financial Account Display Logic for Tracking Number on Goods Shipment — DELETED (@DeliveryViaRule@=’S’)

PostgreSQL

PostgreSQL: Update column from another table’s column

Posted on

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 = c_order.c_order_id)     UPDATE m_product SET manufacturer = (SELECT m_product_po.manufacturer FROM m_product_po WHERE m_product.m_product_id = m_product_po.m_product_id )