Challenge
The client was managing their large music library of 1,000+ albums. Each song was supposed to have an accompanying file containing the lyrics.
However, some were missing. So the task was to figure out exactly which ones lacked a corresponding .txt or .lrc file.
Manually going through each folder and eye-checking was certainly out of the question.
Solution
Figuring this out was actually relatively trivial using a simple command line (.bat) script. To demonstrate that I clearly understood what the client needed, I first wrote a ~30-line script that outputted a list of the problematic files.
But I understand that not everyone is comfortable working within the Windows Command Prompt. Plus, certain settings would be much easier to manage with a simple checkbox, and you could click a Browse... button instead of entering a folder path. An app with a GUI would simply be more intuitive for most users.
Within one day, I put together a standalone app that took the original logic one step further. Why limit yourself to .mp3 files with .txt and .lrc? I decided to let the user specify whatever file extension they needed, and output all results into one CSV, which allows for more flexibility in filtering or sorting in Excel afterward.
Outcome
The client could now click a button, and within seconds they would have a comprehensive report of every song lyric file in their music library (including folders within folders!).
App quickly processes large collections and results are neatly formatted in the CSV output file. Developer is very responsive! I appreciate your work on this app!
Visit the FileHarmony product page to learn more or try it yourself!