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

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

Jasper Reports

JasperServer: Start Server on Boot

Posted on

This is an excellent post, which not only shows you how to solve the startup problem, but illustrate the use of startup scripts. http://community.jaspersoft.com/questions/541044/auto-start-boot   Key Points. To creste “service type” scripts you need to create the bash script on /etc/init.d/NAME_OF_SCRIPT To have this script run on server boot, you need to run update-rc.d NAME_OF_SCRIPT defaults […]

Prestashop

Prestashop: Add custom column on Product Page and Display it on product.tpl

Posted on

Steps: Create the table manually on the database. Declare the variable on /classes/product.php add the variable on /controllers/front/ProductController.php in the following matter. $product_tariff = $this->product->em_mg_tariff_code; $this->context->smarty->assign(‘tariff_code’, $product_tariff); 4. Add the field on your tpl on the following matter. {$tariff_code}    

Prestashop

Prestashop: No follow causing W3 non-compliance

Posted on

The problem I believe has to do with changes on standards. The w3 validator shoes as an error to have multiple rel=”example” tags inside an argument. So when it added its no follow arguments did the following things. Incorrect <a rel=”nofollow” href=”http://www.malla-supply.com/manufacturers-abb-96?p=2” rel=”next“>   Correct <a href=”http://www.malla-supply.com/manufacturers-abb-96?p=2” rel=”next nofollow“>   To solve this I removed the […]

Prestashop

Prestsahop: Edit Variables

Posted on

I wanted to change the Manufacturer Name variable, to eliminate the spaces and replace it with a dash. I tried doing this with PHP, but it was terrible to do it, as there were multiple places to change it, and it some places impossible. To do it via PHP Variable I had to change it […]