Re: Excel File Parser for ColdFusion

2010-11-29 Thread Dan Baughman
Not off the top of my head, but I recall that you have to close both the resource and the queryobject using a .close function, or the resource handle stays open and you end up having to restart coldfusion every so often. On Mon, Nov 29, 2010 at 10:02 AM, Joel Rivera wrote: > > :):):) > > ~

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
:):):) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339581 Subscriptio

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
Hi Dan, We are just converting our cf4.5 code to cf8 and are having issues with closing an excel file. Since cfusion_disable_dbconnections is function is obsolete from cf 8, do you have a code that closes the excel connection? Joel jriv...@volt.com ~

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
> I have a function that will do just that, its only like 22 lines of > code. > > You have to be careful because if you don't close the resource and > the > connection you have to restart your coldfusion services... so you may > want > to throw in a try/catch that does that. > > With this cod

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
> I have a function that will do just that, its only like 22 lines of > code. > > You have to be careful because if you don't close the resource and > the > connection you have to restart your coldfusion services... so you may > want > to throw in a try/catch that does that. > > With this cod

Re: Excel File Parser for ColdFusion

2009-08-07 Thread Dan Baughman
> Mark A. Kruger, CFG, MCSE > (402) 408-3733 ext 105 > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > -Original Message- > From: Dan Baughman [mailto:dan.baugh...@gmail.com] > Sent: Friday, August 07, 2009 11:22 AM > To: cf-talk > Subject: Re: Exc

RE: Excel File Parser for ColdFusion

2009-08-07 Thread Mark Kruger
t 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dan Baughman [mailto:dan.baugh...@gmail.com] Sent: Friday, August 07, 2009 11:22 AM To: cf-talk Subject: Re: Excel File Parser for ColdFusion It appears that approach wants to work with a CSV file, not an xls? O

Re: Excel File Parser for ColdFusion

2009-08-07 Thread Dan Baughman
Friday, August 07, 2009 10:59 AM > To: cf-talk > Subject: Re: Excel File Parser for ColdFusion > > > Hi Dan, > > Yes. Currently I am reading the uploaded CSV file with CFHTTP which > returns > the data in a query. > > Thanks, > > Donnie > > >The end goa

RE: Excel File Parser for ColdFusion

2009-08-07 Thread Mark Kruger
ssage- From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] Sent: Friday, August 07, 2009 10:59 AM To: cf-talk Subject: Re: Excel File Parser for ColdFusion Hi Dan, Yes. Currently I am reading the uploaded CSV file with CFHTTP which returns the data in a query. Thanks, Donnie >

Re: Excel File Parser for ColdFusion

2009-08-07 Thread Dan Baughman
I have a function that will do just that, its only like 22 lines of code. You have to be careful because if you don't close the resource and the connection you have to restart your coldfusion services... so you may want to throw in a try/catch that does that. With this code you don't have to ins

Re: Excel File Parser for ColdFusion

2009-08-07 Thread Donnie Carvajal
Hi Dan, Yes. Currently I am reading the uploaded CSV file with CFHTTP which returns the data in a query. Thanks, Donnie >The end goal is to convert the file into a query-like struct that you can >loop through taking action on the contents of each line? > >On Fri, Aug 7, 2009 at 10:41 AM, Don

Re: Excel File Parser for ColdFusion

2009-08-07 Thread Dan Baughman
The end goal is to convert the file into a query-like struct that you can loop through taking action on the contents of each line? On Fri, Aug 7, 2009 at 10:41 AM, Donnie Carvajal < donnie.carva...@transformyx.com> wrote: > > We have an application that excepts a CSV file for data imports, but a

Re: Excel File Parser for ColdFusion

2009-08-07 Thread John M Bliss
http://cflib.org/udf/parseExcel http://cfexcelproxy.riaforge.org http://cfxl.riaforge.org On Fri, Aug 7, 2009 at 10:41 AM, Donnie Carvajal < donnie.carva...@transformyx.com> wrote: > > We have an application that excepts a CSV file for data imports, but as I > am sure you know, editing CSV fil

Excel File Parser for ColdFusion

2009-08-07 Thread Donnie Carvajal
We have an application that excepts a CSV file for data imports, but as I am sure you know, editing CSV files in notepad is a pain and since Excel loves to change your data the process can be very cumbersome and painful. So, I was thinking, if there was an Excel file parser that I could run in