Karaoke Forums

Your quite welcome Chip. One thing that I like to do do is take a program and work with it to see if there are bugs. I have found some even with Latshaws song book and told them about it and they fixed it.

If I find anymore I'll let ya know.

Waiting for Toger to get the new AUTOKJ on board so I can start playing with it to help him fine tune it.

Lone Wolf

OH YEA the new version works now but still playing with it.

_________________
I like everyone when I first meet them. If you don't like me that's not my problem it's YOURS!
A stranger is a friend you haven't met yet

You got me thinkin'.... (dangerous as that may be)

I tested out the RTF file-writing time on a database of 10,368 tracks. Now, keep in mind that this time is what is timed after a disk scan. Although there wasn't one in this case, I can with most certainty guess that a disk scan of this magnitude would take approximately 1.5 minutes including the temporary database build.

Anyway, the file writing time for this database was all of 25 seconds to write both the titles listing and the artist listing.

The program also created a file for use with the kiosk as well. If you don't have "SONGFINDER", that file is useless right? It can just be deleted if you're strictly uSing this to create a song book and not using it to search for songs?

THANK YOU CHIP!!!!!!!!!!

The wife and I where just getting ready to go thru the dreaded task of re-printing songs books, and I was gonna have to refresh myself on Excell to get a 2-column per page format, cause our books were getting to big.

BUt you have SAVED ME, and thanks again!!!!!!


And upon trying the proggy, I found another possible issue....
on the RTF by song title, I got the song 'Til A Woman Comes Along on the first page before the songs that start with numbers because of the '.


But again, THANKS!!!!!!

and just noticed another couple problems with songs starting with (.

Here is a cut and past of the first couple lines form the song title RFT....

'Til A Woman Comes Along (PH) -Janson, Chris K348-39
'til We Ain't Strangers Anymore (th)
-Bon Jovi & Leann Rimes K330-14
(I Just Want It) To Be Over -Cole, Keyshia K994-18
(Listen To The Band) Covers -Monkees, The K997-101
03 Bonnie & Clyde -Jay Z & Beyoncé Knowles K301-03
1 2 3 4 (th) -Feist K333-51
1 Thing -Amerie K994-08
1,2,3,4 (sc) -Plain White T's K339-58

You're welcome... Use it in good health...




Absolutely it is the single apostrophe. They sort higher than any letters do. The single apostrophe is ascii character 39 where the uppercase "T" is ascii character 84.

Look in the "Error.txt" file for any that it couldn't resolve at all and skipped.

Here's an ascii character chart and you can see why all the punctuation and numbers sort higher than letters:

http://www.asciitable.com/

yep... just trash it if you like.... The "Kiosk.csv" file you can ope with Excel... you can do the same with "hoster.dat" if you rename it to "hoster.csv" first.

They are both just text files. The only files you need there are the *.RTF files. All of the files will be overwritten every time you run the program anyway.

Hey twansenne,

Did your book turn out smaller too? (heh, heh...)

Okay, here's the IMPROVED VERSION:

Modifications:

1. Added "REMOVE ALL DUPLICATES" function. This means that all the duplicates will be removed. Sorry, it doesn't give you a choice of brand, but it will work. Be advised: Because this function involves several "comparison tests" it is very time-intensive. It will take a few minutes to run so be patient. You'll see a counter as it goes up and at the end, you'll also see what the final count was in your book.

2. Added "DO NOT PRINT DISC ID" function. This means that the leader dots AND the disc ID will NOT appear in either the song title or artist section.

3. Changed FILE DESTINATIONS. All files will now be written to the same folder as the program and NOT to the root of drive C:

Please NOTE:

1) If you have already downloaded and installed this program, then you ONLY need TWO files below. You MUST place these files in the same folder as the files you have already installed. The default folder location is: C:/book

http://dkusa.com/FreeBookLink/Mp3gBook.exe
http://dkusa.com/FreeBookLink/mp3g1.exe

2) If you have NOT already downloaded and installed this program, then you can do so here:

http://dkusa.com/FreeBookLink/FreeBook.exe

As usual, give it a try and let me know how it works.... (be nice, remember it's still free.)

Yes they will be much smaller. Since last time I printed have added about 2K in songs. And after printing with your program, by books will actually be about 20 pages less than last time I printed.

I have another suggestion, Chip...How about you add the abillity to delete any songs that have any form of "w-vocal" in the title...whether it be in the artist field or the title field. That would delete many songs that never get sung.

There are various versions i.e. Wvocal, Wvocals, W-vocal, W-Vocal, W-Vocals, W-vocals. might be some others that aren't coming to mind right now....wvocal, w-vocal etc.

You can do this already yourself... Just open the "hoster.dat" file with wordpad and do a search for the word: "vocal" and delete the entire line. Just make sure that there are no blank lines.

OR....


You can rename hoster.dat to hoster.csv an open it with Excel and do searching and deleting as well... Just MAKE SURE that the last row (or last line in wordpad) has nothing on it but 3 asterisks+END+3 asterisks. Like this:--> ***END***

ALSO, make sure that you've downloaded the update.

okay. Just thought it would be easier if there was just another box to check to do the same thing.

I didn't downloaded the update. I deleted the program and then re-installed the complete version. It just seemed easier to do it that way for me so I knew I would have the entire thing in one place. It deleted a bunch of the dupes but not all of them. so I tried to use a smaller folder of songs so it wouldn't take so much time and it seems to have added the new folder to the previous folders total of songs. Do I have to delete something to start over from scratch or does just restarting the software and searching over write the previous running of the search action?


I'm not a techie by any stretch so I'm maybe asking stupid questions. I apologize if that's the case. I'm not sure if I even understand your instructions for searching for "vocal" and deleting a line. It's been fun trying to weed out the dupes in an effort to see how many individual titles I actually have but some songs just aren't named exactly alike and they wind up getting added in even though they are the same song by the same artist because the same song maybe something like Clapton, Eric - Wonderful Tonight and the other one is Eric Clapton - Wonderful Tonight.

It shouldn't be adding anything to anything... it is simply overwriting what was there previously with all new information.




No questions are stupid. Okay, the file named: Hoster.dat is nothing more than a text file. You can open it with wordpad. When you do, you'll see lines that look like this:

[font=Courier]"7675","Stickwitu","Pussycat Dolls","0","0","BCI41560 2-10","Generic"
"7676","Probably Wouldn't Be This Way","Leann Rimes","0","0","BCI41106 2-07","Generic"
"7677","Baby Girl","Sugarland W-Vocals","0","0","BCI41106 2-08","Generic"
"7678","When I Think About Cheating","Gretchen Wilson","0","0","BCI41106 2-09","Generic"
"7679","How Far (W/vocal)","Martina McBride","0","0","BCI41106 2-10","Generic"[/font]

Do a search for the word "vocal" and simply erase the line or lines (in this case) that has "W-vocals" in it (Sugarland and Martina above). Just make sure that when you erase a line, you don't leave a blank line in it's place. (hit the F3 key to search for the next one... etc...)

Save the file.

Now, in your C:/book folder you'll find 2 (count 'em two) program files. Double-click on the one named: Mp3gBook.exe to start it. This will use the file you've just modified to create your books without doing the disc scan and the tracks you've eliminated won't be there.

so if there are thousands of songs with vocals to be removed , you have to do each one manually? That's an awful lot of mouse clicking. I don't know how it happened but when I tried to use a smaller folder to test the program I wound up with more duplicates deleted than songs that I have in the folder....by a large margin too. I think I'm just gonna remove the program and re-install it again and start over.

Why not simply move the files with the word "vocal" in them to a different folder? You can do that in just a few keystrokes and be done with it. Just move them to a different drive...

1) create a folder on a different drive. One that you are NOT going to include in your book. Open this new (empty) folder and minimize it.

2) Using Windows Explorer, click on the search tool (magnifying glass) and perform a search where you are searching (checkbox) "Filenames ONLY"

3) Your search criteria will be: *vocal*.*
This will find ANY file that has that word in the filename.

4) Highlight all the tracks it has found and drag them to the newly-created empty folder. Windows will now place a copy of the track there. VERIFY that these copies have been placed there before the next step.

5) Now, delete the files in the search box. You will now have all the vocal tracks separated from the others. Perform your songbook scan again and you should be all set.

deleted Starland Vocal Band song. If I delete all of the songs it will take me forever to get them back in the folders where they belong. For some reason, KJ Pro has a button to remove all songs with vocals....I wonder why that is??? Oh yeah, because people think it's a good idea...but you keep coming up with reasons not to provide that function.......Oh that's right. It's FREE so why improve it? SIGH!!!

I guess I'll stick with KJ Pro

If you say so....

It's amazing how your demeanor has changed because I'm not jumping to accommodate your request. Sure, you'd like it to do what you want, but still want it free?... Was KJPro free too?

But why in the world would you include vocal versions in the first place?

"give 'em an inch.... and they want the whole enchilada"

Other people asked for additions/corrections and you gave it to them. I asked for one that I thought would improve your FREE gift to everyone and you fought the suggestion from the get go.....and I didn't ask you to JUMP. You could have easily said that it was a good suggestion and that you might eventually get around to making it happen. If you don't want to improve your program, DON'T! The vocal versions of songs help me to learn how to sing them but I wouldn't want them taking up space in my song book. I hope you had a wonderful Thanksgiving, Chip. I'm not mad but I'm not gonna beg you to do the right thing either. I survived this long without your free software. You asked people to play with your freebie and give you feedback. I did and you acted as if I backed you up against a wall or was twisting your arm to do something that would ruin your program. Enjoy the Holiday Season and I hope you get everything that you want for Christmas/Chanukah.

and by the way, I did get KJ Pro for free.

You've probably spent more time telling me how to work around the problem than it would have taken for you to write the code to fix the "problem".

He certainly tried to help you, Bruce, with several suggestions, even though you mentioned a feature that he didn't feel was a valuable asset to the program. You can hardly have sour grapes about him helping you, but it appeared from your previous posts that you do. I personally don't think the majority of KJs would even use that feature, since most don't choose to import the vocal versions when they're importing a disc. Just MHO.

I do wonder, though, if you have such high expectations from programmers every time you get a new program, whether you purchase it or it's free.