Solved

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

Posted on 2015-01-19
3
184 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
[X]
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
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VFP9 Server Can't lock file 22 134
MS Access no longer ablle to link to FoxPro tables 30 370
filling in gaps in tables vfp 9 86
DBF to ... Converter 5 111
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…
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

734 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