ProFox

profox@leafe.com

2704 discussions

ChilkatVFP 1.33 Released
by Bill Anderson 04 Apr '24

04 Apr '24

Folks, Another update... https://github.com/billand88/ChilkatVFP Issues addressed: 1) Chilkat v98 compatibility. 2) Much better multi-language support for ChilkatVFP dialogs. 3) New document "Using the Chilkat Class Library", using language changes as a proxy for understanding the class library construction. Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

ProFox List Statistics for March 2024
by List Administrator Account 01 Apr '24

01 Apr '24

================================================== ProFox List Statistics March 2024 ================================================== Subscriber Count at End of Month: ProFox: 306 ProFoxTech: 184 ================================================== Total Posts: 20 (Up 400.0% from February 2024) Total [OT] Posts: 0 (Unchanged from February 2024) Total [NF] Posts: 0 (Unchanged from February 2024) Daily Message Counts for March 2024 ------------------------------------------------ DOW Date Count --- ---- ----- F 1 - 4 M 4 - 3 T 5 - 1 W 6 - 2 T 7 - 3 S 10 - 1 W 27 - 3 T 28 - 3 Message Counts By Day of Week for March 2024 ------------------------------------------------ DOW Count --- ----- Sun - 1 Mon - 3 Tue - 1 Wed - 5 Thu - 6 Fri - 4 Distinct Posters to the List (changes relative to February 2024) ------------------------------------------------ Non-OT messages: 10 (Up 150.0%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 10 (Up 150.0%) Top 10 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 7 Paul H. Tarver 2. 3 Kurt Wendt 3. 3 Alan Bourke 4. 1 Rick Schummer 5. 1 Desmond Lloyd 6. 1 List Administrator Account 7. 1 Graham Brown 8. 1 Eric Selje 9. 1 Christof Wollenhaupt 10. 1 Ajit Abraham Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 10 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 7 Paul H. Tarver 2. 3 Kurt Wendt 3. 3 Alan Bourke 4. 1 Rick Schummer 5. 1 Desmond Lloyd 6. 1 List Administrator Account 7. 1 Graham Brown 8. 1 Eric Selje 9. 1 Christof Wollenhaupt 10. 1 Ajit Abraham Top 5 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Paul H. Tarver 2. 1 Desmond Lloyd 3. 1 List Administrator Account 4. 1 Eric Selje 5. 1 Rick Schummer Top 6 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 VFPAdvanced - My Problem, My Tests & Some Results 2. 4 Splitting PDF Files with Ghostscript 3. 2 VFP and SSO 4. 1 VFPA Shortcut Keys 5. 1 ProFox List Statistics for February 2024 6. 1 Virtual Fox Fest 2024: Speakers, sessions and registration Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 6 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 VFPAdvanced - My Problem, My Tests & Some Results 2. 4 Splitting PDF Files with Ghostscript 3. 2 VFP and SSO 4. 1 VFPA Shortcut Keys 5. 1 ProFox List Statistics for February 2024 6. 1 Virtual Fox Fest 2024: Speakers, sessions and registration

1 0

Splitting PDF Files with Ghostscript
by Paul H. Tarver 28 Mar '24

28 Mar '24

Ok, does anyone have some sample VFP code they are willing to share to help me split a PDF file with 50 pages or so into separate PDF files with one page in each file? I've tried to convert several things I've seen on multiple sites with various languages, but I've had no luck converting those to run using the WScript.Shell. Any help would be appreciated! Thanks! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

VFP and SSO
by Desmond Lloyd 27 Mar '24

27 Mar '24

Good morning. Is it possible to integrate SSO with VFP apps? Would appreciate any input... Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Virtual Fox Fest 2024: Speakers, sessions and registration
by Rick Schummer 10 Mar '24

10 Mar '24

Virtual Fox Fest 2024 is a one-day event on Wednesday, May 8, 2024. We have some great speakers (https://virtualfoxfest.com/speakers.aspx) delivering great sessions (https://virtualfoxfest.com/sessions.aspx) live chatting during presentations, and getting to hang out virtually with new and old friends. This event will feature classic sessions (from previous conferences), updated for 2024, along with at least one brand new session. More details here: https://virtualfoxfest.com/ Registration is open! Details, deadlines and cost are available on our Web site. You register for the conference here: https://geekgatherings.com/Registration. Don't procrastinate, get this done today! In case you missed it, we've already announced Southwest Fox 2024 (https://swfox.net/) in Arizona, September 26-29, 2024. More details for this hybrid conference coming in May. The in-person event will be held at the Hampton Inn & Suites Phoenix-Scottsdale and the virtual side on the Hopin platform via the Internet. Rick White Light Computing, Inc.

1 0

VFPAdvanced - My Problem, My Tests & Some Results
by Paul H. Tarver 07 Mar '24

07 Mar '24

Just got the Stats for February, 2024 and when the ProFox List Statistics for January is one of the top posts for the month of February, I realized I've been busy to comment and I assume everyone else has been busy too, so consider this a kick-off post for March to help improve or at least stimulate some conversation in here! So, last month, I took the plunge and purchased a copy of VFPA 10.2. I have a software app I wrote a long time ago to help telemarketers comply with the Telemarketing Sales Rule by scrubbing their call lists against the National Do Not Call List sold by the Federal Trade Commission. The program (which I creatively named Call List Scrubber) was originally written in VFP6 and just like VFP, it is a mature and stable product requiring little maintenance, is easy to use and is easy to support. That having been said, the full National Do Not Call List has grown to almost 3Gb in size and while we changed several years ago from using FREADs to using the Scripting.FileSystemObject, up until now we could import and store the information in a DBF and didn't exceed 2Gb by using several tricks not the least of which was storing the area codes as a 3 byte text field and the 7 digit number as an 4byte integer. Oh, and I built the original program to use IDX files instead of compound NDX files so that was another trick that helped us over the years as we dealt with the unceasing growth in the National Do Not Call List. While most of our users only purchase individual area code DNC lists from the FTC, in January we had a new client who did purchase the full national list and you guessed it, Call List Scrubber could no longer import the full National DNC list and function. So, I helped the client split the file into two roughly equal portions, set up two installs for them and they are able to function and use the product for now. But..That meant I needed to find some alternative and permanent solution. One choice and the one that most of you would probably recommend would be for me to upsize to a SQL database or perhaps use SQLite. But that would require almost a full re-write of the product and I don't really have time for that at the moment and more importantly, I don't have the motivation to do a full re-write at this time (perhaps later), so I started casting about for solutions and VFPAdvanced came to mind. I reached out to Chen via email and asked a few questions about how to implement this product which he graciously answered and I ultimately purchased version 10.2 from him to test and to play with to see if the large file fix would work in my application. The installation went very smoothly after I upgraded my installation per his instructions. I easily set up the program to run side by side with VFP9 and I have continued working in VFP9 for the majority of my work and I simply setup a new startup shortcut to use when I want to use VFPA10 instead. Works completely as advertised and does not crossover into my standard installation in any way. Now that I've completed my initial testing I'd like to share some of my results and invite some comments: First, to answer the obvious question: Yes, when I use VFPA, I can import the full National DNC file with 250Million + telephone numbers into my program without any other changes beyond recompiling with VFPA 10.2. After importing the NDNC text file (~3Gb) and stripping off the not used characters like commas, spaces, etc; the resulting finished DBF is 2.004Gb, the Area Code IDX is 1.083Gb and the full 10 digit number index is 1.750GB. Second, I did several tests with VFPA and found if I split the list into 10 separate area code files (0-100, 100-200, 200-300, etc), it took about twice as long to import and populate those tables as it did to import the full file into one DBF. Though I may need to do more testing on this idea but it seems like a convoluted solution to me so I didn't go too far with it. Third, the best performance came from a buffered import where I import the text data in batches. Each record in the NDNC file is 12 bytes long and looks like this: "999,9999999LF", so using the Scripting.FileSystemObject, I'm importing 12^6 characters (248,832 records at a time) and then I use ALINES to convert the buffered characters to an array and then insert each of the array "rows" into the DBF. This method allows me to import a grand total of 250 Million telephone numbers on the Do Not Call List, populate a DBF in excess of 2GB and update two IDX files at the same time in just under 4 hours. Some of that work was done across my internal network so I might be able to pick up some extra time by running solely on an SSD, but if someone has other ideas of how to import, populate and update IDX files any faster, please let me know. Fourth, VFPA performs very well in my tests. I have found nothing that isn't compatible with the original VFP6 code and I suspect I won't find any major differences in VFP9 code because I'm using both VFP6 and VFP9 class libraries in my tests and everything works as expected. Chen has been responsive to my questions and released an update even as I was writing this. I'm not sure I'm ready to cut over to VFPA for my primary development work, but this is looking like a great option in this particular situation. Finally, there is one issue that concerns me at this point and that is with memory usage. During an import test like the ones I've described here, I see memory usage by VFP and the Large Memory module that Chen provides grow from the 500Mb I usually see when running one of my VFP applications to 2 to 2.5 GB. I have a suspicion this is caused by the two IDX files I have open while doing the import. I'm opening the IDX files with the DBF file so that they are updated as the data is inserted into the DBF. This may not be the best way to do things because perhaps recreating the indexes after the import is complete may be faster, BUT, I'm not sure how to provide user feedback on the progress of the indexing process and maybe I just need someone to guide me on this point. I'll have to test doing the import without the IDX files open to confirm my thoughts about the memory usage during the import, but the most important issue is that the memory that gets allocated during the import process isn't released when I close the table and the indexes. In fact, it isn't released at all until I close VFPA and restart it. Does anyone have an insight into this memory usage weirdness I'm seeing? Ok, I know this is a long email, but I'm trying to start some conversation and there are several points I think y'all can help me with so have at it. Any feedback is helpful for this situation let me know what you know! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 9

VFPA Shortcut Keys
by Eric Selje 01 Mar '24

01 Mar '24

I just got the latest VFPA updates email, and was struck by how awesome the new keyboard shortcuts are: NEW.....] VFP 9.0 FIX - THE NEW ACCESS KEYS FOR THE MENU ITEMS INDENT AND UNINDENT [NEW.....] VFP 9.0 FIX - THE NEW ACCESS KEYS FOR THE MENU ITEMS COMMENT AND UNCOMMENT Visual FoxPro Advanced supports the following keyboard shortcuts in Editor: --------------------------------------------------------------------------------------------------------------- | CTRL++ | Enlarge font. | --------------------------------------------------------------------------------------------------------------- | CTRL+- | Reduce font. | --------------------------------------------------------------------------------------------------------------- | CTRL+] | Indent. | --------------------------------------------------------------------------------------------------------------- | CTRL+[ | Unindent. | --------------------------------------------------------------------------------------------------------------- | CTRL+* | Comment. | --------------------------------------------------------------------------------------------------------------- | CTRL+SHIFT+* | Uncomment. | --------------------------------------------------------------------------------------------------------------- I clicked on the link to read more <http://baiyujia.com/vfpdocuments/f_vfp9fix308.asp> and was pleasantly surprised to get acknowledged that this was a suggestion I had made quite a while back. If you're using VFP,9 you should be using VFPA. Eric --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

ProFox List Statistics for February 2024
by List Administrator Account 01 Mar '24

01 Mar '24

================================================== ProFox List Statistics February 2024 ================================================== Subscriber Count at End of Month: ProFox: 305 ProFoxTech: 184 ================================================== Total Posts: 4 (Down 66.67% from January 2024) Total [OT] Posts: 0 (Unchanged from January 2024) Total [NF] Posts: 0 (Unchanged from January 2024) Daily Message Counts for February 2024 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 1 T 6 - 1 T 13 - 1 T 27 - 1 Message Counts By Day of Week for February 2024 ------------------------------------------------ DOW Count --- ----- Tue - 3 Thu - 1 Distinct Posters to the List (changes relative to January 2024) ------------------------------------------------ Non-OT messages: 4 (Down 60.0%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 4 (Down 60.0%) Top 4 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Bill Anderson 2. 1 Rick Schummer 3. 1 List Administrator Account 4. 1 Tracy Pearson Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 4 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Bill Anderson 2. 1 Rick Schummer 3. 1 List Administrator Account 4. 1 Tracy Pearson Top 4 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Bill Anderson 2. 1 Rick Schummer 3. 1 List Administrator Account 4. 1 Tracy Pearson Top 4 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 1 Southwest Fox 2024: Call for Speakers 2. 1 Hidden windows in the Window menu 3. 1 ChilkatVFP 1.32 released 4. 1 ProFox List Statistics for January 2024 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 4 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 1 Southwest Fox 2024: Call for Speakers 2. 1 Hidden windows in the Window menu 3. 1 ChilkatVFP 1.32 released 4. 1 ProFox List Statistics for January 2024

1 0

Southwest Fox 2024: Call for Speakers
by Rick Schummer 27 Feb '24

27 Feb '24

We've issued the Call for Speakers for Southwest Fox. If you are interested in presenting, please read the document referenced on that page to learn about submitting sessions. The conference will take place September 26-29, 2024. https://swfox.net/CallForSpeakers.aspx Rick White Light Computing, Inc.

1 0

ChilkatVFP 1.32 released
by Bill Anderson 13 Feb '24

13 Feb '24

Folks, Chilkat released version 97 on 1/31, so I needed to follow suit... The list of updates: 1) Added Version 97 compatibility, which includes the new CodeSign class. 2) The LogicalToBit method was fixed. 3) Added bug fixes and documentation fixes where I noticed them. See the History.md document for some details. 4) Added lots of documentation within the instance classes methods/properties. 5) Added the ChilkatChangeLog method to all instance classes to serve as historical documentation. Cross referenced all the Chilkat release notes to their affected individual classes. https://github.com/billand88/ChilkatVFP Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox