ProFox June 2017

profox@leafe.com

53 participants
64 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

Disappearing (and later reappearing) data on Windows Server 2016
by mbsoftwaresolutions＠mbsoftwaresolutions.com 14 Jul '17

14 Jul '17

VFP9SP2 app on Win10 clients; data on Windows Server 2016 Client showed me (via TV session) how adding records seems to show the new records in the local vfp view, then after saving, not showing them, then exiting and re-entering the app, the data is there. Now normally we'd say "well it must be a bug in the app" -- but this app has been rock solid and bug free with this basic add operation for 14+ years now. The only change in the environment is the new Server 2016. Anyone having any issues with their VFP DBC tables residing on Windows Server 2016? tia, --Mike

5 15

[NF] has anyone played with Linux on a thumb drive?
by Michael Madigan 04 Jul '17

04 Jul '17

https://mydailydiscovery.com/spo/fact-or-fiction-is-the-25-computer-real-th… I wonder, does this really work?

11 22

Southwest Fox 2017: Super-saver deadline is today...
by Rick Schummer 30 Jun '17

30 Jun '17

Hear that sound? Tick, tick, tick, tick... That's the countdown clock here at Geek Gatherings getting closer to the Super-saver deadline for Southwest Fox! June 30th is *TODAY* and we thought we would pass along a reminder just in case you forgot to type it into your task list, or put a yellow sticky note on your monitor. We still need people to register to make the conferences happen. The conference takes place October 26-29, 2017 in Gilbert, Arizona and we really hope you can be there. We would hate to see you lose out on the $125 discount, the FREE pre-conference session, and an opportunity to win a scholarship or a license of Stonefield Query SDK (a $6,000 value). Head over to the registration Web site today: https://geekgatherings.com/Registration If you've already registered, we thank you. Can you help us remind your fellow developers who have been procrastinating about the looming deadline by sharing this email or tweeting about it? Spread the word by telling others you going on our Facebook event: https://www.facebook.com/events/201298070323046/ Also, if you sent in your registration and have not received a confirmation, please contact us to see what happened. Everyone gets a confirmation when the registration is processed. As promised, we are not cashing checks or processing credit cards for new registrations until the middle of July. Check out our list of amazing speakers and dig into our session tracks. Follow the news about the conference on our blog. Speakers: http://swfox.net/speakers.aspx Sessions: http://swfox.net/sessionsswfox.aspx News: http://swfox.net/news.aspx Blog: http://swfox.net/blog/index.php Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

[FiC] Fox In Cloud
by mbsoftwaresolutions＠mbsoftwaresolutions.com 30 Jun '17

30 Jun '17

I'm working with Thierry's group to beat around the latest versions of Fox In Cloud. He prefers support in public forums such as this so in order to help "categorize" these posts, I was going to preface the subject with [FiC] unless good reason why I shouldn't. I could use the forum over at WestWind but that wouldn't help educate anyone here at ProFox. Thoughts? Objections? Free beer? tia, --Mike

2 1

[NF] debugger hacks for VS2017
by Stephen Russell 29 Jun '17

29 Jun '17

If you use VS these are some good ideas on how to debug better. Unless you don't need no stinkin debuggin https://blogs.msdn.microsoft.com/visualstudio/2017/06/26/7-lesser-known-hac… -- 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 ---

3 3

Bulk Imports While Multi-User System is in Use
by Ken Dibble 29 Jun '17

29 Jun '17

Hi folks, Having never attempted this before, I am seeking any guidance you can offer. I'm using VFP tables across a LAN, with VFP 9 SP 1. The tables are on a virtualized Windows 2012 file server that has gargantuan memory and HDD resources available. The workstations are Windows 7 Ultimate 32-bit with processors in the 3.5 GHz range and 4 GB of RAM. My framework does not use the RAD features of VFP; no data environments, no control sources, no buffering (I actually wrote my own "buffering"/conflict resolution system), no auto-incrementing columns. The only time I manually lock anything is when my integer surrogate key-creation program is generating a new key--and I only lock the table that stores the last-used key value. I do use a database container so that the default value methods of the PK fields of my tables can call the key generation program. When users create new records, I use APPEND, not INSERT. The system was deliberately designed to divorce database access from business rules and GUI (because initially, long ago, I thought I might actually embark on writing my own database server). I understand that there is brief automatic locking, however, whenever VFP writes to a table (or, rather, when the server OS, in its infinite wisdom, deigns to carry out VFP's request to write to the table). I've been given the task of importing data from a spreadsheet into my multi-user system. I have not done any testing on this but it is possible that the import process, run every week or every two weeks, will create thousands of records that will be "children" of a few hundred "parent" records. The system is in near constant use by somewhere around a half-dozen people, and much larger numbers use it occasionally. Some of the half-dozen intensive users are quite likely to be accessing the parent records at the time the bulk import process is creating the child records. I am concerned about creating massive access conflicts leading to race conditions, freezing of the system, and/or data corruption. Should I just block everybody from saving any data while the import process runs? (I don't know how long it will take, but I do envision a lot of error-checking and logging on each row of the spreadsheet to prevent bad data from getting into the system.) Or are there simple things I can do to prevent issues ("simple" means, no major changes to the framework or the database)? Or is this something I don't really need to worry about? Thanks very much for any suggestions. Ken Dibble www.stic-cil.org

6 5

[NF] Latest Ransomware "vaccine"
by Ted Roche 28 Jun '17

28 Jun '17

How to Enable the NotPetya/Petna/Petya Vaccine To vaccinate your computer so that you are unable to get infected with the current strain of NotPetya/Petya/Petna (yeah, this naming is annoying), simply create a file called perfc in the C:\Windows folder and make it read only. For those who want a quick and easy way to perform this task, Lawrence Abrams has created a batch file that performs this step for you. Source: https://www.bleepingcomputer.com/news/security/vaccine-not-killswitch-found… -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

4 3

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox June 2017