Error importing CRC into MySQL 1.1RC on Ubuntu 10.04

[ethanwhite]

The following error occurs almost immediately when trying to import CRC using the new deb install:
Error:(1054, "Unknown column 'estimated' in 'field list'")

[ethanwhite]

Also occurs importing into SQLite (Error: no such column: estimated). This is particularly strange since a search of the src indicates no uses of "estimated" in any of our files.

[ethanwhite]

Wow, I so should have had a second cup of coffee this morning. This only popped up because I had an old scripts folder with the CRC script in it and I didn't even think about the fact that CRC needs proprietary data. Closing.

[bendmorris]

This is a legitimate issue caused by a bug in the way the Retriever handles strings that contain quotes and multiple consecutive blank fields in an Excel file. The Retriever has changed but this script hadn't been touched in almost a year so it needed some updating. I'm not reopening because those problems have been fixed.

[ethanwhite]

Apparently randomly clicking on things while half awake has it's benefits :)