The documentation warns that the -csv flag, unlike most exiftool options, builds the entire output in memory and so memory usage can be quite large when used on many files - probably best to script up something that goes folder-by-folder. (in this example, all of the files in the current directory). This will include a very long list, so if you want to just include a few specific things you can do that: exiftool -csv -Model -CreateDate -GPS:all -time:all *.jpg T/images/Canon.jpg,0,151, t/images/Casio.jpg, Gives an output like this: SourceFile,AEBBracketValue,AELock,AFAreaHeight,AFAreaMode,AFAreas, For example, this command: exiftool -csv -r t/images > out.csv Practical to use the -csv option for extracting all information from As well, a firstĬolumn labelled "SourceFile" is generated. Organizing the information into columns for each tag. Sorted list of available tag names as the first row of the output, and Pre-extracting information from all input files, then producing a The -csv (comma separated values) option solves this dilemma by You can do this fairly easily with the cross-platform free software ExifTool. Most of the tools I've found that do batch EXIF metadata exporting do so by exporting a separate text file for each input JPG, which is not what I'm after, I need one table per folder (and its subfolders). I've found Camera Bits Photo Mechanic, which does what I need, but I was hoping there was a free/open source solution. I need to preserve at least 6 decimal places in the lat/long fields, the location data is important. I'd like to extract certain pieces of metadata (latitude/longitude, data/time, camera model and serial number, maybe a few others) from all the images in those folders and their subfolders and export it in a table (CSV would be easiest), so that I can import the metadata into a database. If date AND TIME are required, remove the SET fdate line and replace the "!fdate:~0,10!" with "%%~tiĭate and time format - to be certain, need to know the format you are using.I have hundreds of thousands of images in a set of about 50 folders, each of the folders has a varying number of subfolders. The inner setlocal is to allow at least some silly directory names.Įdited to show date as third element. Quote both and output with a comma between. The pathname of the directory required should be supplied as the first parameter, quoted if necessary.Įssentially, change to the directory in question, find and save the name of the leaf directory, then execute a directory scan returning the filenames. If by the "Immediate folder name" you mean the name of the containing directory but without the path to that directory, then: OFFįOR /f "delims=" %%i IN ("%cd%") DO SET directory=%%~nxiįOR /f "delims=" %%i IN ('dir /b /a-d /on') DO (
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |