| Karaoke Scene's Karaoke Forums https://mail.karaokescene.net/forums/ |
|
| Best songbook software - Question for the PRO's https://mail.karaokescene.net/forums/viewtopic.php?f=1&t=4362 |
Page 1 of 1 |
| Author: | kjbill [ Thu Mar 03, 2005 6:42 am ] |
| Post subject: | Best songbook software - Question for the PRO's |
Hello Folks! Which one of these is the best songbook software? Which one do you recommend? No subscription fee on this one: airwer musicbookdeluxe kjpro Cheers! |
|
| Author: | karaokemeister [ Thu Mar 03, 2005 8:24 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
I've tried the trial on most songbook software and I've yet to find one that corrects mistakes or sychronizes the artists/songs to match. I use Excel for now (will move to access soon enough) to insure the artist is always spelled the same way and if a song is released by mutiple artists it's has the same spelling throughout as well. Can't give you any more feedback than this though... I only used the trial on 3-4 different books and never bought or subscribed - mainly because of the shortcomings I saw. |
|
| Author: | Lonman [ Thu Mar 03, 2005 9:54 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
I use Microsoft Access. Typed everything in by hand - which also helped me know what I have as well. |
|
| Author: | kjbill [ Thu Mar 03, 2005 10:46 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
So, it seems that Microsoft Access is the way to go so far. I guess that advange of having one of these programs is that everything is already typed in for you. Can you bring in a Microsoft Excel file into Access? |
|
| Author: | Lonman [ Thu Mar 03, 2005 11:18 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
kjbill @ Thu Mar 03, 2005 10:46 am wrote: So, it seems that Microsoft Access is the way to go so far.
I guess that advange of having one of these programs is that everything is already typed in for you. Can you bring in a Microsoft Excel file into Access? Don't know if you can open an Excel file in Access - never tried, but you can copy the info & paste into a blank database & go from there. You view my books through my website. Hit the karaoke page & then the drop down menu. Click on T-Bird book. Halfway down from there are a couple pdf files one of artist & one of title. These were both from an Access report - fully customizeable I might add. |
|
| Author: | kjbill [ Thu Mar 03, 2005 12:14 pm ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
Hi Lonman, Nice website! Thanks for the info. I will look into Excel and Access. . |
|
| Author: | EElvis [ Thu Mar 03, 2005 1:01 pm ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
You can import an excel file into access. I use kjpro, and access\excel quite frequently. No songbook on the market will be 100% correct. if you are looking for that you might as well stop. I find that most of them are about 90-95% correct, and that in itself is a timesaver, and worth the price. The hosting software I use creates my songbooks for me so I really don't need to use it. My wife uses kjpro, and access\excel to create songbooks for other kj's in the area. |
|
| Author: | kjbill [ Thu Mar 03, 2005 1:24 pm ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
Hi Dr. D. Thanks for your reply! What is your "hosting software"? KJPRO? |
|
| Author: | karaokemeister [ Thu Mar 03, 2005 4:40 pm ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
You can take an Excel spreadsheet into Access without any problems using the import features. Unless you want to try and do fancy reporting or something similar Excel will handle your books until you get over 60,000 songs though. Admittedly I have just under 4000 songs but Excel works wonderfully thus far. I'm planning my move to Access now so I can do my books a little differently though and keep track of some extended information for tax purposes (date purchased, where, etc). Currently in my spreadsheet I duplicate my artists column to get my books the way I want. Much like this... Artist|song|Artist|Volume|track I hide the second artist column, sort on artist, song, volume and print to get a line that starts with artists and is in order. I then unhide the second artist and hide the first, resort on Song, Artist, Volume to get the second half of my book. That way what ever is the main sort key is first in the book making it a little easier to find. |
|
| Author: | marley rules [ Thu Mar 03, 2005 6:19 pm ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
I have used Airwer Song List creator and I am not impressed. While it is easy to choose discs and export the listing over to excel, it does have an inordinate amount of errors. Also, they have this nasty habit of providing you a password for database updates and then changing the password. You then have to send them an email and wait for them to respond with a new password to access the updates. I have no problem with them changing passwords for updates, but they should be proactive and send an email to all registered users. Sorry for venting. |
|
| Author: | Plug Your Ears [ Tue Mar 08, 2005 8:39 pm ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
Aloha Everyone, I have been working this songbook issue on my own for quite sometime now and have come up with several methods. I first use sax n dotty to scan my karaoke folder, I then use the Sax N Dotty songlist.mdb and import it into Access, now I can manipulate the data in several different ways and exportable to any office format or CSV. This method is based on what you actually have on your hard drives and not what is listed in Kjpro database or any other database. How to import into Access: 1. Create a new Access database 2. Go to file menu, and then import, browse for the sax n dotty folder and import songlist.mdb, A box will pop up and select KaraokeTracks only. (You can select all, but you really only need the KaraokeTracks, import all and learn Access!) 3. Mission Complete Want to delete the duplicates in Access for printing under Kjpro? 1. Delete the following rows in KaraokeTracks table view then close. SongID, DiscName, TrackNo, TrackPath, Notes, Kamikaze, Error 2. Now there is two columns: ArtistName and TrackName 3. Right click KaraokeTracks and select copy 4. Then click the white, now right click and select Paste 5. Select structure only and name it copy. 6. Now click copy and select design view 7. Now select both ArtistName and TrackName (Cntrl A, Edit-Select All, Shift Button and click both) You Got It? 8. Now there is a key in the tool bar about half way through it, click it (it is right next to a lightning bolt and hard to see) 9. Both those ArtistName and TrackName should now have key in the L/H box. 10. Close it and select save (you can open it up and there should be nothing in it if you want to check otherwise lets drive on) 11. Select Queries now and now create query by wizard, Select table: KaraokeTracks and select both ArtistName and TrackName into the right box. Click next and finish; now you will have a query called KaraokeTracks Query. 12. Highlight it now and click design view, now on the tool bar there is a drop down box with a two box icon on it (left of the RED!) Select Append Query (has a Green +! next to it. A box pops up now select append to copy and click ok 13. Now you’re at the Queries screen, click what you just created, box pops up click yes, another pops up with the number of songs you have, click yes, the last box pops up and click yes. (that’s three yes’s) (Mine goes from 59,000 plus down to 21,000) 14. Once completed go to table screen and double click the copy table , that is the list of every song that is currently on your drives with no duplicates. Now remember that access is a database, so naming of files is important. If you have a song/artist on there twice they are not spelled the same way. There is a file checker that will rename files fast, I live by it. Download it here or email me and I will send 394kbs http://www.xs4all.nl/~franckey/franckey/software/ be careful and pay attention otherwise it will name some files for you. This program is simple to use and in another class. 15. I sorted my Access by artist and checked for spelling and then song for standard naming practices Now importing into KJPRO. 1. Figure what table you want to export (copy table for singles karaoke tracks for all), open it up and on the file menu select export and on the save as menu select Microsoft Office 97-2002. Name it whatever and select a folder you can find later. I save to the Kjpro folder. 2. now find the file and open it up in excel and make the following changes Insert row before ArtistName and now cut and paste 'TrackName into it 3. Rename first row titles to match these below Title Artist Manu DiscNo TrackNo 4. this is key into importing into Kjpro 5. From Kjpro website now: 6. How can I import songs from Excel? The Excel Import button doesn't work. 7. An easy alternative method for importing songs from Excel is with "Copy" and "Paste Append". Here's how: 8. 1. Set up your Excel spreadsheet so the songs have the following column headings: 9. Title Artist Manu DiscNo TrackNo 10. (Note: If you've exported a songbook from KJ Pro, it will have a column called "Description". Rename this column to "Manu". If there is already a column called "Manu" in addition to the Description column, delete the "Manu" column and rename "Description" to "Manu". Sorry, this is a quirk in the program.) 11. 2. Select the range of songs you want to copy, including the column headings in your selection. (KJ Pro needs these to match up with the fields in the program.) Use "Control+C" to copy them to the Windows clipboard (or "Edit" - "Copy"). 12. 3. Open KJ Pro and open the custom songbook you want to copy the songs to by clicking "View/Filter" under Custom Songbooks. Select your custom songbook from the drop-down box. Then click on the "Add Songs" button on top of the window. 13. 4. Click the "Paste Append" button on top of the Window. Your Excel songs should be pasted from the Windows clipboard into your custom songbook. Good Luck! Devon Did any of that make since??[/code] |
|
| Author: | kjgreg [ Wed Mar 09, 2005 3:46 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
So far I have been using Music book deluxe and have been happy. Haven't had any problems this the software. maybe not as customizable as what some use. Most KJ's in our area are using it. |
|
| Author: | kjbill [ Wed Mar 09, 2005 6:42 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
Aloha Devon! Thanks for the info. This is a good way to go. |
|
| Author: | karyoker [ Wed Mar 09, 2005 8:35 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
Right now I'm in the process of printing books again ( after 5 ran out of toner ) The S&D method is the best way Ive found yet I paid for Airwer and Kjpro both. Basically use the same method as Hawaii but I no longer think in terms of cd's and numbers, have artist and title only. No lookin in books for numbers.. First response is but I have songs in 2 or more brands. Here is wat I do Just spent god knows how many hours moving duplicates into a seperate folder. For example I have Picture in Soundchoice and Top Hits Monthly. Most prefer THP so in my zipped folder which is the db for S&D is Crow, Sheyl & Kid Rock - Picture(THM).zip... The (THM) is a flag that there is a different version in the Dups folder... In S&D go to file view browse to to Dups folder and que... I used to do a data base for the new songs list and print from excel now I'm lazy and keep a new folder with new ones and use the cue and txt function in Mp3GToolz and print the list from Notepad... A new cd is ripped into this folder, named the way I want, zipped, copied into the main folder (next book printing is alreadyupdated).. and another quick print with Toolzs and Notepad.... It is possible to use the txt feature in Toolz for the main folder and result is a txt file that is only about 500kb however it is only a list does anybody know how to import this into excel for a viable printing format? |
|
| Author: | Plug Your Ears [ Wed Mar 09, 2005 11:56 am ] |
| Post subject: | Re: Best songbook software - Question for the PRO's |
Copy and Paste from notebook into Excel, then highlight column A then under data toolbar use the text to columns method. And pick and choose. Should get it for you. I printed a list as you talked about regarding just artist and title through KJpro through custom song book method. works like a champ and you have all those options under their print books. Send me the file and i will try and imort into excel for you if you have problems. Aloha, Devon |
|
| Page 1 of 1 | All times are UTC - 8 hours |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|