RE: VFPA

[Chris Davis]

Thank you.

-Original Message-
From: ProfoxTech  On Behalf Of 
juer...@wondzinski.de
Sent: Tuesday, April 30, 2024 12:20 PM
To: profoxt...@leafe.com
Subject: AW: VFPA

Hi Chris,

the password for the download of the free version at 
http://www.baiyujia.com/f_downloadproc_vfpa32.asp

is a simple "ok" 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Chris Davis
Gesendet: Dienstag, 30. April 2024 12:16
An: ProFox Email List 
Betreff: VFPA

Noticed the download of this is now password protected, has it's availability 
changed?


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo2p123mb70994e269a0bbe3be94e37e58f...@lo2p123mb7099.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

VFPA

[Chris Davis]

Noticed the download of this is now password protected, has it's availability 
changed?


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo2p123mb7099cb4767fa2fd27b35bfc28f...@lo2p123mb7099.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: PDF Scraping

[Chris Davis]

Looks interesting, I will check it out ... thanks Gianni

-Original Message-
From: ProfoxTech  On Behalf Of Gianni Turri
Sent: Saturday, January 13, 2024 12:07 PM
To: profoxt...@leafe.com
Subject: Re: PDF Scraping

Another option is the Balabolka Text Extract Utility, I have used it with 
success in the past.

https://www.cross-plus-a.com/btext.htm

This is the command line version, so you can run it from VFP.

Example usage:

blb2txt -f "My file.pdf" -out "My file.txt"

The program has many options, for example you can process many files at once.

Gianni

On Fri, 12 Jan 2024 12:46:50 +, Chris Davis  wrote:

Forgot Ghostscript could do that, thank you Alan ... works a treat ?

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Friday, January 12, 2024 11:27 AM
To: profoxt...@leafe.com
Subject: Re: PDF Scraping

Chris

This is not easy in general and probably not possible without going outside of 
VFP. You're probably looking at leveraging Ghostcript somehow to parse the PDF 
files and dump the text out.

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb58903eca8add3ba554b3df618f...@cwlp123mb5890.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: PDF Scraping

[Chris Davis]

Forgot Ghostscript could do that, thank you Alan ... works a treat 

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Friday, January 12, 2024 11:27 AM
To: profoxt...@leafe.com
Subject: Re: PDF Scraping

Chris

This is not easy in general and probably not possible without going outside of 
VFP. You're probably looking at leveraging Ghostcript somehow to parse the PDF 
files and dump the text out.

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives This message: 
https://leafe.com/archives/byMID/c073fe82-ac75-47ad-8a8b-e0e69350a...@app.fastmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb5890f99b93ac2a87d4f9ae4b8f...@cwlp123mb5890.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

PDF Scraping

[Chris Davis]

Any suggestions on how best to find data (I can't find it simply by using 
notepad) in a PDF?  I need to process a folder full of PDF's.

TIA

Chris


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb589079f146584426c7863f1d8f...@cwlp123mb5890.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Printer Dialogue

[Chris Davis]

Hi Alan

No sorry, I mean the dialogue that appears when you do report form to printer 
prompt.



-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Thursday, December 21, 2023 2:14 PM
To: profoxt...@leafe.com
Subject: Re: Printer Dialogue 

Not following Chris - do you mean GetPrinter() ?

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb58904d82c84e7cb3b1f3cd9f8f...@cwlp123mb5890.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Printer Dialogue

[Chris Davis]

I'm not certain when but in Windows 11 the printer dialogue for 32 bits apps 
changed ...

If you leave the new dialogue active (you can change registry settings to force 
the old one) then anything you do with set printer before printing a report 
with printer prompt brings up the dialogue but it just displays the default 
printer, is forcing the old dialogue the only solution for vfp apps or is there 
a way to get vfp to work nicely with it?

TIA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb58902807bbf26a60fd98cf818f...@cwlp123mb5890.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[Chris Davis]

After a lot of testing it turns out this was a bug at the other end, I have 
obtained a patch for it and now VFP sends the data fine.

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: Tuesday, November 14, 2023 9:41 AM
To: profoxt...@leafe.com
Subject: RE: ZPL

Thanks Woody

The image is already converted to hex and the { symbol doesn't appear in it ... 
if I don't get any further today I will create an actual example to demonstrate 
it better.  Although I am just considering going the Chilkat route and sending 
the data via the socket and making a networked label printer a minimum 
requirement for our customers.

Appreciate your input so far.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of 
juer...@wondzinski.de
Sent: Tuesday, November 14, 2023 8:27 AM
To: profoxt...@leafe.com
Subject: RE: ZPL

Hi Chris,

I suspect that you have a "misbehaving char" in your hex data, something like 
Ctrl-Z, which terminates the standard DOS copy process. 

If you need to transfer binary data to your printer, you could use this routine 
here:

??? ChrTran(File2Str("yourPicture.jpg"), "{", "{{}")

wOOdy



-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 3:13 PM
To: profox@leafe.com
Subject: RE: ZPL

Done a bit more testing and capture the print job it looks like it only sends 
upto 16535 kB to the printer before it's then captured as a job? Make any sense?



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb49884274b7daf07f3d52b6398f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[Chris Davis]

Thanks Woody

The image is already converted to hex and the { symbol doesn't appear in it ... 
if I don't get any further today I will create an actual example to demonstrate 
it better.  Although I am just considering going the Chilkat route and sending 
the data via the socket and making a networked label printer a minimum 
requirement for our customers.

Appreciate your input so far.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of 
juer...@wondzinski.de
Sent: Tuesday, November 14, 2023 8:27 AM
To: profoxt...@leafe.com
Subject: RE: ZPL

Hi Chris,

I suspect that you have a "misbehaving char" in your hex data, something like 
Ctrl-Z, which terminates the standard DOS copy process. 

If you need to transfer binary data to your printer, you could use this routine 
here:

??? ChrTran(File2Str("yourPicture.jpg"), "{", "{{}")

wOOdy



-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 3:13 PM
To: profox@leafe.com
Subject: RE: ZPL

Done a bit more testing and capture the print job it looks like it only sends 
upto 16535 kB to the printer before it's then captured as a job? Make any sense?



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988240536e71c463c59b10d8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[Chris Davis]

To be fair I am getting the same result when sending the ZPL from notepad to 
the printer, it just doesn't work, I think because it's a large ZPL the print 
driver is sorting it out onto pages ... I've tried the continuous feed no break 
but it makes no difference

-Original Message-
From: ProfoxTech  On Behalf Of Ted Roche
Sent: Monday, November 13, 2023 3:25 PM
To: profoxt...@leafe.com
Subject: Re: ZPL

TYPE is NOT the same as copying a file to a printer or network destination. It 
ASSuMEs it is sending text, and has problems with word wrap, long files without 
returns, etc. It is a dBASE II command and ought to be avoided. See 
https://hackfox.github.io/section4/s4g173.html for details.



On Mon, Nov 13, 2023 at 7:44 AM Chris Davis  wrote:
>
> Thanks Woody
>
> That seems to behave the same as me using ...
>
> STRTOFILE(label1.mlabel,"c:\batch\testlabel.txt")
> TYPE c:\batch\testlabel.txt TO PRINTER
>
> If I do this with the example label from labelary it works fine, if I use it 
> with my own label where I have an embedded image it doesn't.  The embedded 
> image command is long as it contains the data in hex format.
>>

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives This message: 
https://leafe.com/archives/byMID/cacw6n4vishu4zdykvnzjry2cvl0-tgb_hrcn9kmt_krvyuj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988dcfcda127e962e7a04ea8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[Chris Davis]

Done a bit more testing and capture the print job it looks like it only sends 
upto 16535 kB to the printer before it's then captured as a job? Make any sense?

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 12:44 PM
To: profoxt...@leafe.com
Subject: RE: ZPL

Thanks Woody

That seems to behave the same as me using ...

STRTOFILE(label1.mlabel,"c:\batch\testlabel.txt")
TYPE c:\batch\testlabel.txt TO PRINTER

If I do this with the example label from labelary it works fine, if I use it 
with my own label where I have an embedded image it doesn't.  The embedded 
image command is long as it contains the data in hex format.

If I paste my own label into labelary it works, if I send me label to the 
printer via TCPIP socket using Chilkat it works.  It just doesn't work when 
sending it via set printer to

Make sense?

-Original Message-
From: ProfoxTech  On Behalf Of 
juer...@wondzinski.de
Sent: Monday, November 13, 2023 11:59 AM
To: profoxt...@leafe.com
Subject: RE: ZPL

Hi Chris,

You connect to the printer with a regular cPrinterName = GETPRINTER() SET 
PRINTER TO NAME (cPrinterName)

Then you open the printer
SET PRINTER ON

And all commandlines starting with ??? get sent directly, without conversion of 
the Windows drivers.
thus:

#DEFINE CR CHR(13)+CHR(10)

??? "^XA" + CR
??? "^CF0,60" + CR
??? "^FO50,50^GB100,100,100^FS" + CR

SET PRINTER OFF
SET PRINTER TO


One caveat: The ??? command also translates embedded strings between curly 
braces:

??? "This is a printer control string: {27}Q{100} to set the right margin"

If you need to print that left curly bracket in real, then you need to do a 
"{{}"

wOOdy





-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 12:27 PM
To: ProFox Email List 
Subject: ZPL

Hi All

Would anyone have any suggestions of how best to approach sending ZPL commands 
to a compatible printer?

If the printer is on the network I can get this to work using ChilKat such as 
https://www.example-code.com/foxpro/socket_connect.asp

But I have also found that you can get ZPL to a printer that is connected via 
USB or network using the Generic / Text Only Driver ... this works with a 
simple example from

https://labelary.com/viewer.html

but if the commands become more extensive (maybe because an image has been 
included) then this method goes wrong I think because the driver is doing 
something relating to page size? But not sure.

If possible I would like a native VFP method of connecting to either a USB or 
Network connected ZPL printer and be able to send whatever I like ... thoughts?

TIA


Chris Davis




--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb498826b44a10125657ba8c828f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[Chris Davis]

Thanks Woody

That seems to behave the same as me using ...

STRTOFILE(label1.mlabel,"c:\batch\testlabel.txt")
TYPE c:\batch\testlabel.txt TO PRINTER

If I do this with the example label from labelary it works fine, if I use it 
with my own label where I have an embedded image it doesn't.  The embedded 
image command is long as it contains the data in hex format.

If I paste my own label into labelary it works, if I send me label to the 
printer via TCPIP socket using Chilkat it works.  It just doesn't work when 
sending it via set printer to

Make sense?

-Original Message-
From: ProfoxTech  On Behalf Of 
juer...@wondzinski.de
Sent: Monday, November 13, 2023 11:59 AM
To: profoxt...@leafe.com
Subject: RE: ZPL

Hi Chris,

You connect to the printer with a regular cPrinterName = GETPRINTER() SET 
PRINTER TO NAME (cPrinterName)

Then you open the printer
SET PRINTER ON

And all commandlines starting with ??? get sent directly, without conversion of 
the Windows drivers.
thus:

#DEFINE CR CHR(13)+CHR(10)

??? "^XA" + CR
??? "^CF0,60" + CR
??? "^FO50,50^GB100,100,100^FS" + CR

SET PRINTER OFF
SET PRINTER TO


One caveat: The ??? command also translates embedded strings between curly 
braces:

??? "This is a printer control string: {27}Q{100} to set the right margin"

If you need to print that left curly bracket in real, then you need to do a 
"{{}"

wOOdy





-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 12:27 PM
To: ProFox Email List 
Subject: ZPL

Hi All

Would anyone have any suggestions of how best to approach sending ZPL commands 
to a compatible printer?

If the printer is on the network I can get this to work using ChilKat such as 
https://www.example-code.com/foxpro/socket_connect.asp

But I have also found that you can get ZPL to a printer that is connected via 
USB or network using the Generic / Text Only Driver ... this works with a 
simple example from

https://labelary.com/viewer.html

but if the commands become more extensive (maybe because an image has been 
included) then this method goes wrong I think because the driver is doing 
something relating to page size? But not sure.

If possible I would like a native VFP method of connecting to either a USB or 
Network connected ZPL printer and be able to send whatever I like ... thoughts?

TIA


Chris Davis




--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988293ae9b23511e2d35e4f8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

ZPL

[Chris Davis]

Hi All

Would anyone have any suggestions of how best to approach sending ZPL commands 
to a compatible printer?

If the printer is on the network I can get this to work using ChilKat such as 
https://www.example-code.com/foxpro/socket_connect.asp

But I have also found that you can get ZPL to a printer that is connected via 
USB or network using the Generic / Text Only Driver ... this works with a 
simple example from

https://labelary.com/viewer.html

but if the commands become more extensive (maybe because an image has been 
included) then this method goes wrong I think because the driver is doing 
something relating to page size? But not sure.

If possible I would like a native VFP method of connecting to either a USB or 
Network connected ZPL printer and be able to send whatever I like ... thoughts?

TIA


Chris Davis




--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb498818914d63dc275dc75bb88f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Small Report/Label Designs

[Chris Davis]

Many thanks Alan, the printer is ZPL compatible but TSPL by default ... I am 
going to explore this and see if it's the solution.

Many thanks.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: 15 January 2023 21:05
To: profoxt...@leafe.com
Subject: Re: Small Report/Label Designs

Well, with a Zebra I would forget the VFP report designer and just send it ZPL 
commands. And use this to to the design.

http://labelary.com/viewer.html

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Sun, 15 Jan 2023, at 10:56 AM, Chris Davis wrote:
> Something similar to a Zebra.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Alan 
> Bourke
> Sent: 13 January 2023 12:28
> To: profoxt...@leafe.com
> Subject: Re: Small Report/Label Designs
>
> What label printer are you printing them on ?
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988e589d21c54e7d7a32d6a8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Small Report/Label Designs

[Chris Davis]

Thanks Ted, I will try some of the tips you've summarised see if they save 
what's left of my hair.

My main issues are layout and images not printing clearly  so the grid and 
resolutions things you have mentioned should help me layout properly.  I fear 
the quality of the printed images is either the windows print driver or the 
images themselves so knowing the printer is ZPL compatible (it's native is 
TSPL) I am going to explore Alan's suggestion and see if I can skip the report 
design/driver all together. 

Your reply is much appreciated.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Ted Roche
Sent: 15 January 2023 14:50
To: profoxt...@leafe.com
Subject: Re: Small Report/Label Designs

On Thu, Jan 12, 2023 at 8:19 AM Chris Davis  wrote:
>
> Anyone got any tips for working easier on small label designs?
>
Sure. What is it you're having trouble with? Data, layout, resolution, spacing 
between labels? There's LOTs that's maddening about labels!

Decades of books and magazine articles were written on report and label tricks. 
(Bow towards the west and the all-knowing Ms. LSN! And south and the skilled 
Ms. Pountney.)

- Use the layout tools and label/report properties, set the grid to pixels, 
snap to grid on/off depending on whether it's helping or not.
- Load and save a printer environment if you and your users are on the same 
network with the same printers (rare these days)
- Lower the screen resolution to zoom a small work area (1024x768 or even 
800x600).
- Move elements with the cursor arrow keys (and Ctrl+ modifier keys)
- Group elements together to move without losing spacing between them (Click 
and Ctrl-click to group)
- Create a layout element like a line you want all elements to line up with and 
then drag items to it, snap-to-grid, then delete line.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988ddf04897833a43d8dfe68f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Small Report/Label Designs

[Chris Davis]

So you mean print to a larger PDF and then print the PDF to the printer with 
shrink to fit?

-Original Message-
From: ProfoxTech  On Behalf Of Man-wai Chang
Sent: 13 January 2023 12:09
To: profoxt...@leafe.com
Subject: Re: Small Report/Label Designs

Foxpro's report writer has dimensions. It will be easier if printer-friendly 
labels are available.

In the worst case, use PDF format? :)

On Thu, Jan 12, 2023 at 9:19 PM Chris Davis  wrote:
>
> Anyone got any tips for working easier on small label designs?
>

--
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Fedora 35 Server Spin
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988f792a4615051a148e60f8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Small Report/Label Designs

[Chris Davis]

Something similar to a Zebra.

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: 13 January 2023 12:28
To: profoxt...@leafe.com
Subject: Re: Small Report/Label Designs

What label printer are you printing them on ?


--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb498839b17abe6cb13b980f7c8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Small Report/Label Designs

[Chris Davis]

Anyone got any tips for working easier on small label designs?

TIA

Chris.

Chris Davis
Acton Gate Systems Limited

Please note our new address from 1st May 2022:
1 Nightingale Place
Pendeford Business Park
Wolverhampton
WV9 5HF
M: 07966 020 473
T: 01902 249299
*: chr...@actongate.co.uk
Web<mailto:chr...@actongate.co.uk%0bWeb>: 
www.actongate.co.uk<http://www.actongate.co.uk/>

This email is confidential and may be privileged; it is for use of the named 
recipient(s) only. If you have received it in error, please notify us 
immediately; please do not copy or disclose its contents to any person or body, 
and delete it from your computer systems. Any views or opinions expressed 
within this email are personal and may not necessarily reflect those of Acton 
Gate Systems Limited, unless explicitly stated otherwise. Whilst all reasonable 
care has been taken to avoid the transmission of viruses, it is the 
responsibility of the recipient to ensure that the onward transmission, opening 
or use of this message and any attachments will not adversely affect its 
systems or data. No responsibility is accepted by Acton Gate Systems Limited in 
this regard and the recipient should carry out such virus and other checks as 
it considers appropriate.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwxp123mb49831c5829681d8b2e0ebf458f...@cwxp123mb4983.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Need Help - Foxpro & Chilkat & Rest API

[Chris Davis]

Hi Paul

Sorry only just got around to your email in my inbox! Do you have a link to the 
API documentation? or if not, as well as the token end point in your code 
(/rest/api/token/) do you also have an authorisation end point?

Regards

Chris.



-Original Message-
From: ProfoxTech  On Behalf Of Paul H. Tarver
Sent: 12 July 2022 20:13
To: profoxt...@leafe.com
Subject: RE: Need Help - Foxpro & Chilkat & Rest API

I started reading Rick's material yesterday and it definitely helped me get to 
the point of getting an OAuth2.0 token back. I just need to get back and finish 
reading his work and the API documentation (which is definitely not written for 
VFP!) and maybe it will help me understand how to convert the Postman 
information into VFP code which calls Chilkat tools to accomplish building the 
data requests. I got the token request and a data request functioning in 
Postman first which did help but none of the code examples are from a VFP point 
of view, so I'm having to translate their code into something I can use in VFP 
with Chilkat. I'm pretty sure I can handle the extraction of the data from the 
responses. In fact, I ran into a situation yesterday where the Chilkat LoadJson 
function wasn't working right and it turned out the token response didn't match 
the layout Chilkat expects. So, I just used VFP Alines() to break apart the 
Json elements which worked quite nicely.

Getting my head wrapped around the formation of the API requests is without a 
doubt the hardest part of this. However, trying to learn Chilkat + API at the 
same time is making the process more complicated I think. That's why I was 
hoping to get some other sample code to review since Chilkat's examples are 
mostly for specific published API's and do not use a more generalized approach. 
At least I figured out yesterday how to use Chilkat to get more useful feedback 
from the API server than just the 400 error so that has been helpful. 

Paul H. Tarver
Tarver Program Consultants, Inc.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Tuesday, July 12, 2022 10:54 AM
To: profoxt...@leafe.com
Subject: RE: Need Help - Foxpro & Chilkat & Rest API

That was the 30,000 for view, of course. 

Gotta get your head wrapped around the requirements of the API you’re calling. 
What I’m referring to is the architecture of the internal APIs written by my 
engineering team here. There are a couple of different flavors and the token 
handling isn’t consistent between the two. I really did find that going through 
Rick’s tutorials were very helpful since it’s got the VFP perspective.

--

rk

From: ProfoxTech  On Behalf Of Paul H. Tarver
Sent: Tuesday, July 12, 2022 11:19 AM
To: profoxt...@leafe.com
Subject: RE: Need Help - Foxpro & Chilkat & Rest API

I wish it was as easy to program as it was to read your explanation! :)

But I guess if it were really easy, then everyone would be learning to code.
:)

Paul H. Tarver
Tarver Program Consultants, Inc.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Tuesday, July 12, 2022 9:20 AM
To: profoxt...@leafe.com
Subject: RE: Need Help - Foxpro & Chilkat & Rest API

Generally speaking, the token is the key that unlocks access to the APIs you 
want to call. So you need to persist that in your business object, and pass it 
to any API calls you make. Depending on the API you're hitting, the token value 
could be in the request header or it could be a key:value pair in the payload.

--

rk

From: ProfoxTech 
mailto:profoxtech-boun...@leafe.com>> On Behalf 
Of Paul H. Tarver
Sent: Tuesday, July 12, 2022 9:38 AM
To: profoxt...@leafe.com
Subject: RE: Need Help - Foxpro & Chilkat & Rest API

Definitely!

I did have a small breakthrough yesterday as I was able to get an OAuth2 Token 
returned from within VFP. Woohoo!

Now if I can just figure out what to do with it. :)

Paul H. Tarver
Tarver Program Consultants, Inc.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Monday, July 11, 2022 4:54 PM
To: 
profoxt...@leafe.com>
Subject: Re: Need Help - Foxpro & Chilkat & Rest API

On Jul 11, 2022, at 16:51, Paul H. Tarver 
mailto:p...@tpcqpc.com>>
 wrote:
>
> I'll keep looking for your project and when you release it, I'll 
> definite consider upgrading to your tool as soon as I can.

Sounds like a potential beta tester! ;-)

-- Ed Leafe







[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable 

RE: Need Help - Foxpro & Chilkat & Rest API

[Chris Davis]

Hi Paul

I use Chilkat a lot to grab data from API's, a lot using OAuth and the expiring 
token.  Are you able to share the code that's getting you to the 400 response 
so I can see where your upto?

Regards

Chris

-Original Message-
From: ProfoxTech  On Behalf Of Paul H. Tarver
Sent: 09 July 2022 18:45
To: profoxt...@leafe.com
Subject: Need Help - Foxpro & Chilkat & Rest API

I have a spec project where I need to build an application using a REST API to 
extract data elements and then post those data elements to a different system. 
The API requires me to get a token upfront (which has a five-minute life span), 
issue my requests with the token and then get the results back in a JSON or XML 
format. Based on recommendations I received at the Virtual FoxFest earlier this 
year, I purchased the Chilkat tools and dove into what has turned out to be the 
deep end without knowing how to swim. The documentation at Chilkat while 
extensive is almost too extensive for me to understand exactly what I've got to 
do to make this work. 

 

So far, I've been unable to even get a token back. All I seem to be able to get 
back from the server is 

 

400 Bad request

Your browser sent an invalid request.

 

That response has been less than helpful. I've reached out to the API Provider 
but their answers are focused on requests issued after I get the token. 

 

My question is this: Does anyone have any sample Foxpro code they use for a 
similar process (Request a token, then make requests with the token) using the 
Chilkat tools they would be willing to share? A Foxpro wrapper would be too 
much to hope for, but that would be even better if it is exists. I've got to 
get to a point where I'm beyond this initial stage to prove I can make this 
work. 

 

Help! I know this is possible, but so far, I'm not making much headway. 

 

Paul H. Tarver
Tarver Program Consultants, Inc. 



 



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988ed7f380b8acc3f56c1528f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP Advanced COM

[Chris Davis]

Actually got this working now, a typo!  But interesting when I try and create 
an instance of the 64 bit com exe within the command window of VFPA itself it 
crashes, everywhere else it works fine.

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: 26 April 2022 14:49
To: profoxt...@leafe.com
Subject: VFP Advanced COM

Just having a play around with this, I have created a simple COM exe and 
compiled it in the 64bit version of VFPA.  It suggests its creating a 64bit exe 
but I can only create an instance of it from a 32bit application (VFP 32bit / 
Node 32bit) ... if I try from VFPA 64Bit or Node 64Bit then it can't find the 
class.

Am I trying to do something its not intended to do?

TIA

Chris.


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb498875c1de7647313d18a52c8f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

VFP Advanced COM

[Chris Davis]

Just having a play around with this, I have created a simple COM exe and 
compiled it in the 64bit version of VFPA.  It suggests its creating a 64bit exe 
but I can only create an instance of it from a 32bit application (VFP 32bit / 
Node 32bit) ... if I try from VFPA 64Bit or Node 64Bit then it can't find the 
class.

Am I trying to do something its not intended to do?

TIA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988a4806d94fea7387f9dc98f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Anyone on here involved with Virtual Fox Fest?

[Chris Davis]

Thank you Ajit

-Original Message-
From: ProfoxTech  On Behalf Of Ajit Abraham
Sent: 22 December 2021 04:50
To: profoxt...@leafe.com
Subject: Re: Anyone on here involved with Virtual Fox Fest?

I tried the link yesterday - got a 404 error Its fine today.

Ajit

On 21/12/2021 16:53, Chris Davis wrote:
> Any idea if this link will be made available again?
>
> https://virtualfoxfest.com/2020/
>
> Thanks
>
> Chris.
>
>


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb498895a979c2be5c58138f118f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Anyone on here involved with Virtual Fox Fest?

[Chris Davis]

Any idea if this link will be made available again?

https://virtualfoxfest.com/2020/

Thanks

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo0p123mb4988ca2cbe24b598b89f39d38f...@lo0p123mb4988.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Slow performance after moving to VM

[Chris Davis]

Thanks Christof, assuming at the moment this was the issue did you manage to 
speed it up?  Was there a configuration on the client which determined how many 
packets could be exchanged?

-Original Message-
From: ProfoxTech  On Behalf Of Christof 
Wollenhaupt
Sent: 26 October 2021 11:23
To: profoxt...@leafe.com
Subject: Re: Slow performance after moving to VM

Hi Chris,

> Most of the 20 clients are still running fine, but a handful (3 identified) 
> at the moment are running really slow, they are only running slow in the VFP 
> application any other use of the server like copying files runs fine.  They 
> also seem to be the better spec'd machines out of the 20.  Nothing has 
> changed on the client pc's other than the unc path where the application is 
> looking for the data.

I had issues with systems were the number of TCP/IP packets that could be 
exchanged between client and server depended on the version of Windows on the 
server. So the same client would exchange 250 packets per second with a Windows 
2012 R2 but 1250 with Windows 2008 R2. Because VFP requests records one at a 
time and only reads the next one when the first has been processed, we ended up 
reading a maximum of one record every 4ms or every 0.8 ms. Both were slow, but 
the new Windows server considerably slower.

My first step would be to run Process Monitor on the client once for the faster 
machines and then once for the slower system. Then look at the timing between 
ReadFile requests in some table. Preferably one where multiple records are read 
in a row, such as a SCAN loop, SELECT statement or a grid control. Look if 
there's a significant difference in the duration between two records and if 
this number is somewhat constant.

If this doesn't help, then WireShark is a great tool, but does require some 
digging into SMB protocols.

--
Christof
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo2spr01mb00699898ce6e367fb24ccf008f...@lo2spr01mb0069.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Slow performance after moving to VM

[Chris Davis]

Hi All

Has anyone got any suggestions as to where the problem maybe in the following 
scenario.

We have a VFP application, using DBC/DBF's on a windows server, it has been 
running fine and quick for years.  Various windows clients (all now Windows 10).

The server was a physical server but has now been replaced with a virtual 
machine hosted on a HyperV machine on premises.

Most of the 20 clients are still running fine, but a handful (3 identified) at 
the moment are running really slow, they are only running slow in the VFP 
application any other use of the server like copying files runs fine.  They 
also seem to be the better spec'd machines out of the 20.  Nothing has changed 
on the client pc's other than the unc path where the application is looking for 
the data.

Any suggestions?

TIA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo2spr01mb0069010ba5a090f0bd9b3e178f...@lo2spr01mb0069.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Google Sheets

[Chris Davis]

Before I start I just wondered if anyone has any experience of interacting with 
a google sheet from VFP?

I have a licensed copy of ChilKat and have successfully create an app and 
authenticated and managed basic read and write bulk data updates.

But now need to my head around identifying and updating existing data so 
thought now was a good time to see if there is any advice or tips knocking 
around out there.

TIA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3325bad41bbde400cbb3dabc8f...@loyp123mb3325.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Pringing PDFs via ShellExecute from VFP

[Chris Davis]

Hi Philip

I had the same problem recently and switched with success to 

http://www.columbia.edu/~em36/pdftoprinter.html

as sometimes we found adobe would leave itself open so any checks to see if it 
was still running couldn't be relied on.

Then using the following ShellExecute code ... you will notice my method on the 
form agcheckexe("pdftoprinter.exe"), I have included that code as well as this 
basically loops until any previous instances have finished before it launches 
again for the next PDF you want to queue up ...

&& PDF PRINT METHOD
LPARAMETERS lcfilename
lcfilename=ALLTRIM(TRANSFORM(lcfilename))

declare INTEGER ShellExecute in shell32 INTEGER handle, STRING @ oper, ;
STRING @ ifile, STRING @ iparam, STRING @ ipath, INTEGER showcmd

lcfile="c:\pdfprinter\pdftoprinter.exe"
lcpath=""

lcparam=["]+lcfilename+["]

DO WHILE thisform.agcheckexe("pdftoprinter.exe")
ENDDO

shellexecute(0,"open",lcfile,lcparam,lcpath,1)
=

&& AGCHECKEXE METHOD
LPARAMETERS tcName, tlTerminate
LOCAL loLocator, loWMI, loProcesses, loProcess, llIsRunning
loLocator   = CREATEOBJECT('WBEMScripting.SWBEMLocator')
loWMI   = loLocator.ConnectServer() 
loWMI.Security_.ImpersonationLevel = 3  && Impersonate

loProcesses = loWMI.ExecQuery([SELECT * FROM Win32_Process WHERE Name = '] 
+ tcName + ['])
llIsRunning = .F.
IF loProcesses.Count > 0
FOR EACH loProcess in loProcesses
llIsRunning = .T.
IF tlTerminate
loProcess.Terminate(0)
ENDIF
ENDFOR
ENDIF
RETURN llIsRunning


Regards

Chris

-Original Message-
From: ProfoxTech  On Behalf Of Philip Borkholder
Sent: 01 July 2021 20:55
To: profoxt...@leafe.com
Subject: Pringing PDFs via ShellExecute from VFP

Hi all,

I am currently printing VFP reports in sequence, then using ShellExecute to 
print PDFs via their default program (Adobe DC).
I am trying to keep each print job in sequence so they come out in the tray 
together:
Example:

WO #1
Drawings for WO #1 (PDF via ShellExecute)

WO #2
Drawings for WO #1 (PDF via ShellExecute)

etc.

What I'm running into is sometimes WO#2 prints out before WO#1's PDF prints 
from Adobe DC.

Does anyone have experience in using a Windows API to see if Adobe has printed 
the PDF before I can continue printing my next VFP form?

Thanks

Philip B
Bison Tech Plus

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3325f2252a0e2d9c4657db7f8f...@loyp123mb3325.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ShellExecute

[Chris Davis]

Thanks Alan also found this which seems to work very well ...

https://www.berezniker.com/content/pages/visual-foxpro/check-if-exe-running-and-optionally-terminate-it


-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: 09 June 2021 11:40
To: profoxt...@leafe.com
Subject: Re: ShellExecute

* -- 
https://docs.microsoft.com/en-us/previous-versions//d5fk67ky(v=vs.85)
Function RunUsingWSH(lcExe, lcCommandLine) as Integer
Local loWshShell

loWshShell = CreateObject("WScript.Shell")
this.nProcessReturnCode = loWshShell.Run(lcExe + " " + 
lcCommandLine, 1, .t.)   && Wait for result.

Endfunc



--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Wed, 9 Jun 2021, at 10:33 AM, Chris Davis wrote:
> Hi All
> 
> I want to ShellExecute a program repeatedly but not until the previous 
> instance has finished, what's the best approach?  So I effectively 
> want to wait in a loop until the previous instance exits and then run 
> it again.
> 
> Ideas?
> 
> TIA
> 
> Chris.
> 
> 
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb33162651fe5f6b41decbc3fe8f...@cwlp123mb3316.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

ShellExecute

[Chris Davis]

Hi All

I want to ShellExecute a program repeatedly but not until the previous instance 
has finished, what's the best approach?  So I effectively want to wait in a 
loop until the previous instance exits and then run it again.

Ideas?

TIA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb3316b406efac3e18021770c38f...@cwlp123mb3316.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Printing PDF's

[Chris Davis]

Hi Woody

That’s exactly what we do at the moment and Adobe Acrobat Reader executes and 
prints the PDF, but Acrobat Reader doesn’t allow you to save printing defaults 
like fit to page.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Jürgen Wondzinski
Sent: 07 June 2021 16:28
To: profoxt...@leafe.com
Subject: AW: Printing PDF's

Shouldn't this be done with a simple ShellExecute(0,"print","yourFile.pdf") ?

That's the same as when you rightclick in Explorer on your file and chose 
"Print".
Whatever is configured on that PC as default service for PDFs will get that job.

wOOdy




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Chris Davis
Gesendet: Montag, 7. Juni 2021 10:10
An: profox@leafe.com; profoxt...@leafe.com
Betreff: RE: Printing PDF's

Thanks for the replies, but I'm not printing to a PDF ... I am printing an 
existing PDF to the printer.



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives This message: 
https://leafe.com/archives/byMID/063a01d75bb1$ba73cfd0$2f5b6f70$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/063a01d75bb1$ba73cfd0$2f5b6f70$@wondzinski.de
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb3316d84d341c2664625f84ea8f...@cwlp123mb3316.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Printing PDF's

[Chris Davis]

Thanks Mike

The one that I mention I found, PDFTOPRINTER.exe seems to work really well and 
gives a lot of control, but thanks for the heads up it's always good to have a 
plan B.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Mike
Sent: 07 June 2021 09:31
To: profoxt...@leafe.com
Subject: Re: Printing PDF's

Chris,

This is a bit of a kludge, but here's an article on how you can 1. Install the 
free Foxit Reader 2. Use the Command line to copy a PDF file to the reader 
program and instruct it to print to the printer you indicate.

You can even print to a network printer.

Hope it helps.

http://www.brooksnet.com/lpd/how-print-pdf-files-command-line-windows-printer


Mike C

Chris Davis wrote:
> Thanks for the replies, but I'm not printing to a PDF ... I am printing an 
> existing PDF to the printer.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Dave 
> Crozier
> Sent: 07 June 2021 08:55
> To: profoxt...@leafe.com
> Subject: RE: Printing PDF's
>
> +1 for Foxit reader... smaller and more stable than Acrobat.
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
> Mob: 07967 671080
>
> ﴾⚆ᨎ⚆﴿
>
>
>
> Flexipol® Packaging Ltd
> T 01706 222 792
> E dcroz...@flexipol.co.uk
> W https://www.flexipol.co.uk/
> Follow us:
> Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, 
> Lancashire, BB4 5HH
>
> ​This communication and the information it contains is intended for the 
> person or organisation to whom it is addressed. Its contents are confidential 
> and may be protected in law. If you have received this e-mail in error you 
> must not copy, distribute or take any action in reliance on it. Unauthorised 
> use, copying or disclosure of any of it may be unlawful. If you have received 
> this message in error, please notify us immediately by telephone or email.
>
> Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
> risk of virus transmission through email and therefore any files sent via 
> e-mail will have been checked for known viruses. However, you are advised to 
> run your own virus check before opening any attachments received as Flexipol 
> Packaging Ltd will not in any event accept any liability whatsoever once an 
> e-mail and/or any attachment is received.
>
>   It is the responsibility of the recipient to ensure that they have adequate 
> virus protection.
>
> --
> --
> --
> --
> -
> ​​
> ​Terms & Conditions:
>   Notwithstanding delivery and the passing of risk in the goods, the 
> property in the goods shall not pass to the buyer until the seller 
> Flexipol Packaging Ltd. ("The Company") has received in cash or 
> cleared funds payment in full of the price of the goods and all other 
> goods agreed to be sold by the seller to the buyer for which payment 
> is then due. Until such time as the property in the goods passes to 
> the buyer, the buyer shall hold the goods as the seller's fiduciary 
> agent and bailee and keep the goods separate from those of the buyer 
> and third parties and properly stored protected and insured and 
> identified as the seller's property but shall be entitled to resell or 
> use the goods in the ordinary course of its business. Until such time 
> as the property in the goods passes to the buyer the seller shall be 
> entitled at any time -Original Message-
> From: ProFox  On Behalf Of Jan Bucek
> Sent: 03 June 2021 14:13
> To: profox@leafe.com
> Subject: Re: Printing PDF's
>
> Free Foxit PDF reader installs a PDFprinter by default. PDFprinter has a 
> couple of properties than can be set in Settings > Printers.
>
>
> Dne 03.06.2021 v 13:20 Chris Davis napsal(a):
>> I've found ...
>>
>> http://www.columbia.edu/~em36/pdftoprinter.html
>>
>> seems to achieve what I needed
>>
>> Thanks for the heads up on 2printer though Matt.
>>
>> Regards
>>
>> Chris.
>>
>> -Original Message-
>> From: ProfoxTech  On Behalf Of Chris 
>> Davis
>> Sent: Wednesday, 02 June 2021 13:37
>> To: profoxt...@leafe.com
>> Subject: RE: Printing PDF's
>>
>> Thanks Matt, looks good, I am hoping to find a free solution but will keep 
>> that option open if I don't.
>>
>> Regards
>>
>> Chris.
>>
>> -Original Message-
>> From: ProfoxTech  On Behalf Of Matt 
>> Slay

RE: Printing PDF's

[Chris Davis]

Thanks for the replies, but I'm not printing to a PDF ... I am printing an 
existing PDF to the printer.

-Original Message-
From: ProfoxTech  On Behalf Of Dave Crozier
Sent: 07 June 2021 08:55
To: profoxt...@leafe.com
Subject: RE: Printing PDF's

+1 for Foxit reader... smaller and more stable than Acrobat.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

Mob: 07967 671080

﴾⚆ᨎ⚆﴿



Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us: 
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.
  
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any attachments received as Flexipol 
Packaging Ltd will not in any event accept any liability whatsoever once an 
e-mail and/or any attachment is received.
  
 It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

-
​​
​Terms & Conditions:
 Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. 
("The Company") has received in cash or cleared funds payment in full of the 
price of the goods and all other goods agreed to be sold by the seller to the 
buyer for which payment is then due. Until such time as the property in the 
goods passes to the buyer, the buyer shall hold the goods as the seller's 
fiduciary agent and bailee and keep the goods separate from those of the buyer 
and third parties and properly stored protected and insured and identified as 
the seller's property but shall be entitled to resell or use the goods in the 
ordinary course of its business. Until such time as the property in the goods 
passes to the buyer the seller shall be entitled at any time -Original 
Message-
From: ProFox  On Behalf Of Jan Bucek
Sent: 03 June 2021 14:13
To: profox@leafe.com
Subject: Re: Printing PDF's

Free Foxit PDF reader installs a PDFprinter by default. PDFprinter has a couple 
of properties than can be set in Settings > Printers.


Dne 03.06.2021 v 13:20 Chris Davis napsal(a):
> I've found ...
> 
> http://www.columbia.edu/~em36/pdftoprinter.html
> 
> seems to achieve what I needed
> 
> Thanks for the heads up on 2printer though Matt.
> 
> Regards
> 
> Chris.
> 
> -Original Message-
> From: ProfoxTech  On Behalf Of Chris 
> Davis
> Sent: Wednesday, 02 June 2021 13:37
> To: profoxt...@leafe.com
> Subject: RE: Printing PDF's
> 
> Thanks Matt, looks good, I am hoping to find a free solution but will keep 
> that option open if I don't.
> 
> Regards
> 
> Chris.
> 
> -Original Message-
> From: ProfoxTech  On Behalf Of Matt Slay
> Sent: 02 June 2021 12:26
> To: profoxt...@leafe.com
> Subject: Re: Printing PDF's
> 
> Check out 2Printer. I've used the trial version recently to test it.
> It's got a powerful command line syntax with options to set the paper size.
> 
> https://www.cmd2printer.com/ <https://www.cmd2printer.com/>
> 
> 
> Here is the very complete documentation on the syntax. I was able to get a 
> list of available printers, then I was able to get a list of defined paper 
> sizes for my desired printer, the I was able to print a PDF tabloid (ledger, 
> 11" X 17") from the command line.
> 
> https://www.cmd2printer.com/overview/syntax
> <https://www.cmd2printer.com/overview/syntax>
> 
> 
> *- Matt Slay*
> 
> 
> 
> On 6/2/2021 3:01 AM, Chris Davis wrote:
>> Hi All
>>
>> We are currently printing some PDF content using the shell print function 
>> that just triggers the default application for opening PDF's to do its 
>> stuff.  We have a lot of A5 content which needs to printed to fit A4 paper, 
>> is there another method I could use that would give us this control.
>>
>> We have t

RE: Printing PDF's

[Chris Davis]

I've found ...

http://www.columbia.edu/~em36/pdftoprinter.html

seems to achieve what I needed 

Thanks for the heads up on 2printer though Matt.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: Wednesday, 02 June 2021 13:37
To: profoxt...@leafe.com
Subject: RE: Printing PDF's

Thanks Matt, looks good, I am hoping to find a free solution but will keep that 
option open if I don't.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Matt Slay
Sent: 02 June 2021 12:26
To: profoxt...@leafe.com
Subject: Re: Printing PDF's

Check out 2Printer. I've used the trial version recently to test it. 
It's got a powerful command line syntax with options to set the paper size.

https://www.cmd2printer.com/ <https://www.cmd2printer.com/>


Here is the very complete documentation on the syntax. I was able to get a list 
of available printers, then I was able to get a list of defined paper sizes for 
my desired printer, the I was able to print a PDF tabloid (ledger, 11" X 17") 
from the command line.

https://www.cmd2printer.com/overview/syntax
<https://www.cmd2printer.com/overview/syntax>


*- Matt Slay*



On 6/2/2021 3:01 AM, Chris Davis wrote:
> Hi All
>
> We are currently printing some PDF content using the shell print function 
> that just triggers the default application for opening PDF's to do its stuff. 
>  We have a lot of A5 content which needs to printed to fit A4 paper, is there 
> another method I could use that would give us this control.
>
> We have tried setting defaults in Acrobat Reader but the fit to page option 
> isn't one it retains, we are also thinking there might be a more efficient 
> way of getting the PDF to the printer other than using the default app.
>
> TIA
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>text/plain (text body -- kept)
>text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb332552c7b1ff64a044bc218c8f...@loyp123mb3325.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Printing PDF's

[Chris Davis]

Thanks Matt, looks good, I am hoping to find a free solution but will keep that 
option open if I don't.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Matt Slay
Sent: 02 June 2021 12:26
To: profoxt...@leafe.com
Subject: Re: Printing PDF's

Check out 2Printer. I've used the trial version recently to test it. 
It's got a powerful command line syntax with options to set the paper size.

https://www.cmd2printer.com/ <https://www.cmd2printer.com/>


Here is the very complete documentation on the syntax. I was able to get a list 
of available printers, then I was able to get a list of defined paper sizes for 
my desired printer, the I was able to print a PDF tabloid (ledger, 11" X 17") 
from the command line.

https://www.cmd2printer.com/overview/syntax
<https://www.cmd2printer.com/overview/syntax>


*- Matt Slay*



On 6/2/2021 3:01 AM, Chris Davis wrote:
> Hi All
>
> We are currently printing some PDF content using the shell print function 
> that just triggers the default application for opening PDF's to do its stuff. 
>  We have a lot of A5 content which needs to printed to fit A4 paper, is there 
> another method I could use that would give us this control.
>
> We have tried setting defaults in Acrobat Reader but the fit to page option 
> isn't one it retains, we are also thinking there might be a more efficient 
> way of getting the PDF to the printer other than using the default app.
>
> TIA
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>text/plain (text body -- kept)
>text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3325248e9f21cc844a694bc18f...@loyp123mb3325.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Printing PDF's

[Chris Davis]

Hi All

We are currently printing some PDF content using the shell print function that 
just triggers the default application for opening PDF's to do its stuff.  We 
have a lot of A5 content which needs to printed to fit A4 paper, is there 
another method I could use that would give us this control.

We have tried setting defaults in Acrobat Reader but the fit to page option 
isn't one it retains, we are also thinking there might be a more efficient way 
of getting the PDF to the printer other than using the default app.

TIA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3325dff32e2e46fce8d39d7e8f...@loyp123mb3325.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: XLSX-Workbook-Class

[Chris Davis]

Sorry that's what its called on VFPX project page ... 
https://github.com/ggreen86/XLXS-Workbook-Class



-Original Message-
From: ProfoxTech  On Behalf Of 
juer...@wondzinski.de
Sent: 26 November 2020 16:31
To: profoxt...@leafe.com
Subject: AW: XLSX-Workbook-Class

It would help if you would specify, which xlsx class you're referring to.
Link?

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Chris Davis
Gesendet: Donnerstag, 26. November 2020 16:53
An: profox@leafe.com
Betreff: XLSX-Workbook-Class

Can anyone help with this ???


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb26413bdb78b778ffd32420d88f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: XLSX-Workbook-Class

[Chris Davis]

Sorry forget this question I have updated from the R31 version to the R32 beta 
and its now working as expected.

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: 26 November 2020 15:53
To: profoxt...@leafe.com
Subject: XLSX-Workbook-Class

Can anyone help with this ???


I use the example readxlsxfile.prg and check the generated debugexcelread file 
and everything is correct.  i.e. all the values and all the rows ...

I then replicate this code in my application and then any string value that's 
return always returns the first value from Row 1 Col 1.

PUBLIC goexcel
goexcel=thisform.goexcel

lcfile=this.txtName.Value

IF !EMPTY(lcFile)
  lnWb = goExcel.OpenXlsxWorkbook(lcFile)
  loSheets = goExcel.GetWorkbookSheets(lnWb)

  FOR lnSh=1 TO loSheets.Count
FOR lnRow=1 TO goExcel.GetLastRowNumber(lnWb, loSheets.List[lnSh, 
1])
  FOR lnCol=1 TO goExcel.GetMaxColumnNumber(lnWb, 
loSheets.List[lnSh, 1]) wait window "Row: "+TRANSFORM(lnrow)+ " Column: 
"+TRANSFORM( lnCol)+ "  Value: "+ TRANSFORM(goExcel.GetCellValue(lnWb, 
loSheets.List[lnSh, 1], lnRow, lnCol)) ENDFOR
ENDFOR
  ENDFOR
ENDIF

The wait window displays the rows and column references as expected but the 
value is always the value from 1,1.

Any ideas?

Regards

Chris.



--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb2641ab92700b817c65c75e9b8f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

XLSX-Workbook-Class

[Chris Davis]

Can anyone help with this ???


I use the example readxlsxfile.prg and check the generated debugexcelread file 
and everything is correct.  i.e. all the values and all the rows ...

I then replicate this code in my application and then any string value that's 
return always returns the first value from Row 1 Col 1.

PUBLIC goexcel
goexcel=thisform.goexcel

lcfile=this.txtName.Value

IF !EMPTY(lcFile)
  lnWb = goExcel.OpenXlsxWorkbook(lcFile)
  loSheets = goExcel.GetWorkbookSheets(lnWb)

  FOR lnSh=1 TO loSheets.Count
FOR lnRow=1 TO goExcel.GetLastRowNumber(lnWb, loSheets.List[lnSh, 
1])
  FOR lnCol=1 TO goExcel.GetMaxColumnNumber(lnWb, 
loSheets.List[lnSh, 1])
wait window "Row: "+TRANSFORM(lnrow)+ " Column: "+TRANSFORM( lnCol)+ "  Value: 
"+ TRANSFORM(goExcel.GetCellValue(lnWb, loSheets.List[lnSh, 1], lnRow, lnCol))
ENDFOR
ENDFOR
  ENDFOR
ENDIF

The wait window displays the rows and column references as expected but the 
value is always the value from 1,1.

Any ideas?

Regards

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb2641feb7df7b4d91789b8a368f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Opinions on Servers

[Chris Davis]

Thanks Christof, I think trying a Raid 10 array with 4 SSD's seems like a good 
way forward for us as its not a massive change to the norm.

Thanks for your input.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Christof 
Wollenhaupt
Sent: Tuesday, 24 November 2020 11:17
To: profoxt...@leafe.com
Subject: Re: Opinions on Servers

> Yes sorry I didn't make it clear, this is an RDS server so the .exe and DBFs 
> will be on the same machine.  So it sounds like the main consideration to 
> make the application work as quickly as possible is the disk.  
> 
> Typically in the past we would have had 4 15k rpm HDD's running in a Raid 10 
> configuration.  We are thinking maybe SSD or NVMe will make a massive 
> difference but not sure how much of a difference taking into account the cost.

VFP is IOPS intensive, so anything you can do to increase that number will 
directly benefit VFP applications. An array of 4 SSDs equals to an array of 150 
15K SAS disks in terms of IOPS. If SSD is an option when considering that 
server grade SSDs are more expensive, I'd definitely go with SSD. I don't think 
NVMe would make a big difference here over 6 Gb/s SSDs. Depending on how many 
different channels you have to access SSDs, they already deliver 15-60 MB/s per 
user minimum. Plus a TS with local DBF files can actually cache data that is 
most used unlike TS that access a NAS or SAN.

The other issue is memory. Without reconfiguring Window a VFP application can 
make use of up to 2 GB of memory. For 30 users working mainly with this 
application you probably peak out at 96 GB RAM. It's a little more if you run 
browsers and Office in addition to the VFP application. On the other side of 
the spectrum I wouldn't run on anything less than 32 GB these days. 

--
Christof
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb2641e8e4eee38879e497ec928f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Opinions on Servers

[Chris Davis]

Hi Alan

Yes sorry I didn't make it clear, this is an RDS server so the .exe and DBFs 
will be on the same machine.  So it sounds like the main consideration to make 
the application work as quickly as possible is the disk.  

Typically in the past we would have had 4 15k rpm HDD's running in a Raid 10 
configuration.  We are thinking maybe SSD or NVMe will make a massive 
difference but not sure how much of a difference taking into account the cost.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Tuesday, 24 November 2020 08:45
To: profoxt...@leafe.com
Subject: Re: Opinions on Servers

> If you was choosing a server which would run a vfp application using 
> standard dbfs

It won't be running a VFP application (unless it's the RDS server too), it'll 
just be providing access to a shared folder with DBFs in it. So disk and 
network throughput is very important.

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb264118f935e6a3b6d47760978f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Opinions on Servers

[Chris Davis]

Thanks Tracy

So, you would typically have the clients RDP'ing into one server to run the 
.exe in turn accessing the dbf's on another VM acting as a file server?

How are the physical drives configured, is there any redundancy if anything 
fails or you using some VM magic?

Thanks

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Monday, 23 November 2020 14:54
To: profoxt...@leafe.com
Subject: RE: Opinions on Servers

Hi Chris,

We get away with 1 CPU core per server in a VM to get good performance 
accessing DBFs on a different VM.
More CPU cores may help by allowing the server to spread out on additional 
cores. We don't see a lot of CPU usage per VM.
The bottle neck appears to be IO access to the DBFs.
With that said, we have over 20 machines that allow a Remote Desktop like 
connection and 5 separate storage VMs for our 4000+ clients.

The fastest drives you can get (SSD's are a good choice) and a good backup 
solution.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Monday, November 23, 2020 9:04 AM
To: profoxt...@leafe.com
Subject: Opinions on Servers

Hi All

Just a general question ...

If you was choosing a server which would run a vfp application using standard 
dbfs as fast as possible for around 30 users (connected via remote desktop).  
What server would you choose to get the best performance?

Is it CPU's , Hard Drive Configuration, Memory etc ... we can assume that there 
is sufficient memory for the remote desktop side of things.

Thanks

Chris.


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb2641dde001ffaf29e50620e78f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Opinions on Servers

[Chris Davis]

Hi All

Just a general question ...

If you was choosing a server which would run a vfp application using standard 
dbfs as fast as possible for around 30 users (connected via remote desktop).  
What server would you choose to get the best performance?

Is it CPU's , Hard Drive Configuration, Memory etc ... we can assume that there 
is sufficient memory for the remote desktop side of things.

Thanks

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp123mb264172c5dccf1b3f54960aca8f...@cwlp123mb2641.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Is there a way to uto open the last project?

[Chris Davis]

We use a simple project class to put us into the root directory of the project 
we have just opened.

DEFINE CLASS projhook AS projecthook

Height = 22
Width = 23
Name = "projhook"

PROCEDURE Init
LOCAL lcDir
lcDir=_VFP.ACTIVEPROJECT.HOMEDIR
SET DEFAULT TO (lcDir)
ENDPROC


ENDDEFINE



-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Monday, 03 February 2020 21:08
To: profoxt...@leafe.com
Subject: RE: Is there a way to uto open the last project?

If you have the setting in the Tools - Options - View tab - Open last project 
on startup.
You may be able to look at _VFP.ActiveProject.HomeDir to know where to go.
Otherwise, I'm not sure how to determine the last used project. 

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael 
Savage
Sent: Monday, February 03, 2020 4:01 PM
To: profoxt...@leafe.com
Subject: Is there a way to uto open the last project?

I have standard directory structure that I use. I can run a seetup program when 
I'm in the root directory of a project. Is there  way to know what the last 
project project was, and therefore change to it automatically and then run my 
setup routine.
TIA,
Mike


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3167226f3fc069b6ce4ce25f8f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: AW: May the Open Source Be With You: INTL and SDT!

[Chris Davis]

http://eqeus.com/

Does more than just PDF, but includes lots of useful extras.

-Original Message-
From: ProfoxTech  On Behalf Of António Tavares 
Lopes
Sent: Friday, 17 January 2020 23:55
To: profoxt...@leafe.com
Subject: Re: AW: May the Open Source Be With You: INTL and SDT!

Foxypreviewer produces PDF files based on VFP reports if that's your target 
scenario.

At our company, we have been producing PDF files for years using TextControl, 
and now we are evaluating Foxit for its signing capabilities and programmatic 
features.

On Fri, Jan 17, 2020 at 9:44 PM roger tremblay  wrote:

>
> Does anyone know if VFP can write pdf files?
>
> TIA
>
>
> Roger
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb316790440e76cdf0f5bd9d598f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQL Dump

[Chris Davis]

Sorry! Thanks Stephen even!

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: Sunday, 01 December 2019 14:30
To: profoxt...@leafe.com
Subject: RE: SQL Dump

Thanks Russell I will get on google/youtube tonight and look into this , thanks 
for the heads up

-Original Message-
From: ProfoxTech  On Behalf Of Stephen Russell
Sent: Sunday, 01 December 2019 13:48
To: profoxt...@leafe.com
Subject: Re: SQL Dump

That sounds like an ETL job that I would set up in SSIS

There are plenty of youtube vids on this.

We use SSIS to extract data from our ERP database nightly for inclusion in the 
data warehouse and then for our data marts.


On Sat, Nov 30, 2019 at 1:52 PM Chris Davis  wrote:

> Thanks everyone for all the ideas and advice, I will give them a try.
>
> Effectively what I am trying to create is a way to replicate a VFP DBC 
> to a SQL Database daily.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Stephen 
> Russell
> Sent: Friday, 29 November 2019 16:08
> To: profoxt...@leafe.com
> Subject: Re: SQL Dump
>
> What incorrect answers these were.
>
> IN the DB you made in SQL Server you can import the data at SSIS speed.
>
> Rt click on the DB in the DB pane.  Tasks and Import Data.
>
> >From there you tell it to use VFP data via your oledb engine.  From 
> >there
> it will make all tables and indexes from VFP and import it very fast.
>
> Sorry I was driving when this was first posted.  You can Youtube SQL 
> Server Import data and see a few different vids on how to do this.
> The wizard has been around for decades and still does a great job of 
> setting up what you need to do and allowing you to watch the process as it is 
> cranking.
>
> Your single row inserts will waste a lot of energy updating the log 
> for each row you inserted.  This skips that altogether.
>
>
>
> On Thu, Nov 28, 2019 at 10:55 AM Chris Davis 
> wrote:
>
> > Hi All
> >
> > Is there any tricks I am missing which would speed up a dump of a 
> > VFP table into a SQL table.
> >
> > I have predifined by SQL statement something like this
> >
> > "insert into mytable (myfield) values (?m.myfield)"
> >
> > I am then scanning through the VFP table performing a scatter memvar 
> > and then executing the SQL.
> >
> > It works it just seems to take alot longer than I imagined it would.
> >
> > Thanks IA
> >
> > Chris.
> >
> >
> > --- StripMime Report -- processed MIME parts --- multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb316720b5102d5fd680f8462e8f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQL Dump

[Chris Davis]

Thanks Russell I will get on google/youtube tonight and look into this , thanks 
for the heads up

-Original Message-
From: ProfoxTech  On Behalf Of Stephen Russell
Sent: Sunday, 01 December 2019 13:48
To: profoxt...@leafe.com
Subject: Re: SQL Dump

That sounds like an ETL job that I would set up in SSIS

There are plenty of youtube vids on this.

We use SSIS to extract data from our ERP database nightly for inclusion in the 
data warehouse and then for our data marts.


On Sat, Nov 30, 2019 at 1:52 PM Chris Davis  wrote:

> Thanks everyone for all the ideas and advice, I will give them a try.
>
> Effectively what I am trying to create is a way to replicate a VFP DBC 
> to a SQL Database daily.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Stephen 
> Russell
> Sent: Friday, 29 November 2019 16:08
> To: profoxt...@leafe.com
> Subject: Re: SQL Dump
>
> What incorrect answers these were.
>
> IN the DB you made in SQL Server you can import the data at SSIS speed.
>
> Rt click on the DB in the DB pane.  Tasks and Import Data.
>
> >From there you tell it to use VFP data via your oledb engine.  From 
> >there
> it will make all tables and indexes from VFP and import it very fast.
>
> Sorry I was driving when this was first posted.  You can Youtube SQL 
> Server Import data and see a few different vids on how to do this.  
> The wizard has been around for decades and still does a great job of 
> setting up what you need to do and allowing you to watch the process as it is 
> cranking.
>
> Your single row inserts will waste a lot of energy updating the log 
> for each row you inserted.  This skips that altogether.
>
>
>
> On Thu, Nov 28, 2019 at 10:55 AM Chris Davis 
> wrote:
>
> > Hi All
> >
> > Is there any tricks I am missing which would speed up a dump of a 
> > VFP table into a SQL table.
> >
> > I have predifined by SQL statement something like this
> >
> > "insert into mytable (myfield) values (?m.myfield)"
> >
> > I am then scanning through the VFP table performing a scatter memvar 
> > and then executing the SQL.
> >
> > It works it just seems to take alot longer than I imagined it would.
> >
> > Thanks IA
> >
> > Chris.
> >
> >
> > --- StripMime Report -- processed MIME parts --- multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3167ca14761cf90701c5b51f8f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQL Dump

[Chris Davis]

As the backend for a website which can work off a day old copy of the data as 
various tasks performed in the vfp app take exclusive access of the data

-Original Message-
From: ProfoxTech  On Behalf Of MB Software 
Solutions, LLC
Sent: Sunday, 01 December 2019 00:19
To: profoxt...@leafe.com
Subject: Re: SQL Dump

For the purposes of a daily backup as a failsafe or what?

On 11/30/2019 2:51 PM, Chris Davis wrote:
> Thanks everyone for all the ideas and advice, I will give them a try.
>
> Effectively what I am trying to create is a way to replicate a VFP DBC to a 
> SQL Database daily.
>
>

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb316737565e9d67a15e08ce7e8f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQL Dump

[Chris Davis]

Thanks everyone for all the ideas and advice, I will give them a try.

Effectively what I am trying to create is a way to replicate a VFP DBC to a SQL 
Database daily.

-Original Message-
From: ProfoxTech  On Behalf Of Stephen Russell
Sent: Friday, 29 November 2019 16:08
To: profoxt...@leafe.com
Subject: Re: SQL Dump

What incorrect answers these were.

IN the DB you made in SQL Server you can import the data at SSIS speed.

Rt click on the DB in the DB pane.  Tasks and Import Data.

>From there you tell it to use VFP data via your oledb engine.  From 
>there
it will make all tables and indexes from VFP and import it very fast.

Sorry I was driving when this was first posted.  You can Youtube SQL Server 
Import data and see a few different vids on how to do this.  The wizard has 
been around for decades and still does a great job of setting up what you need 
to do and allowing you to watch the process as it is cranking.

Your single row inserts will waste a lot of energy updating the log for each 
row you inserted.  This skips that altogether.



On Thu, Nov 28, 2019 at 10:55 AM Chris Davis  wrote:

> Hi All
>
> Is there any tricks I am missing which would speed up a dump of a VFP 
> table into a SQL table.
>
> I have predifined by SQL statement something like this
>
> "insert into mytable (myfield) values (?m.myfield)"
>
> I am then scanning through the VFP table performing a scatter memvar 
> and then executing the SQL.
>
> It works it just seems to take alot longer than I imagined it would.
>
> Thanks IA
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb31675c5862926255b6f297868f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SQL Dump

[Chris Davis]

Hi All

Is there any tricks I am missing which would speed up a dump of a VFP table 
into a SQL table.

I have predifined by SQL statement something like this

"insert into mytable (myfield) values (?m.myfield)"

I am then scanning through the VFP table performing a scatter memvar and then 
executing the SQL.

It works it just seems to take alot longer than I imagined it would.

Thanks IA

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb31676f6ad36f7fae59e027738f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

File Sync

[Chris Davis]

Can anyone recommend a free and simple file syncing program to mirror a folder 
on a server to a local folder (files and subfolders).

I had been using freefilesync / robocopy but struggling with both of these on 
one particular computer and want to try another such utility to see if it gives 
me a better idea of what the issue is.

Thanks

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb31672e4deab27cf67d2af7928f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: OLE iDispatch Exception

[Chris Davis]

Thanks Andy & Tracy, I had misread it, I thought VFP couldn't find the 
msxml3.dll resource!!! Reading it again as the control can't find the URL 
resource now  makes a lot of sense.


-Original Message-
From: ProfoxTech  On Behalf Of AndyHC
Sent: Thursday, 24 October 2019 11:34
To: profoxt...@leafe.com
Subject: Re: OLE iDispatch Exception

Your internet connection is [briefly] down?

On 24-Oct-2019 2:50 PM, Chris Davis wrote:
> The following code works most of the time but occasionally it throws the 
> following OLE error when .send is called, any ideas?
>
> lcURL=www.bbc.co.uk<http://www.bbc.co.uk> && not the real url
>
> oHTTP = CreateObject("msxml2.xmlhttp")
> oHTTP.open("GET",lcurl,.f.)
> oHTTP.send()
>
>
>
> OLE IDispatch exception code 0 from msxml3.dll: The system cannot 
> locate the resource specified
>
> Regards
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>text/plain (text body -- kept)
>text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb3167556038ef951f046821448f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

OLE iDispatch Exception

[Chris Davis]

The following code works most of the time but occasionally it throws the 
following OLE error when .send is called, any ideas?

lcURL=www.bbc.co.uk && not the real url

oHTTP = CreateObject("msxml2.xmlhttp")
oHTTP.open("GET",lcurl,.f.)
oHTTP.send()



OLE IDispatch exception code 0 from msxml3.dll: The system cannot locate the 
resource specified

Regards

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/loyp123mb316795deb085a3023c86ca9b8f...@loyp123mb3167.gbrp123.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SMB

[Chris Davis]

>From what I have read it is also in the latest version of Windows 10, so you 
>can effectively type from the client end ...

New-smbmapping -remotepath '\\myserver\myvfpappshare' UseWriteThrough $True

And it doesn't matter what the server is.


-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Tuesday, 03 September 2019 11:10
To: profoxt...@leafe.com
Subject: Re: SMB

New in Server 2019 it appears.

At a guess, with regards to VFP applications, it would be similar to existing 
methods which turn off SMB caching, i.e. a bad idea as it will hammer 
performance.

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp265mb1668e153afe4fe9ba3c2c8a88f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SMB

[Chris Davis]

Has anyone got any thoughts on

New-SMBMapping -UseWriteThrough $True 

-Original Message-
From: ProfoxTech  On Behalf Of MB Software 
Solutions, LLC
Sent: Tuesday, 27 August 2019 14:44
To: profoxt...@leafe.com
Subject: Re: SMB

On 8/27/2019 8:29 AM, Frank Cazabon wrote:
> Hi Chris,
>
> I moved away from DBF and DBC a long time ago but I don't think it was 
> very difficult to check the registry settings manually.
>
>
Yep...same here.  I haven't designed major apps with DBFs since I saw Bob Lee 
use a MySQL database in New York from his VFP app in Milwaukee years ago at 
WhilFest.  So many benefits to that design decision.  I always lead by telling 
folks they're getting the same database as NASA and Google use and they'll 
never run out of space, that the app will be running long ago they've retired.

IMO, the key to good VFP app design is to use the N-tier approach where you 
separate the UI/BizObj/DataObj so that you can easily swap out backends or 
frontends or whatever.  I've loved working on my apps for 15 years because of 
that good design organization, imo.

Frank provided some good tips, Chris, so I hope they help.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives This message: 
https://leafe.com/archives/byMID/2ff7f7f8-4733-52a5-a17c-51a66abf5...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/2ff7f7f8-4733-52a5-a17c-51a66abf5...@mbsoftwaresolutions.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp265mb166806b66d6bdf90826631e08f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SMB

[Chris Davis]

Brilliant Alan thanks I will give it a shot 

> On 27 Aug 2019, at 14:32, Alan Bourke  wrote:
> 
>> On Tue, 27 Aug 2019, at 11:57 AM, Chris Davis wrote:
>> 
>> or at least allow you to compare two setups?
> 
> Go to server 1 and run PowerShell as administrator.
> 
> Then
> 
> Get-SmbServerConfiguration > server1-serverconfig.txt
> Get-SmbClientConfiguration > server1-clientconfig.txt
> 
> then repeat on server 2,  outputting to different text files.
> 
> Then compare the text files using the compare tool of your choice, which will 
> highlight the differences.
> 
> e.g.
> 
> fc server1-serverconfig.txt server2-serverconfig.txt
> 
> -- 
>  Alan Bourke
>  alanpbourke (at) fastmail (dot) fm
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/d837dd95-6cec-4751-ae1b-a79ba7ec5...@actongate.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SMB

[Chris Davis]

Thanks Ted

As per my reply to Frank unfortunately the application in this instance isn't 
our own, so I am not worried if the application is well designed or not I am 
just simply comparing it running OK on one server and like a sack of spuds on 
another.  We also get index corruption and crashes.

Typically most of the issues are with the newest server rather than the oldest. 
 The worst scenario being more recent when Virtual Machines were employed so 
the highest specification and the performance dropped significantly.  

Typically we are not responsible for the servers these are done by different 
third parties and so my end goal is advice to those companies on how to 
configure the server they have supplied to run this application.

Some of the advice given from the software vendor is to change these settings 
on the client which is why I was focusing on SMB.

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanWorkstation\Parameters]
 
"FileInfoCacheLifetime"=dword: 
"FileNotFoundCacheLifetime"=dword: 
"DirectoryCacheLifetime"=dword:

Thanks

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Ted Roche
Sent: Tuesday, 27 August 2019 13:32
To: profoxt...@leafe.com
Subject: Re: SMB

On Tue, Aug 27, 2019 at 6:58 AM Chris Davis  wrote:

>
> With any networked VFP application sharing a DBC the SMB performance 
> of the server hosting the DBC is very important?
>

No.

Yes, network performance is very important, but that is a complex mix of 
network throughput, latency, congestion, theoretical max speed (VFP did some 
pretty nifty things on 10 Mbps networks, way back when), the basic hardware 
specs (CPU, clock speed, RAM amount, hard disk performance) and the other 
demands on the server (running VFP and Exchange and SQL Server on the same 
machine, for example). And finally, the actual structure and logic of the app 
is so important: I've been called in on apps where all the temp files were 
written back to the network, or all of the data files were opened, queried and 
closed on every call, ruining the VFP caching.

Ideally, all of the relatively static resources used by the app should be 
installed on the local machine: EXE, external reports, temp files, local 
working tables and the DBC, and a startup program should be invoked each time 
the app is launched to download an updated version if available from the 
network. That cuts down on calls to the network to just data, and removes all 
the contention from sharing the DBC.

Assuming your answer to the above question is Yes or Of Course, then when
> you have one server that seems to perform well and one that doesn't it 
> would be useful to easily compare the setup of the two.
>

No two Windows machines are the same.


> Is anyone aware of any utilities that make the configuration and 
> tweaking of SMB easy or at least allow you to compare to setups?
>

Is there a reason you are focusing on Server Message Block as the source of the 
problems? IME, a bad network card or cable is responsible for poor network 
throughput. Basic SMB is about the same from workstation shares through 
workgroups and domains and Active Directory.

Performance Monitor on the server is one of the easiest clue factories: CPU 
load, HDD performance, network load gives so many useful clues. Something is 
always the bottleneck, it's just a matter of narrowing down the possibilities.

And the Log reader is an application woefully underused: I often find a log 
full of error messages that the onsite folks have never seen.


> Of course, if your answer to the first question isn't yes I would also 
> be interested in your thoughts.
>
> I know there is a lot more that comes into the performance of an 
> application other than the setup of the server, i.e the spec of the 
> client, the os of the client, other software such as anti virus, 
> network infrastructure etc etc.
>
> Where I am going with this...
>
> We have lots of sites where an application works well and one site 
> where it doesn't, and without having to spend hours and hours 
> investigating all the various settings and registry entries,  I just 
> want to start with the servers and make a comparison to see if there are any 
> obvious differences.
>

On the machine, or dialed in by remote control, File Explorer, This PC, 
right-click, Properties, will give you the basic OS version, CPU and RAM.
Right-click on the taskbase and Task Manager, More details, will show you any 
obvious bottlenecks. Back to File Explorer, this PC, right-click and Manage 
brings up the Computer Management console, Event Viewer will let you look at 
the logs.


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@lea

RE: SMB

[Chris Davis]

Thanks Frank

Unfortunately the application in this instance is not written by us, and 
although a SQL based version of the application is available it doesn’t have 
all the modules over the VFP version so in most cases we are only able to 
install the VFP version.

We are mostly talking about Server 2012R2+ (Some Server 2008) including 2016 
and Windows 7/10 clients, so SMB1 is for the most gone and this is about using 
SMB2 without issue.

Thanks

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Frank Cazabon
Sent: Tuesday, 27 August 2019 13:30
To: profoxt...@leafe.com
Subject: Re: SMB

Hi Chris,

I moved away from DBF and DBC a long time ago but I don't think it was very 
difficult to check the registry settings manually.

There is a tool available here:

http://www.symantec.com/connect/downloads/smb2-toggle-too-mikes-tool-set

Here are my notes from back then:

*To Disable SMB2*

When using the terms "client" and "server" in case of file and print sharing, 
it does not necessarily mean that a client-type OS such as Vista "always" 
connects to a server-type Os such as Windows Server 2008. 
Sometimes, a Vista computer will connect to another Vista computer, and in that 
case, the computer that is "serving" the shares is considered to be the 
"server".

Here's how SMB is used when related to SMB versions:
When a Windows Server 2008/Vista "client" connects to a Windows Server 
2008/Vista "server", SMB 2.0 is used.
When a Windows Server 2008/Vista "client" connects to a Windows
2000/XP/2003 "server", SMB 1.0 is used.
When a Windows 2000/XP/2003 "client" connects to a Windows Server 2008/Vista 
"server", SMB 1.0 is used.
When a Windows 2000/XP/2003 "client" connects to a Windows 2000/XP/2003 
"server", SMB 1.0 is used.
So, for troubleshooting purposes, mostly in an environment that has mixed 
operating systems, you might want to consider disabling SMB 2.0. 
You need to do so on both the "client" and the "server" operating systems. To 
disable SMB 2.0 for Windows Vista or Windows Server 2008 systems that are the 
“client” systems run the following commands:
sc config lanmanworkstation depend= bowser/mrxsmb10/nsi sc config mrxsmb20 
start= disabled Note there's an extra " " (space) after the "=" sign.
To enable back SMB 2.0 for Windows Vista or Windows Server 2008 systems that 
are the “client” systems run the following commands:
sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsisc config 
mrxsmb20 start= auto Again, note there's an extra " " (space) after the "=" 
sign.
In order to disable SMB 2.0 on the server-side computer, follow these steps:


Warning!

This document contains instructions for editing the registry. If you make any 
error while editing the registry, you can potentially cause Windows to fail or 
be unable to boot, requiring you to reinstall Windows. Edit the registry at 
your own risk. Always back up the registry before making any changes. If you do 
not feel comfortable editing the registry, do not attempt these instructions. 
Instead, seek the help of a trained computer specialist.

 1.
Run "regedit" on Windows Server 2008 based computer.
 2.
Expand and locate the sub tree as follows.
HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters
 3.
Add a new REG_DWORD key with the name of "Smb2" (without quotation mark)
Value name: Smb2Value type: REG_DWORD0 = disabled1 = enabled  4.
Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable
SMB 2.0.
 5.
Reboot the server.

This paper may also be of some assistance:

https://www.dataaccess.com/KBasePublic/Files/2476.Tuning%20Microsoft%20Networks%20for%20the%20Legacy%20Embedded%20Database_PDF_FMT.PDF


Frank.

Frank Cazabon

On 27/08/2019 06:57 AM, Chris Davis wrote:
> Hi All
>
> With any networked VFP application sharing a DBC the SMB performance of the 
> server hosting the DBC is very important?
>
> Assuming your answer to the above question is Yes or Of Course, then when you 
> have one server that seems to perform well and one that doesn't it would be 
> useful to easily compare the setup of the two.
>
> Is anyone aware of any utilities that make the configuration and tweaking of 
> SMB easy or at least allow you to compare to setups?
>
> Of course, if your answer to the first question isn't yes I would also be 
> interested in your thoughts.
>
> I know there is a lot more that comes into the performance of an application 
> other than the setup of the server, i.e the spec of the client, the os of the 
> client, other software such as anti virus, network infrastructure etc etc.
>
> Where I am going with this...
>
> We have lots of sites where an application works 

SMB

[Chris Davis]

Hi All

With any networked VFP application sharing a DBC the SMB performance of the 
server hosting the DBC is very important?

Assuming your answer to the above question is Yes or Of Course, then when you 
have one server that seems to perform well and one that doesn't it would be 
useful to easily compare the setup of the two.

Is anyone aware of any utilities that make the configuration and tweaking of 
SMB easy or at least allow you to compare to setups?

Of course, if your answer to the first question isn't yes I would also be 
interested in your thoughts.

I know there is a lot more that comes into the performance of an application 
other than the setup of the server, i.e the spec of the client, the os of the 
client, other software such as anti virus, network infrastructure etc etc.

Where I am going with this...

We have lots of sites where an application works well and one site where it 
doesn't, and without having to spend hours and hours investigating all the 
various settings and registry entries,  I just want to start with the servers 
and make a comparison to see if there are any obvious differences.

Thanks

Chris.






--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp265mb16682dabf52f961de20a2a128f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Someone was asking about SFTP client libraries recently.

[Chris Davis]

Thanks Alan

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Friday, 23 August 2019 09:13
To: profoxt...@leafe.com
Subject: Someone was asking about SFTP client libraries recently.

It appears that the very popular free WinSCP client has a .NET Assembly that 
wraps its scripting interface, and that .NET Assembly is also COM visible so 
you could presumably use it from VFP.

https://winscp.net/eng/docs/library_install


-- 
 Alan Bourke
 alanpbourke (at) fastmail (dot) fm



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp265mb1668912c190334bc68d7b9e18f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Microsoft Teams

[Chris Davis]

If you have Office365 and had Skype for Business installed then Microsoft Teams 
is it's replacement.

-Original Message-
From: ProfoxTech  On Behalf Of data...@adam.com.au
Sent: Wednesday, 21 August 2019 04:35
To: profoxt...@leafe.com
Subject: RE: [NF] Microsoft Teams

Me either. But it also STARTS when I reboot. I don’t even know what it is. I 
don’t do software development anymore.  I write/edit/proofread/publish books 
now. Less stressing and less profitable☹

Still love to read this list.

-Original Message-
From: ProFox  On Behalf Of MB Software Solutions, LLC
Sent: Wednesday, 21 August 2019 12:36 PM
To: profox@leafe.com
Subject: [NF] Microsoft Teams

Well that's interesting.  On reboot after the latest update, I now have an icon 
on my desktop that says Microsoft Teams.  That seems sneaky on M$'s part.  I 
don't recall ever expressly installing any software from them called that.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives This message: 
https://leafe.com/archives/byMID/000d01d557d1$5e56dcf0$1b0496d0$@adam.com.au
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/000d01d557d1$5e56dcf0$1b0496d0$@adam.com.au
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cwlp265mb1668208a37dc22d0805a9a5c8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SFTP

[Chris Davis]

Thanks Ted, again I am looking for ease of deployment.

-Original Message-
From: ProfoxTech  On Behalf Of Ted Roche
Sent: Friday, 02 August 2019 14:04
To: profoxt...@leafe.com
Subject: Re: SFTP

Well if you just want to use raw scp and sftp, you can always use PuTTY and 
script it:

https://www.chiark.greenend.org.uk/~sgtatham/putty/

In the past, I have set up a couple of clients with overnight routines that 
process data and upload results using PuTTY.



On Fri, Aug 2, 2019 at 8:53 AM Ed Leafe  wrote:

> On Aug 2, 2019, at 4:25 AM, Chris Davis  wrote:
> >
> > Before I make a purchase of either Chilkat or West Wind Internet &
> Client Tools which are both around the same price.
> >
> > At this moment its simply to get a SFTP function but both of these 
> > come
> with lots of other stuff.
>
> Such a shame. SFTP is built into Linux and MacOS, and you can use the 
> pysftp (https://pysftp.readthedocs.io/en/release_0.2.9/) module to use 
> SFTP directly in Python, even in Windows!
>
>
> -- Ed Leafe
>
>
>
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lnxp265mb1675e448bbd1f77eb9c55a3d8f...@lnxp265mb1675.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SFTP

[Chris Davis]

Thanks ed I will check it out, but I fear ease of deployment might be the 
compromise ?

-Original Message-
From: ProfoxTech  On Behalf Of Ed Leafe
Sent: Friday, 02 August 2019 13:53
To: profoxt...@leafe.com
Subject: Re: SFTP

On Aug 2, 2019, at 4:25 AM, Chris Davis  wrote:
> 
> Before I make a purchase of either Chilkat or West Wind Internet & Client 
> Tools which are both around the same price.
> 
> At this moment its simply to get a SFTP function but both of these come with 
> lots of other stuff.

Such a shame. SFTP is built into Linux and MacOS, and you can use the pysftp 
(https://pysftp.readthedocs.io/en/release_0.2.9/) module to use SFTP directly 
in Python, even in Windows!


-- Ed Leafe






[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lnxp265mb167548beac902678452033598f...@lnxp265mb1675.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SFTP

[Chris Davis]

Before I make a purchase of either Chilkat or West Wind Internet & Client Tools 
which are both around the same price.

At this moment its simply to get a SFTP function but both of these come with 
lots of other stuff.

Does anyone else pay for either of these and have any recommendations of one 
over the other?

Thanks

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lnxp265mb167570f35be30435224d6d358f...@lnxp265mb1675.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP Data / Node / MariaDB

[Chris Davis]

Thanks Tracy

Are the issues with using ODBC and CDX / FPT corruptions a known issue?  

Is that specifically the VFP ODBC drive or OLEDB as well?

Thanks

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Thursday, 11 July 2019 16:28
To: profoxt...@leafe.com
Subject: RE: VFP Data / Node / MariaDB

Hi Chris,

I haven't been down that path specifically. 
I have been down the path of connecting to VFP data with ODBC. 
We found that our old code base with Clipper/FoxBase style coding in many 
places that update our DBFs, and an ODBC updating the same DBFs caused CDX and 
FPT corruptions. 
If you are only reading though the ODBC, you should be fine.
If your VFP code uses buffering and maybe transactions, you should be fine.

We went with writing a VFP COM that uses buffering and transactions, and a C# 
service to host it for API access.

Hope that helps,
Tracy

P.S. Shameless plug 
http://swfox.net/SessionsSWFOX.aspx#Implementing_a_VFP_COM_Object_in_a_C_Project


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Thursday, July 11, 2019 11:15 AM
To: profoxt...@leafe.com
Subject: VFP Data / Node / MariaDB

I have been experimenting (more like messing around) with ways to create an API 
to VFP data.

The reason for this is to be able to leave our existing or other third party 
VFP apps doing what they do but provide the information within them to other 
parties via an API.

I quite easily created a simple REST API using Node/Express and a ODBC/OLEDB 
package, but I found the package providing the connection to the data source 
either lacking documentation or difficult to setup.

Having started my thoughts with stacks, like the MEAN stack I knew there was so 
much information and so many packages out there that make working with data 
sources like Mongo/MySQL etc so easy.

I then ventured into MariaDB and its CONNECT engine type allowing me to add 
data as a table into a MariaDB database from an external source, it’s not 
importing this data just linking to it.

Once added which was a simple as CREATE TABLE customers ENGINE=connect 
table_type=ODBC connection=’DSN=mydbc’ I could query away.

Going back to node I can now use packages which help me use MariaDB as a 
datasource 

Just wondered if any of you had been down this route, or similar?

Because some of the applications I need to do this with are not ours I don’t 
have the option of saying why are we still using VFP data instead of a backend 
like Mysql or SQL Server in the first place.

TIA

Chris.
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives This message: 
https://leafe.com/archives/byMID/001301d537fd$40ab9d60$c202d820$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/001301d537fd$40ab9d60$c202d820$@powerchurch.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo2p265mb1679c8576db23f6ac9e112198f...@lo2p265mb1679.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

VFP Data / Node / MariaDB

[Chris Davis]

I have been experimenting (more like messing around) with ways to create an API 
to VFP data.

The reason for this is to be able to leave our existing or other third party 
VFP apps doing what they do but provide the information within them to other 
parties via an API.

I quite easily created a simple REST API using Node/Express and a ODBC/OLEDB 
package, but I found the package providing the connection to the data source 
either lacking documentation or difficult to setup.

Having started my thoughts with stacks, like the MEAN stack I knew there was so 
much information and so many packages out there that make working with data 
sources like Mongo/MySQL etc so easy.

I then ventured into MariaDB and its CONNECT engine type allowing me to add 
data as a table into a MariaDB database from an external source, it’s not 
importing this data just linking to it.

Once added which was a simple as CREATE TABLE customers ENGINE=connect 
table_type=ODBC connection=’DSN=mydbc’ I could query away.

Going back to node I can now use packages which help me use MariaDB as a 
datasource 

Just wondered if any of you had been down this route, or similar?

Because some of the applications I need to do this with are not ours I don’t 
have the option of saying why are we still using VFP data instead of a backend 
like Mysql or SQL Server in the first place.

TIA

Chris.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/lo2p265mb167922e6b81d13ce2f3548188f...@lo2p265mb1679.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: File Access Issues

[Chris Davis]

Following on from this, we have discovered this setup is using a shared cluster 
disc?  Could this be having any effect?  We have moved the data from the VM's 
onto an existing physical server (the doman controller) and all the issues have 
gone away.

-Original Message-
From: ProfoxTech  On Behalf Of Chris Davis
Sent: Thursday, 21 March 2019 16:26
To: profoxt...@leafe.com
Subject: RE: File Access Issues

I am sure the Anti Virus which had been ruled out as the cause (Sophos) has 
been reinstalled and disables Defender, but it's a good heads up and I will 
double check.

Thanks Fred

Regards

Chris.



-Original Message-
From: ProfoxTech  On Behalf Of Fred Taylor
Sent: Thursday, 21 March 2019 16:05
To: profoxt...@leafe.com
Subject: Re: File Access Issues

We recently upgraded to a new server box from running Windows Server 2008
(3 VM's) to Windows Server 2019 (running 6 VM's).  Most of the VM's have access 
to FoxPro data and function without incident.

Have you made sure that Windows Defender has also been set to ignore 
.DBF/.CDX/.FPT files on both the servers and the workstations?

Fred


On Thu, Mar 21, 2019 at 2:42 AM Chris Davis  wrote:

> We are seeing increasing problems with VFP applications (some of our 
> own and other commercial ones) as our customers have their servers upgraded.
>
> A lot of these servers are now virtual machines hosted on a physical 
> machine.  In some instances these are remote desktop servers which 
> access the VFP data from a different server.
>
> The file access issues seem to be random, in some instances the 
> indexes get corrupted and need to be repaired.
>
> Anti Virus has been ruled out by uninstalling it, but the problems persist.
>
> Any ideas? Any issues with VFP data and VM's?
>
> Regards
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16688eb3288fb6f03cf235238f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Error on Win10 machine invoking IE in code from VFP9SP2 app

[Chris Davis]

Is it possible the 32bit version of internet explorer is either missing or 
disabled in some way?

-Original Message-
From: ProfoxTech  On Behalf Of MB Software 
Solutions, LLC
Sent: Friday, 26 April 2019 16:16
To: profoxt...@leafe.com
Subject: Error on Win10 machine invoking IE in code from VFP9SP2 app

VFP9SP2 app running on Win10 Pro, build 1809.

See https://www.screencast.com/t/pFvzYl2H7ZX6. These users are all running 
Windows 10, and my app works on all machines but 1.  I tracked it down (via 
vRunFox!) to the line that creates an instance of Internet
Explorer:  oIE = createobject("internetexplorer.application")

This code has been running fine for nearly 15 years.  Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51aea5e1-fbbe-5335-76b2-c4e335310...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/51aea5e1-fbbe-5335-76b2-c4e335310...@mbsoftwaresolutions.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668fc186d7f8d249ec382ac8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Landscape PDFs using XFRX

[Chris Davis]

>From XFRX FAQ

5.1. The paper size is wrong, landscape reports are generated as portrait.
Make sure you don't delete all information from the EXPR field of the first 
record of the page. XFRX doesn't use printer settings stored in the FRX file 
and uses PAPERSIZE and ORIENTATION values from the EXPR field of the first 
record. If they are not there, the default value is used, which can result in a 
wrong orientation or a wrong paper size.



-Original Message-
From: ProfoxTech  On Behalf Of Joe Yoder
Sent: Tuesday, 23 April 2019 19:48
To: profoxt...@leafe.com
Subject: Re: Landscape PDFs using XFRX

I reread what what I wrote and realize that The first sentence should have been 
"Using XFRX in VFP to convert  Reports to create PDF files" - sorry - Joe

On Tue, Apr 23, 2019 at 1:33 PM Joe Yoder  wrote:

> I have an older version of XFRX that I am converting to create PDF 
> files instead of printing reports directly. All reports are working 
> well except the one that requires Landscape output. Apparently XFRX 
> just ignores the printer orientation information in the Tag1 and Tag2 
> fields in the Report.frx file.
>
> Can someone share what is needed to change the output orientation of 
> the XFRX output files?
>
> Thanks in advance,
>
> Joe
>


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668050040f8e0eba608a7178f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Mobile Forms

[Chris Davis]

Thanks everyone for your replies, POD was just one example.

I will look into all the suggestions.

-Original Message-
From: ProfoxTech  On Behalf Of Johan Nel
Sent: Tuesday, 09 April 2019 16:09
To: profoxt...@leafe.com
Subject: Re: Mobile Forms

Chris,

Why redesign the wheel.  Have a look at:

https://www.supersignature.com/demo.aspx

At US$219 for an Enterprise license, I don't think you can go wrong... If you 
want it just on a mobile, cost free, you can download the details back at the 
office.

SuperSignature can be used as an online signature pad for your websites. 
Users can sign online easily! You can capture signatures from language of your 
choice Asp.net, Php, CF, JAVA. Works on major browsers both desktop and mobile.

Features    Trial     Professional     Enterprise Domains allowed   
  localhost     single unlimited Price               $0    $119$219


Johan Nel
George, South Africa
FOX member: Friends of XSharp
Website    : https://xsharp.info <https://xsharp.info/> VFP forum  : 
https://www.xsharp.info/forum/public-vfp
X# Runtime : https://github.com/X-Sharp/XSharpPublic

On 2019/04/08 16:32, Chris Davis wrote:

> Hi All
>
> We are looking at extending our application so we can gather some information 
> from mobiles.
>
> The easiest example is a signature for proof of delivery.
>
> We certainly don't want to start from scratch and are hoping to find a 
> solution which will allow us to feed some basic data across for the forms to 
> use, have barcode scanning and signature capture.
>
> And then send us the data back to process.
>
> We have found one solution which is almost what we want but not quite, just 
> wondered if anyone out there is doing a similar thing and can make any 
> recommendations.
>
> Googling it just shows how many solutions are out there.
>
> We are hoping to find one that will allow us to resell the soltution as our 
> own possibly with some branding to make it look like ours as well.
>
> Regards
>
> Chris.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb166800dc4b4c3ee55b9eec658f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Mobile Forms

[Chris Davis]

To give you a better idea of what we are currently lookling at, here is the 
link ...

https://www.pro-forms.co.uk/

Advantages so far, we can deliver data to the app via an existing cloud 
solution like Onedrive or Dropbox and back again.

Disadvantages, it does it how it wants to, so it can scan a barcode (great) but 
it can't then trigger other controls on the form to be populated with data with 
us pressing search on another lookup control making it feel a little clunky.

Another disadvantage it cant be rebranded.

Any solution would need to be Andriod/IOS.

-Original Message-
From: ProfoxTech  On Behalf Of Stephen Russell
Sent: Monday, 08 April 2019 16:11
To: profoxt...@leafe.com
Subject: Re: Mobile Forms

What device are you using?  I did something like this a few years back where we 
proposed a phone app for a museum.  You could scan barcodes as you walked along 
the displays and we would bring back the facts about the item, maybe older 
images where it came from, maybe a movie about it.  The museum didn't 
understand that as the holder of all the data they had to produce the content 
they wanted to present.  Too much work on their end is what it came down to.

We did it in android and followed their MVC application standards.  All the 
tools are free all it takes is time and advil as you learn what you goofed upon.




On Mon, Apr 8, 2019 at 9:32 AM Chris Davis  wrote:

> Hi All
>
> We are looking at extending our application so we can gather some 
> information from mobiles.
>
> The easiest example is a signature for proof of delivery.
>
> We certainly don't want to start from scratch and are hoping to find a 
> solution which will allow us to feed some basic data across for the 
> forms to use, have barcode scanning and signature capture.
>
> And then send us the data back to process.
>
> We have found one solution which is almost what we want but not quite, 
> just wondered if anyone out there is doing a similar thing and can 
> make any recommendations.
>
> Googling it just shows how many solutions are out there.
>
> We are hoping to find one that will allow us to resell the soltution 
> as our own possibly with some branding to make it look like ours as well.
>
> Regards
>
> Chris.
>
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb166890d83072cb2477a403dc8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Mobile Forms

[Chris Davis]

Hi All

We are looking at extending our application so we can gather some information 
from mobiles.

The easiest example is a signature for proof of delivery.

We certainly don't want to start from scratch and are hoping to find a solution 
which will allow us to feed some basic data across for the forms to use, have 
barcode scanning and signature capture.

And then send us the data back to process.

We have found one solution which is almost what we want but not quite, just 
wondered if anyone out there is doing a similar thing and can make any 
recommendations.

Googling it just shows how many solutions are out there.

We are hoping to find one that will allow us to resell the soltution as our own 
possibly with some branding to make it look like ours as well.

Regards

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb166838b9c3e9ccefb8abcf648f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: File Access Issues

[Chris Davis]

I am sure the Anti Virus which had been ruled out as the cause (Sophos) has 
been reinstalled and disables Defender, but it's a good heads up and I will 
double check.

Thanks Fred

Regards

Chris.



-Original Message-
From: ProfoxTech  On Behalf Of Fred Taylor
Sent: Thursday, 21 March 2019 16:05
To: profoxt...@leafe.com
Subject: Re: File Access Issues

We recently upgraded to a new server box from running Windows Server 2008
(3 VM's) to Windows Server 2019 (running 6 VM's).  Most of the VM's have access 
to FoxPro data and function without incident.

Have you made sure that Windows Defender has also been set to ignore 
.DBF/.CDX/.FPT files on both the servers and the workstations?

Fred


On Thu, Mar 21, 2019 at 2:42 AM Chris Davis  wrote:

> We are seeing increasing problems with VFP applications (some of our 
> own and other commercial ones) as our customers have their servers upgraded.
>
> A lot of these servers are now virtual machines hosted on a physical 
> machine.  In some instances these are remote desktop servers which 
> access the VFP data from a different server.
>
> The file access issues seem to be random, in some instances the 
> indexes get corrupted and need to be repaired.
>
> Anti Virus has been ruled out by uninstalling it, but the problems persist.
>
> Any ideas? Any issues with VFP data and VM's?
>
> Regards
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16687f4b61c539939d6f8c0e8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: File Access Issues

[Chris Davis]

Thanks Peter

The RDP client ?

> On 21 Mar 2019, at 10:28, Peter Cushing  wrote:
> 
>> On 21/03/2019 09:41, Chris Davis wrote:
>> We are seeing increasing problems with VFP applications (some of our own and 
>> other commercial ones) as our customers have their servers upgraded.
>> 
>> A lot of these servers are now virtual machines hosted on a physical 
>> machine.  In some instances these are remote desktop servers which access 
>> the VFP data from a different server.
>> 
>> The file access issues seem to be random, in some instances the indexes get 
>> corrupted and need to be repaired.
>> 
>> Anti Virus has been ruled out by uninstalling it, but the problems persist.
>> 
>> Any ideas? Any issues with VFP data and VM's?
>> 
> We have been running our data on VMs for a good few years now with
> mostly no problems.  A couple of years ago we started getting index
> corruptions and found out it was only when a remote user did an
> operation.  Updated the RDP software and the problems went away.
> 
> Peter
> 
> This communication is intended for the person or organisation to whom it is 
> addressed. The contents are confidential and may be protected in law. 
> Unauthorised use, copying or disclosure of any of it may be unlawful. If you 
> have received this message in error, please notify us immediately by 
> telephone or email. 
> 
> www.whisperingsmith.com
> 
> Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. 
> Tel:0161 831 3700 
> Fax:0161 831 3715 
> 
> London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299 7960
> 
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/f11532d0-5d48-46bf-b3fd-0a8840920...@actongate.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

File Access Issues

[Chris Davis]

We are seeing increasing problems with VFP applications (some of our own and 
other commercial ones) as our customers have their servers upgraded.

A lot of these servers are now virtual machines hosted on a physical machine.  
In some instances these are remote desktop servers which access the VFP data 
from a different server.

The file access issues seem to be random, in some instances the indexes get 
corrupted and need to be repaired.

Anti Virus has been ruled out by uninstalling it, but the problems persist.

Any ideas? Any issues with VFP data and VM's?

Regards

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16685a44a9cd7d3b1c147ad78f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SFTP

[Chris Davis]

Thanks Mike & Dave

No worries, I am exploring both Chilkat and West Wind and will no doubt opt for 
one of those solutions.

The only other thing I have considered is leaving the FTP aspect to an FTP 
Client and creating some kind of script that something like FileZilla could 
execute.

Regards

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Dave Crozier
Sent: Wednesday, 20 February 2019 08:19
To: profoxt...@leafe.com
Subject: RE: SFTP

I haven't had time to implement SFTP as of yet but it is on my list of projects 
in the not too distant future.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿



Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us: 
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.
  
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any attachments received as Flexipol 
Packaging Ltd will not in any event accept any liability whatsoever once an 
e-mail and/or any attachment is received.
  
 It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

-
​​
​Terms & Conditions:
 Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. 
("The Company") has received in cash or cleared funds payment in full of the 
price of the goods and all other goods agreed to be sold by the seller to the 
buyer for which payment is then due. Until such time as the property in the 
goods passes to the buyer, the buyer shall hold the goods as the seller's 
fiduciary agent and bailee and keep the goods separate from those of the buyer 
and third parties and properly stored protected and insured and identified as 
the seller's property but shall be entitled to resell or use the goods in the 
ordinary course of its business. Until such time as the property in the goods 
passes to the buyer the seller shall be entitled at any time -Original 
Message-
From: ProFox  On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: 19 February 2019 18:20
To: ProFox Email List 
Subject: Re: SFTP

On 2019-02-19 13:18, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> On 2019-02-19 08:45, Chris Davis wrote:
>> Yes please!
> 
> 
> https://leafe.com/dls/vfp
> 
> It's the top of the list from ProFox's very own Dave Crozier.  ;-)


Oh Chris...I'm sorryre-reading Dave's comments in that listing says that 
SFTP is not yet supported.  Sorry!

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb0852f2836cee723e032e6d2ffb...@cwlp265mb0852.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/cwlp265mb0852f2836cee723e032e6d2ffb...@cwlp265mb0852.gbrp265.prod.outlook.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16681e85259883c01a1f6a548f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the mes

RE: SFTP

[Chris Davis]

Yes please!

-Original Message-
From: ProfoxTech  On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Monday, 18 February 2019 20:48
To: profoxt...@leafe.com
Subject: Re: SFTP

On 2019-02-08 06:09, Chris Davis wrote:
> Me again, sorry!
> 
> I have been using vfpconnection for sometime now, very useful!
> 
> However I have now got a ftp server that I wont connect to.
> 
> The url I have been given starts SFTP, vfpconnection only seems to 
> support FTPS.
> 
> When I use FTPS I just send up with a SSL error when tracing it 
> through.
> 
> Should I be looking for another solution that maybe supports newer 
> protocols or am I missing something?
> 
> Thanks
> 
> Chris.


Hi Chris,

I used a simple solution from Dave here.  Let me know if you still need 
something.

--Mike

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16688e310f0384df4da949888f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SFTP

[Chris Davis]

Thanks both I have given the trial version of west wind a whirl and as expected 
it just works!



-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Friday, 08 February 2019 12:24
To: profoxt...@leafe.com
Subject: Re: SFTP

I use Chilkat and can recommend it.

On February 8, 2019 6:43:53 AM EST, Alan Bourke  wrote:
>I think you will need to look at West Wind's tools, or Chilkat.
>
>Or write a COM DLL in C# and leverage that.
>
>-- 
>  Alan Bourke
>  alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668f5eda99bb2b3c7943ee28f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SFTP

[Chris Davis]

Me again, sorry!

I have been using vfpconnection for sometime now, very useful!

However I have now got a ftp server that I wont connect to.

The url I have been given starts SFTP, vfpconnection only seems to support FTPS.

When I use FTPS I just send up with a SSL error when tracing it through.

Should I be looking for another solution that maybe supports newer protocols or 
am I missing something?

Thanks

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668158a6d213eb4c49cc38d8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Pipe Delimited

[Chris Davis]

Worked around it for now like so ...

*** to give me the headers without any lines
COPY TO customerheaders.csv FOR 1=0 TYPE CSV 

*** to give me the lines pipe limited with no quotes or commas
COPY TO customerlines.csv TYPE delimited WITH "" WITH CHARACTER "|" 

***to merge the two files together and convert the commas in the 
headers to pipes

STRTOFILE(STRTRAN(FILETOSTR("customerheaders.csv"),",","|")+FILETOSTR("customerlines.csv"),"customer.csv")

Seems to work ok.

-Original Message-
From: ProfoxTech  On Behalf Of Kurt at VR-FX
Sent: Friday, 08 February 2019 02:35
To: profoxt...@leafe.com
Subject: Re: Pipe Delimited

AFAIK - I don't think so. I remembered needing to do the same thing a number of 
years ago - and I think I had to kind of add the headers by hand. If I'm not 
mistaken...

And - by hand - I mean doing low-level file handling - or some such.

-K-

On 2/7/2019 6:13 PM, Chris Davis wrote:
> 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
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668427d999f9e61b9f5290b8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Pipe Delimited

[Chris Davis]

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
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16684d301cdbb263e9a3a08a8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP application issues on new server

[Chris Davis]

I will double check, but I believe it is a dedicated physical box in a data 
centre, which then has the two virtual machines running on it.

It's definitely not a file share across the internet as when it works its fine

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Wednesday, 06 February 2019 08:28
To: profoxt...@leafe.com
Subject: Re: VFP application issues on new server


When you say the RDS and app server are in the cloud, to me this would be 
ringing alarm bells unless both server instances  are on same physical host all 
the time. Is this Azure or something? Otherwise you are essentially running a 
file share across the internet.


-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16684b271474e203dc8dd9858f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP application issues on new server

[Chris Davis]

Hi both thanks for the replies,
Yes we use a loader program that copies the .exe and a few other files into the 
%appdata% folder of the logged on user.

The .exe then opens the .dbc which is located on the other virtual machine.

If we move the data from the file server to the rds server so all the clients 
are using it locally ... i.e.

Instead of \\fileserver\ourshare

It points to 

C:\shareddata

It works without issue, move the data back to the share and we get the random 
errors.

The app is proven to work over many years, the only thing that’s changed is the 
environment, server 2016 virtual machines on one physical host and the clients 
connecting in from the rds box.

We have the same app elsewhere being used from a rds box as the client without 
issue.

If anything this is the highest spec server its ever lived on, ssd drives on 
the physical host etc etc.



-Original Message-
From: ProfoxTech  On Behalf Of Dave Crozier
Sent: Tuesday, 05 February 2019 17:28
To: profoxt...@leafe.com
Subject: RE: VFP application issues on new server

As Tracy says, write or get a loader program that loads a copy of the 
executable to the host machine. That way the .exe will be co-resident all the 
time.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿



Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us: 
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.
  
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any attachments received as Flexipol 
Packaging Ltd will not in any event accept any liability whatsoever once an 
e-mail and/or any attachment is received.
  
 It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

-
​​
​Terms & Conditions:
 Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. 
("The Company") has received in cash or cleared funds payment in full of the 
price of the goods and all other goods agreed to be sold by the seller to the 
buyer for which payment is then due. Until such time as the property in the 
goods passes to the buyer, the buyer shall hold the goods as the seller's 
fiduciary agent and bailee and keep the goods separate from those of the buyer 
and third parties and properly stored protected and insured and identified as 
the seller's property but shall be entitled to resell or use the goods in the 
ordinary course of its business. Until such time as the property in the goods 
passes to the buyer the seller shall be entitled at any time -Original 
Message-
From: ProFox  On Behalf Of Chris Davis
Sent: 05 February 2019 09:26
To: profox@leafe.com
Subject: VFP application issues on new server

Hi All

We have an app, which has lived on windows PC's and a windows server (on 
premisis) for years which has worked without issue.

Nothing fancy going on!

It has now been moved onto two virtual machines, both on the same host in the 
cloud.

One machine is acting as the file server and one as a RDS box.

All the users are connecting in using a remote desktop.

The client side of the app is designed in such a way that locally on the client 
it uses dedicated files in %appdata%.

The app works but the user are experiencing regular 2005 and 1104 error 
messages.

Simply waiting a period of time (usually over a minute) whatever the issue is 
clears and the app continues.

Any idea what it is about this environment that causes this issue?

We have ruled out the anti virus solution used by having it uninstalled, but 
the problems persist.

TIA

Chris.



--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/ma

RE: VFP application issues on new server

[Chris Davis]

As far as I'm aware the backups will be being taken as an image of the virtual 
machine but I will check.

I don't think it's indexing related as if we move the data to the RDS box (i.e. 
the data is on the same box as the client) it works fine, so whatever the issue 
is seems to be network related but the network is running at full tilt, and 
obviously there is no physical network between the two machines as they are 
both of the same physical host

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Tuesday, 05 February 2019 10:29
To: profoxt...@leafe.com
Subject: Re: VFP application issues on new server

What are the operating systems in question ?

There was an issue recently with an update to Windows 10 1803 causing weird DBF 
problems due to SMB caching, which I believe are fixed in Windows 10 1809.

Another thing it could be is the Windows Server indexing service which may be 
on and indexing everything depending on what flavour of Windows Server it is. 
It could also be online backup software that monitors locations for cloud 
backup.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16682459649e0a1916c980458f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP application issues on new server

[Chris Davis]

It's all server 2016

-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Tuesday, 05 February 2019 10:29
To: profoxt...@leafe.com
Subject: Re: VFP application issues on new server

What are the operating systems in question ?

There was an issue recently with an update to Windows 10 1803 causing weird DBF 
problems due to SMB caching, which I believe are fixed in Windows 10 1809.

Another thing it could be is the Windows Server indexing service which may be 
on and indexing everything depending on what flavour of Windows Server it is. 
It could also be online backup software that monitors locations for cloud 
backup.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb166881b04e3c89b08c189e208f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

VFP application issues on new server

[Chris Davis]

Hi All

We have an app, which has lived on windows PC's and a windows server (on 
premisis) for years which has worked without issue.

Nothing fancy going on!

It has now been moved onto two virtual machines, both on the same host in the 
cloud.

One machine is acting as the file server and one as a RDS box.

All the users are connecting in using a remote desktop.

The client side of the app is designed in such a way that locally on the client 
it uses dedicated files in %appdata%.

The app works but the user are experiencing regular 2005 and 1104 error 
messages.

Simply waiting a period of time (usually over a minute) whatever the issue is 
clears and the app continues.

Any idea what it is about this environment that causes this issue?

We have ruled out the anti virus solution used by having it uninstalled, but 
the problems persist.

TIA

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668eb4aaab7a3e27491ef1d8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Google API for Geocoding ... Again

[Chris Davis]

Not sure if this will help as only glancing at these emails but in vfp I do 
visit the following URL

http://maps.googleapis.com/maps/api/geocode/json?address=##ADDRESS##

using either vfpconnection or the Microsoft html thing ( I can be more specific 
if required)

the ##ADDRESS## is replaced with a postcode for instance

http://maps.googleapis.com/maps/api/geocode/json?address=WS98ER

You used to be able to do this all day long (there was a throttle that kicked 
in at some point based on your IP address but the limit was something like 5000 
calls a day)

These days I believe you need an API key which you would need to pass in with 
the query to get your JSON back with the lat and lng in.

I believe you need a paid for account now but you get $200 dollars usage credit 
each month for the API which I think for modest usage is plenty.




-Original Message-
From: ProfoxTech  On Behalf Of M Jarvis
Sent: Monday, 28 January 2019 19:27
To: profoxt...@leafe.com
Subject: Re: Google API for Geocoding ... Again

On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail  wrote:

> Ok - yes, I'm dredging up a VERY Old thread here!
>
> So, here's the deal. A woman I worked with for this Jewish Holiday 
> Pop-up shop here in SF this past late Nov./early Dec. - she wants me 
> to do a kind of Admin task for her. She's going to give me a 
> spreadsheet of locations - and wants me to use Google Maps to find the 
> distances traveled. She then has to note the distances back into the 
> spreadsheet.
> It may have to do with reimbursement based upon mileage.
>


I did something like this back in 2008 or so and I'm pretty darn sure I posted 
it here but I'll be darned if I can find it. Maybe your Search-Fu is better 
than mine so you might be able to dig it up.

I used MS Access to do the work but it did the exact thing you are trying to do.


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16684dcf2d3416e0d3d66cf78f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Web App without moving to far away from VFP

[Chris Davis]

Prior to me asking this question we had been thinking about creating a MEAN 
stack application, but replacing the MongoDB element of that with some node 
addon to work with our existing VFP data via ODBC.

So I guess creating a VFP/EAN stack  Not sure how tall these stacks can be 
before they topple over.

I'm not sure how good the existing ODBC addons are, I've had results but mixed.

Our reason behind all of this is it would allow our existing established 
desktop applications to remain, and any work we do of this nature to be an 
extension.

Thanks everyone for the discussion around this its all good food for thought.

Chris.

-Original Message-
From: ProfoxTech  On Behalf Of Stephen Russell
Sent: Monday, 26 November 2018 17:59
To: profoxt...@leafe.com
Subject: Re: Web App without moving to far away from VFP

Nobody brought up the reality that fox technique is no longer in fashion in the 
digital world.

I suggest learning what the rest of the world embraces today.  There are so 
many combinations to choose from.

On Mon, Nov 26, 2018 at 11:02 AM Frank Cazabon 
wrote:

> You would think twice or you would *not *think twice?
>
> Frank.
>
> Frank Cazabon
>
> On 26/11/2018 11:49 AM, Stephen Russell wrote:
> > I would think twice about learning javascript, html, css, a js 
> > framework and have a good chance of having positive revenue streams 
> > for the next 10 years.
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJidMYKyb3B_UhneOc8qG+7DKWObXGpvx9Q6Rc2kdk0=4b2...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Report [OT] Abuse: 
http://leafe.com/reportAbuse/CAJidMYKyb3B_UhneOc8qG+7DKWObXGpvx9Q6Rc2kdk0=4b2...@mail.gmail.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/lo2p265mb16797721579a90281452e97a8f...@lo2p265mb1679.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Web App without moving to far away from VFP

[Chris Davis]

So would it be accurate(ish) to say

I would use ActiveVFP/West Wind Web Connection if I wanted to use VFP to create 
my Web App

And

I would use FoxInTheCloud if I wanted to use the Web to access my VFP App

?



-Original Message-
From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Monday, 26 November 2018 08:33
To: profoxt...@leafe.com
Subject: Re: Web App without moving to far away from VFP

FoxInCloud

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/lo2p265mb1679317cdabd2b97d8a67ef78f...@lo2p265mb1679.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Web App without moving to far away from VFP

[Chris Davis]

Thanks both, I will check out FoxInCloud this evening.  I think if we was to 
get into what it sounds like FoxWeb does we would go the whole hog and use node 
and learn some javascript.

-Original Message-
From: ProfoxTech  On Behalf Of Thierry Nivelet
Sent: Friday, 23 November 2018 13:15
To: profoxt...@leafe.com
Subject: Re: Web App without moving to far away from VFP

Hi Chris,

FoxWeb: you need to write HTML/CSS/JS, interaction with server and server-side 
processing

FoxInCloud: you just adapt your extent code ro run as a web application and let 
FoxIncloud do the above mentioned, tedious work for you. 
FoxInCloud Adaptation Assistant helps your adaptation process: 
http://foxincloud.com/download.php

Thierry Nivelet
http://foxincloud.com/

Le 23/11/2018 à 13:49, Malcolm Greene a écrit :

> What seems like 100 years ago I built a bunch of cool web prototypes  with 
> Foxweb. This is a VFP centric product. I was impressed.
>
> The company still appears to be in business and has a free evaluation version.
>
> FoxWeb
> http://www.foxweb.com/
>
> This list's very own Thierry Nivelet's company FoxInCloud appears to have 
> some cool tech as well.
> http://foxincloud.com/
>
> Good luck,
> Malcolm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/6caccf36-f8a1-cb55-9f60-516593351...@foxincloud.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: 
http://leafe.com/reportAbuse/6caccf36-f8a1-cb55-9f60-516593351...@foxincloud.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb166876535d8340c9d9aeb7d68f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Web App without moving to far away from VFP

[Chris Davis]

Hi All

Just wondered about your recommendations / experience with any of these VFP 
based server side packages that enable us to leverage our exisiting knowledge 
and code to build simple web apps.

Basically we have a very simple app which we would like to create a browser 
based version of as an alternative to trying to run it as a Remote App in 
Terminal Services.

We like the idea of using devices in some sort of browser-based kiosk mode.

TIA.

Chris.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668fa5d34cc456b5122f32d8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Terminal Server 2008

[Chris Davis]

Thanks Alan I will check all these out as the server isn’t managed by us 

> On 8 Nov 2018, at 12:42, Alan Bourke  wrote:
> 
> Check:
> AV exclusions, no need for realtime scanners to be scanning DBF files.
> Online backup software (Mozypro etc) not a good idea for backing up 
> file-based databases.
> Windows Indexing Service shouldn't be indexing your application date 
> (particularly a problem with Small Business Server)
> 
> 
> -- 
>  Alan Bourke
>  alanpbourke (at) fastmail (dot) fm
> 
> 
> ___
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
> OT-free version of this list: 
> http://mail.leafe.com/mailman/listinfo/profoxtech
> Searchable Archive: http://leafe.com/archives/search/profox
> This message: 
> http://leafe.com/archives/byMID/profox/1541680929.3759286.1569984688.1df54...@webmail.messagingengine.com
> ** All postings, unless explicitly stated otherwise, are the opinions of the 
> author, and do not constitute legal or medical advice. This statement is 
> added to the messages for those lawyers who are too stupid to see the obvious.
> 
> Report [OT] Abuse: 
> http://leafe.com/reportAbuse/1541680929.3759286.1569984688.1df54...@webmail.messagingengine.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/c9e13d15-65ba-4340-a4d8-e5418b5c6...@actongate.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Terminal Server 2008

[Chris Davis]

Hi All

Not sure this issue is speciic to terminal server 2008, but we have an issue 
where a file gets locked so that foxpro cant access it, yet if you look in open 
files on both the terminal server and the file server the file isn't open.  The 
only way to remove this lock is to either log every user connected to the 
terminal server off or reboot the terminal server.

Anyone accessing the same file directly on the file server can access it 
without issue, i.e. the file isn't really locked the terminal server just 
thinks it is.

Any ideas?

Thanks

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668452ded92ed313c0ace158f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SPT and Remote Views

[Chris Davis]

Thanks for the all the responses, I contacted filemaker support and basically 
they say the problem isn't theirs its because the implementation of ODBC in 
foxpro is v1? And the only support v2.

They proved this by using the same DSN I had created to use with foxpro and 
querying it via excel and msquery and all the data appears without issue.

I have decided not to pursue using fox to get the data out.

-Original Message-
From: ProfoxTech  On Behalf Of Stephen Russell
Sent: Thursday, 08 November 2018 02:39
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views

You could add a column for the length of varchar(max) content and sort on that 
descending.  Then you will know if the width of Fox cursor is actually getting 
all of the data.

On Wed, Nov 7, 2018 at 2:25 PM Kevin J Cully  wrote:

> I was looking for an old blog post but I couldn't find it.  At times 
> there may be a problem with the ODBC connection and using CAST(), 
> especially with VARCHAR(max).  If you ever experience problem using 
> CAST() and accessing a field of type VARCHAR(max), take a look at 
> CONVERT().  This will work with VFP ( and Xojo! ) to access these fields 
> where CAST() fails.
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. 
> Tarver
> Sent: Wednesday, November 07, 2018 3:14 PM
> To: profox@leafe.com
> Subject: RE: SPT and Remote Views
>
> +1
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Charlie-gm
> Sent: Tuesday, November 06, 2018 2:46 PM
> To: profoxt...@leafe.com
> Subject: Re: SPT and Remote Views
>
>
> Just a quick FYI.
>
> If using SQL Pass-through, don't forget you have the "CAST()" syntax 
> available (you can convert dates to strings, set a size of the 
> character length, etc). I've used it frequently to ensure a "proper" 
> (expected) VFP data type output result.
>
> -Charlie
>
> On 11/6/2018 12:08 PM, Chris Davis wrote:
> > Not really, I can issue the query once and I get C(10) and again and 
> > I get
> M(10) with the whole value in it.
> >
> > It seems to be an issue with the Filemaker ODBC driver, they 
> > suggested VFP
> does ODBC v1? And their driver only supports ODBC v2?
> >
> > Whatever the issue is, Remote Views seem to get around it.  I would 
> > just
> like to be able to get around it using SPT.
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of Ted 
> > Roche
> > Sent: Tuesday, 06 November 2018 16:53
> > To: profoxt...@leafe.com
> > Subject: Re: SPT and Remote Views
> >
> > Remote views, as you've indicated, let you specify the target 
> > structure of
> the query.
> >
> > When you execute direct SPT Fox attempts to get the first record 
> > matching
> the query, and uses the structure of that result as the (fixed column) 
> structure of the result set. So, if you have a varying-length string
> > (varchar) and the first result is 3 characters, VFP might create a
> > C(3)
> field, which could truncate everything else. Does that describe what 
> you are seeing?
> >
> >
> >
> > On Tue, Nov 6, 2018 at 10:54 AM Chris Davis 
> wrote:
> >
> >> Hi All
> >>
> >> What extra happens when using Remove Views over SPT?
> >>
> >> Using the same ODBC conneciton to a Filemaker database if I do 
> >> "select
> >> * from " I get mixed results for the text strings.
> >>
> >> If I perform the same query via a remote view I get the same mixed
> result.
> >>
> >> But if I go one step further with the Remote View and specifc 
> >> properties of the fields it manages to pull complete information 
> >> out of
> filemaker.
> >>
> >> So what extra is Remote View managing to ask of the Filemaker ODBC 
> >> driver to make it behave?
> >>
> >> Any ideas?
> >>
> >> Regards
> >>
> >> Chris.
> >>
> >>
> >>
> >> --- StripMime Report -- processed MIME parts --- multipart/alternative
> >>text/plain (text body -- kept)
> >>text/html
> >> ---
> >>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb16688eb37a65bef884a100a68f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SPT and Remote Views

[Chris Davis]

Not really, I can issue the query once and I get C(10) and again and I get 
M(10) with the whole value in it.

It seems to be an issue with the Filemaker ODBC driver, they suggested VFP does 
ODBC v1? And their driver only supports ODBC v2?

Whatever the issue is, Remote Views seem to get around it.  I would just like 
to be able to get around it using SPT.

-Original Message-
From: ProfoxTech  On Behalf Of Ted Roche
Sent: Tuesday, 06 November 2018 16:53
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views

Remote views, as you've indicated, let you specify the target structure of the 
query.

When you execute direct SPT Fox attempts to get the first record matching the 
query, and uses the structure of that result as the (fixed column) structure of 
the result set. So, if you have a varying-length string
(varchar) and the first result is 3 characters, VFP might create a C(3) field, 
which could truncate everything else. Does that describe what you are seeing?



On Tue, Nov 6, 2018 at 10:54 AM Chris Davis  wrote:

> Hi All
>
> What extra happens when using Remove Views over SPT?
>
> Using the same ODBC conneciton to a Filemaker database if I do "select 
> * from " I get mixed results for the text strings.
>
> If I perform the same query via a remote view I get the same mixed result.
>
> But if I go one step further with the Remote View and specifc 
> properties of the fields it manages to pull complete information out of 
> filemaker.
>
> So what extra is Remote View managing to ask of the Filemaker ODBC 
> driver to make it behave?
>
> Any ideas?
>
> Regards
>
> Chris.
>
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668cddbdf3f923280b02ed68f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SPT and Remote Views

[Chris Davis]

Hi All

What extra happens when using Remove Views over SPT?

Using the same ODBC conneciton to a Filemaker database if I do "select * from 
" I get mixed results for the text strings.

If I perform the same query via a remote view I get the same mixed result.

But if I go one step further with the Remote View and specifc properties of the 
fields it manages to pull complete information out of filemaker.

So what extra is Remote View managing to ask of the Filemaker ODBC driver to 
make it behave?

Any ideas?

Regards

Chris.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668bc13f74017fc98e737208f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

OAuth from VFP

[Chris Davis]

Hi All

I am still pluging away at this and making steady progress.

I have now got my access token and secret and can successfully make queries 
against the API endpoint using Postman.

https://www.mywebsite.com/api/rest/products?page=1

I can make the same request from VFP and if I sign the request using PLAINTEXT 
then it works no problem.

If I attempt to sign it using HMAC-SHA1 then I get the following error ...

{"messages":{"error":[{"code":401,"message":"oauth_problem=signature_invalid"}]}}

I have used the same VFP code borrowed from the OAuth project on VFPX github to 
get as far as the access token so I am happy that the signing code works so I 
think it must be something I am either including or excluding from the string 
that gets signed which is causing the issue.

Can anyone spot anything obvious ...

GET%3A%2F%2Fwww.mywebsite.com%2Fapi%2Frest%2Fproducts_consumer_key%3Dd5740bb1a40426a34917b58153b5d060_nonce%3D49878452BA6F410EA566452C71B9F4CD_signature_method%3DHMAC-SHA1_timestamp%3D1538408837_token%3D22cad6515e48df11001a14e335477188_version%3D1.0%3D1

Any help appreciated.

Thanks

Chris.





--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cwlp265mb1668bf0cad200aeab7c058fb8f...@cwlp265mb1668.gbrp265.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SOAP

[Chris Davis]

Cheers tracey I am going to pick apart the vfptweetapi as it seems to contain 
everything I need

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Thursday, 06 September 2018 20:14
To: profoxt...@leafe.com
Subject: RE: SOAP

You need to add a header. How it is formatted depends on the API.
I have this code, I'm also using the Chilkat ActiveX control for the HTTP 
requests.
oHTTPRequest.AddHeader("Authorization", "Bearer " + Token)

As an side note, I started using the Chilkat control over the MSXML control 
because the logging. 
The MSXML doesn't have connectivity logging to diagnose problems. Chilkat does.

Have fun,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Thursday, September 06, 2018 2:51 PM
To: profoxt...@leafe.com
Subject: RE: SOAP

Keeping it basic at the moment with MsXml2.XmlHttp

But I have noticed in the middle of vfpoauth there is a signrequest method that 
doesn't seem to be used ... I have also ventured into the vfptweetapi and that 
has the same function so I will delve deeper tomorrow


-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Thursday, 06 September 2018 19:31
To: profoxt...@leafe.com
Subject: RE: SOAP

What are you using to make the web requests in VFP?

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Thursday, September 06, 2018 2:12 PM
To: profoxt...@leafe.com
Subject: Re: SOAP

Progress I have managed to use vfpoauth to get my access token now I need to 
work out how to sign a request in vfp , I can get it to work in postman 

> On 6 Sep 2018, at 19:01, Stephen Russell  wrote:
> 
> This might help?
> 
> https://github.com/VFPX/VFPOAuth
> 
> 
> 
> 
> 
>> On Thu, Sep 6, 2018 at 10:24 AM Chris Davis  wrote:
>> 
>> Thanks Stephen, I am struggling with oAuth at the moment, the 
>> documentation gives examples but obviously not in VFP and it looks 
>> like things like javascript and php include oauth modules.
>> 
>> So if I can reword my question, has anyone got any oauth code 
>> 
>> -Original Message-
>> From: ProfoxTech  On Behalf Of Stephen 
>> Russell
>> Sent: Thursday, 06 September 2018 15:20
>> To: profoxt...@leafe.com
>> Subject: Re: SOAP
>> 
>> To be honest, REST is just a way that sets up an interaction in 
>> complex ways without the client knowing anything beforehand about the 
>> server and the resources it hosts. You define that the transmission 
>> is going to be HTTP and then follow the rules for it.
>> 
>> Now your call to the API can be done from a web browser, an app on a 
>> phone or a tablet.
>> 
>> here is something I wrote to get data for ExchangeRates.
>> apicall.Clear();  // This is a string to hold the params for the call 
>> I am making for data
>> 
>> apicall.Append("api/historical/" + EOM);
>> 
>> 
>> apicall.Append(".json?app_id=bbfaf8b299c54f93811b2144f9d33c3e=GBP,EUR,CAD");
>> // get the dates for use in the string  HttpResponseMessage 
>> httpResponseMessage = await client.GetAsync(apicall.ToString());
>>   HttpResponseMessage response = httpResponseMessage;
>>  if (response.IsSuccessStatusCode)
>>{  //  put the data returend into a data object I have
>> local.
>>  eRateReturn rate = await
>> response.Content.ReadAsAsync();
>> 
>> 
>> 
>> Here is eRateReturn class(s) for data:
>> public class Rates
>>{
>>public float GBP { get; set; }
>>public float CAD { get; set; }
>>public float USD { get; set; }
>>    public float EUR { get; set; }
>>}
>> 
>>public class eRateReturn
>>{
>>public float timestamp { get; set; }
>>public string Base { get; set; }
>>public DateTime date { get; set; }
>>public Rates rates {get; set;}
>>}
>> 
>> 
>> 
>> 
>> 
>>> On Thu, Sep 6, 2018 at 8:38 AM Chris Davis  wrote:
>>> 
>>> Thanks for the reply Russell, I have now discovered this particular 
>>> thing also supports REST api, just trying to figure out oAuth
>>> 
>>> -Original Message-
>>> From: ProfoxTech  On Behalf Of Stephen 
>>> Russell
>>> Sent: Thursday, 06 September 2018 14:30
>>> To: profoxt...@leafe.com
>>> Subject: Re: SOAP
>>> 
>>> Too bad that Alan is no longer among us, he redid his application 
>>> all in Web Service 

RE: SOAP

[Chris Davis]

Keeping it basic at the moment with MsXml2.XmlHttp

But I have noticed in the middle of vfpoauth there is a signrequest method that 
doesn't seem to be used ... I have also ventured into the vfptweetapi and that 
has the same function so I will delve deeper tomorrow


-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Thursday, 06 September 2018 19:31
To: profoxt...@leafe.com
Subject: RE: SOAP

What are you using to make the web requests in VFP?

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Thursday, September 06, 2018 2:12 PM
To: profoxt...@leafe.com
Subject: Re: SOAP

Progress I have managed to use vfpoauth to get my access token now I need to 
work out how to sign a request in vfp , I can get it to work in postman 

> On 6 Sep 2018, at 19:01, Stephen Russell  wrote:
> 
> This might help?
> 
> https://github.com/VFPX/VFPOAuth
> 
> 
> 
> 
> 
>> On Thu, Sep 6, 2018 at 10:24 AM Chris Davis  wrote:
>> 
>> Thanks Stephen, I am struggling with oAuth at the moment, the 
>> documentation gives examples but obviously not in VFP and it looks 
>> like things like javascript and php include oauth modules.
>> 
>> So if I can reword my question, has anyone got any oauth code 
>> 
>> -Original Message-
>> From: ProfoxTech  On Behalf Of Stephen 
>> Russell
>> Sent: Thursday, 06 September 2018 15:20
>> To: profoxt...@leafe.com
>> Subject: Re: SOAP
>> 
>> To be honest, REST is just a way that sets up an interaction in 
>> complex ways without the client knowing anything beforehand about the 
>> server and the resources it hosts. You define that the transmission 
>> is going to be HTTP and then follow the rules for it.
>> 
>> Now your call to the API can be done from a web browser, an app on a 
>> phone or a tablet.
>> 
>> here is something I wrote to get data for ExchangeRates.
>> apicall.Clear();  // This is a string to hold the params for the call 
>> I am making for data
>> 
>> apicall.Append("api/historical/" + EOM);
>> 
>> 
>> apicall.Append(".json?app_id=bbfaf8b299c54f93811b2144f9d33c3e=GBP,EUR,CAD");
>> // get the dates for use in the string  HttpResponseMessage 
>> httpResponseMessage = await client.GetAsync(apicall.ToString());
>>   HttpResponseMessage response = httpResponseMessage;
>>  if (response.IsSuccessStatusCode)
>>{  //  put the data returend into a data object I have
>> local.
>>  eRateReturn rate = await
>> response.Content.ReadAsAsync();
>> 
>> 
>> 
>> Here is eRateReturn class(s) for data:
>> public class Rates
>>{
>>public float GBP { get; set; }
>>public float CAD { get; set; }
>>public float USD { get; set; }
>>public float EUR { get; set; }
>>}
>> 
>>public class eRateReturn
>>{
>>public float timestamp { get; set; }
>>public string Base { get; set; }
>>public DateTime date { get; set; }
>>public Rates rates {get; set;}
>>}
>> 
>> 
>> 
>> 
>> 
>>> On Thu, Sep 6, 2018 at 8:38 AM Chris Davis  wrote:
>>> 
>>> Thanks for the reply Russell, I have now discovered this particular 
>>> thing also supports REST api, just trying to figure out oAuth
>>> 
>>> -Original Message-
>>> From: ProfoxTech  On Behalf Of Stephen 
>>> Russell
>>> Sent: Thursday, 06 September 2018 14:30
>>> To: profoxt...@leafe.com
>>> Subject: Re: SOAP
>>> 
>>> Too bad that Alan is no longer among us, he redid his application 
>>> all in Web Service calls years ago.
>>> 
>>> In general, the "service" is a replacement for a data store.  You 
>>> ask for data from the service and it gives it to you in SOAP, xml that is.
>>> What you actually receive is some sort of collection of data, that 
>>> may have collections within it.  You could do the same thing in 
>>> arrays if you wanted in VFP.
>>> 
>>> Now the data is yours to use at your desire.  You may have to 
>>> package the data back into XML that mimics the data they sent you 
>>> for inserts, updates, maybe even deletes.  Now through the "service" 
>>> you post that XML pack to them.
>>> 
>>> Today the industry is changing the name from Web Service to API but 
>>> in general it works in much the same way.

Re: SOAP

[Chris Davis]

Progress I have managed to use vfpoauth to get my access token now I need to 
work out how to sign a request in vfp , I can get it to work in postman 

> On 6 Sep 2018, at 19:01, Stephen Russell  wrote:
> 
> This might help?
> 
> https://github.com/VFPX/VFPOAuth
> 
> 
> 
> 
> 
>> On Thu, Sep 6, 2018 at 10:24 AM Chris Davis  wrote:
>> 
>> Thanks Stephen, I am struggling with oAuth at the moment, the
>> documentation gives examples but obviously not in VFP and it looks like
>> things like javascript and php include oauth modules.
>> 
>> So if I can reword my question, has anyone got any oauth code 
>> 
>> -Original Message-
>> From: ProfoxTech  On Behalf Of Stephen
>> Russell
>> Sent: Thursday, 06 September 2018 15:20
>> To: profoxt...@leafe.com
>> Subject: Re: SOAP
>> 
>> To be honest, REST is just a way that sets up an interaction in complex
>> ways without the client knowing anything beforehand about the server and
>> the resources it hosts. You define that the transmission is going to be
>> HTTP and then follow the rules for it.
>> 
>> Now your call to the API can be done from a web browser, an app on a phone
>> or a tablet.
>> 
>> here is something I wrote to get data for ExchangeRates.
>> apicall.Clear();  // This is a string to hold the params for the call I
>> am making for data
>> 
>> apicall.Append("api/historical/" + EOM);
>> 
>> 
>> apicall.Append(".json?app_id=bbfaf8b299c54f93811b2144f9d33c3e=GBP,EUR,CAD");
>> // get the dates for use in the string
>>  HttpResponseMessage httpResponseMessage = await
>> client.GetAsync(apicall.ToString());
>>   HttpResponseMessage response = httpResponseMessage;
>>  if (response.IsSuccessStatusCode)
>>{  //  put the data returend into a data object I have
>> local.
>>  eRateReturn rate = await
>> response.Content.ReadAsAsync();
>> 
>> 
>> 
>> Here is eRateReturn class(s) for data:
>> public class Rates
>>{
>>public float GBP { get; set; }
>>public float CAD { get; set; }
>>public float USD { get; set; }
>>    public float EUR { get; set; }
>>}
>> 
>>public class eRateReturn
>>{
>>public float timestamp { get; set; }
>>public string Base { get; set; }
>>public DateTime date { get; set; }
>>public Rates rates {get; set;}
>>}
>> 
>> 
>> 
>> 
>> 
>>> On Thu, Sep 6, 2018 at 8:38 AM Chris Davis  wrote:
>>> 
>>> Thanks for the reply Russell, I have now discovered this particular
>>> thing also supports REST api, just trying to figure out oAuth
>>> 
>>> -Original Message-
>>> From: ProfoxTech  On Behalf Of Stephen
>>> Russell
>>> Sent: Thursday, 06 September 2018 14:30
>>> To: profoxt...@leafe.com
>>> Subject: Re: SOAP
>>> 
>>> Too bad that Alan is no longer among us, he redid his application all
>>> in Web Service calls years ago.
>>> 
>>> In general, the "service" is a replacement for a data store.  You ask
>>> for data from the service and it gives it to you in SOAP, xml that is.
>>> What you actually receive is some sort of collection of data, that may
>>> have collections within it.  You could do the same thing in arrays if
>>> you wanted in VFP.
>>> 
>>> Now the data is yours to use at your desire.  You may have to package
>>> the data back into XML that mimics the data they sent you for inserts,
>>> updates, maybe even deletes.  Now through the "service" you post that
>>> XML pack to them.
>>> 
>>> Today the industry is changing the name from Web Service to API but in
>>> general it works in much the same way.
>>> 
>>> On Thu, Sep 6, 2018 at 7:31 AM Chris Davis 
>> wrote:
>>> 
>>>> Is anyone able to share an example of working with a webservice
>>>> purely in code?
>>>> 
>>>> Thanks
>>>> 
>>>> Chris.
>>>> 
>>>> 
>>>> --- StripMime Report -- processed MIME parts --- multipart/alternative
>>>>  text/plain (text body -- kept)
>>>>  text/html
>>>> ---
>>>> 
> [excessive quoting removed by server]
> 
> ___
> Post Messages to: ProFox@leafe.com
> Subsc