ProFox February 2019

profox@leafe.com

39 participants
27 discussions

Parsing a JSON object
by Paul Newton 12 Feb '19

12 Feb '19

Hi all I am investigating the use of Chilkat's tools for parsing JSON objects but I am having trouble developing a generic routine. For example, take the following: Local loJsonObject As 'Chilkat_9_5_0.JsonObject' Local lcStrJsonObject, lnNumPets lcStrJsonObject = '{"pets":[{"name":"jack","breed":"terrier"},{"name":"john","breed":"bulldog"},{"name":"joe","breed":"terrier"}]}' loJsonObject = CreateObject('Chilkat_9_5_0.JsonObject') loJsonObject.Load(lcStrJsonObject) i = 0 lnNumPets = loJsonObject.SizeOfArray("pets") DO WHILE i < lnNumPets loJsonObject.I = i ? STR(i) + ": " + loJsonObject.StringOf("pets[i].name") + "," + loJsonObject.StringOf("pets[i].breed") i = i + 1 ENDDO What I am trying to do is make the code generic such that I do not need to refer to "pets", "name" and "breed". Any help would be much appreciated. I have found a generic method for parsing JSON arrays but so far have been unable to do so for JSON objects Paul Newton

2 2

Pipe Delimited
by Chris Davis 08 Feb '19

08 Feb '19

Is it possible to export a cursor/table to Pipe Delimited with Headers without rolling my own? Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Name your lnaguages.
by Stephen Russell 07 Feb '19

07 Feb '19

https://twitter.com/shanselman/status/1092319147118247936 -- 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 2

FoxBin2Prg and DBF files
by Tracy Pearson 07 Feb '19

07 Feb '19

Does anyone that uses the FoxBin2Prg app convert DB2 files back to DBFs? >From the documentation it looks like it should convert back and forth. I'm getting the following error: 2019-02-07T16:32:52 ---------------------------------------------------------------------------- ------------------------ Error 1098, File [C:\Work\pconebody\PCOnebody_MetaData.db2] is not supported convert, 4087 FoxBin2Prg: [C:\WORK\TOOLS\FOXBIN2PRG\FOXBIN2PRG.EXE] (EXE Version: v1.19.51) tc_InputFile = [C:\WORK\PCONEBODY\PCONEBODY_METADATA.DB2] Source file: C:\Work\pconebody\PCOnebody_MetaData.db2

2 2

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

Converting .scx to .prg
by Gene Wirchenko 02 Feb '19

02 Feb '19

Hello: How do I convert a .scx to a .prg? I have found most of the pieces of code, but I do not see how the contained objects are created. (I was expecting to find a form .Init().) Sincerely, Gene Wirchenko

7 6

ProFox List Statistics for January 2019
by List Administrator Account 01 Feb '19

01 Feb '19

================================================== ProFox List Statistics January 2019 ================================================== Subscriber Count at End of Month: ProFox: 293 ProFoxTech: 182 ================================================== Total Posts: 166 (Up 163.49% from December 2018) Total [OT] Posts: 2 (Up 100.0% from December 2018) Total [NF] Posts: 15 (Down 44.44% from December 2018) Daily Message Counts for January 2019 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 2 T 3 - 11 F 4 - 7 S 5 - 1 S 6 - 5 M 7 - 10 T 8 - 12 W 9 - 30 T 10 - 28 F 11 - 7 S 12 - 2 S 13 - 3 M 14 - 8 T 15 - 5 W 16 - 2 M 21 - 6 T 22 - 2 W 23 - 2 T 24 - 6 S 26 - 3 M 28 - 7 T 29 - 7 Message Counts By Day of Week for January 2019 ------------------------------------------------ DOW Count --- ----- Sun - 8 Mon - 31 Tue - 28 Wed - 34 Thu - 45 Fri - 14 Sat - 6 Distinct Posters to the List (changes relative to December 2018) ------------------------------------------------ Non-OT messages: 34 (Up 9.68%) OT messages: 2 (Up 100.0%) NF messages: 8 (Down 55.56%) Total number: 34 (Up 9.68%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 17 Gene Wirchenko 2. 13 Ed Leafe 3. 12 Kurt @ Gmail 4. 11 Fletcher Johnson 5. 9 Richard Kaye 6. 9 Alan Bourke 7. 8 Tracy Pearson 8. 8 Frank Cazabon 9. 7 Koen Piller 10. 7 Ted Roche 11. 7 Fernando D. Bozzo 12. 7 mbsoftwaresolutions(a)mbsoftwaresolutions.com 13. 6 Dave Crozier 14. 4 Charles Hart Enzer, M.D. 15. 4 Peter Cushing 16. 3 John Weller 17. 3 Jean Laeremans 18. 3 Paul Newton 19. 3 Man-wai Chang 20. 2 Malcolm Greene Top 2 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 1 50% Adam Buckland 2. 1 14% Dave Crozier Top 8 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Fletcher Johnson 2. 2 Charles Hart Enzer, M.D. 3. 2 Kurt @ Gmail 4. 2 Alan Bourke 5. 2 Ed Leafe 6. 1 <juergen(a)wondzinski.de> 7. 1 Koen Piller 8. 1 Kurt at VR-FX Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 17 Gene Wirchenko 2. 13 Ed Leafe 3. 12 Kurt @ Gmail 4. 11 Fletcher Johnson 5. 9 Richard Kaye 6. 9 Alan Bourke 7. 8 Tracy Pearson 8. 8 Frank Cazabon 9. 7 Koen Piller 10. 7 Ted Roche 11. 7 Dave Crozier 12. 7 Fernando D. Bozzo 13. 7 mbsoftwaresolutions(a)mbsoftwaresolutions.com 14. 4 Charles Hart Enzer, M.D. 15. 4 Peter Cushing 16. 3 John Weller 17. 3 Jean Laeremans 18. 3 Paul Newton 19. 3 Man-wai Chang 20. 2 Malcolm Greene Top 12 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Fletcher Johnson 2. 2 List Administrator Account 3. 2 Tracy Pearson 4. 2 Gene Wirchenko 5. 2 <juergen(a)wondzinski.de> 6. 2 Adam Buckland 7. 1 Charles Hart Enzer, M.D. 8. 1 Johan Nel 9. 1 Kurt @ Gmail 10. 1 Ed Leafe 11. 1 Paul Newton 12. 1 Alan Bourke Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 AW: Custom Scrollbar 2. 32 [ADMIN] Testing new mail relay 3. 18 VSS to git conversion 4. 11 [NF] Looking for a little Python/Django help 5. 10 Hey, can you test this... 6. 9 ProFox List Statistics for 2018 7. 8 Custom Scrollbar 8. 6 Converting .scx to .prg 9. 5 Moving/dragging form leaves a trail of images of the form behind it 10. 5 VFP Work in San Diego??? 11. 4 The future of Xbase 12. 4 ERD with a table with strange keys 13. 4 This is a test please ignore. 14. 2 [NF] Microsoft Account 15. 2 VFPx Project Explorer and git 16. 2 Google API for Geocoding ... Again 17. 1 [ADMIN] This is a test please ignore. 18. 1 ERD with a table with strange keys 19. 1 AW: [NF] Microsoft Account 20. 1 ProFox List Statistics for December 2018 Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 2 [OT] : Hello (Again) Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 AW: Custom Scrollbar 2. 32 [ADMIN] Testing new mail relay 3. 18 VSS to git conversion 4. 11 [NF] Looking for a little Python/Django help 5. 10 Hey, can you test this... 6. 9 ProFox List Statistics for 2018 7. 8 Custom Scrollbar 8. 6 Converting .scx to .prg 9. 5 Moving/dragging form leaves a trail of images of the form behind it 10. 5 VFP Work in San Diego??? 11. 4 The future of Xbase 12. 4 ERD with a table with strange keys 13. 4 This is a test please ignore. 14. 2 [OT] : Hello (Again) 15. 2 [NF] Microsoft Account 16. 2 VFPx Project Explorer and git 17. 2 Google API for Geocoding ... Again 18. 1 [ADMIN] This is a test please ignore. 19. 1 ERD with a table with strange keys 20. 1 AW: [NF] Microsoft Account

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox February 2019