ProFox

profox@leafe.com

2704 discussions

Issues with Excel (Office365) & appendxlsx.prg
by Paul H. Tarver 03 Jun '17

03 Jun '17

I have been using the "appendxlsx.prg" procedure to import data from Excel (XLS and XLSX) files for a few years now but yesterday I ran into a weird problem and now I'm wondering if there is a bug in either Office 365 or Appendxlsx.prg. A client who has been using one of my programs for a couple years without any problems contacted me yesterday with an issue related to data not being imported correctly. The Excel spreadsheet containing the data is pretty straightforward with less than 100 rows and probably 20-25 columns. The client creates and maintains the spreadsheet and then imports the spreadsheet data in my program which converts it into a file to be imported elsewhere. All rows have similar data, but in the case of one row, the data was imported correctly with the exception of one cell. The cell contained a Case ID which looks like this: "091-293828-012" and that one cell was imported into my program via the "appendxlsx.prg" procedure as '0'. Nothing I did to the cell would change the behavior. If I added characters to the beginning or end of the Case Id, it would still import as '0'. If I changed the cell contents to '1234567890', it would import as '0'. The row above this record and the row after this record as well as all other records in the file imported correctly. But not this one cell. Ultimately, saving the Excel file to a CSV format and importing it as a CSV solved the problem. However, in talking with the client, the only change that has been made is they switched recently to Office 365. Their problems importing data from the Excel spreadsheet began shortly after that. Has anyone seen behavior like this? Is it a problem I need to debug in the "appendxlsx.prg" program, or is this a bug in Office 365? Thanks in advance! Paul H. Tarver Tarver Program Consultants, Inc. Email: <mailto:paul@tpcqpc.com> paul(a)tpcqpc.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

[NF] Web GUI Toolkit recommendation
by Charlie-gm 02 Jun '17

02 Jun '17

All, I am getting involved with a project where I'll be doing some web page implementation. Python will probably be our main code choice and we'll hosting on Linux servers. We are pretty sure we're going to use Django as the primary framework, but we need a GUI component "package" or whatever (we really don't want to go build that stuff from scratch). Primary requirements (most important first): 1) open source (essentially it needs to be "free" for internal use in our organization) 2) have a robust "grid" component (think of VFP's grid control) 3) easily integrate with Django 4) be extensible/customizable I have spent several hours of web searching and found various references: like DXHTML (has a free option, but limited), Bootstrap, jQuery, etc. The little gotchas I keep hitting are stuff like jQuery is great, but to get a "grid" you gotta use a "plugin" ... and then those plugins cost money... blah blah blah So, I'd like to hear what other people have used, hated, loved, etc. Sorry for requesting your mental burn cycles on this, but I have RTFI (Read the F'n Internet) and I really need input from folks I trust. Please do not waste my time with recommendations of Microsoft frameworks/code/tools. TIA, -Charlie

3 7

Southwest Fox 2017: Registration is open!
by Rick Schummer 01 Jun '17

01 Jun '17

Registration for Southwest Fox 2017 (http://www.swfox.net/register.aspx) is now available. See http://www.swfox.net/speakers.aspx for a list of speakers and http://www.swfox.net/sessionsswfox.aspx for a list of sessions. Super-Saver Registration, which saves you $125, is available only through June 30th, so don't wait. Putting on a conference is a risky endeavor. Conference centers require a guaranteed minimum income to block the dates of a conference; for a conference like Southwest Fox, that minimum is in the tens of thousands of dollars. We have to commit to the conference center by July 2nd and need your support by July 1st to make that commitment. We will not send out any "We need your help" appeals so please do not wait; register by June 30th! We know most of you like to wait until the last minute to avoid the credit card bill arriving too soon. We will not charge any attendee credit cards or cash any checks until we have committed to going forward (sometime after July 2), so this is not is a reason to wait. Doug, Tamar, and I look forward to seeing you in October! Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Re: [NF] PyQT for desktop applications
by Gene Wirchenko 01 Jun '17

01 Jun '17

At 07:55 2017-05-30, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: >On Tue, 30 May 2017, at 12:05 PM, Stephen Russell wrote: > > On Tue, May 30, 2017 at 3:07 AM, Alan Bourke <alanpbourke(a)fastmail.fm> > > wrote: > > > > > > In 2017, how many users are looking for desktop apps? > > > > > > Still plenty. > > > > > > > > Seriously? > > > > > >Seriously. Anything that needs any sort of meaningful interaction with a >local file system or devices, or a rich UI for example. 1) Snappiness, too. 2) The UI limitations of browsers are a bother. Oh, yes, there are some solutions, but unfortunately, there is no standard. And many of the richer features require security compromises. 3) When something fails, is it due to a bug? A wrong browser version? Security blocking? It is much simpler when only one thing can fail. Sincerely, Gene Wirchenko

3 2

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

01 Jun '17

================================================== ProFox List Statistics May 2017 ================================================== Subscriber Count at End of Month: ProFox: 288 ProFoxTech: 187 ================================================== Total Posts: 351 (Up 44.44% from April 2017) Total [OT] Posts: 5 (Up 100.0% from April 2017) Total [NF] Posts: 144 (Up 350.0% from April 2017) Daily Message Counts for May 2017 ------------------------------------------------ DOW Date Count --- ---- ----- M 1 - 17 T 2 - 18 W 3 - 9 T 4 - 13 F 5 - 17 S 6 - 9 S 7 - 1 M 8 - 21 T 9 - 10 W 10 - 27 T 11 - 9 F 12 - 17 S 13 - 8 M 15 - 3 T 16 - 16 W 17 - 12 T 18 - 16 F 19 - 3 S 21 - 2 M 22 - 8 T 23 - 10 W 24 - 23 T 25 - 17 F 26 - 11 S 27 - 9 S 28 - 5 M 29 - 3 T 30 - 25 W 31 - 12 Message Counts By Day of Week for May 2017 ------------------------------------------------ DOW Count --- ----- Sun - 8 Mon - 52 Tue - 79 Wed - 83 Thu - 55 Fri - 48 Sat - 26 Distinct Posters to the List (changes relative to April 2017) ------------------------------------------------ Non-OT messages: 55 (Up 22.22%) OT messages: 3 (Up 100.0%) NF messages: 38 (Up 216.67%) Total number: 56 (Up 24.44%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 63 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 24 Ted Roche 3. 19 Alan Bourke 4. 19 Richard Kaye 5. 18 Fred Taylor 6. 17 Gene Wirchenko 7. 15 Stephen Russell 8. 13 Dave Crozier 9. 12 Paul H. Tarver 10. 10 Charles Hart Enzer, M.D. 11. 9 Thierry Nivelet 12. 8 Kurt at VR-FX 13. 7 Ed Leafe 14. 7 Kurt Wendt 15. 6 Michael Madigan 16. 6 Man-wai Chang 17. 6 Tracy Pearson 18. 5 Edward Leafe 19. 5 Darren 20. 5 Paul Newton Top 3 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 3 15% Gene Wirchenko 2. 1 14% Michael Madigan 3. 1 100% Jerry Wolper Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 27 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 11 Stephen Russell 3. 11 Alan Bourke 4. 10 Gene Wirchenko 5. 10 Ted Roche 6. 6 Charles Hart Enzer, M.D. 7. 6 Dave Crozier 8. 6 Thierry Nivelet 9. 5 Kurt Wendt 10. 4 Kevin J Cully 11. 4 Ed Leafe 12. 4 Paul H. Tarver 13. 3 Ken Dibble 14. 3 Jean Laeremans 15. 3 Edward Leafe 16. 2 AndyHC 17. 2 Richard Kaye 18. 2 Malcolm Greene 19. 2 John Weller 20. 2 Ken Kixmoeller (ProFox) Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 63 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 24 Ted Roche 3. 20 Gene Wirchenko 4. 19 Richard Kaye 5. 19 Alan Bourke 6. 18 Fred Taylor 7. 15 Stephen Russell 8. 13 Dave Crozier 9. 12 Paul H. Tarver 10. 10 Charles Hart Enzer, M.D. 11. 9 Thierry Nivelet 12. 8 Kurt at VR-FX 13. 7 Michael Madigan 14. 7 Ed Leafe 15. 7 Kurt Wendt 16. 6 Man-wai Chang 17. 6 Tracy Pearson 18. 5 Edward Leafe 19. 5 Darren 20. 5 Paul Newton Top 20 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 3 Charles Hart Enzer, M.D. 3. 3 Gene Wirchenko 4. 2 Stephen Russell 5. 2 Paul Hill 6. 2 Paul H. Tarver 7. 2 Paul Newton 8. 1 Alan Bourke 9. 1 List Administrator Account 10. 1 Jean Haidar 11. 1 Desmond Lloyd 12. 1 Ted Roche 13. 1 Fred Taylor 14. 1 Dave Crozier 15. 1 Garrett Fitzgerald 16. 1 Gérard LOCHON 17. 1 <rafael.copquin(a)gmail.com> 18. 1 Edward Leafe 19. 1 Rick Schummer 20. 1 Charlie-gm Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 31 [NF] PyQT for desktop applications 2. 23 Running Multiple Instances of VFP 9 3. 16 Recommendations for temporary file storage 4. 16 Question about determining when record not showing after filter applied 5. 15 [NF] Friday Afternoon Discussion: Passwords 6. 13 [ADMIN] Spring Cycling for Charity 7. 13 Weird Instantiation Bug 8. 12 [NF] Sending Large Files... 9. 12 [NF] URGENT Request - MailMerge w/PDF 10. 12 VFP9SP2 app on Windows 10 -- reports not showing 11. 11 Getting count of rows in a text file -- best approach? 12. 11 GetFile() problem (VFP9, Win 10) 13. 11 [NF] As one door closes, ... 14. 9 generate pdf files by batch and send them by email 15. 9 [NF] C#: Single inheritance 16. 7 {NF] Error with VmwPlayer 17. 7 How to tell between Win8 and Win10 using Fox commands? 18. 6 [NF] Web GUI Toolkit recommendation 19. 6 Google Sheets access from VFP 20. 6 [ADMIN][SPAM] I love that! Top 2 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 4 [OT] Excessive Bounces E-mails 2. 1 [OT] Humour (was: VFP9SP2 app on Windows 10 -- reports not showing) Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 31 [NF] PyQT for desktop applications 2. 23 Running Multiple Instances of VFP 9 3. 16 Recommendations for temporary file storage 4. 16 Question about determining when record not showing after filter applied 5. 15 [NF] Friday Afternoon Discussion: Passwords 6. 13 [ADMIN] Spring Cycling for Charity 7. 13 Weird Instantiation Bug 8. 12 [NF] Sending Large Files... 9. 12 [NF] URGENT Request - MailMerge w/PDF 10. 12 VFP9SP2 app on Windows 10 -- reports not showing 11. 11 Getting count of rows in a text file -- best approach? 12. 11 GetFile() problem (VFP9, Win 10) 13. 11 [NF] As one door closes, ... 14. 9 generate pdf files by batch and send them by email 15. 9 [NF] C#: Single inheritance 16. 7 {NF] Error with VmwPlayer 17. 7 How to tell between Win8 and Win10 using Fox commands? 18. 6 [NF] Web GUI Toolkit recommendation 19. 6 Google Sheets access from VFP 20. 6 [ADMIN][SPAM] I love that!

1 0

Re: [NF] PyQT for desktop applications
by Gene Wirchenko 31 May '17

31 May '17

At 13:19 2017-05-31, Thierry Nivelet <tnivelet(a)foxincloud.com> wrote: >Today's Browsers follow standard https://caniuse.com/ Unfortunately, many *Websites* do not. I very much dislike coming across a Website which has weird dependencies and where I have to jump through hoops to get it to work. It happens all too often. And, the chance is rather high that there is no one to contact about it. The latest example was when UT switched to levelextreme.com. It gives me this: Important message Your browser has way too much security in place. Presently, it is running with a high level of security which disables the javascript support. This site makes use of advanced functionalities and requires the browser to maintain its average security settings. Basically, you will not be able to log in and do much on this site for as long as this is not rectified. We encourage you to proceed at our <https://www.levelextreme.com/Troubleshooting.aspx>Troubleshooting page to look at possible causes which could be in effect. Once your browser security adjusted normally, this message will go away confirming you that everything should be ok for you to work on this site. Their support E-mail did not exist when I tried it. [snip] Sincerely, Gene Wirchenko

1 0

Re: [NF] PyQT for desktop applications
by Gene Wirchenko 31 May '17

31 May '17

At 12:27 2017-05-30, Stephen Russell <srussell705(a)gmail.com> wrote: [snip] >Each environment has it's own line issues, but no users who are well versed >in "the internet vs the network" would ever ask for limited functionality, >instead, they would demand the web as it provides access to everything. Do those well-versed users you mention know about security issues? Considering all of the on-line break-ins, it is worth thinking about *who* is being provided access to everything. Sincerely, Gene Wirchenko

2 1

[OT] Humour (was: RE: VFP9SP2 app on Windows 10 -- reports not showing)
by Gene Wirchenko 31 May '17

31 May '17

At 04:41 2017-05-30, Richard Kaye <rkaye(a)invaluable.com> wrote: >Found it. > >http://doughennig.blogspot.com/2012/02/updating-vfpx-reportbuilderapp.html How does working with computers affect you? One way is that you may use some of the same algorithms. For example, in parsing words strung together, you might use a greedy algorithm, that is, take the longest word possible. I did above. Even knowing what it says, I still tend to read the first word as "dough". [snip] Sincerely, Gene Wirchenko

1 0

Re: [ADMIN][SPAM] I love that!
by Gene Wirchenko 31 May '17

31 May '17

At 13:07 2017-05-27, Ed Leafe <ed(a)leafe.com> wrote: >On May 27, 2017, at 5:20 AM, Ted Roche <tedroche(a)gmail.com> wrote: > > > I'm pretty sure Al's not emailing from a static IP in Vietnam. Looks > > like some spam got through: > >Yeah, unfortunately it happens. If someone is a member of the list, >it's much easier to sneak something through. I'm not too sad, >though, since the existing filters blocked over 160 spam messages. > >In the past 2 days. Thank you, Ed, for being on the ball with that. I also follow thedailywtf.com which has been getting spambotted for months. Quite unpleasant. Sincerely, Gene Wirchenko

1 0

RE: [NF] URGENT Request - MailMerge w/PDF
by Gene Wirchenko 31 May '17

31 May '17

At 11:11 2017-05-25, Kurt Wendt <Kurt_Wendt(a)globetax.com> wrote: >You're postings do tend to make me chuckle! > >By the way - I checked out that tool on CodePlex - and it ROCKS!!!! >It does Exactly what I needed to do - so - problems ALL Solved! > >So - in that regards - seems I WILL have this done Quick, Accurate >(cause I do good work) - and Cheap (since that tool was Free)! Ha - >you thought Quick, Cheap & Accurate could not be done - and, so - >I've proven that concept wrong. Good Day sir! It is also possible to win at Russian Roulette, but it is not an effective long-term strategy. [snip] Sincerely, Gene Wirchekno

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox