Re: pdf to email
Hi Raido, We accomplish this by using the remedy email engine, Crystal Enterprise 9 and an ASP page. The result is the user clicks a button and an email window opens with the PDF already attached to the attachment pool. The user can then edit the body of the email and click send. To do this, our workflow first calls the asp page with an active link/OLE action. The ASP page runs the report, converts it to pdf and saves it to a network location. The asp/ie browser page is invisible to users. After the pdf is stored to a network location, we have workflow that grabs the pdf and attaches it to an attachment pool. The user can then add any comments to the body of the email and click send (with pdf attached). Contact me off-line if you'd like more info. Thanks, Karee [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Raido Oja Sent: Thursday, August 24, 2006 11:19 AM To: arslist@ARSLIST.ORG Subject: Re: pdf to email Thanks for the feedback, but likewise - I'm not an OLE guru.. and we don't use Crystal. I'm abandoning the idea of automating the exact scenario for now. Not long ago there was a thread named "automatically generate email with report included". Thomas Bean's solution should work for my case as well in its general idea. Raido Oja [EMAIL PROTECTED] patrick zandi wrote: > There might be a way threw Crystal Reports.. there is an Export > function in the viewer to a PDF format.. I would think.. that there > might be a Way just to make the report a PDF and save it to a file.. > Never every tried that .. but it might be worth looking at. OR I > recently saw somewhere .. Someone had an api with a built in PDF > functionality ? is PDF open source now ? > > On 8/24/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: >> ** I guess you could the File > Pint bit using OLE automation. Macros >> only >> do searches or data maniputation, not printing afaik. >> I am not an OLE guru so I can not advice you how this should be done, >> but >> you might have access to a tech with OLE skills yourself or try some >> googling... >> -- >> Michiel >> >> On 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: >> > Hi, >> > >> > At present I have the following scenario: >> > - user opens a display only form with some formatted character fields >> > - prints to a virtual pdf printer (using file > print) >> > - sends the .pdf via his default mail program as an attachment >> > >> > I need to automate that process. I can save the pdf to the email >> > messages form as an attachment using run process commands in an AL. >> The >> > tricky part for me is actually generating the pdf. Can I do the >> 'file > >> > print' command in a macro ? (having the printer and file name as >> > parameters). This would be the first time for me to work with >> macros so >> > any help is greatly appreciated. I'm also having a hard time finding >> > material on macros, there's not much in Remedy's docs. Am I even on >> the >> > right track with this solution ? >> > >> > Raido Oja >> > [EMAIL PROTECTED] >> > >> > >> ___ >> >> > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> > >> >> __20060125___This posting was submitted >> with HTML in it___ > > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pdf to email
Scott, Just FYI - There are alternatives to using Acrobat to create files and eliminate the need to keep a static pdf.ini that needs to be copied. The thread "Saving Crystal Reports output as pdf to a predetermined file" from May 8 has info on using RedMon and Ghostscript. HTH Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 24, 2006 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: pdf to email If you utilize the PDF Writer (not the PDF Distiller) as your virtual printer, you can utilize a pdf.ini file and specify the path and filename of your "printed" report. However, after the printer utilizes the pdf.ini once, it removes the path and filename from the pdf.ini (why, I don't know). What I have done in the past is create workflow that 1. Copies a static pdf.ini file that has the filename included, 2. Print the report to the virtual printer, 3. Rename the just-created pdf file (easy enough since it's static in the pdf.ini), 4. Attach the file to the email, 5. Re-copy the static pdf.ini for use next time. It works very well. Scott Parrish IT Prophets Original Message: - From: patrick zandi [EMAIL PROTECTED] Date: Thu, 24 Aug 2006 10:44:37 -0400 To: arslist@ARSLIST.ORG Subject: Re: pdf to email There might be a way threw Crystal Reports.. there is an Export function in the viewer to a PDF format.. I would think.. that there might be a Way just to make the report a PDF and save it to a file.. Never every tried that .. but it might be worth looking at. OR I recently saw somewhere .. Someone had an api with a built in PDF functionality ? is PDF open source now ? On 8/24/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: > ** I guess you could the File > Pint bit using OLE automation. Macros > only do searches or data maniputation, not printing afaik. > I am not an OLE guru so I can not advice you how this should be done, > but you might have access to a tech with OLE skills yourself or try > some googling... > -- > Michiel > > On 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: > > Hi, > > > > At present I have the following scenario: > > - user opens a display only form with some formatted character > > fields > > - prints to a virtual pdf printer (using file > print) > > - sends the .pdf via his default mail program as an attachment > > > > I need to automate that process. I can save the pdf to the email > > messages form as an attachment using run process commands in an AL. > > The tricky part for me is actually generating the pdf. Can I do the > > 'file > print' command in a macro ? (having the printer and file > > name as parameters). This would be the first time for me to work > > with macros so any help is greatly appreciated. I'm also having a > > hard time finding material on macros, there's not much in Remedy's > > docs. Am I even on the right track with this solution ? > > > > Raido Oja > > [EMAIL PROTECTED] > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > __20060125___This posting was submitted with HTML > in it___ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org mail2web - Check your email from the web at http://mail2web.com/ . ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pdf to email
If you utilize the PDF Writer (not the PDF Distiller) as your virtual printer, you can utilize a pdf.ini file and specify the path and filename of your "printed" report. However, after the printer utilizes the pdf.ini once, it removes the path and filename from the pdf.ini (why, I don't know). What I have done in the past is create workflow that 1. Copies a static pdf.ini file that has the filename included, 2. Print the report to the virtual printer, 3. Rename the just-created pdf file (easy enough since it's static in the pdf.ini), 4. Attach the file to the email, 5. Re-copy the static pdf.ini for use next time. It works very well. Scott Parrish IT Prophets Original Message: - From: patrick zandi [EMAIL PROTECTED] Date: Thu, 24 Aug 2006 10:44:37 -0400 To: arslist@ARSLIST.ORG Subject: Re: pdf to email There might be a way threw Crystal Reports.. there is an Export function in the viewer to a PDF format.. I would think.. that there might be a Way just to make the report a PDF and save it to a file.. Never every tried that .. but it might be worth looking at. OR I recently saw somewhere .. Someone had an api with a built in PDF functionality ? is PDF open source now ? On 8/24/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: > ** I guess you could the File > Pint bit using OLE automation. Macros only > do searches or data maniputation, not printing afaik. > I am not an OLE guru so I can not advice you how this should be done, but > you might have access to a tech with OLE skills yourself or try some > googling... > -- > Michiel > > On 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: > > Hi, > > > > At present I have the following scenario: > > - user opens a display only form with some formatted character fields > > - prints to a virtual pdf printer (using file > print) > > - sends the .pdf via his default mail program as an attachment > > > > I need to automate that process. I can save the pdf to the email > > messages form as an attachment using run process commands in an AL. The > > tricky part for me is actually generating the pdf. Can I do the 'file > > > print' command in a macro ? (having the printer and file name as > > parameters). This would be the first time for me to work with macros so > > any help is greatly appreciated. I'm also having a hard time finding > > material on macros, there's not much in Remedy's docs. Am I even on the > > right track with this solution ? > > > > Raido Oja > > [EMAIL PROTECTED] > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > __20060125___This posting was submitted > with HTML in it___ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org mail2web - Check your email from the web at http://mail2web.com/ . ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pdf to email
Thanks for the feedback, but likewise - I'm not an OLE guru.. and we don't use Crystal. I'm abandoning the idea of automating the exact scenario for now. Not long ago there was a thread named "automatically generate email with report included". Thomas Bean's solution should work for my case as well in its general idea. Raido Oja [EMAIL PROTECTED] patrick zandi wrote: There might be a way threw Crystal Reports.. there is an Export function in the viewer to a PDF format.. I would think.. that there might be a Way just to make the report a PDF and save it to a file.. Never every tried that .. but it might be worth looking at. OR I recently saw somewhere .. Someone had an api with a built in PDF functionality ? is PDF open source now ? On 8/24/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: ** I guess you could the File > Pint bit using OLE automation. Macros only do searches or data maniputation, not printing afaik. I am not an OLE guru so I can not advice you how this should be done, but you might have access to a tech with OLE skills yourself or try some googling... -- Michiel On 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: > Hi, > > At present I have the following scenario: > - user opens a display only form with some formatted character fields > - prints to a virtual pdf printer (using file > print) > - sends the .pdf via his default mail program as an attachment > > I need to automate that process. I can save the pdf to the email > messages form as an attachment using run process commands in an AL. The > tricky part for me is actually generating the pdf. Can I do the 'file > > print' command in a macro ? (having the printer and file name as > parameters). This would be the first time for me to work with macros so > any help is greatly appreciated. I'm also having a hard time finding > material on macros, there's not much in Remedy's docs. Am I even on the > right track with this solution ? > > Raido Oja > [EMAIL PROTECTED] > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pdf to email
There might be a way threw Crystal Reports.. there is an Export function in the viewer to a PDF format.. I would think.. that there might be a Way just to make the report a PDF and save it to a file.. Never every tried that .. but it might be worth looking at. OR I recently saw somewhere .. Someone had an api with a built in PDF functionality ? is PDF open source now ? On 8/24/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: ** I guess you could the File > Pint bit using OLE automation. Macros only do searches or data maniputation, not printing afaik. I am not an OLE guru so I can not advice you how this should be done, but you might have access to a tech with OLE skills yourself or try some googling... -- Michiel On 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: > Hi, > > At present I have the following scenario: > - user opens a display only form with some formatted character fields > - prints to a virtual pdf printer (using file > print) > - sends the .pdf via his default mail program as an attachment > > I need to automate that process. I can save the pdf to the email > messages form as an attachment using run process commands in an AL. The > tricky part for me is actually generating the pdf. Can I do the 'file > > print' command in a macro ? (having the printer and file name as > parameters). This would be the first time for me to work with macros so > any help is greatly appreciated. I'm also having a hard time finding > material on macros, there's not much in Remedy's docs. Am I even on the > right track with this solution ? > > Raido Oja > [EMAIL PROTECTED] > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pdf to email
** I guess you could the File > Pint bit using OLE automation. Macros only do searches or data maniputation, not printing afaik.I am not an OLE guru so I can not advice you how this should be done, but you might have access to a tech with OLE skills yourself or try some googling... --MichielOn 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: Hi,At present I have the following scenario:- user opens a display only form with some formatted character fields- prints to a virtual pdf printer (using file > print)- sends the .pdf via his default mail program as an attachment I need to automate that process. I can save the pdf to the emailmessages form as an attachment using run process commands in an AL. Thetricky part for me is actually generating the pdf. Can I do the 'file > print' command in a macro ? (having the printer and file name asparameters). This would be the first time for me to work with macros soany help is greatly appreciated. I'm also having a hard time findingmaterial on macros, there's not much in Remedy's docs. Am I even on the right track with this solution ?Raido Oja[EMAIL PROTECTED]___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
pdf to email
Hi, At present I have the following scenario: - user opens a display only form with some formatted character fields - prints to a virtual pdf printer (using file > print) - sends the .pdf via his default mail program as an attachment I need to automate that process. I can save the pdf to the email messages form as an attachment using run process commands in an AL. The tricky part for me is actually generating the pdf. Can I do the 'file > print' command in a macro ? (having the printer and file name as parameters). This would be the first time for me to work with macros so any help is greatly appreciated. I'm also having a hard time finding material on macros, there's not much in Remedy's docs. Am I even on the right track with this solution ? Raido Oja [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org