Re: Generating reports in the background (update)
Aidan: Frankly I am not surprised you are having trouble Reports can put a serious load on the CF interpreter. Some questions to ask are: Are you using SQL Server and making full use of its power with views (and calculated columns?), stored procedures, triggers, etc.. Have you considered or have you already created a separate, (repeat separate) OLAP database strictly for reporting? It sounds like you may also have already done this, but have you considered dividing the reports into "regularly viewed" and "must be on-the-fly"? For "regularly viewed" the user could enter their preferred parameters, if any are required, into a database that will store them for use with scheduled reports that could be run in low traffic times and saved to a pick-up location, as, say, pdfs. There is nothing inherent to cflocating and cfhttp that should take forever. As a rule, CF does not handle complex reporting jobs well... it is designed to glue things together. make the work happen elsewhere (for best results)... not meaning to tell you something you already know... sorry if any of this sounds like bad news to you. regards, Patrick At 11:44 AM 31/10/2001 +, Aidan Whitehall wrote: >I'm trying to trigger a ColdFusion template that generates a report in the >background. I want to start the process and then redirect the browser to a >"your report is being created" page. Try as I might, I can't get the report >started without the browser being forced to wait at some point for the >report to be finished. > >The report generation needs to be triggered on-demand. Updating a CFSCHEDULE >and then running it straight away doesn't seem to work (I guess because it >must be set at least 15 minutes in the future). > >Calling the report making template via CFHTTP before using CFLOCATION >doesn't work, as the page sits there until the report is finished before >redirecting. > >Using CFHTTP at the end of the "your report is being created" also makes >that page take forever to be rendered. If I was using CF5, I guess I could >CFFLUSH the page before doing CFHTTP last, but we're stuck with v4.0.1. > >I can't call CFML.EXE via a URL and CFEXECUTE is only 4.5+. > > >Any ideas? I've run out... > >Thanks. > >-- >Aidan Whitehall <[EMAIL PROTECTED]> >Macromedia ColdFusion Developer >Fairbanks Environmental +44 (0)1695 51775 > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 2000 desktop version.
Hey gang: I attended an MS developer session where they said that SQL Desktop will run you about $50 per seat license. That was probably Canadian funds, so that's about, what, $1 American? ;) ... Patrick Harkins At 01:11 PM 30/10/2001 -0800, Costas Piliotis wrote: >And for the most part, it looks like MSDE and Personal Edition are the same >except the Desktop Edition comes with the Tools (EM, QA, Profiler). Desktop >Engine is just the database. > >So I don't stand corrected :-) > > > >-Original Message- >From: Costas Piliotis >Sent: Tuesday, October 30, 2001 12:56 PM >To: CF-Talk >Subject: RE: SQL Server 2000 desktop version. > > >Ahhh... Ooops... I stand corrected. There's a first for everything =) > >Here's Microsoft's link to a comparison: > >http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ >ar_sa2_9gz4.asp > >-Original Message- >From: Dave Watts [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, October 30, 2001 11:01 AM >To: CF-Talk >Subject: RE: SQL Server 2000 desktop version. > > > > It's called msde. It comes with Office 2000/XP. Not Really a desktop > > edition but rather a scaled down implementation of SQL Server. > > > > As far as I know, if you have an Office 2000/XP licence, you have a > > MSDE licence as well. > >MSDE isn't the same as SQL Server Desktop Edition. With SQL Server, you >could install the Desktop Edition on a Windows 98 machine, for example, and >you'd get the core SQL Server engine (with some pretty severe size and >functionality limitations) and the Enterprise Manager tools. MSDE, on the >other hand, is simply the SQL Server engine (with its own, different, set of >limitations), with no Enterprise Manager tools. > >If you develop applications with Visual Studio, you can redistribute MSDE >with those applications, as an alternative to using Access. You can't >redistribute SQL Server Desktop Edition. > > > Do you need a license to install the desktop version of SQL Server > > 2000? > >As for needing a license to install SQL Server Desktop Edition, I'm sure you >need one, but I don't know how much it is. You'd also need licenses for >connections, I suspect, if you were to actually have any connections to it. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Generating reports in the background
.how about CFLOCATION to the notification page first, then CFHTTP? Patrick -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: October 26, 2001 6:12 AM To: CF-Talk Subject: Generating reports in the background I want a user to be able to specify the criteria for a report, dump the criteria into a database, trigger a page that generates the report in the background by specifying the ReportID value, then redirects the user to a page saying "Your report is being created". At the moment, I'm using CFHTTP to call the template that creates the report. However, the CFLOCATION then doesn't redirect the browser until the report has been generated - I want the CFLOCATION to happen straight away. I don't want to use Scheduled Events as some reports will only take a few seconds to run and the user won't like to have to wait another (say) 15 minutes before all the outstanding reports are triggered for a small report. Any ideas on a good way of doing this? I'm sure the answer is simple but the grey stuff is really struggling today... Thanks in advance -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting Word and Excel to HTML
Hi Kathryn: It depends on the documents themselves how they look when they turn out. Basically, the converted pages tend to look ugly. And as Mark Smyth said, Dreamweaver can clean up the wonky HTML. Yes it is doable with Excel too, in fact I have found that Excel documents tend to turn out better. You might want to consider getting Adobe Acrobat (the full version, not the Reader) and using it to convert the docs to pdfs. Here is a link that explains the process and talks about some of the issues: http://users.belgacom.net/prepresspanic/pdf/apps/word.htm . Or you could go with activePDF: www.activepdf.com. Acrobat Reader is a free and quick install for those who do not already have it. my two cents... :) Patrick Harkins Good morning, all Here is my problem. We have a number of Word and Excel documents that are currently available on our company Intranet. We have just rolled out the Intranet, so it is only available at HQ. We are slowly beginning to give our branches access, but our branch employees generally have thin clients with IE installed, but no Word or Excel. Therefore, we need to create a custom tag that takes Word/Excel files and coverts them to HTML. My first thought is to use the Object models in Word and Excel to do a simple Save As HTML. Has anyone done anything like this? Is this a practical solution? I would think that I would use VBScript to do this. Does anyone have any comments, war stories, references or resources on this? I am posting this through email, since our Internet access has been shut down due to the virus, so if this has been covered ad nauseum, I apologize. Thanks! Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm resending - help
Michael: I read your question and it is not entirely clear but I get the general drift. What you are asking suggests that the architecture of what you are doing is unweildy. Not to be annoying, but you are asking ColdFusion to do too much - believe me I know this from experience. ColdFusion should only be used as the glue to integrate your output. It is not designed to be a workhorse. What database are you using? You can probably do a lot of the work on the database side, if you are using a true database server, using triggers and stored procedures. It sounds to me like you may well be in need of a whole separate OLAP database. That is where I would suggest that you direct your thoughts - it will save you a whole lot of grief, and your server will continue to be your friend. Patrick Harkins -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: September 20, 2001 6:46 AM To: CF-Talk Subject: I'm resending - help Resending this, please take a look (haven't got response). I have a complexed CFM template that output a result page after a long process.The process includes: connecting to 3-4 diffrent datasources, string manipulation, math calculations, links, includes, everything... I though about the following way to cache: Every cfoutput (and other html/js code) is store incremently in a cf variable. (upon succesful completion of every phase). In the end, I output the result to the user and store that variable in a SQL table with a UID. Then, the second time a user calls the CFM, I first check if the output content is already in SQL, and output it. If the content is not there, or expired, I simply parse the CFM from the start. Any comments on my way to do this? What is better in this way, store the output content in SQL or a text file (and then it)? Michael. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Microsoft Word & Coldfusion
Hi: I am not sure what you are asking. You can always format the document using nested tables, but it is slow and painful - must be done by hand coded HTML. As you must know, the built-in Word HTML converter is no good. If you want to save time on a tool to wite the html for you, I tried the online demo of OutsideIn-Server a year or so ago and was totally blown away. The product should be found at www.inso.com, but when i try to go there i get a 404 error, so perhaps the company is out of business or who knows what..but things are very wormy today, so it may be a temporary thing. Hope that helps :) Patrick Harkins -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: September 19, 2001 9:19 AM To: CF-Talk Subject: Microsoft Word & Coldfusion Hi I wish to integrate a ms word document within an existing html page using CF. I would like to display the contents of the word doc within a table in an html page, so it looks as if it was constructed in HTML. Is this possible with Coldfusion, if so what is the procedure for achieving the best result? Are there any tags or methods to achieve this, apart from COM which relies on either the user have word installed locally or the server having word installed which is not an option if you are running on UNIX or LINUX. Finally are any o the list aware of www.wwvare.com it parses word data and converts it into html or into a db I think, anyone on the list used this before? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
