Today is Sunday, November 30, 2014, so that means tomorrow is my target date for being "done" with the reconversion of my CDs to MP3. I have 7,115 files that I believe are duplicates. When I just ran my MS DOS batch file, it gave me 72633 File(s) as a total number of music files. If all of those 7115 are, indeed, duplicates, that puts my total music collection at 65518.
HOWEVER....
I am not going to finish converting the ~100 CDs I have to enter manually. For weeks, those CDs have been a low priority. As my deadline looms, a part of me wonders whether I should have started with them, instead of the ones I could do quickly and without manually entering artist and other song information. I can't go back in time.
I also don't know if I'll have any more time to write blog posts today as it's 9:25 AM, I have to shower and be ready to leave for Mass with Megan. The youth group is singing today; I'm hoping to play drums.
Showing posts with label 2014_11_Conversion Projects. Show all posts
Showing posts with label 2014_11_Conversion Projects. Show all posts
Sunday, November 30, 2014
Saturday, November 22, 2014
Converting Resumes
I am looking at needing to eliminate 14, 961 duplicate files from my music folders. Previously, I mentioned that I had approximately 200 CDs remaining to convert. While I work on weeding out duplicates, I have the Toshiba laptop ripping CDs. It's kind of fun as I am ripping Life CDs and while the CD rips, the CD is played so I get to listen to music. The Eagles are playing the acoustic version of "Hotel California" with that awesome percussion groove under the acoustic guitar.
Sunday, November 16, 2014
Consolidating Madness
I'm pulling music files from the My Cloud drive into my master folder structure on the external hard drive in an effort to weed out duplicates. In doing so, I feel like I'm doing the same work over and over because I think I've done exactly the same type of merging previously. For example, in the folder structure where the .txt files for my MS DOS files are stored, my code used to put the day in front of the month as in creating a folder for December 5, 2013 in this format: 2013_05_12. At some time in the reconversion, I decided to change the code for my folders to be in this format: 2013_12_05. I'm not sure if one is better than the other, but that's what I did. This means that when I merge these .txt files into the "master" folder structure, I have both folders:
2013_05_12 <-- old format
2013_12_05 <-- new format
My methodology is to rename 2013_05_12 to 2013_12_05 and, of course, that means I end up with (2) files in that folder structure (Windows' way of saying that there is a second file with the same name). I do have a separate MS DOS batch file that deletes all my duplicate files as it looks for files named *(2).* through *(40).* and deletes them without manual intervention.
On the same subject as changing my MS DOS batch file code, I just made a change to the code to include the current date in the file name that is created. I don't know why I waited until now, when I'm nearly done with the reconversion, to do this except to say that I never thought of it until this morning. Here's the revised code:
|
REM | 20131230
REM | Create date folder
cd\
f:
cd f:\music_shell
cd f:\music_shell\(_______Date
SET Today=%Date:~10,4%_%Date:~4,2%_%Date:~7,2%
mkdir %today%
REM | Begin commands for the entire music_shell folder
cd\
f:
cd music_shell
dir F:\music_shell\*.flv *.mp4 *.web* /s /od >f:\music_shell\(_______Date\%today%\%today%_videofiles_music_shell_2TB.txt
dir F:\music_shell\*___* *-* *_* *___* *--* /s /od >f:\music_shell\(_______Date\%today%\%today%_needtofix_music_shell_2TB.txt
dir F:\music_shell\a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z* >f:\music_shell\(_______Date\%today%\%today%_allfolders_music_shell_2TB.txt
dir F:\music_shell\*.mp3 *.wav *.wma /s /od>f:\music_shell\(_______Date\%today%\%today%_mostrecentcount_music_shell_2TB.txt
REM | Begin commands for the music_reconversion folder
cd\
f:
cd Music_shell\music_reconversion_E_DR
dir F:\Music_shell\music_reconversion_E_DR\*.mp3 *.wav *.wma /s /od>f:\music_shell\(_______Date\%today%\%today%_mostrecentcount_Music_reconversion_2TB.txt
dir F:\Music_shell\music_reconversion_E_DR\*.flv *.mp4 *.web* /s /od>f:\music_shell\(_______Date\%today%\%today%_videofiles_Music_reconversion_2TB.txt
dir F:\Music_shell\music_reconversion_E_DR\*___* *-* *_* *___* *--* /s /od >f:\music_shell\(_______Date\%today%\%today%_needtofix_Music_reconversion_2TB.txt
dir F:\Music_shell\music_reconversion_E_DR\a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z* >f:\music_shell\(_______Date\%today%\%today%_allfolders_Music_reconversion_2TB.txt
cd\
f:
cd music_shell
dir *.* /s >f:\music_shell\(_______Date\%today%\%today%_allfiles_Music_shell_2TB.txt
cd\
dir *.* /s >f:\music_shell\(_______Date\%today%\%today%_allfiles_2TB.txt
|
The result of this code is the date is in the file name. Yesterday, I had files like this:
Directory of F:\Music_shell\(_______Date\2014_11_15
11/15/2014 03:59 PM 18,467,635 allfiles_2TB.txt
11/15/2014 03:58 PM 9,080,126 allfiles_Music_shell_2TB.txt
11/15/2014 03:58 PM 170,902 allfolders_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 1,115 allfolders_music_shell_2TB.txt
11/15/2014 03:57 PM 6,914,594 mostrecentcount_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 6,914,594 mostrecentcount_music_shell_2TB.txt
11/15/2014 03:58 PM 8,158,170 needtofix_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 8,497,847 needtofix_music_shell_2TB.txt
11/15/2014 03:57 PM 2,021 videofiles_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 2,021 videofiles_music_shell_2TB.txt
|
and today, the same code I run gives me this:
|
Directory of F:\Music_shell\(_______Date\2014_11_16
11/16/2014 08:05 AM 22,781,984 2014_11_16_allfiles_2TB.txt
11/16/2014 08:05 AM 13,390,516 2014_11_16_allfiles_Music_shell_2TB.txt
11/16/2014 08:05 AM 170,900 2014_11_16_allfolders_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 1,115 2014_11_16_allfolders_music_shell_2TB.txt
11/16/2014 08:04 AM 6,943,576 2014_11_16_mostrecentcount_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 9,425,363 2014_11_16_mostrecentcount_music_shell_2TB.txt
11/16/2014 08:05 AM 8,181,281 2014_11_16_needtofix_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 12,033,726 2014_11_16_needtofix_music_shell_2TB.txt
11/16/2014 08:04 AM 2,021 2014_11_16_videofiles_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 4,922 2014_11_16_videofiles_music_shell_2TB.txt
|
Just another way that I geek out when I write MS DOS code!
2013_05_12 <-- old format
2013_12_05 <-- new format
My methodology is to rename 2013_05_12 to 2013_12_05 and, of course, that means I end up with (2) files in that folder structure (Windows' way of saying that there is a second file with the same name). I do have a separate MS DOS batch file that deletes all my duplicate files as it looks for files named *(2).* through *(40).* and deletes them without manual intervention.
On the same subject as changing my MS DOS batch file code, I just made a change to the code to include the current date in the file name that is created. I don't know why I waited until now, when I'm nearly done with the reconversion, to do this except to say that I never thought of it until this morning. Here's the revised code:
|
REM | 20131230
REM | Create date folder
cd\
f:
cd f:\music_shell
cd f:\music_shell\(_______Date
SET Today=%Date:~10,4%_%Date:~4,2%_%Date:~7,2%
mkdir %today%
REM | Begin commands for the entire music_shell folder
cd\
f:
cd music_shell
dir F:\music_shell\*.flv *.mp4 *.web* /s /od >f:\music_shell\(_______Date\%today%\%today%_videofiles_music_shell_2TB.txt
dir F:\music_shell\*___* *-* *_* *___* *--* /s /od >f:\music_shell\(_______Date\%today%\%today%_needtofix_music_shell_2TB.txt
dir F:\music_shell\a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z* >f:\music_shell\(_______Date\%today%\%today%_allfolders_music_shell_2TB.txt
dir F:\music_shell\*.mp3 *.wav *.wma /s /od>f:\music_shell\(_______Date\%today%\%today%_mostrecentcount_music_shell_2TB.txt
REM | Begin commands for the music_reconversion folder
cd\
f:
cd Music_shell\music_reconversion_E_DR
dir F:\Music_shell\music_reconversion_E_DR\*.mp3 *.wav *.wma /s /od>f:\music_shell\(_______Date\%today%\%today%_mostrecentcount_Music_reconversion_2TB.txt
dir F:\Music_shell\music_reconversion_E_DR\*.flv *.mp4 *.web* /s /od>f:\music_shell\(_______Date\%today%\%today%_videofiles_Music_reconversion_2TB.txt
dir F:\Music_shell\music_reconversion_E_DR\*___* *-* *_* *___* *--* /s /od >f:\music_shell\(_______Date\%today%\%today%_needtofix_Music_reconversion_2TB.txt
dir F:\Music_shell\music_reconversion_E_DR\a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z* >f:\music_shell\(_______Date\%today%\%today%_allfolders_Music_reconversion_2TB.txt
cd\
f:
cd music_shell
dir *.* /s >f:\music_shell\(_______Date\%today%\%today%_allfiles_Music_shell_2TB.txt
cd\
dir *.* /s >f:\music_shell\(_______Date\%today%\%today%_allfiles_2TB.txt
|
The result of this code is the date is in the file name. Yesterday, I had files like this:
Directory of F:\Music_shell\(_______Date\2014_11_15
11/15/2014 03:59 PM 18,467,635 allfiles_2TB.txt
11/15/2014 03:58 PM 9,080,126 allfiles_Music_shell_2TB.txt
11/15/2014 03:58 PM 170,902 allfolders_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 1,115 allfolders_music_shell_2TB.txt
11/15/2014 03:57 PM 6,914,594 mostrecentcount_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 6,914,594 mostrecentcount_music_shell_2TB.txt
11/15/2014 03:58 PM 8,158,170 needtofix_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 8,497,847 needtofix_music_shell_2TB.txt
11/15/2014 03:57 PM 2,021 videofiles_Music_reconversion_2TB.txt
11/15/2014 03:57 PM 2,021 videofiles_music_shell_2TB.txt
|
and today, the same code I run gives me this:
|
Directory of F:\Music_shell\(_______Date\2014_11_16
11/16/2014 08:05 AM 22,781,984 2014_11_16_allfiles_2TB.txt
11/16/2014 08:05 AM 13,390,516 2014_11_16_allfiles_Music_shell_2TB.txt
11/16/2014 08:05 AM 170,900 2014_11_16_allfolders_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 1,115 2014_11_16_allfolders_music_shell_2TB.txt
11/16/2014 08:04 AM 6,943,576 2014_11_16_mostrecentcount_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 9,425,363 2014_11_16_mostrecentcount_music_shell_2TB.txt
11/16/2014 08:05 AM 8,181,281 2014_11_16_needtofix_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 12,033,726 2014_11_16_needtofix_music_shell_2TB.txt
11/16/2014 08:04 AM 2,021 2014_11_16_videofiles_Music_reconversion_2TB.txt
11/16/2014 08:04 AM 4,922 2014_11_16_videofiles_music_shell_2TB.txt
|
Just another way that I geek out when I write MS DOS code!
Wednesday, November 12, 2014
Reconverting Continues
Speaking of my CD Reconversion project, I see this number as my total from running the MS DOS batch file: 64876 File(s)
My self-imposed deadline for being complete is looming - Monday, December 1, 2014 - and I still have ~200 CDs to go. These are the lowest of the low priorities:
My self-imposed deadline for being complete is looming - Monday, December 1, 2014 - and I still have ~200 CDs to go. These are the lowest of the low priorities:
- ~100 CDs I received while I was writing CD reviews that must have the basic information - track number, artist, album, & song title - entered manually. That means that converting these CDs is more time consuming than a commercially available CD. For those CDs, Windows Media Player automatically looks up that information and applies it to the files as they are created on my hard drive.
- ~100 CDs are CDs I created that are mainly mix CDs, such as my Life CD series that I've described elsewhere on this blog. The same type of work must be done for these CDs but the challenge for this group is that I sometimes put a song on a Life CD that I liked at the time, but I have since forgotten the name of the band. I probably thought I'd never forget the band / CD when I created the CD but guess what? I have. Thus, I have to piece together who the band is and what song it is. To that end, I have a freeware installed that will allow me to search for songs by song length, which I plan to use when I get around to entering the information for these CDs.
Dipping a Toe into a New Adventure Pool
I've increasingly become interested in programming. No, I don't want to sit and write code for software all day, but writing code for doing what I want to do automatically has increased its appeal. For example, I started out being interested in finding a way to find out if I'm missing songs in the CD reconversion. The first thing I thought about is finding a way to flag a directory if I have files like this:
01_MP3_File.mp3
03_MP3_File.mp3
04_MP3_File.mp3
where I'm missing 02_MP3_File.mp3. I talked to my friend Chris about it and he brought up some logical points regarding how - we referred to it as "the thing" - the thing would know how many songs should be there. I had started with the idea that the thing would count down from 99 through 0 and if it found a missing number, it would spit out the directory into a log file of some sort.
Eventually that evolved into a way to extract the Windows Media Player (WMP) database into an Excel file. There is supposed to be a way to do so, using a Microsoft "Winter Fun" package from 2003, but in order to install it on Windows 7, which I have on my work laptop as well as at home, you have to delete a specific folder in a specific path. I haven't been successful in being able to do that on either device.
The other day, I sent this email to Chris:
Is there a way to take this code and bring over ‘all’ of the columns that are in a WMP database?
I got the original code here & tried to do it, but I’m lost.
|
Set objPlayer = CreateObject("WMPlayer.OCX" )
Set objMediaCollection = objPlayer.MediaCollection
Set colSongList = objMediaCollection.getByAttribute("MediaType", "Audio")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Add()
Set objWorksheet = objWorkbook.Worksheets(1)
objWorksheet.Cells(1,1) = "Track Number"
objWorksheet.Cells(1,2) = "Title"
objWorksheet.Cells(1,3) = "Artist"
objWorksheet.Cells(1,4) = "Album"
objWorksheet.Cells(1,5) = "Length"
objWorksheet.Cells(1,6) = "Genre"
objWorksheet.Cells(1,7) = "Times Played"
objWorksheet.Cells(1,8) = "Contributing Artist"
j = 2
For i = 0 to colSongList.Count - 1
Set objSong = colSongList.Item(i)
objWorksheet.Cells(j,1) = objSong.getItemInfo("WM/TrackNumber")
objWorksheet.Cells(j,2) = objSong.getItemInfo("Name")
objWorksheet.Cells(j,3) = objSong.getItemInfo("WM/AlbumArtist")
objWorksheet.Cells(j,4) = objSong.getItemInfo("WM/AlbumTitle")
objWorksheet.Cells(j,5) = objSong.durationString
objWorksheet.Cells(j,6) = objSong.getItemInfo("Genre")
objWorksheet.Cells(j,7) = objSong.getItemInfo("UserPlayCount")
objWorksheet.Cells(j,8) = objSong.getItemInfo("WM/ContributingArtist")
j = j + 1
Next
Set objRange = objWorksheet.UsedRange
objRange.Columns.AutoFit()
|
And he just wrote back this:
Yeah, the manual of how is here:
http://msdn.microsoft.com/en-us/library/ee487074(v=winembedded.70).aspx
So you would first call getAttributeCount() to get the count, then pass the numbers in to the function that tells you the names, then use those names to fill in the lines you have below such as objSong.getItemInfo("Name”) where “Name” would be replaced with the names you got back from the function.
Hopefully that makes sense.
It's 6:30 AM and my Mountain Dew is just beginning to hit my system. It doesn't make sense yet!
01_MP3_File.mp3
03_MP3_File.mp3
04_MP3_File.mp3
where I'm missing 02_MP3_File.mp3. I talked to my friend Chris about it and he brought up some logical points regarding how - we referred to it as "the thing" - the thing would know how many songs should be there. I had started with the idea that the thing would count down from 99 through 0 and if it found a missing number, it would spit out the directory into a log file of some sort.
Eventually that evolved into a way to extract the Windows Media Player (WMP) database into an Excel file. There is supposed to be a way to do so, using a Microsoft "Winter Fun" package from 2003, but in order to install it on Windows 7, which I have on my work laptop as well as at home, you have to delete a specific folder in a specific path. I haven't been successful in being able to do that on either device.
The other day, I sent this email to Chris:
Is there a way to take this code and bring over ‘all’ of the columns that are in a WMP database?
I got the original code here & tried to do it, but I’m lost.
|
Set objPlayer = CreateObject("WMPlayer.OCX" )
Set objMediaCollection = objPlayer.MediaCollection
Set colSongList = objMediaCollection.getByAttribute("MediaType", "Audio")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Add()
Set objWorksheet = objWorkbook.Worksheets(1)
objWorksheet.Cells(1,1) = "Track Number"
objWorksheet.Cells(1,2) = "Title"
objWorksheet.Cells(1,3) = "Artist"
objWorksheet.Cells(1,4) = "Album"
objWorksheet.Cells(1,5) = "Length"
objWorksheet.Cells(1,6) = "Genre"
objWorksheet.Cells(1,7) = "Times Played"
objWorksheet.Cells(1,8) = "Contributing Artist"
j = 2
For i = 0 to colSongList.Count - 1
Set objSong = colSongList.Item(i)
objWorksheet.Cells(j,1) = objSong.getItemInfo("WM/TrackNumber")
objWorksheet.Cells(j,2) = objSong.getItemInfo("Name")
objWorksheet.Cells(j,3) = objSong.getItemInfo("WM/AlbumArtist")
objWorksheet.Cells(j,4) = objSong.getItemInfo("WM/AlbumTitle")
objWorksheet.Cells(j,5) = objSong.durationString
objWorksheet.Cells(j,6) = objSong.getItemInfo("Genre")
objWorksheet.Cells(j,7) = objSong.getItemInfo("UserPlayCount")
objWorksheet.Cells(j,8) = objSong.getItemInfo("WM/ContributingArtist")
j = j + 1
Next
Set objRange = objWorksheet.UsedRange
objRange.Columns.AutoFit()
|
And he just wrote back this:
Yeah, the manual of how is here:
http://msdn.microsoft.com/en-us/library/ee487074(v=winembedded.70).aspx
So you would first call getAttributeCount() to get the count, then pass the numbers in to the function that tells you the names, then use those names to fill in the lines you have below such as objSong.getItemInfo("Name”) where “Name” would be replaced with the names you got back from the function.
Hopefully that makes sense.
It's 6:30 AM and my Mountain Dew is just beginning to hit my system. It doesn't make sense yet!
Wednesday, November 5, 2014
Reconversion Continues
When I have time, I am working on cleaning up my music files. After running the DOS Batch file this morning, I have 79453 File(s). The capture below shows that I have at least 9174 files that are found when I use the following criteria:
01 *.*, 01-*.mp3, 02-*.mp3, 03-*.mp3, 04-*.mp3, 05-*.mp3, 06-*.mp3, 07-*.mp3, 08-*.mp3, 09-*.mp3. 10-*.mp3, 11-*.mp3, 12-*.mp3, 13-*.mp3, 14-*.mp3, 15-*.mp3, 16-*.mp3, 17-*.mp3, 18-*.mp3, 19-*.mp3, 20-*.mp3, 21-*.mp3, 22-*.mp3, 23-*.mp3, 24-*.mp3, 25-*.mp3, 26-*.mp3, 27-*.mp3, 28-*.mp3, 29-*.mp3. 30-*.mp3, 31-*.mp3, 32-*.mp3, 33-*.mp3, 34-*.mp3, 35-*.mp3, 36-*.mp3, 37-*.mp3, 38-*.mp3, 39-*.mp3, 40-*.mp3
My reason for finding these files is that my naming convention is to use an underscore (_) after the track number instead of a space ( ) or dash (-). I'm trying to make all of my files follow the same naming convention.
01 *.*, 01-*.mp3, 02-*.mp3, 03-*.mp3, 04-*.mp3, 05-*.mp3, 06-*.mp3, 07-*.mp3, 08-*.mp3, 09-*.mp3. 10-*.mp3, 11-*.mp3, 12-*.mp3, 13-*.mp3, 14-*.mp3, 15-*.mp3, 16-*.mp3, 17-*.mp3, 18-*.mp3, 19-*.mp3, 20-*.mp3, 21-*.mp3, 22-*.mp3, 23-*.mp3, 24-*.mp3, 25-*.mp3, 26-*.mp3, 27-*.mp3, 28-*.mp3, 29-*.mp3. 30-*.mp3, 31-*.mp3, 32-*.mp3, 33-*.mp3, 34-*.mp3, 35-*.mp3, 36-*.mp3, 37-*.mp3, 38-*.mp3, 39-*.mp3, 40-*.mp3
My reason for finding these files is that my naming convention is to use an underscore (_) after the track number instead of a space ( ) or dash (-). I'm trying to make all of my files follow the same naming convention.
Saturday, November 1, 2014
Conversioning Update
I am continuing my work on eliminating misnamed music files.
Editor's Note: There was a graphic, but it has disappeared.
Editor's Note: There was a graphic, but it has disappeared.
Subscribe to:
Posts (Atom)