Is it possible to create a scheduled task to retrieve the data from a CSV file that is hosted on a 3rd party server (SFTP) and import the contents?
We would also like to send similar data in a CSV back to that same server.
I believe there are some restrictions, but wondering if anyone here has found alternative coding methods to those?
Hi Tony ,
The short answer is that yes, it is possible. We built and deployed CSV importers for numerous customers that include a number of safeguards for factors such as row size, file size, formatting issues, scheduler timeouts, alerts for job completions/failures, etc. To keep development costs down, we've refined this offering to a base product which handles the heavy lifting plus the cost to implement the specific business logic required to process the CSV file template(s).
Contact us via our site if you would like to learn more about the solution we can implement for you.
Chris
