MTU.Community

MTU.Community (http://forum.mtu.com/index.php)
-   Hoster Help (http://forum.mtu.com/forumdisplay.php?f=71)
-   -   Songbooks (http://forum.mtu.com/showthread.php?t=8961)

ddouglass December 22nd, 2007 09:48 PM

We started with it from the beginning, built the table, queries and reports from scratch.
That said you can copy the file songs.mdb (don't work directly on the original file) then open it in Access. From there you can add queries and reports.

billyo December 27th, 2007 05:59 PM

hoster songbook
 
i used karaoke songlist creator, i can delete /hide duplicate songs and also edit , and create my on brand..

stublack August 5th, 2008 10:31 AM

I didn't vote on this poll because there was not an option that fit.

I used KJ Pro in the past before I purchased Hoster.
I have used Excel for other purposes and did consider using it for my songbooks.

For my purposes the Hoster Songbook is just a lot simpler.

So if there was an option that said Hoster Songbook is better for your purposes than any other program that you've used I would have place my vote there:):)

laddie August 5th, 2008 10:55 AM

I have KJPro, but I really like the songbook feature in Hoster. I convert the output file to an SQL database and post it on my web site. My customers can create search criteria and make their own songbooks rather than go thru mine.

capnvic August 5th, 2008 12:34 PM

Songbooks
 
Quote:

Originally Posted by stublack (Post 78446)
I didn't vote on this poll because there was not an option that fit.

I used KJ Pro in the past before I purchased Hoster.
I have used Excel for other purposes and did consider using it for my songbooks.

For my purposes the Hoster Songbook is just a lot simpler.

So if there was an option that said Hoster Songbook is better for your purposes than any other program that you've used I would have place my vote there:):)

I used KJ Pro for a long time prior to buying Hoster. With most processes, you have to be aware of all sorts of shortcomings with each process. (I don't want to use "problem" as a word in this application) With KJ Pro, Hoster and most Song book creators, there is always going to be necessary changes, such as typos, Song title inconsistencies, and other errors. I spend quite a bit of time correcting the database for Hoster, as I did with KJ Pro, however, I do like the format and flexibility with the Hoster songbook creator, such as porting the list to a SQL db or Word or even PDF.:)

bfischer August 5th, 2008 10:15 PM

Don't have a lot of experience with other programs but I found the Hoster Songbook to work well for my level of computer expertise (very little)

Did I see that one of the features in Version 4 was the ability to delete duplicates in the songbook?

madjim- with the Lord August 6th, 2008 04:41 AM

Quote:

Originally Posted by bfischer (Post 78471)
Don't have a lot of experience with other programs but I found the Hoster Songbook to work well for my level of computer expertise (very little)

Did I see that one of the features in Version 4 was the ability to delete duplicates in the songbook?


In Hoster 4 we have the ability to prevent any song from showing up in the songbook. You don't delete the duplicate using the songbook, you just select it so it won't show up when you print your books.

I Hope This Helps.

Jim :g

ddouglass December 10th, 2008 12:26 PM

Quote:

Originally Posted by madjim (Post 78479)
In Hoster 4 we have the ability to prevent any song from showing up in the songbook. You don't delete the duplicate using the songbook, you just select it so it won't show up when you print your books.

I Hope This Helps.

Jim :g

Select "Hide" in the Edit Songs function for the duplicates (to further explain your answer Jim).

madjim- with the Lord December 10th, 2008 02:14 PM

Quote:

Originally Posted by ddouglass (Post 86828)
Select "Hide" in the Edit Songs function for the duplicates (to further explain your answer Jim).

Thanks for the backup Dale!

Jim :g

Eric Whitehouse December 11th, 2008 08:57 AM

I 've got quite a lot of songs in my database and would have to have several sessions selecting the duplicates I didn't want in my book. Is there anyway I can save my work until I complete the task :?

ddouglass December 11th, 2008 10:00 AM

Eric if you use the Edit Songs in Hoster your work is saved as you go and the changes are permanent. You can either hide them or delete them from there. If you use Access to make the changes then it isn't permanent and will dissapear next time you do a rebuild or add to the database.

Eric Whitehouse December 11th, 2008 10:22 AM

Many thanks, I'll give it a go and let you know how I get on.:)

bigjohn December 19th, 2008 11:16 AM

songbook
 
Hoster songbook works ok not the best and not the worst I forgot how to make it list in excel old age i guess.

bryant December 20th, 2008 02:06 AM

Quote:

Originally Posted by bigjohn (Post 87496)
old age i guess.


:)Never admit to being old, coz as soon as you do, then you are?:) And if you don't, then you are not.:)

Singsation February 9th, 2009 11:45 AM

Converting lazer discs to mpegs
 
Quote:

Originally Posted by Lonman (Post 63300)
No but I know someone that did transfer them down to DVD or VCD I believe. I have no clue as to how that works or how to do convert them to make them work in Hoster.


I transfered my laser discs to mpeg 2 by recording off my laser player onto a recordable dvd player using dvdrw. I used rw's so you can the edit the disc putting chapters where the tracks would start. By now you have backed up the laser disc onto dvd. Next i used a sony vaio and DV gate software ,(DV gate free on vaio)to import them to a hard drive, I tried a lot of software to do this but the sony DV Gate reads VOB files and automaticly creates a mpeg file at each chapter point and will allow atomatic numbering eg. 301-A-01, 02,03 etc The only problem i had was in the uk we can only get (at the time) pal region recorders. Now the pause screen on the laser disc player is pal60 and the playback is ntsc so the disc recorder wold not record the two formats together. I tried several dvd recorders to do this as pal 60 is not true pal and alot of recorders would just record a rolling picture. I used a phillips dvd recorder in the end, as it was the most reliable. This may not be a problem in America as it's all ntsc. Takes along time though but three or four discs a night whilst doing something else soon goes by. The other thing to considure is file size 2500 lazer tracks Mpeg 2 good quality is 400 gig. Hoster 4.10 will allow you to import the tracks, but its just as easy to search using the current player. Tried to convert to divx just takes too long. Hope this helps.

Joe Nieves February 11th, 2009 11:43 PM

Quote:

Originally Posted by ddouglass (Post 68958)
No because I don't have that many duplicates to worry about. Besides most of my singers know which brand they like and if I took them out they would hollar.:g


Hi ddouglass

I like access too and find it helps me clean up hoster database issues quickly.

As for the hoster song book I don't use it at all.
Main reason not setup to print by Disc ID only by book ID

When singers want a song in SoundChoice or ChartBuster ver. they like to see it listed in the book that way SC2535-05 CB90045-09, mush easier to remember then Book ID 11205939 or 396943824.

I use Music Book Dlx find it very useful, accurate and easy to use takes care of dup's and has many features not availible in other song book programs.

Would be nice if Hoster would allow other database to be used for import.

Joe....

ddouglass February 12th, 2009 12:29 AM

Quote:

Originally Posted by Joe Nieves (Post 89293)
Hi ddouglass

I like access too and find it helps me clean up hoster database issues quickly.

I hope you don 't have to ever Rebuild or Add your Database, because every change you make in Access will disappear. I use Access to look at the Songs Database and to use it as my basis for printing my books and am trying to use it to print my Singers lists from that database, though I have not been completely successful with that yet.

Quote:

Originally Posted by Joe Nieves (Post 89293)
As for the hoster song book I don't use it at all.
Main reason not setup to print by Disc ID only by book ID

Joe, when was the last time you looked at the Songbook Creator. You can have it use either the BookID or the DiskID. You might want to check it out.

Joe Nieves February 12th, 2009 08:22 PM

Quote:

Originally Posted by ddouglass (Post 89296)
I hope you don 't have to ever Rebuild or Add your Database, because every change you make in Access will disappear. I use Access to look at the Songs Database and to use it as my basis for printing my books and am trying to use it to print my Singers lists from that database, though I have not been completely successful with that yet.


Joe, when was the last time you looked at the Songbook Creator. You can have it use either the BookID or the DiskID. You might want to check it out.

Hmm?

I'll have to check up on these two responces and get back to you on them.

Thanks ddouglass

Joe....

swany February 14th, 2009 02:52 PM

Started with KJPro, when I got hoster I went with it. I found it to be for me not the right thing. Went back to KJPro.

I am numberless, and do not list brand id.

Double col, and no numbers does make my books smaller and faster to locate for folks looking.

Musicman51 February 14th, 2009 02:58 PM

I like KJ pro for the reasons stated above. I used KJPro when i was doing karaoke with a player, only program worth a durn at that time. Outdoor yard parties, pool parties, and biker rallies i still take my JVC, and old backup disc to use. So the Hoster books would do me little good actually.

So i have just stayed with KJ Pro. I keep the duplicate titles in, i tried leaving them out, and everyone drove me nuts asking what lable the song was on.

Last count i had 9 D.I.V.O.R.C.E. recordings on different lables.:w


All times are GMT -4. The time now is 06:34 PM.

Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.