I have about 100,000 files scattered among about 20 directories. For each file there is an associated .arf file, which references the actual file and has details about it. What I would like to do is have a script be able to read these .arf files and create a MySQL insert statement from the fields in the .arf file to add them all into a single table. I would like the MySQL code to be contained in a single .sql file once all of the .arf files have been read in.
Here is an example of an .arf file:
GROUPID: "Check Stubs"
The fields in each .arf file are all identical, so that should make things a little easier. The path here is not important and will probably be ignored but it should be imported as well.
Any thoughts on how to tackle this problem?