CSV to Query
Anybody have a UDF for this? I need it sharpish, I can write it myself but if someone else has done this.. whooho! Much apreciated -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CSV-to-Query
Greetings! I am struggling with the notion of trying to query a CSV. For some reason CFHTTP does not work for me. And I am also having trouble setting up a csv file as a datasource in CF Admin. (verify=failed) Do any of you know of a custom tag for this purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV to Query
I don't know if there's anything on cflib.org, but if you have access to DRK3, the DFA API does this (and a ton more). ~Simon Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor Blog - http://www.horwith.com > > Anybody have a UDF for this? I need it sharpish, I can write it myself > but if someone else has done this.. whooho! > > Much apreciated > > -- > Mark Drew > mailto:[EMAIL PROTECTED] > blog:http://cybersonic.blogspot.com/ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
Have a look at cfhttp HTH Dick On Aug 25, 2004, at 5:56 AM, Mark Drew wrote: > Anybody have a UDF for this? I need it sharpish, I can write it myself > but if someone else has done this.. whooho! > > Much apreciated > > -- > Mark Drew > mailto:[EMAIL PROTECTED] > blog:http://cybersonic.blogspot.com/ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
I have looked at this.. there is one small problem one of the columns is a date so I am not sure how dbtype= query handles it but the results seem a bit odd SELECT * FROM info WHERE orderdate < value="#DateFormat(Now(), "dd/mm/")#"> On Wed, 25 Aug 2004 06:35:57 -0700, Dick Applebaum <[EMAIL PROTECTED]> wrote: > Have a look at cfhttp > > HTH > > Dick > > On Aug 25, 2004, at 5:56 AM, Mark Drew wrote: > > > Anybody have a UDF for this? I need it sharpish, I can write it myself > > but if someone else has done this.. whooho! > > > > Much apreciated > > > > -- > > Mark Drew > > mailto:[EMAIL PROTECTED] > > blog:http://cybersonic.blogspot.com/ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
Can we see a few lines of your CSV file? Dick On Aug 25, 2004, at 7:03 AM, Mark Drew wrote: > I have looked at this.. there is one small problem > > one of the columns is a date so I am not sure how dbtype= query > handles it but the results seem a bit odd > > > textqualifier=""> > > > SELECT * > FROM info > WHERE orderdate < > value="#DateFormat(Now(), "dd/mm/")#"> > > > On Wed, 25 Aug 2004 06:35:57 -0700, Dick Applebaum > <[EMAIL PROTECTED]> wrote: > > Have a look at cfhttp > > > > HTH > > > > Dick > > > > On Aug 25, 2004, at 5:56 AM, Mark Drew wrote: > > > > > Anybody have a UDF for this? I need it sharpish, I can write it > myself > > > but if someone else has done this.. whooho! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
> > > Anybody have a UDF for this? I need it sharpish, I can write it myself > > > but if someone else has done this.. whooho! I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You can find some other great utils there too. This is the code I use to parse a CSV file... it creates an array not a query though. f = createObject( "java", "java.io.FileInputStream" ); f.init("#REQUEST.DOCUMENT_DIRECTORY#\#File.ServerFile#"); parser = createObject( "java", "com.Ostermiller.util.ExcelCSVParser" ); parser.init( f ); csvArr = parser.getAllValues(); parser.close(); f.close(); -- Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
The file is something like Part,PartDesc,OrderRef,Qty,orderdate XX,A descriptoin of an Item,OrderRefno222,1,14/05/2004 15:20 you get the idea It is the date that kills me! MD On Wed, 25 Aug 2004 10:20:29 -0400, Marc Campeau <[EMAIL PROTECTED]> wrote: > > > > Anybody have a UDF for this? I need it sharpish, I can write it myself > > > > but if someone else has done this.. whooho! > > I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You > can find some other great utils there too. > > This is the code I use to parse a CSV file... it creates an array not > a query though. > > > > f = createObject( "java", "java.io.FileInputStream" ); > f.init("#REQUEST.DOCUMENT_DIRECTORY#\#File.ServerFile#"); > > parser = createObject( "java", "com.Ostermiller.util.ExcelCSVParser" ); > parser.init( f ); > csvArr = parser.getAllValues(); > parser.close(); > f.close(); > > > > -- > Marc > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
Here's a second vote for ostermiller's CSV parser. It's java, so it requires a touch of Java knowlesge, but it's very easy to use, as Marc's demo illustrates, and quite fast. cheers, barneyb On Wed, 25 Aug 2004 10:20:29 -0400, Marc Campeau <[EMAIL PROTECTED]> wrote: > > > > Anybody have a UDF for this? I need it sharpish, I can write it myself > > > > but if someone else has done this.. whooho! > > I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You > can find some other great utils there too. > > This is the code I use to parse a CSV file... it creates an array not > a query though. > > > > f = createObject( "java", "java.io.FileInputStream" ); > f.init("#REQUEST.DOCUMENT_DIRECTORY#\#File.ServerFile#"); > > parser = createObject( "java", "com.Ostermiller.util.ExcelCSVParser" ); > parser.init( f ); > csvArr = parser.getAllValues(); > parser.close(); > f.close(); > > > > -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
Oops, forgot to send this! Dick That looks like a date time field. I never thought much about it, but I don't think that cfhttp can determine that the field is a datetime -- I think it simply creates a char field. So, you can't do a QofQ on a datetime value as only text comparisons are valid. A possible solution is to: 1) loop through the query 2) convert each text representation of date time into a valid datetime object 3) perform your comparison 4) build a new query with a row for each match HTH Dick > The file is something like > Part,PartDesc,OrderRef,Qty,orderdate > XX,A descriptoin of an Item,OrderRefno222,1,14/05/2004 15:20 > > you get the idea > > It is the date that kills me! > > MD > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
Not to forget querySim: there's the original tag which you can get from http://www.halhelms.com/index.cfm?fuseaction=code.detail or the UDF version from http://www.cflib.org/udf.cfm?ID=255 Both do pretty much the same thing - take some formatted text and return a recordset. As to which to use, its much of a muchness - I think the UDF is slightly faster until the amount of data being passed in reaches a certain size, after which performance deteriorates faster than the tag, but I haven't looked at either for years, so that would have been testing on CF5 Cheers Bert From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 August 2004 17:14 To: CF-Talk Subject: Re: CSV to Query Here's a second vote for ostermiller's CSV parser. It's java, so it requires a touch of Java knowlesge, but it's very easy to use, as Marc's demo illustrates, and quite fast. cheers, barneyb On Wed, 25 Aug 2004 10:20:29 -0400, Marc Campeau <[EMAIL PROTECTED]> wrote: > > > > Anybody have a UDF for this? I need it sharpish, I can write it myself > > > > but if someone else has done this.. whooho! > > I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You > can find some other great utils there too. > > This is the code I use to parse a CSV file... it creates an array not > a query though. > > > > f = createObject( "java", "java.io.FileInputStream" ); > f.init("#REQUEST.DOCUMENT_DIRECTORY#\#File.ServerFile#"); > > parser = createObject( "java", "com.Ostermiller.util.ExcelCSVParser" ); > parser.init( f ); > csvArr = parser.getAllValues(); > parser.close(); > f.close(); > > > > -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV-to-Query
no custom tag, but what's the problem mapping it as a datasource? What drivers are you using to try to connect to the spreadsheet? ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:49 AM To: CF-Talk Subject: CSV-to-Query Greetings! I am struggling with the notion of trying to query a CSV. For some reason CFHTTP does not work for me. And I am also having trouble setting up a csv file as a datasource in CF Admin. (verify=failed) Do any of you know of a custom tag for this purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0549C.EDA1C16A Content-Type: text/plain; charset="iso-8859-1" You could do something like this. HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 9:49 AM To: CF-Talk Subject: CSV-to-Query Greetings! I am struggling with the notion of trying to query a CSV. For some reason CFHTTP does not work for me. And I am also having trouble setting up a csv file as a datasource in CF Admin. (verify=failed) Do any of you know of a custom tag for this purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists --_=_NextPart_001_01C0549C.EDA1C16A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: CSV-to-Query You could do something like this. <cfset = dirPath =3D "E:\somewhere\folder"> <cftry> <cffile action=3D"UPLOAD" = filefield=3D"CSVFile" destination=3D"#dirPath#" = nameconflict=3D"OVERWRITE"> <cfcatch type=3D"any"> = <cfabort = showerror=3D"You must attach a .csv document : = #cfcatch.message#"> </cfcatch > </cftry> =20 <cftry> <cfif isDefined("file.clientFile") and = Len(file.clientFile)> <CFFILE ACTION=3D"Read" = FILE=3D"#dirPath#\#File.ClientFile#" = VARIABLE=3D"CSVFile"> <cfset = mail =3D QueryNew("MailTo,FName,LName")> <cfparam name=3D"counter" = default=3D"1"> <cfloop list=3D"#CSVFile#" = delimiters=3D"#CHR(13)##CHR(10)#" = index=3D"thisLine"> = = <CFSET = newRow =3D QueryAddRow(mail, 1)> = = <cfset = temp =3D QuerySetCell(mail,"MailTo",ListGetAt(thisLine, = 1))> = = = <cfset = temp =3D QuerySetCell(mail,"FName",ListGetAt(thisLine, = 2))> = = <cfset = temp =3D QuerySetCell(mail,"LName",ListGetAt(thisLine, = 3))> = <cfset counter =3D IncrementValue(counter)> </cfloop> </cfif> <cfcatch type=3D"any"> <cfabort showerror=3D"There was a problem working with = your .csv file, <br> ensure that you have created a .csv file = with the following fields. <br> = <b>EmailTo,FirstName,LastName</b> <br> = #cfcatch.message#"> </cfcatch> </cftry> HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]">mailto:Rich@internet4asso= ciations.com] Sent: Wednesday, November 22, 2000 9:49 AM To: CF-Talk Subject: CSV-to-Query Greetings! I am struggling with the notion of trying to query a = CSV. For some reason CFHTTP does not work for me. And I am also having = trouble setting up a csv file as a datasource in CF Admin. = (verify=3Dfailed) Do any of you know of a custom tag for this = purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the = official book at http://www.fusionauthority.com/bkinfo.cfm" = TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= --_=_NextPart_001_01C0549C.EDA1C16A-- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Apparently I do not have the necessary driver to map it as a datasource through cfadmin. "verification failed" every time. Also, how do I construct a query to a csv? I've never done, and I assume I can't ise standard sql! - Original Message - From: "Simon Horwith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 10:54 AM Subject: RE: CSV-to-Query > no custom tag, but what's the problem mapping it as a datasource? What > drivers are you using to try to connect to the spreadsheet? > > ~Simon > > > Simon Horwith > > Certified ColdFusion Developer > > Fig Leaf Software > > 1400 16th St NW, # 220 > > Washington DC 20036 > > 202.797.6570 (direct line) > > www.figleaf.com > > > > > -Original Message----- > From: Richard Gilbert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 10:49 AM > To: CF-Talk > Subject: CSV-to-Query > > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Take a look at: http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP and http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:58 AM To: CF-Talk Subject: Re: CSV-to-Query Apparently I do not have the necessary driver to map it as a datasource through cfadmin. "verification failed" every time. Also, how do I construct a query to a csv? I've never done, and I assume I can't ise standard sql! - Original Message - From: "Simon Horwith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 10:54 AM Subject: RE: CSV-to-Query > no custom tag, but what's the problem mapping it as a datasource? What > drivers are you using to try to connect to the spreadsheet? > > ~Simon > > > Simon Horwith > > Certified ColdFusion Developer > > Fig Leaf Software > > 1400 16th St NW, # 220 > > Washington DC 20036 > > 202.797.6570 (direct line) > > www.figleaf.com > > > > > -----Original Message- > From: Richard Gilbert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 10:49 AM > To: CF-Talk > Subject: CSV-to-Query > > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Anyone have a CF version of CSV-to-Table using SQL7's ability to import a text file? best, paul At 11:07 AM 11/22/00 -0500, you wrote: >Take a look at: >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP >and >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP > >~Simon > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Paul: Now you're talking. Can you describe this process to me? I am using SQL7, but have never taken advantage of this feature. Richard - Original Message - From: "paul smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 11:39 AM Subject: RE: CSV-to-Query > Anyone have a CF version of CSV-to-Table using SQL7's ability > to import a text file? > > best, paul > > > At 11:07 AM 11/22/00 -0500, you wrote: > >Take a look at: > >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP > >and > >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP > > > >~Simon > > > > > > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
This tag works great and may suit your needs. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347395-2830-11D4-AA 9700508B94F380&method=Full > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Well, if you go to EM and select a database, you'll see "import data" as an option in the right pane. Click on that, then click on "Next" and then select "Text file" from the drop down for "Source" This is how you can do it while sitting at a SQL7 box. My question is has anyone developed the script to do it in a CF template. best, paul At 12:22 PM 11/22/00 -0500, you wrote: >Paul: > >Now you're talking. >Can you describe this process to me? >I am using SQL7, but have never taken advantage of this feature. > >Richard > >- Original Message - >From: "paul smith" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, November 22, 2000 11:39 AM >Subject: RE: CSV-to-Query > > > > Anyone have a CF version of CSV-to-Table using SQL7's ability > > to import a text file? > > > > best, paul > > > > > > At 11:07 AM 11/22/00 -0500, you wrote: > > >Take a look at: > > >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP > > >and > > >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP > > > > > >~Simon > > > > > > > > > > > ~~ > > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Does this tag use CFFILE? best, paul At 09:44 AM 11/22/00 -0800, you wrote: >This tag works great and may suit your needs. > >http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347395-2830-11D4-AA >9700508B94F380&method=Full > > > > > > Greetings! > > > > I am struggling with the notion of trying to query a CSV. For some reason > > CFHTTP does not work for me. And I am also having trouble setting up a csv > > file as a datasource in CF Admin. (verify=failed) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Not that I am aware of. It is a CFX. -Adrian -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:12 AM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: CSV-to-Query Does this tag use CFFILE? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Richard, Go to http://www.nateweiss.com/taggallery/ and look at CFX_CSVToQuery - it will put a CSV file into a CF Query. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Richard Gilbert wrote: > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Cool...I always used http://www.icesinc.com/nate/taggallery/ and it disappeared recently. I thought Nate abandoned the CF world. His tags and support to the community have been great, although I have not heard much from Nate in recent days, perhaps he is on the Unix-CF based lists now... -Adrian -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Go to http://www.nateweiss.com/taggallery/ and look at CFX_CSVToQuery - it will put a CSV file into a CF Query. regards, larry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
CFHTTP can make a query out of a CSV file, but ONLY if all of the cells in the file have the SAME text delimiters. For example if ALL of the cells have "quotes" around the values or if NONE of the cells have "quotes". This rules out any CSV saved by Microsoft Excel. Unfortunately this is the source of 99% of the CSV files you will need to parse. What I do is I tell CFHTTP that there are NO text delimiters, then I can make a query out of the file. Some of the cells will have extra "quotes" around them. I run each and every field of the query through some reg-ex'es to remove a leading " and remove a trailing " as I copy them into a temporary table in my database. Then I can manipulate the date with real queries. At 10:48 AM 11/22/00 -0500, Richard Gilbert wrote: >Greetings! > >I am struggling with the notion of trying to query a CSV. For some reason >CFHTTP does not work for me. And I am also having trouble setting up a csv >file as a datasource in CF Admin. (verify=failed) > >Do any of you know of a custom tag for this purpose? > >Thanks in advance, >Richard > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Windows only unfortunately :-( Nothing for us Unix folk. At 02:24 PM 11/22/00 -0500, Larry C. Lyons wrote: >Richard, > >Go to http://www.nateweiss.com/taggallery/ and look at CFX_CSVToQuery - >it will put a CSV file into a CF Query. > >regards, > >larry > >-- >Larry C. Lyons >ColdFusion/Web Developer >EBStor.com >8870 Rixlew Lane, Suite 201 >Manassas, Virginia 20109-3795 >tel: (703) 393-7930 x253 >fax: (703) 393-2659 >http://www.ebstor.com >http://www.pacel.com >email: [EMAIL PROTECTED] > >Chaos, panic, and disorder - my work here is done. >-- > >Richard Gilbert wrote: >> >> Greetings! >> >> I am struggling with the notion of trying to query a CSV. For some reason >> CFHTTP does not work for me. And I am also having trouble setting up a csv >> file as a datasource in CF Admin. (verify=failed) >> >> Do any of you know of a custom tag for this purpose? >> >> Thanks in advance, >> Richard >> >> ~~ >> Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm >> >> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists