Blog Stats
  • Posts - 151
  • Articles - 0
  • Comments - 36
  • Trackbacks - 0


Monday, December 15, 2014

NAV Odata Update


So I’m please to report that my project to get Dynamics NAV ODATA hooked up to an iOS application has worked (written in SWIFT).

I’m using the JSON formatter from NAV,  which makes things nice and light-weight.

A gotcha to point out, is that you can’t combine entity queries and JSON formatting in one single call.


http://YOURSERVER/OData/Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Cambridge'

To make a query return in JSON format you need to add



http://YOURSERVER/OData/Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Cambridge'&$format=json

It wasn’t obvious from the documentation that you needed to add in an extra & between parameters.   When pointed out, it looks straight forward, but I struggled with this….

Monday, April 14, 2014

JSON Odata, baby steps

So this is what I feel are some really constructive steps for next gen. mobile. Allow your App. to talk to your backend datasource via OData. I've spent a tonne of hours trying to make a combination of SQL Sever, .Net 4.5 all try to agree this is the way forward. Tonight, they are all not sharing the same vision. :-(

Saturday, January 11, 2014

SQL Server Compact; what gives!!

So I have many a customer using SQL Compact offline replication, you know like cool mobile apps. that just work offline (like they need to in real life). Last blog post on the Microsoft Embedded Technology Blog, was 4 years ago. I guess we all must have a permanent go anywhere Internet Connection now....

Saturday, January 4, 2014

CRUD for all?

CRUD, or Create, Read, Update, Delete is what you do with most databases or when working with a new bread of cloud based services (well all Dynamics products). However. I think we should not exclude Execute (i.e. run stuff). So I propose we extend the acronym to CRUD(E)....

Monday, December 23, 2013

A little Self indulgence...

I won this in 2006. British Computer Society developer of the year...

Go Greg Go

My Good Friend Greg Pugh is blogging. He's doing lots with the Go Programming Language. Exciting stuff. Check out he's blogged here.

Saturday, November 30, 2013

iBeacon at Home

Like a faithful dog,  greeting you when you get home.   I’d like my house to greet me every time I walkthrough the front door( I do have faithful dogs too, but that’s another story).


Well my house does this now…

I’ve added a Bluetooth low energy USB adapter to my Raspberry PI.     I went for -

A Bluetooth LE dongle


I followed the Radius networks instructions to turn the Pi, into an iBeacon.

I struggled a little with the instructions for scripting the start-up of the iBeacon.

I found this command line invaluable to debug what is going on.   Open a second terminal window on your pi and run -

sudo hcidump

This is a bluetooth monitoring tool, it helped get things up and running.  

My start-up script had to include the long hand instruction to broadcast a signal from the Beacon.    Which is (a scary looking line of codes) -

sudo hcitool -i hci0 cmd 0x08 0x0008 1e 02 01 1a 1a ff 4c 00 02 15 e2 c5 6d b5 df fb 48 d2 b0 60 d0 f5 a7 10 96 e0 00 00 00 00 c5 00 00 00 00 00 00 00 00 00 00 00 00 00

This seemed to be the only way to get things to work correctly.

So once done,   I then used the Radius’s iBeacon locate software on my iPhone.   Link here -

Download for iOS

Download for Android


Behold!,   my iBeacon is broadcasting,  and as I approach my home (literally this is cool,  I like drive up to my house),   I get a popup message indicating that I am in range/arriving home.


Next to write an app.  or your Passbook, to-do something with this new found power….

Friday, April 19, 2013

Apple Networks

Just interested. (and I may be asking for it). Got a bigger Apple network than me? (you must have) IMG 0021

Monday, March 25, 2013

Super stylin

Firstly most impressed that I can now blog from my ipad courtesy of

Self promoting my ios bin collections app for scambs.

- Posted using BlogPress from my iPad

Location:Cambridge Road,Waterbeach,United Kingdom

Thursday, January 3, 2013

Excel ODBC on OSX, Connect to SQL Server

Oh goodness. What a shocker. How hard can it be, to simply make Microsoft Office Mac (Excel) connect to Microsoft SQL Server. I've spent the last 2 hours being told to go spend $xx to go buy ODBC drivers and stuff. In this respect MS 1, Apple (or maybe Microsoft nil/NSNull) 0. I have finally arrived at - Which does the job, quite nicely, costs $xx (check it out); however bit of a fluff. But I guess this is what it takes to keep hi-tech. firms thriving. + Happy New year


Copyright © Richard Jones