idempiere: accounting and reporting principles
We've used iDempiere for almost a decade, but used it as an inventory maintenance and quoting system, as we used Openbravo (its […]
Category: it
exchange powershell: review and add spam rules
On the eternal fight against spam, we will be trying to minimize the impact of unwanted emails. In this case, I will […]
prestashop: memcached does NOT deactive even if on the backend its OFF.
In order for memcached to work on prestashop, two conditions have to be met: memcached installed and running on the server it […]
python: execute function from shell or cli
example: python3 -c 'from scripts.apps.malla.sugarcrm.contacts.delete_contacts_by_title import *; delete_by_title_leads(0) '
mysql: create local user and remote user
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass'; GRANT ALL ON *.* TO 'myuser'@'localhost'; CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass GRANT ALL […]
mysql: extract domain from email
SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)
mysql: capitalize first word of all words
credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/ create a function: CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT; DECLARE i […]
mysql: min value per group
surprisingly, to find the min date per company, which is a super basic query, on mysql you need to do a complicated […]
elasticsearch: secure
https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-elasticsearch-on-ubuntu-20-04 To test: Run from the local server to see if the server can connect to the elasticsearch cluster: curl -X […]