Generate List of Files in Folder

Question

I need to create a workflow that will generate a list of files in a given filepath (ex. C:\My Documents) that gives me the full file path, file name, extension, and size at minimum. I'd also like to be able to retrieve, if possible, original creator and last date modified.

I need to be able to change the file path as needed, and generate an output that can then be utilized in both statistics and metadata review/extrapolation for other projects.

I've played around with a few options, but haven't found the right combination. Any ideas?

jrkmorgan · Answer

I finally have a great workflow going - next concern is how to output the error log as a tab in the excel output file - for all the files/folders that were not readable/convertable/etc. so that we can address them.

I've spent the last two hours searching and reading different threads on how to output an error log to excel with no luck. A few links were archived and I couldn't access the pages any longer. Others, I do not have the folders mentioned in my "program folders" file to access.

Ideas?

binu_acs · Answer

@jrkmorgan use the FileGetExt() function to get the file extension

jrkmorgan · Answer

Yes, but I'm struggling with how to get metadata, if I can, showing creator, last modified date, and extension. I need the file extension parsed from the full path and haven't hit upon the right combination of tools yet to achieve my end goal.