How to copy files from one location to another with seletions

Posted on 2012-09-19
Last Modified: 2012-10-23
I have a project that I am doing for a company.  I am generating automatically a csv file daily. that lives on the server.  In that csv file will be one column that will contain a part#.  For each one of those part numbers there is a COA (certificate of authenticity) word doc on the server.  What needs to happen is something needs to scan that file for what part numbers are being used, then go to that server drive and copy the COA files that are related.  For instance, part# 12345 is in the 5th of column of the excel file.  I need to pull the file COA12345.doc from the server and copy it into a ftp holding area so it can be picked up by someone.  The area would then hold the one excel file and a whole bunch of COA's that are related to that excel file.   One day you could have just part# or you could have 20.  
How could this be done?  Any help would be appreciated.  Thanks.
Question by:kevinecaldwell
    LVL 16

    Expert Comment

    You could use a Robo-FTP script to do this.  The READFILE command can parse the CSV file for the document and then fetch the file and send it.

    Accepted Solution

    It is not working and I am still figuring out ways to do this.

    Author Closing Comment

    Have had no luck and still working on it to find a way.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    This video demonstrates basic masking and how to edit the mask to reveal the desired image.
    XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now