<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>Pickled Shark</title>
	
	<link>http://www.pickledshark.com</link>
	<description>Web Development, SEO and Internet Entrepreneurship</description>
	<lastBuildDate>Mon, 12 Jul 2010 10:59:50 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/pickledshark" /><feedburner:info uri="pickledshark" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><feedburner:emailServiceId>pickledshark</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>What is a Thin Affiliate Site?</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/1M5wYyAW1K0/</link>
		<comments>http://www.pickledshark.com/thin-affiliate-site/#comments</comments>
		<pubDate>Sat, 10 Jul 2010 12:19:19 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Search Engine Optimisation]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=148</guid>
		<description><![CDATA[In their ever continuing efforts to fight spam, Google coined the phrase thin affiliate to describe a site offering only affiliate links and no value to a user. Being labeled a thin affiliate site will mean very little to no traffic from Google, but what criteria does Google use to filter out these sites, how do they do it and how can you prevent this happening to you?]]></description>
			<content:encoded><![CDATA[<p>Many people still hold the mistaken belief that making money on the internet is easy, if you know the tricks. They believe that it is possible to make a fortune without considerable effort, time or experience. Millions of people start websites in this frame of mind and 99.9% of these people fail.</p>
<div style="float: right; display: inline; text-align: center;"><img src="http://farm2.static.flickr.com/1325/1449868160_d560bbfeac_m.jpg" alt="The duckies invade Google" class="alignright size-full" /><br /><small><a href="http://creativecommons.org/licenses/by/2.0/" title="Attribution License" target="_blank" rel="nofollow"><img src="http://www.pickledshark.com/wp-content/plugins/photo-dropper/images/cc.png" alt="Creative Commons License" border="0" width="16" height="16" align="absmiddle" /></a> photo credit: <a href="http://www.flickr.com/photos/99527366@N00/1449868160/" title="Yodel Anecdotal" target="_blank" rel="nofollow">Yodel Anecdotal</a></small></div>
<p>It is hard to say quite where these beliefs come from but it is fair to say that many people are exploiting this attitude in order to make a lot of money themselves.</p>
<p>There are so many training courses, auto website generators, traffic boosters, SEO tools, Auto Twitter tools etc. exploiting this attitude that it is hard to keep track. Generally their sales page promises instant results, gives examples of successful users and shows you how little time and effort it takes to execute.</p>
<p>Unfortunately these tools are almost always trying to outsmart the one company that you do not want to mess with &#8211; Google. The main aim is to try and exploit the free traffic you would get from being listed high in Google for a popular keyword.</p>
<p>No matter how many tools you try and how clever you think these ideas are, you will never outsmart Google in the long run. To avoid sending you to auto-generated websites, websites filled with advert or even websites with malicious intent Google use some of the most sophisticated technology in existence.</p>
<p><strong>Note</strong> &#8211; at this point it is worth mentioning that some people operate their online business this way, knowing that they will not overcome Google permanently. They work on a scattergun approach and make money while they can constantly changing, throwing away websites and trying new methods. This method may well be successful but I have no experience in it and don&#8217;t believe it is worth the effort. I also don&#8217;t believe in tricking users is in any way worth monetary compensation.</p>
<p>Google uses many methods to fight spam in the search engine results. Naturally, they do not want to recommend bad websites and your trust is fundamental to their success &#8211; if you find bad websites at Google you will use another search engine. In this article we explore the &#8220;Thin Affiliate&#8221; label Google has defined, how it is determined, the consequences of being one and how to recover from it if you are.</p>
<h2>So, what is a &#8220;Thin Affiliate&#8221; and how does it relate to tricking Google?</h2>
<p>Essentially Google does not want to send people to sites that do not offer valuable content. &#8220;Thin Affiliate&#8221; is a label applied when Google thinks you have created a site that is completely focused on affiliate links (PPC ads, paid adverts, links to other merchants etc.) and doesn&#8217;t offer anything else of value.</p>
<p>A good example of this would be a script that creates a website from eBay listings. It is focused on a certain group of products (e.g. Car Exhausts) and provides several category pages (e.g. Exhausts for different models). Each page lists the current eBay auction results with links, earning the website owner money for every click and/or sale.</p>
<p>Google doesn&#8217;t like this because the website is not offering anything new to the user. This model can be easily replicated and if they don&#8217;t take action, Googles search engine results would be littered with this type of website, pushing genuine Car Exhaust sellers down the listings.</p>
<p>Another example would be a blog that reviews laptops. The reviews are automatically generated from a mixture of Amazon reviews, other merchant sites and related information. The result is a jumbled mess and the content may even be &#8220;spun&#8221; (a process of replacing words automatically in order to create unique content) which makes the content unreadable. Not only is the site not offering anything new but it is not of benefit to the visitor in any way.</p>
<p>Unfortunately, the idea of a &#8220;Thin Affiliate&#8221; site is not always so black and white. You might create a website with a few unique articles and pages with links to eBay the same as our above example. Does the unique content mean Google will not penalise your site? What is the line that we must not cross?</p>
<h2>How is your site determined to be Thin Affiliate?</h2>
<p>There are many automatic methods that Google employ to penalise sites. If you have duplicate content, poor quality content, an unresponsive site, too much advertising, you are using cloaking etc. then it is likely that Google will recognise this programatically (i.e. without any human intervention) and you will be penalised automatically.</p>
<p>Being a Thin Affiliate is somewhat open to interpretation and not so easy to recognise using automatic methods. However, you could be penalised automatically for reasons like the following:</p>
<ul>
<li>No Content &#8211; if you have nothing at all on your site except adverts you will be penalised</li>
<li>Duplicate or poor content &#8211; It is possible to tell the quality of your content automatically and Google are very likely to use this technology. Content spinning, duplicate content and badly written content will get you penalised</li>
<li>Turnkey Solutions &#8211; Using a script that is known to generate thin affiliate sites can get you an automatic penalty. These scripts have a &#8220;footprint&#8221; i.e. something that gives away your site is using a particular script (e.g. html markup, particular file names/locations etc.)</li>
<li>User Behaviour &#8211; it is possible that Google monitors its users behaviour to see how they react to a site. e.g. if the majority of users click back to Google, then it is safe to assume the site doesn&#8217;t offer anything of value for that keyword</li>
</ul>
<p>While these types of automatic methods are no doubt in place, it appears that a lot of manual reviewing is being done by Google in this area. That is an actual person is taking a look at your site and deciding wether to cut off the traffic from Google or not. This is extremely important to remember &#8211; it is easy to circumvent filters and stay within a boundary, but a manual reviewer can always see your site for what it is.</p>
<p>Most likely your site will be flagged for review based on automatic detection, like the above. For example, if a lot of users are returning to Google straight after visiting your site then your site is added to a review list. Someone will then manually visit your site and make a decision on its value &#8211; is it a Thin Affiliate site or does it actually offer something useful?</p>
<p>It is possible that your site can escape a manual review for a long time or possibly even indefinitely, especially if your site is well established. However it can be reviewed at any time for many reasons &#8211; a competitor reporting you, visitors reporting you, change in Googles algorithm etc. so don&#8217;t assume it will not happen to you.</p>
<p>With all this considered, determining wether your site is Thin Affiliate or not becomes quite simple. If you were to review your site without bias, would you consider it useful?</p>
<h2>How can I avoid being labelled a Thin Affiliate?</h2>
<p>Back in 2007 Shoemoney posted a video with essentially the message <a href="http://www.shoemoney.com/2007/10/06/dont-make-google-look-stupid-period/">don&#8217;t make google look stupid</a>. The point is simple &#8211; Google is bigger than you, smarter than you, has more resources than you and will catch you out if you try and trick them. Don&#8217;t make them look stupid by putting useless sites in their index. According to Jeremy, Google use this video internally to educate their staff and help them understand more about this issue.</p>
<p>The only true way to avoid being labelled a Thin Affiliate is to make your site good. Add great, compelling, unique content. Provide a useful service. Offer reviews, advice, tips or even just a good way to compare products. Whatever you do, make sure its useful to visitors and you are proud to put your name to it.</p>
<h2>What penalties can I get?</h2>
<p>Typically you will receive a -50 penalty, which means you will be listed 50 places lower than you would have done previously for search terms. You may still get traffic from extremely unique keywords but expect your traffic from Google virtually disappear.</p>
<p>From my experience you won&#8217;t get banned outright and remember that other search engines behave differently &#8211; you may still get good traffic from Yahoo and Bing especially. Google will never contact you to tell you whats happened, nor will they give you any information whatsoever if you ask them. They keep all of this 100% secret to protect their methods so we can only maker educated guesses on what has happened.</p>
<p>My conclusion is that Google will not remove your site completely from the search engines because it is too clear a sign that you have done something wrong. By issuing the -50 penalty, many people will just assume that they have not got enough links or popularity and will continue to try and promote their site. This is my speculation, but I believe Google are happy for people to waste time like this instead of working on another way to get bad sites to the top of the search listings.</p>
<p>A complete ban is not likely for a Thin Affiliate site &#8211; this is usually reserved for Black Hat techniques (e.g. cloaking, blog farms etc.) and sites that are frequently unavailable.</p>
<h2>How do I recover from a penalty?</h2>
<p>It is the same as with any penalty from Google &#8211; fix the problem and apply to have your site reconsidered via <a href="http://www.google.com/webmaster/">Google Webmaster Tools</a>.</p>
<p>Essentially if you have received this penalty, you need to add value to your site. Google deals with a lot of affiliate sites and as such they are not high in their priority if you are contesting a penalty &#8211; you will likely get ignored. Therefore you need to overcompensate and turn your site into something that they must pay attention to. Getting attention and links from other high authority sites will help, although it may still take a couple of months for Google to get round to reviewing your changes.</p>
<p>Some people may consider it a write off and start again with a new site and domain. This might be a better option, depending on how much time and money you put into the original site.</p>
<h2>The Conclusion</h2>
<p>So we have looked at what Google defines as a Thin Affiliate site, how they spot it, how to avoid it and how to recover from it. Essentially I would recommend your philosophy is to create a great website. Initially don&#8217;t focus too much on what Google wants, conversion rates, the best affiliate networks etc. &#8211; simply create a great website that people want to visit, with great content and some innovative ideas. Create a website you are proud of and that you are happy to tell your friends about.</p>
<p>Do this and you will never have to worry about being a Thin Affiliate.</p>
<p><strong>What do you think?</strong></p>
<p>Have you any experience with being labelled a Thin Affiliate? Want some advice on your site? Have something you wish to say?</p>
<h2 style="text-align: center;"><span style="color: #ff0000;">If so, comment below!</span></h2>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/1M5wYyAW1K0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/thin-affiliate-site/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/thin-affiliate-site/</feedburner:origLink></item>
		<item>
		<title>New Section – Reviews on Training Courses, Books and Resources</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/uOL9llNhcLQ/</link>
		<comments>http://www.pickledshark.com/section-reviews-training-courses-books-resources/#comments</comments>
		<pubDate>Thu, 13 May 2010 10:59:27 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Training, Books and Resources]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=133</guid>
		<description><![CDATA[A quick announcement about our new section at Pickledshark - we will be reviewing training materials, books and other resources. Read on to find out more and what we will be taking a look at first.]]></description>
			<content:encoded><![CDATA[<p>We are starting a new section here at Pickled Shark to place training course reviews, book summaries and anything else related to learning. Our aim is to give you honest, useful and indendepent reviews on the best training courses, books, conferences and learning material.</p>
<p>Our first two reviews will be for the following books from <a href="http://www.packtpub.com/">Packt Publishing</a>.</p>
<p><a href="/go/packt-magento-sales-tactics/"><img src="http://www.pickledshark.com/wp-content/uploads/2010/05/Mag1.3_STC-243x300.jpg" alt="Magento Sales Tactics Cookbook" title="Magento Sales Tactics Cookbook" width="243" height="300" class="alignleft size-medium wp-image-136" /></a></p>
<h2><a href="/go/packt-wordpress-flash-cookbook/">Magento 1.3 Sales Tactics Cookbook</a></h2>
<p>A look at various techniques to increase sales when using the open souce eCommerce system Magento. Includes SEO techniques, improving customer experience, cross promotion and selling internationally.</p>
<p>From Packt: &#8220;Build a professional Magento sales web site, with the help of easy-to-follow steps and ample screenshots, to solve real-world business needs and requirements. Develop your web site by using your creativity and exploiting the sales techniques that suit your needs. # Provide visitors with attractive and innovative features to make your site sell.&#8221;</p>
<p><a href="/go/packt-magento-sales-tactics/">View Magento 1.3 Sales Tactics Cookbook on Packt Publishing</a></p>
<p><br clear="all" /></p>
<p><a href="/go/packt-wordpress-flash-cookbook/"><img src="http://www.pickledshark.com/wp-content/uploads/2010/05/WP_n_Flash_10x-243x300.jpg" alt="WordPress and Flash 10x Cookbook" title="WordPress and Flash 10x Cookbook" width="243" height="300" class="alignleft size-medium wp-image-141" /></a></p>
<h2><a href="/go/packt-wordpress-flash-cookbook/">WordPress and Flash 10x Cookbook</a></h2>
<p>Exploring the use of WordPress along with Flash to create rich blogs and websites. This book, amongst other things, covers the technical aspects of embedding flash in WordPress, essential plugins, video bloggin, using audio and creating animations, buttons etc. in Flash.</p>
<p>From Packt: &#8220;Over 50 simple but incredibly effective recipes to take control of dynamic Flash content in WordPress. Learn how to make your WordPress blog or website stand out with Flash. Embed, encode, and distribute your video content in your WordPress site or blog. Build your own .swf files using various plugins. Develop your own Flash audio player using audio and podcasting plugins.&#8221;</p>
<p><a href="/go/packt-wordpress-flash-cookbook/">View Magento 1.3 Sales Tactics Cookbook on Packt Publishing</a></p>
<p><br clear="all" /></p>
<p>If you have any requests or suggestions for reviews of books, online courses, seminars, conferences etc. simply <a href="/contact-us/">get in touch here</a> with the details.</p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/uOL9llNhcLQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/section-reviews-training-courses-books-resources/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/section-reviews-training-courses-books-resources/</feedburner:origLink></item>
		<item>
		<title>What is Multivariate Testing?</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/Ut9d989d1aw/</link>
		<comments>http://www.pickledshark.com/multivariate-testing/#comments</comments>
		<pubDate>Mon, 03 May 2010 11:15:31 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[eCommerce]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=125</guid>
		<description><![CDATA[To get the most from your website you need to test, tweak and optimize. Traditionally a common way of finding out about changes to your website was to split test - basically serve two different versions of your page and compare the results from each. In this article we take a look at a more in depth method; multivariate testing. Read on to find out how you can implement and use this method of website optmization to improve conversions on your website.]]></description>
			<content:encoded><![CDATA[<div style="float: right; display: inline; text-align: center;"><img class="alignright size-full" src="http://farm1.static.flickr.com/122/277341190_3f098a08a4_m.jpg" alt="Code washing" width="360" height="288" /><br />
<small ><a title="Attribution-NonCommercial-NoDerivs License" rel="nofollow" href="http://creativecommons.org/licenses/by-nc-nd/2.0/" target="_blank"><img style="font-size: 24.75px; line-height: 42.75px;" src="http://www.pickledshark.com/wp-content/plugins/photo-dropper/images/cc.png" border="0" alt="Creative Commons License" width="24" height="24" align="absmiddle" /></a> photo credit: <a title="Ezu" rel="nofollow" href="http://www.flickr.com/photos/49502986585@N01/277341190/" target="_blank">Ezu</a></small></div>
<p><em><strong>This is a guest post from Craig Smith of Trinity Insight.</strong></em></p>
<p>Any internet marketer knows the importance of &#8220;optimization&#8221;. Simply stated, optimization is the effort to improve previous performance.</p>
<p>On the web, we do this via online testing and the monitoring of key metrics that associate to business goals. In the past, businesses were confined to conducting &#8220;split tests&#8221;, otherwise testing version &#8220;A&#8221; versus version &#8220;B&#8221;. These tests, albeit effective, were difficult to scale in measuring multiple elements on a page.</p>
<p>Enter multivariate testing; a new form of testing based upon technologies that allow for the measurement of multiple aspects of a webpage.</p>
<p>Multivariate testing is the process of creating varied &#8220;recipes&#8221; of web content, that are served to your visitors in order to decipher intelligence into which mix of messaging and imagery works best. In the past, this type of solution was only available to the very large enterprises who had substantial dollars to spend on additions to their content management systems. As eCommerce and internet marketing has progressed however, so has the availability of tools that execute these conversion improvement functions.</p>
<p>Simply put, there is no reason why your organization or business should not be improving your conversion rates through online optimization.</p>
<p><strong>Why you need to execute multivariate testing</strong></p>
<p>Testing is a fundamental aspect of direct marketing. Ask any cataloger over the last 100 years. They have been testing covers, layouts, imagery within the print medium as long as the market has been active.</p>
<p>For a print business, the goal is clear. Test different variations of catalogs in order to isolate the best performing version for upcoming campaigns. Seems pretty basic and simple right? Well, it is, but 90% of businesses that I talk to on a daily basis are not involved in testing in the online medium, even within the available tools today.</p>
<p>Think of your website as a brochure that has 2 seconds to peak someone&#8217;s interest. That is the exact environment that exists today. With homepage and key landing page bounce rates exceeding 40% many times, the lost opportunity with not testing is substantial.</p>
<p>Be it your unique value proposition on your homepage, messaging that relates to your key services or products, or just the shape and size of a button that you want to test, multivariate testing will help answer questions about your users and web content with hard data not gut feelings.</p>
<p><strong>How it works</strong></p>
<p>Most multivariate testing solutions are based upon Javascript technology and the &#8220;injection&#8221; and &#8220;swapping&#8221; of content within a page. The most widely used multivariate testing platform is Google Website Optimizer and this tool is also based upon Javascript.</p>
<p>Basically, each area of your webpage that you want to test is encapsulated with Javascript within the test set up process. Alternatives to each location are defined within the test set up and you set goal pages to accurately track which version performed best.</p>
<p>As users come to your site, they get served different versions. The version that they received is populated within their cookies, this way on subsequent visits they receive the same version.</p>
<p>A variety of metrics can be utilized to gauge performance with the most popular being conversion. Other metrics that can be leveraged are time on site, pages per visit, or the aforementioned bounce rate metric.</p>
<p><strong>Challenges with multivariate testing</strong></p>
<p>As in any technology solution, there are always challenges. With multivariate testing, challenges come into play with content management systems and eCommerce platforms. Because these systems are based upon templates and the use of databases to render content, some additional work needs to be done to ensure that tests function properly.</p>
<p>Also serving as a hurdle can be the &#8220;tagging&#8221; process that needs to be done regarding the site elements on a page. In situations which software is licensed and access to the source code is not readily available, the tagging process needs to be done by a software vendor and can equal headaches and expensive per hour fees for remedial steps.</p>
<p>Regardless of these challenges, multivariate testing is something that is a must if you operate a web-based or eCommerce business. To not test different types of layouts, promotions, and calls to action is flying blind and leaving dollars on the table. Complacency is the enemy of efficiency and don&#8217;t be complacent with the conversion rate of your website. Start multivariate testing today.</p>
<p><strong>About the author</strong></p>
<p>Craig Smith is the CEO of Trinity Insight &#8211; a leading <a href="http://www.trinityinsight.com/">eCommerce consulting</a> company that specializes in <a href="http://www.trinityinsight.com/home/multivariate-testing">multivariate testing</a>.</p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/Ut9d989d1aw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/multivariate-testing/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/multivariate-testing/</feedburner:origLink></item>
		<item>
		<title>Why Opportunity is Stealing our Time, Focus and Energy</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/JoG1jOni-Tk/</link>
		<comments>http://www.pickledshark.com/opportunity-stealing-time-focus-energy/#comments</comments>
		<pubDate>Mon, 12 Apr 2010 11:10:43 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Productivity and Motivation]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=83</guid>
		<description><![CDATA[In every area of our life we have opportunity. Every day a new tool is launched that could change our leaves, a new technology that can make us happier or a new skill that can increase our earnings. In this article we look at why people are overwhelmed by opportunity, hide behind it and most importantly how we can deal with this.]]></description>
			<content:encoded><![CDATA[<div style="float: right; display: inline; text-align: center;"><img class="alignright size-full" src="http://farm1.static.flickr.com/39/90125879_d7179d6173_m.jpg" alt="Toad" /><br />
<small><a title="Attribution-NonCommercial License" rel="nofollow" href="http://creativecommons.org/licenses/by-nc/2.0/" target="_blank"><img src="http://www.pickledshark.com/wp-content/plugins/photo-dropper/images/cc.png" border="0" alt="Creative Commons License" width="16" height="16" align="absmiddle" /></a> photo credit: <a title="Thomas Hawk" rel="nofollow" href="http://www.flickr.com/photos/51035555243@N01/90125879/" target="_blank">Thomas Hawk</a></small></div>
<p>Nobody can argue against the amount of opportunity we have in this day and age. Particularly in our industry, the internet, there are so many potential lives we could lead that we can literally be anybody we want to be.</p>
<p>There lies the problem. Who do you want to be?</p>
<p>Would you like to be a famous and respected blogger? A drop shipper, selling the latest products from China all around the world? A PPC expert making money from all the affiliate networks? Or perhaps you would like to dominate the latest porn niche?</p>
<p>As I will explore in this article, I don&#8217;t believe it is what you choose that matters &#8211; more the fact that you do choose it.</p>
<p><strong>Why can choice be bad?</strong></p>
<p>In generations passed choices were limited. If you had access to a guitar, a grand piano or a football and some friends the chances are you would spend a lot of time doing that. To pass the boredom. You would be more likely to master it, to stick with it and make something useful of it.</p>
<p>In our generation, you can have a guitar if you want. Next week you can get access to a grand piano. At the weekend you can play a game of football, see the latest film, play the latest video game and so on. Do you ever get bored anymore? Your time and attention is split between so many things, how could we expect to master one of them?</p>
<p>Despite this, it does happen and it just requires discipline. In this instance you need to pick your field, pick it early and stick with it.</p>
<p><strong>Are there any quick wins anymore?</strong></p>
<p>In my opinion, there have never been any quick wins. I believe in luck&#8230; and let me explain what I mean by that.</p>
<p>I am in no way disregarding that it requires talent to achieve something good. It is essential. What I am saying is that many people have the talent it takes to start a software company, become a professional athlete or run a successful website. I believe there are many brilliant people who aren&#8217;t achieving what they are capable of and some that do.</p>
<p>The difference is timing or as I prefer, the luck factor.</p>
<p>In the excellent book <a href="/go/outliers/">outliers by Malcom Gladwell</a>, this point is made very well and includes great examples such as Bill Gates (who was lucky enough to have programming access on a computer at the right time &#8211; just before the home computer revolution took off) and the hockey players who have statistically more chance of making professional if they are born in January (because try out cut off dates meaning they are older and stronger than players born in December).</p>
<p>Luck is not all you need, but it is a big factor.</p>
<p>How do you get lucky? Become the best you can be in your area. Don&#8217;t take on too much and when that opportunity comes along you will be ready.</p>
<p><strong>How does this relate to internet businesses?</strong></p>
<p>In our industry, there are an unlimited amount of opportunities. Every week there is a new tool, a new ebook, a new technique, a new script or a new research method that can make us millions. All of these opportunities have something in common &#8211; they give you the impression that making money is easy. Just follow these 5 simple steps and you could earn $1000 a day.</p>
<p>Lawyers call this technique &#8220;papering&#8221;. A typical web professional has so much information, potential opportunities and even blogs to read telling you about all this stuff that they have less time to actually do something. Lawyers will do this to each other during cases so that they have to spend more time (and money) on sorting out the latest letters, procedures etc.</p>
<p>Don&#8217;t let anyone steal your focus or steal your time.</p>
<p>As any web professional worth their salt (and not actively trying to sell you something) will tell you that you have to work hard to achieve success. I would like to add to this and say you need to work honestly.</p>
<p>Yes there are many of the blackhat crowd making a living by creating intriguing Facebook groups that require you to sign up to something or gaming the search engines with the latest trick, but it is not a predictable or stable path to follow. If your going down that path, your reading at the wrong place.</p>
<p>Don&#8217;t be tempted by the latest tricks. Don&#8217;t let anyone distract your focus. Have a great game plan, have 100% confidence in your plan and have 100% stubborn focus to see that plan through.</p>
<p><strong>Are you a jack of all trades?</strong></p>
<p>&#8230; and a master of none? If your skills are in marketing, why do you need to know how to code HTML? Focus on what is important and what you are good at. Do this throughout your life and accept the things that you just don&#8217;t have the time to fit into your life.</p>
<p>Committing to doing something is actually a very expensive thing to do. If you start down the path of learning a new language you are giving yourself less time to do other things &#8211; see your family, play football or finish that latest project. Analyse your life constantly and don&#8217;t take on any new hobbies or commitments unless you are 100% sure it will benefit you and fit in your life.</p>
<p>The most successful people are absolute masters of one thing, and know little about other things. As Seth Godin points out in his excellent book &#8220;<a href="http://sethgodin.typepad.com/all_marketers_are_liars/">All Marketers are Liars</a>&#8220;, a frog can catch a living fly but not a dead one. It is an absolute master at catching flies with their tongue as that is all they are made for. Be the frog; find your skill and make it better.</p>
<p><strong>If you are doing something, do it properly</strong></p>
<p>My dad always said &#8220;if your going to do a job, do it properly&#8221; and I always try to remember this in my life. If you are going to start learning a new language make sure you do it to the best of your abilities. If you can&#8217;t, just don&#8217;t do it yet.</p>
<p>This applies to all areas of our life and business. Don&#8217;t start a new website unless your sure you can do it the best you can. I would make a guess that 80% of the internet is half finished projects, or projects that don&#8217;t get the time they need. Imagine what we could do with all that half effort and add it up to a full effort.</p>
<p><strong>Do less, do more</strong></p>
<p>Try doing less. Stop trying to read a book every week. Have less friends. Work on less projects.</p>
<p>What will happen? You will feel like you got more done. The books you read, you will read properly and take value from. You will have better friends and you will be a better friend. The projects you do work on will be more succesful.</p>
<p><strong>Was it worth it? Is it worth it?</strong></p>
<p>Are you getting anything from the book your reading? If not, drop it. Are you losing weight at the gym? Try a class instead. Do you check your emails every day? Try every other day.</p>
<p>Don&#8217;t take anything for granted in your life. There are many ways were we can cut down on the things we are doing, the time we are spending and the effort that we are wasting. Take some inspiration from places like <a href="http://lifehacker.com/">Life Hacker</a> and optimise your life.</p>
<p><strong>How else can you stay focused and own your time?</strong></p>
<ul>
<li> Drop wrong opportunities quickly &#8211; don&#8217;t throw good time after bad</li>
<li> Plan your projects, set goals and stick to them</li>
<li> Review your goals and processes regularly (I recommend every week) &#8211; are you on track? Can you put any projects on hold</li>
<li>&#8220;How do you eat an elephant&#8221; &#8211; one piece at a time. Keep faith in the big tasks by splitting them into manageable chunks</li>
<li>Be aware of priority &#8211; don&#8217;t let anything jump the queue unless it benefits you</li>
<li>For those things you want to do, but can&#8217;t right now &#8211; put them on a list. Keep them safe and review often. But don&#8217;t do them until you can give them 100%</li>
<li>Put all projects on hold, move them off main lists</li>
</ul>
<p><span style="color: #339966;">Thank you for reading &#8211; I hope this inspires you to achieve more and make more fantastic contributions to this world. If you have any other tips, comments or questions <strong>comment below!</strong></span></p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/JoG1jOni-Tk" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/opportunity-stealing-time-focus-energy/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/opportunity-stealing-time-focus-energy/</feedburner:origLink></item>
		<item>
		<title>Backing up on DVDs and CDs? Think Again</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/mGiZDK-7Jxw/</link>
		<comments>http://www.pickledshark.com/backing-dvds-cds/#comments</comments>
		<pubDate>Thu, 18 Mar 2010 11:19:42 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Software]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=82</guid>
		<description><![CDATA[Backing up your files can never be spoken about enough. There is nothing worse than losing everything, or even something, important. Find out why DVDs and CDs are no good for backing up and read an introduction to other more reliable methods.]]></description>
			<content:encoded><![CDATA[<div style="float: right; display: inline; text-align: center;"><img class="alignright size-full" src="http://farm3.static.flickr.com/2255/2355186770_0cd55cd414_m.jpg" alt="Backups" /><br />
<small><a title="Attribution License" rel="nofollow" href="http://creativecommons.org/licenses/by/2.0/" target="_blank"><img src="http://www.pickledshark.com/wp-content/plugins/photo-dropper/images/cc.png" border="0" alt="Creative Commons License" width="16" height="16" align="absmiddle" /></a> photo credit: <a title="Tony Austin" rel="nofollow" href="http://www.flickr.com/photos/27948364@N00/2355186770/" target="_blank">Tony Austin</a></small></div>
<p>You are an extremely lucky person if you have never lost anything from your computer. As every day goes by more and more of our lives are held on hardware that at any time could fail without notice; photographs, movies, journals, business records, website files, databases, designs, contacts, emails and more.</p>
<p>This might sound like the introduction to a new backup solution but the truth is this is more like a self motivating post. Despite losing photographs, work and many gigabytes of MP3 I still don&#8217;t have a reliable backup solution. It is forever on my todo list and never completed, as there is always something better to be doing.</p>
<p>Until my inevitable post describing the loss of my entire digital life, I just wanted to talk quickly about using optical discs (DVDs and CDs especially) for backup; <strong>don&#8217;t do it</strong>.</p>
<p>Most likely you are using more sophisticated methods such as an external hard drive, but if you have any old backups on disc, get them somewhere safe. Why? Simply because optical discs degrade over time.</p>
<p>The lifespan of a DVDr could be anything from 2 years to 30 years depending on the quality, storage, temperature and exposure to light. As anyone who has burned discs before will know, even discs in the same spindle are of varying quality; some work and some don&#8217;t.</p>
<p>Without the need for research, debate, analysis or testing it is safe to say you shouldn&#8217;t use CDs or DVDs for backup if you have anything but short term intentions. With the amount of alternatives available, it is best just to get out of this habit and look at something else.</p>
<p>A quick overview of alternative methods:</p>
<ul>
<li><strong>Cloud Storage</strong> &#8211; store your data online at places like <a href="http://jeremy.zawodny.com/blog/archives/007641.html">Amazon S3</a> or <a href="/go/dreamhost/">Dreamhost Files Forever</a> (my recommendation &#8211; let someone else worry about the hardware).</li>
<li><a href="http://www.pickledshark.com/go/getdropbox/"><strong>Dropbox</strong></a> &#8211; Great automatic solution, requires no maintenance, but limited in size</li>
<li><strong>External Hard Drives</strong> &#8211; Applications like Time Machine on the Mac make this easy, but still could fail.</li>
<li><a href="http://www1.crashplan.com/landing/index.html"><strong>Crashplan</strong></a> &#8211; Looked like a good solution. Similar to dropbox but with more space and scope. When I tried it took too long to upload and drained bandwidth.</li>
</ul>
<p>Whatever backup system you use make sure it is feasible, automatic and reliable. Most importantly, just make sure you have one! (note to self&#8230;)</p>
<p style="text-align: center;"><strong><br />
</strong></p>
<p style="text-align: center;"><strong><span style="color: #ff0000;">Suggestions, criticisms or opinions? Get involved and comment below!</span></strong></p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/mGiZDK-7Jxw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/backing-dvds-cds/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/backing-dvds-cds/</feedburner:origLink></item>
		<item>
		<title>Online Banking Usability and The Dreaded Card Reader</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/-rLCgk7iK3k/</link>
		<comments>http://www.pickledshark.com/online-banking-usability-dreaded-card-reader/#comments</comments>
		<pubDate>Fri, 19 Feb 2010 13:24:55 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[User Interface and Usability]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=99</guid>
		<description><![CDATA[Online banking has some catching up to do. While certainly one of the oft quoted reasons for using the internet, banking online has so much more potential. The field has taken a blow recently, at least in the UK, with the introduction of "card readers" passing security problems onto the user and creating a barrier. Read on to find out more about why the card reader is a mistake, good examples of online banking and how improvements could be made.]]></description>
			<content:encoded><![CDATA[<p><img class="alignright size-medium wp-image-104" title="Online Banking" src="http://www.pickledshark.com/wp-content/uploads/2010/02/piggy_bank_online_banking-300x264.jpg" alt="" width="300" height="264" /><br />
When a little card reader called PINSentry arrived for one of my accounts with Barclays, I was initially a bit curious of the technology but more importantly I was frustrated. Could I use my bank on the move? What if I am in Starbucks and I forget it? Where am I going to keep it on my desk? (yes, this is a concern for me!)</p>
<p>For those of you that are not aware, these card readers look like a calculator with a slot for your card at the top. You enter your card, enter your pin, enter a code from the website and receive a code to type back into the website.</p>
<p>A number of years ago, while working for an upcoming warehouse software company, I came across a somewhat paranoid but fascinating solution one of our clients used to protect their network. We often had to access databases remotely and in this case we did so via a VPN (a VPN is basically connecting to a private network over the internet).</p>
<p>The added twist was that we had to enter an extra code. This code was shown on a little keychain dongle that had been sent us &#8211; while I don&#8217;t remember the name or details, the dongle gave us the password and it was different every time. We had excited conversations between ourselves on how this thing worked and how the algorithm could possibly be cracked. Soon enough we realised that the whole idea was a huge burden &#8211; many people needed to access the VPN from many different places and we only had one.</p>
<p>We toyed with the idea of setting up a webcam and broadcasting the readout via a webpage, undermining the security. Fortunately the client scrapped this security.</p>
<p>I write this because this is exactly the frustration we all face with bank card readers. Currenty I am in Asia (<a href="http://www.longjourney.co.uk/">Koh Chang, Thailand to be precise</a>) and I am carrying no less than three of these readers, one of which I had to have shipped from the UK after they replaced it.</p>
<div id="attachment_100" class="wp-caption aligncenter" style="width: 458px"><img class="size-full wp-image-100 align-center" title="barclays pinsentry card reader" src="http://www.pickledshark.com/wp-content/uploads/2010/02/barclays_pinsentry_card_reader.jpg" alt="" width="448" height="336" /><p class="wp-caption-text">The Barclays PINSentry Card Reader. I H8 U.</p></div>
<p>Why else are these readers a burden?</p>
<ul>
<li>They prevent multiple users accessing the account simultaneously (think business accounts and shared accounts)</li>
<li>They require your card, so two items need to be carried at all times. Some people never use their cards and have no reason to carry them</li>
<li>Card readers can break</li>
<li>Card readers need batteries</li>
<li>They are not convenient to carry</li>
</ul>
<p>It is no doubt a big priority that these systems remain secure. Ultimately, that security is irrelevant if the customers do not use the service or transfer to banks that have a more user friendly security method. So, in my opinion, number one priority for bank and customer is the usability.</p>
<p>Unfortunately, the card readers are just the icing on the cake for me. Some of the other frustrations I find with online banking:</p>
<ul>
<li>Non standard login methods, preventing your browser or plugin (<a href="http://www.lastpass.com/">LastPass</a>!) from working</li>
<li>Incomprehensible design and technology decisions, causing major usability problems. (e.g. browser back/forward buttons causing logging out)</li>
<li>Lack of stored data (most of my accounts only hold a couple of months statements)</li>
<li>Lack of browser/device compatibility (no chance of banking online with my phone)</li>
<li>Lack of reliable notifications for payments (did they receive it? what is the status?)</li>
</ul>
<p><strong>The Light</strong></p>
<p>Fortunately, I have seen recently a couple of examples of great forward thinking in the online banking arena. Of particular note is Barclaycards excellent new online interface, launched around July 2009. As the screenshot below shows, you can see up to date graphs on your spending categorised by groceries/fashion/travel etc.</p>
<div id="attachment_102" class="wp-caption alignright" style="width: 225px"><a href="http://www.pickledshark.com/wp-content/uploads/2010/02/barclaycard_online_interface_graphs.jpg"><img class="size-medium wp-image-102" title="barclaycard online interface with graphs" src="http://www.pickledshark.com/wp-content/uploads/2010/02/barclaycard_online_interface_graphs-215x300.jpg" alt="" width="215" height="300" /></a><p class="wp-caption-text">Barclaycard Online Interface - Click to Enlarge</p></div>
<p>As Barclaycard have pioneered, what else can we look into for our online banking solutions?</p>
<ul>
<li>Notifications &#8211; RSS, Text, Email and/or desktop messages showing transactions, balance, charges, statement available</li>
<li>Phone integrations &#8211; an iPhone app for my banks, with push notification, would be immense</li>
<li>Integrations &#8211; Achievable via notifications for a programmer, but some kind of integration with invoicing software or personal finance systems would be a big time saver.</li>
<li>Better exports &#8211; ability to export all information, from all date ranges</li>
<li>Better use of information &#8211; Imagine the information that must be available on each transaction? Location, company details, exact time, balance at that moment etc.</li>
<li>Standardisation across banks, allowing the ability to view finances together (perhaps only realistically achievable by integrations)</li>
</ul>
<p><strong>Existing Integrations</strong></p>
<p>I intend to investigate further, although it seems that existing websites bringing finances together in a truly automated way are still in infancy, probably due to our banking system here in the UK. It is only last year that the banks upgraded their systems to allow instant money transfers (instead of 3 to 5 days delay) &#8211; from a reliable rumour I heard, this was due to some banks using the equivalent of spreadsheets to organise these transactions.</p>
<p>Some of the sites that are worth investigating (thank you to Emma Davies of LoveMoney for her contributions here):<br />
<a href="http://www.mint.com">Mint.com</a> &#8211; currently seems to be USA only<br />
<a href="http://www.moneydashboard.com">Money Dashboard</a> &#8211; looks slightly amatuer, although claims to integrate automatically. Try with caution, I saw them spamming on money forums. Still in Beta with no launch date.<br />
<a href="http://www.lovemoney.com">LoveMoney.com</a> &#8211; A new UK only company launched in April 2009, with online banking launched in December last year. Constantly improving with updates every two weeks. Check out the <a href="http://www.lovemoney.com/blog/">Love Money Blog</a>.<br />
<a href="http://www.kublax.com/">Kublax</a> &#8211; a 2007 <a href="http://www.seedcamp.com/">seedcamp</a> winner, but faces closure due to lack of funding. <a href="http://techcrunch.com/2010/02/19/kublax-to-get-a-lifeline-from-simply-finance/">Could be saved by Simply Finance</a> so still worth keeping in mind.<br />
<a href="http://www.wehuhu.co.uk/">Wehuhu</a> &#8211; No integrations yet (manual uploads) but this is a new service and could be expanding soon.</p>
<p>With some digging around, there appears to be a resistance from the UK banks which is delaying these types of systems. Quote regarding Mint.com &#8220;They&#8217;ve said they aren&#8217;t going to launch a UK version for the forseeable future. None of the major UK banks have gotten on board to allow sharing of transaction data.&#8221;. Source: <a href="http://forums.moneysavingexpert.com/showthread.html?p=30023169">Money Saving Expert forums</a>.</p>
<p><strong>Imagine the Future</strong></p>
<p>I am an optimist. I picture a time when I wake up in the morning, check my emails and see that I have received three payments with details of who from and the exact date/time they sent it. This summary also shows that of the five payments I sent yesterday night, three have been received successfully and two are still pending. My invoicing software is notified of the payments and marks the relevant invoices as paid.</p>
<p>Sat in my favourite coffee shop, I check out my iPhone banking app. I can quickly see the balance of all my accounts, credit cards (including available spend) and also that the two pending payments are now confirmed.</p>
<p>That evening I travel out of my home town and pay for petrol on my card in somewhere I have never been before. I instantly receive a text message to notify me of this transaction, due to its slightly out of character nature, with a web link and number to report the fraud and instantly freeze the card if necessary.</p>
<p>It is is the end of the month and I am checking my credit card statements. I can see easily what I have spent compared to the past 6 months, by category of expenditure. I can see a graph showing my expenditure over the month and realise that the first week I went a bit overboard on clothes shopping. My account shows that all bills are scheduled to be paid and calculates that there is enough money to pay them all, giving me a total of &#8220;free cash&#8221; that I can withdraw during the month.</p>
<p>This is just a sample of how much control we could have and how convenient banking could be. How nice would it be to see a cheap Macbook Air in the shop, check your finances instantly on your phone and only buy if you can? Not very nice for the banks it appears, which may be a reason they are dragging their heels when it comes to providing us with convenient information.</p>
<p><strong>Why Banks should Embrace</strong></p>
<p>More control over our finances should theoretically mean less mistakes, less people overdrawn, less interest and less fines; all this equals less profit for the banks.</p>
<p>The reality is that not everyone will embrace these new features. Offering this technology does not instantly make everyone in the country good with money &#8211; those who are too busy, too scared and otherwise not motivated will still make the mistakes they always have. The ones who are craving this power will reward the banks with more business.</p>
<p>Advancing the online banking technology will not put more money in peoples pockets, remove their greed or fix their lack of money skills.</p>
<p>Let me indulge you with an example. I always play it safe &#8211; if I have any doubt over how much money I have, I won&#8217;t buy. I am not tricked by overdrafts, high credit card limits or buy now pay laters. I like to think I know about money and I don&#8217;t like paying interest &#8211; I always pay in full and on time.</p>
<p>If I am given more control and information, I am likely to know exactly what I can afford and spend more. As a bonus, if I am told that buying a new espresso machine this month will only cost me £7.24 in interest if I put it on card and pay it the month after, I will be tempted to do so.</p>
<p>There is opportunity here for financial institutions to get a head start on others. I am not afraid to change to a bank that offers me more information, better access, more convenience and is more forward thinking. As banks know, an existing customer is more likely to take a loan or a mortgage or other products.</p>
<p>Better tools to access information and monitor information means people will be using the banks systems more. More usage means more potential for advertising, up selling and gaining customers trust.</p>
<p>If my bank embraced technology even slightly, I would respect them more and listen to what they have to say.</p>
<p><strong>Solutions to Security</strong></p>
<p>There still lies obstacles with security, put in place by self-righteous technology consultants and the paranoid media. Due to this mindset, usability is often completely ignored.</p>
<p>I admit I am not particularly security focused, but I believe finding a solution that is convenient to the user is essential. Regardless, here are some potential security starting points:</p>
<ul>
<li>Instead of card readers, how about additional security only when unusual activity occurs? (e.g. different location of login)</li>
<li>Grant lower security to those who want it. Give us a choice! I will take the risk, because I know I won&#8217;t enter my details into www.barclaysbank.somerandomdomain.com/login</li>
<li>Custom security levels. e.g. by default require additional authentication only when money is transferred (customisable by the user)</li>
<li>Bio-metrics &#8211; some way off for mainstream (who of you has a fingerprint reader?), but should be implemented when feasible</li>
<li>Trusted machines &#8211; link my laptop or desktop to the website, meaning I only have to jump through a hoop once</li>
</ul>
<p><strong>What do you think?</strong></p>
<p>Are you happy with the banking system? Are you inconvenienced by the security, or do you not mind and prefer the peace of mind? Do you have any alternatives or ideas?</p>
<h2 style="text-align: center;"><span style="color: #ff0000;">If so, comment below!</span></h2>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/-rLCgk7iK3k" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/online-banking-usability-dreaded-card-reader/feed/</wfw:commentRss>
		<slash:comments>3</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/online-banking-usability-dreaded-card-reader/</feedburner:origLink></item>
		<item>
		<title>Importing Large MySQL Database SQL Dump Files</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/DVBwx9Wwn64/</link>
		<comments>http://www.pickledshark.com/importing-large-mysql-database-sql-dump-files/#comments</comments>
		<pubDate>Mon, 19 Oct 2009 14:58:47 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Web Development]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=80</guid>
		<description><![CDATA[Exporting and importing large MySQL databases can sometimes be a problem due to timeouts from web interfaces, hosting restrictions and inconsistent internet connections. Here we look at a script that will help to reliably export and import MySQL databases.]]></description>
			<content:encoded><![CDATA[<p>If you have ever tried to transfer a large MySQL database you will no doubt have come across some issues. With <a href="http://www.phpmyadmin.net/">phpMyAdmin</a> being the most popular interface most webhosts provide it (and only this) as the way for you to interact with your databases.</p>
<p>Unfortunately, import an SQL dump containing your data and table structure often causes timeouts via phpMyAdmin when the database is particularly large meaning you have to import data a table at a time (or even part of a table at a time) which takes a long time and is prone to error.</p>
<p>In the past I have done many things from writing custom import scripts to importing the database bit by bit. I have also used desktop tools (such as the excellent <a href="http://www.sequelpro.com/">Sequel Pro</a> for Mac OS X) although many web hosts disallow external access.</p>
<p>Fortunately I came across an excellent, flexible import script called <a href="http://www.ozerov.de/bigdump.php">BigDump</a> which takes your SQL file, splits it and automatically imports it (via javascript reloads). Script and full instructions are available at <a href="http://www.ozerov.de/bigdump.php">http://www.ozerov.de/bigdump.php</a></p>
<p><span style="color: #ff0000;">Do you have any tips, tricks, advice or questions about importing/exporting MySQL databases? Get involved and comment below!</span></p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/DVBwx9Wwn64" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/importing-large-mysql-database-sql-dump-files/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/importing-large-mysql-database-sql-dump-files/</feedburner:origLink></item>
		<item>
		<title>CAPTCHA – Passing the Problem to the User</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/f_-_VHQ0Y-Y/</link>
		<comments>http://www.pickledshark.com/captcha-passing-problem-user/#comments</comments>
		<pubDate>Fri, 18 Sep 2009 16:20:13 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[User Interface and Usability]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=77</guid>
		<description><![CDATA[We take a look at the widespread use of CAPTCHA, how it might affect conversions and possible alternatives. CAPTCHA no doubt prevents spam but at what cost?]]></description>
			<content:encoded><![CDATA[<p>CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart) is a method of preventing spam commonly used in web forms. The user is displayed a distorted image of numbers, letters or words and asked to type them out. This ensures that the form is not filled out automatically by a bot and reduces the spam sent through that form.</p>
<p>It is clear that this solution goes a long way to dealing with the spam problem and the webmaster is happy, but at what cost to the user? At best there is another field to fill out. At worst, if the image is hard to read or the user has some visual impairment it is a barrier for the user to completing the form.</p>
<p>Most good CAPTCHA implementations will include a visual (image with text) and audible (audio playback of the text) meaning that even those struggling to read the image will be able to complete the form. There are also usually options to &#8220;refresh&#8221; the image, creating a potentially easier to read image.</p>
<p>All of this helps but does not avoid the fact that the user is having to do more work to complete the form. We are always looking to increase conversions and should be looking at reducing the actions a user has to do (such as <a href="http://adactio.com/journal/1611/">avoiding duplicate email and password fields</a>) in order to increase the chance they will fill out the form.</p>
<p>So what about alternatives? A great example of spam detection is the excellent <a href="http://akismet.com/">Akismet</a> as popularised by <a href="http://wordpress.org/">WordPress</a>. Spam is automatically detected by algorithms and tests on the Akismet server and this reduces manual checking to pretty much zero as well as leaving the user experience untouched.</p>
<p>So a use of Akismet or similar service is the ideal solution &#8211; the user does not see a change and the spam problem is still solved. The service should err on the side of caution, to prevent losing genuine information. Regular checks of the &#8220;spam&#8221; content should also be considered.</p>
<p>The second best solution, which can also be used in conjunction with an Akismet type integration, would be to improve your admin systems. If your form is submitting directly to email then it will be difficult to check and remove large amounts of spam. Having a tidy admin area with the ability to view/edit/delete data all together will reduce time spent on checking for spam.</p>
<p>Many CAPTCHA implementations are unnecessary and are done as either habit or due to some idea that it is a professional thing to do &#8211; question whether you will actually receive spam and is it better to deal with it manually?</p>
<p>The final alternative would be to make the CAPTCHA less obtrusive, more fun or easier in some creative way. Microsoft have the initiative <a href="http://research.microsoft.com/en-us/um/redmond/projects/asirra/">ASIRRA</a> which shows promise &#8211; the user is asked to identify pictures of dogs and cats. A simple click by the user is all that is needed and in tests many found the exercise fun.</p>
<p>Some websites also offer simple random questions (e.g. what is 3 plus 5?) although these are potentially circumvented as well as lacking the fun appeal to most users.</p>
<p>In conculsion I stress that you should consider first and foremost whether you need spam protection. If you need to, try to ensure the spam protection does not intrude on the users experience &#8211; your conversion rates will reward you.</p>
<p><span style="color: #ff0000;">Do you have any CAPTCHA tips, tricks, advice or questions? Get involved and comment below!</span></p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/f_-_VHQ0Y-Y" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/captcha-passing-problem-user/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/captcha-passing-problem-user/</feedburner:origLink></item>
		<item>
		<title>Accessing Websites Without a Subdomain</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/OTBZBvJ80uY/</link>
		<comments>http://www.pickledshark.com/accessing-websites-subdomain/#comments</comments>
		<pubDate>Tue, 25 Aug 2009 14:39:45 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Web Development]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=74</guid>
		<description><![CDATA[Many websites simply time out if you try to access them without the www prefix on the URL. Read on and make sure you don't lose visitors by making this mistake.]]></description>
			<content:encoded><![CDATA[<div style="float: right; display: inline; text-align: center;"><img class="alignright size-full" src="http://farm2.static.flickr.com/1041/990866224_b7be4405df_m.jpg" alt="World Wide Web" /><br />
<small><a title="Attribution-ShareAlike License" rel="nofollow" href="http://creativecommons.org/licenses/by-sa/2.0/" target="_blank"><img src="http://www.pickledshark.com/wp-content/plugins/photo-dropper/images/cc.png" border="0" alt="Creative Commons License" width="16" height="16" align="absmiddle" /></a> photo credit: <a title="Bull3t" rel="nofollow" href="http://www.flickr.com/photos/56315780@N00/990866224/" target="_blank">Bull3t</a></small></div>
<p>The www prefix is essentially a subdomain of your website and although many people will type it in, some may just try to enter the domain itself.</p>
<p>Many websites, including high profile ones, can&#8217;t be accessed without the www subdomain. For example, barclaycardunwind.co.uk is inaccessible while <a href="http://www.barclaycardunwind.co.uk">www.barclaycardunwind.co.uk</a> is.</p>
<p>This is essentially a DNS or server configuration problem, so a single solution is not available for everyone but it should be straightforward. Contact your web host if you are not sure or modify your server configuration if you know what you need to do.</p>
<p>Once you can access your site without the www, <a href="http://www.pickledshark.com/htaccess-redirect-nonwww-www/">make sure that the traffic is forwarded to one or the other</a> to prevent potential duplicate content issues with google.</p>
<p>Make sure you do it, or risk frustrating and/or losing a lot of your visitors!</p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/OTBZBvJ80uY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/accessing-websites-subdomain/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/accessing-websites-subdomain/</feedburner:origLink></item>
		<item>
		<title>Understanding Google Gears – The Basics</title>
		<link>http://feedproxy.google.com/~r/pickledshark/~3/26u3Qtfz2eo/</link>
		<comments>http://www.pickledshark.com/understanding-google-gears-basics/#comments</comments>
		<pubDate>Tue, 11 Aug 2009 22:22:09 +0000</pubDate>
		<dc:creator>Carey</dc:creator>
				<category><![CDATA[Software]]></category>

		<guid isPermaLink="false">http://www.pickledshark.com/?p=70</guid>
		<description><![CDATA[Some people are unsure exactly what Google Gears is, what it does and how you can use it. Read on for a quick and dirty guide that will give you an understanding of this technology by Google so you can benefit from it and even use it in your websites/applications.]]></description>
			<content:encoded><![CDATA[<p><img src="http://www.pickledshark.com/wp-content/uploads/2009/08/google-gears-explanation.gif" alt="Understand Google Gears" title="Understand Google Gears" width="153" height="43" class="alignright size-full wp-image-71" /></p>
<p>Google Gears was released in mid 2007 and, as described by the big G themselves, &#8220;enables more powerful web applications, by adding new features to your web browser.&#8221;. This is a slightly generic explanation and the aim of this post is to show exactly what Google Gears does and how you can benefit from it.</p>
<p>Essentially Gears (the official name, to reflect the open source nature) extends your web browser. You perform an install at <a href="http://gears.google.com/">http://gears.google.com/</a> which is available for most modern browsers. A website can then use the following features via Gears:</p>
<ul>
<li>A local server, to cache and serve application resources (HTML, JavaScript, images, etc.) without needing to contact a server</li>
<li>A database, to store and access data from within the browser</li>
<li>A worker thread pool, to make web applications more responsive by performing expensive operations in the background</li>
</ul>
<p><em><strong>But what does this actually mean and what makes it good?</strong></em></p>
<p><strong>Offline Functionality</strong> &#8211; By using Gears, the application and data can be stored offline and the user can perform tasks without an internet connection. Data can then be synchronised once an internet connection is available. A great example of this is <a href="http://www.gmail.com">Google Mail</a> &#8211; with gears you can view your emails, reply, send new, access your address book etc. and everything is performed once you get an internet connection. See also the todo list application <a href="http://www.rememberthemilk.com/services/googlegears/">Remember the Milk</a>.</p>
<p><strong>Faster Sites</strong> &#8211; Gears can store files, data and code on a local web server, meaning your machine shares the processing power and reduces the need for data transfer. <a href="http://www.wordpress.com">WordPress</a> implements this well in the admin area, speeding up many tasks.</p>
<p><strong>Quicker Searches</strong> &#8211; Full text searching can be performed locally, meaning less server resources are used and quicker results for the user. <a href="http://developer.myspace.com/community/blogs/devteam/archive/2008/05/29/myspace-mail-search-with-gears-released-google-i-o-presentation-slides.aspx">MySpace</a> takes advantage of this feature.</p>
<p><strong>Threading JavaScript Code</strong> &#8211; On a more technical level, the WorkerPool functionality allows Javascript to be run in the background without affecting the browser. This essentially means that script execution is not stopped on the website while this Javascript is running, meaning a more user friendly experience and hopefully the disappearance of the &#8220;A script is taking a long time to run&#8230;&#8221; dialog boxes.</p>
<p><strong>GeoLocation access</strong> &#8211; Google Gears can request the geographic location from the client (if there is a GPS device such as on an iPhone) or from the network information (IP address etc.). This is made simple for the coder and allows the web application to know with accuracy and efficiency where the client is located.</p>
<p><em><strong>What else can Gears do?</strong></em></p>
<p>Gears is still in Beta and is not recommended for public use yet (despite many Google Applications using the technology). Gears provides an interface between the website and the clients machine, meaning that in future websites will for example be able to:</p>
<ul>
<li>Encode video/audio locally</li>
<li>Send notifications to the users desktop (e.g. Windows XP bubbles or OS X Growl style notifications)</li>
<li>Access files locally</li>
<li>Ability to resume file uploads</li>
<li>Use the clients camera</li>
</ul>
<p><em><strong>Some important information</strong></em></p>
<p>Google Gears needs to be implemented so this is an extra strain on lower budget websites and applications. Also, the client needs to install an extension to their browser meaning your typical user won&#8217;t have the software available. This means that at the moment only hugely popular technical/professional style sites are implementing gears.</p>
<p>The popular Firefox plugin <a href="https://addons.mozilla.org/en-US/firefox/addon/748">Grease Monkey</a>, which basically allows you to use scripts (or your own code) to modify websites on the fly, can be used to implement Gears features even when the website hasn&#8217;t implemented it. See the Google article <a href="http://code.google.com/apis/gears/articles/gearsmonkey.html">Gears Monkey</a> for more information and a script for Wikipedia.</p>
<p>The actual name of this technology is Gears. Google renamed it from Google Gears in order to reflect the open source direction of this project. Many people still refer to the technology as Google Gears, including myself, due to the ambiguity of Gears.</p>
<p><em><strong>What other web applications are currently using Google Gears?</strong></em></p>
<p>Here are a few I know about:<em><strong><br />
</strong></em></p>
<ul>
<li><a href="http://reader.google.com">Google Reader</a></li>
<li><a href="http://docs.google.com">Google Docs</a></li>
<li><a href="http://drupal.org/project/gears">Drupal</a></li>
<li><a href="http://thn.gs/">Somethings</a></li>
<li><a href="http://picasa.google.co.uk/">Picasa</a></li>
<li><a href="http://www.buxfer.com/">Buxfer</a></li>
<li><a href="http://www.mindmeister.com/">Mind Meister</a></li>
<li><a href="http://www.passpack.com/">PassPack</a></li>
<li><a href="http://calendar.google.com/">Google Calendar</a></li>
</ul>
<p><span style="color: #ff0000;">Do you have any Google Gears tips, tricks, advice or questions? Get involved and comment below!</span></p>
<img src="http://feeds.feedburner.com/~r/pickledshark/~4/26u3Qtfz2eo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.pickledshark.com/understanding-google-gears-basics/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.pickledshark.com/understanding-google-gears-basics/</feedburner:origLink></item>
	</channel>
</rss><!-- Dynamic page generated in 0.346 seconds. --><!-- Cached page generated by WP-Super-Cache on 2010-07-30 16:45:45 -->
