Re: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
Rick, Thanks for the attached. I've had some time now to study this code and I have a few questions, if you don't mind. 1.) What is the included template "_ext2attr.cfm"? Is it possible to get a copy of it as well? Or do I need it? 2.) How do you invoke this custom tag of yours? I see the following: which is soon followed by Does that mean that there are arguments to your custom tag like vr1c1="xxx" vr1c2="yyy" etc. etc. for each data point that should be included in the doughnut chart? Or is this what the ext2attr.cfm template is all about? I hope you don't mind my asking you these questions and that they are not too much of an imposition. But the answers would sure help. Thanks in advance, -- Tim Dempsey - Original Message - From: "Rick Osborne [Mojo]" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 04, 2000 8:17 PM Subject: RE: How can I use CF to push data into a statistical package or an Ex cel spreadsheet? > Tim Dempsey asked: > > How do I take that data and get it into Excel on the client's machine? > > We had to do something like this last month (with Doughnut charts instead of > Pie charts, but it's close enough). I never could get it to work 100% in > CF, as Excel wouldn't honor my Quit() command and would just stay open, > leaving lots of little zombies all over the place. However, on a whim I > translated it into Perl and got it to work that way. (And, oddly enough, > the Perl version is *much* easier on the eyes, for once.) > > Anyway, I apologize for the minimal documentation, but this was really just > a quick hack for me. YMMV and all that. If you ever figure out the Quit() > problem, let me know. I'd love to know what I'm doing wrong. Also, if you > want the (working) Perl version, let me know and I'll send it via separate > channels (as I figured I'd get flamed 'til the end of time if I posted Perl > to this list). It's much smarter and does things like palette conversion > (so that you aren't stuck with Excel's default colors), and other neat-o > tricks. > > -R > > > > > > > > > > > > > > > > > > > > > > > NAME="App"> > > NAME="App"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Resetting color #CellColor# > > Mid(CellColor,4,2) & Mid(CellColor,2,2),16)> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Error > #CFCATCH.Message# > #CFCATCH.Detail# > > > > > > > > > >DELETEFILE="Yes"> > > > > > > ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
Tim, Rick, Currently working on a similar problem. Rick,would you mind sending your Perl version as a short term fix. Tim keep me in the loop re developments on the CF Side Appreciate that Regards D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: 05 December 2000 13:21 To: CF-Talk Subject: Re: How can I use CF to push data into a statistical package or an Ex cel spreadsheet? Thanks very much Rick. This is really helpful. And, if you would, can you send the working Perl version to me at [EMAIL PROTECTED] ? I'd appreciate that, too. Thanks again, -- Tim Dempsey - Original Message - From: "Rick Osborne [Mojo]" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 04, 2000 8:17 PM Subject: RE: How can I use CF to push data into a statistical package or an Ex cel spreadsheet? > Tim Dempsey asked: > > How do I take that data and get it into Excel on the client's machine? > > We had to do something like this last month (with Doughnut charts instead of > Pie charts, but it's close enough). I never could get it to work 100% in > CF, as Excel wouldn't honor my Quit() command and would just stay open, > leaving lots of little zombies all over the place. However, on a whim I > translated it into Perl and got it to work that way. (And, oddly enough, > the Perl version is *much* easier on the eyes, for once.) > > Anyway, I apologize for the minimal documentation, but this was really just > a quick hack for me. YMMV and all that. If you ever figure out the Quit() > problem, let me know. I'd love to know what I'm doing wrong. Also, if you > want the (working) Perl version, let me know and I'll send it via separate > channels (as I figured I'd get flamed 'til the end of time if I posted Perl > to this list). It's much smarter and does things like palette conversion > (so that you aren't stuck with Excel's default colors), and other neat-o > tricks. > > -R > > > > > > > > > > > > > > > > > > > > > > > NAME="App"> > > NAME="App"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Resetting color #CellColor# > > Mid(CellColor,4,2) & Mid(CellColor,2,2),16)> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Error > #CFCATCH.Message# > #CFCATCH.Detail# > > > > > > > > > >DELETEFILE="Yes"> > > > > > > ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
If you just need simple pie charts or bar graphs, the java applets that used to come with CF work out fine.. Take a look at survey results I just did for someone: http://a1webs.com/pm-news/graphs.cfm the survey is at: http://a1webs.com/pm-news/ (don't look at the ugly colors - it had to blend in with an existing ugly site:) I think the java applets are on the allaire site someplace. To use, it is simply: http://a1webs.com/pm-news/" width="300" height="300"> You just have to fill in the items, values and title parameter from your database. Al Musella a1webs.com ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
Thanks very much Rick. This is really helpful. And, if you would, can you send the working Perl version to me at [EMAIL PROTECTED] ? I'd appreciate that, too. Thanks again, -- Tim Dempsey - Original Message - From: "Rick Osborne [Mojo]" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 04, 2000 8:17 PM Subject: RE: How can I use CF to push data into a statistical package or an Ex cel spreadsheet? > Tim Dempsey asked: > > How do I take that data and get it into Excel on the client's machine? > > We had to do something like this last month (with Doughnut charts instead of > Pie charts, but it's close enough). I never could get it to work 100% in > CF, as Excel wouldn't honor my Quit() command and would just stay open, > leaving lots of little zombies all over the place. However, on a whim I > translated it into Perl and got it to work that way. (And, oddly enough, > the Perl version is *much* easier on the eyes, for once.) > > Anyway, I apologize for the minimal documentation, but this was really just > a quick hack for me. YMMV and all that. If you ever figure out the Quit() > problem, let me know. I'd love to know what I'm doing wrong. Also, if you > want the (working) Perl version, let me know and I'll send it via separate > channels (as I figured I'd get flamed 'til the end of time if I posted Perl > to this list). It's much smarter and does things like palette conversion > (so that you aren't stuck with Excel's default colors), and other neat-o > tricks. > > -R > > > > > > > > > > > > > > > > > > > > > > > NAME="App"> > > NAME="App"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Resetting color #CellColor# > > Mid(CellColor,4,2) & Mid(CellColor,2,2),16)> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Error > #CFCATCH.Message# > #CFCATCH.Detail# > > > > > > > > > >DELETEFILE="Yes"> > > > > > > ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
Tim Dempsey asked: > How do I take that data and get it into Excel on the client's machine? We had to do something like this last month (with Doughnut charts instead of Pie charts, but it's close enough). I never could get it to work 100% in CF, as Excel wouldn't honor my Quit() command and would just stay open, leaving lots of little zombies all over the place. However, on a whim I translated it into Perl and got it to work that way. (And, oddly enough, the Perl version is *much* easier on the eyes, for once.) Anyway, I apologize for the minimal documentation, but this was really just a quick hack for me. YMMV and all that. If you ever figure out the Quit() problem, let me know. I'd love to know what I'm doing wrong. Also, if you want the (working) Perl version, let me know and I'll send it via separate channels (as I figured I'd get flamed 'til the end of time if I posted Perl to this list). It's much smarter and does things like palette conversion (so that you aren't stuck with Excel's default colors), and other neat-o tricks. -R Resetting color #CellColor# Error #CFCATCH.Message# #CFCATCH.Detail# ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
I would suggest using cfcontent to a file on the server then providing a link to it for the client to click on. You could also set the cfcontent tag for download, which would make the excel file and then prompt them to download it in one step. Rick -Original Message- From: Dempsey, Timothy F. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:17 PM To: CF-Talk Subject: How can I use CF to push data into a statistical package or an Ex cel spreadsheet? Folks, I have a CF application that conducts a survey by presenting a varying series of questions to the user and then storing the answers in an Oracle database. I have another CF application for the administrator of the survey that displays on a web page a summary of the answers for each question (e.g. 23 respondents answered A, 47 respondents answered B, etc.). I allow the survey administrator to click on a hyperlink next to each question on the summary web page and that link is supposed to send the question, each given answer, and the number of respondents for each answer over to Excel from which a pie chart can be generated. My question is: How do I take that data and get it into Excel on the client's machine? Any suggestions? Or even suggestion about where to look to research this problem? Or is there another approach any one would care to point out to graphing my survey responses instead of Excel? Thanks, -- Tim Dempsey ~~ 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
How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
Folks, I have a CF application that conducts a survey by presenting a varying series of questions to the user and then storing the answers in an Oracle database. I have another CF application for the administrator of the survey that displays on a web page a summary of the answers for each question (e.g. 23 respondents answered A, 47 respondents answered B, etc.). I allow the survey administrator to click on a hyperlink next to each question on the summary web page and that link is supposed to send the question, each given answer, and the number of respondents for each answer over to Excel from which a pie chart can be generated. My question is: How do I take that data and get it into Excel on the client's machine? Any suggestions? Or even suggestion about where to look to research this problem? Or is there another approach any one would care to point out to graphing my survey responses instead of Excel? Thanks, -- Tim Dempsey ~~ 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
