So I'm trying to consolodate a few external HDs down this new 1.5TB drive. This drive is going to be the primary home for all the MP3 files
I managed to figure this out once but cant recall how I did it last time, though I do recall it being major PITA. The question is does anyone know how to get a directory listing output in a way that it easily imports into a spreadsheet? I'd like to include genre, artist, bit rate, folder name, tracks, etc in the output.
I figured out how to get it to do some of that, though its not the best for importing using the dir command and passing some variables.
dir /ON /S >allmp3s.txt but this does not give me what I need. Anyone know how to get the list in a comma/tab seperated format with all the attributes for the file?
To give you an idea of what we are talkin about here, I'm consolodating 5 external drives into the one... the folder structure for the most part is matching up but I'm still working to marry them. This snapshot is only about 5/8s of the way done combining them, so finding an automated way to catalog them would be um... huge lease:
I should mention that this is all physical CD RIPS with a very limited number of "mixes" done by my DJ friends. Its the digital, offsite backup for these professional DJ friends, ya know, just in case they were to loose those bohemouth heavy anus metal cd cases that BigD hates carrying into clubs
I managed to figure this out once but cant recall how I did it last time, though I do recall it being major PITA. The question is does anyone know how to get a directory listing output in a way that it easily imports into a spreadsheet? I'd like to include genre, artist, bit rate, folder name, tracks, etc in the output.
I figured out how to get it to do some of that, though its not the best for importing using the dir command and passing some variables.
dir /ON /S >allmp3s.txt but this does not give me what I need. Anyone know how to get the list in a comma/tab seperated format with all the attributes for the file?
To give you an idea of what we are talkin about here, I'm consolodating 5 external drives into the one... the folder structure for the most part is matching up but I'm still working to marry them. This snapshot is only about 5/8s of the way done combining them, so finding an automated way to catalog them would be um... huge lease:
I should mention that this is all physical CD RIPS with a very limited number of "mixes" done by my DJ friends. Its the digital, offsite backup for these professional DJ friends, ya know, just in case they were to loose those bohemouth heavy anus metal cd cases that BigD hates carrying into clubs