Skip to main content

Usage data being sent back

Youmustbejoking

I'm leaving my current company at the end of the month and there are many things that need tying up. One of these is how I get a load of raw data in Excel and import it into Sql Server. The task is extremely difficult to automate because of the crazy manner in which the data comes. The open nature of a spreadsheet means that it comes completely different each time we get it resulting in lots of messing about and vlookup pain to get it into a nice importable format.?

I want to record the task as a screencast so that anyone doing this task after I leave can see the sort of methods I use to format the data correctly. I've used BB Flashback Express in the past so I have just downloaded and installed this. During installation I was just really annoyed at the requests for desktop shortcuts, quick launch links and the like, topped off with a request to collect information on how you use the software. It's anonymous but who cares, we do I want a program that I will only use?occasionally?taking up desktop real estate and feeding information to the net? It's crap like this that ruins the PC for the ordinary user. Many people leave the defaults and click next for everything they do and within months their desktops are full of mad icons and their IE window is reduced to about 800 pixels high because of the 50 toolbars that have been installed. Not to mention their computers run like dogs because every program under the sun runs at start up and loves checking for updates. It makes me think the cleanness of the Apple apps must be the future. I love the easy in easy out nature of them and the sandbox they are forced to stay in.?

Anyway, morning rant complete.?

Comments

Popular posts from this blog

Creating star ratings in HTML and Javascript

I'd searched around a little for some shortcuts to help in doing this but I couldn't find anything satisfactory that included the ability to pull the rating off again for saving. I'd ended up coming up with this rather cheeky solution. Hopefully it helps you too! This is my first post in a while (I stopped blogging properly about 8 years ago!) It's strange coming back to it. Blogger feels very crusty and old by todays standards too.

Make your objects immutable by default

More about the Good Dojo In my post last week , I discussed creating objects that are instantiated safely. Please go back and read if you are interested. At the end of the post, I mentioned that I'd also written the class so it was immutable when instantiated. This is important!!! I feel like a broken record in repeating this but I am sure at the time of writing your code, you aren't modifying your object all over the place and so are safe in the belief that protecting against mutability is overkill. Please remember though, your code could be around for a hell of a long time. You aren't writing your code for now... you are writing for the next fool that comes along (including you) . Nothing is more upsetting that coming back to fix a bug on some wonderfully crafted code to say "Who has butchered my code?!", but often you were involved at the start of the process. You made the code easy to modify, allowing objects to be used / reused / modified without thi

An instantiated object should be "ok"

I've been QA'ing quite a bit of work recently and one common theme I've noticed across both Java and C# projects I have been looking at is that we occasionally open ourselves up unessacarily to Exceptions by the way objects are being created. My general rule of thumb (which I have seen mentioned in a Pluralsight video recently but also always re-iterate in various Robust Software talks I have done) is that you shouldn't be able to create an object and then call a method or access a property that then throws an exception. At worst, it should return null (I'm not going to moan about that now). I've created an example below. We have two Dojos, one is good and one is bad. The bad dojo looks very familiar though. It's a little class written in the style that seems often encouraged. In fact, many classes start life as something like this. Then as years go on, you and other colleagues add more features to the class and it's instantiation becomes a second