Idonix, a custom software development company specialising in show control systems, was engaged by a major UK broadcaster to provide data integration and graphics automation systems for their 2008 US Presidential Election coverage.
One of the requirements was to download and process substantial quantities of election result data from an Associated Press ftp server. Rather than write our own ftp synchronisation software, we found an existing product that fitted our needs exactly - WatchFTP. It was extremely straightforward to configure WatchFTP to download files as they were updated by the Associated Press systems, and not only that - we were able to use the Run a batch script action to bulk load each updated file into our SQL Server database.
However when we arrived at the customer's site we had an unforeseen problem... (read more...)