279 Days to Overnight Success

This is a great document, very informative, honest and a very easy read.

http://chrisguillebeau.com/3x5/overnight-success/

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

Software Updates

R10Clean 2.2.1
The grid Font and Size can now be changed using the onscreen controls.

R10Cipher 2.0.8
Minor Bug Fixes.

macVCR 2.4.1
Minor Bug Fixes.

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

Mac SQL Database Tool, Orac. Updated

Version 0.9.66 of Orac has been uploaded.

This version features the following updates.

You can now query any SQLite database. The window settings, stored servers and stored scripts for Orac are all stored in a SQLite file in the Orac directory, Orac_LocalCache.r10. You can view them using csh_win_main, csh_set_main and csh_sql_main respectively.

A text file containing a SQL query can now be dragged and dropped onto the SQL query input field.

The useless 'splash' window has been eradicated with extreme prejudice. What was I thinking ??

Many small UI tweaks.

I have had a number of requests to continue with my original idea to make this product work on Windows. I can do this but there are a few technical issues I would have to solve and to be honest I am still of the opinion that it would not be cost effective from a business perspective. Besides, the shift towards all things Mac continues ... ;-)

Sales have been very poor this week, although compared to the same period last month I am almost exactly at the same position, still - it's worrying, so next week will be mostly spent marketing :-)

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

Syntax Highlighter Module Released for REALbasic Developers

I released my Syntax Highlighter Module for REALbasic Developers today. The example application can be downloaded from http://www.rbtools.net/.

Download the Example Application to test the Syntax Highlighter with the supplied SQL Keywords file or alternatively your own Keywords file.

The Syntax Highlighter Module operates against any EditField in your REALbasic Application. As you type, your words are matched against a text file containing keywords, words that you wish to have highlighted in some way on your EditField, an example would be a SQL Query or a Language Editor.

Whatever you type in the EditField is highlighted if contained within your Keywords File. This text file can be easily created and then edited to include or exclude additional keywords.

The Syntax Highlighter is supplied as an Encrypted RB Module which you include in your own applications. There are no royalty fees involved.

The encrypted module and the unencrypted example application will be sent to you via email following purchase via Paypal from our website at http://www.rbtools.net. This encrypted module can be used in any of your projects without limitation or credit.

To use the Module within your own application, follow these simple instructions:

1. Create your text file of Keywords
2. Load the Keywords file (possibly at program startup) with the following code:
mSyntaxControl.LoadKeywordsFromFile(FILENAME)
3. Place the following code in the EditField TextChange Event:
mSyntaxControl.ChangeText(me,True,True,True,&c0000FF)
The Parameters are: (EditField, Capitals as Boolean, Bold as Boolean, Colour as Boolean, Colour Value)

Words within single or double quotes are not affected and neither are words that are part of another word.

A screenshot of the example program is shown below:



Updates to this module will be made over time as feedback comes in and as it is used in one of my own products I will no doubt be adding enhancements over the next few weeks / months.

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

Orac and ArtenSUITE Updates

Yesterday was an interesting day. My first task was to do some custom development in ArtenSUITE. Essentially the customer wanted to show his clients on a map with a different icon depending on the type of client (Broker, Individual, Manufacturer etc.) and a different colour depending on the status of the client (yellow = customer, red = on hold etc.).

I sweated on this for a while and then implemented the solution using Google Maps. The HTMLViewer control in REALbasic is very poor and while this caused a few problems I was able to win through in the end. It works well and I impressed even myself :-)

Having earned my corn for the day I decided to make some more changes to Orac my Mac OSX SQL Tool. These changes were based on tester feedback and have in my opinion made the product much better. Although in the early stages of development there does appear to be a lot of interest judging by the download statistics, although not yet much in the way of feedback.

The changes I made were as follows:

1. Enhanced Keyboard Support. If you turn on the 'tab to all controls' option on your Mac, you can now use the keyboard for most things in Orac.

2. The Results List now uses a clearer, larger font by default and if you adjust the font size the row height increases proportionally.

3. The UI has had a major re-design to make everything clearer and more accessible. The window size will now (just!) fit on a 1024 x 768 monitor.

4. The Stored Server setup now allows you to specify the particular type of database this configuration applies to.

5. A lot of behind the scenes work to make working with multiple types of databases and switching between them much easier and cleaner and from my point of view the code will be far more manageable.

You can see a few screenshots below:















www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

Orac: Mac OSX SQL Tool Updated

Orac Update
Version 0.9.6 of Orac is now available for download.

http://www.artenscience.com/autoupdate/latestversions/orac_osx.zip

This version works with Oracle 9i+, and will refuse to connect to an Oracle 8i database. Until I sort out the reason for the issues with 8i I decided it was preferable to not let the software connect at all. 8i support coming soon though :-)

In addition I think the Syntax Highlighting facility is working properly now, all the edge cases that I am aware of have been sorted.



www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

REALbasic Starter Kit

Today I made available the first release of my Starter Kit for REALbasic Developers. The version available for download is a very early 'proof of concept'. The idea came about through talking to associates and friends who are considering moving to REALbasic but dread the initial learning curve.


The RB Starter Kit executable demonstrates and documents a module of predefined functions that will mainly be of use to new and intermediate REALbasic Developers.


The idea at the moment is that purchase of the Starter Kit gives you the source code for the examples application. The module that performs the functions remains encrypted but can be used in any of your projects without restriction.


As well as the module that can be used within your own projects, the source code for the examples application can be used to learn how to do things such as automatically creating a local SQLite database to store the locations and sizes of all the windows in your application, how to populate and react to events on a Listbox Control, use of Toolbars, Menus Etc.


More information from here: http://www.rbtools.net

Orac Update

Version 0.9.4 of Orac is now available for download.

http://www.artenscience.com/autoupdate/latestversions/orac_osx.zip

There are a number of small improvements to this pre-release version, mainly the Syntax Highlighting when entering a SQL Query. You can choose for the SQL Keywords to be formatted as Bold, Uppercase or Coloured, or any combination of the three.

The keywords are derived from a simple text file that comes with the application, therefore additional keywords can be easily added/amended/deleted if necessary.

A screenshot is shown below. Click the image for a larger picture.



www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

R10Cipher 1.1 Free with MacFormat Issue 207 - May 2009

R10Cipher 1.1 is available for free on this months MacFormat magazine.

1.1 supports the easy encryption and decryption of text. Version 2 is needed if you wish to encrypt and decrypt files.

R10Cipher is Cross Platform and available for Mac OSX, Windows (XP,Vista,7) and Linux.

Owners of Version 1.1 are eligible for a 25% discount on Version 2. Contact steve@artenscience.co.uk for details.





www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

Arten Science 1st Quarter Sales Results

I thought it may be of interest to other small software companies if I were to share the results of my sales for the 1st Quarter 2009. I'm not going to show actual values, but you can nevertheless see the trend, which is an important factor given this 'worldwide recession'.

Here is a graph showing my first quarter of internet software sales:



Obviously I am pleased with these results given my lack of marketing budget, and lack of marketing in general. What is significant is that sales in 2009 far exceed 2008 which I believe is mainly down to the fact that I read, and more importantly put into practice some of the advice from Bob Walsh's excellent 'MicroISV Sites that Sell'.

One of the biggest changes I made was to create websites for my individual products, rather than lump them all within the www.artenscience.com website. This had made a big difference I believe. These seperate sites can still all be accessed from my main site but more importantly they now have their own domains as well.

www.protectclientdata.com
www.artensuite.co.uk
www.macvcr.com
www.oractotherescue.com
www.r10cipher.com
www.r10clean.com
www.r10vault.com

I intend this month to spend some time on further refining these websites and doing some marketing. We'll see what difference that makes :-)

How is everybody else doing ?

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development