Solved

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

Posted on 2015-01-19
3
177 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

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…
Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

713 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