ProFox May 2017

profox@leafe.com

56 participants
78 discussions

[NF] Copy of VmWare on 2nd Machine Does Not Open
by Charles Hart Enzer, M.D. 02 May '17

02 May '17

Copying the Virtual Player folder to a new machine, I get this error trying to mount the virtual drive: A disk read error occured Press Ctrl-Alt-Del to restart I have not found an answer on the Vmware site nor with google. Note: I first copies the host Folder from the desktop to iDrive in the cloud. then on the laptop, i "restored" from the iDrive the VMWare Player folder to the laptop's Document's folder. *Shai / שי Charles Hart Enzer, M.D., FAACAPVolunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: http://homepages.uc.edu/~enzerch/ <http://homepages.uc.edu/%7Eenzerch/>* *“And after all this, what would I say to those who ask me the secret of a fulfilled life? Mine is really quite a simple philosophy. Try to live every day as if it is your last, but plan your future as though there were endless tomorrows.”David Rubinger (Hebrew: דוד רובינגר‎‎; 29 June 1924 – 2 March 2017)* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

VFP9 and Windows 10 PDF printer
by Mike McCann 01 May '17

01 May '17

Anyone have experience with printing regular FRX reports to the Window 10 PDF and directing to a file automatically (i.e. no user dialog)? Thanks, Long time lurker, Mike

6 6

Getting count of rows in a text file -- best approach?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 01 May '17

01 May '17

VF9SP2 Currently, I'm simply doing this for now: RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename)) Is there a better (read: FASTER) way? These are tab delimited text files so I can't really use FSEEK or FSIZE(m.Filename) (which requires SET COMPATIBLE ON) because I can't be sure of each record's length. tia, --Mike

11 35

Excel automation to get the SUM("R:R")
by mbsoftwaresolutions＠mbsoftwaresolutions.com 01 May '17

01 May '17

Excel 2013, VFP9SP2 Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire column, Excel tells me the SUM of all of the values in the column at the bottom. I need that number. I don't want to do some sort of loop; rather, I want to basically say from VFP: 'return the SUM("R:R").' I've looked at the object model above and there doesn't appear to be a .Sum to tag onto the end of the Range object (like you might think of with DotNet stuff). Also, I don't want to create a formula in some other remote cell and then read that, although that's my Plan B for now. Ideas? tia! --Mike

2 6

Reading & Extracting Data From PDF Files
by Paul H. Tarver 01 May '17

01 May '17

Original Thread: Getting count of rows in a text file -- best approach? A couple of times I've heard people mention reading in PDF files using FileToStr and I want to know more about reading and extracting data from PDF files. I do a lot of data conversion and interface work with lots of file formats, but I've not been very successful at importing and extracting data from PDF reports. Obviously a scanned image saved as a PDF would have to be ocr'd first, but is there is a reliable way to extract data from PDF reports and if so, how? I'm sure I don't know all the ends and outs of the PDF format, but when I try, I seem to get a strange mix of formatting details and data combined in a random way. Am I being thick here or is there really a way that I can get any PDF file from any client and then successfully extract the data elements from that format? I'm prepared to be thought of as stupid but be gentle! :) Paul H. Tarver Tarver Program Consultants, Inc. Email: paul(a)tpcqpc.com -----Original Message----- From: Brant E. Layton [mailto:dcci@futureone.com] Sent: Wednesday, April 26, 2017 3:17 PM To: profoxtech(a)leafe.com Subject: RE: Getting count of rows in a text file -- best approach? |My experience was moving PDF files in and out of SQLServer tables - |found an abrupt truncation at the 16,777,184 mark... Brant Layton| |480.964.1316| On 4/26/2017 12:57 PM, profoxtech-request(a)leafe.com wrote: > RE: Getting count of rows in a text file -- best approach? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server]

7 10

[NF] Steve Ballmer Serves Up a Fascinating Data Trove (USAFacts.org)
by mbsoftwaresolutions＠mbsoftwaresolutions.com 01 May '17

01 May '17

https://mobile.nytimes.com/2017/04/17/business/dealbook/steve-ballmer-serve… Nice to see he's giving back like this. Seriously. Kudos, Monkeyboy. Well done.

1 0

is there a proper way in FPW 2.6 to add a line to the end of a memo?
by Michael Madigan 01 May '17

01 May '17

is there a recommended way in FPW 2.6 to add a line to the end of a memo field? I have been using : replace memo_field with memo_field + new_line and every once in a while the FPT file blows up to a large size (2 or 3 times normal size). I'm guessing it blows up because someone uses a utility to add a line to a large number of records at once. Is there a command that prevents the bloat? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

ProFox List Statistics for April 2017
by List Administrator Account 01 May '17

01 May '17

================================================== ProFox List Statistics April 2017 ================================================== Subscriber Count at End of Month: ProFox: 289 ProFoxTech: 187 ================================================== Total Posts: 243 (Up 58.82% from March 2017) Total [OT] Posts: 0 (Down 100.0% from March 2017) Total [NF] Posts: 32 (Up 128.57% from March 2017) Daily Message Counts for April 2017 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 M 3 - 7 T 4 - 3 W 5 - 2 T 6 - 3 F 7 - 3 S 8 - 4 S 9 - 4 M 10 - 12 T 11 - 12 W 12 - 29 T 13 - 9 F 14 - 5 M 17 - 10 T 18 - 4 W 19 - 7 T 20 - 21 F 21 - 30 M 24 - 1 T 25 - 5 W 26 - 21 T 27 - 18 F 28 - 24 S 29 - 7 S 30 - 1 Message Counts By Day of Week for April 2017 ------------------------------------------------ DOW Count --- ----- Sun - 5 Mon - 30 Tue - 24 Wed - 59 Thu - 51 Fri - 62 Sat - 12 Distinct Posters to the List (changes relative to March 2017) ------------------------------------------------ Non-OT messages: 45 (Up 25.0%) OT messages: 0 (Down 100.0%) NF messages: 12 (Up 71.43%) Total number: 45 (Up 25.0%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 37 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 36 Ted Roche 3. 23 Richard Kaye 4. 12 Gene Wirchenko 5. 10 Gianni Turri 6. 9 Alan Bourke 7. 9 Fernando D. Bozzo 8. 8 Stephen Russell 9. 8 Darren 10. 7 Malcolm Greene 11. 6 Man-wai Chang 12. 6 Rick Schummer 13. 5 Peter Cushing 14. 5 Mike 15. 4 Ken Dibble 16. 4 Laurie Alvey 17. 4 Mike McCann 18. 4 Paul H. Tarver 19. 3 Tom Dawson 20. 3 Jean MAURICE Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 12 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Ted Roche 2. 5 Stephen Russell 3. 4 mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 3 Malcolm Greene 5. 2 Man-wai Chang 6. 2 Michael Madigan 7. 1 Alan Bourke 8. 1 Kevin Cully 9. 1 Ken McGinnis 10. 1 Vince Teachout 11. 1 Fred Taylor 12. 1 Kevin J Cully Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 37 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 36 Ted Roche 3. 23 Richard Kaye 4. 12 Gene Wirchenko 5. 10 Gianni Turri 6. 9 Alan Bourke 7. 9 Fernando D. Bozzo 8. 8 Stephen Russell 9. 8 Darren 10. 7 Malcolm Greene 11. 6 Man-wai Chang 12. 6 Rick Schummer 13. 5 Peter Cushing 14. 5 Mike 15. 4 Ken Dibble 16. 4 Laurie Alvey 17. 4 Mike McCann 18. 4 Paul H. Tarver 19. 3 Tom Dawson 20. 3 Jean MAURICE Top 19 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 3 Gene Wirchenko 3. 3 Ted Roche 4. 3 Stephen Russell 5. 2 Michael Madigan 6. 2 Mike McCann 7. 1 List Administrator Account 8. 1 Al 9. 1 Tom Dawson 10. 1 Malcolm Greene 11. 1 Matt Wiedeman 12. 1 Dr. Jörg Arand 13. 1 José Olavo Cerávolo 14. 1 Rick Schummer 15. 1 Paul H. Tarver 16. 1 Richard Kaye 17. 1 Charles Hart Enzer, M.D. 18. 1 Man-wai Chang 19. 1 Ken Dibble Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 38 Getting count of rows in a text file -- best approach? 2. 20 Codeplex is shutting down, VFPX.org is spinning up 3. 18 VFP EXE and RDS random crashes 4. 16 Fuzzy Name Searching 5. 13 Referring to a Column 6. 10 Text file import 7. 10 SQL sum 8. 10 Reading from SQLite 9. 9 Reading & Extracting Data From PDF Files 10. 9 VFP9 and Windows 10 PDF printer 11. 7 Checking in on FOXCHARTS 12. 7 Easy way to get UNC from drive mapping? 13. 7 [NF] Recommendation on a 3rd party VPN service? 14. 6 [NF] What's in your event log? 15. 6 [NF] Chromebook OOBE 16. 5 Retrospective properties - the magic of inheritance 17. 5 Excel automation to get the SUM("R:R") 18. 5 Win10 Creator's Update? 19. 3 STREXTRACT (was Text file import) 20. 3 [NF] Fix for dead chromebooks Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 38 Getting count of rows in a text file -- best approach? 2. 20 Codeplex is shutting down, VFPX.org is spinning up 3. 18 VFP EXE and RDS random crashes 4. 16 Fuzzy Name Searching 5. 13 Referring to a Column 6. 10 Text file import 7. 10 SQL sum 8. 10 Reading from SQLite 9. 9 Reading & Extracting Data From PDF Files 10. 9 VFP9 and Windows 10 PDF printer 11. 7 Checking in on FOXCHARTS 12. 7 Easy way to get UNC from drive mapping? 13. 7 [NF] Recommendation on a 3rd party VPN service? 14. 6 [NF] What's in your event log? 15. 6 [NF] Chromebook OOBE 16. 5 Retrospective properties - the magic of inheritance 17. 5 Excel automation to get the SUM("R:R") 18. 5 Win10 Creator's Update? 19. 3 STREXTRACT (was Text file import) 20. 3 [NF] Fix for dead chromebooks

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2017