csv output for mysql database install

[Mjkxxl]

Hey guys quick question here.

My goal is to export the metadata into a CSV file to be integrated into a MySql database so that I can generate lists of images that fit certain criteria (shutter speed, aperture, etc. )

I understand how to export to CSV just fine using the CMD commands however the list I get back contains the descriptive terms. For example, when reading a .CR2 file, it displays "ContinuousDrive
" section as "Continuous, Low" or "Continuous, High" etc.

I was wondering if there was a way to export to CSV and use the values found here.

http://www.exiftool.org/TagNames/Canon.html

These appear to be mainly numerical in nature or smaller in size than the actual descriptive listings and it would reduce the size of the database considerably. Or if someone has a better way to place the exif data into a mysql  database I would love to hear it!

Thanks guys, and thanks Phil for making such an awesome tool. I so wish PHP would take this and use it in their exif_read_data() function!!

Also if this is in the wrong place (not sure where to put it since I am using the exiftool.exe file) go ahead and move it where it needs to go!

[Phil Harvey]

Yes.  add the -n option to the command to extract numerical values.

- Phil

[Mjkxxl]

Thanks Phil, talk about total fail in missing that command when reading the FAQ.

And thanks again for the tool!

[BogdanH]

Hi,

...total fail in missing that command when reading the FAQ.

I believe it's a good idea to read "general" documentation first:
http://www.exiftool.org/exiftool_pod.html (here, -n usage is explained).
Of course, it's impossible to remember all options, but one gets an overview of possibilities -that is, I can't remember "how to do something", but I do remember it's mentioned there.

Bogdan