Re: Automatic Import from CSV file

[Phillip Ward]

Is there no way this can be done more directly?

My first choice would be for the sending application/ system to connect directly to your MySQL database and update the data directly.

If that's not possible (because the Internet is a scary place that we don't want to let anywhere near our databases) then I'd suggest a web application (at "your end" of things) that the sender uses to upload the files. That web application can then read each file, connect to the database and do the updates and, possibly, even send back any errors for the sender to resolve, if that's relevant.

Failing that you're back to polling directories for [new] files, moving them elsewhere and processing them using either LOAD DATA or a custom program; personally, I'd suggest the latter, if only because it can do better error handling (although who you'd tell about those errors, and how, is another matter).

Regards, Phill W.