PowerBI

PowerBI: SugarCRM Database Connection.

Posted on

It will only work if you add the following parameter: OldGuids=true And the query will work as follows. let Source = MySQL.Database("192.168.1.244", "crm_em", [ReturnSingleDatabase=true, OldGuids=true]), crm_em_opportunities = Source{[Schema="crm_em",Item="opportunities"]}[Data] in crm_em_opportunities

Life

Tim Ferriss: Rick Rubin Interview

Posted on

Rick is a well established music businessman, on this interview he shares his views on life and several interesting subjects. Recommended. Notes Lost 140 Pounds First steps into health with Phil Maffetone Recommended Stu Middleman (1000 Miles in 11 Days)  https://www.amazon.com/Slow-Burn-Faster-Exercising-Slower/dp/0062736744 Nutritionist Doctor David Heber UCLA  The only doctor that was able to make him […]

Prestashop

Prestashop: Remove Rendering Blocking CSS

Posted on

If you do a Page Speed test on Google, to make sure your site is loading fast enough and a slow load time is not penalizing your SEO, you can do this hetre: https://developers.google.com/speed/pagespeed/insights/ One tipical error you'll get is  Eliminate render-blocking JavaScript and CSS in above-the-fold content The solution I got was to remove […]

Life

Life: List of Mentors

Posted on

For the past couple of years ago, I've been enriched by reading or hearing key thought leaders, Below a list of the most important: Podcasts Joe Rogan Marc Maron Norm MacDonald James Altucher Howard Stern Eli the Computer Guy Lewis Holmes Larry King Rick Rubin Chase Jarvis Tim Ferriss Reid Hoffman - Masters of Scale […]

Mautic

Mautic: Clear Bounces not working correctly

Posted on

Some emails are parsed, while others are not. It depends on the format of the email. Here are some highlights: Files of interest: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce/DsnParser.php /app/bundles/EmailBundle/MonitoredEmail/Mailbox.php: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce.php The process as I understand it is the following: Step 1.  On Mailbox.php you define what emails are considered for un-subscription. The default criteria es UNSEEN, which the process […]

Prestashop

Prestashop Shortlinks

Posted on

Manufacturer Link on Product Page <a href="manufacturers-{$product->manufacturer_name|replace:'&':''|replace:' ':'-'|lower}-{$product->id_manufacturer}" style="color:blue; text-decoration:underline" ></a>     Manufacturer Link on Manufacturer List href="{$link->getmanufacturerLink($manufacturer.id_manufacturer, $manufacturer.link_rewrite)|escape:'html':'UTF-8'}"

Scrapy

Scrapy: Basic Commands

Posted on

Create Project scrapy startproject EXAMPLE /home/Scripts/scrapy/EXAMPLE   2 . Create Project inside the spiders folder with the format: example_spider.py   3.  Start testing with the console. scrapy shell 'http://quotes.toscrape.com'   And execute the XPath commands https://devhints.io/xpath   To run the spider execute the followng command on the folder. scrapy crawl <spider name> -o file.csv -t […]

PHP

PHP-FPM Performance Tweaks

Posted on

High performance Apache with mpm-event and PHP-FPM   Next, we edit config file for mpm-event at /etc/apache2/mod-available/mpm-event.conf : # event MPM # StartServers: initial number of server processes to start # MinSpareThreads: minimum number of worker threads which are kept spare # MaxSpareThreads: maximum number of worker threads which are kept spare # ThreadsPerChild: constant number of worker threads […]

Uncategorized

FreeSwitch & Flowroute to Receive and Send SMS

Posted on

See tutorial   Support For Flowroute SMS in FreeSWITCH   Got stuck, on apt-get install -y --force-yes freeswitch-video-deps-most with the following error: root@Asterisk:/home# apt-get install -y --force-yes freeswitch-video-deps-most Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation […]

Ubuntu

Apache http2 Activation on Ubuntu 14.04

Posted on

http/2 is apparently where the web is going on the next generation web data transfer. I'm interested on trying to configure it, to see if that gives me an edge on the SEO side. The process to activate it is particularly simple, but, I had some compatibility challenges. Let me elaborate: I'm hosting this particular […]