Help for upload .csv files saved in multiple folders
Periodically, a set of industrial machines send remotely (FTP) a file containing the data for assessing the operation of the machine.
Files are saved in specific folders for any operating machine on the company server in head office.
The CSV file contains the machine identifier, date and time of transmission, separated by a "-" character in the file name itself.
Example:
G00X001-20161016-1010.csv
Inside the files transmitted are a series of data separated by the character ";" useful to evaluate the operation of the operating machine.
The type of transmitted data is identical for each operating machine.
In order to do the analysis on the performance of these machines I need to group all this information (present in about twenty different folders) and keep them updated with the new items of files.
How can I upload in QW all files saved in the folders on the server and keep them updated?
In addition to the data contained in the CSV file I have to add the identifier of the machine that is reported only in the name of the CSV file.
