RE: Sending (formatted) output directly to a printer
I asked: > Is there a way to format an answer set from a CF request to a > database into a report and then send it directly to a user's > printer while bypassing their browser? Bryan said: > First off...printing from the web can be pretty > tough...especially sending straight to printer (unless the > printer is connected to the server and the client has access > to that printer.like in an intranet setup). If memory > servesthe straight to printer only works in IE. I should have mentioned that we are dealing with an intranet that has 1500 offices spread across the country . . . and we are standardized on MSIE for our browser . . . the print output would need to be directed to the printer that is associated with a user, regardless of where their office is . . . Bryan also said: > Have you considered generating an Excel or PDF file on the > fly and simply making it available to download? Yes, we are considering this, but this raises a number of security issues as there will be sensitive data in the output files. And as you mentioned, it's not 'direct to printer'. We are quite curious to see if Blackstone's PDF functionality would help us with this approach. Bryan also said: > It's _javascript_ based if memory serves (may also be a COM > based method)and all it does is open the print dialogue > (equivalent of hitting the print button in the browser)...NOT > actually start the print job. We are already using this to allow users to print what they have displaying in their browser. Michael said: > It is sometimes a mistake to try and replicate an existing > system exactly if that does not fit your new delivery medium. > Some re-education of users has been required. Yep, right with you on that one. Unfortunately our users are persistent in requesting this functionality. So I revisit this issue about once a year and re-post it to the list hoping that someone may be aware of advances in technology that may have yielded a reasonable solution or work-around . . . Michael also said: > On a more helpful note :-) you may wish to check out the following > http://www.meadroid.com/scriptx/index.asp Thanks for the link. I'll check it out. George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sending (formatted) output directly to a printer
We have converted from a 'green screen' terminal based application written in a proprietary 4GL language to CF based system, and one of the hard lessons for us to learn was that while there are great benefits to the new system there are downsides too. It is sometimes a mistake to try and replicate an existing system exactly if that does not fit your new delivery medium. Some re-education of users has been required. On a more helpful note :-) you may wish to check out the following http://www.meadroid.com/scriptx/index.asp - Original Message - From: Earl, George <[EMAIL PROTECTED]> Date: Wed, 29 Sep 2004 15:17:00 -0400 Subject: Sending (formatted) output directly to a printer To: CF-Talk <[EMAIL PROTECTED]> Is there a way to format an answer set from a CF request to a database into a report and then send it directly to a user's printer while bypassing their browser? We are migrating a mainframe CICS application to a web application using CF and Oracle. When a user requests a listing/report, the mainframe application will return up to 300 rows to the screen, will divert between 301 to 3000 rows to the user's mainframe associated printer, and will ask the user to refine their search if the answer set reaches 3001 rows. The users want us to duplicate this 300/3000 row functionality in the web app version and they also want the capability of sending output directly to a printer regardless of how many rows are in the answer set (at times this could be as many as 5000 rows!). The output that gets directed to a printer must be formatted into a listing/report just like the output that gets displayed in the browser. I.e., the print output must have report headers, column headers, counts and totals, etc., not just be a dump of the answer set. Our dilemma is how do we format the output into a listing/report and send it directly to the user's printer while bypassing the browser? How would you do this? If this is not possible, what other alternative(s) would you consider to satisfy this requirement? We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX 6.1/Blackstone on Solaris . . . Thanks! George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Sending (formatted) output directly to a printer
I too have a new requirement that is an intranet-based application that we wish it to print directly to the printer on the server...so since its on each desktop, actually submitting everything directly to the printer (as it will grab a few extra print items based upon other requirements), not an scripted equivalent of hitting print, I can do that. :) Thanks. -Eric From: Blaine Korte [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 3:16 PM To: CF-Talk Subject: RE: Sending (formatted) output directly to a printer Wow, I didn't even know it was possible in the first place. Care to elaborate on the 'only in IE' part? I'm building an application where this would work perfect and we already require IE. Thanks, -Blaine _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 2:02 PM To: CF-Talk Subject: Re: Sending (formatted) output directly to a printer First off...printing from the web can be pretty tough...especially sending straight to printer (unless the printer is connected to the server and the client has access to that printer.like in an intranet setup). If memory servesthe straight to printer only works in IE. Secondthe formattting without display Have you considered generating an Excel or PDF file on the fly and simply making it available to download? I know it bypasses you "straight to printer" requirement...but I don't know how much success you'll have with that anyway ;-) It does however give you a consistent interface and flow without too many cross-browser issues. my couple'o'cents Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Earl, George To: CF-Talk Sent: Wednesday, September 29, 2004 12:17 PM Subject: Sending (formatted) output directly to a printer Is there a way to format an answer set from a CF request to a database into a report and then send it directly to a user's printer while bypassing their browser? We are migrating a mainframe CICS application to a web application using CF and Oracle. When a user requests a listing/report, the mainframe application will return up to 300 rows to the screen, will divert between 301 to 3000 rows to the user's mainframe associated printer, and will ask the user to refine their search if the answer set reaches 3001 rows. The users want us to duplicate this 300/3000 row functionality in the web app version and they also want the capability of sending output directly to a printer regardless of how many rows are in the answer set (at times this could be as many as 5000 rows!). The output that gets directed to a printer must be formatted into a listing/report just like the output that gets displayed in the browser. I.e., the print output must have report headers, column headers, counts and totals, etc., not just be a dump of the answer set. Our dilemma is how do we format the output into a listing/report and send it directly to the user's printer while bypassing the browser? How would you do this? If this is not possible, what other alternative(s) would you consider to satisfy this requirement? We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX 6.1/Blackstone on Solaris . . . Thanks! George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Sending (formatted) output directly to a printer
Aaaah, that's exactly what I do now.They have to confirm it, but you can get it there easily. Thanks -Blaine _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 2:21 PM To: CF-Talk Subject: Re: Sending (formatted) output directly to a printer Yep...just Google Groups something along the lines of "_javascript_ send to printer" It's _javascript_ based if memory serves (may also be a COM based method)and all it does is open the print dialogue (equivalent of hitting the print button in the browser)...NOT actually start the print job. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Blaine Korte To: CF-Talk Sent: Wednesday, September 29, 2004 1:16 PM Subject: RE: Sending (formatted) output directly to a printer Wow, I didn't even know it was possible in the first place. Care to elaborate on the 'only in IE' part? I'm building an application where this would work perfect and we already require IE. Thanks, -Blaine _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 2:02 PM To: CF-Talk Subject: Re: Sending (formatted) output directly to a printer First off...printing from the web can be pretty tough...especially sending straight to printer (unless the printer is connected to the server and the client has access to that printer.like in an intranet setup). If memory servesthe straight to printer only works in IE. Secondthe formattting without display Have you considered generating an Excel or PDF file on the fly and simply making it available to download? I know it bypasses you "straight to printer" requirement...but I don't know how much success you'll have with that anyway ;-) It does however give you a consistent interface and flow without too many cross-browser issues. my couple'o'cents Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Earl, George To: CF-Talk Sent: Wednesday, September 29, 2004 12:17 PM Subject: Sending (formatted) output directly to a printer Is there a way to format an answer set from a CF request to a database into a report and then send it directly to a user's printer while bypassing their browser? We are migrating a mainframe CICS application to a web application using CF and Oracle. When a user requests a listing/report, the mainframe application will return up to 300 rows to the screen, will divert between 301 to 3000 rows to the user's mainframe associated printer, and will ask the user to refine their search if the answer set reaches 3001 rows. The users want us to duplicate this 300/3000 row functionality in the web app version and they also want the capability of sending output directly to a printer regardless of how many rows are in the answer set (at times this could be as many as 5000 rows!). The output that gets directed to a printer must be formatted into a listing/report just like the output that gets displayed in the browser. I.e., the print output must have report headers, column headers, counts and totals, etc., not just be a dump of the answer set. Our dilemma is how do we format the output into a listing/report and send it directly to the user's printer while bypassing the browser? How would you do this? If this is not possible, what other alternative(s) would you consider to satisfy this requirement? We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX 6.1/Blackstone on Solaris . . . Thanks! George _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sending (formatted) output directly to a printer
Yep...just Google Groups something along the lines of "_javascript_ send to printer" It's _javascript_ based if memory serves (may also be a COM based method)and all it does is open the print dialogue (equivalent of hitting the print button in the browser)...NOT actually start the print job. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Blaine Korte To: CF-Talk Sent: Wednesday, September 29, 2004 1:16 PM Subject: RE: Sending (formatted) output directly to a printer Wow, I didn't even know it was possible in the first place. Care to elaborate on the 'only in IE' part? I'm building an application where this would work perfect and we already require IE. Thanks, -Blaine _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 2:02 PM To: CF-Talk Subject: Re: Sending (formatted) output directly to a printer First off...printing from the web can be pretty tough...especially sending straight to printer (unless the printer is connected to the server and the client has access to that printer.like in an intranet setup). If memory servesthe straight to printer only works in IE. Secondthe formattting without display Have you considered generating an Excel or PDF file on the fly and simply making it available to download? I know it bypasses you "straight to printer" requirement...but I don't know how much success you'll have with that anyway ;-) It does however give you a consistent interface and flow without too many cross-browser issues. my couple'o'cents Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Earl, George To: CF-Talk Sent: Wednesday, September 29, 2004 12:17 PM Subject: Sending (formatted) output directly to a printer Is there a way to format an answer set from a CF request to a database into a report and then send it directly to a user's printer while bypassing their browser? We are migrating a mainframe CICS application to a web application using CF and Oracle. When a user requests a listing/report, the mainframe application will return up to 300 rows to the screen, will divert between 301 to 3000 rows to the user's mainframe associated printer, and will ask the user to refine their search if the answer set reaches 3001 rows. The users want us to duplicate this 300/3000 row functionality in the web app version and they also want the capability of sending output directly to a printer regardless of how many rows are in the answer set (at times this could be as many as 5000 rows!). The output that gets directed to a printer must be formatted into a listing/report just like the output that gets displayed in the browser. I.e., the print output must have report headers, column headers, counts and totals, etc., not just be a dump of the answer set. Our dilemma is how do we format the output into a listing/report and send it directly to the user's printer while bypassing the browser? How would you do this? If this is not possible, what other alternative(s) would you consider to satisfy this requirement? We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX 6.1/Blackstone on Solaris . . . Thanks! George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Sending (formatted) output directly to a printer
Wow, I didn't even know it was possible in the first place. Care to elaborate on the 'only in IE' part? I'm building an application where this would work perfect and we already require IE. Thanks, -Blaine _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 2:02 PM To: CF-Talk Subject: Re: Sending (formatted) output directly to a printer First off...printing from the web can be pretty tough...especially sending straight to printer (unless the printer is connected to the server and the client has access to that printer.like in an intranet setup). If memory servesthe straight to printer only works in IE. Secondthe formattting without display Have you considered generating an Excel or PDF file on the fly and simply making it available to download? I know it bypasses you "straight to printer" requirement...but I don't know how much success you'll have with that anyway ;-) It does however give you a consistent interface and flow without too many cross-browser issues. my couple'o'cents Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Earl, George To: CF-Talk Sent: Wednesday, September 29, 2004 12:17 PM Subject: Sending (formatted) output directly to a printer Is there a way to format an answer set from a CF request to a database into a report and then send it directly to a user's printer while bypassing their browser? We are migrating a mainframe CICS application to a web application using CF and Oracle. When a user requests a listing/report, the mainframe application will return up to 300 rows to the screen, will divert between 301 to 3000 rows to the user's mainframe associated printer, and will ask the user to refine their search if the answer set reaches 3001 rows. The users want us to duplicate this 300/3000 row functionality in the web app version and they also want the capability of sending output directly to a printer regardless of how many rows are in the answer set (at times this could be as many as 5000 rows!). The output that gets directed to a printer must be formatted into a listing/report just like the output that gets displayed in the browser. I.e., the print output must have report headers, column headers, counts and totals, etc., not just be a dump of the answer set. Our dilemma is how do we format the output into a listing/report and send it directly to the user's printer while bypassing the browser? How would you do this? If this is not possible, what other alternative(s) would you consider to satisfy this requirement? We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX 6.1/Blackstone on Solaris . . . Thanks! George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sending (formatted) output directly to a printer
First off...printing from the web can be pretty tough...especially sending straight to printer (unless the printer is connected to the server and the client has access to that printer.like in an intranet setup). If memory servesthe straight to printer only works in IE. Secondthe formattting without display Have you considered generating an Excel or PDF file on the fly and simply making it available to download? I know it bypasses you "straight to printer" requirement...but I don't know how much success you'll have with that anyway ;-) It does however give you a consistent interface and flow without too many cross-browser issues. my couple'o'cents Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Earl, George To: CF-Talk Sent: Wednesday, September 29, 2004 12:17 PM Subject: Sending (formatted) output directly to a printer Is there a way to format an answer set from a CF request to a database into a report and then send it directly to a user's printer while bypassing their browser? We are migrating a mainframe CICS application to a web application using CF and Oracle. When a user requests a listing/report, the mainframe application will return up to 300 rows to the screen, will divert between 301 to 3000 rows to the user's mainframe associated printer, and will ask the user to refine their search if the answer set reaches 3001 rows. The users want us to duplicate this 300/3000 row functionality in the web app version and they also want the capability of sending output directly to a printer regardless of how many rows are in the answer set (at times this could be as many as 5000 rows!). The output that gets directed to a printer must be formatted into a listing/report just like the output that gets displayed in the browser. I.e., the print output must have report headers, column headers, counts and totals, etc., not just be a dump of the answer set. Our dilemma is how do we format the output into a listing/report and send it directly to the user's printer while bypassing the browser? How would you do this? If this is not possible, what other alternative(s) would you consider to satisfy this requirement? We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX 6.1/Blackstone on Solaris . . . Thanks! George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]