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

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 […]

Prestashop

Prestashop:Product Custom Field on Product-List.tpl

Posted on

This was kind of a tricky one, I created a custom field on the database (explained on another post) and was able to add it to the product.tpl by adding just {$imagurl}. This variable did not work on product-list.tpl, upon some research the correct way to add this is by adding:   $product.em_mg_imageurl

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 […]

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 […]

Ubuntu

Apache http2 Not working

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 […]

PostgreSQL

PgSQL: Replace Add break

Posted on

UPDATE m_product SET em_mg_longdescription = regexp_replace(em_mg_longdescription,’————‘,chr(13)) WHERE em_mg_manufacturer = 1000637 AND value = ‘IMI-YW356A01′     Some additional replace scripts   UPDATE m_product SET em_mg_longdescription = regexp_replace(em_mg_longdescription,'</li>’,chr(10)) WHERE em_mg_manufacturer = 1000637   UPDATE m_product SET em_mg_longdescription = replace(em_mg_longdescription,'<li>’,”) WHERE em_mg_manufacturer = 1000637   UPDATE m_product SET em_mg_longdescription = replace(em_mg_longdescription,'<ul>’,”) WHERE em_mg_manufacturer = 1000637   UPDATE […]

Mautic

Mautic: Understanding how it works

Posted on

Add your contacts. Create your segments and apply the filters you want. Update the segments using this query php /var/www/html/malla-group.com/mail/app/console mautic:segments:update Rebuild Campaign php /var/www/html/malla-group.com/mail/app/console mautic:campaigns:rebuild Trigger Campaign —> Note that once you trigger the campaign the email will appear as Sent altough it may not have been sent yet. The email will be stock […]

Mautic

Mautic: Console Commands

Posted on

To execute… php /var/www/html/—PATHTOSERVER—/mail/app/console mautic:campaigns:rebuild mautic:campaigns:trigger – mautic:campaign:trigger – mautic:trigger:campaigns – mautic:trigger:campaign 2) mautic:campaigns:rebuild – mautic:update:campaigns – mautic:rebuild:campaigns – mautic:campaigns:update 3) mautic:iplookup:download – mautic:fetch:ipdata – mautic:ipdata:fetch – mautic:ipdata:update – mautic:update:ipdata 4) mautic:emails:send – mautic:send:emails – mautic:process:email – mautic:process:emails – mautic:email:process – mautic:emails:process – mautic:send:email 5) mautic:email:fetch – mautic:fetch:email – mautic:email:fetch – mautic:fetch:mail – mautic:check:email – […]

Mautic

Mautic: Configuration

Posted on

https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful   Add Mailto to the List-Unsubscribe Header: Go to -> /app/bundles/EmailBundle/Helper/MailHelper.php: Aproximately on line 1484 /** * Generate and insert List-Unsubscribe header. */ private function addUnsubscribeHeader() { if (isset($this->idHash)) { $unsubscribeLink = $this->factory->getRouter()->generate(‘mautic_email_unsubscribe’, [‘idHash’ => $this->idHash], true); $this->headers[‘List-Unsubscribe’] = “<unsubscribe@malla-group.com>,<$unsubscribeLink>”; } }

Synology

NAS: Reload Cron

Posted on

On the Synology OS (…some type of linux…) after editing the crontab you need to reload it otherwise no changes are made. /usr/syno/sbin/synoservicectl –reload crond