Skip to content

Exporting data from Magento

Often when using web applications it’s quicker to export any required data directly from the database using SQL queries. Magento e-Commerce is a very different beast, due to the fact that much of the important data is stored using the EAV (Entity Attribute Value) model. You can’t get find a single table to dump the data.

Fortunately Magento provides you with Import and Export routines for Customer and Product data. But if you’re expecting to get offered the choice of where to save the data, you might be surprised to find that the data just get saved in the directory /magento root/var/export. You’ll have to dig the file out and copy to your local machine before you can start mapping fields to data for the import process.

Posted in Magento | Tagged , , | Comments Off on Exporting data from Magento

iPhone 4? Get your free bumper here…

Apple have finally announced how iPhone 4 owners can go about claiming their free ‘bumper’ to help solve those pesky reception problems. Just install an app and say “yes please!”

http://www.apple.com/uk/iphone/case-program/

Posted in iPhone | Tagged , | Comments Off on iPhone 4? Get your free bumper here…

Finally – the death of PHP4…

PHP as a programming language has always been criticised. Because it’s scripting language, because it’s fundamentally a procedural language with thousand of unrelated functions, but mostly because it’s support for Object Orientated Programming was primitive at best. PHP4 didn’t even support the public,private and protected keywords for methods and fields.

However, until recently, most of the major Open Source web applications such as WordPress and Drupal would run happily on PHP4. This meant that web hosts had little incentive to upgrade to PHP5, which meant that developers often didn’t take advantage of the new language facilities available in PHP5.

The good news is that WordPress 3.2, due early next year, will only support PHP5.2 and later. The next iteration of Drupal and Joomla are also going to require PHP5.2. This will finally force web hosts to enable PHP5 support out of the box, and hopefully will speed up the development of PHP as a language, as more developers start to take advantage of the PHP5 specific features such as PDO, the new XML objects and better Object support.

It’s just a shame that they haven’t jumped straight to requiring PHP5.3, which adds a number of very useful programming constructs, such as closures and crucially late static binding. Building complex extended classes is a right pain in the arse in PHP5.2, as you often end up having to redefine methods or fields in child classes, rather than just referring to methods defined in the parent class. Brandon Savage has a nice little primer on late static binding, and I’ve suffered myself with this issue myself when playing with Zend Framework.

Posted in Web Development | Tagged , , | Comments Off on Finally – the death of PHP4…

What is the keychain?

I’ve lost count of the number of times Mac technical support customers have asked me what the keychain is. It’s a very simple concept. Fundamentally it’s a place for you to store passwords so that applications, such as your email program, can retrieve the password when they need. So how does it work?

When you create an email account you’ll be asked for the password needed to access that mailbox. If you tick the box saying “remember this password” then the password is then added to your keychain with a note saying which application wanted to remember the password. Henceforth, everytime that application needs to send that password, it asks the keychain for it. The keychain checks to see if the application requesting the password is the one that asked for it to be saved. If it is, the password is provided. If it isn’t, the password is refused.

So why do you sometimes see messages saying things like “The application Mail wants to access an item in your keychain…” out of the blue? Usually it’s because you’ve run an OS update, the application Mail has been updated and the keychain is checking that you still want to give it access to your passwords.

Why so complex? If the keychain didn’t protect passwords on a per application basis, someone could persuade you to download dodgy software onto your machine that could then extract all your stored passwords. Which would be very  bad news.

Lastly, the keychain is normally locked by a “master” password – no program can access data stored in it until you enter the password for that keychain. The reason you don’t typically see a prompt to enter the keychain password is that it is automatically unlocked when you login to your Mac.

All cleared up? Good.

Posted in Apple, Security | Tagged | Comments Off on What is the keychain?

SEO basics – choosing good urls for higher Google position

Search engines use incredibly complex algorithms to calculate what pages should be returned when you search for a given term. The exact algorithms are closing guarded secrets, but search engine optimisation experts have been able to infer some basics rules to follow.

One of these is that having a url that contains some of your chosen keywords can help provide a marginal, but useful boost to a page’s relevance. Let’s assume we are trying to optimise for “vintage rare coganc”. We can gain some advantage by using those terms in the querystring, the path or the TLD.

  1. http://www.my-domain.blah/index.php?q=vintage&20cognac
  2. http://www.my-domain.blah/vintage-cognac
  3. http://www.my-vintage-cognac.blah/

Any sensible Content Management System or e-Commerce platform should be able to support such “pretty” or “search engine friendly” urls – which can help make those marginal gains that push you from the second page of results onto the first.

Interested in learning more about Search Engine Optimisation? Why not get in touch?

Posted in Web Development | Tagged , , , , | Comments Off on SEO basics – choosing good urls for higher Google position