Showing posts with label Ripping CDs to MP3. Show all posts

Thursday, July 17, 2025

Renaming MP3s with Excel

In Google.com, I entered the following: "rename mp3 files excel macro" and this is what was generated.

To rename MP3 files using an Excel macro, you can create a macro that reads old and new filenames from two columns in Excel and then uses the Name statement in VBA to rename the files. The macro will iterate through each row in your Excel sheet, taking the old filename from one column and the new filename from another, and then rename the corresponding file in the specified folder. [1, 2]
Sub RenameMP3Files()

  Dim Source As Range
  Dim OldFile As String
  Dim NewFile As String
  Dim FolderPath As String
  Dim Row As Long

  ' Set the folder path where the MP3 files are located
  FolderPath = "C:\Path\To\Your\MP3\Folder\" ' <<--- CHANGE THIS!

  ' Define the range in Excel containing the old and new filenames
  Set Source = Cells(1, 1).CurrentRegion ' Assumes data starts at A1

  ' Loop through each row in the specified range
  For Row = 1 To Source.Rows.Count
    ' Get the old and new filenames from the Excel sheet
    OldFile = FolderPath & Source.Cells(Row, 1).Value ' Assumes old filenames are in column A
    NewFile = FolderPath & Source.Cells(Row, 2).Value ' Assumes new filenames are in column B

    ' Check if the old file exists
    If Dir(OldFile) <> "" Then
        ' Rename the file using the VBA Name statement
        Name OldFile As NewFile
    Else
        ' Handle the case where the old file doesn't exist
        MsgBox "File not found: " & OldFile
    End If

  Next Row

  MsgBox "File renaming process completed."

End Sub
Explanation:
Sub RenameMP3Files(): Defines the start of the macro.
FolderPath = "C:\Path\To\Your\MP3\Folder\": Important: Replace this with the actual path to the folder containing your MP3 files. Make sure the path is enclosed in quotes.
Set Source = Cells(1, 1).CurrentRegion: Defines the range of cells in your Excel sheet that contain the data for renaming. It assumes your data starts at cell A1 and extends to include all adjacent cells.
For Row = 1 To Source.Rows.Count: Loops through each row in the defined range.
OldFile = FolderPath & Source.Cells(Row, 1).Value: Constructs the full path for the old filename, retrieving the value from the first column (A) of the current row.
NewFile = FolderPath & Source.Cells(Row, 2).Value: Constructs the full path for the new filename, retrieving the value from the second column (B) of the current row.
If Dir(OldFile) <> "" Then: Checks if the old file actually exists in the specified folder.
Name OldFile As NewFile: Renames the file using the Name statement in VBA. This is the core renaming command.
Else: Handles the case where the old file does not exist.
MsgBox "File not found: " & OldFile: Displays a message box indicating the file was not found.
Next Row: Moves to the next row in the loop.
MsgBox "File renaming process completed.": Displays a message box when the macro finishes processing all files. [1, 3, 4, 5, 6, 7, 8]
How to use the macro:
Open your Excel workbook.
Open the VBA editor: Press Alt + F11.
Insert a new module: In the VBA editor, go to Insert > Module.
Paste the code: Paste the code into the module.
Modify the FolderPath: Change the FolderPath variable to point to the correct directory on your computer.
Prepare your Excel data: In your Excel sheet, make sure you have two columns: one with the old filenames and another with the new filenames.
Run the macro: Go back to your Excel sheet, and then in the VBA editor, press F5 or click the "Run" button (the green triangle) to execute the macro. [3, 9, 10, 11]
Important considerations:
File Paths: Ensure the file paths in your Excel sheet and the FolderPath variable are correct and that the files exist at those locations.

AI responses may include mistakes.
[1] https://stackoverflow.com/questions/7508605/renaming-files-with-excel-vba
[2] https://www.reddit.com/r/excel/comments/1aq38b4/looking_for_a_macro_that_can_copypasterename_the/
[3] https://stackoverflow.com/questions/63880958/rename-files-in-folder-separately-using-excel-vba-based-on-cell-value
[4] https://www.launchexcel.com/edit-macro-in-excel
[5] https://www.autohotkey.com/boards/viewtopic.php?t=131029
[6] https://www.mathworks.com/matlabcentral/answers/525854-rename-folders-using-excel-key
[7] https://www.youtube.com/watch?v=hQeKh2qKZlo
[8] https://answers.microsoft.com/en-us/msoffice/forum/all/rename-file-in-windows-exlorer-using-macro/fd96598c-32d9-4a1b-b00e-b451ab5958c1
[9] https://www.simonsezit.com/article/how-to-record-a-macro-in-excel/
[10] https://medium.com/@techwithjulles/automating-excel-backups-with-vba-a-step-by-step-guide-234251eae10f
[11] https://stackoverflow.com/questions/50881020/rename-files-using-list-in-excel

Thursday, August 3, 2023

Some MP3 Stats on my EHDs

dir e:\music\*(1).mp3 *(2).mp3 *(3).mp3 *(4).mp3 *(5).mp3 *(6).mp3 *(7).mp3 *(8).mp3 *(9).mp3 *(10).mp3 /s
59857 File(s) 745,987,570,580 bytes
0 Dir(s) 3,521,551,814,656 bytes free

dir e:\music\*.mp3 /s /os
562519 File(s) 6,446,132,042,260 bytes
0 Dir(s) 3,521,551,814,656 bytes free

dir i:\music-shell\*.mp3 /s
252482 File(s) 2,367,933,787,331 bytes
0 Dir(s) 7,220,252,672,000 bytes free

Wednesday, January 26, 2022

How to Clean Up a MP3 Mess

I'm still mucking around with my music files from the CD to MP3 project I began on 6-5-2016. It's unreal. I have so many messed up file names. For example,

03_Touché [Acoustic]-Acoustic_Godsmack_The Other Side.wma
03_Touché [Acoustic]_Godsmack_The Other Side_Stragglers.wma
03_Touché_Godsmack_The Other Side_Stragglers.wma

The problem? I want one file named the following:

03_Touche-Acoustic_Godsmack_The Other Side_40000.wma

My issues are as follows:

I don't want the é in the file name
I don't want the brackets
I want to use a dash to separate any information, such as if it's a live version of the tune or, in this case, if it's an acoustic version of the tune.
I don't want the word "Acoustic" both in and outside of the brackets
I don't want the _Stragglers at the end
I use the naming convention: TT_TI_AR_AL_CO

where

TT = Track Number
TI = Title
AR = Artist
AL = Album
CO = Composer

I actually use the "Composer" property to store the location. Where I want to end up is to have

either 10NN_Spindle, to indicate the numbered spindle the physical CD is located on

40000

40000

But I also have junk like this to deal with:

23_Sensitive Guys Don't Go Home Alone Live_Michael Nichols_Home Alive-The Art of Self Defense Disc 1_1053_Spindle.mp3

23_Sensitive Guys Don't Go Home Alone [Live]_Michael Nichols_Home Alive The Art of Self Defense Disc 1_1053_Spindle.mp3

23_Sensitive Guys Don't Go Home Alone [Live]_Michael Nichols_Home Alive- The Art of Self Defense Disc 1_1053_Spindle.mp3

23_Sensitive Guys Don't Go Home Alone [Live_Michael Nichols_Home Alive-The Art of Self Defense Disc 1_1053_Spindle.mp3

22_Sensitive Guys Don't Go Home Alone-Live_Michael Nichols_Home Alive-The Art of Self Defense Disc 1_1053_Spindle.mp3

23_Sensitive_Guys_Don't_Go_Home_Alone_[Live]_Michael_Nichols_Home_Alive_The_Art_of_Self_Defense_Disc_1_1053_Spindle.mp3

There's spaces, brackets, and underscores. What I really want is the following:

23_Sensitive Guys Don't Go Home Alone-Live_Michael Nichols_Home Alive The Art of Self-Defense-Disc-1_1053_Spindle.mp3

Additionally, there are several files which lack a track number, an artist, the album, and the Composer tag at the end. Many of those files do not include that information within the properties of the file. For example, what artist and album should be in the file name?, such as this: [Your Love Keeps Lifting Me] Higher and Higher [A Tribute to Jackie Wilson].mp3

All of that leads me back to a macro I have used in the past. The purpose of the macro is to identify the unique strings and provide a count. However, it ignores numbers so I will need to create some sort of masking to replace numbers, underscores, and dashes with a letter in order to use the macro that is described more fully than what I wrote in this post on this page: https://wordribbon.tips.net/T010761_Generating_a_Count_of_Word_Occurrences.html.

Friday, October 15, 2021

How can I store thousands of CDs?

This post - How can I store thousands of CDs? - Super User - poses the question that I consider a fantastic question. Thus far, my answer has been to store my CDs on 100 capacity spindles in my den closet. I have 58 spindles of CDs as well as a spindle of DVDs as well. I have some other 'straggler' misc spindles.

Related Pages on this Blog

https://prhmusic.blogspot.com/p/reconversion.html
https://prhmusic.blogspot.com/p/cd-spindles.html

Tuesday, September 28, 2021

Naming Conventions for My Music - Questioning Myself - Part 2

I read Dan Gravell's blog about music management frequently and when I was thinking about naming conventions, for the record, I did re-read this article, from 2010, about how to name music files. I didn't mean for my previous post to sound as if I have already implemented the "Band_Album_Track-Number_Title_Genre.mp3" naming convention. I am thinking about trying out a different naming convention.

Naming Conventions for My Music - Questioning Myself

Yesterday, when I looked at my music files, I had a moment of clarity. I use the following naming convention: Track-Number_Title_Artist_Album_Genre.mp3 I use _ to separate each element in the naming convention so I have files named like this:

01_They're Not Horses They're Unicorns_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3
02_Blame It on Bad Luck_Bayside_Live at the Bayside Social Club_1001_Spindle.mp3
03_Duality_Bayside_Live at the Bayside Social Club_1001_Spindle.mp3
04_Masterpiece_Bayside_Live at the Bayside Social Club_1001_Spindle.mp3
05_Carry On_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3
06_The Walking Wounded_Bayside_Live at the Bayside Social Club_1001_Spindle.mp3
07_Montauk_Bayside_Live at the Bayside Social Club_1001_Spindle.mp3
08_Dear Your Holiness_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3
09_Don't Call Me Peanut_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3
10_I and I_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3
11_They Looked Like Strong Hands_Bayside_Live at the Bayside Social Club_1001_Spindle.mp3
12_Hello Shitty_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3
13_Devotion and Desire_Bayside_Live at The Bayside Social Club_1001_Spindle.mp3

What I realized in that moment of clarity is that this naming convention would be easier for me to use: Artist_Album_Track-Number_Title_Genre.mp3

Bayside_Live at the Bayside Social Club_01_They're Not Horses They're Unicorns_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_02_Blame It on Bad Luck_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_03_Duality_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_04_Masterpiece_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_05_Carry On_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_06_The Walking Wounded_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_07_Montauk_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_08_Dear Your Holiness_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_09_Don't Call Me Peanut_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_10_I and I_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_11_They Looked Like Strong Hands_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_12_Hello Shitty_1001_Spindle.mp3
Bayside_Live at the Bayside Social Club_13_Devotion and Desire_1001_Spindle.mp3

Tuesday, September 14, 2021

CHKDSK to the Rescue

When I got to my desk this AM, my laptop said it was "restarting" which was odd because when I left work last night, I had not initiated a "restart" of my laptop. Eventually, I had to press the Power button because, after helping my friend Jay with his PC on 3rd level and walking with him, when I came back to my desk, it still said it was "restarting" - not a good sign. Thus, after the laptop rebooted, I got a message that there was an error on my EHD so I ran CHKDSK to see if that would clear it up. As you can see from the CHKDSK log below, yes, it did clear it up. If you search this post for the word corrupt, you will see 78 uses of that word in the log below. Obviously, something was going on!

Sometimes, I wish I understood what all of the text below really means, as far as what the machine is really trying to tell me about what the CHKDSK process found, but then I think that it would be too late in my lifetime to ever truly understand "all about the actual machine innards" that are shown below. Besides, I still need to perfect my God-granted talent of writing to the point that I don't use the word that to string together a sentence! <GRIN>

My point to all of this? Once again, CHKDSK saved my butt! The log below was generated after running CHKDSK on my EHD with my cassette-to-MP3 files as well as my "most current" version of my Music-Shell folder, which is where I store my CD-to-MP3 files. If this EHD crashed, I would be hurting in those two areas as I would probably have to rebuild those directories and, no, that would NOT be a fun task!

Chkdsk was executed in read/write mode.

Checking file system on I:
Volume dismounted. All opened handles to this volume are now invalid.
Volume label is L_Black_5TB_Portable.

Stage 1: Examining basic file system structure ...
Attribute record of type 0x80 and instance tag 0x0 is cross linked starting at 0x4e1e92a for possibly 0xb10 clusters.
Some clusters occupied by attribute of type 0x80 and instance tag 0x0 in file 0x9abf7 is already in use.
The total allocated size 0x1e687000 of attribute of type 0x80 and instance tag 0x0 in file 0x9abf7 is incorrect. The expected value is 5a000.
Correcting total allocated size in attribute record (80, "") of file 300000009ABF7.
Deleted corrupt attribute list entry with type code 80 in file 9ABF7.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009abf8. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9ABF8.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa565f with sequence number 0x7.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa565e with sequence number 0x6.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa565d with sequence number 0x7.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa5702 with sequence number 0x5.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa575c with sequence number 0x4.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa56d0 with sequence number 0x4.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa5789 with sequence number 0x7.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa5823 with sequence number 0x7.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa5836 with sequence number 0x4.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa5837 with sequence number 0x4.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to find child frs 0xa5911 with sequence number 0x5.
Attribute record of type 0x80 and instance tag 0x0 is cross linked
starting at 0xc7b430 for possibly 0xd clusters.
Some clusters occupied by attribute of type 0x80 and instance tag 0x0 in file 0x9ac22 is already in use.
The attribute of type 0x80 and instance tag 0x0 in file 0x9ac22 has allocated length of 0x29e00000 instead of 0x3915000.
The total allocated size 0x23211000 of attribute of type 0x80 and instance
tag 0x0 in file 0x9ac22 is incorrect. The expected value is 3092000.
Correcting total allocated size in attribute record (80, "") of file 300000009AC22.
Deleted corrupt attribute list entry with type code 80 in file 9AC22.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac23. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC23.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac27. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC27.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac28. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC28.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac29. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC29.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac2a. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC2A.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac2b. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC2B.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac2c. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC2C.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac2d. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC2D.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac2e. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC2E.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac2f. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC2F.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac30. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC30.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac31. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC31.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac35. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC35.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac36. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC36.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac37. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC37.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac3b. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC3B.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac3d. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC3D.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac3e. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC3E.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac3f. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC3F.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac40. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC40.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac41. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC41.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac42. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC42.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac43. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC43.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac44. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC44.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac45. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC45.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac46. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC46.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac48. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC48.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac49. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC49.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac4a. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC4A.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac4b. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC4B.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac5d. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC5D.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac67. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC67.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009ac68. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AC68.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009adc5. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9ADC5.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009afae. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AFAE.
Unable to locate attribute with instance tag 0x0 and segment reference 0x300000009afb0. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0x9AFB0.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a2329. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA2329.
Unable to locate attribute with instance tag 0x0 and segment reference 0x20000000a3eb4. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA3EB4.
Unable to locate attribute with instance tag 0x0 and segment reference 0x60000000a5659. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5659.
Unable to locate attribute with instance tag 0x0 and segment reference 0x60000000a565a. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA565A.
Unable to locate attribute with instance tag 0x0 and segment reference 0x60000000a565b. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA565B.
Unable to locate attribute with instance tag 0x0 and segment reference 0x50000000a5660. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5660.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a5661. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5661.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a5663. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5663.
Unable to locate attribute with instance tag 0x0 and segment reference 0x50000000a5678. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5678.
Unable to locate attribute with instance tag 0x0 and segment reference 0x60000000a567b. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA567B.
Unable to locate attribute with instance tag 0x0 and segment reference 0x50000000a567c. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA567C.
Unable to locate attribute with instance tag 0x0 and segment reference 0x50000000a567e. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA567E.
Unable to locate attribute with instance tag 0x0 and segment reference 0x50000000a56a8. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA56A8.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a56aa. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA56AA.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a56c3. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA56C3.
Unable to locate attribute with instance tag 0x0 and segment reference 0x40000000a56ce. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA56CE.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a5743. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5743.
Unable to locate attribute with instance tag 0x0 and segment reference 0x60000000a5751. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5751.
Unable to locate attribute with instance tag 0x0 and segment reference 0x50000000a577b. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA577B.
Unable to locate attribute with instance tag 0x0 and segment reference 0x60000000a57a4. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA57A4.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a57a8. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA57A8.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a57bb. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA57BB.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a5812. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5812.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a5813. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5813.
Unable to locate attribute with instance tag 0x0 and segment reference 0x70000000a582f. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA582F.
Unable to locate attribute with instance tag 0x0 and segment reference 0x40000000a5838. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA5838.
Unable to locate attribute with instance tag 0x0 and segment reference 0x40000000a583e. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "") from file record segment 0xA583E.
Unable to locate attribute with instance tag 0x0 and segment reference 0x40000000a584c. The expected attribute type is 0x80.
Deleting corrupt attribute record (0x80, "")

Thursday, August 12, 2021

Some MP3 Issues

It never fails. I have randomly located files that are corrupt in my "Music-Shell" folder.

Monday, September 14, 2020

I am NOT Done with WMP

In a last ditch effort to salvage using WMP (Windows Media Player) to continue ripping Spindle #53, I tried to resolve the issue I had with it, but I have come up empty. I found this article - Media Player - 'find album info' not working - which suggests changing a Windows Defender setting. However, when I went to the screen on my laptop, I saw this:

So that was a dead end.

Friday, August 21, 2020

Need to Do Some Synching

If I did this "right," I would have 4 copies of my "Music_Shell" folder with the same number of files in each.
A: 139421
L: 139638 ← Source of Truth folder
O: 139667
P: 150011

There are 217 *fewer* files in the A:\Music_Shell folder than in the L:\Music_Shell folder.
There are 29 *more* files in the O:\Music_Shell folder than in the L:\Music_Shell folder.
There are 10,373 *more* files in the P:\Music_Shell folder than in the L:\Music_Shell folder.

Wednesday, August 12, 2020

Trying MusicBee

I think I am giving up on Windows Media Player. Yesterday, I created a collection of KISS tunes that I wanted to call "00_S1ngles" and when I used the "Find Album Info" and the window where I used to be able to define an album has been changed. There is no longer the option to manually change MP3 file information - I have to choose a pre-defined album, which is not what I want at all.

Thus, I am giving up on Windows Media Player and going to try a freeware called MusicBee. As you can see in the screenshot below, I am creating a library with all 6 of my EHDs.

Saturday, July 18, 2020

Few Things To Note

This is a snapshot of the synch job between the A:\Music-Final_A folder, which is the folder to which I have copied all MP3s from L:\Music_shell but put them in a single, flat, directory and P:\Music-Final_A, which is a backup of the A:\Music-Final_A folder.
The name of the synch job - e-jpg--e-jpg2-synch - has nothing to do with making the A:\Music-Final_A folder match the P:\Music-Final_A folder - that information is being pointed to by the red double arrows.
The synch job began yesterday, 7/17/2020, at 9:08:22 AM - that information is in the green box.
It's a little hard to see, but the synch job is moving 98,197 files from A:\Music-Shell_A to P:\Music-Shell_A as well as deleting 98,239 files from P:\Music-Shell_A - that information is at the bottom of the screenshot within the purple box.
The synch job is at 63.64% complete and has 10 hours remaining, which means it should be complete around 5 PM today, based upon the current time of 7 AM.

Wednesday, August 21, 2019

How to Test For These Abnormalities?

Editor's Note: Updating the page that is dedicated to tracking progress of the CD to MP3 progress is the appropriate location for the information within this post. However, due to the layout decision to use a table to store tabular information and due to the screenshots below being necessary to explain the subject, it would be ugly. Thus, that page has been updated to include a reference to this post. To see the page that is dedicated to tracking progress of the CD to MP3, see CDs to MP3 Documentation.

I have not documented my progress with my music collection lately so here I go. I ran the command "dir *.mp3 *.wav *.wma *.3gp *.amr" in the directory o:\music_shell and had 119,535 files, which is a lot of music files. However, it is a false number because of some abnormalities in my files. I found the following examples to illustrate the type of work that still needs to be done in my music collection on my external hard drive.

Notice in the red rectangle that the first file uses "Steve Miller Band" while the second file uses "The Steve Miller Band" which results in double (44) the actual files on this specific album.

Notice how the first file and the second file have the same file size, are both "Track 1" - one of those files needs to be renamed to include the actual track information and the other file needs to be deleted.

Notice how even though these are the files in the "50_Spindle" folder, there are files that have "1051_Spindle" in the file name. Files that have "1051_Spindle" in the file name need to be verified to be the actual same tune as the file that has "1050_Spindle" in the file name and then the files that have "1051_Spindle" in the file name need to be deleted from this folder.

The files that begin "Amen" in the Purple rectangles need to be compared to the files that begin with the track number and the duplicates then need to be deleted.

All that said, I ran other commands:

"dir /s" in the directory o:\music_shell and had 122569 files
"dir /s /ah" in the directory o:\music_shell and had 4913 files. The number of hidden files are not included in the above total. A quick review of that list of hidden files indicate that these are the file types which exist in the o:\music_shell folder:

JPG files
DB files
INI files

Tuesday, July 16, 2019

LG Promotion Expiration - 7/19/2019

I guess I need to do something . . .

Editor's Note: Updated on July 17, 2019, with a revealing screenshot:

Tuesday, July 9, 2019

Wasting Time

You know, I waste time. I sat at my desk in the den and counted out piles of 25 CD booklets & inlay cards so I have a better idea as to what capacity CD holder(s) to purchase because, now that I have 53 spindles of 100 CDs each converted to MP3, I need to do something with my CD booklets, as I've been talking about since the Den Transformation project and yes, I used this post as a reason to update the Den Transformation project page on this blog. Back to the point, I like a really nice one that is $85 on Amazon, which is where I have $55 in gift cards to spend. So, yes, I do waste time. And then, there's this guy, you know

THAT GUY

who

REALLY

wastes

TIME,

as shown in the following videos:

LEGO Star Wars fan builds animated Death Star trench run & Death Star II destruction scenes with 50,000 LEGO pieces [Video]

Monday, January 7, 2019

When $391.20 trumps $903.60

This post is a reminder that I updated Tracing the Progress of the Den Transformation

Tuesday, January 1, 2019

CatDrive in January 2018?

Halos will release CatDrive, a new generation storage device PRESS RELEASE PR Newswire Nov. 21, 2017, 08:00 AM
https://www.indiegogo.com/projects/catdrive-most-secure-wireless-external-hard-drive/#/

Tuesday, October 16, 2018

4000 CDs for $.50 each is still a LOT OF MONEY!?!?

I have 50 spindles of 100 CDs each. I'm not going to pay $4000 to purchase another 4000 more. I get what the guy is trying to achieve. The seller has obviously worked hard to create their collection and now that it has come time to sell it, the seller wants to be reimbursed for the work that has been done. Frankly, though, if I had that seller's collection, I would probably accept $.50 / CD because, if there are $4000 CDs, that's still $2000. If I sold my 5000 CDs for $.50 / CD, I'd make $2500.

Very much related to owning an extensive CD collection, last weekend, I started re-ripping the 51st spindle. I did that because I have multiple "data" CDs with multiple albums on each. A "data" CD is different from a "music" CD in that I can play a "music" CD on a stereo CD player whereas a "data" CD doesn't play on a stereo. However, in a CD drive on a laptop or PC, you can access files on the "data" CD. When I copied files from the data CDs on Spindle 51, I didn't create a sub-folder for each data CD. Instead, I put all the folders at the root. It looks like what you see in this screenshot to the right of this text. The reason I don't like that is I cannot tell, just by looking at those folders, which data CD the album came from v. if the album came from a music CD, which also exist on the 51st spindle.

I do like complications it would seem!
That is why I am re-ripping the CDs on the 51st spindle. After that spindle is complete, I am going to have several more spindles to rip. If pressed to guess, I'd guess 500 more CDs. It's going to be a nice winter season project which I hope to kick into overdrive during the next few weeks.

As far as if I would sell my CD collection, I say no. I have the crazy idea that my spindles can be given away at my wake and/or funeral. I just hope there are at least 56 people that come to my wake and/or funeral!

Wednesday, September 5, 2018

Synched!

This (difficult to read) screenshot shows the first file created in the j:\music_shell folder.

This (difficult to read) screenshot shows the last file created in the j:\music_shell folder.

This (difficult to read) screenshot shows how many files were copied from g:\music_shell to j:\music_shell.

This (easy to read) screenshot shows how many files were then synched from j:\music_shell to g:\music_shell (mostly .jpg files).

Search This Blog