song database standard "trick" need bucket password.

[sevekj]

I have been building on my database since '97
I started with the first name last name format and omitted the "the"
in artists and created a duets as the artists for duet songs so after the title I had (artist)
I built this in excel and later on learned access and would use access to make my books and even if I say so my self I had the best books around and still do thanks to hoster.
I am wondering if hoster can select a format.
I personally like the first name format, but I have noticed that the bucket seems to mix it up.
I most always have to do some editing to get my data in the way I want it.
And I have a little trick.

I open up excel, go online to my favorite online current data base or where I ordered my cdg, I highlight the contents, copy and paste the info to my excel. Then open hoster, prepare to import, select the mfg, input the new cd id# input bookid and then I keep hoster and excel side by side and copy and paste the info, it saves on typing and typos for the most part.

I am going to create another thread to get the password for the bucket.mdb
because I think if I can get in there I could cut and paste more songs at once and make my editing so much more easier.
I hope this trick helps someone out there.

Sevekj

[MTUSUPPORT]

Thanks for the Input.

[nreel]

Viewing, Cutting, and Pasting Artist/Song information from the Bucket Database is not feasible, unless you are proficient in making Queries to combine multiple TABLES.

The Bucket database uses separate TABLES for Artist and SongTitle and Disc Manufacturer.

When you go to your favorite KARAOKE WEB STORE, where they usually have a listing that one can Cut & Paste, the Artist and SongTitles, usually, are in a TABLE that follows the Disc Manufacture’s Layout (Tracks 01 - XX).

This way, when Pasted in your favorite Word Processor, you can readily Transfer the data to Hoster as Hoster is Open, along with, your Word Processor. And, by-the-way, a Dual Video card, used for Hoster, comes in handy as one can use the Dual Mode, with Two Monitors, to keep Hoster Maximized on one Monitor and the Word Processor Maximized on the second Monitor so that one can VIEW both, at the same time, while Cutting and Pasting.

Since the Bucket Database has separate Tables for Artist, SongTitle, and Disc Manufacturer, none of the information lines up or is displayed, as you would see on the Internet.

Hoster, itself, runs the Queries to combine the tables that automatically fill in the Data, when a Brand and Disc number is selected.

Unless you like the fact that all the Apostrophes have been removed from the Bucket Database, which make contractions look like misspelled words, then, you may as well Cut & Paste from the Internet, which are going to be 99% correct listings.

Norm

[nreel]

Since Hoster does not have the LATEST Karaoke Disc listings, I feel compelled to try and help those who have inquired concerning full access to a Karaoke Database. I can offer this:

If you want a complete Database, you can do this, if you have MsAccess and KJPro...I did and it works great.

Obtain MsAccess and the KJPro Program (226,818 total Records as of August 2004) and do this:

Open KJPro to MAIN SCREEN

Click on "VIEW/FILTER SONGS" in the "Master Song Database" Section

Click on the 1st Song's Gray Box located in the LEFT Margin (Box Turns Black)

Click and HOLD the LEFT Mouse Button on the VERTICAL Scroll Bar on the RIGHT Margin.

With the LEFT Mouse Button held continuously, Pull your Mouse Down...note Counter as you Drag...until the Counter says 55,000 or so, but not more than 60,000.

Let go of Mouse Button.

Hold SHIFT key DOWN.

While Holding SHIFT Key DOWN, Click on the Gray Box in the LEFT Column next to any SONG you wish that is displayed (This Selects all the Records from #1 to #xx,xxx - You CANNOT copy more than 60,000 Records to the Windows Clipboard - That is why you will stop somewhere prior to 60,000, each pass, until you get all the Records).

Left Click your Mouse on top of the Last BLACK Box in the LEFT Column and Click on COPY in the Drop Down Box (You are ready to Paste into MsAccess).

Open MsAccess, if you have not already done so, to a NEW Database and assign a name like KJPro.

When Database opens, click on "Create table by entering data."

Click on the Asterisk located in the LEFT Margin at the bottom of the "Generic" Table.

Left Click on the Black Line and select Paste in the Drop Down Box.

Repeat until all Records have been Cut and Pasted.

Save the Table with a name like KJPro.

You are done...sort the data any way you like.

Norm