Skip to Content
author's profile photo Pete Simms
0
Pete Simms

From ASCII - FTP

Posted on Nov 30, 2014 at 05:56 PM 65 Views

I'd like to pull a flat file from an FTP location. I had planned to execute a to ASCII pass to generated a txt file with the variable file name in it and then pass this to a ftp tool like PuTTY (using a shell execute pass) to do the get to a local directory on my VM.

However...according to the help doc in the MMC you can specify the source file name of an ASCII pass as an ftp location. I've been playing around with it and can't get this to work but I assume it's because I don't have the ftp:// connection string correct. Does anyone know the format this needs to be entered as? The ftp site requires password and username so I was assuming it was ftp://username:password@ftp.site.com/filenamepassword@ftp.site.com/filename but so far no luck.

We currently run 7.2 sp7 in case that makes a difference.

Thanks in advance!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Matt Pollicove
    Matt Pollicove
    Posted on Nov 30, 2014 at 06:02 PM
    3

    Pete,

    if you cut and paste the FTP string to a browser does it work then?

    Matt

    Add a comment
    10|10000 characters needed characters exceeded

    • Pete Simms Matt Pollicove
      Dec 08, 2014 at 05:03 PM

      Hey,

      Just to close the thread, I gave up on trying to make FTP connection work from ASCII. I wrote a to ASCII pass to create a .txt file. This contains the date specific file names I want to 'mget'. I then run a shell execute to run psftp.exe and pass it my usernaname, ftpsite, pwd, and txt file on the command line.

      One quirk. I couldn't get the the usual format of shell execute to work, and ended up having to start my command string with "echo | blah". I've no idea why that makes it work but noted it from a previous thread and it appears to kick of the psftp executable correctly.

    Comment on This Answer
  • author's profile photo Tero Virta
    Tero Virta
    Posted on Dec 01, 2014 at 07:53 PM
    0

    Hi Pete,

    I had to FTP a reports from shared service center's IdM to it's customer organizations.. My notes show I created a command file with the needed FTP-commands in it, the cmd-file was called from the Shell Excecute with "cmd /c theCommandFile.cmd". (With full path pointing to the cmd-file.)

    I cannot remember whether I did the cmd-file wrapper because calling the ftp-command didn't work in Shell Execute or due to the other complexity, like FTP'ing the files to 10+ different locations.

    regards, Tero

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.