Coldfusion Upload client file to CF Server

I have a scenario where I need to automatically upload client file(CSV, Excel, etc...) to CF Server.

However, no user intervention is allowed. The process will be done using the Coldfusion's job scheduler.

We use to use CFFTP but this is not allowed on the host server anymore.

Some experts guided us in the direction of using CFHTTP. However, we have never use this before.

Any suggestion is highly appreciated
Errol FarroAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Can you elaborate on "upload client file(CSV, Excel, etc...) to CF Server."?  

Do you mean send a file from your server to another remote CF server? That's certainly possible, but we'd need to know more about what the remote server expecting to receive.
Errol FarroAuthor Commented:
On a daily basis employees create CSV and Excel files from their legacy system on a local server in a central directory. These files must subsequently be transferred to a host in the cloud. The host in the cloud runs Coldfusion. Coldfusion does not run locally on any of their servers. What we would like to do is have the CF server in the cloud pick up these file from the  local server without manual intervention. Is this possible ? We are not allowed to install any FTP client on the local server
For CF to be able to access files on another machine, they need to be accessible remotely somehow, such as:

- Web accessible:  The remote server runs a web server and makes the file available via http
- FTP accessible: The remote server makes the file available via FTP
- Network accessible: If the remote server was on the same network, it could be mapped as a shared drive

Is the file web accessible on the legacy system? If yes, then cfhttp would work to access it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keep in mind the above just describes CF file access in general, not security.  Always consider the content and whether or not it's something that should be made web accessible, what type of security is needed, etc...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.