Uncategorized

JAVA: Revert from JAVA 1.8 to 1.7 Windows 10

Posted on

Uninstall Java from Control Panel -> Programs -> Uninstall Need to remove three files from /Windows/System32 and C:\ProgramData\Oracle\Java\javapath (you need to view hidden files to see Program Data) This files are  "java", "javaw" and "javaws" After you do this you should reboot and then install the java version you want (in this example java 1.7) […]

iDempiere

Jasper Studio: JAVA Compatibility

Posted on

We user Jasper Reports on multiple projects: We have a stand-alone Jasper Server that runs all types of reports from our server We have an Openbravo ERP Instance  We have an iDempiere ERP Instance Running (same fork root as Openbravo). The Jasper Studio is used to configure the reports and compile them, the problem is […]

PostgreSQL

PgSQL: Create table inside database

Posted on

Example   CREATE TABLE c_ordernotes ( c_ordernotes_id numeric(10,0) CONSTRAINT firstkey PRIMARY KEY, ad_client_id numeric(10,0) NOT NULL, ad_org_id numeric(10,0) NOT NULL, isactive character(1), created timestamp DEFAULT current_timestamp, createdby numeric(10,0), updated timestamp DEFAULT current_timestamp, updatedby numeric(10,0), c_order_id numeric(10,0), line numeric(10,0), notes_name varchar(255), notes_description varchar(2550) );

Uncategorized

Asterisk: Fail2ban & IP Tables

Posted on

https://www.voip-info.org/fail2ban-with-iptables-and-asterisk/ /etc/init.d/fail2ban restart /etc/init.d/fail2ban reload /etc/init.d/iptables-persistent restart When you reload or restart fail2ban all the bans are removed.    One problem with this wonderful solution (which is related to iptables, not fail2ban), is that when you reboot your server all the rules and blocked IPs are deleted. On my case I want all this IPs […]

Uncategorized

Prestashop: Remove Manufacturer List Scroll

Posted on

theme folder -> manufacturer-list.tpl To remove top scrool, around line 70, delete the following: <div class="top-pagination-content clearfix bottom-line"> {include file="$tpl_dir./pagination.tpl" no_follow=1} </div>   For the bottom one,    Delete around line 153   <div class="content_sortPagiBar"> <div class="bottom-pagination-content clearfix"> {include file="$tpl_dir./pagination.tpl" no_follow=1 paginationId='bottom'} </div> </div>     To disable Sortibar Delete around line 51:   <div […]

Prestashop

Prestashop: Manufacturer Page Slow

Posted on

-> Classes-> Manufacturer.php   /* $results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT p.`id_manufacturer`, COUNT(DISTINCT p.`id_product`) as nb_products FROM `'._DB_PREFIX_.'product` p USE INDEX (product_manufacturer) '.Shop::addSqlAssociation('product', 'p').' LEFT JOIN `'._DB_PREFIX_.'manufacturer` as m ON (m.`id_manufacturer`= p.`id_manufacturer`) WHERE p.`id_manufacturer` != 0 AND product_shop.`visibility` NOT IN ("none") '.($active ? ' AND product_shop.`active` = 1 ' : '').' '.(Group::isFeatureActive() && $all_group ? '' : […]

Uncategorized

Talend Studio: Allocate Memory

Posted on

https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/ta-p/21642   Locate the .ini file inside the Talend installation folder.  With 8 GB of memory available on 64-bit system, the optimal settings can be: -vmargs -Xms1024m -Xmx4096m -XX:MaxPermSize=512m -Dfile.encoding=UTF-8 After this, you need to configure this same variables on the Advanced Settings of the Run Tab.

OpenBravo

Openbravo: Custom Query to find Invoice's Product Account

Posted on

SELECT c_invoice.documentno, c_invoiceline.linenetamt, --m_product_acct.m_product_id, --m_product_acct.ad_org_id, m_product_acct.p_expense_acct, c_elementvalue.name FROM c_invoice LEFT JOIN c_invoiceline ON c_invoice.c_invoice_id = c_invoiceline.c_invoice_id LEFT JOIN m_product_acct ON c_invoiceline.m_product_id = m_product_acct.m_product_id LEFT JOIN c_elementvalue ON c_elementvalue.c_elementvalue_id = m_product_acct.p_expense_acct WHERE dateinvoiced > '2017-01-01 00:00:00' AND dateinvoiced < '2017-12-31 00:00:00' AND issotrx = 'N' AND m_product_acct.c_acctschema_id = '092273C810444B4086ED18612E3F5833' ORDER BY --c_invoice.dateinvoiced ASC p_expense_acct asc

Uncategorized

Excel: Create Random 40 character string

Posted on

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))