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]
Login
Register
FAQ
Search
