Loading HD Song Data
HD Songs are the MP3 Song
files on your hard drive(s)
This process loads the MP3
Song’s data into the HD Songs
Along with the XML Song Files created by PCDJ VRM, HD Song Records need to be loaded.
The HD Songs Records come from searching and cataloging all of the MP3 Audio Files DJ
Printer can find on all of your connected (but not network) drives (Hard Drive, CD,DVD,
Having a table of records that represent the songs on your hard drive allows you to compare
the contents of the XML Song files against the actual MP3 files on the hard drive(s). It will also
tell you what songs on your hard drives that PCDJ does not have logged in a XML Song file.
This window has a simple Data Query Builder for searching against the HDSongs table.
When you run DJ Printer for the first time or after you delete the HD Songs table and select HD
Songs from the Browse Menu,
You will see the following Dialog Box asking you if you want to “Search For MP3 Files?” You
should click Yes.
You will see a Search dialog box on the screen with a fast moving progress bar and you
should be able to see some of the file paths that are being searched. System and Hidden
folders are not searched.
When the search is done, you will see a dialog telling you that there is a final step, Save The
Memory Queue to HDSongs table. The dialog will go away in 5 seconds or you can click on it.
After all the MP3 Songs, called HD Songs here, are found, you will see the Status bar show
you how many records are being loaded into the HDSongs table. It could take awhile if you
have lots of songs.
16,000 songs took a few minutes but not terribly long.
Once the data is loaded, you will see the HD Songs Browse and the listings of the songs DJ
Printer has found on your hard drive(s).
The Column that is in Red is the Current Sort Column, the Search field at the top of the
window will search the Current Sort Column. If you need to search using more than one
column, then use the Build Query button for advanced searches.
As you select songs in the browse window, notice that the currently selected song is also
shown in the Play Button at the bottom – left corner of the window.
The highlighted button above is the Play Preview Button. Click this button to hear the
currently selected song. This should bring up the default MP3 player on your system.
Even though you have the ability to add and edit records it’s not advised. The ability is here
for future features and the Insert and Change buttons will be hidden in the release version.
The best thing to do at this point is to close the window. Changing any of this data may mean
that the other functions will not be reliable because it’s dependant on the data that you
changed and your changes don’t match up with the current state of the file.
Search Using Multiple Fields and the Query Builder
If you want to search using more than one field, then you need to use the Query Builder.
To access the Query Builder click “Build Query” button.
You will see a dialog box with the fields from the browse and the query commands available
This dialog is easy to use. Let’s say that we are going to search for the word: ‘Green’ in the
field ‘Name’. The Name field is the one that contains to MP3 Song File name that normally
contains the Artist, Space Hypen Space, Song Name.
This is how you would do it:
The order you choose the elements is important. You need to start with the field (in the
‘Column’ column) and then the keyword in the ‘Keywords’ column. In this sequence you
would click on ‘Name’ in the ‘Column’ column, then you click ‘Contains’ in the ‘Keywords’
After clicking on ‘Contains’ in the ‘Keywords’ column, the text field above the Global NoCase
button becomes active and that’s where you type the Search Criteria, in this case type:
Click ‘Accept’ button twice. Once to accept the word ‘Green’ and once more to accept and
perform the search.
When this dialog closes, the search is performed and you will see the Query String at the top
Left corner of the window, green text on black background..
As you can see, I only had one song that had ‘Green’ in the ‘Name’ field. I can click the button
at the bottom left of this window and play the song if I need to review.
To clear the Query and see all of the records again, click on: “Clear Query” button.
After clicking on the ‘Clear Query’ button all of the records are available to you again.
One nice thing about the query builder and the search field is that you can use them together.
You could create a query using multiple fields and then use the search field to narrow the
results of the query even further.
Extract MP3 Data From HD Songs
The HD Songs (MP3 Song Files) contain ID3 Data that is the Artist, Song Title, Album Title, etc.
So far, all we have is the file name but we can extract the Mp3 ID3 data and store that in a
separate table, linked to the original file.
I wrote this because I have received songs from others that the file name was wrong or a
series of numbers and I had no way of knowing what it is unless I play it and hope I recognize
it! At least with this I can see if the ID3 data can help me to figure out what the song or sound
More on the Extracted MP3 ID3 Browse Window here
The following menu shows you some of the other things that you can do while you have the
HD Songs Browse Window open.
The Tools Menu and the following selections are only available when the HD Songs Browse
Window is open.
1. Find All HD Songs – This will search all connected (but not networked) hard drive(s) for
MP3 Audio Files. Use this selection if you choose no at the ‘Search For MP3’ Dialog
2. Extract ID3 Tags – Extract ID3 Data from the MP3 Audio files found by DJ Printer and
listed in the HDSongs table.
3. Find Non-PCDJ Songs – Find all the HD Songs on your hard drive(s) that are NOT
logged with PCDJ VRM Recordcase. Helps to finds lost or forgotten songs.
Print Excluded HD Songs Report – Prints a report of the Excluded HD Songs in Artist /
Song Title Order.
4. Included and Excluded Records Report – Prints a combined report of the Included and
Excluded songs. You will see an alpha sorted list of songs logged with PDJ VRM and
after a page break you will see an alpha sorted list of songs NOT logged with the PCDJ
5. This sub Menu takes you to selections that will allow you to clear the three fields that
are used in counting functions.
Clear Duplicate Flags – Clears the DUP Flag field.
6. Clear Inv 01 and 02 Flag – Clears the Inv 01 and the Inv 02 Flags based on your choice.
7. Clear All Flags – Clears all flags at one time (DUP, Inv01 and Inv02)