6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

Talend - FTP file to a personal Excel file

by OrenPowell
4 replies
Ok, bascically the title said it all.
I'm using Talend to get files (in .csv format) from a FTP site and combining all the data into one Excel sheet on my computer. Bascically, I've have tried a few ways, but pretty much, it doesn't seem to work... at all! except the logging into the FTP site, I know i need to use the following item, but just dont know how:
FTP send
FTP get
list
compare
and probably TMAP
If you have a solution.... well, that would be pretty great. Feel free to ask any questions
#.csv #excel #file #ftp #personal #talend
  • Profile picture of the author OrenPowell
    can anyone help me on this?
    {{ DiscussionBoard.errors[4040620].message }}
  • Profile picture of the author OrenPowell
    Come on, guys... help me out. Geez
    {{ DiscussionBoard.errors[4047023].message }}
    • Profile picture of the author ToneUK
      Does it have to be using Talend because I can throw together a quick VB.NET program that will do what you want quite easily?
      Signature
      Free article directory for publishers to download. Free article submission with fast approval times. Submit free articles with back links that are Do follow.
      {{ DiscussionBoard.errors[4050202].message }}
      • Profile picture of the author ToneUK
        I have created a windows program that should do what you require. You can install it by visiting CSVCombine and clicking the "Install" button. See screen shot of running program below:



        Usage is self explanatory. The 3 text fileds on the left are for providing the login details and server address of your FTP server.

        The CSV directory is for specifying the directory to change to once connected. This is the directory that the CSV files should be stored in. The Save file is where the combined save file will be located on the local machine.

        Supply the details then click Combine. The file will then be saved to the location specified.
        Signature
        Free article directory for publishers to download. Free article submission with fast approval times. Submit free articles with back links that are Do follow.
        {{ DiscussionBoard.errors[4050510].message }}

Trending Topics