> Using MX anyone have any ideas on a really fast way to > convert a large (200-500k) cvs file into a CF complex data > type like a query or array? > > "Barry Manilow","Dr. Sholz","[EMAIL PROTECTED]"
CF5 came with the Merant ODBC driver for text files. I don't have a machine handy that has MX but never had CF5, so I can't be 100% sure they're still included with CFMX. If you have access to those drivers, they've VERY fast. I tried a variety of CF and CFX methods for reading and parsing a text file, but nothing has come even close to the speed of the Merant driver. Since it's an ODBC driver, you use CFQUERY like any other datasource; so it's automatically a query ready for you to use. I've used the Merant driver to parse CSV files up to 20MB in size, and CF has chugged though it without any problems. A 500k file should take only a few seconds to read in. Setting up the data format takes a little time as you need to create an INI file for the driver. You can use the ODBC control panel to setup the format semi-automaticaly. It's a bit less than crystal clear, but I found the helpfile for the driver had enough info to figure it out. Best regards, Zac Bedell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
