Thursday, August 10, 2006
On a slightly unrelated note, it is a big mistake for most companies to outsource customer service. Customer facing processes, particularly customer service, are sources of business intelligence on customers' needs and frustrations. Great pause must be taken when considering outsourcing or ignoring vital customer processes.
Tuesday, August 08, 2006
- Accept it
- Reject it
- Modify it
So what does it mean to ARM yourself? Well, one good step is to use the string cleansing functions of your programming language. Also, if a field is supposed to be a number then explictly convert it from a string to number.
I originally talked about this at the ACMSE-2006 conference in May. I will have to write up some more on the topic at a later date.
Wednesday, August 02, 2006
"SQL Converter for Excel is a tool to convert worksheets to real SQL database tables. First, you load and model your data as a familiar spreadsheet. Once you have the fields and data the way you need them, SQL Converter will help you build a SQL database table that can then be easily loaded into your MySQL database server
" (SQL Converter 2.0.3 BETA readme).
As the primary developer for the project, I am glad that the program is finally in the beta phase. It has been many years in the making as my attention has previously been divided among the web hosting business, my undergraduate coursework, and other work.
This first beta phase will last for at least a month. The feedback will be incorporated into a subsequent beta and then the final copy will be released. Early beta testers will be able to earn a free copy of the final release by materially participating in the beta. If you are interested in joining the beta testing program for SQL Converter, please let me know.