Find songs in Band in a Box
Over a period of 10 years I have collected almost 56,000 songs in Band in a Box
The song picker cannot cope with so many styles and songs.
I needed an easy way of creating a complete listing in excel
once the data is loaded into a spreadsheet it becomes easy to find the various versions of the songs.
My solution was to make a batch file in Windows XP
the following text can be pasted into notepad and the file saved as makelist.bat and saved to c:\bb
or where your music is stored.
---------------------------------------------
Rem copy the makelist.bat into your bandbox folder usually c:\bb
Rem cd c:\bb run the batch file makelist.bat
echo Make a list of music files in Band in a Box and open excel
dir *.m* /b /s /n > listing.txt
echo open listing.txt with excel
echo use just one wide column to import data with no filters
echo Use excel to find *.mxx music files
echo off
start excel.exe "listing.txt"
echo complete
rem once excel has loaded the new text file skip the deleminiating option
rem change A column width to about 160
rem to find all your songs enter the most relevant part of the file name, find all
----------------------------------------------
Hi June
Many thanks for the batch file.
I have just upgraded from Band in a Box 2006 to Band in a Box 2012 Pro.
The song picker has been enhanced with extra features
You can navigate to the root off C:\BB
Using the [change] tab and tick [include sub folders]
I have 25,000 songs in a separate folder the [rebuild] list
Took about an hour to complete.
The [export to csv] is quick and produced an excel spreadsheet in minutes.
Another of the nice features you can associate any of the music files
You can click on any music file and it will open and play in Band in a Box
The look of Band in a Box 2012 looks almost the same as ver 2006
But so many extra features hiding away.
Good luck
Tony