Solved

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

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

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 41

Expert Comment

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

Thanks!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
In  today’s increasingly digital world, managed service providers (MSPs) fight for their customers’ attention, looking for ways to make them stay and purchase more services. One way to encourage that behavior is to develop a dependable brand of prod…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now