Disc ID question

[Lonman]

I use the disc id for my search query. Why don't it list the track ie Disc ID SC8148-07 when I do a search for SC8148? It just lists SC8148 but no distinguishable track number? I can search for the disc itself, but if I put in the search SC8147-07 - it comes up nothing found?
I just started using my computer tonight in the club & this is kind of a problem for me>????

[mindonstrike]

The track # is the last two digits of the bookid

Sam

[madjim- with the Lord]

Originally Posted by mindonstrike

The track # is the last two digits of the bookid

Sam

Sorry to repeat this answer, Sam slipped it in while I was typing.

Jim

[madjim- with the Lord]

The track number is the last two digits of the BookID.

For example in my collection "Remember When" By "Alan Jackson" is off of disc "SC3382' with the BookID "6801". When I loaded Disc "SC3382", "68" was the lowest unused discID number (or the 68th disc I loaded) so the first two numbers of the BookID will be "68". Since "Remember When" is track "1" on the disc the last two numbers of the BookID will be "01". (BookID 6801)

Type in the DiscID without a track number then look at the last two numbers of the BookID.

My singers give me a song title or I will search for the artist and let them choose a song from the list. I never have to search by DiskID. If they try to give me a BookID number or hand me a piece of paper I explain (in a nice way) that I only need the title of the song (you really only need one or two words) and their name.

I Hope This Helps

Jim

Note from the manual:

"We STRONGLY recommend you click the Next button for Hoster to automatically assign the lowest unused BookID Root when importing tracks from a Brand-DiscID you have not imported before."

I followed these instructions and did not create a cutom scheme.

[gd123]

Performing a search for SC8148 will list, in numeric BOOK ID order, Trks 01-15.

I know this doesn't get you what you want, which would be to enter SC8148-01 and only have a listing of just that.

But, the technical reason is that the DiscID in and of itself does not contain a Track Number. It's a kin to the BookID ROOT. The BookID ROOT doesn't contain a Track Number. Hence, in reality, the DiscID should be technically referred to as a DiscID ROOT.

But, if logic is to follow, one can search on a BookID, which contains the BookID ROOT and a Track Number. So, why can't one search for a DiskID, which contains the DiscID ROOT and a Track Number?

Well, one glaring reason is found in the Songs.MDB...the Bible to Hoster. Notice that the BookID (not Bookid ROOT) is shown in its own column, whereas, the DiscID (ROOT) is in its own Column and the corresponding Track Number is in a SEPARATE Column.

Which is more strange because, in the KMA Songs Folder, the DiscID (ROOT) and its corresponding Track number are together separated by a DASH...not a Column.

However, I was able to convert the Access97 Songs.MDB to Access2007. From there I was able to Delete the DiskID Field, Insert and COPY the PATH Field, which had to be RENAMED to the DiskID Field, as there was already a PATH Field.

Then, I used REPLACE to get rid of the PATH info and the .KMA info, which left the DiskID-Track Number.

Then, I converted the Access2007 Songs.ACCDB back down to an Access2000 Songs.MDB. I attempted to match the "Original" DiskID "FIELD SIZE" of 16, but Access wanted to delete too much info in the DiskID Field so I left the DiskID Field at the Copied parameters of the PATH Field, which was 255.

Copied the altered Songs.MDB to the Hoster\Database Folder and Hoster Opened perfectly.

Upon performing a Search for DiskID SC8148, the Disk listed all Tracks.

Upon performing a Search for DiskID (ROOT) and Track Number 1, which would be SC8148-1, I got a truncated list of all DiskID (ROOT) Trks:
01
10
11
12
13
14
15

as I couldn't get specific to Track 01 as the DiskID is listed as SC8148-1 and NOT SC8148-01

So, if I wanted to further alter the Songs.MDB by adding leading ZEROS to single digit Tracks, I could perform an exact SEARCH, which is what you are tyring to accomplish.

Man I'm smart.

[Lonman]

Oh well, I don't use the bookid - for me it's a useless field (unless I want to see the track numbers), guess i'll have to live with it.

[goonie227]

How can you not use the book ID?

[madjim- with the Lord]

My singers give me the name (title) of the song or the name of the artist, NO NUMBERS! I started hosting karaoke with disc and CDG player using numbers like everybody else and understand that old habits can be hard to break but a paperless show means less work for the KJ. This alows the KJ to focus on the singers and the show. It takes a little while to train your singers but once they get used it they will never have to remember a number or write on a piece of paper again.

Paperless/Numberless Shows, The only way to KJ!

Jim

[Lonman]

Originally Posted by goonie227

How can you not use the book ID?

Because I prefer to use the disc ID number instead. Not only does it tell people what brand they are singing off of, it gives me a fall back if the computer crashes as well as my discs are with me at every show.
For my use, the book id is not a useable number which is why I asked for the songbook creator to be able to list book ID OR disc ID. Right now the songbook creator won't work for my needs either which is why I continue to use my Access reports.

[ddouglass]

Originally Posted by madjim

My singers give me the name (title) of the song or the name of the artist, NO NUMBERS! I started hosting karaoke with disc and CDG player using numbers like everybody else and understand that old habits can be hard to break but a paperless show means less work for the KJ. This alows the KJ to focus on the singers and the show. It takes a little while to train your singers but once they get used it they will never have to remember a number or write on a piece of paper again.

Paperless/Numberless Shows, The only way to KJ!

Jim

Jim,
How is it less work if you have to use the search typing in name for each and every addition to the playlist, or do you remember the bookid for every song? I would think even Lonman's use of the DiscID would be faster.

[mindonstrike]

I'm a "custom scheme(r)". I have a legend at the front of the books for those who want to know what brand a song is. 01-xx thru 99-xx are reserved for VCD for when the time comes they can be imported but they are titled that way on my hard drive now. 100-xx thru 299-xx =PHM, 300-xx thru 499-xx =CB, etc. I use Soundchoices own numbers 2000-xx thru 9908-xx. Most of the number blocks I have memorized so when I do get a question on a song I can usually tell them the brand without looking it up, and most of my singers who are concerned about the brand are looking for SC which is even easier to tell.

I will usually accomodate a song slip that is missing the bookid but I have found that most folks who give me a slip like this often times didn't even look in the book to see if I have the song or they confuse a line from the chorus as being the song title. , they just wrote it up, handed it in and went on their merry way so then I have to hunt them down and let them know I don't have it ask whose rendition etc.

If I were paperless I'd have to deal with 50-60 people, many of whom after making their requests want to stay and chat forcing me to blow them off to get to other requests or collect microphones, call up the next singer, etc.

madjim I am glad the paperless thing works for you, but for me it would be more work than I would care for.

my 2 cents
Sam