Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

What are the steps to set up and utilize winSCP in FoxPro (9)

Posted on 2015-01-19
3
166 Views
Last Modified: 2015-12-09
Can someone let me know the proper way to setup / register  / USE winscp and use it for automation in visual foxpro?

I need to drop and pull files from a SECURE ftp site as well as read a directory to wait for a file.

Thanks!!

BC
0
Comment
Question by:busycoder
  • 2
3 Comments
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 40559387
WinSCP does not allow OLE Automation as other products like MS Office etc.

Instead of the WindSCP OLE Automation you may use its scripting capability and execute it as a DOS batch file by RUN command from inside VFP application.

All details about WinSCP setup and scripting parameters are described here: http://winscp.net/eng/docs/guide_automation

Of course, .NET allows better WinSCP control via assembly build on top of the WinSCP scripting interface.

Other products also exist:
Chilkat FTP library is easily accessible from VFP: http://www.example-code.com/foxpro/sftp.asp
And it also has ActiveX interface (http://www.chilkatsoft.com/refdoc/xChilkatSftpRef.html)

If you would like more work for a free then there is libcURL: http://curl.haxx.se/libcurl/
FTP functions (not SFTP!) were encapsulated to FLL library for FoxPro: http://www.sweetpotatosoftware.com/SPSBlog/CommentView,guid,e7cccb45-7d99-4c35-85bc-e123c81c8794.aspx
0
 

Author Closing Comment

by:busycoder
ID: 41363164
Thank you for your help on this I thought I closed this long ago :(
0
 
LVL 42

Expert Comment

by:pcelba
ID: 41363513
LOL, first points in December!

Thanks!
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question