![]() ![]() I.e, I want to ignore these 2 directories from my listing.Īlso, at the end of the listing, instead of showing it on the console screen, I want to export this list to a CSV file, where I can open it in a text editor or Microsoft Excel. In this very simple article, I'm going to share with you a script that I developed to meet a very common need in the daily lives of those who create courses and training, which is to create a spreadsheet or CSV file, containing the list of videos, size and duration of each video, in order to maintain the folder structure to be able to calculate the total duration of the videos and also to be able to add the total duration per directory and per file, to make this available on a course platform, for example.įor this example, I used my course files on Database on Azure, which are already separated by separate directories for each module:īut notice that there are 2 folders within the course directory, called "General" and "Marketing", which are promotional videos and I don't want to consider them to assemble and make available the training schedule or to calculate the total duration of the videos. Career, Courses and Certifications (36).Make sure you follow the Windows Install Instructions in order for CMD to be able to find exiftool. This means the command line can't find exiftool, it's not in a directory covered by the PATH environmental variable. You mention getting a "exiftool is not recognized" error. Or you can use a wildcard to get all the gps tags For example,Įxiftool -csv >/path/to/out.csv -GPSLatitude -GPSLongitude You can limit the output to certain tags if you specify them in the command. ![]() This will dump all the data into the csv file. Replace with the files and/or Directories you want to process. The basic command to get csv file (see FAQ #12) There are a few other GUIs out there, though I'm not really familiar with them. I have lots of problems with it on Windows 10. It has been unsupported for a long time so you may or may not be able to get it to work. Maybe you used the Exiftool GUI found in the Exiftool GUI sub board on this forum. I am open to use the command-line option but I get an error when I try the cmd "'exiftool' is not recognized as an internal or external command, operable program or batch file." or just never-end clicking down to see more when I open "exiftool.exe" or "exiftool (-k).exe".Įxiftool is a command line only program, it doesn't have a GUI built in. In the GUI that I downloaded recently, I could only export each images' properties into separate files where I want one single spreadsheet. Hi Lumigraphics, I also would like to use the My Folder List in Bridge to be able to export metadata from multiple images into an excel, csv or text file. Otherwise, I want to export the properties (where I can choose which attributes to export ideally) from multiples images into a csv spreadsheet format. I have not managed to find that GUI interface. I could click "copy information from previous line" and it would take the latitude or longitude from another image. ![]() I remember an GUI interface where I saw a table format with all the image files in a given folder with columns for the properties (including GPS and tags). I had used exiftool successfully a few months ago but now I seem to be getting nowhere. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |