Group,
I have written a rather simple report to indicate pages on the site that have
not been updated within a specific time span. I am outputting this report to a
CSV file. The entire process works, but when I click the link to the generated
report, only the first two lines are displayed
I would assume you are doing a loop to generate the CSV content. Are you
adding CHR13 to the end of each line?
Robert Harrison
Director of Interactive Services
Austin Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788
T
: RE: Odd CSV Results
I would assume you are doing a loop to generate the CSV content. Are you
adding CHR13 to the end of each line?
Robert Harrison
Director of Interactive Services
Austin Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I Hauppauge, NY
Good. Glad it's solved. I've done a lot of CSV files and they do seem to work
well once you get the syntax correct.
Robert Harrison
Director of Interactive Services
Austin Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788
T
/desktop/ms709353(v=vs.85).aspx
Byron Mann
Lead Engineer Architect
HostMySite.com
On Aug 30, 2013 10:46 AM, wrote:
Ok, I have more information about this problem.
In the CSV file, if I replace all semicolons by commas, it works perfectly.
The problem is that, either under W 7 or W 2008
I finaly found the problem:
When you open the ODBC Administrator, you first select the database you want to
update,
you click on configure, you see the name of your datasource, fine,
then you click Options, you still see the name of the datasource you are
configuring,
then you click Define
You might try passing delimiter=';' as an additional dsn parameter.
BINGO!
The problem is that the file Schema.ini is not properly updated by the 32 bit
ODBC Administrator.
In my W 7 file I see Format=Delimited(;) which is correct, but in the W 2008
file I have Format=CSVDelimited
I set
Ok, I have more information about this problem.
In the CSV file, if I replace all semicolons by commas, it works perfectly.
The problem is that, either under W 7 or W 2008, it seems that one can set the
delimiter and some other format parameters in odbcad32.exe, but they are not
saved anywere
Hi,
since I moved my applications from a 2003 server to Windows 2008, I have a
problem reading a database defined on a .CSV file through the ODBC socket
driver.
The problem seems to be with the ODBC driver.
I have the 32 bit version of CF installed an I use the odbcad32.exe 32 bit ODBC
thanks very much, it worked
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
unusual request I know, I have a CSV file with lots of rows but it has no
column headings. Is there a way of inserting a row at the top of the file (1st
row) with the heading names?
any help would be appreciated. thanks
Unusual request I know, I have a CSV file with lots of rows but it has no
headings, is there a way of inserting a new row at the top of the CSV file with
some heading names?
Any help would be greatly appreciated.
~|
Order
a CSV file with lots of rows but it has no
headings, is there a way of inserting a new row at the top of the CSV file
with some heading names?
Any help would be greatly appreciated.
~|
Order the Adobe Coldfusion Anthology now
at the document object. On the action page, a query is
generated and fed to a custom changeQueryToCSV(query) function. Ultimately I
want the user to be able to view (in Excel) and/or save the resulting .csv to
their own pc.
I use this at the bottom of my action page to make it happen:
[code]
cfcontent type
Modify http://cflib.org/udf/QueryToCSV2 to use or chr(9) (a tab
literal) as the list delimiter.
Alternately, add delimiter as an additional argument, then you can use
it for both CSV and TAB.
Cheers,
.jonah
Thank Jonah
I am using this one:
http://cflib.org/udf/QueryToCSV2
So you
to specify a date time automatically in Excel
from a CSV file opening. If someone knows, please let us know.
--
Thanks I was able to format the data. It works now.
Any suggestions on creating a TAB file in CF?
~|
Order
On 11/4/2011 11:39 PM, Torrent Girl wrote:
On 11/4/2011 8:59 AM, Torrent Girl wrote:
Hi All. I need to give users the ability to download a CSV and TAB
file. While I found a neat little function to create a CVS file
(http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am
having
as date.
I don't know a way to specify a date time automatically in Excel
from a CSV file opening. If someone knows, please let us know.
--
Thanks I was able to format the data. It works now.
Any suggestions on creating a TAB file in CF
Modify http://cflib.org/udf/QueryToCSV2 to use or chr(9) (a tab
literal) as the list delimiter.
Alternately, add delimiter as an additional argument, then you can use
it for both CSV and TAB.
Cheers,
.jonah
Here's the one I'm using:
/**
* Convert the query into a CSV format using
Hi All. I need to give users the ability to download a CSV and TAB file. While
I found a neat little function to create a CVS file
(http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a
problem with dates values.
Here is my date: 6/20/2009 7:15:03 PM but in the file
Are you seeing that value in Excel? What do you see if you open the CSV
with a text editor like Notepad?
On Fri, Nov 4, 2011 at 7:59 AM, Torrent Girl moniqueb...@gmail.com wrote:
Hi All. I need to give users the ability to download a CSV and TAB file.
While I found a neat little function
On 11/4/2011 8:59 AM, Torrent Girl wrote:
Hi All. I need to give users the ability to download a CSV and TAB file.
While I found a neat little function to create a CVS file
(http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a
problem with dates values.
Here is my
Are you seeing that value in Excel? What do you see if you open the CSV
with a text editor like Notepad?
yes when I open it in excel. When I select the column in excel I see the true
value.
~|
Order the Adobe Coldfusion
On 11/4/2011 8:59 AM, Torrent Girl wrote:
Hi All. I need to give users the ability to download a CSV and TAB
file. While I found a neat little function to create a CVS file
(http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am
having a problem with dates values.
Here
I've been using the following code for years with no problems on
IE,FF,Safari to force the download of a CSV file that will be associated
with and opened by Excel:
cfheader name=Content-Disposition
value=attachment;filename=myExport.csv charset=utf-8
cfcontent type=application/vnd.Microsoft
Have you tried using this mime type instead?
application/msexcel
On Mon, Dec 6, 2010 at 1:42 PM, Brook Davies cft...@logiforms.com wrote:
I've been using the following code for years with no problems on
IE,FF,Safari to force the download of a CSV file that will be associated
That works in every other browser (that I tested..) except Chrome. Chrome
just downloads the CFM template...
-Original Message-
From: Rick Root [mailto:rick.r...@gmail.com]
Sent: December-06-10 10:50 AM
To: cf-talk
Subject: Re: CFHEADER on Chrome to download an Excel CSV / Mime Type
: Re: CFHEADER on Chrome to download an Excel CSV / Mime Type problem
Have you tried using this mime type instead?
application/msexcel
On Mon, Dec 6, 2010 at 1:42 PM, Brook Davies cft...@logiforms.com wrote:
I've been using the following code for years with no problems on
IE,FF,Safari
Thanks, but it is not that simple.
I have plenty of things to check, convert, validate, etc.
Don't forget an Excel file is created and filled by humans ;-)
I would figure out a way to use my RDBMS to handle this. Navicat or SQL Server
tools to do it.
Then clean the data or whatever once it's
I agree using something like Navicat to load the data would be a much better
solution, but if you must use code, then I would parse those table names and
replace all of the bad characters and spaces before creating the tables.
Special characters and spaces just cause too many problems to even
Another way to do this is read the file, loop thru the lines and massage the
data as wanted when inserting into the database. This way you can have better
control on the data manipulation.
cfloop file=#expandPath('.')#\sampledata.csv from=1 index=line
cfquery name=qi datasource=#mydsn#
On Thu, Oct 21, 2010 at 1:03 PM, Ketan Jetty kje...@yahoo.com wrote:
Another way to do this is read the file, loop thru the lines and massage
the data as wanted when inserting into the database. This way you can have
better control on the data manipulation.
cfloop
If this is MS SQL you can do this as well.
Thanks, but it is not that simple.
I have plenty of things to check, convert, validate, etc.
Don't forget an Excel file is created and filled by humans ;-)
~|
Order the Adobe
Hi,
I have to create a new database from a CSV text file.
I have an ODBC datasource defined for the CSV file and I can read the file with
a query like:
CFQUERY NAME=getMembers DATASOURCE=Import
SELECT * FROM membersImport.csv
/CFQUERY
The problem is that column names have blanks and special
I've tried getMembers['Région administrative'] but it
causes an error.
Did you forget the row number or is that typo?
ie
queryName[column name][ rowNumber ]
~|
Order the Adobe Coldfusion Anthology now!
Did you forget the row number or is that typo?
Actually, I'm in a loop on the query, I thought the row number would be
implicit as usual.
But you're right, queryName[column name][queryName.currentRow] does work.
This is kind of weird since queryName.columnName works, bur not
This is kind of weird since queryName.columnName works, bur
not queryName[columnName]
I guess the difference is queryName[columnName] gives you access to the
column array. I thought it was strange at first too. But realized it is a good
thing, since it allows you to access values in any row
To get this to work, I had to do something really hokey.
I created an Access database, and used a linked table to the actual text file.
Works great.
And no, I am not proud of this solution...
~|
Order the Adobe Coldfusion
on the network. It collects magnetic
stripe scans to a CSV file located on the server. I need to get this into
a SQL Server db ideally.
I created the ODBC text data source on the server.
When I attempt to add the data source in the ColdFusion administrator, it
tells me:
Connection
I have a badge reader that hangs on the network. It collects magnetic stripe
scans to a CSV file located on the server. I need to get this into a SQL Server
db ideally.
I created the ODBC text data source on the server.
When I attempt to add the data source in the ColdFusion administrator
On Wed, Sep 15, 2010 at 9:29 AM, Rick Root wrote:
Unfortunately, using your code (except using createObject instead of
javaloader, as I have the library in CF's classpath), I get the same
error.
Here's a function that uses opencsv http://opencsv.sourceforge.net/ 2.1,
another CSV http
On Thu, Sep 16, 2010 at 12:04 AM, Paul Hastings p...@sustainablegis.com wrote:
On 9/16/2010 2:45 AM, Rick Root wrote:
http://www.opensourcecf.com/1/2010/09/Example-of-using-JavaCSV-CSVReader-class-to-read-CSV-files.cfm
pretty sure the numeric columns for csvReader are 0 based (ie 1st column
Use the JavaCSV library to read and writing CSV files with coldfusion.
You'll NEVER have to worry about parsing CSV files again =)
This java library handles all kinds of things like this. Dealing with
CSV files in coldfusion can be a real pain in the ass once you start
dealing with files where
BTW in my own interest, having never actually used the CsvReader class
(only the CsvWriter class), I started to attempt to write some sample
code...
Unfortunately, this is as far as I got :)
cfset filename = test.csv
cfset fileInput = createObject(java,com.csvreader.CsvReader)
cfset
If I recall correctly, I experienced problems when using just a file name as
well. But was successful by using constructor using the filename, delimeter,
and charset. I hope you can see what changes you're need from the code below
which works within the context of my app but doesn't work on its
Unfortunately, using your code (except using createObject instead of
javaloader, as I have the library in CF's classpath), I get the same
error.
On Wed, Sep 15, 2010 at 10:52 AM, Dorioo dor...@gmail.com wrote:
If I recall correctly, I experienced problems when using just a file name as
well.
file not found message. try full path
to
CSV file.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http
On Wed, Sep 15, 2010 at 1:01 PM, Paul Hastings p...@sustainablegis.com wrote:
your error looks like a poorly worded file not found message. try full path
to
CSV file.
Yeah, that was it.
And yes, VERY poorly worded =)
Rick
Okay, I wrote some sample code and tested it for using JavaCSV to read
a CSV file.
http://www.opensourcecf.com/1/2010/09/Example-of-using-JavaCSV-CSVReader-class-to-read-CSV-files.cfm
My test file didn't have headers so this just generically dumps the
csv into a very generic query.
Rick
On 9/16/2010 2:45 AM, Rick Root wrote:
http://www.opensourcecf.com/1/2010/09/Example-of-using-JavaCSV-CSVReader-class-to-read-CSV-files.cfm
pretty sure the numeric columns for csvReader are 0 based (ie 1st column is
referenced as 0 not 1).
yes, i'm too lazy to register on your blog
I have the following data...
bb0a0933-85d4-44be-a72c-25aa759c603f,3782049,DirectMail,63933-8188,The
form ProgramForms has been rejected because of the following reason:
bb0a0933-85d4-44be-a72c-25aa759c603f,3782049,DirectMail,63933-8188,The
form (Application Form) has been rejected because of the
In Windows a line feed is actually #chr(10)##chr(13)#. However, if you
remove those you will probably remove ALL line feeds in your file instead of
just the double line feed that is causing you problems. This can be tricky,
but you will probably want to look for
Try Chr(10) also like:
cfset newcsvfile = replace(csvfile, '#chr(10)#', '', ALL)
I just had to do that with a message digest that wasn't being verified
correctly,
Phil
On Tue, Sep 14, 2010 at 1:17 PM, Phillip Vector
vec...@mostdeadlygame.comwrote:
I have the following data...
No need for the extraneous pound signs.
cfset newcsvfile = replace(csvfile, chr(10), '', ALL)
On Tue, Sep 14, 2010 at 1:26 PM, Phillip Duba phild...@gmail.com wrote:
Try Chr(10) also like:
cfset newcsvfile = replace(csvfile, '#chr(10)#', '', ALL)
I just had to do that with a message
On Thu, Jun 3, 2010 at 2:35 PM, Paul Henderson wrote:
This solution worked for me:
http://www.bennadel.com/blog/1903-Parsing-CSV-Data-With-ColdFusion-s-CFHTTP-Tag.htm
I've done that in the past with some success. It all depends on how
good the data is. GIGO, ja know?
There's a long
I'm trying to import a comma delimited CSV file using cfloop
file=filename.csv, but some records contain commas and they are throwing
everything off. I can't seem to figure out how to replace the in-field
commas without messing up the delimiter. Any ideas? Thanks in advance.
-Paul
There is absolutely no reason to parse a CSV document manually; there
are myriad tools for exactly this purpose. A quick Googling will turn
up a pile of options. You may need to tweak them if your file is
enormous and must be processed line-by-line, but even then you should
be able to use
Any delimited file that has delimiters contained within a field is
supposed to use a text qualifier. For CSV, the most common qualifier
is double quotes, so your file would look like:
1234,field 1,my big field, that has a delimiter or two, but is qualified
If there are not text qualifiers
Thanks for the replies, it seems like I'm taking the wrong approach.
Currently I am using a cfloop to loop over the file, then
#listgetat(FileLine,1)# to reference each field.
cfloop file=C:\CSVs\2010-05-21.csv index=FileLine
cfset record_type = '#listgetat(FileLine,1)#'
/cfloop
This solution worked for me:
http://www.bennadel.com/blog/1903-Parsing-CSV-Data-With-ColdFusion-s-CFHTTP-Tag.htm
On Thu, 03 Jun 2010 14:27:08 -0400, Paul Henderson
p...@smashedvision.com wrote:
Thanks for the replies, it seems like I'm taking the wrong approach.
Currently I am using
I have a CSV that looks like the following...
3270,5101650,Dewey, Cheatum Howe , 0 , 0 ,0.00,0.00,9.25,-9.25
3270,5101650,Phillip Vector, 34 , 3,161.00
,92.97,79.25,61.76,17.50
3270,5101650,James P. Kardone JR., P.C. , 0 , 0 ,0.00,0.00,9.25,-9.25
I'm stuck on how
Use a CSV parsing library, rather than rolling your own. They take
care of all that stuff for you. I've used
http://ostermiller.org/utils/CSV.html in the past.
If you really want to parse it yourself, you can use listToArray, and
then iterate over the array and combine items that are quoted
Simply define an ODBC datasource using the Microsoft txt ODBC driver.
Then requst the datasaource to get all records.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
Defining another datasource is not allowed in this. Yes, I know it's
easier to do it that way, but unfortunally it's not an option here.
On Tue, Dec 22, 2009 at 9:17 AM, Claude Schneegans
schneeg...@internetique.com wrote:
Simply define an ODBC datasource using the Microsoft txt ODBC driver.
On Tue, Dec 22, 2009 at 9:09 AM, Barney Boisvert bboisv...@gmail.com wrote:
Use a CSV parsing library, rather than rolling your own. They take
care of all that stuff for you. I've used
http://ostermiller.org/utils/CSV.html in the past.
I took a look at that and didn't see anything
Defining another datasource is not allowed in this.
What database(s) are you using?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Oracle, but I do not have permission to set up another datasource. So
I need to do it by coding.
On Tue, Dec 22, 2009 at 9:24 AM, Leigh cfsearch...@yahoo.com wrote:
Defining another datasource is not allowed in this.
What database(s) are you using?
Quoting is part of standard CSV, Ostermiller will take care of it.
But you don't need to loop over every character. Once you have your
array, you start combining when you find an item that begins with a
quote, and you stop combining when you find an item that ends with a
quote. In my example
Ok.. I see what you are saying... Thanks. :)
On Tue, Dec 22, 2009 at 9:26 AM, Barney Boisvert bboisv...@gmail.com wrote:
Quoting is part of standard CSV, Ostermiller will take care of it.
But you don't need to loop over every character. Once you have your
array, you start combining when you
Oracle
Okay. I was thinking there might be options with an MS datasource. But as that
is out of the question, I would go with Barney's suggestion. (Looks
interesting. I will have to try it myself).
~|
Want to reach
[ '],
multiple spaces) that it shouldn't, but would happily export the CSV anyway.
DATA,BELLS WHISTLES, 'MOATS'; dragons ~ and gypsies ,more data
I found out the app used the systems regional delimiter just like Excel does
and a simple system change let us export it as PIPE (|) delimited.
I
I have a need to write the output from aquery to a csv file without headers.
I've seen many examples where you can write the output from a query to a CSV
file. However
most of the examples I've seen require that the file be created first with
headers and then then
ourput from the query
=ColdFusion_Documentationfile=0246.htmwrite
will create the file
append will add to it
2009/12/9 coldfusion.develo...@att.net
I have a need to write the output from aquery to a csv file without
headers.
I've seen many examples where you can write the output from a query to a
CSV file. However
most
)#,#TRIM(ed_email)#, And so on
/cfsavecontent
Cffile write=c:\blah.csv output=#trim(csv)#/
You can't use html (like br) in a csv.. Instead you use actual line breaks
(chr(10) or chr(10)chr(13) for windows). But the code above will add those
because they are created when you code and hit enter
append will add to it
2009/12/9 coldfusion.develo...@att.net
I have a need to write the output from aquery to a csv file without
headers.
I've seen many examples where you can write the output from a query to a
CSV file. However
most of the examples I've seen require that the file
Hi I have an old fusebox app i am working on. it outputs a csv file with data
however the html (layout) is also getting added to the csv? anyone know why.
cfsetting enablecfoutputonly=yes
cfscript
function cleanField(sField){
sField = (replace(sField,,,;,All
What version of fusebox is it?
You should be able to swap or suppress the layout around the csv content.
-Original Message-
From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk]
Sent: Friday, December 04, 2009 9:12 AM
To: cf-talk
Subject: fusebox layout adding to csv?
Hi I have
Oh, hell.
...
cffile action=write file=#ExpandPath('csv.htm')# output=/table
:-)
On Thu, Oct 1, 2009 at 3:01 PM, Ian Skinner h...@ilsweb.com wrote:
John,
I need help with one another thing.
I have a header and footer template which I need to use when I generate the
html.
How do I use
Oh, hell.
John,
I need help with one another thing.
I have a header and footer template which I need to use when I generate the
html.
How do I use it. could you please provide me a sample?
Thanks
This is really basic stuff. I suggest you read up on cfinclude here
Oh, hell.
Thank you John, will try this out. ;-)
Another option is to use the file attribute of cfloop as in
cfloop
index = i
file = absolute path and filename
Do your html stuff here
/cfloop
hth,
larry
~|
Probably 10 ways to do this. Here's one:
1. read in the csv file with cffile:
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_f_07.html#3545217
2. use this to make it into a query: http://cflib.org/udf/CSVToQuery
3. use this to dump the query as a table:
http://cflib.org/udf
ways to do this. Here's one:
1. read in the csv file with cffile:
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_f_07.html#3545217
2. use this to make it into a query: http://cflib.org/udf/CSVToQuery
3. use this to dump the query as a table:
http://cflib.org/udf
John M Bliss wrote:
cffile action=read file=#ExpandPath('csv.csv')# variable=thiscsv
cffile action=write file=#ExpandPath('csv.htm')# output=table
addnewline=true
cfloop list=#thiscsv# index=thisline delimiters=#Chr(10)#
cffile action=append file=#ExpandPath('csv.htm')# output=tr
Oh, hell.
...
cffile action=write file=#ExpandPath('csv.htm')# output=/table
:-)
On Thu, Oct 1, 2009 at 3:01 PM, Ian Skinner h...@ilsweb.com wrote:
John M Bliss wrote:
cffile action=read file=#ExpandPath('csv.csv')# variable=thiscsv
cffile action=write file=#ExpandPath('csv.htm')#
Oh, hell.
...
cffile action=write file=#ExpandPath('csv.htm')# output=/table
:-)
On Thu, Oct 1, 2009 at 3:01 PM, Ian Skinner h...@ilsweb.com wrote:
Thank you John, will try this out. ;-)
~|
Want to reach the ColdFusion
Hi,
I am a newbie to CF and I require help on this asap as I have to finish it
before noon today.
I have a CSV file which I have to read and write the output as HTML. This is
because we would get this update twice a year and hence have to read and write
as HTML.I was told.
The CSV file
Probably 10 ways to do this. Here's one:
1. read in the csv file with cffile:
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_f_07.html#3545217
2. use this to make it into a query: http://cflib.org/udf/CSVToQuery
3. use this to dump the query as a table:
http://cflib.org/udf
Awesome, that did it. Thanks a bunch Peter and have a great weekend.
You've got:
cfoutput query=qMembers
[content]
/cfoutput
Which is:
cfoutput query=qMembersNEWLINE[content]NEWLINE/cfoutput
Hence why you're getting empty lines.
You need your content to start on the same line
I've spent days trying to set up a simple export to a .csv file with no luck.
cffile keeps saving it in html format so I'm using another solution I found
online. It seems to work a lot better than cffile, but when I open the .csv
file in MS Excel, every other row is blank. When I open
You've got:
cfoutput query=qMembers
[content]
/cfoutput
Which is:
cfoutput query=qMembersNEWLINE[content]NEWLINE/cfoutput
Hence why you're getting empty lines.
You need your content to start on the same line as the opening cfoutput, or end
the tag on the same line as the content.
I've updated my server with the http://kb2.adobe.com/cps/406/kb406660.html
hot-fix as I want to use the YouTube API.
The problem is that a simple use of CFHTTP to read a .csv file that used to
work no longer does. I get an 'Attribute validation error for tag cfloop' when
I try to loop over
Hi everyone,
I have a CSV file I need to take the values out of and update a database with
them. Any suggestion or best ways to do this?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
file (the .csv file) for its data. Performance will be MUCH better
than read and parse with CF, and gives you the advantage of working with the
data just like you would with any other recordset. I use this for a regular
35,000 record data import and it takes minutes compared to hours using
I have a program - very simple to query a db and geta result set and save to a
CSV verything seemend to work OK initially but when I run the program now I
keep getting a message cannot download the .cfm file.
Here is the code.
cfquery name=getUsers datasource=#request.AppDS#
SELECT *
FROM
If you get rid of cfconent then load the page in a browser does it
render as a normal CF page such that if you view source you see
exactly the content that you expect to see in a CSV file?
If it is a text file then use a regular line break instead of a BR tag.
-Mike Chabot
On Wed, Nov 5, 2008
Geez, I always just use the cffile tag with the write and then append
actions. and you can access a .csv through the web, so you can just use
that extension.
Rob
On Wed, Nov 5, 2008 at 8:20 PM, Mike Chabot [EMAIL PROTECTED] wrote:
If you get rid of cfconent then load the page in a browser does
I am trying to figure out how to update a sql table using a CSV file that has
commas in the data fields. The long and Short of it, is that we have a SEO
company rewriting our keywords, meta descriptions and titles for our product
database. We were able to build a simple CSV export so
or some other identifier) data that contains the delimiter,
like this:
[EMAIL PROTECTED],Joe,Smith,Joe, John Sons Inc.
Then you need a data import routine that can correctly handle that. Most of
the ColdFusion CSV handling code I come across does not handle this very well.
-Ryan
if
the data does not conform to your requirements, or only import the rows
that do conform, and notify the user of the rows that were not imported.
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Michael Grove wrote:
I am trying to figure out how to update a sql table using a CSV file
Hi,
I'm trying to set up CSV datasource in CF 8. Looking at CSV data
sources on some older CF instances (MX), I see the driver used is the
ODBC Socket. When I try to do something similar in CF 8 the ODBC DSN
drop down is blank, so I cannot finish configuring the data source.
Any ideas? Thanks
1 - 100 of 788 matches
Mail list logo
