KARAOKE SCENE MAGAZINE ONLINE! - Looking for a better way to create my songbook Public Forums Karaoke Discussions Karaoke Scene's Karaoke Forums Home | Contact Us | Site Map  

Karaoke Forums

Karaoke Scene Karaoke Forums

Karaoke Scene

   
  * Login
  * Register

  * FAQ
  * Search

Custom Search

Social Networks


wordpress-hosting

Offsite Links


It is currently Sat Jan 18, 2025 7:29 pm

All times are UTC - 8 hours





Post new topic Reply to topic  [ 28 posts ]  Go to page 1, 2  Next
Author Message
PostPosted: Thu Jul 29, 2010 4:45 pm 
Offline
Super Poster
Super Poster
User avatar

Joined: Sun Jun 06, 2010 10:39 am
Posts: 884
Location: Tx
Been Liked: 17 times
I'm currently using CDG's with my home setup and am looking for a better way to manage my song book. Currently I have everything in a excel spreadsheet (about 2500 songs) and when I buy a new disc I have to update and re-sort 2 versions Sorted by Title and by Artist.

I've been looking for a song book creator online but everything seems to want to read from a hard drive to generate the list. I'm still using CDG's so currently haven't backed up anything or shifted to mp3 format.

Does anyone know of a song book creator that I can import say a comma delimited file into and then use to maintain my library and different sorts?


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Thu Jul 29, 2010 5:03 pm 
Offline
Super Duper Poster
Super Duper Poster

Joined: Wed May 18, 2005 10:03 pm
Posts: 2674
Location: Jersey
Been Liked: 160 times
KJ Pro is a simple to use karaoke songbook maker. Just click pn each disc that you own and the software does the rest


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Thu Jul 29, 2010 6:12 pm 
Offline
Super Poster
Super Poster
User avatar

Joined: Sun Jun 06, 2010 10:39 am
Posts: 884
Location: Tx
Been Liked: 17 times
That's a little more than I wanted to spend plus it looks like I'd have to pay for updates. I already have all of my songs in an excel spreadsheet, and don't mind adding them per disc as I buy them just trying to get a two column layout and easy sort without having to move my #A-Z breaks and re-arranging headings each time I add to it.

Maybe I should just create a mysql database and import my csv file. Then I could write a php script that will allow me to add my new stuff and then I could sort however and then just work on my output formatting.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Thu Jul 29, 2010 6:24 pm 
Online
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Sun Nov 27, 2005 11:31 am
Posts: 5404
Location: Watebrury, CT
Been Liked: 407 times
Fast Tracks is a great songbook program. Plus for a fee you get lifetime updates. The Basic costs$80. www.karaokeware.com

_________________
The Line Array Experiment is over. Nothing to see here. Move along.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Fri Jul 30, 2010 7:29 am 
Offline
Advanced Poster
Advanced Poster
User avatar

Joined: Thu Apr 10, 2008 2:12 pm
Posts: 299
Been Liked: 0 time
hiteck @ Thu Jul 29, 2010 8:12 pm wrote:
Maybe I should just create a mysql database and import my csv file. Then I could write a php script that will allow me to add my new stuff and then I could sort however and then just work on my output formatting.


Yes 100%. See an example of my books made exactly this way at.

www.classic-karaoke.com/pdfsongbook.php

I used the fpdf library and tweaked an example report to get it to do what I want. You can use GET parameters eg


www.classic-karaoke.com/pdfsongbook.php?order=song
www.classic-karaoke.com/pdfsongbook.php ... 4&rigs=2,1


- Jonn


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Fri Jul 30, 2010 7:47 am 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Mon May 28, 2007 10:11 am
Posts: 1832
Location: TX
Been Liked: 59 times
Although I don't use it Airwer will do what you want although it costs $100 for the program and all updates are free. All you have to do is check mark the discs you have and it will do the rest.


Can be found at www.airwer.com

_________________
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


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Fri Jul 30, 2010 8:08 am 
Offline
Super Poster
Super Poster

Joined: Fri Aug 28, 2009 10:42 pm
Posts: 1064
Been Liked: 92 times
I've used KJ Pro for a long time, through several version updates. Unfortunately, they don't seem to keep up on the updates anymore or else the software is getting so screwed up that the update part no long works properly for me. The basic program still works and has a lot of music in it already and you can manually update.

Next time I buy one, I'll get the Fast Tracks or whatever it is that works with Compuhost.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Fri Jul 30, 2010 8:15 am 
Offline
Super Duper Poster
Super Duper Poster

Joined: Wed May 18, 2005 10:03 pm
Posts: 2674
Location: Jersey
Been Liked: 160 times
BigJer @ July 30th 2010, 11:08 am wrote:
I've used KJ Pro for a long time, through several version updates. Unfortunately, they don't seem to keep up on the updates anymore or else the software is getting so screwed up that the update part no long works properly for me. The basic program still works and has a lot of music in it already and you can manually update.

Next time I buy one, I'll get the Fast Tracks or whatever it is that works with Compuhost.


Maybe you need to re install the program BigJer. Mine still works great...except for the numerous Sound Choice errors over the years. It seems like someone from Sound Choice would give KJ Pro the right songs but in the wrong order.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Fri Jul 30, 2010 8:46 am 
Offline
Extreme Poster
Extreme Poster
User avatar

Joined: Mon Dec 20, 2004 10:09 am
Posts: 3341
Location: Tampa Bay, FL
Been Liked: 445 times
Over the years, I have used Excel, the Airwer Songlist Creator, KJ Pro, and FastTracks.

KJ Pro is definitely the best pure songbook creator of the three.
I did not care for Airwer at all.
FastTracks is not as good as KJ Pro, but it integrates with CompuHost and CDGRip very very well. Basically, you enter your discs into FastTracks, burn the disc with CDGRip and it automatically names the tracks in the exact format CompuHost uses.

So, if you use CompuHost, get FastTracks. It will save you WEEKS of setup on your digital library. I think lifetime updates are only like $30.00 extra, but worth every penny.

If you do not use CompuHost, go with KJPro!!

I wouldn't buy the Airwer Songbook Creator, it just is not as robust as either of the other programs.

_________________
C Mc
KJ, FL


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Fri Jul 30, 2010 11:28 am 
Offline
Senior Poster
Senior Poster

Joined: Tue Apr 27, 2010 3:46 pm
Posts: 107
Been Liked: 11 times
After looking at alot of book programs and doing it myself with excel we went with Fast Tracks. I like it alot. You do not have to rip the discs, you can just click the disc and add. You can also export to csv file or import the csv file so there is less clicking to start. There are also several ways that you can print the book out.

I do the Fast Tracks then export and look at the listings. Do sortings all kinds of ways and fix ones that are wrong (i.e. song name, singer name, etc.). I fix it both in the program and in the file. Since I have put the cd+g's on the hard drive I will also fix the titles in that so that when I want to redo the book and start over with a new book I don't have to fix them all over again. (does that make sense?) The program itself isn't really to blame for the wrong listings, since it's the manu that gives that info.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Sun Aug 01, 2010 2:22 pm 
Offline
Extreme Poster
Extreme Poster
User avatar

Joined: Sun Jul 30, 2006 7:24 pm
Posts: 4466
Been Liked: 1052 times
I also use FastTracks. It is awesome. Probably the best. And if you have CompuHost, the integration is seemless. A great combination but either one can be used alone.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Aug 02, 2010 8:16 am 
Offline
Super Duper Poster
Super Duper Poster

Joined: Fri Jun 18, 2010 11:16 pm
Posts: 2027
Location: HIgh River, AB
Been Liked: 268 times
I also use fastracks. Out of all the software I have used, it is the easiest. My only complaint is there aren't enought editing features. I mean how hard could it be to program to be able to select multiple items, even for something as simple as pushing the delete key. *sigh*


-James


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Aug 02, 2010 8:41 am 
Online
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Sun Nov 27, 2005 11:31 am
Posts: 5404
Location: Watebrury, CT
Been Liked: 407 times
jclaydon @ Mon Aug 02, 2010 11:16 am wrote:
I also use fastracks. Out of all the software I have used, it is the easiest. My only complaint is there aren't enought editing features. I mean how hard could it be to program to be able to select multiple items, even for something as simple as pushing the delete key. *sigh*


-James


Do you mean to edit a field. They have that right click on the item you want to change and go to multiedit.

_________________
The Line Array Experiment is over. Nothing to see here. Move along.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Aug 02, 2010 8:47 pm 
Offline
Super Duper Poster
Super Duper Poster

Joined: Fri Jun 18, 2010 11:16 pm
Posts: 2027
Location: HIgh River, AB
Been Liked: 268 times
DannyG2006 @ Mon Aug 02, 2010 8:41 am wrote:
jclaydon @ Mon Aug 02, 2010 11:16 am wrote:
I also use fastracks. Out of all the software I have used, it is the easiest. My only complaint is there aren't enought editing features. I mean how hard could it be to program to be able to select multiple items, even for something as simple as pushing the delete key. *sigh*


-James


Do you mean to edit a field. They have that right click on the item you want to change and go to multiedit.


No, I am talking about things like deleting multiple tracks. Or being able to edit ONLY the selected tracks instead of ALL of the tracks that match the search criteria. The "multi-edit" feature has a limited use, in my opinion.


The weird thing is I can't seem to remember what exactly I was trying to do where the function wouldn't work.

edit:I just remembered I was trying to change the "genre" settings for about 300 tracks, which I had to do one disc at a time.. PITA!


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Tue Aug 03, 2010 1:49 am 
Offline
Super Poster
Super Poster
User avatar

Joined: Tue May 10, 2005 3:42 pm
Posts: 1395
Location: Silicon Valley, CA
Been Liked: 0 time
jclaydon @ Mon Aug 02, 2010 8:47 pm wrote:
DannyG2006 @ Mon Aug 02, 2010 8:41 am wrote:
jclaydon @ Mon Aug 02, 2010 11:16 am wrote:
I also use fastracks. Out of all the software I have used, it is the easiest. My only complaint is there aren't enought editing features. I mean how hard could it be to program to be able to select multiple items, even for something as simple as pushing the delete key. *sigh*


-James


Do you mean to edit a field. They have that right click on the item you want to change and go to multiedit.


No, I am talking about things like deleting multiple tracks. Or being able to edit ONLY the selected tracks instead of ALL of the tracks that match the search criteria. The "multi-edit" feature has a limited use, in my opinion.


The weird thing is I can't seem to remember what exactly I was trying to do where the function wouldn't work.

edit:I just remembered I was trying to change the "genre" settings for about 300 tracks, which I had to do one disc at a time.. PITA!


I totally agree with you. Love using the Fasttrack but that is one major short coming. All they need to do is to allow control click to select multiple songs and change one field on all the songs. It would be so huge time saver if they allowed that.

_________________

Seize the day and SING!!!

Image



Top
 Profile Singer's Showcase Profile 
 
PostPosted: Tue Aug 03, 2010 10:40 am 
Offline
Senior Poster
Senior Poster
User avatar

Joined: Thu Aug 13, 2009 11:03 am
Posts: 136
Been Liked: 1 time
Try Pilot Song Book Creator. If you like it, it's only $39. You can import from your song files, CSV, or from discs. You can format anyway you want. There are a host of print out formats. It will even allow you to synchronize the song names of the files with the song names in the program such as if you globally change all "The's" to ", The" and the end.

Check out the free demo. You can find the link on my blog:
http://www.nwohiokaraoke.blogspot.com

_________________
Join Us on Facebook!
NW Ohio Karaoke


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Tue Aug 03, 2010 10:57 am 
Offline
Advanced Poster
Advanced Poster

Joined: Mon Aug 02, 2010 11:02 am
Posts: 485
Location: third stone from the sun
Been Liked: 2 times
I like KJPro.. it makes nice looking books, and is easy to use.

Great for quickly building a book for an existing collection, and easy to add new discs.

You don't really need to buy the future updates, either.. you can always manually enter new discs as you get them.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Tue Aug 03, 2010 4:56 pm 
Offline
Extreme Poster
Extreme Poster

Joined: Thu Jun 06, 2002 7:26 am
Posts: 4839
Location: In your head rent-free
Been Liked: 582 times
Books?..... c'mon it's 2010.... get with the program....

use a kiosk and get rid of books....

I haven't used a printed paper book in 6 years...

(kills muchn fewer trees you know.)


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Tue Aug 03, 2010 5:38 pm 
Offline
Super Poster
Super Poster
User avatar

Joined: Sun Jun 06, 2010 10:39 am
Posts: 884
Location: Tx
Been Liked: 17 times
c. staley @ Tue Aug 03, 2010 6:56 pm wrote:
Books?..... c'mon it's 2010.... get with the program....

use a kiosk and get rid of books....

I haven't used a printed paper book in 6 years...

(kills muchn fewer trees you know.)


My request for a better way was for my home use....I'm still using a dual CDG player and CDG's so I don't see spending the money on a kiosk. I'm only doing one book so not really having that much effect on the environment, I'm just looking for a better way to organize my selections for private/family fun.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Wed Aug 04, 2010 4:03 am 
Offline
Senior Poster
Senior Poster
User avatar

Joined: Thu Aug 13, 2009 11:03 am
Posts: 136
Been Liked: 1 time
For home use, use Excel and sort by whatever column you want. Will print out pretty well. If you have Access, you could use that too and maybe find a few better printouts. Otherwise, Excel it the way to go for home use.

I didn't see where you mentioned how many discs you had. You can cut and paste info for the discs from most website lists to add to your database.

_________________
Join Us on Facebook!
NW Ohio Karaoke


Top
 Profile Singer's Showcase Profile 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 28 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 582 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Powered by phpBB® Forum Software © phpBB Group

Privacy Policy | Anti-Spam Policy | Acceptable Use Policy Copyright © Karaoke Scene Magazine
design & hosting by Cross Web Tech