upgrade

[admin]

It's called BOOKID, isn't it?

I don't think I can justify adding yet another number.

I also can't remove the DiscID# after the Song name in the ARTIST BOOK, or Artist name in the SONGS BOOK. There are too many who requested it that caused us to add it in. One day, we may be able to make the fields in each SongBook report selectable. That way you could disable the DiscID# if you didn't want it. No promises for now.

[Beavis]

sorry about the config utility, i meant rebuild the song database.

i remember before you said we could not change mis-spelled titles or artist in microsoft access.


i guess my question is can we import the cd-g's in the backup computer then transfer the .kma to the main karaoke computer via drag and drop? (i have both computers networked together)


i dont use the song book utility. i print my own books using excell

[sevekj]

I have been able to edit anyway I want any data I want and create the hoster books anyway I want, here is how.

First and most important. Make a copy, make a copy, make a copy!!!! Use a CD or another hard drive or copy and paste to desktop, whatever you feel safer with.


I open MS Access, find the database named "songs"

Open the Table "songs"

The songs info for all the songs you have imported should be displayed with columns for all the data necessary for hoster to work properly.

You can edit anything in this database, do not mess with the path column you will be very sorry!!!!, Only edit title and artist as is necessary for misspellings and other like problems.

Replace the original "songs" with the edited one and you are done. Make a copy of the edited one if all works fine and then discard the old backup.

Also, If there is data you do not want to appear in the books such as the mfg# you can make an edited copy, with mfg# column removed for example, place it temporarily in the database folder, place the original on the desktop or be sure it is saved in it's original condition on a CD or HD, open Hoster, select the books tab and prepare books. Close Hoster, reopen the hoster database folder find and open the word file you want, title or artist, , edit Header/ Footer, print , replace the original "songs.mdb." in to the database folder so that the info will display in hoster and so hoster will work properly, do not forget to do the last step,and you are done!!!

And don't forget, backup, backup, backup!!!! Very important!!!!

Proud hoster user, Seve

[kedmison]

Thanks Seve,

I'll try that. I did copy the data base file to my desktop computer. I have Access 2000. It tells me that the Hoster version of the data base is an older version. Is this correct.?


Thanks again.

Kelly

[admin]

Originally posted by kedmison
Thanks Seve,

I'll try that. I did copy the data base file to my desktop computer. I have Access 2000. It tells me that the Hoster version of the data base is an older version. Is this correct.?

Thanks again. Kelly

If you edit with Access 2000, you must export in Access 97 format or Hoster will NOT identify the database.

BEAVIS, can't comment on click and drag, but however you get the files over there, when you execute the Build Songs database command, the new files will be added to the Songs database, IF... there are no duplicate BOOKID numbers.

[gduns - with the Lord]

Kedmisson,

This is quick an example of what wants to print out in my song book:
Beatles

Hold your hand201.................20112
No where man170....................1701

How do I remove the numbers immediatley after the song titles?

I've always felt that the DiscID# really should be called Song ID#.

Open the word RTF title or artist in word
select edit, select replace, select font, select italic, then ok, leave "replace with" blank, select replace all, allow a few seconds, look at new document without the italicised mfg#.