Loading HD Songs Records
Previous  Next

graphic
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 table.

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, Floppy).

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,

graphic

You will see the following Dialog Box asking you if you want to “Search For MP3 Files?” You should click Yes.

graphic

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).

graphic

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.

graphic

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.

If you double – click on a song in the browse, the Add / Edit Form will appear.

graphic

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. graphic

You will see a dialog box with the fields from the browse and the query commands available to you.

graphic

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:

graphic

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’ column.

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: ‘Green’.

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..

graphic

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.

graphic

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.

graphic

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 is.

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.

graphic

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 Box.

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 VRM Recordcase.

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)