Coldfusion MySql Importing a CSV file
Posted on 2009-05-25
I have an ongoing need to automatically import CSV files into MySQL and am running coldfusion.
The CSV files are fine because when I view them in Excel the columns line up perfectly.
When importing with coldfusion however, the records that have commas inside the actual data field are screwing up the process.
In addition, to separate data fields it uses quotation marks, so when a field has quotes that messes up not only the columns, but also causes all data to convert from just the normal data to having everything encapsulated in quotes.
I am not getting the csv files in a way that i can restrict what data they contain, nor can I get them in any different format, so no solution will work that involves opening up the file and "escaping" the troubling characters. They need to be 100% importable as they sit.
Is there any way to accomplish this at all?