Categories
Blog News

Excel 2008 for Mac insists on using mm/dd/yyyy instead of dd/mm/yyyy !

I’ve just discovered a really bothersome bug using Excel 2008 for Mac (I’m using the current latest version 12.2.3 of Excel 2008 for Mac). My date columns keep on insisting on using the US format of month-days-year, even when the mac time setting is set to Brussels, Belgium. There does not seem to be a way to fix the setting in Excel, and similar date format problems appear on forums already since Excel 2004.

The workaround I found was to select the date format 01-Mar-2009, in other words show the month as a word instead of as a number. This way I’m sure that the date I’m typing in is correct. But really this is annoying me immensely.

Another workaround (haven’t tried it yet) so that Excel uses the underlying Mac date format is to NOT preselect CELLs and format them as DATES – just type the date in a normal cell using slashes and Excel will then convert the values to the correct international date as set by the mac… I’ll try that next time.

WHY hasn’t this been resolved yet !? What’s so hard about doing this the right way ? I know the answer ofcourse – it’s a big company and everyone there has to jump through 15 hoops simultaneously while hopping on one leg and signing delivery forms with a pen that only works 1 in 3 times 🙂

Categories
Hardware

My HD Recorder KISS DP-558 is dead. So is the Kiss website.

Kiss Technology is dead

After 4 years of usage, my Kiss DP-558 recorder is dead. Done. No longer working. And the Kiss website is down as well. Cisco/Linksys has taken over and shut down Kiss Technologies. More’s a pity that they never *did* anything with what they bought…

A mains current failure that came and went made sure that it died an agonizing death, always switching on and then switching off again. I’m sorry to see you go mate, you earned the ‘wife-acceptance’ trophy, which is hard to come by.

So I’m looking for a replacement. I’ve finally settled on a Emtec S800 (I originally bought the S800H, but this only has a digital tuner, not an analog, and we’re still (stubbornly) analog.

Still, no more Electronic Program Guide to pick and choose from. And still no H.264 (which the S800H did have) codec support. And no more having something decent looking under your televison that fitted in with the Hi-Fi equipment.

Bummer.

Categories
Blog News

What about flex on this blogpost ?

For those few regular readers out there, they have probably noticed that I no longer post regularly about Adobe Flex.

Please be assured that this is not out of the picture ! Rather, I wanted to learn Flex enough to get by in it. It’s been *very* interesting, but also very hard sometimes to wrap my head around Actionscript and MXML. Now that I know a bit about what I can do with Flex, I’ve started again with Python and more specifically with CherryPy.

CherryPy is a very easy-to-use web framework that you can use to set up your own webserver in a flash. It provides a basic syntax for setting up the webservice, then scurries out of the way, letting you ‘get on with it’, whatever that may be.

Currently I’m setting up a local Webserver (using CherryPy) and this is where most of my time has gone to.

Once the python application on there has been created (and most of it has) I then will head back to Flex and it’s usages as a reporting tool – I’ll be trying to use PyAMF as the glue between python functions and Flex datagrids.

Anyways, more on that later…

Categories
Programming

Feedparser.py and it’s uses…

I recently discovered feedparser.py, a library written by Mark Pilgrim that is amazing if you want to use python to consume rss feeds. It ‘normalizes’ the different versions of rss/atom out there into one request that you can use consistently. Doesn’t matter if it’s atom 0.1 or 0.3

A few links that are interesting together with feedparser.py as they show it’s usage:

I’m constantly amazed about the quality python code that is out there and you can just find via a simple google query. It certainly makes me think that choosing Python over, say Perl, was a good decision.

As for using feedparser.py to put relevant tweets on your website, note that you can also use javascript to achieve the same thing; go here for some twitter.com goodies and an explanation on how to set this up.

Categories
Programming

Cleaning up user input variables on the web (Python)

Only recently I’ve discovered the power of ‘re’ the python regular expression library. Instead of writing long functions that process text character by character to add or remove stuff, you use re, write and expression in regex that achieves what you want and basta! in a few lines things get done.

For example the following function will remove any html tags (preventing Cross Site Scripting) and escape the rest of whatever the user types in:

# Remove html tags and escape the input
def scrapeclean(text):
----# This matches open and closing tags and what's between them
----x = re.compile(r'<&#91;^<&#93;*?/?>')
----# Replace to nothing using sub and escape what's leftover and return the result all in one line!
----return cgi.escape(x.sub('',text))

Remove the dashes when you copy the code – they were added to show the necessary indentation. And for full disclosure : I took the compile statement from the following site (I’m not a regex expert).

So you can call this function from somewhere in your python code and the result will be ‘scraped clean’ of all tags beginning with < and ending with > plus any ampersands other other special characters get to be ‘escaped’.

YMMV – this is very likely not a complete protection against all the things a hacker can input in your website, but it’s certainly a start.

Categories
Blog News

This made me think…

Lego as an example of what we are and can do
Lego as an example of what we are and can do
Categories
Apple Hardware

The MacBook Touch (mockup)

Yep. This is droolworthy.

MacBookTouch

Categories
Blog News Programming

AIR Badge plugins for WordPress take away all the hard work!

This is soooo cool.

Creating an AIR badge for an Adobe AIR application is a bit of a hassle, but the following 2 WordPress plugins really do take all the work out of it. Any post where you want to add an Air badge, you’re done in 3 minutes.

You’ll need either one of the following plugins:

– The Original plugin, made by Peter Elst, which is easy to use
– The Updated plugin with built-in click tracking (requires a bit more work)

I decided to use the original plugin, and you need to do just 3 things to use it.

  1. install the plugin (in your admin menu, just go to the plugin section and use the “search plugins” button to search for “air badge”
  2. upload your .air file to the server (if you want to use the wordpress “Add Media” uploader, you might also need to install an additional plugin called “PJW mime-config” and add .air to the list.
  3. create your badge by writing the following magic words between the words ‘airbadge’ : application name, full URL to .air file, application version, image.jpg

You’re done ! Admire your work (and that of the guy who made it possible, Peter Elst)!

Categories
Apple

Mac OS X 10.6.2 makes sluggishnes go away!

When I upgraded from Mac OS X 10.6.0 to 10.6.1, suddenly my 2006 iMac became a sluggish beast, trashing the disk for every little thing that it needed to do. Changing to another virtual desktop became 10 seconds of pure torture instead of a slick swish… At first I thought this had nothing to do with the upgrade, and thought my disk might be going bad.

Onyx, the all-in-one swiss knife of maintenance tools that I ran found out that I had a disk error. I fixed this by rebooting with the Leopard install disk and using disk utility there to correct the error. But my iMac kept being sluggish. Launching programs became an interminable wait (ok, ok, 10 seconds are not interminable, but they do add up in the long run when you want to get things done !)

Now that I upgraded to Mac Os X 10.6.2 things are suddenly running smoothly once again. I don’t know what happened, but they did something !

Categories
Programming

Python Package Manager

Python Package Manager Logo
Python Package Manager Logo

The Python Package Manager is here, a visual tool for the python developer to find and install all the necessary packages.

It shows you what is already installed on your system, with the option to deinstall the packages, and by typing into the search box you can find additional packages and install them, all graphically. It’s supposed to be cross-platform, but the homepage of the developer only provides a windows download option.

I just hope this gets used and keeps being supported, as it is a lot handier than using the command line ! I do think you still need easy_install and wxpython/wxwidgets though…