Jane's Technical Stuff

Wednesday, August 29, 2007

Nokia 6610 with IMAP


I've just got a Nokia 6610 (and very nice it is too) and have spent the last couple of days configuring it. As I have a months free internet usage (thanks Vodafone), I thought I'd make use of it. I set my email settings up (I use IMAP) and could send and receive emails, however, messages deleted from my IMAP server, weren't being deleted from my phone's inbox. This confused me for quite some time, and I couldn't find anything on the internet to help me so I fiddled with a few settings until I got it to work.

Within the E-mail settings section there are 4 options:
Connection settings - the incoming and outcoming options for the email servers
User settings - name, signature, new email alerts
Retrieval settings - what to receive (headers etc) and how many, IMAP folders to retrieve
Automatic retrieval - E-mail notifications and E-mail retrieval.

The Automatic retrieval details holds the key, it is badly described in the user manual as:
E-mail notifications — To automatically retrieve the headers to your device when
you receive a notification of new e-mail in your remote mailbox, select Auto-
update or Only in home netw.
E-mail retrieval — To have e-mail headers automatically retrieved at set intervals,
select Enabled, or if you only want headers to be retrieved in your home network,
select Only in home netw. Headers can be automatically retrieved for two
mailboxes at most. You can set on which days, at what times, and how frequently
the headers are retrieved in Retrieval days, Retrieval hours, and Retrieval interval.
E-mail notifications and E-mail retrieval cannot be active at the same time.


Quite frankly I didn't understand this when I read it first time, and I still don't fully understand it. What I do know, however, is that by choosing E-mail retrieval and setting it to "Only in home netw." a message is displayed on the screen which says "All e-mails are retrieved to mailbox when automatic retrieval enabled. Continue?" which led me to believe I was on to something. I set up some Retrieval days, hours and interval and then when chosing to connect a proper synchronise took place. I'm not sure if this is because some other settings behind the scenes were magically updated, or that this on its own was the key. To try and work this out, I set the E-mail retrieval back to disabled and re-connected and deleted emails didn't get removed, so I'm assuming that this is the key.

I'm not sure how much I want to use email on my phone, but I'm pleased to have worked out how to make it work.

Update:
More confused than ever. Whilst it worked once, and sync'd my mailbox, I then deleted some more emails from my server IMAP account and re-connected and nothing changed. New emails were received, but deleted ones didn't go away. However, if I delete an email from the phone inbox (and asking it to delete on the server as well) a proper synchronise seems to happen. This would appear to be the most reliable method currently.

Labels:

// posted by Jane @ 8:49 PM   save to del.icio.us

Comments:

iGoogle


I started using the iGoogle personalised home page quite some time ago now, and over time have configured it to have almost everything I need displayed on it. This is the screen that I have open on my browser the majority of my day at work, and it gives me a great view into everything that is important.

iGoogle

From top left to bottom right (going in columns) I use:

Every now and again I follow the Add Stuff link to see what is new. And whilst checking that link I've just gone and got distracted by the Ski and Snow Report gadget :-) - one to install in preparation for the big trip me thinks.

Labels:

// posted by Jane @ 6:16 PM   save to del.icio.us

Comments:

Thursday, August 23, 2007

Remember the milk


This time last year I read most of the GTD book and overhauled my existing todo management system (notes in diaries, tasks in outlook, email TODOs etc). After that and up until the beginning of the year I relied on monkeyGTD to help me keep track of what my team and I needed to do. I used it locally, on my desktop and kept backups etc and whilst it worked pretty well for me, it started to get pretty unwieldy due to storing all the tasks within the page itself, not to mention that it was only useful at work and didn't help me when I was at home (there is a password protected online version of monkeyGTD I could have used which would have overcome this issue) so I was still emailing TODO items to my work email address. So, not perfect.

Several months later, with a new (non management) job and tasks building up I decided it was time to move to a new tool. I knew that Paul was a devotee of Remember the Milk (rtm) and so thought I'd give it a try.

First impressions were good, with an easy to use interface allowing me to create as many or as few lists as I needed, with priorities, dates, repeating tasks etc and a handy getting started guide. I discovered an iGoogle gadget which allows an easy method of maintaining a task list. Being an iGoogle fan (there's a blog post coming sometime soon about why this is) this works well for me as the page is open in my browser window quite a lot of the time.

Not long after I started using rtm, they announced twitter integration and being a twitter fan I was totally sold. By linking up twitter to my rtm account, I can:

      add tasks to rtm by sending direct messages (d rtm). These get sent to my rtm inbox list. Parsing takes place so if I send a task "Buy milk today @7pm" it'll get added to rtm with an appropriate date and time reminder

      set up my reminder service in rtm to direct message me with tasks due - either daily reminders or the time based reminders

Having got my twitter direct messages going straight to my mobile phone, I get timely reminders sent to me directly. A fantastic combination of technologies.

Remember the milk have just started to offer a pro service, mainly to offer the chance for regular users to support the service, but there will be some new pro-only features according to the blog post. I've still only been using rtm for two or three months, but I'm already seriously considering supporting them as I'd miss it if it wasn't here, and I've been really impressed with their embracing of technologies (they implemented google gears support within days of it being released). In fact, I'll just add a task to rtm to reminder me to consider that in a months time if I'm still as impressed with it.

Labels: , ,

// posted by Jane @ 6:04 PM   save to del.icio.us

Comments:
Thanks for the recommendation for rtm. I signed up. I hope to use it from within Google Cal. Clive
 

Tuesday, August 21, 2007

SQL Server - Dynamic Order by clause


I was just asked a question about a way of making the order by clause in a query alter according to a variable without having to build up the sql query as a string and EXEC it.

After a bit of a play we got it to work using similar code to the following

DECLARE @intOrder INT
SET @intOrder = 4

SELECT *
FROM Customers
ORDER BY
CASE @intOrder
 WHEN 1 THEN CompanyName
 WHEN 2 THEN ContactName
 WHEN 3 THEN ContactTitle
 WHEN 4 THEN Fax
END

where CompanyName, ContactName, ContactTitle and Fax are all character columns.

There is a condition. The columns that are being potentially ordered by need to be of the same type, which means potentially casting columns. And of course, remembering that an integer may be of a different length to others and so needs to be padded to ensure that the comparison is appropriate.

DECLARE @intOrder INT
SET @intOrder = 3

SELECT *
FROM Employees
ORDER BY
CASE @intOrder
 WHEN 1 THEN LastName
 WHEN 2 THEN CONVERT(VARCHAR(20),BirthDate,121)
 WHEN 3 THEN REPLACE(STR(ReportsTo, 10), SPACE(1), '0')
 WHEN 4 THEN Title
END

where LastName and Title are character columns, BirthDate is a date - using format 121 to move it into ODBC canonical (with milliseconds) yyyy-mm-dd hh:mi:ss.mmm(24h) and ReportsTo is an integer

Labels:

// posted by Jane @ 12:11 PM   save to del.icio.us

Comments:

Wednesday, August 15, 2007

A busy Tuesday in Brighton


Last night was a busy night in Brighton, with an overlap between Flash Brighton - Jeremy Keith - Ajax : Flash Killer and £5 App Meet.

Seb and Jeremy

Richard and I managed to see some of Jeremy's presentation (which was excellent) before heading off to the £5 app to hear Tom Hume talk about the history of Future Platforms.

Jeremy presented on Ajax and how it relates to Flash, and effectively how there is space for both of them - Ajax is good for pages, flash is good for applications. We were shown a set of different sites and asked "Are they Ajax or not?" - Jeremy pointed to the ratings section on Amazon as a great Ajax example - small, discreet and works really well. Then we had to grab a cab and move on - any chance of seeing the rest of the slides sometime Jeremy?

Tom talks

Tom gave an excellent presentation about "The gritty reality of founding a software company", discussing the history of FP, the highs and lows, the lessons learnt - check for mobile coverage before renting an office when you're a mobile application provider - and of course the Pith!

Two excellent events, with excellent local speakers.

Labels: , , , ,

// posted by Jane @ 8:18 PM   save to del.icio.us

Comments:

Tuesday, August 14, 2007

TSQL: Get random rows


We needed to return a random subset of rows from a database, and someone pointed out the newid() function.

SELECT *
FROM Company
ORDER BY newid()


For the application concerned it works well, but as it says in Random Sampling in T-SQL "However, it's evaluated by the operating system, not T-SQL. In addition, while unique identifiers can be ordered, the comparison functions aren't documented. Unlike Rand(), NewID() has not been designed for use as a statistically valid random number generator." so it obviously must be used with caution.

Labels:

// posted by Jane @ 4:30 PM   save to del.icio.us

Comments:

Monday, August 13, 2007

Madgex Hackday II



Hackday in progress
Originally uploaded by Jane Dallaway
Last week saw the 2nd Madgex hackday. There were 6 teams, with 24 hours each, to work on a project of our own choosing. We were the biggest team of 5 people on the day and focussed on implementing a templating language for ASP.NET based around the concept of django's templates. Our hacking went well and by the end of the day we had a working subset of tags.

On Friday we all had to present our projects, and quite a wide range had been done from social policy research, a project documentation creator, a tool for deployments, a tool for managing the status of changes waiting to be deployed, and finally a table football webcam (so that the people on the other floors can check that the table is empty before appearing for a game). Our project won, and so we have custody of the cup until the next hackday.

All in all it was an excellent opportunity to work with different people and to investigate some new ideas. Thanks Madgex!

Labels: ,

// posted by Jane @ 9:53 PM   save to del.icio.us

Comments:
What? You have table football as well? I am soooo missing table football. *Sigh*
 

Brighton Bloggers   This page is powered by Blogger. Isn't yours?   rss Sussex Digital - focusing on the Sussex digital community