September 28, 2016

Prestashop: Debug Mode and Memory Upgrade

To turn on debug mode go to: config/defines.inc.php Set define(‘_PS_MODE_DEV_’, false); –> define(‘_PS_MODE_DEV_’, true);   To upgrade PHP Memory Limit vim /etc/php5/apache2/php.ini — Go to Memory Limit.   […]
September 23, 2016

UBUNTU: Extract Emails from TXT File

grep -E -o “[-0-9a-zA-Z.+_]+@[-0-9a-zA-Z.+_]+\.[a-zA-Z]{2,4}” /var/www/html/development/Todos2016.txt
September 16, 2016

CSV IMPORT MANUAL

Remove Commas from strings Truncate String Length using LEFT function in Excel Use CLEAN Function to remove unwanted breaks and non displaying characters
September 16, 2016

SQL Query: Remove Leading and Trailing Double Quotes

UPDATE m_product SET name = TRIM(BOTH ‘”‘ FROM name) WHERE m_product_id = ‘1128493’ UPDATE m_product set name = replace(name, ‘””‘, ‘”‘) WHERE m_product_id = ‘1128493’
September 11, 2016

Common Integration Protocols

FTP EDI XML
September 9, 2016

Logistics: Calculate volumetric weight

Dimensions in INCHES, Volumetric Weight in KILOGRAMS L x W x H in / 366 = VOL WEIGHT IN KG
September 8, 2016

iDempiere: Alter Sequence

Update M_Product_ID UPDATE ad_sequence SET currentnext = 1026150 WHERE ad_sequence_id = 114 Update Product PriceList UPDATE ad_sequence SET currentnext = 1026138 WHERE ad_sequence_id = 165