ProFox July 2017

profox@leafe.com

49 participants
53 discussions

Google API for Geocoding ... Again
by Dave Crozier 04 Feb '19

04 Feb '19

Fellow Gentlemen, I posted a request about doing geocoding requests to receive back a Lat/Long dataset for various addresses a few weeks ago and now find that Google do in fact provide a Geocoding service: https://developers.google.com/maps/documentation/geocoding/start The responses back from the requests are all JSON from a Java Script API run by Google. I have looked over Rick's Westwind site to try and get a start on using this method to get back a JSON response but seem to be getting nowhere fast. Anyone got any ideas on a simple & neat way of retrieving this data back using VFP programmatically? Either that or anyone know a free Geocoding site that would handle up to 100 name and address calls per day ideally by sending a text file and receiving one back which could be automated from the VFP end. Never even looked at Web services in anger before so it all seems a little baffling and terribly long winded at the moment unless I am missing something obvious. Note I don't want to have to drop into an intermediate program/language to accomplish this, if possible. Dave

9 23

[NF] Maybe THIS is the year for Linux....lol
by mbsoftwaresolutions＠mbsoftwaresolutions.com 09 Aug '18

09 Aug '18

http://tech.firstpost.com/news-analysis/the-great-linux-game-25-years-and-m… How many times have they said "Maybe this year!?!?!"

4 6

[NF] Ransomware
by John Weller 02 Oct '17

02 Oct '17

There was an interesting talk on the BBC yesterday on the recent internet ransom attacks. I didn't hear the talk myself but a friend told me about it. One of the interviewees was from Europol's European Cybercrime Centre and he recommended their website https://www.nomoreransom.org/about-the-project.html which has decryption tools for a number of recent viruses. Could be useful. John John Weller 01380 723235 07976 393631

11 14

Re: GETFILE() Returns Empty String in Some Cases
by Ken Dibble 08 Aug '17

08 Aug '17

>Permissions issue on the folder or on the selected file? I don't see how. In both cases it's me doing the test, on the same computer, with the same folder and file, with the same domain administrator account. Ken Dibble www.stic-cil.org

11 14

Outlook 2016 security no longer allowing VFP app to send emails as it did in the past
by mbsoftwaresolutions＠mbsoftwaresolutions.com 05 Aug '17

05 Aug '17

My client has Outlook 2016. At some point in the past, the Outlook version they had prior worked with the application that uses SMTP to send emails from it. I thought I recalled Microsoft tightening security over the years but that there was some (3rd party?) utility to get around the increased security blockage. Does anyone remember that and can comment on it? Thanks.

7 32

SET DECIMALS Gotcha
by Gene Wirchenko 02 Aug '17

02 Aug '17

Hello: I have just been bitten by SET DECIMALS. (Is there really any use for this besides making programming just a bit more difficult?) I have a table with values to four decimal places. I use <vfp> transform(thevalue,"999999.9999") </vfp> to create the string representation. With SET DECIMALS set to its default value, a value of 0.0123 is converted to " 0.0100" which loses two digits of precision. I had this problem with another data item that had more than two decimal places. I wrote a special function to handle it by setting SET DECIMALS to the number of decimal places I needed, doing the transform(), and setting SET DECIMALS back to the default. Why did I do that? Because the number of decimal places can vary and I was generating a line of print in one line of code, BUT also, because I really do not understand the point of SET DECIMALS. Could someone please clue me in? Sincerely, Gene Wirchenko

4 5

[NF] are you considering Python?
by Stephen Russell 01 Aug '17

01 Aug '17

Here is a top SQL Server blogger writing that he is learning Python. http://sqlservercode.blogspot.com/2017/07/why-i-am-learning-python-and-why-… -- 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 ---

8 11

Re: GETFILE() Returns Empty String in Some Cases
by Brant E. Layton 31 Jul '17

31 Jul '17

Hi All, I think that mypath (or whatever variable you are expecting to contain the returned path) needs to be initialized prior to the GETFILE call... In the code below, make it look like: private mypath mypath = '' mypath = GETFILE(...) Perhaps your standalone application initializes mypath, and the application doesn't?|| || |Brant Layton| |480.964.1316| On 7/31/2017 12:24 PM, profoxtech-request(a)leafe.com wrote: > ------------------------------ > Message: 10 > Date: Mon, 31 Jul 2017 15:23:06 -0400 > From: Philip Borkholder <plborker(a)netzero.net> > To: profoxtech(a)leafe.com > Subject: Re: GETFILE() Returns Empty String in Some Cases > Message-ID: <588017c0-9341-521a-b853-270a04a58e6e(a)netzero.net> > Content-Type: text/plain; charset="us-ascii"; Format="flowed" > > Are you declaring your variable as PRIVATE right before you run the > GETFILE() command? > > PRIVATE mypath > > mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") > > Just curious if that is affecting it. > > -Philip > > > On 7/31/2017 2:19 PM, Ken Dibble wrote: >>> Permissions issue on the folder or on the selected file? >> I don't see how. In both cases it's me doing the test, on the same >> computer, with the same folder and file, with the same domain >> administrator account. >> >> Ken Dibble >> www.stic-cil.org >> [excessive quoting removed by server]

1 0

RE: GETFILE() Returns Empty String in Some Cases
by Ken Dibble 31 Jul '17

31 Jul '17

>What kind of value does "parms" contain? The actual code is: mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") In both stand-alone and application mode, this displays the file dialog correctly and pointing to the location that I expect. However, I have also tried it as: mypath = GETFILE("csv","File","Open",0,"Open Spreadsheet") because someone suggested that the dialog can't display more than 10 characters to the left of the file name textbox. That didn't help. I have also tried it simply as: mypath = GETFILE() Then I manually navigate to the file location. But that doesn't make it work either. I'm sorry, I got sidetracked and failed to properly end the original message. I meant to conclude with: Thanks in advance. Ken Dibble www.stic-cil.org

2 1

GETFILE() Returns Empty String in Some Cases
by Ken Dibble 31 Jul '17

31 Jul '17

Hi folks, VFP 9 SP1 on Windows 7 Ultimate. I have a process to let the user choose a file. The user opens a .scx form, presses a button to run some code that calls GETFILE(), and when the user has done so, the path and file name are displayed on the form. When I run this form in stand-alone mode, this works fine. GETFILE() returns the path and file name to a string variable and I then display the variable contents on the form. When I run this form from within the full application, GETFILE() displays the proper location and behaves perfectly fine, but when the user chooses a file, it always returns an empty string. I've tracked this in the debugger. In both cases, I emphasize, from the point the user presses the button, the exact same code runs, at each point generating the exact same results, until we get past myvariable = GETFILE(parms) line, at which point myvariable is empty in application mode, but contains the full path and file name in stand-alone mode. I am following the correct procedure to obtain an appropriate full path, and in both cases the GETFILE() dialog displays the correct location and is configured properly according to my parameters. It simply won't return a value when run from inside the application. I've read everything with "GETFILE" in the subject line in the leafe.com archives. I can't find anything that addresses this situation. My application does not use the _SCREEN (SCREEN = OFF in the config.fpw file). Instead I have my own main window which is modeless and "2 - as top level". Normally the import window, which is modeless and (1 - in top level), is called from a modal form that is opened from a menu item. To eliminate the possibility that this modal/modeless business is interfering, I put the button that opens the import form directly on my main window, so that the only open windows are the modeless top-level form and the modeless in-top-level import form before the GETFILE() dialog is called. That's as close as I can get to running the import form in stand-alone mode. This did not help. The stand-alone mode of my framework's forms actually creates the same environment that exists in the full application before opening the form, so I can't see how not actually running the full application can make a difference. I emphasize, again, in the debugger, from the point the user presses that button every single step runs exactly the same way, and returns the same results, up to the GETFILE() dialog, in both stand-alone and full-application modes. My code stores the location that I want GETFILE() to display to a variable, mypath, so I do: oldpath = FULLPATH(CURDIR()) CD (JUSTPATH(mypath)) myvariable = GETFILE(parms) CD (JUSTPATH(oldpath)) Some people suggest using SET DEFAULT TO ..., so I also tried it like this: oldpath = FULLPATH(CURDIR()) CD (JUSTPATH(mypath)) SET DEFAULT TO (mypath) myvariable = GETFILE(parms) CD (JUSTPATH(oldpath)) SET DEFAULT TO (oldpath) That doesn't help either. The default is for the file name and path to contain spaces, and this works just fine in stand-alone mode. But I renamed the test file to remove spaces, and put the file in C:\foo, so there are no spaces anywhere in the path or file name, and it still doesn't work full application mode. GETFILE() just returns an empty string. I've also tried using PUTFILE() instead of GETFILE(), even though it's less elegant for my purpose. PUTFILE() also works as I expect in stand-alone mode but returns an empty string in full-application mode. LOCFILE() is not an option because I can't mandate a file name for this. This is driving me absolutely bonkers. Possibly I could roll my own file dialog, but short of that, can anyone provide any suggestions to explain why this is happening? Any suggestions

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2017