... please wait

Jeremy Aaron Heminger

Systems Programmer / Web Developer Located in Southern California

WinSCP SFTP Automation

My GitHub repository for this project

The WinSCP Official Website

It was a fortunate coincidence that I needed to build this tool at just the right time. Aquamor had recently brought on a new customer whose EDI connection required SFTP. At the time, the DelmiaWorks EDI module only supported FTP. Normally, a new customer like this would ramp up gradually, and we could’ve used something like FileZilla in the interim—but eventually, a more robust solution would be necessary.

As it happened, IQMS was planning a mandatory upgrade for June 2025. According to their EDI technician, customers unable to upgrade in time were being advised to use WinSCP as a workaround. I had completely forgotten about WinSCP—I had used it in a WordPress FTP plugin a year or so earlier. That experience allowed me to quickly port some of that code and integrate it with my existing custom IQMS libraries to automate polling of EDI files and transfer data in and out of DelmiaWorks.

Although Aquamor was prepared for the upgrade, this particular customer was not using the DelmiaWorks VAN, so a separate connection was required. Technically, eServer supports custom connection strings and could have been used instead of this tool, but that wasn’t an option available to us before the upgrade deadline. Besides, there’s no telling what hybrid setup future customers might require. As I’ve mentioned elsewhere, Aquamor operates as a hybrid manufacturer while also handling eCommerce—so we’re constantly onboarding new customers and integrating new connections into the system.

Since this tool ended up being a bit of a novelty that we didn’t strictly need long-term, I thought it might be useful to others. So I posted it on my GitHub.

Linux
Apache
MySQL
PHP
HTML5
CSS3
JavaScript
jQuery
Grunt
Sass
Git / GitHub
WordPress
Drupal
TypeScript
C#
Oracle SQL Developer
Visual Studio