ProFox September 2018

profox@leafe.com

32 participants
28 discussions

2 Excel questions using automation from VFP9SP2
by mbsoftwaresolutions＠mbsoftwaresolutions.com 07 Sep '18

07 Sep '18

See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D 1) (rose highlight) I've forgotten how to get Excel to close without asking me this every time. Currently, I'm just calling the .Quit() method of my Excel object. I tried passing a .T. parm but that failed. 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS formula to work in VFP? Would be neat to have this and I thought perhaps someone already built it. tia, --Mike

7 18

SOAP
by Chris Davis 06 Sep '18

06 Sep '18

Is anyone able to share an example of working with a webservice purely in code? Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 15

Re: Office 2016 Outlook Problem: Throttled Output
by Gene Wirchenko 06 Sep '18

06 Sep '18

At 02:46 2018-09-05, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: >On Tue, 4 Sep 2018, at 7:35 PM, Kevin J Cully wrote: > > Instead of using Outlook automation, and risking it breaking during > > every upgrade, and potentially being marked as a spammer, perhaps using > > a transactional email service might be an approach to consider. > >This is definitely the way to go these days for bulk sending. >Outlook, and specifically Outlook connected to hosted Exchange, is >not designed to do bulk sends. The problem happens on the *first* E-mail. We are not doing bulk sends. Each of the E-mails is different. They are monthly invoices and possibly some other reports. There are less than 100 of them, and they are sent one at a time as they get completed. [snip] Sincerely, Gene Wirchenko

2 1

Office 2016 Outlook Problem: Throttled Output
by Gene Wirchenko 05 Sep '18

05 Sep '18

Hello: I have an in-house client billing system application that I wrote and maintain. It runs under VFP 9. One of the functions is to E-mail invoices and reports. This program composes an E-mail and attaches the appropriate files accessing Outlook through automation. Production was using Outlook 2010. That worked fine. Production now has Office 2016 Outlook. This still works, but when sending the E-mail through automation, there is a delay of a few minutes. This is for *just one* E-mail. When, instead, a E-mail is generated and saved through the VFP program and then sent by the operator manually in Outlook, there is no delay. Is there any way to get around this delay and still send through automation in the VFP program? If i have left out any significant details, please let me know. I do not know Outlook nearly as well as I know VFP. Sincerely, Gene Wirchenko

5 6

Re: Office 2016 Outlook Problem: Throttled Output
by Gene Wirchenko 05 Sep '18

05 Sep '18

At 01:32 2018-09-03, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: > > This program composes an E-mail and attaches the > > appropriate files accessing Outlook through automation. > >How exactly - MAPI, the Outlook object model, etc? I do not know. I assume the Outlook object model, because I am creating and manipulating objects. I got the basic code out of a Hertzenwerke book. Sincerely, Gene Wirchenko

1 0

RE: Office 2016 Outlook Problem: Throttled Output
by Gene Wirchenko 05 Sep '18

05 Sep '18

At 14:09 2018-09-02, Chris Davis <chrisd(a)actongate.co.uk> wrote: >Are there any messages or dialogues displayed or is it simply just a delay? He did not say anything about a message, so I assume not. [snipped previous] Sincerely, Gene Wirchenko

1 0

ProFox List Statistics for August 2018
by List Administrator Account 01 Sep '18

01 Sep '18

================================================== ProFox List Statistics August 2018 ================================================== Subscriber Count at End of Month: ProFox: 291 ProFoxTech: 182 ================================================== Total Posts: 157 (Up 27.64% from July 2018) Total [OT] Posts: 0 (Unchanged from July 2018) Total [NF] Posts: 27 (Down 49.06% from July 2018) Daily Message Counts for August 2018 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 19 T 2 - 6 F 3 - 22 S 5 - 1 M 6 - 1 T 7 - 1 W 8 - 11 T 9 - 6 F 10 - 2 T 14 - 4 W 15 - 5 T 16 - 6 F 17 - 9 M 20 - 4 W 22 - 18 T 23 - 4 F 24 - 10 S 25 - 1 M 27 - 3 T 28 - 12 W 29 - 3 F 31 - 9 Message Counts By Day of Week for August 2018 ------------------------------------------------ DOW Count --- ----- Sun - 1 Mon - 8 Tue - 17 Wed - 56 Thu - 22 Fri - 52 Sat - 1 Distinct Posters to the List (changes relative to July 2018) ------------------------------------------------ Non-OT messages: 31 (Down 6.06%) OT messages: 0 (Unchanged) NF messages: 13 (Down 18.75%) Total number: 31 (Down 6.06%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 22 Alan Bourke 2. 19 Dave Crozier 3. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 11 Ted Roche 5. 8 Stephen Russell 6. 7 Paul H. Tarver 7. 7 Malcolm Greene 8. 6 Ken Dibble 9. 5 John Weller 10. 5 Gene Wirchenko 11. 5 Vince Teachout 12. 4 Eric Selje 13. 4 Fernando D. Bozzo 14. 4 Richard Kaye 15. 4 Koen Piller 16. 4 Ed Leafe 17. 3 Paul Newton 18. 3 Garrett Fitzgerald 19. 3 Philip Borkholder 20. 2 roger tremblay Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 13 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Vince Teachout 2. 4 John Weller 3. 3 Koen Piller 4. 3 Alan Bourke 5. 2 Richard Kaye 6. 2 Dave Crozier 7. 2 Malcolm Greene 8. 2 Eric Selje 9. 1 Fernando D. Bozzo 10. 1 Ted Roche 11. 1 Michael Glassman 12. 1 Paul Hemans 13. 1 mbsoftwaresolutions(a)mbsoftwaresolutions.com Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 22 Alan Bourke 2. 19 Dave Crozier 3. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 11 Ted Roche 5. 8 Stephen Russell 6. 7 Paul H. Tarver 7. 7 Malcolm Greene 8. 6 Ken Dibble 9. 5 John Weller 10. 5 Gene Wirchenko 11. 5 Vince Teachout 12. 4 Eric Selje 13. 4 Fernando D. Bozzo 14. 4 Richard Kaye 15. 4 Koen Piller 16. 4 Ed Leafe 17. 3 Paul Newton 18. 3 Garrett Fitzgerald 19. 3 Philip Borkholder 20. 2 roger tremblay Top 15 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 2 Alan Bourke 3. 2 Ken Dibble 4. 1 Dave Crozier 5. 1 List Administrator Account 6. 1 Paul H. Tarver 7. 1 John Weller 8. 1 Philip Borkholder 9. 1 Ted Roche 10. 1 Vinny Terrabella 11. 1 Vince Teachout 12. 1 Vince Teachout 13. 1 Rafael Copquin 14. 1 Paul Newton 15. 1 Michael Glassman Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 27 Lianja anyone? 2. 16 Optimised search of memo data. 3. 12 Test Email 4. 10 Determining Text File Encoding 5. 9 Test One-Two, *tink* *tink* is this thing on? 6. 9 ReFox Experience 7. 9 [NF] Form Controls Toolbar 8. 8 [NF] Recommendations for online PHP course? 9. 8 [NF] Server OS in a VM on a client OS box 10. 7 [ADMIN] Still No Messages Since August 2 11. 6 MCP ID 12. 5 Ooopsy test 13. 5 [ADMIN] No Messages Since August 2 14. 5 Error 1150 - Not enough memory for file map 15. 4 Contacting folks on GitHub 16. 4 between clause in TSQL (from VFP9) 17. 3 Frustrations on anchor=15 resizing not happening until I go off the page and come back to it 18. 2 Frustrations on anchor=15 resizing not happening until I go off the page and come back to it (SOLVED) 19. 1 Every day a school day. 20. 1 FoxCharts pie question Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 27 Lianja anyone? 2. 16 Optimised search of memo data. 3. 12 Test Email 4. 10 Determining Text File Encoding 5. 9 Test One-Two, *tink* *tink* is this thing on? 6. 9 ReFox Experience 7. 9 [NF] Form Controls Toolbar 8. 8 [NF] Recommendations for online PHP course? 9. 8 [NF] Server OS in a VM on a client OS box 10. 7 [ADMIN] Still No Messages Since August 2 11. 6 MCP ID 12. 5 Ooopsy test 13. 5 [ADMIN] No Messages Since August 2 14. 5 Error 1150 - Not enough memory for file map 15. 4 Contacting folks on GitHub 16. 4 between clause in TSQL (from VFP9) 17. 3 Frustrations on anchor=15 resizing not happening until I go off the page and come back to it 18. 2 Frustrations on anchor=15 resizing not happening until I go off the page and come back to it (SOLVED) 19. 1 Every day a school day. 20. 1 FoxCharts pie question

3 2

Test One-Two, *tink* *tink* is this thing on?
by Ted Roche 01 Sep '18

01 Sep '18

Just checking to see if the Internet has unsubscribed us all, again. Happy Labor Day to my US friends and first-day of school to northern hemisphere types. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

8 7

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox September 2018