WebCitz Blog


WordPress 4.1 Update

For those of you who run your website on WordPress, the newest version 4.1 is available. Many features come with the newest update such as appearance updates, media updates, bug fixes and much more. Focus more on your blog posts and writing with a distraction-free feature. Turn on distraction-free writing mode in the settings and the surrounding menus will fade away as you type your post. WordPress 4.1 is translated into 44 languages and continues to translate more. PSD’s, (Photoshop documents), are now able to be uploaded to WordPress along with displayed error messages while uploading media. For more information about WordPress 4.1 go to WordPress Support.


USPS API Updates Coming September 7 & September 28, 2014

USPS is making two changes to its API this month on September 7th and September 28th which may impact your ecommerce storefronts. USPS is changing a few uncommon shipping services and country names on September 7th, 2014 and dropping support for their RateV3 API on September 28th, 2014. If you have an ecommerce website running Magento 1.5.1.0 or newer you are in the clear, but if your version is older you will need to consider installing the patch released by WebShopApps. If you are running an ecommerce website on an older version of some other ecommerce platform you will need to look into whether or not this USPS API update will impact your website prior to the dates mentioned. Please let us know if you need assistance!


Excel Tip / Trick: How to Check for and Remove a Trailing Comma

If you have ever worked with a spreadsheet that had lots of data – perhaps thousands or tens of thousands of rows – then you know the importance of formulas. We would like to share a handy formula with you that will check a cell for a trailing comma (or other character) and remove it. Please keep in mind that this formula actually checks to see if the last character is a comma – it will not just remove the last character in the cell no matter what – a crucial check for anyone that might not have such a problem on all cells.

=IF(RIGHT(A1,1)=”,”,LEFT(A1,LEN(A1)-1),A1)

In the above formula, you will notice that cell A1 is being checked to see if there is a comma at the last position. If a comma is found then it will remove the comma, but if another character is found it will leave it alone. To change it from a comma to another character, such as hyphen, simply change the formula to look like the following:

=IF(RIGHT(A1,1)=”-“,LEFT(A1,LEN(A1)-1),A1)

We hope this comes in handy for someone! Please remember to always keep backups of your files and data before making any changes!


Bing it On!

Try the Bing vs Google challenge at www.bingiton.com to see which of the two popular search engines you like more!


YubiKey NEO Works Great!

Testing out the YubiKey Neo that just arrived today – so far we are really liking it for secure computer logins and its integration with LastPass! We haven’t yet tried it for accessing Magento / Joomla / WordPress websites but we plan to test that out soon. http://www.yubico.com/


WordPress Caching Plugin Security Update

There is a new serious WordPress vulnerability in certain versions of two popular WordPress caching plugins, W3TC and WP Super Cache. The vulnerability allows remote PHP code to be executed locally on a server for anyone running either of the plugins. An attacker could then execute code on the infected server.


CloudFlare – WordPress Brute Force Attack

There is currently a widespread brute force attack being launched at a large number of WordPress blogs across the Internet. The attacks are using brute force against WordPress administrative portals, using the username “admin” and trying thousands of passwords. It appears a botnet is being used to launch the attack and more than tens of thousands of unique IP addresses have been recorded attempting to hack WordPress installs. If you have a username of “admin” for your blog or other CMS program, please update it to something less generic. It is also a good idea to ensure the passwords you are using are strong, such as the inclusion of special characters, mixed case and numbers.

Read More: http://blog.cloudflare.com/patching-the-internet-fixing-the-wordpress-br


Improve WordPress Speed with W3 Total Cache

WebCitz would like to recommend the W3 Total Cache plugin for WordPress 2.8+. The W3 Total Cache plugin works to improve your blog’s performance through browser, page, object and database caching as well as minification of your HTML, CSS and Javascript. Additionally, it provides content delivery network (CDN) support if that is of interest to you. The extension has been downloaded nearly 1,000,000 times according to WordPress.org! In our tests, we have found it to be an excellent source for increasing the speed of a WordPress website. If you choose to install this plugin, please be sure to take a full backup of your website and database – as you should with any significant modification to your website. Take a look at the extension here: WordPress Plugin Directory.


Creating CSS Sprites

Are you looking for a way to automatically create CSS sprites for your website? More than likely, you are looking to create a CSS sprite in order to cut down on HTTP requests on your website, improve page speed and satisfy the checklists of many popular website speed checking programs. Here is a great website for an Automatic CSS Sprite Generator.


PNG Compression & Image Optimization

WebCitz would like to share another website page speed optimization tip with its followers! If your website has PNG files used as graphics or background images, you may want to consider compressing those files in order to cut down on the amount of data your customers or visitors have to download before seeing your website. There isn’t an easy, default method for compressing PNG images within PhotoShop, but if you checkout this website called PunyPNG you will find a great tool that can quickly compress your PNG files with little to no loss of image quality. The free online service allows you to upload 15 images at a time!