The Camera Centre is now accepting orders utilising Google Checkout making life even easier for shoppers to get great camera and accessory deals!

Checkout www.thecameracentre.net …. pardon the pun!

You can export the “People & Groups” section to an XL spreadsheet by hinging through the owssvr DLL. However, you’re going to need the SSID for both your ‘List’ and whichever ‘View’ also to get it to work.

To obtain both of these:

List SSID – Goto the “People & Groups” list you want to export and goto “Settings >> List Settings”. Then click on “Create Column”. From there you see in the URL fldNew.aspx?List=%7B blah %7D

^^ Take the long string between the %7B and %7D at either end. Do not take the %7B nor the %7D at either end <– important!

View SSID – just goto your “People & Groups” list and choose the “Detail View” which will initiate it and you’ll get in the URL blahblah&View={the SSID}

^^ Take the SSID without the curly braces this time and place them in the following URL string at the appropriate places with your SITEURL also:

http://[SITEURL]/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[LISTID]&View=[VIEWID]&CacheControl=1

From there you’ll get an export of the contents of your group from which you can copy ‘n paste the email addresses into your new site.

You’ll need to create a new XL column and concatenate the email address with a semi-colon after it prior to pasting the emails in.

From reading through the blogosphere and all the varying Magento forums its obvious lots of people are having issues in upgrading from Magento 1.3.x to 1.4.x due to custom theme problems and errors. I was no different! Who would have thought these things could be so difficult!?

After several attempts at upgrading Magento to 1.4.x failing dismally I set about toying with a development site until I could figure out what was what?! Its detailed everywhere that your 1.3.x theme will have to be re-written to work with 1.4.x but I’ve managed to get a simple enough process working for me in upgrading Magento 1.3.x to 1.4.x and keeping my custom 1.3.x theme working in 1.4.x without any re-development at all! So here goes:

1. Log into the Magento Backend Admin Panel and remove products that you have placed in more than one category. Just have your products in one category otherwise these cause errors after the upgrade.
2. Turn off SEO url rewrites (System >> Configuration >> Web >> Search Engines Optimization)
3. Turn off cache management (System >> Cache Management)

The following from CrucialWebHost’s help site is perfect:

A little cleanup first:

rm -rf downloader/pearlib/cache/* downloader/pearlib/download/*

Set the permissions on the pear file so we can run it:

chmod 550 pear

I then cleaned out the cache myself manually to be sure:

rm -Rf var/cache/*

and again from the CrucialWebHost:

Initialize the PEAR channel just in case:

./pear mage-setup .

And then we can upgrade:

./pear upgrade-all

If it tells you that there’s Nothing to upgrade, you’ll need to do this instead:

./pear install magento-core/Mage_All_Latest

Lastly, we need to clear out any temporary and cached data. These commands will be done via SSH in the staging directory.

rm -rf downloader/pearlib/cache/* downloader/pearlib/download/*
rm -rf var/cache/ var/session/ var/report/ media/tmp/

And then reset our file and directory permissions:

find . -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \;
chmod 550 pear

After this point delete everything in the following to clean out the backend cache (you need to do this or you will get errors when saving new configurations and probably logging into magento admin after upgrade too)

rm -Rf app/code/core/Zend/Cache/*

Log into your new 1.4.x Magento Backend Admin Panel from index.php/admin/

1. ReIndex Data on everything (System >> Index Management)
2. Turn on SEO rewrites  (System >> Configuration >> Web >> Search Engines Optimization)
3. Turn on Cache Management (System >> Cache Management)

From this process you have theoretically upgraded your Magento installation to the latest 1.4.x version of Magento and have your custom theme working fine. Or at least I have, I can’t guarantee that this process will work for everyone out there?!

Good luck.

The Camera Centre web presence has been updated with a fantastic selection of Rollei digital cameras and associated products.

Rollei’s digital camera products can be easily purchased through the new easy to use interface and one step checkout system in just a couple of mouse clicks.

Currently celebrating their 90 year aniversary. Rollei cameras:

are easy to use and function extremely well ─ these were the main criteria of company founders Paul Franke and Reinhold Heidecke while designing the legendary twin lens Rolleiflex back in 1929. It rapidly became a widely used tool of professional photographers and the dream of every amateur one.

The high quality standards of Rollei’s founders remain virtually unchanged today.

The “twin lens” feature initiated the constant development of innovative devices. Important milestones in design were the compact Rollei 35 mm camera, the Rolleiflex SL66 with built-in lens bellows, the first electronically controlled medium-format Rolleiflex SLX, and the 35 mm mirror reflex SL 2000F with interchangeable film backs. And Rollei’s twin slide projectors are one-of-a-kind in the world.

Do check out thecameracentre.net’s fantastic new Rollei range!

Noticed how the instructions to install your Comodo SSL certificate flags an error when you flick onto HTTPS? The way to fix this is to employ the following for both the :

<script language=”JavaScript” type=”text/javascript”>
var comodohost = ((“https:” == document.location.protocol) ? “https://” : “http://”);
COT(comodohost + “www.yourdomain.tld/cot.gif”, “SC2″, “none”);
</script>

<script type=”text/javascript”>
var comodohost = ((“https:” == document.location.protocol) ? “https://” : “http://”);
TrustLogo(comodohost+”www.yourdomain.tld/tl_white.gif”, “SC4″, “none”);</script>

Note the new comodohost variable being used to provide either the HTTPS or HTTP connection.