Recent Entries

Ben Mullay – Shetland Photography

ben-mullay

Ben Mullay is continually looking to create eye-catching and striking images to convey what is viewed through the lens. Ben’s home village of Bigton, Shetland, is the site of the famous St Ninian’s Isle, reputably the largest tombolo in Europe.

 
XHTML, CSS, PHP, MySQL
Hosted by yadUKHosting
goto site http://www.benmullay.com/

Business benefit of ensuring fit for purpose presentation layer

“What exactly is the business benefit of doing that?”, a cry oft heard.

Well, what exact business benefit is there for not ensuring the presentation layer is ‘fit for purpose’? To build a “web” based application meeting all specific requirements and policies in regards scalability and the like – then ignoring its output “just because” it does what it does and appears on the surface to render as it should …. ?

Folllowing modern techniques, ensuring your presentation layer is split against semantic markup and seperate styling gives the ability to alter the way an applications output looks and feels merely through editing CSS stylesheets in the presentation layer. Business benefit? You don’t have to raise the same level of change requests and prioritise development work to back-end developers nor do you have to ensure you’re within a release schedule several months away – where the focus will be on ensuring business layer upgrades requested by the business take first priority! Nor is there a need to edit deep down in the business layer at what are most likely multiple points to alter inline styling.

A benefical frontend development strategy creating real cost savings

Why? Because, it can be done by front-end developers and can be done in a fast turnaround with next to no cost leaving backend developers prioritising and developing workstreams providing “real” long term business benefit without wasting precious effort and time! User interfaces can be improved/tweaked adhoc providing end-user centric benefits when required without conflicting with underlying business logic or data storage.

For instance, improving end-user input without additional requirements of backend error-checking and processing by simply altering the user interface can pay dividends further downstream! Improved data quality and removing the need to re-key information or use generally poor scrub & match automation delivers on-the-ground business benefits through no cost. The only definite requirement is to ensure alignment of a presentation level release schedule that fits with the programmatic release.

Making certain frontend web industry standards are applied is a forward planning strategy producing real cost and time savings!

Photoshop – The memory could not be “written” error

Bizarrely I couldn’t figure out why my version of Photoshop CS3 was playing up and dumping me out with a dialog box proclaiming that memory at some segment couldn’t be referenced and giving me a “The memory could no be ‘written’” error.

Well, it’s definitely not the fact that my profile was stuffed though refreshing it did for a little while give back control of Photoshop. A colleauge pointed out that how he had solved his same issue was to choose a different default printer! Which amazingly does the trick?!

So is it the RICOH Alficio MP C3500 PCL 6 printer, or the fact that it’s on a shared queue? Not entirely sure but not having it as default does the trick!

Use Javascript to find which render mode browser is in

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 position elements as you see fit and can move away finally from table based layouts.

Though how are you physically able to show a change having taken place to management other than through overkill style demo pages or pointing with your finger ..? Using the below code by simply pasting it into the URL address bar and launching by pressing the enter key, you will receive a dialog box detailing which CSS rendering mode you are in.

BackCompat = Backwards Compatibility (quirks mode)
CSS1Compat = Standards Compliance mode.

Quick and simple! This hidden Javascript browser gem and further great insights can be found at quirksmode.org “for all your browser quirks”. A fantastic resource on all things browser based!

Interactive BATCH file with DEBUG script

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 always entirely wise either to install compiled errorlevel tools into an Enterprise environment. This will potentially go against an application or network policy or you’re just plain unable to.

The below batch file instead is self-contained outputting a DEBUG script before compiling it and utilising it to check for user input. This it utilises within the demo. Save the text down to a textfile and give it the extension .bat

It is an extension of and use of the following Microsoft support site example - Accepting Keyboard Input in Batch Files. Note that there should be a backslash after %temp% and before the word REPLY which is being stripped out by this parser.

Hyperion Essbase -> Excel -> Access -> automagic

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 exporting to textfile format or CSV before manipulation?

Well, why not try the below code!

The below function run within MS Access will write an “Essbase connection plugin” before instantiating a copy of MS Excel to run Essbase from. Unfortunately if you don’t write out and pull in the textfile to create a module in Excel as is within the code Microsoft’s security permissions now deny access. Give them their due – it was a good move for certain issues.

After the “plugin” is pulled into the MS Excel workbook it fires a connection to Essbase and in this case draws down and partitions the relevant info to worksheets. Note the code will require setting up against whatever Essbase fields you require from your system.

The code as you will see at the bottom will clear down any previous retrieval before using MS Access’  TransferSpreadsheet import functionality to pull in the retreived workbook. The code also requires a table within MS Access to hold your Hyperion Essbase login details. In this case the table is called tbl_essbase_credentials and can be seen within the code. The Excel workbook is cleared down and you are left with your Hyperion Essbase MS Excel retrieval in your MS Access database.

Way to go!

So the process from MS Access is to run function and -> create a module for import into MS Excel -> start a virtual copy of MS Excel -> import the module into the virtual copy of MS Excel -> run virtual module to connect to Hyperion Essbase and download required data -> save MS Excel workbook and transfer the spreadsheet into MS Access -> clean up. All from within MS Access!

find – what you’re looking for and more

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)

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 {} \;

Azureus Vuze Streaming to PS3

Always wondered how to get Azureus (now Vuze) to stream to your PS3? I’d seen the icon on the PlayStation numerous times but had never figured it out nor had I found anything on t’Internet either. Then poking in around Vuze the other day I clocked the following:

Tools > Options > Plugins > Media Server >”Checkbox – Publish Media to Local Sever”

Now has that always been there? Probably … ? Who knows? Anyway, it works and you can stream your torrents as long as they’re compatible with the PS3. Those from Vuze; Matroska MKV containers, don’t normally play without remuxing etc. etc.

I do have issues however, with a 1080p XViD download, very jumpy and basically unwatchable. Now to find out about optimising ;)

Task Bar Glomming (grouping)

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 other more complex variations out there such as those found at http://www.kellys-korner-xp.com/xp_tweaks.htm but this script simply hits the nail on the head.

Export Excel to HTML

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 tested in later versions though will most likely work fine.

Lerwick Boating Club

 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]
Reboot of the Lerwick Boating Club Website
[/edit]

(previous – 06/06/2006)
To reflect this they required a re-vamped site from which they could easily update their pages and news through a web based interface. This was achieved by providing a PHP / MySQL based CMS system.

The top image on the site was obtained from www.panphotos.co.uk – specialists in producing high quality panoramic photographic prints and images of Shetland and further afield.

XHTML, CSS, PHP, MySQL
Hosted by yadUKHosting
goto site http://www.lerwickboatingclub.co.uk

HBOS: Corporate Finance & Planning – 2

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 fed from business accessible MS Access database driven backend fed to Intranet SQL Server XML driven Flash/JavaScript frontend;
  • Intranet Leadership Commitment web portal;
  • Web enabled risk data integrity checker;
  • MS Access based reporting tool for IFRS7 data display of entire Corporate balance sheet;
  • Basel II compliance reporting application with full Corporate balance sheet drill down;
  • Be-spoke Corporate Cost Allocation model for entire Corporate book and associated reporting built in MS Excel;
  • First Corporate web enabled Debt Instrument drilling tool;
  • Ad-hoc Business Objects Reports;

Tools used included:

HTML, CSS, JavaScript, MS Access, MS Excel, XML, VBA, Business Objects

Anderson Solutions

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 Scotland and England. Clients include the Scottish Government, Local Authorities, NGOs, Enterprise Companies and Private Enterprise.

XHTML, CSS,  JavaScript, Custom PHP, MySQL
Hosted by yadUKHosting.
goto site http://www.andersonsolutions.co.uk

HBOS: Corporate Finance & Planning – 1

Intranet development and client-side web enabled applications development.

Excellent contract involving many differing Information System (IS) processes to achieve final products.

Client-side web application utilising Internet Explorers Data Island technology to hold source and data bind dynamically built resultant data for on-screen viewing. Heavy use of JavaScript to build dynamic search drop-downs and to traverse the DOM of an XML source document held within a source XML Data Island.

Utilised JScript to traverse the dynamic result display for exporting via ActiveX to Microsoft Excel. XML Source document built from 6+ Business Objects reports output; manipulated; cleaned; and combined within a bespoke MS Access database before exported to XML.

Creation of a Intranet “Portal” for the Business Intelligence department within Corporate Finance & Planning.