Re: CF 11

2014-07-01 Thread Cameron Childress
On Mon, Jun 30, 2014 at 8:26 PM, Russ Michaels wrote: Yes but then you are a better coder than most of the but it works fine of computer merchants I have dealt with :) I expect that as a hosting provider you deal with an entirely different class of developer capabilities than populate this

Re: CF 11

2014-07-01 Thread Russ Michaels
the majority of the people I deal with I do not see active in the community at all, so they are in that silent majority On Tue, Jul 1, 2014 at 2:42 PM, Cameron Childress camer...@gmail.com wrote: On Mon, Jun 30, 2014 at 8:26 PM, Russ Michaels wrote: Yes but then you are a better coder

Writing huge data to excel

2014-07-01 Thread funand learning
Hi, I am working on exporting data to excel with multiple sheets. The sheets are dynamic and may range from 2 to more than 5. What is the best way to handle this? 1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of sheets? I have tried with cfspreadsheet but only the last

re: Writing huge data to excel

2014-07-01 Thread Jeff Garza
You really ought to be looking outside of CF for transfers of large datasets, especially into Excel. Have you tried using SSIS (SQL Server Integration Services) for this? It's really not that difficult to do and it'll handle millions of rows easily... -- Jeff Original Message

Re: Writing huge data to excel

2014-07-01 Thread Jon Clausen
I’ve actually become quite fond of CF's Spreadsheet functions, though I prefer to use the script versions as I find them more flexible when dealing with large datasets, formatting content for reports and working with multiple sheets:

Re: Writing huge data to excel

2014-07-01 Thread funand learning
Thank you. I am not using SpreadSheetWrite function to write to a file. I am storing all the sheets in a variable and using cfheader and cfcontent to prompt the user to save or download. Do you think this is a preferred option? On Tue, Jul 1, 2014 at 2:17 PM, Jon Clausen

Re: Writing huge data to excel

2014-07-01 Thread Jon Clausen
That’s really your call. The way you’re doing it is the “old-school” method and used to be the standard for spreadsheet delivery. With CF9+, I find working directly with the spreadsheet object allows me to avoid jumping through a bunch of hoops to sanitize the cell input - especially

File Upload with Chunk Method

2014-07-01 Thread UXB
I am trying to implement a file upload utilizing Plupload and its chunk methodology that needs to be compatible with older versions of ColdFusion as far back as version 5. So far I have had success in the test environment but have found an issue I can't seem to solve and that is what happens