Csv automatic insertion into SQL

I’m currently working on a project with several dataloggers, each datalogger sends a csv file to an ftp sever everyday, the name of each file is function of the date and time it was sent, for instance TEST_DATALOGGER1_20130220183000, the question is, how can I automate from Ignition, the insertion of the data received everyday taking into account tha these must be saved only once in the database?

take a look at this csv parser.


Im not sure how you would know the filename unless you know the exact time the file will be generated ahead of time though. might be easier to do if you could make the datalogger only generate the date and not the time in the filename.