Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2015-01-19
3
Medium Priority
?
241 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 43

Accepted Solution

by:
pcelba earned 2000 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 43

Expert Comment

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

Thanks!
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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…
If you have come across a situation where you need to find some EDB mailbox recovery techniques, then here you will find the same. In this article, we will take you through three techniques using which you will be able to perform EDB recovery. You …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Screencast - Getting to Know the Pipeline

972 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