yadUK

Effective Information System Solutions

Skip to: Content | Sidebar | Footer

Category: Blog

Use Javascript to find which render mode browser is in

28 April, 2009 (07:14) | Reference | By: john

When designing pages utilising CSS for their styling and splitting the semantic content away in an attempt to move legacy systems into the dot com era it might be necessary to show why kicking a browser into CSS Compatability mode might be a good idea. Not least that you can …

Interactive BATCH file with DEBUG script

26 April, 2009 (14:38) | Reference | By: john

Still sometimes need to use batch files to do stuff even in this day and age? Yes, is the usual answer but, unfortunately many of the standard errorlevel checking tools such as CHOICE etc. have either been removed or cannot be used without administrator access in Enterprise environments.

It’s not …

Hyperion Essbase -> Excel -> Access -> automagic

25 April, 2009 (17:52) | Reference | By: john

Accessing Hyperion Essbase is no problem directly from their MS Excel plugins. Though what happens if one wants to import on-the-fly and put that into MS Access so you can deliver your MI: Management Information, alongside current data without having to analyse and alter Hyperion Essbase output in Excel before …

find – what you’re looking for and more

6 April, 2009 (08:05) | Linux CLI | By: john

Using find on the command line as su is a great way to remove spent sessions from your /tmp directory for instance.

find -user theusersname -delete

Will remove all instances of that users files. A great quick way to clean up after a rogue application in development.…

Change word in all files in directory (+recursively)

4 April, 2009 (08:00) | Linux CLI | By: john

These commands will replace all instances of ‘foo’ with ‘bar’ in all files in the current working directory and any sub-directories.

Current Directory:
sed -i s/foo/bar/g *

Recursively:
find * -type f -exec sed -i s/foo/bar/g {} \;

Task Bar Glomming (grouping)

20 February, 2009 (07:34) | Reference | By: john

Found yourself in a strictly locked down Windows desktop environment? Hate those sodding grouped windows on the taskbar and can’t get rid of them? Try out the below code by saving in a .vbs file and double-clicking to ungroup your windows. To group again, just re-launch the script.

There are …

Export Excel to HTML

20 February, 2009 (04:35) | Reference | By: john

Having found on more than a few occasions that MS Excel’s output to HTML is more than a little bloated and not very editable I needed a way to output clean HTML markup to a simple shared folder area.

This was originally used in Excel 97 and has not been …

Lerwick Boating Club

6 August, 2008 (19:52) | Projects | By: john

 The Lerwick Boating Club has over the last 25 years changed from the days when it only organised summer sailing races and a regatta in Shetland. Today, in addition they have yacht races, dinghy races, a yoal team and lots of training sessions for beginners and junior members.

 

[edit]…

HBOS: Corporate Finance & Planning – 2

9 June, 2008 (18:36) | Projects | By: john

This was a continuation of previous contract from November last year again involving many differing Information System (IS) processes to achieve final products.

Projects included Lead Developer role to new-build database driven Business Intelligence & Management Information reporting tools; Corporate Intranet sub-websites;

  • Intranet based be-spoke interactive Intranet Mangement Information Dashboard

Anderson Solutions

1 January, 2008 (19:55) | Projects | By: john

Anderson Solutions offers a comprehensive range of specialist consultancy services. Their research and facilitation services “support high quality decision-making in the creation and development of economic development initiatives” with each project “tailored to meet the specific needs of the client”.

Anderson Solutions is based in Edinburgh and is active throughout …