ProFox July 2021

profox@leafe.com

19 participants
14 discussions

RE: Pringing PDFs via ShellExecute from VFP
by Philip Borkholder 02 Jul '21

02 Jul '21

Thanks Chris! ---------- Original Message ---------- From: Chris Davis <chrisd(a)actongate.co.uk> To: profoxtech(a)leafe.com Subject: RE: Pringing PDFs via ShellExecute from VFP Date: Fri, 2 Jul 2021 09:43:35 +0000 Hi Philip I had the same problem recently and switched with success to http://www.columbia.edu/~em36/pdftoprinter.html as sometimes we found adobe would leave itself open so any checks to see if it was still running couldn't be relied on. Then using the following ShellExecute code ... you will notice my method on the form agcheckexe("pdftoprinter.exe"), I have included that code as well as this basically loops until any previous instances have finished before it launches again for the next PDF you want to queue up ... && PDF PRINT METHOD LPARAMETERS lcfilename lcfilename=ALLTRIM(TRANSFORM(lcfilename)) declare INTEGER ShellExecute in shell32 INTEGER handle, STRING @ oper, ; STRING @ ifile, STRING @ iparam, STRING @ ipath, INTEGER showcmd lcfile="c:\pdfprinter\pdftoprinter.exe" lcpath="" lcparam=["]+lcfilename+["] DO WHILE thisform.agcheckexe("pdftoprinter.exe") ENDDO shellexecute(0,"open",lcfile,lcparam,lcpath,1) ========================= && AGCHECKEXE METHOD LPARAMETERS tcName, tlTerminate LOCAL loLocator, loWMI, loProcesses, loProcess, llIsRunning loLocator = CREATEOBJECT('WBEMScripting.SWBEMLocator') loWMI = loLocator.ConnectServer() loWMI.Security_.ImpersonationLevel = 3 && Impersonate loProcesses = loWMI.ExecQuery([SELECT * FROM Win32_Process WHERE Name = '] + tcName + [']) llIsRunning = .F. IF loProcesses.Count > 0 FOR EACH loProcess in loProcesses llIsRunning = .T. IF tlTerminate loProcess.Terminate(0) ENDIF ENDFOR ENDIF RETURN llIsRunning ============================ Regards Chris -----Original Message----- From: ProfoxTech <profoxtech-bounces(a)leafe.com> On Behalf Of Philip Borkholder Sent: 01 July 2021 20:55 To: profoxtech(a)leafe.com Subject: Pringing PDFs via ShellExecute from VFP Hi all, I am currently printing VFP reports in sequence, then using ShellExecute to print PDFs via their default program (Adobe DC). I am trying to keep each print job in sequence so they come out in the tray together: Example: WO #1 Drawings for WO #1 (PDF via ShellExecute) WO #2 Drawings for WO #1 (PDF via ShellExecute) etc. What I'm running into is sometimes WO#2 prints out before WO#1's PDF prints from Adobe DC. Does anyone have experience in using a Windows API to see if Adobe has printed the PDF before I can continue printing my next VFP form? Thanks Philip B Bison Tech Plus [excessive quoting removed by server]

1 0

PDF printing on WINE & Win98
by Jürgen Wondzinski 02 Jul '21

02 Jul '21

Ok, now it's my turn for a problem solving: I inherited a customer, who runs a VFP6 app on a WINE on Linux setup. The emulated Windows version is a Win98. The original developer and SysAdmin left the company. (After looking at the codebase, I now know why) I was able to successfully recompile it in VFP9 and fix some idiotic things. Now the customer wants to print reports to PDF and then create an email (pure text), attach that PDF and mail it by SMTP. All that without using the new printengine (that is slower than molasses on that installation), and no COM object (since WINE is version 1.1.9 from 2006) Has anybody experience with a simple DLL only solution for that scenario? wOOdy

2 1

Pringing PDFs via ShellExecute from VFP
by Philip Borkholder 02 Jul '21

02 Jul '21

Hi all, I am currently printing VFP reports in sequence, then using ShellExecute to print PDFs via their default program (Adobe DC). I am trying to keep each print job in sequence so they come out in the tray together: Example: WO #1 Drawings for WO #1 (PDF via ShellExecute) WO #2 Drawings for WO #1 (PDF via ShellExecute) etc. What I'm running into is sometimes WO#2 prints out before WO#1's PDF prints from Adobe DC. Does anyone have experience in using a Windows API to see if Adobe has printed the PDF before I can continue printing my next VFP form? Thanks Philip B Bison Tech Plus

3 2

ProFox List Statistics for June 2021
by List Administrator Account 01 Jul '21

01 Jul '21

================================================== ProFox List Statistics June 2021 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 183 ================================================== Total Posts: 86 (Up 40.98% from May 2021) Total [OT] Posts: 0 (Unchanged from May 2021) Total [NF] Posts: 1 (Up 100.0% from May 2021) Daily Message Counts for June 2021 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 7 W 2 - 5 T 3 - 2 M 7 - 8 T 8 - 1 W 9 - 6 T 10 - 1 T 15 - 2 W 16 - 9 T 17 - 1 F 18 - 4 S 19 - 2 M 21 - 1 T 24 - 3 F 25 - 4 S 27 - 2 M 28 - 17 T 29 - 11 Message Counts By Day of Week for June 2021 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 26 Tue - 21 Wed - 20 Thu - 7 Fri - 8 Sat - 2 Distinct Posters to the List (changes relative to May 2021) ------------------------------------------------ Non-OT messages: 29 (Up 93.33%) OT messages: 0 (Unchanged) NF messages: 1 (Up 100.0%) Total number: 29 (Up 93.33%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Chris Davis 2. 9 Alan Bourke 3. 6 Tracy Pearson 4. 6 Jürgen Wondzinski 5. 5 Frank Cazabon 6. 5 Charles Hart Enzer, M.D. 7. 5 Eric Selje 8. 4 MB Software Solutions, LLC 9. 4 Jan Bucek 10. 3 Philip Borkholder 11. 3 Ted Roche 12. 3 Michael Oke, II 13. 3 Vince Teachout 14. 2 Malcolm Greene 15. 2 Richard Kaye 16. 2 Stephen Russell 17. 1 List Administrator Account 18. 1 Christof Wollenhaupt 19. 1 Eric Selje 20. 1 Man-wai Chang Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 1 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Stephen Russell Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Chris Davis 2. 9 Alan Bourke 3. 6 Tracy Pearson 4. 6 Jürgen Wondzinski 5. 5 Frank Cazabon 6. 5 Charles Hart Enzer, M.D. 7. 5 Eric Selje 8. 4 MB Software Solutions, LLC 9. 4 Jan Bucek 10. 3 Philip Borkholder 11. 3 Ted Roche 12. 3 Michael Oke, II 13. 3 Vince Teachout 14. 2 Malcolm Greene 15. 2 Richard Kaye 16. 2 Stephen Russell 17. 1 List Administrator Account 18. 1 Christof Wollenhaupt 19. 1 Eric Selje 20. 1 Man-wai Chang Top 12 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Chris Davis 2. 1 List Administrator Account 3. 1 Jürgen Wondzinski 4. 1 Frank Cazabon 5. 1 Rick Schummer 6. 1 Eric Selje 7. 1 Vince Teachout 8. 1 Stephen Russell 9. 1 Tracy Pearson 10. 1 Philip Borkholder 11. 1 Charles Hart Enzer, M.D. 12. 1 MB Software Solutions, LLC Top 16 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 15 Windows 11??? 2. 15 Printing PDF's 3. 10 Strange display of DropDownList in Grid 4. 8 FPW26a 5. 7 Builders and the VFP Undo function 6. 7 SP2 Download? 7. 7 FoxPro 2.6 for Windows App 8. 5 ShellExecute 9. 3 SOLVED: Bizarre Desktop write problem driving me mad 10. 3 AW: FPW26a 11. 1 ProFox List Statistics for May 2021 12. 1 PDF printing on WINE & Win98 13. 1 Virtual Fox Fest 2021 (Oct): Call for Speakers Reminder 14. 1 AW: Printing PDF's 15. 1 [NF] Python and where it is going. 16. 1 AW: SP2 Download? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 16 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 15 Windows 11??? 2. 15 Printing PDF's 3. 10 Strange display of DropDownList in Grid 4. 8 FPW26a 5. 7 Builders and the VFP Undo function 6. 7 SP2 Download? 7. 7 FoxPro 2.6 for Windows App 8. 5 ShellExecute 9. 3 SOLVED: Bizarre Desktop write problem driving me mad 10. 3 AW: FPW26a 11. 1 ProFox List Statistics for May 2021 12. 1 PDF printing on WINE & Win98 13. 1 Virtual Fox Fest 2021 (Oct): Call for Speakers Reminder 14. 1 AW: Printing PDF's 15. 1 [NF] Python and where it is going. 16. 1 AW: SP2 Download?

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2021