Sunday, 21 December 2008

Well it's that time of year again. I've just got back from setting up the Spanish offices for a customer of mine: Tailored Marine Supplies.

Much as I enjoyed the work, the climate, Sotogrande, the company and especially the last meal at the Argentinean restaurant - this has unfortunately meant that work on Sicuro has been parked for the last couple of weeks, hence this product is now scheduled to be released in January.

I'd like to wish happy holidays to all my customers, friends and everyone really. I'm not going to be working over Christmas although I will be answering emails.

Friday, 12 December 2008

A customer of mine has recently setup a new business dealing with tailored supplies for yachts and boats. The guys who have setup this company are all extremely successful businessmen who I have known for years.

The initial and primary focus of the company is on tailored bedding. Obviously the shape of the cabins in a yacht mean that the beds are not the traditional rectangular shape and so it is difficult and expensive to procure fitted bedding. Given the track record of the founders, the quality of the products and the effort that has gone into this I believe this is going to be an extremely successful venture.

My involvement with this venture is from the IT and software perspective. My ArtenSUITE Framework has been used to develop a suite of modules specifically for TMS.

All the products information, pictures and prices are setup and stored on my hosted database. ArtenSUITE is a Mac OSX and Windows Client running locally, it is only the database that is remote. This works extremely well as TMS are based in Spain, I am in the UK. They need to run the software, I need to maintain it and back it up. The online ordering website also pulls all it's information from this hosted database and save quotes and orders back to this database.

Thursday, 11 December 2008

Version 1.0.0 of DataClean has been released for Mac OSX, Windows and Linux.

DataClean is a Cross Platform Utility designed to make it straightforward to ‘clean’ large amounts of data. Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS), TAB Delimited and Comma Separated. You can also save the modified file using your own Custom Delimiter.

DataClean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action DataClean provides Tasks that you can apply to the data grid.

Tasks include:

Remove Leading SpacesRemove Trailing SpacesRemove Leading and Trailing SpacesRemove TextRemove Selected Row(s)Remove Text from Start of ColumnRemove Text from End of ColumnRemove Text Before ...Remove Text After ...Replace TextFind TextInsert at the Beginning of the ColumnInsert at the End of the ColumnInsert Blank RowFormat as UppercaseFormat as LowercaseFormat as Capitalised

DataClean is a Cross Platform Utility designed to make it straightforward to ‘clean’ large amounts of data.

Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS), TAB Delimited and Comma Separated. You can also save the modified file using your own Custom Delimiter.

DataClean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action DataClean provides Tasks that you can apply to the data grid. Tasks include:

*Remove Leading Spaces*Remove Trailing Spaces*Remove Leading and Trailing Spaces*Remove Text*Remove Selected Row(s)*Remove Text from Start of Column*Remove Text from End of Column*Remove Text Before ...*Remove Text After ...*Replace Text*Find Text*Insert at the Beginning of the Column*Insert at the End of the Column*Insert Blank Row*Format as Uppercase*Format as Lowercase*Format as Capitalised

We are looking for feedback as to what additional features and / or tasks you think should be available within DataClean. All suggestions are welcome.

DataClean is a Cross Platform Utility designed to make it straightforward to ‘clean’ large amounts of data. Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS).

DataClean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action DataClean provides Tasks. For example; within the Remove Action there is the Task ‘Remove Trailing Spaces’.The Preview Version of DataClean is Framework complete, but at the moment has few Tasks. I am looking for feedback as to what you think should be available within DataClean.