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….
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. :-(
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....
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)....
I won this in 2006. British Computer Society developer of the year...
My Good Friend Greg Pugh is blogging.
He's doing lots with the Go Programming Language. Exciting stuff.
Check out he's blogged here.
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 -
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….
Just interested. (and I may be asking for it).
Got a bigger Apple network than me? (you must have)
Firstly most impressed that I can now blog from my ipad courtesy of Blogpress.com
Self promoting my ios bin collections app for scambs.
- Posted using BlogPress from my iPad
Location:Cambridge Road,Waterbeach,United Kingdom
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