Archive for the 'Software' Category

Page 2 of 3

Google Calendar Sync

Woohoo! Back in July, I posted about keeping my calendars synchronised. And guess what? We’re nearly there!

All is explained in the Official Google Blog:

“…This was my life for a whole year before we started working on Google Calendar Sync, a 2-way synching application between Google Calendar and the calendar in Microsoft Outlook. I was probably the most excited person on the team when we started developing it, because now I can access my calendar at home or on my laptop, on Google Calendar or in Outlook. When I add an event to the Outlook calendar on my laptop, Google Calendar Sync syncs it to my Google Calendar — and since I also have Google Calendar Sync running on my desktop, the event then syncs from Google Calendar to Outlook calendar on my desktop. All of my calendar views are always up to date, and I can choose whichever one I want to use.”

Most excellent! Downloaded and installed. And I can access Google Calendar from my mobile and add appointments from there too.

The Trouble with PNG Images

I’ve recently been doing a web site refresh for someone who wanted their site to be more up to date looking, less ‘blocky’ and still CSS-based and standards-compliant. They’d had another designer approach them – or more particularly, the boyfriend of a staff member had approached them – and knocked up a good-looking, if table-based, version of their home page.

OK, he’d forgotten to check the site in different browsers and on different platforms, so it was very broken and likewise it was nowhere near being standards-compliant, but hey-ho…

So they asked me to produce a working, standards-compliant version which I duly did. One of the elements they wanted was a navigation bar to match their current logo colours and I created the background for the navigation area and saved it as a PNG: I didn’t want a GIF image due to the blockier look of the curved ends that would result from using that format and I didn’t want a JPG image due to the file size (I try to ensure my pages come banging in as quickly and efficiently as possible).

The result looked great in all the browsers I tested it on.

The client then asked me to change the navigation element so that there was some mouseover effect, so I went for their logo colour on the text over white when the mouse is over the link and white text over their logo colour in the ‘off’ state. At this point, it looked great in Firefox, Opera, Safari, etc. but the colours were off in Internet Explorer 7 (which has only recently included support for PNG images).

I thought it was just my CSS being screwed up and checked the PNG file I was using for the DIV background against the hex code I was using for the navigation element colour and found they were exactly right. I then did a screenshot and lifted the hex code from the background to find that it was different to the original image when displayed in Internet Explorer 7. The reason? Gamma correction within PNG images which gets stripped out by web browsers except for Internet Explorer! I’d never come across this before as I was used to using GIFs and JPEGs due to the earlier lack of PNG support in Internet Explorer.

There’s a good blog entry about it here that links to this article and this paper.

Word 2007 Speechless

Yet another “benefit” or “upgrading” to Word 2007 is the loss of the text-to-speech function inlcuded in earlier versions – I used to use this to read a Word document from one screen so that I could look for differences in a document or web page on another screen.

I found this out after waiting a little while for the Word Help [sic] window to finally open. It says:

“Text-to-speech features are included only in Microsoft Office Excel.”

Why? Well clearly Microsoft want us all to “upgrade” to Windows Vista, their operating system that would insist on my replacing a previously high end sound card with a new one just because there are no Vista drivers for it. Why the hell should I?

You think I’m kidding? No:

“Speech recognition features are not available in the 2007 Microsoft Office system programs.

“To use speech recognition features, run Windows Speech Recognition in Windows Vista.”

Or not. Helpfully, Microsoft also say:

“If your operating system is Microsoft Windows XP, you must run a previous version of a Microsoft Office system program to use speech recognition features.”

Now they tell us…

There is, however, a workaround. From within Word start the VBA Editor  by pressing Alt+F11.

Add a reference in the normal project to Microsoft Speech Object Library (Tools | References…).

Locate the “Microsoft Speech Object Library” reference and add a tick to the check box.

Note: You must have installed the Speech portion of Excel for the Microsoft Speech Object Library to be available to the VBA editor.

Create a new module by right-clicking the Modules element in the tree under the Normal project and clicking Insert | Module. Call it TextToSpeech in the module’s properties box (where it will say Module1 or whatever next to “(Name)”).

Copy and paste the following macro code into the module you have created, save and close the macro editor.

Dim speech as SpVoice 'Don't overlook this line!

Sub SpeakText()
'Based on a macro by Mathew Heikkila
'
On Error Resume Next
Set speech = New SpVoice
If Len(Selection.Text) > 1 Then 'speak selection
speech.Speak Selection.Text, _
SVSFlagsAsync + SVSFPurgeBeforeSpeak
Else 'speak whole document
speech.Speak ActiveDocument.Range(0, ActiveDocument.Characters.Count).Text, _
SVSFlagsAsync + SVSFPurgeBeforeSpeak
End If
Do
DoEvents
Loop Until speech.WaitUntilDone(10)
Set speech = Nothing
End Sub
Sub StopSpeaking()
'Based on a macro by Mathew Heikkila
'used to interrupt any running speech to text
On Error Resume Next
speech.Speak vbNullString, SVSFPurgeBeforeSpeak
Set speech = Nothing
End Sub

Now add this to your Quick Access Toolbar by clicking the down arrow at the end of the QAT | Customize Quick Access Toolbar | More Commands | Choose commands from: and select Macros from the drop-down list | Add | OK.

To use the macro, select a block of text to be read out to you and click the Macro in your QAT (or else it will read the whole shebang as I must confess the stop macro didn’t work for me…).

Microsoft Office 2007

Just say no.

It’s slow, bloated and what’s more it’s more difficult to use than before.

Upgrade? My arse!

Today’s annoyance? Word 2007. I want to insert a contact’s name, company name and address from Outlook 2007. Now of course, I cannot find a menu item for this so I have previously added a button to the Quick Access Toolbar for “Insert Address” but the default seems to be “Insert Name and Address but not Company Name” for your contacts.

In earlier versions, you could add an Auto-Text thingy to bring in those details. But I’m not sure you can do that now.

Oh and if you’re really bored, try to find out how to insert an address from Outlook using the so-called Help facility within Word. Utterly pants!

The Trouble with Google…

I’m one of those people – as you’ve probably noticed – who displays adverts on their web sites, in my case, Google’s AdSense ones.

Now these adverts generate income for me whenever someone clicks on one of those links. What happens is an advertiser pays Google to display their adverts on sites where certain keywords chosen by the advertisers trigger their ads being displayed. In turn, Google give a percentage of that revenue to the sites displaying the adverts. I pay for some advertising his way as well.

What I’m noticing more and more these days though is that the revenue from displaying these ads. on my sites is coming down despite the fact that I am displaying ads on more web sites than before and the sites having become more popular.

I’ve never made a lot of money from Google – at its best, I was making roughly a dollar a day which was more or less covering my own spend.

But last month, for instance, my ad. revenues were down by a third. Now we’re talking small beans here with me, but if I were running an online business that relied on Google AdSense for its entire income, I’d be seriously worried.

I wonder what’s causing this squeeze? Ad-blockers? Too many sites chasing too few advertisers?

Teh Shiny is Fettled

The additional Kingston 1GB DDR2 RAM SODIMM arrived by courier today from Dabs.com.

I was slightly worried about taking a screwdriver to a day-old laptop and removing the keyboard to get at the RAM slots, but it was fettled within a few minutes, re-booted and is now boasting 1.49GB.

I fettled Firefox last night as well. Then had to install some web server extensions and my FTP program of choice with the FTP site profiles I use.

Now it’s a case of deciding how many and which project management software programs to install.

I’ve also been playing with Microsoft Office Groove as a potential replacement for the good old Offline Files. And the new laptop meant downloading some updated software from Vodafone for their 3G datacard, which looks like an improvement over the old software.

Only problems so far have been the quality of the sound from the stereo speakers – my old Dell Insipron 8100 is much better in this regard – and the mobile ‘drumming’ from the datacard when its communication is picked up by the microphone/speakers.

The position of the vents is better than my old Portégé so you don’t get a toasted forearm when you’re holding it in Tablet mode. Oh and the 5-in-1 Bridge Media slot (which supports SD™ Card, Memory Stick®, Memory Stick Pro™, xD-Picture Card™, SD™ IO Card) is a nice feature. It’s just a pity that it doesn’t support Memory Stick Pro DUO™ cards as I’ve just bought one for my daughter’s new Sony digital camera.

The Trouble with Firefox

I tend to have a number of web browsers installed on my systems to make sure I can test web pages in a number of up to date browsers, and this includes Firefox (
)

But one issue I have with Firefox is how after a few hours’ use – especially as my use these days tends to include a number of AJAX-based sites, Gmail, etc. – the amount of memory being consumed sky-rockets despite, or possibly because of, the amount of physical memory on my main work machine.

This evening, I’ve implemented a number of hacks that may or may not help things out with this supposed memory leak (apparently it’s working as designed…), so here we are. This is Firefox version 2.0.0.6, by the way.

Firstly, we want to reduce the amount of RAM being used for Firefox’s cache. We do this like this:

1. Type “about:config” (no quotes) in the browser
2. Find browser.sessionhistory.max_total_viewer
3. Set its value to “0″
4. Restart Firefox

Secondly, as minimising the browser window seems to accomplish little, we’ll try to reduce memory use when it is:

1. Type about:config again and then press Enter.
2. Right-click in the page and select New -> Boolean.
3. In the box that pops up enter config.trim_on_minimize. Press Enter.
4. Now select True and then press Enter.
5. Restart Firefox.

Still with me? Now we’ll move on to page rendering speeds and more memory leak hacks, this time from “Have Laptop Will Travel”:

“Type in the address bar about:config.
Type pipelining in the filter bar.
Double-click on network.http.pipelining to set its value to TRUE.
Double-click on network.http.pipelining.maxrequests and change its value to 12 or more if you have broadband.

Play a little with the setting to find a configuration which is best for your connection.

Firefox is most hated for its memory usage. After having browsed some hours, Firefox will easily have taken 250MB or more of memory and slow down your PC. This is because FF has never been programmed to overwrite the memory it doesn’t use anymore and give free to other programs. Sometimes even closing Firefox won’t speed up your PC anymore. But the leakage can be prevented.

To do so, open a new tab and type about:config in your address bar again.
This time we want to limit the size of the memory cache.
Therefore we need to create a new preference, named browser.cache.memory.capacity.
Right click on any free area in the preferences window and choose New —> String.
Type now the name browser.cache.memory.capacity and in the next window set the value to 20000.
This will limit the size of the cache in the RAM to 20000KB and should prevent the annoying memory leak.
Restart your browser now.”

And after I’d found and implemented these hacks, I discovered them and more at the element14 Blog.

Recording My Lap Times with a Calendar

Calendars.

A necessary evil these days.  I can’t be bothered with paper ones in the same way that diaries never worked for me.

No, I prefer my good old Outlook Calendar. In the latest version, it can also be set up to synchonise with a webdav-enabled web server which is nice, except that you can’t then simply go to the URL and view your calendar online, for instance in an Internet café or on your mobile. No, the .ics file can be downloaded and imported by applications like Entourage or Outlook, but you can’t really read or amend it when you’re out and about.

When I can be bothered, I can synchronise my Nokia phone with Outlook when I’m back in the office, just as I can my iPAQ, so that’s useful, but it means I have to be around the base PC and have to manage the connection.

I can also export my Outlook calendar and import it into Google Calendar. That’s all very well and good but it’s a slow, manual process.

No, what I want is a calendar that I can amend at my desk. It’s automatically published at regular intervals to the web where I can choose to keep all or part of it private or restrict who can view it online. I want to be able to add to it or change it on my mobile with any changes being made to all the versions automatically the moment I’m in range, either of a decent high speed GPRS link or a 3G one. And I want to be able to update it through any web browser and have those changes propagated immediately to the PC and phone versions.

Surely that’s do-able? 

Search and Ye Shall Find

…depending upon what you use to search.

Or so it would appear.

When I “upgraded” to Office 2007, Outlook “suggested’ I download and install Windows Desktop Search which they suggest is “Best in Class”.

Now I am already running Google Desktop and have been impressed with it.

Yesterday I tried out some Nero software (before removing it again as it didn’t do what I wanted) and that installed another search program that looked exactly like a re-badged version of Windows Desktop Search.

Anyway, I’d had ‘mixed’ results with Windows Desktop Search noting how the number of items searched would sometimes count down, or that the number of items to index would also count down without a corresponding increase in the number of items searched and indeed noting that it would continue to index my PC even when supposedly snoozing.

Couple all that with the way that it only seemed to want to know about the current Outlook post file and it began to take on the usefulness of a chocolate teapot; especially when you take into account the need to keep Outlook post files to an absolute minimum size in the latest version unless you want your system slowed down to less than crawling pace. Outlook 2007: bst avoided!

So the other day, I needed to find some access details I’d e-mailed a client a while back. I knew I wouldn’t find them in my current Outlook post file, so I opened the job-specific post file archive and asked it to search only to find that it hadn’t been indexed and none of the other search facilities in Outlook could help either. So I fired up Google Desktop and instantly found the details I needed…

I looked at the Windows Desktop Search preferences and manually added .pst files – curiously omitted by default – and made sure that the Archives folder was ticked to be searchable and after allowing Windows Desktop Search to catalogue everything unhindered – at the expense of it slowing down my system – I decided to run a little test.

I sent myself an e-mail from my Gmail account (excluded from my Google Desktop search items) with the name “Persephone Winterbottom” in the e-mail body. This came via a POP3 account into MailWasher Pro and thence into Outlook. I then opened an archive .pst file and dragged the new e-mail into it before closing it once more.

After both programs indicated they were up to date, I ran a search for “Persephone Winterbottom”. Now, you need to bear in mind that Google Desktop needs Outlook post files to be open to be searched whilst Windows Desktop Search shouldn’t if it follows the preferences.

And the results? Google Desktop returned a positive on the e-mail within the main Outlook post file. Not so good if you want to actually locate the e-mail in its archive but the program does return its contents within the browser window (which is good enough for me).

Windows Desktop Search still doesn’t seem to acknoweldge the e-mail’s existence whatsover, even days afterwards, so it’s been uninstalled here now.

Gah! (Rare anti-Microsoft Rant)

I’m starting to become A Little Bit Fed-Up with Microsoft.

One of the best pieces of kit I own is my Toshiba Portégé 3500 Tablet PC. Quite why Tablet PCs never really set the world on fire is frankly beyond me: the never-ending notebook* for you to scribble on when you’re making notes or suggesting a layout to a client is just fabulous. (*OneNote – the ‘killer app.’ for the Tablet PC which isn’t too bad on a regular lappy either).

Until…

Until it decides to get a bit tired and emotional and Windows XP SP2 Tablet PC Edition (phew!) throws up yet another BSOD every time you try to start it up, blaming the (unchanged) video drivers.

My main work machine is a three year old, dual-screen PC that was many thousands of pounds to buy and is still super fast and super-spec’d. Except that it takes 15 minutes to start up from being turned on or restarted to have the desktop and start-up apps. loaded and the PC usable. 15 minutes. Try timing that yourself – it’s longer than it takes to go and make a cup of coffee and come back to my desk.

I have Windows Vista ready to roll out. Except that it tells me that my sound card drivers won’t work and because the sound card is three years old, the manufacturer has not written Vista drivers for it. The card and surround sound system is working perfectly here on XP Pro as are a number of apps. which won’t apparently work either. So no, I shan’t be running Vista here for the foreseeable future.

Office 2007, on the other hand, has been installed here. Some nice features for Outlook, but boy is that slow! Oh and it prompted me to download and install Windows Desktop Search which is a truly bizarre little app. which seemingly doesn’t understand what snoozing actually means (i.e. it carries on indexing even when supposedly snoozing) and can’t seem to keep track of how many items it has indexed (often counting backwards) and has still to index.

I also have an old iMac (the CRT TV type) which is ready to go in about a minute. Apparently, Office 2004 for the Mac (I presently have Office X) includes Word 2004 which includes similar functionality to OneNote. Hmm.

So, back to the Tablet PC. How to replace it?

Well Toshiba does seem to be soldiering on with Tablet PCs but we’re looking at £1,000 – £1,600 (plus VAT) for one of them. Pros would include being able to run Office 2007 including OneNote and using my Outlook post file on the PC and the Tablet. Cons would mean the same instability and slow booting time.

Or I could always get a new Apple MacBook. Prices are more or less comparable and if I chose to use Parallels or Boot Camp I could even run Windows XP on it. The downside is simply the lack of the Tablet PC functionality.

Or I could simply buy a cheapo laptop from PC World for £500 and junk it from time to time. No Tablet PC functionality and probably a tad heavier.

Decisions, decisions..