ProFox April 2023

profox@leafe.com

18 participants
11 discussions

[NF] Queries re: Python & Such...
by Kurt ＠ Gmail 22 Jun '23

22 Jun '23

Hey there folks, So, I know there is a Leafe mailing list for Python, as I just looked on the Leafe mailing lists website. But, sadly - unlike this one - it pretty much looks dead. Sad - since I was just beginning to get back into some Python programming again. I did notice that even this forum has gotten to be VERY Quiet. Sad indeed! Truthfully, I have not seriously done any FoxPro since like 2020, and even that was a Small personal project. Last serious work was in like Nov 2017. And, I know that FoxPro usage in general is dying off across the world... Anyway - back to the topic at hand: Python. In my case, I'm actually using the PySimpleGUI to build UI's. Its a project I'm coming back to, as it was mothballed about a year ago - due to a big round of layoffs at the 3D Printing co. where I was working. So - yeah, FYI - I'm back at that co. - they hired me back last year in Oct.! I'm pretty thrilled to be back - especially as it truly is my Dream Job! Anyway - short synopsis of tool I am working on. If someone is printing a REALLY Large print job - which can literally take like 5 days or more to run, problem is - if you get an error on the machine that can not be recovered from. It can be a pretty Epic fail - not only because all the lost hours, but, also costs of filament. For instance - a special filament like Ultem - can run a customer like $750 for 2.5Kg of the stuff. So, if a customer runs a big print job - and they are on the 2nd spool - and printer dies 1/2 way thru that spool - you have essentially thrown like $1100 Down the Toilet! The tool I am creating will essentially take a massive GCode file, and based upon criteria - find out where it left off printing. Then, remove all the lines of code that have already been printed - but, making sure some of the GCode lines at the top, like print temperatures - are still included. Then, it will have proper lines to restart that print job. Anyway - probably TMI in regards to this posting. But, if anyone could point me in the direction of a forum similar to this one - where I could get some help in Python programming - that would be Awesome! Thanks, Kurt

7 12

VFP Report Dynamics Tab Missing
by Frank Cazabon 21 Apr '23

21 Apr '23

Hi, I've got version 09.00.0000.7423 and SET("ReportBehavior") = 90 yet when I double click a report control on a report I don't see the Dynamics Tab or the Advanced Tab. Windows 11 Pro 22H2 What am I doing wrong? -- Frank. Frank Cazabon

4 10

ChilkatVFP 1.21 just released
by Bill Anderson 20 Apr '23

20 Apr '23

Folks, ChilkatVFP just got updated. Chilkat put out a Version 94 release about 3 weeks ago but just put out the Release Notes only recently... https://github.com/billand88/ChilkatVFP Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

NF Recommendations for a js create calendar event library
by Richard Kaye 20 Apr '23

20 Apr '23

An NF question for the collective wisdom. We've got a little JS bit we use in our WWC application that can create an Outlook calendar event. It would be nice if we could find a library that allows creating a calendar event for MS, Google & Apple. Any recs? TIA -- rk

2 2

.csv file imports to VFP
by Joe Yoder 17 Apr '23

17 Apr '23

I have an accounting system data dump that I export each year at tax time, I think I have always had a few records that got mangled but this year I would like to solve the problem. My preferred technique is to create a cursor with the fields I need to import along with any required place holders. I then append from the ,CSV file type delimited. This is very fast and seems to be perfect except for about 24 records out of 10,000. What happens is that fields that belong in later positions in some records show up in the first field position. It seems some records are handled as though they have a carriage return linefeed too early and what follows ends up at the beginning of the following record. I have investigated Low level file input using an fgets function to pull records out one at a time. This is obviously slower and still seems to have the same problem. Another possible approach would be to pull the entire file into memory and parse everything out from there. This will take much more time and be a lot of work to set up but might make sense to try. Finally I have opened the file in Excel with no problem. Some of the fields that want to show up in the left field in VFP stay where they belong in Excel. I don't like to add a process in another package but it may make sense to do so. Any wisdom will be much appreciated. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 6

Re: .csv file imports to VFP
by Philip Borkholder 16 Apr '23

16 Apr '23

Hi Joe, Some things you can check for in your character fields before you append are: CHR(10) CHR(13) CHR(2) CHR(3) CHR(4) Replace those with a blank if they exist. Also see if some of the character fields (like addresses) have a comma in them that might be separating it into a column before you want it to. -Philip B. ---------- Original Message ---------- From: Joe Yoder <joe(a)wheypower.com> To: profoxtech(a)leafe.com Subject: .csv file imports to VFP Date: Sat, 15 Apr 2023 22:35:14 -0400 I have an accounting system data dump that I export each year at tax time, I think I have always had a few records that got mangled but this year I would like to solve the problem. My preferred technique is to create a cursor with the fields I need to import along with any required place holders. I then append from the ,CSV file type delimited. This is very fast and seems to be perfect except for about 24 records out of 10,000. What happens is that fields that belong in later positions in some records show up in the first field position. It seems some records are handled as though they have a carriage return linefeed too early and what follows ends up at the beginning of the following record. I have investigated Low level file input using an fgets function to pull records out one at a time. This is obviously slower and still seems to have the same problem. Another possible approach would be to pull the entire file into memory and parse everything out from there. This will take much more time and be a lot of work to set up but might make sense to try. Finally I have opened the file in Excel with no problem. Some of the fields that want to show up in the left field in VFP stay where they belong in Excel. I don't like to add a process in another package but it may make sense to do so. Any wisdom will be much appreciated. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server]

1 0

Re: ProfoxTech Digest, Vol 239, Issue 2
by Mike Stewart 07 Apr '23

07 Apr '23

The name is familiar, and I can almost picture the guy. But, yeah, he worked at Microsoft. I believe he worked on a product other than FP when I worked in North Carolina, but he was definitely there. -- Mike Stewart On Tue, Apr 4, 2023 at 7:52 PM <profoxtech-request(a)leafe.com> wrote: > His name is John Ramminger. Does anyone have any memories of this guy?

1 0

Fun with .Net DLLs
by Richard Kaye 05 Apr '23

05 Apr '23

ProFoxers, I've started down the road of attempting to create a DLL in C# using VS2019. Here's the problem I'm trying to solve. I want to retrieve the current orientation value from a JPG. If it exists, I want to rotate the image to that value. Finally I want to set/delete the orientation tag. I found a lovely .Net code sample that describes the problem and appears to do exactly what I want. You can see the source here: <https://www.ryadel.com/en/change-image-orientation-iphone-andor-android-pho…> Now assuming this code works, the trick is how to get it into a DLL that I can call from VFP. I've created a Helper class project in VS; got it to build the DLL cleanly and that's where I start running into a brick wall. I used a white paper from Doug Hennig as a guideline on how to invoke from a PRG using wwDotNetBridge and InvokeStaticMethod. Sadly all I've been gotten from that call is a NULL. Then I tried to debug using VS and it tells me I can't debug a Helper DLL; I have to add an executable thing-a-ma-jig to the project. (As you can see my VS knowledge is a bit...lacking.) Tips, tricks and tutorial hints gratefully accepted. I'm happy to get more into actual code once I have enough of a foundation to actually discuss this intelligently. 😊 -- rk

5 10

HTTPS GET using Winsock
by Man-wai Chang 05 Apr '23

05 Apr '23

Are there free Visual Foxpro source codes that do HTTPS GET via Winsock? The following example does non-SSL HTTP GET: Win32API/sample_383.md at master · VFPX/Win32API · GitHub Winsock: retrieving Web pages using sockets (HTTP, port 80) Retrieved data is stored in a Memo field of a cursor https://github.com/VFPX/Win32API/blob/master/samples/sample_383.md -- .~. Might, Courage, Vision. SINCERITY! / v \ https://github.com/changmw/changmw /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

3 4

I was on a call this morning with a guy who claimed to be a FP/VFP support with M$
by Stephen Russell 04 Apr '23

04 Apr '23

His name is John Ramminger. Does anyone have any memories of this guy? Now he is a Sharepoint consultant. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2023