The ability to export file metadata (I'm working with music files currently) for a file, a folder of files, or multiple folders of files. User-selectable fields to export, and in the order the user wants them exported. Delimiter specified by the user. (See Windows music rip options for naming the ripped file for how the field selection and ordering could work easily).
I'm going to search the web for a utility or program to export the metadata from FLAC files. I want to put the data in a spreadsheet and sort on the fields and add my own fields/notes--a kind of index, or directory, if you will.
Did you check the "Tools -> Print / Export.." function?
It does not support custom delimiters and field size is fixed, but it is quite near to a proper csv export.
As tbone says, Tools -> Print / Export is the way to do that already.
Small correction: Field size is unlimited when using .CSV output, which is definitely what you want for a spreadsheet. It'll go as wide as needed. (Or, if there is a limit, it's very large. )
It's only when outputting plain text (.TXT) that field sizes are fixed (to whatever widths you configure).
That's close! Even if there was just an optioin for a tab separator, instead of a user-chosen separator, that would make the export workable so that the exported data could be easily parsed or imported into a spreadsheet or other program. It would be nice to be able to save export settings also.
I don't understand what the user-specified width is doing. I expected the fields to be padded-out with spaces to the specified width. But, I don't need the width specification at all--I just need all the data in the field with a tab separator after each field (except the last field).
The filename is not removable (no big deal), but I don't need the filename in the export so I'm thinking that it should be a removable field.
[quote="TechTony"]That's close! Even if there was just an optioin for a tab separator, instead of a user-chosen separator, that would make the export workable so that the exported data could be easily parsed or imported into a spreadsheet or other program. It would be nice to be able to save export settings also.
I don't understand what the user-specified width is doing. I expected the fields to be padded-out with spaces to the specified width. But, I don't need the width specification at all--I just need all the data in the field with a tab separator after each field (except the last field).
The filename is not removable (no big deal), but I don't need the filename in the export so I'm thinking that it should be a removable field.[/quote]
Funny, I actually selected "tab-Separated List" in the drop-down, and ... well nevermind the previous post quoted above (except for saving of export settings and removeable filename)!
If you don't need the filename in the csv..
You can probably remove it with a small powershell script, which you run from a button afterwards when needed:
Yes, you can do that manually of course. I was just trying to give an automatic solution to help you around the problem of the unwanted name column. If you create a button similar to this, you can create a csv-export with one click. It always skips/removes the first column visible.
@nofilenamequoting
@set filePath={sourcepath$}\foldercontent.csv
Print FOLDER "{sourcepath$}" TO "{$filePath}" AS=csv ENCODING=utf8
Powershell.exe -command "$csv=import-csv '{$filePath}'; $i=$csv[0].psobject.properties | select -expandproperty Name -skip 1; $csv | select $i | export-csv '{$filePath}' -notypeinformation"
Consider adding the QUIET switch in the "Print FOLDER" line, maybe it works for you.
The button should not bring a dialog at all with it. For some yet unknown reason the QUIET switch fails for me.
)