Spectacular Phone at a spectacular price!

I had to purchase a new phone in December 23. My Nokia 6.2 Android phone had served me well but was starting to drop calls and lose messages.

Frankly, being the tight arse that I am I refuse to pay too much for a phone. 

My requirements:

Costs less the AUD$300

Android 12+

Be from a reputable manufacturer.

After researching different brands, I settled on the Aspera R10 (running Android 13) from the Australian company Aspera.

While Aspera are better known for their "seniors" phones they do have a solid reputation.

The Aspera R10 is a rugged phone, targeted at people who work in environments where a smartphone is subjected to heat, dust and water (e.g. Electricians, plumbers etc). 

After nearly a month's use of the phone I have to report that the performance is brilliant, the screen very easy to read, the cameras are good, and the battery life is excellent.

The link to the phone and its specifications: 

Aspera R10 Details

The biggest difficulty is finding a retailer who sells the phone. I purchased mine from an eBay retailer called gadget.point - it was delivered promptly and was in the official shrink-wrapped box from Aspera.

For a robust inexpensive yet powerful phone I'd strongly recommend the Aspera R10.

 

Heritage City Locksmith Online with etouch4!

On July 2^nd,

Heritage City Locksmiths,  

Maryborough QLD 

(our great beta testers) went "live" with etouch4

Adding 25% to their bottom line, improving productivity and automating invoicing.

Some key benefits

• No lost docket books
• Job cards are electronic
• Attach documents to jobs
• Simple single click invoicing
• Maximum flexibility for staff and control for supervisors

Some key features; Job creation and tracking
On the road with any smart phone	Back Office
Instant update of back office Invoicing and simple billing Signature capture Upload photos and documents Optimised for productivity Email or print invoices Integrated to Google maps	Create quotes in minutes Transfer quotes to jobs Track staff locations Simple job creation Simple invoicing (email or print) Review and amend Jobs

For more information go to www.etouch4.com

Heritage City Locksmiths www.heritagecitylocksmiths.com.au

Why Brother is not a bother.

I was recently asked the question, "Why do you offer a discount for clients if they use a Brother printer?".

"Less pain", was my response. I've found that in over 26 years of providing IT support that printers are often the devices that cause the most pain. Printers are often an afterthought and not considered important in IT installations, until, of course, you need them!

Brother HL-L2375DW

Brother MFC-L9570CDW

Of course, if I really want to reminisce I can reflect back to the pain of programming (the then super fast!) 9600 baud modems using the command prompt on DOS computers or dealing with the weird cabling diagrams for some of the concurrent DOS terminal boards. Thankfully, there's a lot less "grind" in IT today. 


One of the companies that have constantly made life a bit easier for IT  (when it comes to installation and use) is Brother International.

Not that I spend too much of my time thinking about printers, but I really like Brother printers because they just work. They're reliable and they last a very long time and somehow survive in some appalling conditions. Next time you walk through a warehouse or a mechanic's workshop, the odds are that you will find a Brother printer or fax machine. Through the layers of dust and the heat, these printers somehow just keep on keeping on!

Brother QL820WB

Brother FAX-2950

Next time you're waiting at reception, have a look, in many offices, you'll notice a Brother QL series label printer. 

Why are they so popular? It's because Brother supplies their proprietary P-Touch® software which is VERY EASY to use P-Touch® even integrates with Microsoft® Excel and Word and is very reliable. 

Brother has a range of labels for most situations and environments. Did you know that in hospitals and nursing homes these printers are so popular because get this, you can label beakers, dishes etc and put them in the dishwasher? Here's the thing, the labels don't fade!!! Everything from mailing/address labels through to tagging of electrical cables. Really practical solutions to everyday problems (I mean who sits around thinking of this stuff??).

If you're a developer or someone with some programming skills you can download the Brother Software Development Kit (SDK) that will allow you to programme direct interaction with the QLs. Even better yet, give Brother a call, they may have a solution available from a partner company (such as mine!).

On top of all this, on the rare occasion that you need it, Brother's support is second to none! In Australia, Brother has one of the best support teams I've ever encountered. Fortunately, I'm not on first name terms with them as I haven't had to call them often enough for us to establish a relationship!

So, less pain is worth a lot to me. A great deal. I don't enjoy spending my time dealing with Printer issues (Windows® updates are enough of a pain).
When I install a printer I don't want to spend an hour on Google trying to find some obscure driver for some printer that probably should never have been manufactured! 

Brother RJ-3150

Here's the amazing thing, Brother have installers for Apple, Android, Windows and get this, Linux! You may think "who cares?". Well I do because I run two PCs with Linux, in my household, we have Apple, Android, three flavours of Windows and yes Linux (Xubuntu). The engineers at Brother must be real geeks, and that's a fantastic thing! Their quality control team must be right on top of everything because I have never, let me repeat NEVER, had a Brother installation fail on me.


If you have clients who need to print out on the road, even just occasionally, check out Brother's mobile print range. The mobile printers range from A4 (yes you read that right A4!) through to 50mm. They have most situations covered! You can actually purchase perforated A4 paper rolls for the A4 printer, with a neat protective roll case! Imagine, the Brother engineers sit around thinking about this stuff "How can we make this work out in the field?" and that is priceless!

Brother PJ-773

So, back to the original question. "Why?" It's simple, "less pain". In fact, Brother also has a programme to work with software developers to provide integrated and enhanced printing solutions. 

Life is too short to waste configuring printers. So yes, I charge less to clients with Brother devices, because there's no pain for me.

The NAS that's more than a NAS

When is a NAS (Network Accessible Storage) device more than a NAS?

When it's a Western Digital DS5100.

I've just finished an evaluation of the WD Sentinel DS5100, courtesy of our colleagues at Western Digital and I'm blown away.

At a Western Digital presentation just prior to Christmas 2013, I got to see a number of WD devices in action. 

Initially, I was just interested in the Linux based My Cloud EX4 units. Great for backup and storage and some very clever applications. 

Normally, a software developer doesn't have a strong interest in NAS devices. However, on this occasion as I read through the specifications of the Windows Server 2012 DS5100 and DS6100 it occurred to me that these NAS devices were much more than storage devices.

After some email discussions with Simon Whitford from Western Digital about the possibilities, Simon sent a DS5100 for us (my colleagues at Brother and myself) to evaluate.

The specifications

The unit tested was the WD Sentinel DS5100 (code : WDBYVE0040KBK ). I'd class this unit as an entry level machine. For greater capacity take a look at the WD Sentinel DS6100.

Operating System	Windows Server 2012 R2 Essentials
CPU	Intel® XeonTM E3-1220LV2 2.3 GHz Dual Core Processor
RAM	8 GB (Upgradable to 32gb)
Disk/s - AV HDD	320gb - for operating system
Disk/s - iSCSI	2 x 2TB (upgradeable to 4 x 2TB)

The DS5100 has the capacity for 2 AV hard disk drives and 4 iSCSI Drives. More information is available on the Western Digital website about the expansion capabilities of the device.

Set-up/Installation
Installation was fairly easy. Using a spare monitor (VGA connection) and a usb keyboard and mouse I set-up the DS5100 with the 2 x 2tb drives configured as RAID 1 (mirrored disks). The Windows Operating System is loaded on the AV HDD drive.

Purpose
The purpose of the evaluation was to see which software packages would work, test that it was possible to install the Brother printer drivers and ascertain as to whether the DS5100 could act as a terminal server.

Obviously not everyone will want  to run the programmes tested within this environment. All of the installed programmes ran and performed with no issues.

Installation Sequence

Software	Version	Type	Notes
Microsoft	SQL Server 2012	Database Engine	Installed the full suite of (except Local DB) including SQL Management tools. Requires some patience as a number of downloads occur
Thinsoft Inc	WinConnect Server ES (64-bit)	TS Software 5 user trial version	Installation was straight forward and works as expected. Transforms the DS5100 into a full blown Terminal Server
Oracle	Virtual Box	Virtual Machine (Windows 8.1 pro 64 bit)	Installed and tested using a Virtual Box copied from Ubuntu 13.10.
brotherPOS	brotherPOS POS	Single User Version	No Issues - runs as expected
brotherPOS	brotherPOS POS	Network Version	No Issues - runs as expected
Soft Velocity	IP Data Server	IP Data Server	When installing make sure that all of your DLLs are provided
Soft Velocity	Clarion Application Broker SE	The Application Broker features a hi-performance multi-threaded socket engine, built-in SSL support, runs as a Windows Service, and has a remote administration interface. The appbroker allows Clarion Developers to enable and run applications over the web. see www.softvelocity.com for more details	In this evaluation the drive I used for applications was the D: drive - the drive letter may vary in other installations To install and configure this service you need to undertake the following. 1. Install to the Raid enabled Drive 2. If using secure login search and edit the registry setting where the drive letter is incorrect. 3. Server Firewall a) Allow the port/s b) Allow the executable (as at writing c60aps.exe in the D:\ClarionAppBroker\ folder). Under 64 bit Windows systems you need to locate and run c60aps.cpl as an administrator to configure the port
Printers	Details	Device Type	Notes
Brother	HL2250DN	Network	Recognised and installed via Windows Update
Brother	J6910 MFC	Network	Recognised and installed via Windows Update
Brother	TD-4000	USB	Downloaded Windows 8 64 bit driver then installed using the manual printer installation process
Other	PDF CREATOR	Software Printer	Downloaded and installed - no issues

Summary

This is a fantastic device. The performance is superb and the footprint is extremely small. Beyond its use as a NAS, the DS5100 would make a great server for any business requiring a low profile, reliable, quiet and very fast data server.

If your data and business activity doesn't need to rely on reliable, responsive and fast response times then the DS5100 is not a cheap machine. 

However, if your data is valuable to you and you see your investment in IT infrastructure as an investment, then you will find the DS5100 gives value for money performance.

We'll be offering the WD DS5100 (and DS6100) as a server to our clients. 

The performance using Microsoft's SQL Server (I'm thinking very useful for CRM and large accounting systems), was extremely fast for connection and data retrieval. In addition the server software (IP Data Server & Application Broker) from Softvelocity performed extremely well. Although the Clarion Application Broker is relatively old technology the response times from the DS5100 were the fastest I've seen for some time.

Installation of the Thinsoft WinConnect product was very easy and performed exceptionally well.

Virtual Box: I use Virtual Box for development. I can't envisage anyone wanting to use this in a business environment (I'm open to being corrected on this). Needless to say, performance was brilliant.

I know that Western Digital designed the DS5100 to be a high performance NAS. As a NAS it shares files and performs as expected. To be honest, if I was only interested in a NAS I'd look at some of the other Western Digital devices such as the My Cloud EX4. In fact you could actually have a number of WD devices on the network to meet all of your needs.

I really like the idea of "My Cloud". I've written before on the cloud and its over-hyping. Western Digital have come up with a solution that allows you to build your own cloud. The advantage is that you know where your data is and how it's being managed.

Okay, here's a list of where I think the DS5100 as a server may be suitable (you may see additional possibilities).

Business/Industry	Notes
Retail Point Of Sale	Because of its small footprint and low profile, the DS5100 would be ideal in a retail situation as a discrete server. Add in the Thinsoft WinConnect software and you've got a server that's accessible in-house and from off-site. With our brotherPOS point of sale you can have Tablet ordering as well as our standard POS approach.
Database Server	The insane performance of the DS5100 means that where you need to add a new SQL Database server you'll get real bang for buck out of this device.
Wholesalers	Most wholesalers have limited office space, need another server for your inventory system? The DS5100 is ideal due to its robust design and small profile.
Supermakets	Reliable, fast and small profile. Add in Thinsoft WinConnect and the manager can log in any time to see how the business is performing
Terminal Server	Need a small departmental terminal server? Then the DS5100 becomes a very low cost device. With Thinsoft's WinConnect you can attach any device that supports RDP.

Clarion IP Driver and Multiple Clarion IP Servers

I had a need to attach to two different Clarion IP Servers simultaneously. The documentation refers to the ability to do this. However, the documentation is really discussing how to change file names, not addressing multiple servers at the same time. Not what was needed.

The IP Extender templates will enable a number of powerful IP DRiver/Server functions but not what I needed in this instance.

To do what I wanted I needed to make a minor adjustment to the IPDRV.TPL template file.

Changing the IPDRV.TPL file

Step 1

Backup it up!

As you can see;  lines 159,160 , 172 & 173 are commented out of the standard Template Code.

The effect :- by commenting out these 4 lines the IPDRV::OWNER Global Variable no longer replaces all Owner Attributes. The beauty of this approach is that if you have no need to access more than one IP Server leaving the Owner Name attributes blank in the dictionary will still result in IPDRV::OWNER as the default variable to enable connection.

Things to know

It’s not possible (as far as I can tell), to have two files with same label open at the same time. No surprise, as it’s not possible in non-IP enable applications either.

The process I went through...

Step 1

Create the Global Variables you’ll use instead of IPDRV::OWNER (The default variable)

In my case I’ve created a separate Group called IPDRV in my dictionary.

As we’re trying to replace the default IPDRV::OWNER variable I suggest that we create the variables with the same attributes.

Leave the “generate last” option unselected as the application will need to have the Global Variables used defined/generated prior to the file declarations.

Step 2

Copy the table structure/s (either to a new dictionary or into an existing) from the second (or third) dictionary that you’re going to use. Since my application is only able to use a single dictionary (I believe this is true of all Clarion applications), I needed to make sure that the data structure matched the structure used in the original dictionary.

Step 3

In the Owner Name  attribute enter the Global Variable to be used preceded by the ! (exclamation mark).

 

Save and exit.

TIP :-  Leave the Owner Name blank if this table is going to be accessed via the default IP Server.

Step 4

Generate the Data Manager DLL - this will create/update the IPS file for your IP Driver enable application.

Step 5

Open your Application

Step 6

Assign the values required to the Alternate Global Variables. I’ve done this in the Program Setup  after the   “Assigning IPDRV::OWNER” embed.

TIP : - Don’t forget to provide the default IPDRV::OWNER values in the IP Driver Client Global Template extension

You could store the details of the alternate IP Servers in an INI file a local file or even in an IP Server Table.

Summary

These simple changes in the IPDV.TPL  Template file extend the power of the IP Driver/Server combination without changing the more common default single IP Server.

In our case we needed to have two different applications communicate a small subset of their data between one another.

This ability allows you to at the minimum

• Roll your own registration server using the IP Driver/Server
• Create Data Connectors between servers where the data resides on different IP Servers

Disclaimer

Please note that I have not yet assessed the full impact of these changes on the other aspects of the IP Driver/Server environment.

Clarion IP Driver and MS SQL Server

.

Clarion IP Driver and MS SQL Server

Normally when you create a Clarion programme that accesses  an SQL Server you would define the details of the connection string in the owner field of the dictionary properties for the table.  This can be hard coded or a variable.

One of the issues that’s been a problem with the Clarion IP Driver/ Server has been the inability to change the sql connection string at runtime.

By exhaustively checking various options I have found a solution that appears to work and allows the programmer to change the SQL Connection string at runtime.

Tip - Don’t define the variable as part of the dictionary’s global variables.

In my example I’m using a variable called servervariable (this is defined in the data dll global as a string)

IP Driver Variables

To change variables on the Clarion IP Server you will need to define the variables (global) in your IP Data DLL. In addition you will need to allow them to be accessed/changed by the IP Client Application (to do this you will need to use the extended features of the IP Driver)

You will need five variables in all (of course you can use names that are meaningful to you)

ServerVariable String - use this as the owner attribute for the sql table/s

DBServer - String/Cstring - the details/name of the SQL Server

DBDataBase - String/Cstring - the name of the SQL Database

DBUsername - String/Cstring - the user name to be used to connect - in my case I created a separate user clarionipserver in the SQL Server for the Clarion IP Server to use for connection

DBPassword - String/Cstring - the password used to access the SQL Server

* Optional - you’ll need a variable for the DBport if you’re not using the default SQL TCP/IP port of 1433

IP Data DLL

In the IP Data DLL after creating the variables, using the IPDRV Extended options make the variables available for the IP Client Application

IP Data DLL - Embed Point for concatenating the variables and assigning to the ServerVariable

Global Embeds > Program Setup > after Extended Options Init

Pass the values to the ServerVariable here.

That’s all that’s required for the Data DLL, next the IP client will need some settings defined.

IP Client Application

In the IP client application you’ll need to check that the IP Data DLL variables are available. This is available as a global extension - IP Client - IPDRV Extended  

Assigning the variables

There are many ways you can store and retrieve the data to assign to the variables;

INI File, Local Data File, TPS File on the IP Server and many other options.

In my testing I decided to use an IP Driver enabled TPS file to store the details for the SQL Server. TIP - makes sure you open and retrieve the data from this file and set the variables on the IP Server prior to opening the SQL Table

Setting the Variables on the IP Server from the Client

To set the variables you can choose to use the IP template extension “set remote” Clarion IP Driver and MS SQL Server

In the example I call the Data settings table to retrieve the variable data after the open files embed in the Main procedure. (I’m not opening the SQL Table until I select a browse containing the data).

Things to know

Trying to set the ServerVariable on the IP Client doesn’t work. The IP Server appears to treat the comma separated values of an SQL connection string as different parameters and only takes the first value (the SQL Server Name)

Make sure that the SQL Server security settings allow the SQL user you’ve defined for the IP Server are valid and have the correct access attributes

Changing SQL Servers and  SQL Databases has been tested and works.

Why Use SQL and IP Driver?

There have been a number of discussions around this. We have a number of IP Driver apps that sit well in the small business/commercial space. In this instance a client needed to have client details imported in real time from their MS SQL based CRM.