MobileIron: Migrating iPads/iPhones Between Instances

As part of a european integration process we find ourselves wanting to move iPads and iPhones pointing to once instance of MobileIron to another. The reasons for this are long and complicated but suffice to say it has to be done and there doesn't seem to be any way to do it automatically (not such that the "old" server can be switched off at anyrate).This blog post is simply a series of steps necessary to migrate the servers. There is one "gotcha"...

Read More

OS X: Resolving UK Keyboard Issues with VMware Fusion

If you happen to be running OS X and using VMware Fusion to run Windows you'll be familiar with the issues regarding the default key-mapping used when you try and type text in windows. Of course if you're using a corporate Windows build (as I am) you get the additional fun of playing "hunt" the special key in password dialog boxes!Now if you check the VMware Fusion forums you'll notice that they're practically full of advice on how to fix this problem...

Read More

Updating NLS_LANG For A Windows Client Installation

Usually you'd expect your Client and Server environments to be in sync but there are specific issues when it isn't the case and this can lead to unexpected conversions when inserting text. We suffer from this issue as our server environment is in "American" whereas our clients are usually in "British".It doesn't cause massive issues but occasionally, especially with Oracle e-Business Suite, this can catch us out (typically it's due to it trying to...

Read More

Celebrating 30 Years of the ZX Spectrum

Well this is going to be a *slight* departure.I have been asked to contribute to an article (see here) on the 30th Anniversary of the ZX Spectrum by a local paper and this triggered a trip down memory lane (not to mention a wasted lunchtime looking through the Spectrum archive at World of Spectrum).Ironically I never actually owned a Spectrum having had parents who brought into the whole "BBC is educational, Spectrum and Commodore are for Games"....

Read More

Using iOS 6 Apple Maps "Report A Problem" Feature

As I'm sure you'll be aware Apple are experiencing a few problems with their brand new Apple Maps application for iOS 6 (see here for CEO Tim Cooks' public apology). One of the features of the new Maps application is a "Report A Problem" link, you can use this to report issues to Apple for them to fix - clearly they'll have a lot to do.Here's how to report an issue;First of all go to the location in Apple Maps which shows the problem you'd like to...

Read More

Apple Maps Comes To Bar Hill!

As I'm sure you're aware Apple have updated their iOS devices (iPad, iPhone, iPod) with iOS 6 which replaces the existing Google Maps with *new* Apple Maps which includes Turn-By-Turn navigation as well as a 3D view.Sadly the new Maps application is not quite up to the standard of Google Maps (in much the same way as an ant is not quite up to the height of a giraffe).Looking at Bar Hill Tesco is a good example of where this has not quite worked ......

Read More

SSRS: Scheduling A Report With 2008R2 (In SharePoint Integrated Mode)

In an ideal world you'd go to a report, enter your parameters, run the report, and a few seconds later you'd have all your data in the format you need. Unfortunately whilst going to the report and entering the parameters are (usually!) easy, the "few seconds" can quickly stretch to "a few minutes" and beyond before you get your data - particularly with some of the more complex GL-based reports.As most reporting is clyclical (month end, year end,...

Read More

Oracle R12 Lot Genealogy and Noetix

If, like me, you work in a process manufacturing* company one of the key things you need to worry about is lot genealogy. Put simply this is the process that a manufacturer uses to determine where the raw ingredients went. When you read about a product recall in the press this is the process the company will have gone through to trace where every product to be recalled went.Here's a simple diagram of the process;Simple Lot GenealogyAs is made (hopefully!)...

Read More

PL/SQL: Using R12 Item Open Interface Tables

I'm sure we won't be the only company to need to do a batch update of all the existing Items (in INV.MTL_SYSTEM_ITEMS_B) so I thought I'd share this. Basically using the interface tables and Concurrent Request allows you to make updates to the existing reports in a controlled (and Oracle Approved) way.I'm going to talk about doing an UPDATE but CREATE will work in pretty much the same way (for various reasons I'm not going to look at DELETE and I...

Read More