Community Member Profile
- Profile: /members/7767-Dharm-Kumar.htm
- URL: http://blog.daksatech.com
- Comments: 3
- Points: 31
Recent Blog Comments By Dharm Kumar
-
Parsing CSV Data With ColdFusion's CFHTTP Tag
Posted on Mar 17, 2011 at 4:21 PM
@Lawrence, to get cfhttp to work with a https url, you will first have to import the SSL certificate into CF. See: http://kb2.adobe.com/cps/400/kb400977.html... read more »
-
Parsing CSV Data With ColdFusion's CFHTTP Tag
Posted on Mar 17, 2011 at 4:17 PM
Another limitation with using cfhttp for parsing csv files is unicode files. if you specify charset="UTF-8" or any other utf encoding, you will get "The column name is invalid" errors. To overcome this you have to specify getasbinary="yes" as an attribute.... read more »
-
UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()
Posted on Feb 9, 2011 at 4:05 PM
I had to perform a similar task on a project couple yrs back wherein users could upload a csv file (fields in any order) and map it to DB fields. I used Microsoft text driver to read the text file. Basically I created a datasource in CF Admin pointing to the folder containing the csv files.
