I spent several hours today trying to figure out how to get that blasted "Title" from the metadata into an Excel file. This is a fabulous solution, thank you many times over for posting this!
@johnmaggio7976 Жыл бұрын
Just as a note - This can also be used on networked drives. It will not take a unc path (\\yourdrive) but if you assign a drive letter to a folder, you can do a CD /d v:\music music for me is on my synology NAS and I mapped V to the folder. I also wanted to list the bit rate of all the MP3 files and the column is called Bit Rate in explorer. Filelist does not like the space so I used bitrate and it worked. So it looks like any column that explorer can display can be used. Thanks for this very good tutorial.
@GrahamSmith463 Жыл бұрын
You are a life saver. Thanks for this!
@carlos_mann9 ай бұрын
So this will work with the metadata that is already embedded into the mp3 file? I'm trying to get a printable list of my mp3s, (artist, title, comments). What he did works, ill be using a synology nas as well
@cesarmontes3406 Жыл бұрын
Man you have saved my life because I´m running a forensic audit in which I´m presenting evidences and with this I can demonstrate the evidence comes from a reliable source.
@kirksurant27694 жыл бұрын
This executeable is something I have been needing for YEARS. Up until now I had been using dir to output to a text file and parsing the data manually in Excel. However I have never been able to find a good way to get the duration ("Length") for the media data. It is a bit confusing with the way the list of details desired is layed out (ie: I couldnt find FullPath in the list AND I was unsure whether to use just Length or System.Media.Duration or both (Length-System.Media.Duration). Yet when i saw the 1st comment where the person was asking for Length and your answer, I kinda figured it out. All in all this is a great video. Short, to the point, and gets the job done well. You have done a very great service for me personally, and to the world; and for that, I thank you so very much. God Bless
@j-center8372 жыл бұрын
I am trying to get the duration but getting weird numbers. How did you fix it?
@gilson79592 жыл бұрын
@@j-center837 This is duration in 100-nanosecond units. First you have to convert into seconds using the formula: =[@Duration]/10000000, and then in Microsoft Excel to convert into time duration format use this: =[@Seconds]/(60*60*24) and change the format to Duration
@nathang74854 жыл бұрын
Since the virus pandemic I now am required to work at home. So, I really appreciate these short cuts while I focus on paperwork :) These short tutorial videos are helping me immensely. I hope you and your family are staying safe during this troubling time.
@philranger98253 жыл бұрын
instead of executing CMD from the windows menu, type "cmd" and enter in the directory name and it will open a command window already in that folder.
@MichaelDewTechTips3 жыл бұрын
Wow, thanks Phil, excellent trick I did not know that! To make sure it is super super clear to everybody else, navigate to the folder in Windows Explorer containing the files and subfolders you want to run the FileList operation on, and then in the address bar of that Windows Explorer window, type "cmd". That will open up the command prompt with the path / directory already set to what you want it to be. Thanks again Phil.
@barbaraparker71293 жыл бұрын
THANK YOU! Using your instructions I was able to export over 1000+ files and the Metadata! You Rock!
@constitution6239 Жыл бұрын
Thank you for having uploaded many useful videos, which includes your Playlist of "JD 3-1 educational."
@christopherwong61746 ай бұрын
THANK YOU!! I've wanted this tool for my music files for years. THANK YOU!! Excellent tutorial and information.
@atiquebinzohur7402 Жыл бұрын
Great video. I needed the duration of hundreds of videos. I figured out how to do that from your video. Thanks again for this!
@A_A783 ай бұрын
thank you very much for this video 💖. it helps me a lot.
@krithigashiva74994 жыл бұрын
Thank you so much. I was particularly searching for length of the media data and got it.
@danielalbrecht88754 жыл бұрын
Daniel Albrecht That saves me so much time. FANTASTIC ! Many thanks for your beautiful video. All the best.
@kannanaiyar52914 жыл бұрын
Brilliant.Thank you. I have been trying to find something like this for a while now. I seem to have several copies of the same photos in different folders, but sometimes the same file name does not mean the same photo. Knowing the Date Taken makes it very easy.
@carlitocarlito9748 Жыл бұрын
Kannan, I use ztree to help solve this issue, it allows you to copy to a single folder from many other folder listings
@paulsouthern5472 жыл бұрын
Thanks for sharing Mike - solves an age-old problem I've had.
@roniux0074 жыл бұрын
Exactly what I'm looking for, thanks for share and teach this procedure. With other commands like "System.Document.DateCreated" instead "System.Photo.DateTaken" I could obtained the content date when the file was created, from many MS word files, finally a completely masively comparing.
@sunnyboy14282 жыл бұрын
Hi Michael, when I'm trying to export video length using System.Media.Duration the output file has some long numbers for the duration like "17608850000" or "19030290000" Please advise what am I doing wrong?
@MichaelDewTechTips2 жыл бұрын
Sorry, never dealt with that before, and not sure what is going on there. I thought it might be the duration seconds, but the number is too big for that. Sorry cannot be more help.
@rowanjoseph99022 жыл бұрын
Found any Solution ?
@gilson79592 жыл бұрын
@@rowanjoseph9902 This is duration in 100-nanosecond units. First you have to convert into seconds using the formula: =[@Duration]/10000000, and then in Microsoft Excel to convert into time duration format use this: =[@Seconds]/(60*60*24) and change the format to Duration
@Sarahlinii Жыл бұрын
@@gilson7959 Where do we type that formula into in order to even make the calculations/changes to have length properly reflect what is shown in windows explorer? I'm having the same issue for example, once the info is exported to excel a video length 04:24:56 is shown as "158961260000" in the length column. I can't do anything with that information. Any help would be appreciated, I'm not familiar with many formulas or codes, etc., in excel.
@kishorekumarjonnalagadda77972 жыл бұрын
Would this work for 2.3 million files in my file system?
@debcodding8609 Жыл бұрын
Excellent video -- saved me a lot of manipulation time! Thanks.
@alexerpeixoto7449 Жыл бұрын
Mate, you saved my life. Thank you so much.
@mcadutub Жыл бұрын
Thanks for making this Excellent tutorial. For unknown reason, I can only do 6000 entries at a time. For instance my library has 33000 songs. When I execute the cmd with 3 columns, filename, size and length (_FileList.exe /USECOLUMNS NAME,SIZE,System.Media.Duration > _flacmp3nfo.txt) excel only takes about 6000 entries and not in alphabetical order. So I have to split my library to chunk of 6000 files at a time. Anyway, it little bit more work but still way better that without having the song duration. 😁
@AshishSharma-rd6ze Жыл бұрын
Finally found some legit tutorial.
@davidp984 жыл бұрын
Excellent, clear instructions and exactly what I needed thank you.
@jam-software5 жыл бұрын
Wow! Thank you very much for this great tutorial.
@tn25mfan4 жыл бұрын
Thanks for the great software! Is there a command for photos>properties>details>comments? I enter GPS coordinates in that location and need them in Excel spreadsheet. Thanks!
@assamazam5151 Жыл бұрын
This is great! Very helpful for my current project. I wonder if there is a way to make a BAT file with this in it.
@CpuAnalyst3 жыл бұрын
QUESTION: Does it only extract the metadata from the directory where you paste the FileList.exe file, or does it also extract the metadata from the sub-directories within THAT folder? Thanx in advance... I have over 34,500 audio files categorized into 900 Directories, and sub-directories The data I'm trying to extract is as follows... ALBUM - ARTIST - TITTLE - SIZE - LENGTH - YEAR - GENRE - INITIAL KEY - BPM - BITRATE Thank you for posting these helpful videos.
@MichaelDewTechTips3 жыл бұрын
It also pulls data out of files in the sub-directories. Perhaps make a small sample folder tree to experiment on to start with.
@CpuAnalyst3 жыл бұрын
@@MichaelDewTechTips Awesome: Thanx for the help.
@Samoaplaya3 жыл бұрын
this guide was really helpful! albeit also a little odd to see "Receipts (Rona)" in there, considering this was made a year before 'rona' was in our vernacular.
@alexbelomlinsky759111 ай бұрын
Thank you for sharing! Any idea why System.Title does not carry over my info from the source files?
@anonUK3 күн бұрын
Thanks for this, this is fantastic. Btw, my help file from Jam Software doesn't show any info in the RH pane. Microsoft offers some assistance on other categories to search for- but is there anywhere else I can get a similar list please?
@MichaelDewTechTips3 күн бұрын
Are you saying that you cannot get the help file for FileList to work? You should be able to download it from www.jam-software.com/filelist.
@dr.melodicadavidbrancazio88603 жыл бұрын
Super helpful, thanks!
@ArthurGarrenton2 жыл бұрын
Thank you, it works like a charm.
@blrsub10 ай бұрын
Thanks Mike for the useful video. What is the code for the file attribute "Comments"?
@abdulrahmanmoughalless23062 жыл бұрын
I was wondering if there is any program that does this automatically, that is, when I copy any file to the folders, the program extracts the metadata to the excel database
@reddlief9 ай бұрын
Michael I have a question and great videos by the way. Excel and even file attributes are different country to country. For instance, European date configuration is D/M whereas my country (USA) is M/D...I've only watched 2 of your files that hit my problem square on, so I apologize if this comes up in your library of videos that I will finish watching!
@reddlief9 ай бұрын
I just hit the more button in comments, and you've listed all the commands and attributes as shown in the video!!!!! What a resource. I only wish I'd have this 30 years ago!
@batista988543 жыл бұрын
Really Thanks a lot. Saved hours of time.
@selectionbreakdown70248 ай бұрын
Dear Sir How about creating a list of files based on the date modified? Just search for files modified in the year 2022.
@MichaelDewTechTips8 ай бұрын
I think the Jam software can only search by folder i.e. it pulls out data for all files in the folder (and its subfolders) irrespective of the dates of the files. After you get the full details of all files from the Jam Software report you could then screen for files with particular dates.
@chrisg7583 жыл бұрын
Super helpful, thank you!
@johndaniels54074 жыл бұрын
That was very helpful!! Thank you so much. God bless you.
@sandeepsaini2994 Жыл бұрын
How to get a lenght of Video
@daviddemers94633 жыл бұрын
So how do I get the info from the comments column?
@chakirpiro71682 жыл бұрын
Very helpful, thank you
@Hitmanu-yq9if4 жыл бұрын
Thanks for the amazing video. Would you please mention how to add the "LENGTH" column to the details? It would be highly appreciated.
@MichaelDewTechTips4 жыл бұрын
Do you mean audio or video file duration? If so, try add "System.Media.Duration" into the string of fields separated by commas, and no spaces.
@madhockeyman4 жыл бұрын
@@MichaelDewTechTips Yes, that is what I think she meant and what I was looking for as well. You hit it spot on! Thanks!
@zohararafi35274 жыл бұрын
@@MichaelDewTechTips Thanks for the video. How about if it's an audio file duration? Is it the same code?
@MichaelDewTechTips4 жыл бұрын
@@zohararafi3527 could be, else try "Length - System.Media.Duration".
@MultiDuypro3 жыл бұрын
@@MichaelDewTechTips Thank you so much
@khalifrhodes5073 Жыл бұрын
Do you have a copy of the filelist 4.3. They fixed the way the file is output in the 4.3.1 . If anyone has the 4.3 file that would be great.
@tokirakis4 жыл бұрын
Is it possible to take the coordinates from the photo? The photos are from a drone.
@KQCNT5 ай бұрын
Im trying to add Frame Width since "System.Image.HorizontalSize" has no info in my video files. Do you know what would be the correct "system" code?
@MichaelDewTechTips5 ай бұрын
No, sorry, I do not know that one.
@JosepCarrizo3 жыл бұрын
Very useful! thanks so much
@digitalsausage5590 Жыл бұрын
Good utility, and very useful. But for photos, I can get everything EXCEPT the F-Stop value to export. It can be displayed in Explorer, but using filelist I can't figure out the right property/field name to fetch F-Stop/Aperture. Anyone else figured that out?
@tomvarrun7322 Жыл бұрын
Thanks man,it works
@matthewwheeler878 Жыл бұрын
Michael, it's great to have this useful demo. I just tried it with a non-local (network attached, mapped) directory. Unfortunately, I got an invalid parameter error for /USECOLUMNS. Any insight? Maybe a developer support issue. Thanks.
@MohamedAshraf-vh3jo2 жыл бұрын
THANK YOU SO MUCH!
@teamofficialvisindometadat75542 жыл бұрын
Thanks Brother, it's realy help
@atiq-ur-rehmanmuhammad32593 жыл бұрын
Great ................ Thank you very much
@turnswood4 жыл бұрын
Hey Michael, this is great. I use the other video showing save as path all the time and recently found the need to get some metadata from my jpegs. Is there a way that you've found to extract all the metadata that is available? Once I had that I could parse what I need in Excel. Maybe a better way of asking that question is - is your list above all of the System. - names all-inclusive or are there more? Thanks - I have looked for other scripts that bring in Powershell that didn't work as I wanted and this is very simple. I have used Jam's other program TreeSize Free for viewing directory sizes and use it all the time. Irv in Florida
@MichaelDewTechTips4 жыл бұрын
no, sorry, I do not know of a single command to bring in "all available" metadata, you could check the jam software guide for the software, but it may be that you have to specify the metadata items you want one by one using the specified commands.
@Melkhalifaaa6 ай бұрын
Hmm would adding the page count per file possible?
@MichaelDewTechTips5 ай бұрын
Try adding System.Document.PageCount to the command, for sure it works to pull pdf file page counts, and may also work for some other file types, but obviously not for photograph files, etc.
@Artist77osi2 жыл бұрын
how to get Titles of the font from font metadata
@LeonMire2 жыл бұрын
Not sure if this works anymore. I ran the command sequence and was told "Access is denied. This file can't run on your PC." Running Windows 10.
@MichaelDewTechTips2 жыл бұрын
Pretty sure it still works. Are you sure you were in the correct drive? If not, try the change directory command.
@jakehansen6052 ай бұрын
does anyone know what the attribute codes are for pulling photo latitude and longitude? Thanks
@MichaelDewTechTips2 ай бұрын
Not sure, but I think that is not possible with this tool, may need a more sophisticated photo metadata tool for that.
@jakehansen6052 ай бұрын
@@MichaelDewTechTips Thanks for the response, I used the exiftool to extract X Y info
@geneholmes81764 жыл бұрын
Very informative and convenient. I am looking to extract the data shown in the "Statistics" tab on file explorer properties but no column is available showing this tab information. This information tab shows editing person, dates and total editing time. This pertains to autocad drawings but this should not affect the data extraction because it is shown in the properties. I have screen shot PDF's showing the tab but am at a loss as to how to find or export this tab information to Excel or .txt. I could send the PDF's for review if desired.
@MichaelDewTechTips4 жыл бұрын
Not sure I can be of any help on this, did you look at the full list of commands available in the Jam Software user guide?
@atpu555ananthan53 жыл бұрын
Thanks for your video, which looked promising, but it only downloaded 1335 line of data! I am not sure why. There are several thousand more files in the folder!
@MichaelDewTechTips3 жыл бұрын
I have had that problem only very seldom (perhaps only once, can't even recall). Try restarting your computer. If that does not help, it may be a problem file that is causing it to crash. Split the data up into subfolders and run the routine on the different subfolders and you may be able to detect where the problem file is.
@atpu555ananthan53 жыл бұрын
@@MichaelDewTechTips Thank you! Will try it.
@Raptor3Falcon2 жыл бұрын
dimensions not working for mp4 files
@anmac69102 жыл бұрын
can you expand and customize this list to include date created, date accessed of folders as well ? what other fields can this show ?
@MichaelDewTechTips2 жыл бұрын
Yes, read the content in the video description right below the video.
@insidedetails61013 жыл бұрын
Great work, I have a question, can I copy the file names like in the video and then organize them inside Excel and apply that inside folders
@MichaelDewTechTips3 жыл бұрын
There is another video on this channel that has a link to a spreadsheet that will sorta allow you to do what you describe
@Sarahlinii Жыл бұрын
I'm finding that whenever I try this, I follow the instructions fully and go to load the .txt file into Excel and find that the list of files is not complete. For example, I have over 700 files in just one folder yet when the info. is exported it only shows 160 or so. I've no idea how to fix this but it keeps happening and does not give me a complete list of files/folders most of the time. I've spent so much time so far trying to figure out where I'm going wrong, but I've no clue! Oh, to add, I'm trying to get lists of files/folders off of my backup External Hard Drives for work. I'm not sure if that influences how FileList, etc., operates or not. Any help would be great!
@MichaelDewTechTips Жыл бұрын
Could be one strange file causing it to crash, perhaps look at the last file in your list of 160, and then also at the next one, and consider moving those off the hard drive and try again (?)
@Sarahlinii Жыл бұрын
@@MichaelDewTechTips Thanks for the reply and the tip, I'll give that a try! It seems to have the same issue with files that aren't on any external drives also. I just tried earlier with several hundred videos I have on my computer and it again only shows a partial list. I'll see if I can figure it out utilizing your tip. Thanks again :)
@JAY_SRI_HARI Жыл бұрын
Is it possible to know the size of page of pdf whether A3 OR A4
@MichaelDewTechTips Жыл бұрын
Looking at the list of codes for what can be extracted by this software, I do not think that is possible with this software. Seems like www.softpedia.com/get/Office-tools/PDF/PDFInfoGUI.shtml might be free software that could do it but I have no experience with that software and not even assessed whether it is trustworthy. PDF Shell tools can do it, www.rttsoftware.com/shelltools.html, but that is paid software. I use PDF shell tools for lots of things and I love it.
@jeffsteidl7573 жыл бұрын
I have a question on this. This pulls the data in. I would like to not only pull it into excel, but do a mass change on the information, then do a mass change on the files with the new data. I have a lot of files that need changed on a mass scale. example is a song list. I have many songs in a file but the tags are sloppy. I would like to adjust them in excel then export or change the files on a mass scale. If this something you have done a video on or can pint me in the right direction? Thanks!
@MichaelDewTechTips3 жыл бұрын
No, I have not done a video on that, although it would be possible to build such a spreadsheet. The closest I have done to that is a spreadsheet that can bulk change just the file names: kzbin.info/www/bejne/rGPKn3uAaLeMrqs
@shreyasiparikh15443 жыл бұрын
THANK U, CAN YOU HELP ? WHAT SHOULD WE WRITE TO GET IMAGE DIMENSION? IN PIXELS ? or Inches (Width and Length)
@MichaelDewTechTips3 жыл бұрын
I think this tool extracts mostly system metadata, for image properties you may have more luck with ExifTool by Phil Harvey (for photograph metadata) , try google that...good luck...
@sridharan4454 жыл бұрын
Thank you. Very useful. But I am not getting the details for drives that are connected via USB say 'G:" or "F:". Am I making any mistake?
@MichaelDewTechTips4 жыл бұрын
you may need to change the command prompt to the drive that you want to extract the data from using the change drive command e.g. to change to F drive type F: at the command prompt and then press enter, then, to type cd for change directory and paste the path of the top level folder and then press enter
@aysenmustafa69733 жыл бұрын
this is very useful but I keep getting error messages when trying to add the columns, Date Last Saved and Total Editing time, I have tried 'DATELASTSAVED' and 'System.Document.DateLastSaved'. What am I doing wrong?
@MichaelDewTechTips3 жыл бұрын
Not sure, perhaps you are including spaces that should not be there? And did you use the > character correctly and not the funny arrow that I had to use in the KZbin description because KZbin does not allow use of > in the video description?
@harndbuster3002 жыл бұрын
I have a folder of emails extracted from outlook. Do you know how to extract the date the email was created in to excel aswel as the metadata?
@MichaelDewTechTips2 жыл бұрын
Did you try adding "System.Message.DateSent" to the line of code?
@harndbuster3002 жыл бұрын
@@MichaelDewTechTips yeh it didnt' bring back anything
@MichaelDewTechTips2 жыл бұрын
@@harndbuster300 hmmm...is this just a collection of .msg files in a folder and you just want to extract "date sent" info? Is this a one time project or something you will want to do this repeatedly from time to time? If you put all of the files into a cloud folder (e.g. Dropbox, Google Drive, etc.) and email the link to me at legaltree at gmail I can take a look at extracting the data, perhaps using another tool. It may be your files have something weird going on with them, but if you give me access to the files then I can try and extract what you need.
@brookehockersmith46854 жыл бұрын
I need the spread sheet to update as I add documents in the folder. Is there an way to do that?
@MichaelDewTechTips4 жыл бұрын
Not that I know of that is easy to implement. Might be able to do it with Power Query in Excel, but could be tricky depending on what metadata you are looking to import. Sorry cannot be of more help.
@ovealexander23463 жыл бұрын
Thanks, very helpful. As always a great solution always begs the question of more. Where might I find a full (or at least expanded) list of metadata columns to extract? I am for example right now interested in camera make and model and my best guesses at what that might look like (e.g. System.Photo.CameraMake) hasn't worked.
@MichaelDewTechTips3 жыл бұрын
Check the Filelist documentation on the Jam software website for a full list. Also, for photos you may want to use an ExifTool e.g. the one by Phil Harvey
@omkarmemane57372 жыл бұрын
@@MichaelDewTechTips Hello Sir...first of all thanks a lot for for this video...this helped a lot...can you please paste link of filelist documentation....actually I wanted code for extracting comments as available in file description
@choosedean Жыл бұрын
@@MichaelDewTechTips I cannot find a full list on the Jam Software website. Can you provide a different resource?
@MichaelDewTechTips Жыл бұрын
@@omkarmemane5737 To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt
@abdulrahmanmoughalless23062 жыл бұрын
thanx a lot
@freshprinceofsolair4 жыл бұрын
how do you get the length of the video file as well? when i type LENGTH it says unknown column
@MichaelDewTechTips4 жыл бұрын
Did you try "System.Media.Duration" as per the earlier comment?
@vaggeto3 жыл бұрын
Hello! When I check their documentation and website, it shows far less column choices than you have in the description. Do you know specifically where the full list can be found? I'm specifically trying to find size on disk vs just size, since it my case I have some files that are corrupted and their size vs size on disk is much different and this tool might help me identify the files I need to correct. Thanks!
@MichaelDewTechTips3 жыл бұрын
To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt
@vaggeto3 жыл бұрын
@@MichaelDewTechTips awesome, thank you so much that will be really helpful! I also found size in disk as system.fileallocationsize in the msdn website.
@weiheon3 жыл бұрын
This is very helpful, but i couldn't find the attribute code to output the number of pages. Is there a way to do that?
@MichaelDewTechTips3 жыл бұрын
You could try System.Document.PageCount, but it may not extract page data from all document types.
@weiheon3 жыл бұрын
@@MichaelDewTechTips It worked brilliantly! Thanks for the tip Mike.
@roofbolt13 жыл бұрын
Great video. But I would also like to capture the list of folders names not only file names. How do I do that?
@MichaelDewTechTips3 жыл бұрын
The folder names are in the "Full path" column, see 6:15 in the video. You can separate that data out using "text to columns" with backslash as the delimeter.
@roofbolt13 жыл бұрын
@@MichaelDewTechTips I was hoping to get the folder names as separate rows because I am interested in the owner or creator of the folder.
@MichaelDewTechTips3 жыл бұрын
@@roofbolt1 As per the list in the description to the video, you can also use add "System.ItemFolderNameDisplay" to the command to output the folder names.
@paulshapiro61192 жыл бұрын
Is there anyway to include the date files were moved into the current folder location (e.g. the indexed folder) as one of the metadata captured?
@MichaelDewTechTips2 жыл бұрын
The "Date Created" data point (as distinct from "Date Modified") is typically the time that the file was created in the current location i.e. "date modified" is when the file contents were modified, and "date created" is when this copy in this folder was created. So you could just pull out date created data.
@paulshapiro61192 жыл бұрын
@@MichaelDewTechTips This is great because I inadvertantly initiated moving a bunch of files between two folders each of which also already had a bunch of files. I stopped the transfer but some files moved. Your strategy above will allow me to identify which files were moves last Tuesday. Thanks!!!!
@MichaelDewTechTips2 жыл бұрын
@@paulshapiro6119 you could also just add the "date created" field to the display of Windows Explorer (right click on the headings and then add that field) and then sort by that column directly in windows explorer by double clicking on the column heading i.e. may not need to export the data to achieve your current goal
@TechWorldTut4 жыл бұрын
I want to extract multiple video duration from file explorer.
@MichaelDewTechTips4 жыл бұрын
Did you try putting the variable System.Media.Duration into the string of code?
@wfh_millenial4 жыл бұрын
Thanks for the informative video. I want to extract the metadata under columns “Tags”, is this possible here?
@MichaelDewTechTips4 жыл бұрын
Try adding the command "System.Keywords" into the string of data to extract. To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt
@aubrey750924 жыл бұрын
@@MichaelDewTechTips THIS was the command I was searching for. I now have the necessary tools to really use this application. Thanks for the video and THANKS for this post. Tremendously useful.
@alkasharma50454 жыл бұрын
Thanks for the tutorial. Is it possible to use it without pasting the exe file in the same folder? I mean, keeping the exe file in a separate folder and extracting the metadata of a separate folder. Not having to paste the exe in a folder every time you have to extract data? Thanks in advance.
@MichaelDewTechTips4 жыл бұрын
No, I think that every time you have to put the .exe file in the top level of the folder of the folder tree you want to extract the data from. You could use a macro to write in the file into the necessary folder and then delete it out afterwards, but that requires some complex macros
@alkasharma50454 жыл бұрын
@@MichaelDewTechTips Thanks for your reply :-) I checked some videos on YT showing how two commands can be run in CMD. Can something like that be done running the exe from a different location?
@MichaelDewTechTips4 жыл бұрын
@@alkasharma5045 Sorry, not sure, I am not an expert on the command line!
@alkasharma50454 жыл бұрын
@@MichaelDewTechTips No worries. Thanks for this video. It is of great help.
@Anisotropy.A4 жыл бұрын
@@alkasharma5045 Google "windows 10 path variable" and add FileList.exe
@kennethschriever98204 жыл бұрын
Anyone know what's the command line for exporting the bitrate from a mp3 file (using "FileList")?
@juanavendano65524 жыл бұрын
System.Audio.EncodingBitrate
@kennethschriever98204 жыл бұрын
THANKS! That worked.
@BigBeezy3 жыл бұрын
cannot use this for a network drive
@MichaelDewTechTips3 жыл бұрын
I believe you can, but at the dos prompt you first need to change to the network drive using the cd command
@tamiascales88915 жыл бұрын
Using an external software is the only way to do this?
@MichaelDewTechTips5 жыл бұрын
It may be that if one knows the commands to put into the command line you could do it directly and without third party software, but the software works so well, and is free, and is the best option I am aware of.
@waynelfuller49 Жыл бұрын
It's frustrating that I always seem to need 3rd party software to do these things. If the 3rd party can do this, why can't I?
@Hanstein.6 ай бұрын
Yeah. Tell me when you have the solutions that doesn't require 3rd party malware
@acttony3 жыл бұрын
didnt work for me, it says length is an unknown column
@MichaelDewTechTips3 жыл бұрын
It seems you have tried to include an additional file attribute of "length", but that is not a proper attribute and may be why you are getting an error. See list of permitted attributes in the video description.
@acttony3 жыл бұрын
@@MichaelDewTechTips Thank you I figured it out, it's working now
@markrickert90404 жыл бұрын
Nice, but it seems the JAM software has limited capacity, particularly about 1kb of data then cuts off any more file data from being retrieved, second it seems that it doesn't retrieve all property data just selected data, most importantly for me the "tags" and "comments" data is not retrieved. Otherwise the video and the original one were vary useful, thank you.
@MichaelDewTechTips4 жыл бұрын
Interesting, I have never found JAM software to cut off file data, even when running it on thousands of files, but perhaps your file data was more detailed that what I have used it for. I have never tried to retrieve tags or comments, but as per the instructions for that software in the help file you can modify the columns of the output table, so it may be that you just have to change the code to make it spit out that additional data. To get a full list of all of the metadata variables that could be pulled from various types of files (i.e. a full list of supported shell columns), you can use the “/PRINTSHELLCOLUMNLIST” parameter i.e. put FileList.exe in a folder and then change to that directory on the command line and then run the following command on the command line: FileList.exe /PRINTSHELLCOLUMNLIST > outputmike.txt It seems to me that comments and tags are both on the list i.e. System.Comment and System.Keywords, but it may be those commands will not actually extract what you are looking for...
@tn25mfan4 жыл бұрын
I would love to know how to show the comment data as well because that's where I enter GPS coordinates. Please reply here if anyone figures out how to do this! Thanks!
@patriciagregg4454 жыл бұрын
@@MichaelDewTechTips System.Comment worked! Thank you so much for the video and comment!
@evrentuskan4 жыл бұрын
System.Keywords; for "tags" System.Comment; for "comments" both can be retrieved
@generalbarry2 жыл бұрын
Microsoft Windows [Version 10.0.19043.1348] (c) Microsoft Corporation. All rights reserved. C:\Users\ME>I:\MUSIC STORAGE FILES 'I:\MUSIC' is not recognized as an internal or external command, operable program or batch file. C:\Users\ME> OK, what am I doing wrong?
@kishorekumarjonnalagadda77972 жыл бұрын
Hi Mike, This video really helps to extract metadata of huge volumes of files. Could you please help me how I can list folder name of each file into a column. for example , my file system is like saving employees personal docs. each folder name is employee id. So I wanted to list down the employee ids as well with the filenames. 1234 --> identity.doc 5678 --> passport.doc The above two folders 1234 and 5678 exists as follows E:\files\1234\identity.doc and E:\files\5678\passport.doc
@MichaelDewTechTips2 жыл бұрын
If you are able to get the data into excel (although it sounds like it may be too much data for excel to manage) you should be able to create a column that lists just the folder names using regular excel functionality e.g. mid, left, right, formulas, or use "text to columns" tool on the data tab of the ribbon and separate by backslash.
@emn8or Жыл бұрын
Thanks for this Michael. I've found it useful but not having much luck applying it to my needs. I followed your video and copied the commands with success. But I need to get a list of mp4 files in a directory including their files name and length (in hh:mm:ss) as listed in the "length column in windows. And I saw the entry you made for length as Length - System.Media.Duration. What command do i need for this? I thought it would be "FileList.exe /USECOLUMNS NAME,FULLPATH,EXTENSION,LENGTH,System.Media.Duration > test1.txt" but I get the error " Error 3: The system cannot find the path specified: NAME,FULLPATH,EXTENSION,LENGTH,System.Media.Duration" Any tips please?
@MichaelDewTechTips Жыл бұрын
Are you sure you have the file Filelist.exe in the same folder as containing the files that you want to extract the data from? Have you been able to extract duration information from any mp4 files? I confirm that I have been able to extract duration data from mp4 files (although not all mp4 files have that data available).
@emn8or Жыл бұрын
Hi @MichaelDewTechTips thanks for your prompt reply. Yes, the .exe file is in the same directory and I have been able to extract other info as per your example, but when I add the length command, I get those errors as listed. The mp4 files definately do have info of their duration in the windows explorer culumn. I just ried agin by leaving out the word "LENGTH" and using the command FileList.exe /USECOLUMNS NAME,FULLPATH,EXTENSION,System.Media.Duration > test1.txt My example mp4 files were this time 3 files 60secs, 90secs and 120 secs long. And I do get a workable result now of "Name","Full Path","Extension","Length" "01=060secs.mp4","C:\Transfers\test\01=060secs.mp4",".mp4","600110000" "02=090secs.mp4","C:\Transfers\test\02=090secs.mp4",".mp4","900060000" "03=120secs.mp4","C:\Transfers\test\03=120secs.mp4",".mp4","1200000000" So it does work now but only when I omit "LENGTH" and gives me a value of length with a lot of traling numbers. (ie the 60 sec file reads "600110000"). I guess I can use this and omit the trailing digits in Excel unless I can come up with a betther solution. Thanks again for your assistance.
@gregorywkent4 жыл бұрын
Thanks for this. I'm looking to pull this information for audio files and am looking to include the 'title' and '#' columns. How would you account for that in the code?
@MichaelDewTechTips4 жыл бұрын
Try "Title - System.Title", see also the video description and the FileList user documentation.
@gregorywkent4 жыл бұрын
@@MichaelDewTechTips Apologies, missed the list in the description. Worked like a charm, thank you.